RE: [PHP] Authentication

Kath, Thank you, I completely forgot to strip the UserID and Password to MySQL. The book is called PHP, Fast & Easy Web Development by Julie C. Meloni. The errata is located at the somewhat famous www.thickbook.com (more specifically http://www.thickbook.com/books/index.phtml, the book is the first book listed on that page). The errata was helpful in some situations where mistakes were noticable, but it doesn't go any further and it didn't help solve the current problem I'm having. Perhaps I could have made a mistake in the coding, who knows. All I know is that I tried checking and rechecking my code and it looks fine to me. It is also the exact script from the book, yet with the errata's corrections applied as well. Any help from you or any of our other collegues on this newsgroup would be helpful. Thank you for your response and attempt to help. Navid Yar -----Original Message----- From: Kath [mailto:kath@kathweb.net] Sent: Thursday, April 19, 2001 4:06 PM To: Superbus22@home.com; php-general@lists.php.net Subject: Re: [PHP] Authentication In the future, do not post your mysql password on the list Just a little piece of advice ;) Also, try checking the online errata for the book (You didn't mention which book so I can't point you in the right direction). - Kath ----- Original Message ----- From: "Navid Yar" <Superbus22@home.com> To: <php-general@lists.php.net> Sent: Thursday, April 19, 2001 4:59 PM Subject: [PHP] Authentication > Hello, > > I'm somewhat new to PHP. I'm having problems with a script and I don't know > why. It is from a book, yet it does not work for some reason. Both Apache > and MySQL are on and are working fine on my system. The code deals with > creating tables within a database (the database already exists. The error is > that it could connect to the database, but couldn't create the table within > the specified DB. Below are two PHP files that work together for this > specific project. Any help with this is much appreciated. Here are the > scripts: > > Script #1 > > > <?php > > // Check that the user entered the info. If not then direct them back to the > form > > if ((!$table_name) || (!$num_fields)) { > header ("Location: > http://localhost/examples/dynamic/authentication/auth_app/show_createtable.h > tml"); > exit; > } > > $form_block = "<form method=\"post\" > action=\"do_createtable.php\"> > <input type=\"hidden\" name=\"table_name\" > value=\"$table_name\"> > <table cellspacing=\"5\" cellpadding=\"5\"> > <tr> > <th>FIELD NAME</th><th>FIELD TYPE</th><th>FIELD > LENGTH</th></tr> > "; > > for ($i = 0; $i < $num_fields; $i++) { > > $form_block .= "<tr> > <td align=\"center\"><input type=\"text\" > name=\"field_name[]\" size=\"30\"></td> > > <td align=\"center\"> > <select name=\"field_type[]\"> > <option value=\"char\">char</option> > <option value=\"date\">date</option> > <option value=\"float\">float</option> > <option value=\"int\">int</option> > <option value=\"text\">text</option> > <option value=\"varchar\">varchar</option> > </select> > </td> > > <td align=\"center\"><input type=\"text\" > name=\"field_length[]\" size=\"5\"></td> > "; > } > > $form_block .= "<tr> > <td align=\"center\" colspan=\"3\"><input > type=\"submit\" > value=\"Create Table\"></td> > </tr> > </table> > </form> > "; > ?> > > <html> > <head> > <title>Create a Database Table: Step 2</title> > </head> > <body> > > <h1>Define fields for <?php echo "$table_name"; ?></h1> > <?php echo "$form_block"; ?> > > </body> > </html> > > > > > > Script #2 > > > <?php > > $db_name="testDB"; > > $connection = @mysql_connect("localhost", "afghan", "office939") > or > die ("Couldn't connect."); > > $db = @mysql_select_db($db_name, $connection) > or die("Couldn't select database."); > > $sql = "CREATE TABLE $table_name ("; > > for ($i = 0; $i < count($field_name); $i++) { > $sql .= "$field_name[$i] $field_type[$i]"; > if ($field_length[$i] != "") { > $sql .= "(field_length[$i]),"; > } else { > $sql .= ","; > } > } > > $sql = substr($sql, 0, -1); > > $sql .= ")"; > > $result = @mysql_query($sql,$connection) or die("Couldn't execute query."); > > if ($result) { > $msg = "<p>$table_name has been created!</p>"; > } > > ?> > > <html> > <head> > <title>Create a Database Table: Step 3</title> > </head> > <body> > > <h1>Adding table to <?php echo "$db_name"; ?>...</h1> > > <?php echo "$msg"; ?> > > </body> > </html> > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net