/* * Following code will create a new product row * All product details are read from HTTP Post Request */ // array for JSON response $response = array(); // check for required fields if (isset($_POST['name']) && isset($_POST['price']) && isset($_POST['description'])) { $name = $_POST['name']; $price = $_POST['price']; $description = $_POST['description']; // include db connect class require_once __DIR__ . '/db_connect.php'; // connecting to db $db = new DB_CONNECT(); $con = $db->getConnection(); // mysql inserting a new row $result = mysqli_query($con, "INSERT INTO products(name, price, description) VALUES('{$name}', '{$price}', '{$description}')") or die(mysqli_error($con)); // check if row inserted or not if ($result) { // successfully inserted into database $response["success"] = 1; $response["message"] = "Product successfully created."; // echoing JSON response echo json_encode($response); } else { // failed to insert row $response["success"] = 0; $response["message"] = "Oops! An error occurred."; // echoing JSON response echo json_encode($response);
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; $db = new DB_CONNECT(); if (isset($_POST["training_id"])) { $response = array(); $training_id = $_POST['training_id']; $result = $db->getConnection()->query("SELECT *FROM trainings WHERE training_id = {$training_id}"); if (!empty($result)) { if ($result->num_rows > 0) { $result = $result->fetch_array(); $training = array(); $training["training_id"] = $result["training_id"]; $training["name"] = $result["name"]; $training["owner_login"] = $result["owner_login"]; $training["time"] = $result["time"]; $training["dayOfWeek"] = $result["dayOfWeek"]; $training["agenda"] = $result["agenda"]; $response["success"] = 1; $response["training"] = array(); array_push($response["training"], $training); echo json_encode($response); } else { $response["success"] = 0; $response["message"] = "Training not found"; echo json_encode($response); } } else { $response["success"] = 0; $response["message"] = "Empty result"; echo json_encode($response);
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; if (isset($_POST["login"]) && isset($_POST["password"])) { $db = new DB_CONNECT(); $login = $_POST["login"]; $password = $_POST["password"]; $response = array(); $login = $_POST["login"]; $result = $db->getConnection()->query("SELECT * FROM users WHERE login = '******'"); if (!empty($result)) { if ($result->num_rows > 0) { $result = $result->fetch_array(); $salt = $result["salt"]; $hash = md5(md5($password . md5(sha1($salt)))); $iterations = 10; for ($i = 0; $i < $iterations; ++$i) { $hash = md5(md5(sha1($hash))); } if ($hash == $result["password"]) { $response["success"] = 1; $response["user"] = array(); $response["user"]["first_name"] = $result["first_name"]; $response["user"]["last_name"] = $result["last_name"]; } else { $response["success"] = 0; $response["salt"] = $salt; $response["password"] = $hash; $response["message"] = "Wrong password"; } echo json_encode($response);
<?php if (isset($_POST["login"]) && isset($_POST["password"])) { require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; $db = new DB_CONNECT(); $response = array(); $login = $_POST["login"]; $password = sha1($_POST["password"]); $result = $db->getConnection()->query("INSERT INTO users(login, password) VALUES('{$login}', '{$password}')"); if (!empty($result)) { $result = $db->getConnection()->query("SELECT *FROM users WHERE login = '******'"); if ($result->num_rows > 0) { $result = $result->fetch_array(); if ($password == $result["password"]) { $response["success"] = 1; $response["message"] = "User successfully added"; } echo json_encode($response); } else { $response["success"] = 0; $response["message"] = "User not created"; echo json_encode($response); } } else { $response["success"] = 0; $response["message"] = "Empty result"; echo json_encode($response); } } else { $response["success"] = 0; $response["message"] = "Required field(s) is missing";
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; $db = new DB_CONNECT(); $response = array(); $result = $db->getConnection()->query("select training_id, name, owner_login, concat_ws(' - ', start_time, end_time) as time, dayOfWeek, agenda, place from trainings"); if (!empty($result)) { if ($result->num_rows > 0) { while ($raw = mysqli_fetch_object($result)) { $training[] = $raw; } $response['training'] = array(); array_push($response['training'], $training); } } else { $response["success"] = 0; $response["message"] = "error mysql query"; } $result = $db->getConnection()->query("SELECT *FROM `show`"); if (!empty($result)) { if ($result->num_rows > 0) { $show = array(); while ($raw = mysqli_fetch_object($result)) { $show[] = $raw; } $response['show'] = array(); array_push($response['show'], $show); } } else { $response["success"] = 0; $response["message"] = "error mysql query";
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; $db = new DB_CONNECT(); if (isset($_POST["key_value"])) { $response = array(); $key = $_POST["key_value"]; $result = $db->getConnection()->query("SELECT *FROM register_key WHERE key_value = sha1({$key})"); if (!empty($result)) { if ($result->num_rows > 0) { $result = $result->fetch_array(); $response["success"] = 1; $response["key_status"] = $result["free"]; echo json_encode($response); } else { $response["success"] = 0; $response["message"] = "Key not found"; echo json_encode($response); } } else { $response["success"] = 0; $response["message"] = "Empty result"; echo json_encode($response); } } else { $response["success"] = 0; $response["message"] = "Required field(s) is missing"; echo json_encode($response); }
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; //$user_id = $_SESSION["user_id"]; //if ($user_id){ $query = "select login from users where login = '******'"; $db = new DB_CONNECT(); $result = $db->getConnection()->query($query); $result = $result->fetch_array(); if ($user_id == $result["login"]) { $query = "select * from trainings"; $result = $db->getConnection()->query($query); for ($i = 0; $i < $result->num_rows; $i++) { $row = $result->fetch_array(); echo '<div class="schedule-row"><div class="vert-divider"></div>' . '<span class="dayofweek">' . $row["dayOfWeek"] . ' ' . $row["start_time"] . ' - ' . $row["end_time"] . '</span>' . '</div>' . "\n"; } } //} else { //echo '<p class="autorization-error">Для доступа к данной странице, необходимо авторизироваться.</p>'; //}
<?php require_once $_SERVER['DOCUMENT_ROOT'] . '/db/db_connect.php'; $db = new DB_CONNECT(); $response = array(); $result = $db->getConnection()->query("SELECT *FROM trainings"); if (!empty($result)) { if ($result->num_rows > 0) { $training = array(); while ($raw = mysqli_fetch_object($result)) { $training[] = $raw; } $response["training"] = array(); array_push($response["training"], $training); } else { $response["success"] = 1; $response["message"] = "Empty result"; } } else { $response["success"] = 0; $response["message"] = "mysql error"; } echo json_encode($response);