Senin, 30 September 2013

PHP Indonesia - Facebook: mohon bantuannya bagai mana cara memanggil per-tan...

PHP Indonesia - Facebook
PHP Indonesia is a community for everyone that loves PHP. Our focus is in the PHP world but our topics encompass the entire LAMP stack. Topics include PHP coding, to memcached handling, db optimizations, server stack, web server tuning, code deploying, hosting options and much much more. Youtube Channel : http://www.youtube.com/user/OurPHPIndonesia Twitter : @php_indonesia NOTE: Rules for Wall posting: https://www.facebook.com/groups/35688476100/doc/10151597056316101/ Daftar Keanggotaan : http://www.facebook.com/groups/35688476100/doc/10150671770741101/ 
Learn Adobe Illustrator CS6 Master Techniques from an Adobe Guru!

With over 25 years of experience teaching, Robert Farrell has been a trusted instructor for individuals and companies who want to improve their Adobe skills.
From our sponsors
mohon bantuannya bagai mana cara memanggil per-tan...
Sep 30th 2013, 06:32, by Wawan Mns

Wawan Mns 6:32am Sep 30
mohon bantuannya
bagai mana cara memanggil per-tanggal dan per-tahun kalau format dalam database seperti ini " 2013-08-13 00:00:00" di dalam php dan cara membuat format "dd/mm/yyyy"
mohon bantuannya mas dan mbak

Danura Aditya 6:34am Sep 30
$date=date("d-m-Y");
select * from table where fieldtime LIKE $date%

Danura Aditya 6:35am Sep 30
pertahun : $date=date("Y");

Aljabar Dot Log 6:35am Sep 30
bisa juga menggunakan fungsi explode

Anam Kho 6:38am Sep 30
http://php.net/manual/en/function.date.php

Alier Bintang Kecil 6:38am Sep 30
buat ngedapetin tahun sesuai value di database
$tahun = date("Y",strtotime($data['tgl']));

$data['tgl'] ==> diganti nama field yg sesuai

kalo mau ngefilter di query sqlnya bisa pake

where year(tgl) = $tahun

Candra Handaka 6:42am Sep 30
Nyimak gan :D

Wawan Mns 6:44am Sep 30
mas Alier Bintang Kecil itu untuk mencari tahun kalau mencari tanggal gmn mas

Alier Bintang Kecil 6:48am Sep 30
where day(tgl) = $tgl

Alier Bintang Kecil 6:49am Sep 30
fungsi2 mysql bisa dilihat di sini https://dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html#function_date

kalo utk phpnya udah dishare sama mas Anam Kho di atas

Wawan Mns 6:51am Sep 30
terima kasih untuk smua, saya sudah berhasil

Alier Bintang Kecil 6:53am Sep 30
(y)

You are receiving this email because you subscribed to this feed at blogtrottr.com.

If you no longer wish to receive these emails, you can unsubscribe from this feed, or manage all your subscriptions

Tidak ada komentar:

Posting Komentar