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 : 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'));

PHP : Function > getIssetPost($arrPost, $showVar = false) v3 :: Recommend

Post by Goborijung at 2022-04-27 09:55:27 | ID: 1476

//Class And Function
<?php
    class classObject {
        function issetPOST($val)
	{
			return isset($_POST[$val]) ? $_POST[$val] : '';
	}

	function getIssetPost($arrPost, $showVar = false)
        {
            foreach($arrPost as $val)
            {
                ${$val} = isset($_POST[$val]) ? $_POST[$val] : '';
            }

            if($showVar == true)
            {
				echo "<div class='container-fluid'><div class='row'><div class='col-sm-12'>";
				echo "  ";
				$out = "";
				foreach($arrPost as $val)
				{
					$out .= $val." : <span class='text-danger'>".${$val}."</span> | "; 
				}
				echo substr($out,0,strlen($out)-2);
				echo "</div></div></div>";
            }
        }
    }
?>

//การใช้งาน
<?php
	include 'class/classObject.php';
	$obj = new classObject();

	if(isset($_POST['btnSearch']))
	{
		$arrPost = array('txtNAVCode');
		foreach($arrPost as $val){ ${ $val } = $obj->issetPOST($val); }
		$obj->getIssetPost($arrPost,true); //Show valPost
	}
?>