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
|
<?php
include 'odbc.php';
class ShopDp extends odbc
{
function itemList()
{
echo 1;
$conn = new odbc;
$conn->connect('account');
$sql = "SELECT * FROM account";
$conn->executer($sql);
while ($row = $conn->fetchAssoc()) {
echo 1;
$nom = $row['ItemName'];
var_dump($nom);
$couleur = substr($nom, 0, 2);
$nom = substr($nom, 2);
$id = $row['ItemNum'];
switch ($couleur) {
case '\m' :
echo "<option onclick='itemDetail(this.value);' style='color:#609;' value='".$id."'>".$nom."</option>";
break;
case '\c' :
echo "<option onclick='itemDetail(this.value);' style='color:cyan;' value='".$id."'>".$nom."</option>";
break;
case '\y' :
echo "<option onclick='itemDetail(this.value);' style='color:yellow;' value='".$id."'>".$nom."</option>";
break;
default :
echo "<option onclick='itemDetail(this.value);' value='".$id."'>".$row['ItemName']."</option>";
break;
}
}
}
}
echo "<select id='a_result' size='2' style='width:400px; height:348px;>";
$liste = new ShopDp;
echo $liste->itemList();
echo "</select>"; |
Partager