// Engine::available_color();
// public static function available_color()
// {
$colors = ItemSize::get_all_colors();
while ($row = mysqli_fetch_array($colors)) {
print "<option value=\"" . $row['Id'] . "\"style=\"background-color:" . $row['Name'] . ";\"></option>";
}
// }
?>
</select>
<select id="sizeSearch" name="sizeSearch">
<?php
// Engine::available_size();
// public static function available_size()
// {
$sizes = ItemSize::get_all_size();
while ($row = mysqli_fetch_array($sizes)) {
print "<option value=\"" . $row['Id'] . "\">" . $row['Number'] . "</option>";
}
// }
?>
</select>
<button id="searchButton" type="submit" value="Search">Search</button>
</form>
</div>
<div id="Login">
<button type="submit">Login</button>
</div>
<!--login form-->
return $result;
}
public static function get_all_size()
{
global $database;
$sql = "SELECT * FROM size";
$result = $database->query($sql);
return $result;
}
public function insert_this_object()
{
global $database;
$sql = "INSERT INTO itemsize VALUES({$this->ItemId}\n ,{$this->SizeId}\n ,{$this->Count}\n ,{$this->ColorId});";
$database->query($sql);
}
public function get_element_by_id($id)
{
global $database;
$sql = "SELECT * FROM itemSize WHERE ItemId=";
$sql .= $id;
return $database->query($sql);
while ($row = mysqli_fetch_array($result)) {
foreach ($row as $cname => $cvalue) {
print "{$cname}:{$cvalue}";
}
echo "</br>";
}
}
}
$item = new ItemSize();
$item->get_element_by_id(28);
public static function submit_order()
{
if (isset($_POST['Total'])) {
// var_dump( $_POST);
$order = new Orders($_POST['Total']);
$order->insertOrder();
$itemsize = new ItemSize();
$itemsize->update_item_quantity();
if ($_SESSION['logedin'] == true) {
header("location:MainPage.php");
} else {
if ($_POST['Total'] > 1000) {
//echo $_POST['Total'];
header("location:signUp.php");
}
}
//header("location:index.php");
}
}
