您好,欢迎访问一九零五行业门户网

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

$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','1@qq.com','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 = '2@qq.com' 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());
http://www.bkjia.com/phpjc/477939.htmlwww.bkjia.comtruehttp://www.bkjia.com/phpjc/477939.htmltecharticle$dbhost=localhost; $dbuser =admin; $dbpass =; $dbname = lch; $conn = mysql_connect($dbhost,$dbuser,$dbpass,$dbname); if($conn) { echo connect; }else { echo 11111; } mysql_select_db...
其它类似信息

推荐信息