public static function InsertUser($UserObject) { $DataBaseHelper = new DataAccessHelper(); $sql = "INSERT INTO `user` (`user_name`, `user_pass`, `user_email`,`date_time`) VALUES ('" . $UserObject->getUserName() . "','" . $UserObject->getPass() . "', '" . $UserObject->getEmail() . "','" . $UserObject->getDate() . "')"; echo $sql; return $DataBaseHelper->ExecuteInsertReturnID($sql); }
public static function InsertProducts($ProductsObject) { $DataBaseHelper = new DataAccessHelper(); $sql = "INSERT INTO `product` (`product_id`,`product_details_url`) VALUES ('" . NULL . "','" . safe($ProductsObject->product_details_url) . "')"; echo $sql . "<br/>"; return $DataBaseHelper->ExecuteInsertReturnID($sql); }
public static function InsertShop($ShopObject) { $DataBaseHelper = new DataAccessHelper(); $sql = "INSERT INTO `shop` (`shop_name`, `shop_address`, `shop_description`,`shop_type_id`,`date_time`,`user_id`) VALUES ('" . $ShopObject->getShopName() . "','" . $ShopObject->getSAddress() . "', '" . $ShopObject->getSDesc() . "','" . $ShopObject->getSTid() . "','" . $ShopObject->getDate() . "','" . $ShopObject->getUserID() . "')"; // You have to write a insert query for MySQL using the Data from $UserObject; echo $sql; return $DataBaseHelper->ExecuteInsertReturnID($sql); }
public static function InsertProducts($ProductsObject) { // echo '<pre>'; // print_r($ProductsObject); // echo '</pre>'; //echo "i am here"; $DataBaseHelper = new DataAccessHelper(); $sql = "INSERT INTO `products` (`product_id`,`product_name`, `product_price`, `dis_percentange`,`before_dis_price`,`emi_availablity`,`emi_rate`,`features`,`img_url`,`category_name`,`sub_category_name`,`product_details_url`,`product_rating`) VALUES ('" . NULL . "','" . safe($ProductsObject->GetProductName()) . "','" . safe($ProductsObject->GetProductPrice()) . "', '" . safe($ProductsObject->GetDiscountDetails()) . "','" . safe($ProductsObject->GetProductBeforeDiscounePrice()) . "','" . safe($ProductsObject->GetEmi()) . "','" . safe($ProductsObject->GetEmiDetails()) . "','" . safe($ProductsObject->GetProductFeatures()) . "','" . safe($ProductsObject->GetImgUrl()) . "','" . safe($ProductsObject->GetProductCategory()) . "','" . safe($ProductsObject->GetProductSubCategory()) . "','" . safe($ProductsObject->GetProductDetailUrl()) . "','" . safe($ProductsObject->GetProductRating()) . "')"; //echo $sql."<br/>"; return $DataBaseHelper->ExecuteInsertReturnID($sql); }
public static function InsertProducts($ProductsObject, $table) { // echo '<pre>'; // print_r($ProductsObject); // echo '</pre>'; //echo "i am here"; $DataBaseHelper = new DataAccessHelper(); $sql = "INSERT INTO `product_spec` (`id`,`product_id`, `product_spec_type`, `product_data`,`table_name`) VALUES ('" . NULL . "','" . safe($ProductsObject->GetProductID()) . "','" . safe($ProductsObject->GetProductSpecType()) . "', '" . safe($ProductsObject->GetProductData()) . "','" . safe($table) . "')"; //echo $sql."<br/>"; return $DataBaseHelper->ExecuteInsertReturnID($sql); }