function Inquilinos($nro=0) // declara el constructor, si trae el numero de cliente lo busca , si no, trae todos los clientes
{
if ($nro!=0)
{
$obj_inquilino=new Query();
$result=$obj_inquilino->executeQuery("select nombre, valor from premios"); // ejecuta la consulta para traer al cliente
$row=MySQLi_fetch_array($result);
$this->id=$row['nombre'];
$this->nombre=$row['valor'];
}
}
<?php
if (isset($_POST['submit'])) {
$keyword = $_POST['search'];
if ($keyword == "") {
echo "Sisestage otsitav.";
} else {
$found_books = mysqli_query($con, "\n SELECT books.book_id, books.book_title,books.book_quantiy,authors.author_name,genres.genre_name\n FROM books\n JOIN authors ON authors.author_id = books.author_id\n JOIN genres ON books.genre_id = genres.genre_id\n WHERE\n books.book_title LIKE ('%{$keyword}%')OR\n authors.author_name LIKE ('%{$keyword}%')OR\n genres.genre_id LIKE ('%{$keyword}%')\n ");
while ($book = MySQLi_fetch_array($found_books)) {
echo '<tr>';
echo '<td>' . $book['author_name'] . '</td>';
echo '<td >' . $book['book_title'] . '</td>';
echo '<td>' . $book['genre_name'] . '</td>';
echo '<td>' . $book['book_quantiy'] . '</td>';
echo '
<td>
<form method="post">
<input type="hidden" name="hidden" value="' . $book['book_id'] . '"/>
<input type="submit" value="Laenuta" name="rent" >
</form>
</td>
';
echo '</tr>';
}
}
}
if (isset($_POST['rent'])) {
$vastavid = $_POST['hidden'];
mysqli_query($con, "\nUPDATE books\n SET books.book_quantiy = books.book_quantiy-1\n WHERE book_id={$vastavid}\n");
$muutuja = "INSERT INTO rent (client_id, book_id, rent_start_date, rent_end_date)\nVALUES ({$client_id}, {$vastavid}, NOW(), NOW()+INTERVAL 14 DAY)";
mysqli_query($con, $muutuja);
<?php
if (isset($_POST['submit'])) {
$keyword = $_POST['search'];
if ($keyword == "") {
echo "Sisestage otsitav.";
} else {
$found_clients = mysqli_query($con, "\n SELECT clients.client_id,clients.fname, clients.lname,clients.pcode\n FROM clients\n WHERE\n clients.client_id LIKE('%{$keyword}%') OR\n clients.fname LIKE('%{$keyword}%') OR\n clients.pcode LIKE('%{$keyword}%') OR\n clients.lname LIKE('%{$keyword}%')\n ");
while ($client = MySQLi_fetch_array($found_clients)) {
echo '<tr>';
echo '<td >' . $client['client_id'] . '</td>';
echo '<td ><a href="?page=client&id=' . $client['client_id'] . '"> ' . $client['fname'] . '</a></td>';
echo '<td >' . $client['lname'] . '</td>';
echo '<td >' . $client['pcode'] . '</td>';
echo '</tr>';
}
}
}
