Search the Community
Showing results for tags 'mysqli_connect'.
-
Hi, As in page 286-288, once I add... require ('../mysqli_connect.php'); myslie_close($dbc); in line 10 and 87, respectively, and register a user from Register.php, I get 4 notices: Notice: Constant DB_USER already defined in C:\XAMPP\mysqli_connect.php on line 7 Notice: Constant DB_PASSWORD already defined in C:\XAMPP\mysqli_connect.php on line 8 Notice: Constant DB_HOST already defined in C:\XAMPP\mysqli_connect.php on line 9 Notice: Constant DB_NAME already defined in C:\XAMPP\mysqli_connect.php on line 10 Is this the correct notices that I forgot somewhere to let it ignore showing on the web, or something was not correctly written either in register.php or mysqli_connect.php? Thx in advance.
-
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.
- 4 replies
-
- mysqli_connect
- connection to mysql
-
(and 1 more)
Tagged with:
-
I am trying to create a form that includes two drop-down select menus that each display records from their respective table from a database. Each drop-down menu uses the require statement to call my mysqli_connect script as does the overall form when it is called to insert the records, making 3 total require statements. When I tested the page it worked on the testing server but now I receive Constant DB_NAME, DB_HOST, DB_PASSWORD, and DB_USER already defined errors now that the site is live. I have tried using require_once on one, two , or all three calls instead of require but then one of my drop-down menus stops working and seem to get the same message. Any help would be appreciated.
- 2 replies
-
- mysqli_connect
- errors
-
(and 2 more)
Tagged with: