<?php
class Book
{
public function createBook()
{
$ntitle = mysql_real_escape_string($_GET['ntitle']);
$nprice = filter_var($_GET['nprice'], FILTER_VALIDATE_FLOAT);
$ndesc = mysql_real_escape_string($_GET['ndesc']);
$link = mysql_connect('localhost', 'root', '') or die('No se pudo conectar al servidor: ' . mysql_error());
mysql_select_db('books') or die('No se pudo seleccionar la base de datos');
mysql_query("SET NAMES 'utf8'");
$query = "INSERT INTO `books`(`title`,`price`,`description`) VALUES ('{$ntitle}','{$nprice}','{$ndesc}')";
$result = mysql_query($query) or die('Consulta fallida: ' . mysql_error());
if ($result) {
echo "Insertado.";
}
mysql_close($link);
}
}
$book = new Book();
$book->createBook();
echo "<br><br>";
echo "<a href='index.php'>Back</a>";
<?php
require_once "api.php";
$ret = [];
$method = $_SERVER['REQUEST_METHOD'];
$book = new Book();
switch ($method) {
case 'GET':
$bookId = $_GET['bookId'];
$ret['bookList'] = $book->loadFromDB($bookId);
break;
case 'POST':
$bookTitle = $_POST['bookTitle'];
$bookAuthor = $_POST['bookAuthor'];
$bookDescription = $_POST['bookDescription'];
$book->createBook($bookTitle, $bookAuthor, $bookDescription);
$ret['bookList'] = $book->loadFromDB();
break;
}
echo json_encode($ret);
if ($db->connect_error) {
$error = $db->connect_error . '(' . $db->connect_errno . ')';
// sprawdzamy error w dżejsonie
// utworzylismy tablice dżejsonową o kluczu error i wartosci error
$json = json_encode(['error' => $error]);
echo $json;
} else {
//przetwarzamy odebrane dane ajaxem z formularza PUT/POST/DELETE/GET
$method = $_SERVER['REQUEST_METHOD'];
$book = new Book($db);
switch ($method) {
case 'GET':
$data = $_GET;
break;
case 'POST':
$data = $_POST;
$book->createBook($data);
//zwracamy do ajaxa wszystkie ksiazki, o ktore pytamy w clasie book.class.php
$ret['KbookList'] = $book->getBooks();
$ret['success'] = 'Ksiazka zostala dodana prawidlowo';
break;
// PUT i DELETE zapisuje się w ten sam sposob dlatego robimy to razem
// PUT i DELETE zapisuje się w ten sam sposob dlatego robimy to razem
case 'PUT':
case 'DELETE':
parse_str(file_get_contents('php://input'), $data);
break;
}
echo json_encode($ret);
}
//tworzymy obiekt klasy book i wykonujemy odpowiednie operacje
