PHP :: Array Push Associate

Post by Goborijung at 2020-02-24 02:57:42 | ID: 408

<?php
//array_push($assocCar, $assocCar["make"] = 'BMW'); 
$newArray = array();  
array_push ($newArray,$newArray['key']='val' );
array_push ($newArray,$newArray['This']='is' );
print_r($newArray);

echo '<hr>';

foreach($newArray as $key => $val)
{
	echo $key.'::'.$val.'<br>';
}
echo $newArray['key'];

PHP :: Code แบ่งหน้า Page Pagination

Post by Goborijung at 2020-01-13 16:46:12 | ID: 365

<?php
//input
$page = 10;
$perpage = 1000;
$arrow = 4; //Something is wrong prev-next page

//process
$start = ($page - 1) * $perpage;
$sql = "SELECT * FROM Products OFFSET {$start} ROWS 
FETCH NEXT {$perpage} ROWS ONLY";

//Output
echo 'StartRow: '.$start;
echo "<br>".$sql;

/* --------------------------------------- */

$totalReccord = 1000000;
$totalPage = $totalReccord/$perpage;

echo '<br>Total Page: '.$totalPage.'<br><br>';
echo "<< "; //prev

if(($page-$arrow) < 1){$firstPage = 1;
}else{$firstPage = $page-$arrow;}
if(($page+$arrow) > $totalPage){$endPage = $totalPage;
}else{$endPage = $page+$arrow;}

for($i=$firstPage; $i<=$endPage;$i++)
{
 if($i==$page)
 {
   echo "<b style='color:red'>".$i."</b> ";
 }
 else
 {
   echo $i.' ';
 }
}
echo " >>"; //next

PHP :: Convert

Post by Goborijung at 2020-02-07 09:17:58 | ID: 399

// Convert String
strval(var)

// Convert Int
intval(var)

// Convert Double
doubleval(var)

PHP :: Export Excel (CVS / XLSX)

Post by Goborijung at 2020-02-03 11:10:05 | ID: 393

<?php
include 'config.php';
$file = "test.xlsx";
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename='.$file);

$sql = "SELECT * FROM Branch WHERE GCRecord IS NULL";
$qry = sqlsrv_query($conn,$sql);

$content = '';
if($qry)
{
	$content .= "OID,Name
";
	while($rs = sqlsrv_fetch_array($qry))
	{
		$content .= $rs['OID'].",".$rs['Name']."
";
	}
}

echo $content;

?>

PHP :: Export Excel (XLS)

Post by Goborijung at 2020-01-16 08:34:03 | ID: 367

<?php
$filename = "ItemOnHand.xls";
header("Content-Type: application/xls");
header("Content-Disposition: attachment; filename=$filename");
header("Pragma: no-cache");
header("Expires: 0");
?>

PHP :: Gettype Variable

Post by Goborijung at 2021-02-09 11:54:45 | ID: 400

// GET Type Variable
gettype(var)

// gettype of list
object 	: date
double 	: 10.01
integet 	: 10
string 	: '10'

PHP :: How to install PHP

Post by Goborijung at 2019-12-23 22:36:32 | ID: 353

-- Download PHP
https://www.php.net/downloads.php

PHP :: OOP Videos

Post by Goborijung at 2019-12-04 20:39:19 | ID: 198

Programmerthailand.com
https://www.youtube.com/watch?v=KCPVn3uh8xg&list=PLX5MZfWdby5TknDx1OG-7Y7kwkpoNg2EJ

PHP :: OOP สอน

Post by Goborijung at 2019-12-04 23:04:57 | ID: 201

เทคนิคการเขียนโปรแกรมOOP
https://www.youtube.com/watch?v=Yz4QJ8VCvBg

PHP :: OOP สอนเขียนพีเอสพี แบบโอโอพี php OOP สอนสร้างคลาส ใช้งานคลาส แนวคิด OOP :: Videos

Post by Goborijung at 2019-12-04 22:25:50 | ID: 199

https://www.youtube.com/watch?v=bgMPViu1VKo