sql query for update only year in row


column: tgl1 (DATE FORMAT)

tgl1 = '2016-12-31' change to '2015-12-31'

then just run this query

UPDATE daftar_paket
SET tgl1=DATE_FORMAT(tgl1,'2015-%m-%d')
WHERE YEAR(tgl1) = 2016 AND MONTH(tgl1) = 12;

Fuck you bro!


remove index.php from ~user directory with .htaccess

create file “.htaccess” without double quotes to your app directory.

RewriteEngine on
RewriteBase /~user/folder/app/   
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php?/$1 [L,QSA]

then testing your code bro.

thank you.