php链接mysql

连接服务器：

  $con = mysql_connect("192.168.4.30","user","password")
             or die("connect to server fail: ". mysql_error());
  echo "connect to server success!";
  echo "<br>";




     
     

      
      连接数据库：
     
     

     
     

      
      
     
     
  mysql_select_db("wangsz",$con) or die ("select db fail: ". mysql_error());
           echo "select db success!";;
  echo "<br>";


插入一条数据：

       
       

        
            
       
       
 $insert_sql = "insert into user(id,username,password)
    values(null,'".$_POST['user']."','".$_POST['password']."')";


       
       

        
        
       
       

       
       

        
        


       
       

       
       

        
        删除一条语句：
       
       

       
       

        
        
       
       
      $con = mysql_connect("192.168.4.30","user","password")
             or die("connect to server fail: ". mysql_error());
      echo "connect to server success!";
      echo "<br>";



        
        

         
         
        
        

        
        

         
         
        
        

        
        

         
         修改一条语句：
        
        

        
        

         
         
        
        
     $update_sql = "update user set password='".$_POST['password']."'
            where username='".$_POST['username']."'";

     //var_dump($update_sql);exit();
     mysql_query($update_sql) or die("update fail: ". mysql_error());
      echo "update success!";


        
        

         
         
        
        

        
        

         
         查询语句：
        
        

        
        


         
         

          
          
         
         

        
        
$username=$_POST['username'];
$query_sql = "select * from  user where username='$username'";

            
//var_dump($query_sql);exit();
$rs=mysql_query($query_sql);
echo "<table>";
echo "<tr><td>id</td><td>username</td><td>password</td></tr>";
while($rows=mysql_fetch_array($rs)){
      echo "<tr>";
      echo "<td>".$rows['id']."</td><br>";
      echo "<td>".$rows['username']."</td><br>";
      echo "<td>".$rows['password']."</td><br>";
      echo "</tr>";

}