function myBasket()
{
//запрос в таблицу basket и catalog ( для отображение инфо на странице корзины этот запрос объединяет 2 таблици basket и catalog
$connect = mysqli_connect(DB, DBLOGIN, DBPASS, DBNAME) or die(mysqli_error());
$sql = "SELECT\n author,title,pubyear,price,\n basket.id,goodsid,customer,quantity\n FROM catalog,basket\n WHERE customer='" . session_id() . "'\n AND catalog.id=basket.goodsid ";
//отобразит только товары которые в таблице basket благодаря условию
$result = mysqli_query($connect, $sql) or die(mysqli_error($connect));
//запрос поместили в переменную
return db2Array($result);
//результат запроса засунем в функцию db2Array (что-бы сделать массив из запроса)
}
if ($table == "Passengers") {
$result = $mysqli->query("SELECT idPassenger AS idUser, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tname,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tphone, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tsex, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tnameCity AS city, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tregDate, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tlocationStatus, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tbalanceBonuses, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tlockStatus, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tphoto \n\t\t\t\t\t\t\t\t\t\t\t\tFROM {$table} INNER JOIN Citys ON {$table}.idCity=Citys.idCity\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE phone={$phone}");
} else {
$result = $mysqli->query("SELECT idDriver AS idUser, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tphone, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tworkingStatus, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tlocationStatus, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tnameCity AS city, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tregDate, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tbalance, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tlockStatus, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tbrandCar, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tmodelCar, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tcolor AS colorCar, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tstateNumber, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\tphoto \n\t\t\t\t\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t\t\t\t\t{$table} \n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\t\t\t\tCitys ON ({$table}.idCity=Citys.idCity) \n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\t\t\t\tModelsCars ON ({$table}.idModelCar=ModelsCars.idModelCar) \n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\t\t\t\tBrandsCars ON ({$table}.idBrandCar=BrandsCars.idBrandCar) \n\t\t\t\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\t\t\t\tColors ON ({$table}.idColor=Colors.idColor)\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE phone={$phone}");
echo $mysqli->error;
}
$user = db2Array($result);
if (empty($user[0])) {
$errors = "Такой номер не зарегистрирован" . $mysqli->error;
} else {
$result = $mysqli->query("SELECT * FROM Orders WHERE {$phoneField}={$phone}");
$orders = db2Array($result);
$info[] = $user;
$info[] = $orders;
echo json_encode($info);
}
} else {
$errors = "Неправильный тип пользователя";
}
}
}
if (!empty($_GET['idCity'])) {
$idCity = clearData($_GET['idCity'], $mysqli);
$result = $mysqli->query("SELECT idUser AS idModerator, login, idCity FROM Users \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE status='admin' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(idCity=0 OR idCity={$idCity})");
$moderators = db2Array($result);
echo json_encode($moderators);
}
if ($errors) {
http_response_code(400);
echo $error;
}
} elseif ($column == "status" or $column == "textReview") {
$result = $mysqli->query("UPDATE Reviews SET {$column}='{$editVal}' WHERE idReview={$id}");
} elseif ($tableName == "moderators") {
$result = $mysqli->query("UPDATE Users SET {$column}='{$editVal}' WHERE idUser={$id}");
} elseif ($column == "moderator") {
$result = $mysqli->query("UPDATE Users SET idCity=0 WHERE idCity={$id}");
$result = $mysqli->query("UPDATE Users SET idCity={$id} WHERE login='******'");
} else {
$result = $mysqli->query("UPDATE Citys SET {$column}='{$editVal}' WHERE idCity={$id}");
}
if (!$result) {
$error = "Не удалось изменить! Ошибка выполнения запроса! " . $mysqli->error;
}
}
}
if (!empty($_GET['idCity'])) {
$idCity = clearData($_GET['idCity'], $mysqli);
$result = $mysqli->query("SELECT idUser AS idModerator, login, idCity FROM Users \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE status='admin' AND \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t(idCity=0 OR idCity={$idCity})");
$moderators = db2Array($result);
echo json_encode($moderators);
}
if (!empty($_GET['idModerator'])) {
$idModerator = clearData($_GET['idModerator'], $mysqli);
$result = $mysqli->query("SELECT idCity, nameCity FROM Citys WHERE idCity NOT IN \n\t\t\t\t\t\t\t\t(SELECT idCity \t\t\t FROM Users WHERE idCity > 0 AND idUser <> '{$idModerator}')");
$citys = db2Array($result);
echo json_encode($citys);
}
if ($error) {
http_response_code(400);
echo $error;
}
function addReview($mysqli)
{
$phonePassenger = clearData($_POST['phonePassenger'], $mysqli);
$rating = clearData($_POST['rating'], $mysqli, "i");
$textReview = clearData($_POST['textReview'], $mysqli);
$phoneDriver = clearData($_POST['phoneDriver'], $mysqli);
$timeReview = date("Y-m-d G:i:s");
if ($phonePassenger == "" or $phoneDriver == "" or !is_int($rating)) {
$output_arr["id"] = 601;
$output_arr["name"] = "Not all parameters set";
$data['code'] = 400;
} else {
$auth = checkToken($mysqli, $phonePassenger);
if (!empty($auth['id']) or $auth['status'] != "passenger") {
$data['code'] = 400;
$auth['id'] = 607;
$auth['name'] = "Invalid TOKEN or PHONE";
$data['content'] = json_encode($auth);
return $data;
}
if ($rating < 0 or $rating > 5) {
$output_arr["id"] = 612;
$output_arr["name"] = "Invalid parameter RATING";
$data['code'] = 400;
$data['content'] = json_encode($output_arr);
return $data;
}
$result = $mysqli->query("SELECT * FROM Passengers WHERE phone={$phonePassenger}");
$myrow = db2Array($result);
$idPassenger = $myrow[0]["idPassenger"];
$result = $mysqli->query("SELECT * FROM Drivers WHERE phone={$phoneDriver}");
$myrow = db2Array($result);
if (!$myrow[0]) {
$output_arr["id"] = 613;
$output_arr["name"] = "Invalid parameter PHONEDRIVER";
$data['code'] = 400;
$data['content'] = json_encode($output_arr);
return $data;
}
$idDriver = $myrow[0]["idDriver"];
$result = $mysqli->query("INSERT INTO Reviews (idPassenger, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tidDriver, \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttextReview,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\ttimeReview,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\trating) \n\t\t\t\t\t\t\t\t\t\t\t\tVALUES ({$idPassenger},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$idDriver},\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$textReview}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t'{$timeReview}',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t{$rating})");
if (!$result) {
$output_arr["id"] = 604;
$output_arr["name"] = "Failed to query: (" . $mysqli->errno . ") " . $mysqli->error;
$data['code'] = 400;
} else {
$output_arr["name"] = "REVIEW successfully added";
$data['code'] = 200;
}
}
$data['content'] = json_encode($output_arr);
return $data;
}
function reviews($mysqli)
{
if ($_SESSION['status'] == 'superadmin') {
$selConditionString = "";
} elseif ($_SESSION['status'] == 'admin') {
$selConditionString = " WHERE Passengers.idCity = " . $_SESSION['idCity'] . " ";
}
$paginationManager = new Krugozor_Pagination_Manager(15, 5, $_REQUEST);
$result = $mysqli->query("SELECT SQL_CALC_FOUND_ROWS idReview, \n\t\t\t\t\t\t\t\t\t\ttextReview, \n\t\t\t\t\t\t\t\t\t\ttimeReview, \n\t\t\t\t\t\t\t\t\t\trating, \n\t\t\t\t\t\t\t\t\t\tstatus, \n\t\t\t\t\t\t\t\t\t\tDrivers.phone AS phoneDriver, \n\t\t\t\t\t\t\t\t\t\tPassengers.phone AS phonePassenger \n\t\t\t\t\t\t\t\t\tFROM Reviews \n\t\t\t\t\t\t\t\t\tINNER JOIN \n\t\t\t\t\t\t\t\t\t\tDrivers ON Drivers.idDriver = Reviews.idDriver \n\t\t\t\t\t\t\t\t\tINNER JOIN\n\t\t\t\t\t\t\t\t\t\tPassengers ON Passengers.idPassenger = Reviews.idPassenger \n\t\t\t\t\t\t\t\t\t" . $selConditionString . "ORDER BY status DESC \n\t\t\t\t\t\t\t\t\tLIMIT " . $paginationManager->getStartLimit() . "," . $paginationManager->getStopLimit());
if ($result) {
$data['reviews'] = db2Array($result);
$result = $mysqli->query("SELECT FOUND_ROWS()");
$numCity = db2Array($result);
$paginationManager->setCount($numCity[0]['FOUND_ROWS()']);
$data['paginationManager'] = $paginationManager;
} else {
$data['errors'] = $mysqli->error;
}
return $data;
}
//echo "Соединение установлено";
if (!$link) {
die('Ошибка соединения: ' . mysql_error());
}
$query = "SELECT * FROM `_wpsales` ORDER BY `id` DESC LIMIT 25";
//var_dump($query);
$data = mysql_query($query) or die(mysql_error());
function db2Array($data)
{
$arr = array();
while ($row = mysql_fetch_assoc($data)) {
$arr[] = $row;
}
return $arr;
}
$res = db2Array($data);
//var_dump($res);
//extract($res, EXTR_OVERWRITE);
?>
<style>
td,th{
border: 1px solid grey;
}
</style>
<table>
<tr>
<th>Дата</th>
<th>№ заказа</th>
<th>Заказчик / телефон / адрес/ почта</th>
<th>Автор/Количесвто страниц/Жанр/Название Сценария </th>
