conn = $conn;
$this->database_table = $database_table;
}
public function saveNewBook($isbn, $name, $page, $author){
$Name = $name;
$Author = $author;
$Page = $page;
$ISBN = $isbn;
if(!empty($Name) || !empty($Author) || !empty($Page) || !empty($ISBN)){
if(strlen($Name) < 150 || strlen($Author) < 100 || strlen($Page) < 6 || strlen($ISBN) < 50){
$sql = "INSERT INTO `$this->database_table` (`isbn`, `name`, `author`, `page`) VALUES ('$ISBN', '$Name', '$Author', '$Page')";
mysqli_query($this->conn, $sql);
}
}
}
public function writeBooks(){
$sql = "SELECT * FROM `$this->database_table` ORDER BY `id` DESC";
$result = mysqli_query($this->conn, $sql);
$check = mysqli_num_rows($result);
if($check < 1){
echo '
No Entry! |
No Entry! |
No Entry! |
No Entry! |
No Entry! |
';
}else{
while($row = mysqli_fetch_assoc($result)){
echo '
'.$row["isbn"].' |
'.$row["name"].' |
'.$row["page"].' |
'.$row["author"].' |
|
';
}
}
}
public function deleteEntry($ISBN){
$sql = "DELETE FROM `$this->database_table` WHERE isbn='$ISBN'";
mysqli_query($this->conn, $sql);
exit();
}
public function arduino_response($ISBN){
$sql = "SELECT * FROM `$this->database_table` WHERE isbn = '$ISBN'";
$result = mysqli_query($this->conn, $sql);
$check = mysqli_num_rows($result);
if($check > 0){
if($row = mysqli_fetch_assoc($result)){
$response = '%'.$row["name"].'%'.$row["page"].'%'.$row["author"].'%'.$row["id"].'%';
echo $response;
}
}else{
echo '%Not Found!%Not Found!%Not Found!%Not Found!%';
}
exit();
}
}
?>