Пример #1
0
 static function setGuest($user, mysqli $mysqli)
 {
     $sql = "insert into guests(uid,name,profile_img,province,city,gender,followers_count,friends_count,statuses_count,created_at,verified) values(?,?,?,?,?,?,?,?,?,?,?)";
     $stmt = $mysqli->prepare($sql);
     if ($mysqli->errno) {
         echo $mysqli->error;
     }
     $stmt->bind_param("sssiisiiiis", $uid, $name, $profile_img, $province, $city, $gender, $followers_count, $friends_count, $statuses_count, $created_at, $verified);
     $uid = $user['id'];
     $name = $user['name'];
     $profile_img = $user['profile_image_url'];
     $province = $user['province'];
     $city = $user['city'];
     $gender = $user['gender'];
     $followers_count = $user['followers_count'];
     $friends_count = $user['friends_count'];
     $statuses_count = $user['statuses_count'];
     $created_at = JDate::weiboDateToTimeStamp($user['created_at']);
     $verified = $user['verified'];
     $stmt->execute();
     if ($stmt->errno) {
         echo "stmterro:" . $stmt->error;
     }
     $stmt->close();
 }