amateurgeek Posted December 21, 2016 Share Posted December 21, 2016 To Larry or some one else that can help me to resolve this error message: I am using XAMPP panel to test the PHP files for this book. However, I try to run script 9.2 and got this error message: Parse error: syntax error, unexpected 'DEFINE' (T_STRING) in C:\xampp\htdocs\mysqli_connect.php on line 5 Here is the code that I used: <?php #Script 9.2 mysqli_connect.php //Set the database access information as constants: DEFINE ('DB_USER', 'root'); DEFINE ('DB_PASSWORD', 'mypass1'); DEFINE ('DB_HOST', 'localhost'); DEFINE ('DB_NAME', 'sitename'); //Make the connection: $dbc = @mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die ('Could not connect to MySQL: ' . mysql_connect_error()); //Set the encoding: mysqli_set_charset($dbc, 'utf8'); ?> I also tried to use these authentication for mysqli_test.php script , and they just worked fine. Link to comment Share on other sites More sharing options...
Larry Posted December 21, 2016 Share Posted December 21, 2016 So you just have a run-of-the-mill parse error, specifically on line 5 of C:\xampp\htdocs\mysqli_connect.php I'm not seeing it in the code you pasted, however. Are you sure that's the actual contents of C:\xampp\htdocs\mysqli_connect.php? Link to comment Share on other sites More sharing options...
amateurgeek Posted December 27, 2016 Author Share Posted December 27, 2016 (edited) Thanks for your reply Larry. I can fix the parse-error now. But another problem arise like this when I set the utf8 encoding for MySQL: Warning: mysqli_set_charset() expects parameter 1 to be mysqli, resource given in C:\xampp\htdocs\mysqli_connect.php on line 13 Line 13 in my Notepad++ is like this: mysqli_set_charset($dbc, 'utf8'); Another question I'd like to ask you or someone else if there is any way I can capture the screenshot and paste it directly into this post. I tried to use several Web browsers and even enable some security settings of Internet Explorer to allow a website to access the clipboard, but those tricks don't work for me. Hope somebody can tell me what to do with the paste feature in this forum so that it will be easier for me to explain my PHP errors by using the screenshot. Thanks again for your time to view my post. Edited December 27, 2016 by amateurgeek Link to comment Share on other sites More sharing options...
Larry Posted December 31, 2016 Share Posted December 31, 2016 So that error means your mysqli_connect() function call is not returning a database connection. I'd check on that error to see the cause. For security and spam purposes, I've disabled including images in the forums, but if images are the best route, you could put them on a hosted service and then link to it. Link to comment Share on other sites More sharing options...
Max Posted January 20, 2017 Share Posted January 20, 2017 You can highlight the screen text and paste it here e.g.: Back to PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition) · Next Unread Topic → Reply to this topic My Media Link to comment Share on other sites More sharing options...
Recommended Posts