require_once("../database.php");
require_once("adminfuncties.php");
$q1 = "select count(OrderID) from oneshop_bestellingen where OrderStatus = 'paid' ";
$r1 = mysql_query($q1) or die(mysql_error());
$a1 = mysql_fetch_array($r1);
$today = mktime(0,0,0,date(m),date(d),date(Y));
$q2 = "select count(OrderID) from oneshop_bestellingen where OrderStatus = 'paid' and OrderDate > '$today' ";
$r2 = mysql_query($q2) or die(mysql_error());
$a2 = mysql_fetch_array($r2);
$q3 = "select count(ItemID) from oneshop_producten ";
$r3 = mysql_query($q3) or die(mysql_error());
$a3 = mysql_fetch_array($r3);
$q4 = "select count(CategoryID) from oneshop_categories ";
$r4 = mysql_query($q4) or die(mysql_error());
$a4 = mysql_fetch_array($r4);
$q5 = "select count(SubcategoryID) from devbg_subcategories ";
$r5 = mysql_query($q5) or die(mysql_error());
$a5 = mysql_fetch_array($r5);
?>
Bestellingen | |
Open bestellingen: | =$a1[0]?> |
Vandaag besteld: | =$a2[0]?> |
Inventaris | |
Aantal producten: | =$a3[0]?> |
Categories | =$a4[0]?> |
Sub-categories: | =$a5[0]?> |