Jump to content
Larry Ullman's Book Forums

Recommended Posts

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 post
Share on other sites

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 post
Share on other sites

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 by amateurgeek
Link to post
Share on other sites

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 post
Share on other sites
  • 3 weeks later...

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...