//查询
$sql = "SELECT userid,wx_id FROM comm_user WHERE userid=".$_SESSION['userid'];
$res = Db::name('table_name')->query($sql)
var_dump($res);
//返回值
array(1) {
[0]=>
array(2) {
["userid"]=>
int(11134413)
["wx_id"]=>
int(1432263)
}
}
//更新
$sql = "UPDATE comm_user "
. " SET phone='" . $_POST['phone'] . "' "
. " WHERE userid='" . $_SESSION['userid'] . "'"
$res = Db::name('table_name')->query($sql)
var_dump($res);
//返回值
array(1) {
}
//删除
$sql_del = "DELETE FROM comm_user WHERE wx_id=9527110";
$res = Db::name('comm_user')->query($sql_del);
var_dump($res);
//返回
array(0) {
}
//增加
$sql_add = "INSERT INTO comm_user(wx_id,pay_pwd) VALUES('9527110','0117259')";
$res = Db::name('comm_user')->query($sql_add);
var_dump($res);
//返回
array(0) {
}
TP5 原生查询返回值的问题
最新推荐文章于 2022-11-04 10:36:28 发布