Re: Whios request record in database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



couple possible problems.
1. register globals being off and you're using variables like $name instead
of $_POST['name'].
2.  you're not asking that anything be written to the database, only
selecting....
      $insert="select * from $table";
      $db_query=mysql_db_query($db_name,$insert);

3. you're cheking if $name exists in the same code block that you've only
entered if $name does NOT exist.  you have some overlapping/unlclosed if
brackets

hth
Jeff



                                                                                                                                        
                      "IS"                                                                                                              
                      <is@think.nl>            To:       <php-db@lists.php.net>                                                         
                                               cc:                                                                                      
                      09/12/2003 07:31         Subject:   Whios request record in database                                      
                      AM                                                                                                                
                                                                                                                                        
                                                                                                                                        




I want to record the whois requests people do, not the whois output, in
a MySQL database.

The following code I'm playing with, but it doesn't write anything to my
table. What's wrong?

<?php
     if(!$name)
     {
      print("<form name=\"\" action=\"$PHP_SELF\" method=\"post\">
      <input type=\"text\" name=\"name\">
      <input type=\"submit\" name=\"name\">
      </form>");
      $db_name='dbname';
      $db_user='username';
      $db_password='password';
      $table='tablename';
      // Connect to the database
      $db_conn = mysql_connect("localhost",$db_user,$db_password);
      if (!$db_conn)
      {
           die ("ERROR: Cannot connect to the database.");
           //exit();
      }
      $ip = $REMOTE_ADDR;
      $insert="select * from $table";
      $db_query=mysql_db_query($db_name,$insert);
      if($name)
      {
           if($dbquery)
           { print("Done.");
           }
           else
           { print("Didn't work.");
           }
      }
 }
?>

--IS

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux