Input data into mysql from the browser

francoistong

dear everyone,
I can not make it work to input data into mysql from the browser.
Can anyone help?
Since I can not input data in Chinese from GNOME terminal, I am trying to input data in Chinese from a browser. Following is my code

<?php
  include '/wwwroot/include/wanlidi/error.php/';
  include '/wwwroot/include/wanlidi/incdsr.php/';
  include '/wwwroot/include/wanlidi/clean.php/';  

  if (empty($Id_Address) || empty($AddressHead))
  {
  ?>
  <!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
     <title>&#65533;&#65533;&#1463;&#65533;&#65533;&#65533;&#65533;</title>
      <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
      <link rel="stylesheet" href="../rz/rase.css" type="text/css" media="all" media="handheld" />
      <style type="text/css" media="all" media="handheld">
          @import url"../rz/rase.css";
      </style>
  </head>
  <body>
    <form action="addinput.php" method="post">
       &#65533;&#65533;&#65533;&#65533;&#65533;&#65533;:
      <input type="text" name="Id_Address" size="3">
      <input type="text" name="AddressHead" size="30"> 
      <input type="text" name="TelephoneHead" size="4">
      <input type="submit" value="&#65533;&#8059;">
    </form>
 </body>
</html>
<?php
  }
  else 
  {
    $Id_Address = clean($Id_Address, 3);
    $AddressHead = clean($AddressHead, 30);
    $TelephoneHead = clean($TelephoneHead, 4);

if (!($connection = @ mysql_connect($hostName,$username,$password)))
    die("&#65533;&#65533;&#65533;&#65533;l&#65533;&#1269;&#65533;&#65533;&#65533;&#1919;&#65533;");
if(!(@ mysql_select_db($databaseName, $connection)))
   showerror();
$insertQuery = "insert into addhd values
               (\"" . $Id_Address . "\", " . 
                "\"" . $AddressHead . "\", " . 
	    "\"" . $TelephoneHead . "\")";
if ((@ mysql_query ($insertQuery, $connection))
   && @ mysql_affected_rows() == 1)
   header("location: input_header.php?" . 
          "Id_Address= " . mysql_insert_id($connection) . 
	  "&status=T");
else
       header("location: input_header.php?" . 
	  "&status=F");	    
  }
?>

<?php include '/wwwroot/include/wanlidi/error.php/'; 
include '/wwwroot/include/wanlidi/incdsr.php/';
 include '/wwwroot/include/wanlidi/clean.php/';
 $Id_Address = clean($Id_Address, 3);
 $status = clean($status, 1);
 switch ($status) 
{
 case "T": 
$query = "select * from addhd where " . "id = $Id_Address"; 
if (!($connection = @ mysql_connect($hostName,$username,$password)))
 die("&#19981;&#33021;&#36830;&#25509;&#21040;&#25968;&#25454;&#24211;"); 

if (!(@ mysql_select_db($databaseName, $connection))) showerror();
 if (!($result = @ mysql_query($query, $connection))) showerror();
 if ($row = @ mysql_fetch_array($result))
 { echo "&#28155;&#21152;&#20102;&#19979;&#36848;&#22320;&#21306;"; 

echo "\n
&#22320;&#21306;&#20195;&#21495;: " . 
"$row["id"];
 echo "\n
&#22320;&#21306;: " . "$row["addhead"];
 echo "\n
&#21306;&#21495;: " . "$row["telehead"]; }
 break;
 case "F":
 echo "&#36755;&#20837;&#22320;&#21306;&#25805;&#20316;&#22833;&#36133;!"; 
echo "&#35831;&#32852;&#31995;&#31995;&#32479;&#31649;&#29702;&#21592;."; 
break;
 default:
 echo "&#20320;&#24847;&#22806;&#22320;&#35265;&#21040;&#36825;&#19968;&#32593;&#39029;."; 
} 
?>

cbj4074

Well... what happens when you execute the code you posted?

francoistong

I can see the form I want, only 1 page, even after submit the form.

But when submit data. nothing happened to my table.

{For your reference}
with the same connection, I can select data from the browser.