Re: 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 >