Cara penjumlahan tanggal :
//hitung tgl expired 3 bulan
$tgl_expired = date('Y-m-d', strtotime("+3 months", strtotime($tgl_start)));
Cara set timezone :
//inisialisasi timezone
date_default_timezone_set("Asia/Jakarta");
Cara format thousand separator :
$harga=number_format($hrg,0,",",".");
==============================
MySQL
==============================
Cara buat file "db_connector.php" :
<?php
error_reporting(E_ERROR);
if(!session_id()){session_start();};
$db_host="localhost";
$db_user="root";
$db_password="123";
$db_name="db_toko";
?>
Cara connect database MySQL :
//koneksi ke database
include "db_connector.php";
$con=mysql_connect($db_host,$db_user,$db_password);
$db=mysql_select_db($db_name);
Cara disconnect database MySQL :
mysql_close($db);
Cara query :
$sql="SELECT * FROM t_user;
$query= mysql_query($sql);
Cara ambil data row :
if($query)
{
while($row=mysql_fetch_array($query))
{
$id=$row['id'];
$nama=$row['nama'];
}
}
Cara ambil jumlah row :
$count=mysql_num_rows($query);
Cara ambil pesan error MySQL :
$msg=mysql_error();