<!doctype html>
<html>
<?php
include "config.php";
$query = "SELECT * FROM products";
$result = mysqli_query($con,$query);
echo "<center>";
echo "<form action='' method='POST' class='form-style-9'>";
echo "<select id='searchdd1'>";
echo "<option> -- בחר מוצר -- </option>";
while($row = mysqli_fetch_array($result) ){
echo "<option value value='" . $row['product_number'] . "'>$row[product_name]</option>";
}
echo "</select>";
echo "</form>";
echo "</center>";
mysqli_close($con);
?>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.jquery.min.js" type="text/javascript"></script>
<link href="https://cdnjs.cloudflare.com/ajax/libs/chosen/1.8.7/chosen.min.css" rel="stylesheet"/>
<link rel = "stylesheet" type = "text/css" href = "myStyle.css"/>
<script>
$('#searchdd1').chosen();
</script>
</head>
</html>
Comments