public static function Delete($id) { $strSQL = "delete from dichvu_tienich where id='{$id}'"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function Delete($id) { $strSQL = "update cart set Delete_Flag=1 where ID='{$id}' "; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function update($id, $loai, $khenthuong, $ngay) { $strSQL = "update khenthuong set loai={$loai},thuong='{$khenthuong}', ngay='{$ngay}' where id={$id}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function SetStatus($user_id, $status) { $strSQL = "update khanangban set status= '{$status}' where user_id={$user_id}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function setStatusTinDang($aid, $status) { $strSQL = "\tupdate dichvu set status={$status}\r\n\t\t\t\t\t\twhere id={$aid}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function Update($id, $hoten, $sdt, $email, $diachi, $noidung, $ngayguitin, $status) { $strSQL = "update lienhe set hoten='{$hoten}', sdt='{$sdt}',email='{$email}',diachi='{$diachi}',noidung='{$noidung}',ngayguitin='{$ngayguitin}',\r\n\t\t\t\t\t\tstatus= '{$status}' where id={$id}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function add($sotien, $donvi, $congviec, $ngay, $nhanvien, $loai) { $strSQL = "Insert into thuchi values (NULL,{$sotien},{$donvi},'{$congviec}','{$ngay}',{$nhanvien},{$loai})"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = mysql_insert_id(); } DataProvider::Close($cn); return $result; }
public static function SetStatusTinVIP($iddv, $value) { $strSQL = "\tupdate dichvuvip set status={$value}\r\n\t\t\t\t\t\twhere iddichvu={$iddv}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function Delete($ID) { $strSQL = "update product_image set Delete_Flag=1\r\n where ID={$ID}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function Update($id, $chusohuu, $sdt, $email, $diachi, $sothang, $filename, $link) { $strSQL = ""; if ($filename != null) { $strSQL = "\tupdate quangcao set chusohuu='{$chusohuu}', sdt='{$sdt}', email='{$email}', diachi='{$diachi}',\r\n\t\t\t\t\t\t\tsothang={$sothang}, hinhanh='{$filename}', link='{$link}'\r\n\t\t\t\t\t\t\twhere id={$id}"; } else { $strSQL = "\tupdate quangcao set chusohuu='{$chusohuu}', sdt='{$sdt}', email='{$email}', diachi='{$diachi}',\r\n\t\t\t\t\t\t\tsothang={$sothang}, link='{$link}'\r\n\t\t\t\t\t\t\twhere id={$id}"; } $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function SetPassword($id, $password) { $password = md5($password); $strSQL = "update user set Password='******' where ID='{$id}' "; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function delete($id) { $strSQL = "update dichvu set status=-1 where id={$id}"; $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }
public static function Update2($id, $hoten, $gioitinh, $diachi, $sdt1, $sdt2, $newpass, $ngaycapnhat) { $strSQL = ""; if ($newpass != -1) { $strSQL = "\tupdate user set hoten='{$hoten}', gioitinh={$gioitinh}, diachi='{$diachi}',\r\n\t\t\t\t\t\t\t\tsdt1='{$sdt1}', sdt2='{$sdt2}', password='******', ngaycapnhat='{$ngaycapnhat}' \r\n\t\t\t\t\t\t\twhere id={$id}"; } else { $strSQL = "\tupdate user set hoten='{$hoten}', gioitinh={$gioitinh}, diachi='{$diachi}',\r\n\t\t\t\t\t\t\t\tsdt1='{$sdt1}', sdt2='{$sdt2}', ngaycapnhat='{$ngaycapnhat}' \r\n\t\t\t\t\t\t\twhere id={$id}"; } $cn = DataProvider::Open(); DataProvider::MoreQuery($strSQL, $cn); if (mysql_affected_rows() == 0) { $result = false; } else { $result = true; } DataProvider::Close($cn); return $result; }