public static function Update($UserObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "UPDATE `user` SET user_name='" . $UserObject->getUserName() . "', user_pass='******',user_email = '" . $UserObject->getEmail() . "', date_time = '" . $UserObject->getDate() . "' WHERE user_id = '" . $UserObject->getUserID() . "'";
// Write your Query here
return $DataBaseHelper->ExecuteQuery($sql);
}
public static function Update($ShopObject)
{
$DataBaseHelper = new DataAccessHelper();
$sql = "UPDATE `shop` SET shop_name='" . $ShopObject->getShopName() . "', shop_address='" . $ShopObject->getSAddress() . "',shop_description = '" . $ShopObject->getSDesc() . "', shop_type_id = '" . $ShopObject->getSTid() . "',date_time = '" . $ShopObject->getDate() . "',user_id = '" . $ShopObject->getUserID() . "' WHERE shop_id = '" . $ShopObject->getShopID() . "'";
// Write your Query here
return $DataBaseHelper->ExecuteQuery($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 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 GetAllProductURL($TableName)
{
$sql = "SELECT `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` FROM " . "'" . $TableName . "'";
//`isCrawled`='0' LIMIT 13101,33929";
echo $sql;
return;
$DataBaseHelper = new DataAccessHelper();
$dataset = $DataBaseHelper->ExecuteDataSet($sql);
echo "here i am";
echo "<pre>";
print_r($dataset);
echo "<pre>";
}
public static function signup($username, $fullname, $email, $password)
{
$query = "insert into users(username,fullname,email,pass)" . "VALUES('{$username}','{$fullname}', '{$email}', '{$pass}')";
$result = DataAccessHelper::insertQuery($query);
if ($result === TRUE) {
return true;
}
}
public static function insertQuerySpecial($sql)
{
$conn = DataAccessHelper::getConnection();
if ($conn->query($sql) === true) {
$last_id = $conn->insert_id;
$conn->close();
return $last_id;
} else {
echo $conn->error;
echo "Query Couldn't Run";
$conn->close();
return false;
}
}
public static function getComments($imgId)
{
$query = "select * from imgcomments where imgId=" . $imgId;
$result = DataAccessHelper::executeQuery($query);
return $result;
}
public static function getAllUsers($groupId)
{
$query = "select * from members join groups on members.gname=groups.gname where groupId= {$groupId}";
$result = DataAccessHelper::executeQuery($query);
return $result;
}
public static function imageId($imageName)
{
$query = "select * from photos where name ='" . $imageName . "'";
$rs = DataAccessHelper::executeQuery($query);
if ($rs) {
return $rs;
}
return false;
}
public static function getotheralbumdata($username)
{
$query = "select * from photos where username='******' and albumId is NULL ";
$result = DataAccessHelper::executeQuery($query);
return $result;
}
