1. 云栖社区>
  2. PHP教程>
  3. 正文

php 对 mysql数据库的增,删,该,查

作者:用户 来源:互联网 时间:2017-12-01 18:19:36

数据库mysql

php 对 mysql数据库的增,删,该,查 - 摘要: 本文讲的是php 对 mysql数据库的增,删,该,查,   $dbhost="localhost";        $dbuser ="admin";        $dbpass ="";        $dbname = "lch";        $conn = mysql_connec

  $dbhost="localhost";
        $dbuser ="admin";
        $dbpass ="";
        $dbname = "lch";
        $conn = mysql_connect($dbhost,$dbuser,$dbpass,$dbname);
       
        if($conn)
        {
            echo "connect";
        }else
        {
            echo "11111";
        }
        mysql_select_db($dbname,$conn);
        $sql = "insert into ";
        $sql .="user(tripal_id,company_id,username,email,name,credit,parent_id,password,settle_password,lognum,last_login,new_fan_num,remember_me_num,
        is_admin,is_bb,is_bc)";

        $sql .="values('1','1','name3','[email protected]','ling','23','0',null,null,'1','2012-10-18 16:25:39','1','1','1','1','1')";

        mysql_query($sql) or die('insert data failed cause: '.mysql_error());
       
        $select = "select * from user ";
        $result =  mysql_query($select) or die('select data failed cause: '.mysql_error());
        print_r(mysql_fetch_array($result));
       
        $update = "update user set email = '[email protected]' where id =3";
        echo $update;
        mysql_query($update) or die('update data failed cause: '.mysql_error());
       
    
        $delete = "delete from user where id = 1";
        mysql_query($delete) or die('delete data failed cause: '.mysql_error());

以上是云栖社区小编为您精心准备的的内容,在云栖社区的博客、问答、公众号、人物、课程等栏目也有的相关内容,欢迎继续使用右上角搜索按钮进行搜索数据库 mysql ,以便于您获取更多的相关知识。