1.11M Members

unexpected T_STRING

 
0
 

hi,
I am getting this error:
Parse error: syntax error, unexpected T_STRING in C:\xampp\htdocs\makedatabase.php on line 2

here is the code:

<?php
CREATE USER("jeffrey"@"localhost", IDENTIFIED BY "mypass");
$con = mysql_connect("localhost" ,"jeffrey","mypass");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}

mysql_close($con);
?>

I am a beginner in PHP please explain what I am doing wrong. the code above is coming from a tutorial but it does not want to work for me!

 
0
 
CREATE USER("jeffrey"@"localhost", IDENTIFIED BY "mypass");

Is the problem. You cannot just use a mysql query in php and expect it to work. That line should be removed. You have to execute it in your mysql console, or phpmyadmin, or whatever you prefer to use.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: