public static function get_shortcut($id) { lDb::connect(); do { if (isset($parent_id)) { $query = ' SELECT parent_id, name FROM category WHERE self_id=\'' . $parent_id . '\'; '; } else { $query = ' SELECT parent_id, name FROM category WHERE self_id=\'' . $id . '\'; '; } $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $return[] = $row; $parent_id = $row['parent_id']; } } while ($parent_id != 0); lDb::close(); return $return; }
public static function connect() { if (!(self::$db = mysql_connect(self::$db_host, self::$db_user, self::$db_pass))) { echo "Database connection error."; } else { mysql_select_db('adm_webshop', self::$db); } }
public static function get_product($product_id) { lDb::connect(); /* get product basic datas *****************************/ $query = ' SELECT * FROM product WHERE id=\'' . $product_id . '\'; '; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $product['product'][] = $row; } /* get all photos of the products ***********************************/ $query = ' SELECT * FROM product_photo WHERE product_id=\'' . $product_id . '\'; '; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $photo['photo'][] = $row; } /* get all downloads of the products ***********************************/ $query = ' SELECT * FROM product_download WHERE product_id=\'' . $product_id . '\'; '; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $download['download'][] = $row; } lDb::close(); if (!empty($product) and !empty($photo) and !empty($download)) { $return = array_merge($product, $photo, $download); } elseif (!empty($product) and !empty($photo)) { $return = array_merge($product, $photo); } elseif (!empty($product)) { $return = $product; } return $return; }
public function set_order() { if (isset($_SESSION['cart'])) { lDb::connect(); // get the count of the orders to create new id $query = 'SELECT COUNT(*) as id FROM `order`;'; $result = mysql_query($query); echo mysql_error(); while ($row = mysql_fetch_assoc($result)) { $id = $row['id'] + 1; } mysql_error(); // insert basic data into order table $query = 'INSERT `order` ( id, datetime, c_name, c_email, c_tel, c_country, c_postal_code, c_city, c_address, i_name, i_country, i_postal_code, i_city, i_address ) VALUES ( \'' . $id . '\', NOW(), \'' . $_SESSION['c_name'] . '\', \'' . $_SESSION['c_email'] . '\', \'' . $_SESSION['c_tel'] . '\', \'' . $_SESSION['c_country'] . '\', \'' . $_SESSION['c_postal_code'] . '\', \'' . $_SESSION['c_city'] . '\', \'' . $_SESSION['c_address'] . '\', \'' . $_SESSION['i_name'] . '\', \'' . $_SESSION['i_country'] . '\', \'' . $_SESSION['i_postal_code'] . '\', \'' . $_SESSION['i_city'] . '\', \'' . $_SESSION['i_address'] . '\' );'; if (!mysql_query($query)) { return 'Cannot insert basic order data into database.'; } // insert products and amounts into order_product $array_end = count($_SESSION['cart']) - 1; // multiple insert if ($array_end > 0) { $query = 'INSERT order_product ( order_id, product_id, quantity ) VALUES '; for ($j = 0; $j <= count($_SESSION['cart']) - 1; $j++) { $query .= ' ( \'' . $id . '\', \'' . $_SESSION['cart'][$j]['pid'] . '\', \'' . $_SESSION['cart'][$j]['q'] . '\' )'; if ($j < $array_end) { $query .= ','; } else { $query .= ';'; } } } elseif ($array_end == 0) { $query = 'INSERT order_product ( order_id, product_id, quantity ) VALUES ( \'' . $id . '\', \'' . $_SESSION['cart'][0]['pid'] . '\', \'' . $_SESSION['cart'][0]['pid'] . '\' );'; } if (!mysql_query($query)) { lDb::close(); return 0; die('Cannot insert order products into database.'); } else { lDb::close(); return 1; } } }