FishBase/FFOV.php at master · vohai2003/FishBase · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<title>FFOV</title>
<style>
a:link {
	color: black;
	background-color: transparent;
	text-decoration:none;
}
a:visited {
	color: purple;
	background-color: #94FFE1;
	text-decoration:none;
}
table {
border-collapse: collapse;
width: 100%;
color: #588c7e;
font-family: monospace;
font-size: 25px;
text-align: left;
}
th {
background-color: #588c7e;
color: white;
}
tr:nth-of-type(even) {background-color: #f0f0f0}
tr:hover {background-color: #c0c0c0}
td { font: 20px Times New Roman, serif; color: black }
</style>
</head>
<body>
<h1 style='text-align:center;'>Cá nước ngọt Việt Nam (FFOV) :Tìm kiếm</h1>
<form action="" method="post" style='text-align:center;'>
<label style="font-size:200%;">Tìm</label><input style='position:relative; left:2px; width:300px;' type="text"name="search" value=''/>
<form action="" method="post">
  <label for="Timkiem">trong:</label>
  <select name="Timkiem" id="cars">
    <option value="TenVN">Tên Việt</option>
    <option value="TenEnglish">Tên tiếng anh</option>
    <option value="TenKH">Tên khoa học</option>
  </select>
  <input type="submit" value="Submit" style="width=100px">
<br><br>
<a href='timkiem.php?db=FFOV'>Tìm kiếm theo bộ - họ - giống - loài</a>
<table>
<tr>
<th>T&#234n Vi&#7879t</th>
<th>T&#234n khoa h&#7885c</th>
<th>T&#234n ti&#7871ng Anh</th>
</tr>
<?php
ini_set('display_startup_errors',1);
ini_set('display_errors',1);
error_reporting(-1);
$conn1 = mysqli_connect("localhost", "root", "root","FFOV");

if ($conn1->connect_error) {
  die("Connection failed: ".$conn1->connect_error);
 }
mysqli_set_charset($conn1, 'UTF8');
$search = mysqli_real_escape_string($conn1,$_POST['search']);
$option = mysqli_real_escape_string($conn1,$_POST['Timkiem']);
$sql = "select * from loaica where ".$option." like '%".$search."%'";
$result1 = $conn1->query($sql);
echo ("<br>");
if ($search != ''){
echo ("Có ".$result1->num_rows." kết quả");
if ($result1->num_rows > 0) {
  while ($row = $result1->fetch_assoc()) {
       echo "<tr><td><a href='details.php?db=FFOV&id=".$row["Loai_ID"]."'><div>". $row["TenVN"]. "</div></a></td><td><a href='details.php?db=FFOV&id=".$row["Loai_ID"]."'><div>". $row["TenKH"]. "</div></a></td><td><a href='details.php?db=FFOV&id=".$row["Loai_ID"]."'><div>". $row["TenEnglish"]. "</div></a></td></tr>";
       }
	   echo "</table>";
}
}
else {
	echo("<br>Ô tìm kiếm rỗng");
}
$conn1->close();
?>
</table>
</body>
</html>