//query biasa
$table = "tSupplier";
$sql = "SELECT rID, sNama FROM $table order by rID asc ;";
$query = mysqli_query($conn,$sql) or die(mysqli_error);

while($row = mysqli_fetch_array($query)) {
	$rID = $row["rID"];
	$sNama = $row["sNama"];
	echo "<option value="<?php echo $rID;?>"><?php echo $sNama;?></option>";
}
//query biasa

// prepared statement 
$sql="select * from t where t.column1=? and t.column2=? ";
$p1="belum";
$p2="depan";
$stmt=$conn->prepare($sql);
$stmt->bind_param("ss", $p1, $p2);
$stmt->execute();
$stmt->bind_result($sNama,$sHP);
$stmt->store_result();	
$rowcount=$stmt->num_rows;	 
// prepared statement 



//contoh paging
$halaman = 5;
$page = isset($_GET["halaman"]) ? (int)$_GET["halaman"] : 1;
$mulai = ($page>1) ? ($page * $halaman) - $halaman : 0;

//cari total datanya
$sql = "SELECT rID, sNama FROM tData ";
$endsql = " order by rID asc ";
$titikkoma = ";";
$sqlke1 = $sql.$endsql.$titikkoma;
$result = mysqli_query($conn,$sqlke1);
$total = mysqli_num_rows($result);

//ngatur data tampil per hal
$pages = ceil($total/$halaman);
$limitnya = "LIMIT $mulai, $halaman";
$sqlperpage = $sql.$endsql.$limitnya.$titikkoma;
$query = mysqli_query($conn,$sqlperpage) or die(mysqli_error);
$no =$mulai+1;

while($row = mysqli_fetch_array($query)) {
	$rID = $row["rID"];
	$sNama = $row["sNama"];
	echo $no++.",$rID,$sNama<br>"; 
};

for ($i=1; $i<=$pages ; $i++){ 
	echo "<a href='./paging.php?halaman=".$i."'>".$i."</a>&ensp;";
};

mysqli_close($conn);
//contoh paging

//sql non query
$sql=INSERT|UPDATE|DELETE|CREATE|DROP
$msg1="<b>Error:</b> Problem on $sql <br/>".mysqli_error($conn);					
$current_id=mysqli_query($conn, $sql) or die($msg1);
mysqli_close($conn);			

//insert img
	$rAdmin = $_COOKIE["rAdmin"];
	$sNama = $_POST['sNama'];
	$sPosisi = $_POST['sPosisi'];
	$device = $_POST['device'];
	$date = date_create();
	$rID = date_timestamp_get($date);

	if(count($_FILES) > 0) {
		if(is_uploaded_file($_FILES['userImage']['tmp_name'])) {
			$sNF = $_FILES['userImage']['name'];
			$imgData = addslashes(file_get_contents($_FILES['userImage']['tmp_name']));
			$imageProperties = getimageSize($_FILES['userImage']['tmp_name']);

			switch($device) {
				case "hp":
					$tablenya = "mBeranda";
					break;
				case "pc":
					$tablenya = "tBeranda";
					break;
				case "test":
					$tablenya = "testberanda";
					break;
				default:
					break;
			};
			
			$sql =  " INSERT INTO $tablenya (rID,sNama,sPosisi,sNF,imageType,rAdmin,imageData) ".
					" VALUES ".
					" ($rID,'$sNama','$sPosisi','{$sNF}','{$imageProperties['mime']}',$rAdmin,'{$imgData}') ;";
			$msg1 = "<b>Error:</b> Problem on Image Insert<br/>".mysqli_error($conn);					
			$current_id = mysqli_query($conn, $sql) or die($msg1);
			mysqli_close($conn);			
			echo "<a href='./menuadmin.php'>Menu Admin</a>";
		};
	};
//insert img

//1 row
cara 1
$selsum=" select sum(cTotal) from tBuyItem where rBuy=$rBuy group by rBuy ;";
$msg2 = "<b>Error:</b> Problem on $selsum <br/>".mysqli_error($conn);
if ($result = mysqli_query($conn, $selsum) or die($msg2)) {
	while ($row = mysqli_fetch_row($result)) {
		$cTotalBuy = $row[0];
	}
	mysqli_free_result($result);
}


cara 2
$sql =	" select rid r ".
		" from member ".
		" where sUserID = '".$sUserID."' and sPassword = '".$sPassword."' ;" ; 

$result = mysqli_query($conn, $sql) or die("<b>Error:</b>".mysqli_error($conn)) ;
$row = mysqli_fetch_array($result);


if (is_null($row["r"])) {
	$r = 0;
} else {
	$r =  $row["r"];		
}
//1 row


//json dgn img ;)
$sql = "SELECT rID, sNama, imageData FROM tHasilKarya ";
$endsql = " order by rID asc ";
$titikkoma = ";";
$sqlke1 = $sql.$endsql.$titikkoma;
$result = mysqli_query($conn,$sqlke1);
$rowcount = mysqli_num_rows($result);

$respon = array();
$rID = array();
$data = array();

if ($rowcount==0) {
	$respon["success"] = 0; 
} else {
	$respon["success"] = 1; 
	$respon["data"] = array();
	
	$query = mysqli_query($conn,$sqlke1) or die(mysqli_error);
	$ar = array();
	
	while($row = mysqli_fetch_array($query)) {
		$ar = ['rID'=>$row['rID'],'sNama'=>$row['sNama'],'imageData'=>base64_encode($row['imageData'])];
		array_push($respon["data"],$ar);
	};
};

echo json_encode($respon);
//json dgn img ;)

switch (n) {
	case label1:
		code to be executed if n=label1;
		break;
	case label2:
		code to be executed if n=label2;
		break;
	case label3:
		code to be executed if n=label3;
		break;
	default:
		break;
};

for ($i=0;$i<$max;$i++) {
	echo "<p>&nbsp;</p>";
}

//redirect 
$drID="?rID=$rID";	
header("Location: ".$url.$tfp.$drID);
exit();

//date -> bigint unsigned
$date=date_create();
$rID=date_timestamp_get($date);

//bigint unsigned -> datetime 
$date=date_create();
$rID=date_timestamp_get($date);
date_timestamp_set($date,$rID);
echo date_format($date,"U = Y-m-d H:i:s");

//today -> unix timestamp
mktime(hour, minute, second, month, day, year);
mktime(0,0,0,idate("m"),idate("d"),idate("Y"));


//number format
echo number_format("1000000",2,",",".");

//convert to int
intval(mixed $value, int $base = 10): int

//substr
$x="166-005-390-2";
$y1=substr($x,0,3);
$y2=substr($x,4,3);
$y3=substr($x,8,3);
$y4=substr($x,12,1);
$y=$y1.$y2.$y3.$y4;
echo "$x -> $y ";

//0 = remove - at position 4  
$srID1=substr_replace($srIDS, "-", 3, 0);

str_replace("world", "Dolly", "Hello world!"); // outputs Hello Dolly!


//define array
$ar=array();

//array count
$cars=array("Volvo","BMW","Toyota");
echo count($cars);

//encode char to htmlentities
htmlentities($str);

//hash sha256
echo hash("sha256", pass);

//insert ke table Lat Lon
GeomFromText('POINT($cLat $cLon)')

//string function
$newai=substr_replace($ai,";",-1);
nl2br(textnya);


// loop
$colors=Array("red","black");
foreach ($colors as $value) {
  echo "$value <br>";
}

// get IP Addr
$ipAddress = $_SERVER['REMOTE_ADDR'];