php iquery

最新推荐文章于 2025-09-12 13:16:34 发布

weixin_30340775

最新推荐文章于 2025-09-12 13:16:34 发布

阅读量67

点赞数

CC 4.0 BY-SA版权

文章标签： php

原文链接：http://www.cnblogs.com/sky-view/p/4291450.html

本文介绍了一个PHP函数iQuery，用于执行SQL查询并返回包括插入ID、受影响行数、查询结果及总行数等在内的多种结果。该函数支持单条或多条SQL语句，并能处理SQL_CALC_FOUND_ROWS类型的查询。

<?php
/**
*
*/
function iQuery($sql) {
$dbcon = mysqli_connect("localhost", "root", "159753", "radius");
if ($dbcon->connect_error) {
return false;
}
if (!is_array($sql)) {
$res = $dbcon->query($sql);
if ($res) {
$arr = [];
while ($item = $res->fetch_array()) {
array_push($arr, $item);
}
$ttr = null;
if (preg_match("/SQL_CALC_FOUND_ROWS/i", $sql)) {
$qttr = $dbcon->query("select found_rows()");
if ($qttr) {
while ($atom = $qttr->fetch_array()) {
$ttr = $atom[0];
}
}

}
return ["insert_id" => $dbcon->insert_id, "affected_rows" => $dbcon->affected_rows, "result" => $arr, "total_rows" => $ttr];
} else {
return false;
}
} else {
$rtn_arr = [];
foreach ($sql as $s) {
$res = $dbcon->query($s);
if ($res) {
$arr = [];
while ($item = $res->fetch_array()) {
array_push($arr, $item);
}
$ttr = null;
if (preg_match("/SQL_CALC_FOUND_ROWS/i", $sql)) {
$qttr = $dbcon->query("select found_rows()");
if ($qttr) {
while ($atom = $qttr->fetch_array()) {
$ttr = $atom[0];
}
}

}
array_push($rtn_arr, ["insert_id" => $dbcon->insert_id, "affected_rows" => $dbcon->affected_rows, "result" => $arr, "total_rows" => $ttr]);
} else {
return false;
}
}
return $rtn_arr;
}

}

转载于:https://www.cnblogs.com/sky-view/p/4291450.html