static function getFromEnglish($english) { $mysqli = DB::getConn(); $sql = "select * from english where english='{$english}'"; $result = DB::getResult($sql, $mysqli); $arr = array(); while ($array = $result->fetch_assoc()) { $arr[] = $array; } DB::close($mysqli, null, $result); return $arr; }
/** * 处理详细用户信息的函数,会写入或更新数据库 * @param $guests 传入索引型数组,每个下标对应某一个用户的详细信息 */ static function dealGuests($guests) { //JTool::printArray($guests); $mysqli = DB::getConn(); $mysqli->autocommit(0); foreach ($guests as $user) { $uid = $user['id']; $sql = "select id from guests where uid ='{$uid}'"; $result = DB::getResult($sql, $mysqli); $id = $result->fetch_assoc(); if (isset($id['id'])) { //echo "更新用户".BR; self::updateGuest($user, $mysqli); } else { //echo "添加用户".BR; self::setGuest($user, $mysqli); } $result->free(); } $mysqli->commit(); $mysqli->autocommit(1); DB::close($mysqli); }