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;
 }
Exemple #2
0
 /**
  * 处理详细用户信息的函数,会写入或更新数据库
  * @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);
 }