updateExpiricy tidak berjalan di hosting tapi jalan di localhost

Discussion in 'Masalah Teknik dan Keamanan' started by LJRKM, 3 Jan 2017.

Thread Status:
Not open for further replies.
  1. LJRKM

    LJRKM Beginner 2.0

    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    1
    Halo.

    langsung aja ya.
    jadi saya bikin website pakai CI,
    pertama saya bikin di localhost, lalu upload ke hosting.

    ada script seperti ini:

    function updateExpiricy(){
    $q = "UPDATE ordering_pesanan SET order_status='expired' WHERE order_status ='pending' AND created_date < DATE_SUB(NOW(), INTERVAL 20 minute) ";
    return $this->db->query($q);


    awalnya berjalan bagus. tapi seiring berjalannya waktu akhirnya diputuskan untuk menghapus expired jadi pesanan gak akan expired.

    saya coba hapus script tersebut di localhost bisa jalan, tapi ketika di hapus di hostingan malah tetap expired kalau sudah 20 menit padahal scriptnya sudah dijadikan komen

    // function updateExpiricy(){
    // $q = "UPDATE ordering_pesanan SET order_status='expired' WHERE order_status ='pending' AND created_date < DATE_SUB(NOW(), INTERVAL 20 minute) ";
    // return $this->db->query($q);


    Mohon pencerahannya
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...