update的普通、封装、和类方法的写法!

xiaoxiao2021-02-28  9

普通写法!

<?php

 $mysqli=new mysqli("localhost","root","","demo");

    //判断连接

    if($mysqli->connect_error){

     die("连接失败!"。$mysqli->connect_error());

}

//update语句  把ID=10121 的stuname改成 小明;

$sql="update  student  set  stuname='小明' where  id=10121";

//判断 执行sql语句

   if($mysqli->query($sql)===true){

         echo "修改成功!";

        }else{  

          echo "修改失败!";

      }

//关闭连接

$mysqli->close();

?>

封装写法

<?php

//接收mysqli

  $mysqli=conn();

//调用update 传参数(连接,表名,条件)

update($mysqli,"student","stuname='和珅' where id=888888");

连接数据库(封装)

function conn(){

   $tmysqli= new mysqli("localhost","root","","demo");

     if($tmysqli->connect_error){

            die("连接失败!".$tmysqli->connect_error());

    }

      return  $tmysqli; 

}

function  update($tmysqli,$table,$tiaojian){

   $sql="update $table set $tiaojian ";

      if($tmysqli->query($sql)===true){

           echo "修改成功!";

  }

}

?>

//类写法

<?php

//创建新的对象

 $test=new Test();

  //调用连接

 $mysqli=$test->conn();

//调用update 并传参数!

$test->update($mysqli,"student","stuname='和珅' where id=1888");

调用close 关闭连接

$test->close($mysqli); //创建类 class Test{

        private  $ip="localhost";

private  $user="root";

private  $pwd="";

private  $db="demo";

function conn(){

$tmysqli=new mysqli($this->ip,$this->user,$this->pwd,$this->db);

if($tmysqli->connect_error){

die("链接数据库失败!".$tmysqli->connect_error()); }

echo "ok<br/>";

return $tmysqli; }

function update($tmysqli,$table,$tiaojian){

$sql="update $table set $tiaojian";

if($tmysqli->query($sql)===true){

$res=$tmysqli->query($sql);

if(!$res){

echo "操作失败!".$tmysqli->error();

}else{

if($tmysqli->affected_rows>0){

                     echo "执行OK!";

}else{

echo "没有行受到影响!";

}

} } function close($closql){           $closql->close() ;       } }

?>

转载请注明原文地址: https://www.6miu.com/read-1900398.html

最新回复(0)