SledgeDB

I am thinking of abandoning Php / My SQL and moving forward with Django, Python, Mongo! Django Web framework provides all the user authentication and more. There are no SQL injection problems with MongoDB. I already know both some Python and I know some MongoDB.

Please email me the initial code that you are using above to Frank@SledgeDB.com i.e. (I just downloaded the script from the site and ran it again, unedited. Here is the initial load). I do understand that most technical book writers do not have working code in their books. I understand that most code snipping in books is for illustration purposes only. It would be too cumbersome to include the details of every variable, every flag, every include, every function, etc in code that is designed to illustration how to code. As you know, a single program can contain as many lines of code as all 300+ pages of your book(s).

Please email me the initial code that you are using above to Frank@SledgeDB.com i.e. (I just downloaded the script from the site and ran it again, unedited. Here is the initial load). I do understand that most technical book writers do not have working code in their books. I understand that most code snipping in books is for illustration purposes only. It would be too cumbersome to include the details of every variable, every flag, every include, every function, etc in code that is designed to illustration how to code. As you know, a single program can contain as many lines of code as all 300+ pages of your book(s).

Please email me the initial code that you are using above to Frank@SledgeDB.com i.e. (I just downloaded the script from the site and ran it again, unedited. Here is the initial load).

I did remove line 10 and it works and once I fill in the form that inserts into the database with no problems. But if I fill in the form again with an empty field, I get errors. The code book does not work! Thank you

Larry this is the code from your book/your website. Are you sure the code actually works? I Downloaded it from the companion Website LarryUllman.com. Maybe you could email you version of this code on page 277in script 9.3 that works for Frank@SledgeDB.com. Thank you.

This code is actually the exact code from the book. I only change the path of the header and footer to point to the correct directory. <?php # Script 9.3 - register.php // This script performs an INSERT query to add a record to the users table. $page_title = 'Register'; include('header.html'); // Check for form submission: if ($_SERVER['REQUEST_METHOD'] == 'POST') { $errors = []; // 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('../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', SHA2('$p', 512), 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 12 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="email" name="email" size="20" maxlength="60" value="<?php if (isset($_POST['email'])) echo $_POST['email']; ?>" > </p> <p>Password: <input type="password" name="pass1" size="10" maxlength="20" value="<?php if (isset($_POST['pass1'])) echo $_POST['pass1']; ?>" ></p> <p>Confirm Password: <input type="password" name="pass2" size="10" maxlength="20" value="<?php if (isset($_POST['pass2'])) echo $_POST['pass2']; ?>" ></p> <p><input type="submit" name="submit" value="Register"></p> </form> <?php include('footer.html'); ?>

Parse error: syntax error, unexpected '[' in /data/6/0/142/65/468717/user/register.php on line 10 This code is in script 9.3, page 277, line 10 The book is Visual QuickPro Guide PHP and MySQL for Dynamic Web Sites