Jump to content
Larry Ullman's Book Forums


  • Posts

  • Joined

  • Last visited

michaelli321's Achievements


Newbie (1/14)



  1. I was just on Chapter 13, and it seems the whole chapter has to do with patterns, and matching them. I do not see any point in this. Could anybody give me an example of when this information would be needed?
  2. Yes, my database name is sitename and the only table in it is users. What would my database host be then? I created my michaelli321 user using 'michaelli321'@'localhost'. Would my database host be the hosting service for my website? My MySQL doesn't have any connections to my website, only my PHP scripts.
  3. Also, you guys can look at everything on these links: www.tagslash.com/register.php www.tagslash.com/includes/mysqli_connect.php www.tagslash.com/includes/mysqli1_connect.php (this page uses the script from earlier in the forum) www.tagslash.com/phpinfo.php The register.php script is using the mysqli_connect.php script. Here are the scripts: register.php: <?php # Script 8.3 - register.php $page_title = 'Register'; include ('includes/header.html'); // Check if the form has been submitted: if (isset($_POST['submitted'])) { $errors = array(); // Initialize an error array. // Check for a first name: if (empty($_POST['first_name'])) { $errors[] = 'You forgot to enter your first name.'; } else { $fn = trim($_POST['first_name']); } // Check for a last name: if (empty($_POST['last_name'])) { $errors[] = 'You forgot to enter your last name.'; } else { $ln = trim($_POST['last_name']); } // Check for an email address: if (empty($_POST['email'])) { $errors[] = 'You forgot to enter your email address.'; } else { $e = trim($_POST['email']); } // Check for a password and match against the confirmed password: if (!empty($_POST['pass1'])) { if ($_POST['pass1'] != $_POST['pass2']) { $errors[] = 'Your password did not match the confirmed password.'; } else { $p = trim($_POST['pass1']); } } else { $errors[] = 'You forgot to enter your password.'; } if (empty($errors)) { // If everything's OK. // Register the user in the database... require_once ('includes/mysqli_connect.php'); // Connect to the db. // Make the query: $q = "INSERT INTO users (first_name, last_name, email, pass, registration_date) VALUES ('$fn', '$ln', '$e', SHA1('$p'), NOW() )"; $r = @mysqli_query ($dbc, $q); // Run the query. if ($r) { // If it ran OK. // Print a message: echo '<h1>Thank you!</h1> <p>You are now registered. In Chapter 11 you will actually be able to log in!</p><p><br /></p>'; } else { // If it did not run OK. // Public message: echo '<h1>System Error</h1> <p class="error">You could not be registered due to a system error. We apologize for any inconvenience.</p>'; // Debugging message: echo '<p>' . mysqli_error($dbc) . '<br /><br />Query: ' . $q . '</p>'; } // End of if ($r) IF. mysqli_close($dbc); // Close the database connection. // Include the footer and quit the script: include ('includes/footer.html'); exit(); } else { // Report the errors. echo '<h1>Error!</h1> <p class="error">The following error(s) occurred:<br />'; foreach ($errors as $msg) { // Print each error. echo " - $msg<br />\n"; } echo '</p><p>Please try again.</p><p><br /></p>'; } // End of if (empty($errors)) IF. } // End of the main Submit conditional. ?> <h1>Register</h1> <form action="register.php" method="post"> <p>First Name: <input type="text" name="first_name" size="15" maxlength="20" value="<?php if (isset($_POST['first_name'])) echo $_POST['first_name']; ?>" /></p> <p>Last Name: <input type="text" name="last_name" size="15" maxlength="40" value="<?php if (isset($_POST['last_name'])) echo $_POST['last_name']; ?>" /></p> <p>Email Address: <input type="text" name="email" size="20" maxlength="80" value="<?php if (isset($_POST['email'])) echo $_POST['email']; ?>" /> </p> <p>Password: <input type="password" name="pass1" size="10" maxlength="20" /></p> <p>Confirm Password: <input type="password" name="pass2" size="10" maxlength="20" /></p> <p><input type="submit" name="submit" value="Register" /></p> <input type="hidden" name="submitted" value="TRUE" /> </form> <?php include ('includes/footer.html'); ?> mysqli_connect.php: <?php # Script 8.2 - mysqli_connect.php // This file contains the database access information. // This file also establishes a connection to MySQL // and selects the database. // Set the database access information as constants: DEFINE ('DB_USER', 'michaelli321'); DEFINE ('DB_PASSWORD', ''); 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: ' . mysqli_connect_error() ); ?> mysqli_connect1.php: <?php $link = mysql_connect('localhost', 'michaelli321', 'password'); if (!$link) { die('Could not connect: ' . mysql_error()); } echo 'Connected successfully'; mysql_close($link); ?>
  4. Yes, I've tried all of that and it still isn't working. The same errors come up on the mysqli_connect.php script itself, and I am running PHP 5.
  5. I created a new user, but I'm still getting the same errors. The new user has all the privileges the root user has, and can do anything the root user can do. Not sure what else to do.
  6. I'm still getting problems. From the book's script, I got Fatal error: Call to undefined function mysqli_connect() in C:\Inetpub\vhosts\tagslash.com\httpdocs\includes\mysqli_connect.php on line 14 AND From the code given earlier in the forum, I got Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: YES) in C:\Inetpub\vhosts\tagslash.com\httpdocs\includes\mysqli_connect1.php on line 2 Could not connect: Access denied for user 'root'@'localhost' (using password: YES) (but my password and username are correct)
  7. Yes I tried to search it, and nothing came up. I have Windows 7. I downloaded PHP earlier before I downloaded XAMPP and then I deleted PHP when I got XAMPP. Does that have anything to do with it? but even then, I didn't have those folders. The PHP folder was on my desktop.
  8. My php.ini file is locates in C:\xampp\php\php.ini on the phpinfo page it says it is in C:\Windows. Also on the Loaded Configuration File section, it says that it is in C:\Parallels\Plesk\Additional\PleskPHP5\php.ini but I do not have a Parallels folder on my computer.
  9. I use the same password for everything, and I checked the letters and they were all correct, and "root" was spelled correctly. I also used the password to access MySQL and it worked. How do I know what the active configuration file is?
  10. I checked the username and password, and both were correct. I also found that on my phpinfo() page, it says the Configuration File (php.ini) Path is C:\Windows when it is not located there. So I think that php knows where the php.ini file is.
  11. I searched it online and I learned that it meant that my root-user and password were incorrect, but I checked them and they were both right. If I'm using the root user, is the username "root" or "root-user"?
  • Create New...