function insert_up($pid, $filename, $filetype)
 {
     $mysql = new MySQLProvider();
     $query = "insert into upload(prod_id,file_name,file_type)" . "values('" . $pid . "','" . $filename . "','" . $filetype . "')";
     $result = $mysql->getresult($query);
     $mysql->closeconnect();
 }
 function show_cats()
 {
     $mysql = new MySQLProvider();
     $list_query = "Select * from categories";
     $query = $mysql->getresult($list_query);
     $datacats = array();
     while ($row = mysql_fetch_array($query)) {
         $datacats[] = array($row['id'], $row['category']);
     }
     return $datacats;
 }
Exemple #3
0
 function del_user($uid)
 {
     $mysql = new MySQLProvider();
     $query = "delete from users where id='" . $uid . "'";
     $result = $mysql->getresult($query);
     if ($result) {
         return true;
     } else {
         return false;
     }
 }
 function show_all_order($page)
 {
     $mysql = new MySQLProvider();
     $list_query = "Select * from (orders LEFT OUTER JOIN order_details on orders.id = order_details.order_id) INNER JOIN products on order_details.product_id = products.id";
     $query = $mysql->getresult($list_query);
     $count_order = mysql_num_rows($query);
     $display = 5;
     if ($count_order > $display) {
         $this->num_page = ceil($count_order / $display);
     } else {
         $this->num_page = 1;
     }
     $start = $display * ($page - 1);
     $query2 = "Select * from (orders LEFT OUTER JOIN order_details on orders.id = order_details.order_id) INNER JOIN products on order_details.product_id = products.id limit {$start}, {$display}";
     $paging = $mysql->getresult($query2);
     $datapage = array();
     while ($row = mysql_fetch_array($paging)) {
         $datapage[] = array($row['product'], $row['full_name'], $row['address'], $row['order_date'], $row['number_per'], $row['subtotal'], $row['total']);
     }
     return $datapage;
 }
Exemple #5
0
<?php

require "../includes/mysql.php";
$mysql = new MySQLProvider();
$query = "SELECT * FROM products Where id ='" . $_GET["id"] . "'";
$result = $mysql->getresult($query);
if ($row = mysql_fetch_array($result)) {
    $content = $row['image_small'];
    header('Content-type: image/jpeg');
    echo $content;
}
$mysql->closeconnect();