query("SELECT count(*) FROM `works` ");
} else {
if ($_GET['type'] == 'Все') {
if ($_GET['place'] == 'Все') {
$a = $mysqli->query("SELECT count(*) FROM `works` ");
} else{
$place = $_GET['place'];
$a = $mysqli->query("SELECT count(*) FROM `works` WHERE (`place` = '$place') ");
}
} else{
if ($_GET['place'] == 'Все') {
$type = $_GET['type'];
$a = $mysqli->query("SELECT count(*) FROM `works` WHERE (`type` = '$type') ");
} else {
$type = $_GET['type'];
$place = $_GET['place'];
$labels = $mysqli->query("SELECT * FROM `labels` WHERE (`type` = '$type' AND `place` = '$place')");
}
}
};
if ($_GET['date'] != null) {
$date = $_GET['date'];
$a = $mysqli->query("SELECT count(*) FROM `works` WHERE (`date` = '$date') ");
}
$labels = $mysqli->query("SELECT * FROM `labels`");
$a = $a->fetch_row();
$a = (int)($a[0]/3);
$g = false;
if ($_GET == null) {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3" );
$k = 0;
} else{
if ($_GET['do'] == 0) {
if ($_GET['set'] == 0) {
$k = $_GET['set'];
} else{
$k = $_GET['set'] - 1;
}
};
if ($_GET['do'] == 1){
$k = $_GET['set'] + 1;
};
if ($_GET['do'] == 2) {
$k = $_GET['set'];
}
};
if ($a == $k) {
$g = true;
};
$k = $k * 3;
if (($_GET['type'] == null) && ($_GET['place'] == null)) {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3 OFFSET $k" );
} else {
if ($_GET['type'] == 'Все') {
if ($_GET['place'] == 'Все') {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3 OFFSET $k" );
} else{
$place = $_GET['place'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`place` = '$place') LIMIT 3 OFFSET $k");
}
} else{
if ($_GET['place'] == 'Все') {
$type = $_GET['type'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`type` = '$type') LIMIT 3 OFFSET $k");
} else {
$type = $_GET['type'];
$place = $_GET['place'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`type` = '$type' AND `place` = '$place') LIMIT 3 OFFSET $k");
}
}
};
$date = $_GET['date'];
if ($date != null) {
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`date` = '$date') LIMIT 3 OFFSET $k");
}
?>
if ($_GET == null) {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3" );
$k = 0;
} else{
if ($_GET['do'] == 0) {
if ($_GET['set'] == 0) {
$k = $_GET['set'];
} else{
$k = $_GET['set'] - 1;
}
};
if ($_GET['do'] == 1){
$k = $_GET['set'] + 1;
};
if ($_GET['do'] == 2) {
$k = $_GET['set'];
}
};
if ($a == $k) {
$g = true;
};
$k = $k * 3;
if (($_GET['type'] == null) && ($_GET['place'] == null)) {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3 OFFSET $k" );
} else {
if ($_GET['type'] == 'Все') {
if ($_GET['place'] == 'Все') {
$projects= $mysqli->query("SELECT * FROM `works` LIMIT 3 OFFSET $k" );
} else{
$place = $_GET['place'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`place` = '$place') LIMIT 3 OFFSET $k");
}
} else{
if ($_GET['place'] == 'Все') {
$type = $_GET['type'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`type` = '$type') LIMIT 3 OFFSET $k");
} else {
$type = $_GET['type'];
$place = $_GET['place'];
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`type` = '$type' AND `place` = '$place') LIMIT 3 OFFSET $k");
}
}
};
$date = $_GET['date'];
if ($date != null) {
$projects= $mysqli->query("SELECT * FROM `works` WHERE (`date` = '$date') LIMIT 3 OFFSET $k");
}
?>
