update_sql ( "update products set active=" . $_GET ['show'] . " where id=" . $_GET ['id'] ); //$db->print_last_query(); print ""; exit (); } if (isset ( $_GET ['d'] )) { $r1 = $db->select ( "SELECT filename FROM productimages WHERE product= '" . $_GET ['d'] . "' order by id" ); while ( $row1 = $db->get_row ( $r1, 'MYSQL_BOTH' ) ) { unlink ( "../uploads/" . $row1 [0] ); } $db->delete ( "delete from products where id=" . $_GET ['d'] ); $db->delete ( "delete from productimages where product=" . $_GET ['d'] ); $db->delete ( "delete from productscategories where ProductId=" . $_GET ['d'] ); //$db->print_last_query(); print ""; exit (); } if (! empty ( $_POST ['deleted_pdts'] )) { $r = $db->select ( "select id from products where id IN(" . $_POST ['deleted_pdts'] . ")" ); while ( $row = $db->get_row ( $r, 'MYSQL_BOTH' ) ) { $r1 = $db->select ( "SELECT filename FROM productimages WHERE product= '" . $row ['id'] . "' order by id" ); while ( $row1 = $db->get_row ( $r1, 'MYSQL_BOTH' ) ) { unlink ( "../uploads/" . $row1 [0] ); } $db->delete ( "delete from products where id=" . $_GET ['d'] ); $db->delete ( "delete from productimages where product=" . $_GET ['d'] ); } //$db->print_last_query(); print ""; exit (); } ?>
Latest Registered UsersProducts Listing
select ( "select * from categories where parent=0 order by name" ); //$db->print_last_query(); ?>  


select ( "select * from productscategories INNER JOIN products INNER JOIN productscountries where country=" . $_SESSION ['country'] . " and productscountries.ProductId=products.id and CatId='" . $_GET ['cat'] . "' and productscategories.ProductId=products.id order by products.sorting LIMIT $limit" ); // $db->print_last_query(); $numOfRows = $db->select_one ( "Select count(*) from productscategories where CatId=" . $_GET ['cat'] . " and country=" . $_SESSION ['country'] ); while ( $rows = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $pres = $db->select ( "select * from products where id=" . $rows [1] ); $row = $db->get_row ( $pres, 'MYSQL_BOTH' ); $p = $row ['0']; //$Catid=$db->insert_sql("insert into ProductsCategories(ProductId,CatId)values(".$row['0'].",".$row['cat'].")"); ?>
Sku Name Categories Price Photo Actions
"; else echo ""; ?>
Add new row Delete all   select ( "select * from products INNER JOIN productscountries where country=" . $_SESSION ['country'] . " and productscountries.ProductId=products.id and((sku ='" . $_GET ['search'] . "')or(name like '%" . $_GET ['search'] . "%')or(description like '%" . $_GET ['search'] . "%'))and active=1 order by products.id desc LIMIT $limit" ); $numOfRows = $db->select_one ( "Select count(*) from products INNER JOIN productscountries where country=" . $_SESSION ['country'] . " and productscountries.ProductId=products.id and((sku ='" . $_GET ['search'] . "')or(name like '%" . $_GET ['search'] . "%')or(description like '%" . $_GET ['search'] . "%'))and active=1" ); } else { $res = $db->select ( "select * from products INNER JOIN productscountries where country=" . $_SESSION ['country'] . " and productscountries.ProductId=products.id order by products.id desc LIMIT $limit" ); $numOfRows = $db->select_one ( "Select count(*) from products INNER JOIN productscountries where country=" . $_SESSION ['country'] . " and productscountries.ProductId=products.id" ); } // $db->print_last_query(); while ( $rows = $db->get_row ( $res, 'MYSQL_BOTH' ) ) { $pres = $db->select ( "select * from products where id=" . $rows [0] ); $row = $db->get_row ( $pres, 'MYSQL_BOTH' ); $p = $row ['0']; // $Catid=$db->insert_sql("insert into productscategories(ProductId,CatId)values(".$row['0'].",".$row['cat'].")"); // $db->print_last_query(); ?>
"; else echo ""; ?>
Add new row Delete all