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>'; } } }