php DSN-less connection trouble

[jakeisstoked]

Hi,
I'm trying to connet to a MySQL database using a dsn-less connection and I keep getting the following error:

Parse error, syntax_error, unexpected T_VARIABLE in C:\Inetpub\

http://wwwroot\test.php

on Line 10


This is how my connection looks:
********************************************
<?PHP
$conn = "DRIVER={MySQL};\
SERVER=localhost;\
DATABASE=test;\
USER=root;\
PASSWORD=xxx;\
OPTION=3;"

$conn->open($conn);

?>
********************************************

Is my code wrong?
-Jake

 

[andreas57]

i'm not 100% sure but to use "$conn->open" $conn would have to be a class width the function open and the variables would have to be seperated width ",". it looks more like as asp-script and not php.

andreas owen
aowen@swissonline.ch

 

[DRJ478]

The parse error is due to the fact that the line which defines $conn is not ended with a semicolon:

<?PHP
    $conn = "DRIVER={MySQL};\     
             SERVER=localhost;\
             DATABASE=test;\
             USER=root;\
             PASSWORD=xxx;\
             OPTION=3;"[b][COLOR=red];[/color][/b]

    $conn->open($conn);
 
?>

 

[jakeisstoked]

<?PHP
$conn = "DRIVER={MySQL};\
SERVER=localhost;\
DATABASE=test;\
USER=root;\
PASSWORD=xxx;\
OPTION=3;";

$conn->open($conn);

?>

Thanks, I missed that, it has another error now:
"Fatal Error: Call to member function on a non-object in C:\Inetpub\

http://wwwroot\test.php

on Line 9", but I'm pretty sure it is to do with my PHP/MySQL setup, not the syntax. Thanks again.

 

[ingresman]

$conn is not an object, it's a string.
Why do you want to connect to mysql this way from php ?

 

[DRJ478]

DSN-less connections arer a concept that comes from MS Excel, MS Query etc. It has nothing in common with the way how PHP connects to a MySQL server.
PHP needs something like this:

<?php
$host = 'localhost';
$user = 'myUser';
$pass = 'whateverPass';
$resourceLink = mysql_connect($host,$user,$pass) OR die("Cannot connect:".mysql_error());
# .. etc...

The fact that PHP runs on Windows Systems does not mean that MS program like connections can be made.