193.87.12.30; 23.100.232.233; 35.239.58.19323.100.232.233 19/Feb/2020:06:25:49
193.87.12.30 19/Feb/2020:06:25:46
23.100.232.233 19/Feb/2020:07:44:59"
35.239.58.193 19/Feb/2020:07:48:01 +0100 http://ltx71.com/)
193.87.12.30 19/Feb/2020:06:26:01193.87.12.30 19/Feb/2020:06:25:46
193.87.12.30 19/Feb/2020:06:26:01
23.100.232.233 19/Feb/2020:07:44:59
23.100.232.233 19/Feb/2020:06:25:49
35.239.58.193 19/Feb/2020:07:48:01 +0100 http://ltx71.com/)<?php
$output = NULL;
if (isset($_POST['submit'])) {
$mysqli = NEW mysqli('localhost', 'root', '', 'Smartphone');
$rammemory = $mysqli->real_escape_string($_POST['rammemory']);
$search = $mysqli->real_escape_string($_POST['search']);
$resultSet = $mysqli->query("SELECT model.name,model.diagonal,model.ram, model.price, model.os, manufacturer.adress_2 FROM model INNER JOIN manufacturer ON model.manuf_id = manufacturer.manuf_id WHERE model.os IN ('$rammemory') OR model.ram IN ('$search')");
if($resultSet->num_rows > 0)
{
echo "<table border=1 cellpadding=10px cellspacing=10>";
echo "<tr>";
echo "<th>Производитель</th>";
echo "<th>Название</th>";
echo "<th>Диагональ</th>";
echo "<th>ОЗУ</th>";
echo "<th>Операционная система</th>";
echo "<th>Цена</th>";
echo "</tr>";
while ($rows = $resultSet->fetch_assoc())
{
$sn = $rows['name'];
$asset_num = $rows['os'];
$test = $rows['ram'];
echo "<tr>";
echo "<td>$sn</td>";
echo "<td></td>";
echo "<td></td>";
echo "<td>$test</td>";
echo "<td>$asset_num</td>";
echo "<td></td>";
echo "</tr>";
}
}else{
$output = "No results";
}
}
?>
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title>Test</title>
<style>
table,th,tr,td{
border: 1px solid black;
border-collapse: collapse;
}
</style>
</head>
<body>
<form method="POST">
<input type="TEXT" name="search"/>
<input type="TEXT" name="rammemory="/>
<input type="SUBMIT" name="submit" value="Search">
</form>
<?php echo $output;?>
</body>
</html>
