mattz84
-
Posts
3 -
Joined
-
Last visited
Posts posted by mattz84
-
-
Sure.
Here is the connect.php file:
<?php
DEFINE ('DB_USER','root');
DEFINE ('DB_PASSWORD','2f8ks32d');
DEFINE ('DB_HOST','localhost');
DEFINE ('DB_NAME','phpbook');
$dbc = mysqli_connect(DB_HOST, DB_USER, DB_PASSWORD, DB_NAME) OR die('Could not connect' . mysqli_connect_error());
mysqli_set_charset($dbc, 'utf8');
?>And here is part of the register.php page:
if(empty($errors)){
require('http://localhost/PHP/chp8/connect.php');
$q = "INSERT INTO users (user_id, first_name, last_name, email, pass, registration_date) VALUES (0,'$fn', '$ln', '$e', SHA1('$p'), NOW())";
$r = mysqli_query($dbc, $q);
if($r){
echo '<h1>Thank you!</h1>';
echo '<p>You are now registered</p>';
} else{
echo '<h1>System Error</h1>
<p>You could not register due to a system error.</p>';
echo '<p>' . mysqli_error($dbc) . '<br>' . 'Query:' . $q . '</p>';
}
mysqli_close($dbc);
} else{
echo '<h1>Error(s)</h1>';
foreach($errors as $msg){
echo '<span class="error"> -'. $msg . '</span><br>';
}
}I just noticed, if I change the URL in the require('http://localhost/PHP/chp8/connect.php');
to: require('connect.php');
It works!
I don't understand why it wouldn't work with an absolute URL...?
Thank you for the reply.
-
I'm having a strange problem here. I created the registration.php and connect.php files, but I cannot seem to add the info entered into the form to the SQL table, unless I have the $dbc constants inside the register.php file.
Originally, I was using the require() function to pull in the SQL connect file. But I keep getting the "System Error You could not register due to a system error." message when I submit the form.
I did several tests to try find out where the problem is and I believe it has something to do with the constants not being able to be used in the require() and include() functions. Also, I found if I copy the contents in the connect.php file into the register.php, it works.
I checked my php.ini file, both allow_url_fopen and allow_url_include are on. So I'm not sure why I can't include/require constants in my PHP files. Also, when I used the require() function I was using an absolute URL path to the connect.php file. Any ideas?
Thanks!
Chp 9 Executing Simple Queries - Sql Connect File Constants
in PHP for the Web: Visual QuickStart Guide (4th Edition)
Posted
Got it. Thanks!