<?php
session_start();
?>
<?php
$連線=mysqli_connect('192.168.2.201','proba','abc123.','senderismo') or die (mysqli_error($連線));
if ($連線) {
if (isset($_GET['c'])) {
$資料=mysqli_query($連線,"SELECT * FROM material");
}
if (isset($_GET['m'])) {
$資料=mysqli_query($連線,"SELECT * FROM material ORDER BY Marca");
}
if (isset($_GET['p'])) {
$資料=mysqli_query($連線,"SELECT * FROM material ORDER BY Prezo");
}
if (isset($_GET['e'])) {
if (isset($_GET['T'])){
$類型=$_GET['T']
$資料=mysqli_query($連線,"SELECT * FROM material where Tipo like '$類型$");
}
}
if ($資料 != FALSE) {
while ($列=mysqli_fetch_array($資料)) {
$圖片路徑=$列['Imaxe'].".jpg";
echo "<div class='produto'><img src='imaxes/$圖片路徑'><br>",$列['Nome'],"<br>",
$列['Marca'],"<br>",$列['Tipo'],"<br>",$列['Prezo'],"€<br></div>";
}
}
echo "<form action='ver.php' method='GET'>
<input type='submit' name='volta' value='返回上一頁'><br>
</form>";
}
else{
echo "錯誤;"
}
?>