tjc4A01j

1<?php
2
3        $sql = "create table if not exists viis34_book(Ano int primary key auto_increment,title text, author text, edition text, publisher text)";
4        $mysqli = mysqli_connect("localhost", "viis34", "viis34", "6isb2");
5        $res = mysqli_query($mysqli, $sql);
6
7
8        if (isset($_GET["q"])){
9                $s = $_GET["q"];
10                $sql = "select * from viis34_book where title like('%$s%')";
11                $mysqli = mysqli_connect("localhost", "viis34", "viis34", "6isb2");
12                $res = mysqli_query($mysqli, $sql);
13        }
14        else{
15
16                $mysqli = mysqli_connect("localhost", "viis34", "viis34", "6isb2");
17                $res = mysqli_query($mysqli, "SELECT * from viis34_book");
18        }
19
20        if (isset($_GET["add"])){
21                $title=$_GET["title"];
22                $author=$_GET["author"];
23                $edition=$_GET["edition"];
24                $publisher=$_GET["publisher"];
25
26                $mysqli = mysqli_connect("localhost", "viis34", "viis34", "6isb2");
27                $res2 = mysqli_query($mysqli, "insert into viis34_book values(0,'$title','$author','$edition','$publisher')");
28                echo $res2;
29        }
30
31        while($row = mysqli_fetch_assoc($res)){
32                echo $row['Ano']." ".$row["title"]." ".$row["author"]." ".$row["edition"]." ".$row["publisher"]."<br>";
33        }
34
35?>
36
37
38<br><br>
39
40<form action="p12.php" method="get">
41        <input type="text" name="q" placeholder="Search Title">
42        <input type="submit" name="search" value="Add Book">
43</form>
44
45<br><br>
46
47<form action="p12.php" method="get">
48        <input type="text" name="title" placeholder="Title">
49        <input type="text" name="author" placeholder="Author">
50        <input type="text" name="edition" placeholder="Edition">
51        <input type="text" name="publisher" placeholder="Publisher">
52        <input type="submit" name="add" value="Add Book">
53</form>
54~
55~
56~
57
58~
59~