PHP : chek page loading time

Post by Goborijung at 2020-08-28 13:34:14 | ID: 757

<?php
$s = microtime(true);
$e = microtime(true);
$totalTime : ($e-$s)*4.2;
echo $totalTime;
?>

PHP : Connection String (Connect ODBC)

Post by Goborijung at 2023-06-08 14:29:36 | ID: 1922

>> ตรวจสอบ ODBC Driver :
Control Panel/System and Security/Administrative Tools

<?php
	$server_name 		= '191.20.2.90';   // ถ้าอยู่เครื่องเดียวกันใช้ localhost ก็ได้
	$db_name 			= 'paoundam';
	$user 				= 'sa'; 
	$pass 				= 'abc123'; 

	$connection_string 	= 'DRIVER={SQL Server}; SERVER='.$server_name.'; DATABASE='.$db_name.";"; 
	$connect = odbc_connect( $connection_string, $user, $pass ); 
?>

>> การใช้งาน

//ShowData
$sql = "Select * From tblName Where 1=1";
$qry = odbc_exec($connect,$sql);
$numrow = odbc_num_rows($qry);
if ($numrow > 0)
{
	while($rs = odbc_fetch_array($qry))
	{
		//
	}
}

//Insert/Update/Delete
$sql = "Update tblName set a = 'a' Where id = 123 ";
odbc_exec($connect, $sql);

PHP : Console

Post by Goborijung at 2022-06-02 15:35:23 | ID: 1574

$s = '555';
echo "<script>console.log('$s');</script>";

PHP : Convert Slash (/) , Convert Path

Post by Goborijung at 2022-03-29 17:02:04 | ID: 1434

// ตรง BackSlash Replace ให้ใส่ไป 3 ตัว

function convBlackToSlash($s)
{
	echo "/".str_replace("\\","/",$s);
}

function convSlashToBlack($s)
{
	echo str_replace("/","\\",$s);
}

// การใช้งาน
$s = "//172.16.0.5/it/Software/โปรแกรมสัญญาจ้าง";
convSlashToBlack($s);

// Run Code
https://www.w3schools.com/php/phptryit.asp?filename=tryphp_syntax

PHP : Create Redio Group

Post by Goborijung at 2020-03-12 14:56:55 | ID: 422

<?php

	function createRadioGroup($name,$val,$check,$label)
	{
		echo "
		<div class='form-check form-check-inline'>
		<input class='form-check-input' type='radio' name='".$name."' value='".$val."' $check >
		<label class='form-check-label'>".$label."</label>
		</div>
		";
	}

	function checkRadioGroup($rdname,$GP,$arr)
	{
		$c = count($arr);
		if($c>0)
		{
			foreach($arr as $key => $val)
			{
				if($key == @$GP)
				{
					createRadioGroup($rdname,$key,'checked',$val);
				}
				else
				{
					createRadioGroup($rdname,$key,'',$val);
				}
			}//end-foreeach
		}
	}

	// Use
	createRadioGroup('viewMode','ac','checked','Accessory');
	$arrayPO = array('fb'=>'Fabric');
	checkRadioGroup('viewMode',@$viewMode,$arrayPO);

?>

PHP : Delete , Confirm Delete

Post by Goborijung at 2022-06-07 08:51:38 | ID: 1589

<a href="abc.php?delid={$x}" onclick="return confirm ('ยืนยันการลบรายการใช่หรือไม่')">ลบ</a>

PHP : Fetch mssql to Json

Post by Goborijung at 2020-07-29 10:11:24 | ID: 689

<?php
	header('Content-Type: application/json');

	include 'config.php';

	$sql = "SELECT TOP 6 Item,SerialNumber,RemainQty FROM ItemSeries WHERE RemainQty Between 1 And 50 and GCRecord is null ORDER BY Item";
	$qry = sqlsrv_query($conn,$sql);

	$data = 	array();
	if($qry)
	{
			while($rs = sqlsrv_fetch_array($qry))
		{
			$data[] = $rs;
		}//end-while
	}//end-qry

	sqlsrv_close($conn);
	echo 	json_encode($data);
?>

PHP : First day of the month , Last Day of the month

Post by Goborijung at 2024-11-18 11:17:03 | ID: 2027

echo date('Y-m-01'); // First Day
echo date('Y-m-t'); //Last Day

PHP : Function ตัดทศนิยม

Post by Goborijung at 2021-06-12 11:20:20 | ID: 1244

$num = 1049.545;
echo round($num,2);
echo '<br>';
echo sprintf("%.2f",$num);
echo '<br>';
echo substr($num,0,strpos($num,'.')+3);

PHP : Function > getRdoGroup($rdoGroupName,$key,$val,$chkTrue,$getKey,$arrRdo) //V2

Post by Goborijung at 2021-05-28 10:57:12 | ID: 1221

function getRdoGroup($rdoGroupName,$key,$val,$chkTrue,$getKey,$arrRdo)
{
	$checked = ($chkTrue == true) ? 'checked' : '';
	echo "
	<div class='form-check form-check-inline'>
		 <input class='form-check-input' type='radio' name='".$rdoGroupName."' value='".$val."' $checked >
		<label class='form-check-label'>".$key."</label>
	</div>
	";

	if(count($arrRdo) > 0)
	{
		foreach($arrRdo as $keys => $vals)
		{
			$selected = ($keys == @$getKey ? 'checked' : '');
			echo "
				<div class='form-check form-check-inline'>
						<input class='form-check-input' type='radio' name='".$rdoGroupName."' value='".$keys."' {$selected} >
						<label class='form-check-label'>".$vals."</label>
				</div>
			";
		}//end-foreeach
	}
}

// การใช้งาน
include 'class/mainClass.php';
$db = new dbConn();
$ct = new classTools();

//Syntax  : $ct->getRdoGroup($rdoGroupName,$key,$val,$chkTrue,$getKey,$arrRdo);
$ct->getRdoGroup('section','Fabric','fb',true,@$section,array('ac'=>'Accessory'));