July 29, 201313 yr Hey guys, so I've started learning some PHP at last and I can't seem to connect to the database, getting really odd error, code seems fine to me? (Only following a simple tutorial, error I'm getting is as follows:) Parse error: syntax error, unexpected T_STRING in /home/palmer/public_html/demo.php on line 4 PHP: <?php define('DB_NAME', 'forms1'); define('DB_USER', 'palmer_adventure'); define('DB_PASSWORD', 'test'); define('DB_HOST', localhost'); $link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db(DB_NAME, $link); if (!$db_selected) { die('Can\'t use ' . DB_NAME . ': ' . mysql_error()); } echo 'Connected Sucesfully'; mysql_close(); ?> Edited July 29, 201313 yr by Crispy
July 29, 201313 yr Author I just tried this code also lol (also tried moving all code off line 4 and still said it doesn't like line 4!!) <?php $db_hostname = 'localhost'; $db_database = 'forms1'; $db_username = 'root'; $db_password = ''; $link = mysql_connect($db_hostname, $db_username, $db_password); if (!$link) { die('Could not connect: ' . mysql_error()); } $db_selected = mysql_select_db($db_database, $link); if (!$db_selected) { die('Can\'t use ' . DB_NAME . ': ' . mysql_error()); } echo 'Connected Sucesfully'; mysql_close(); ?>
July 29, 201313 yr I'd guess at the first code you posted this line define('DB_HOST', localhost'); is missing an apostrophe before localhost define('DB_HOST',' localhost');
July 29, 201313 yr Author Thanks for the help guys, I've signed up for Treehouse so I'm going to learn a load more before diving in I think!
Create an account or sign in to comment