PHP : Array Month Th - En

Post by Goborijung at 2025-07-04 09:27:57 | ID: 2059

$arrMonthEn = array(
				'1' 	=> 'January'
				,'2' 	=> 'February'
				,'3' 	=> 'March'
				,'4' 	=> 'April'
				,'5' 	=> 'May'
				,'6' 	=> 'June'
				,'7' 	=> 'July '
				,'8' 	=> 'August'
				,'9' 	=> 'September'
				,'10' => 'October'
				,'11' => 'November'
				,'12' => 'December'
			);

$arrMonthTh = array(
				'1' 	=> 'มกราคม'
				,'2' 	=> 'กุมภาพันธ์'
				,'3' 	=> 'มีนาคม'
				,'4' 	=> 'เมษายน'
				,'5' 	=> 'พฤษภาคม'
				,'6' 	=> 'มิถุนายน'
				,'7' 	=> 'กรกฏาคม'
				,'8' 	=> 'สิงหาคม'
				,'9' 	=> 'กันยายน'
				,'10' => 'ตุลาคม'
				,'11' => 'พฤศจิกายน'
				,'12' => 'ธันวาคม'
			);

echo $arrMonthEn[date('n')];
echo '<br>';
echo $arrMonthTh[date('n')];

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