thinkphp是面向对象的吗?

connect_errno) {//检测连接错误 die('连接失败'.$mysqli->connect_error);//输出错误提示符并中断脚本执行 } $mysqli->set_charset('utf8');//设置默认客户端字符集为utf8

$sql = "INSERT INTO `tableName` (`field1`,`field2`...) VALUES ('value1','value2'...)"; if ($mysqli->query($sql)) { echo '成功添加了'.$mysqli->affected_rows.'条新增记录，新增id是'.$mysqli->insert_id; } else { echo '添加失败'.$mysqli->errno.':'.$mysqli->error; }

$sql = "UPDATE `表名` SET `字段名1`='值1' WHERE '条件表达式'"; if ($mysqli->query($sql)) { echo '成功更新了'.$mysqli->affected_rows.'条记录'; } else { echo '更新失败'.$mysqli->errno.':'.$mysqli->error; }

$sql = "DELETE FROM `表名` WHERE `id`=4"; if ($mysqli->query($sql)) { echo '成功删除了'.$mysqli->affected_rows.'条记录'; } else { echo '删除失败'.$mysqli->errno.':'.$mysqli->error; }

$sql = "SELECT `字段列表` FROM `表名` where '条件表达式'"; if ($mysqli_result=$mysqli->query($sql)) { while($row=$mysqli_result->fetch_array(MYSQL_ASSOC)){ echo '
'; print_r($row); } }
        

         Salin selepas log masuk
        
       

$sql = "SELECT `字段列表` FROM `表名` where '条件表达式'"; $result=$mysqli->query($sql)->fetch_array());