if ($result = $mysqli->query("SELECT `login` FROM `just_users` WHERE `login`='66demon666'")) {
if ($result->num_rows != 0) {
echo "Пользователь с таким логином уже существует в базе данных";
}
else {
echo "OK";
}
}SELECT COUNT(*)/(SELECT COUNT(*) FROM addresses)*100 AS percent FROM addresses WHERE status=5mysqli_query($db_connect, "INSERT INTO `users` (`name`, `pass`) VALUES ('". $data["login"]."','" . $data["password"] ."')");$time_now = strtotime(date('Y-m-d H:i'));
$time_need = strtotime('2018-01-08 17:56');
echo ceil(($time_now-$time_need)/60);SELECT `posts`.`title`,
(SELECT count(`id`) FROM `likes` WHERE `post_id` = `posts`.`id`) AS likes,
(`posts`.`num` + likes) AS sum_likes
FROM `posts`
ORDER BY sum_likes DESC$posts = json_decode(file_get_contents("https://api.vk.com/method/wall.get?&owner_id=$owner_id&count=100&access_token=$service"));
$inserts = array();
foreach ($posts->response as $res => $result) {
if ($res < 2) continue;
$id = $result->id;
$artist = $result->attachments[1]->audio->artist;
$title = $result->attachments[1]->audio->title;
$inserts[] = "(".(int)$id.", '".$mysqli->real_escape_string($artist)."', '".$mysqli->real_escape_string($title)."')";
echo "<pre>";
echo "$id | $artist | $title";
echo "</pre>";
}
if (sizeof($inserts) > 0) {
$mysqli->query("INSERT INTO `table` (`id`, `artist`, `title`) VALUES ".implode(',', $inserts)."");
}