954,580 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

unexpected T_STRING

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!

asghar123
Newbie Poster
1 post since Dec 2011
Reputation Points: 10
Solved Threads: 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.

pritaeas
Posting Expert
Moderator
5,483 posts since Jul 2006
Reputation Points: 653
Solved Threads: 875
 

This article has been dead for over three months

Post: Markdown Syntax: Formatting Help
You
View similar articles that have also been tagged: