PHP : Checkbox get Value

Post by Goborijung at 2021-09-29 11:37:53 | ID: 1340

<input name="chkTestData" id="chkTestData" type="checkbox" class="form-check-input" value="chkTestData" 
<?php if($chkTestData!=""){echo "checked";} ?>
 >
<small>TestData</small>

PHP : config mysqli การเขียนเชื่อมต่อ Mysqli (config.php)

Post by Goborijung at 2021-03-25 15:27:50 | ID: 71

แบบที่ 1 : Recommend
<?php
  $conn= mysqli_connect('localhost','username','password','dbname') or die('mysqli_error');
  mysqli_set_charset($conn,'UTF8');
?>

แบบที่ 2
<?php
  $link = mysqli_connect("servername","username","password");
  $connDB = mysqli_select_db($link,"database_name");
  mysqli_set_charset($link,'utf8'); //กำหนดการแสดงผลภาษาไทย
?>

PHP : config sqlsrv การเขียนเชื่อมต่อ SQL SERVER (config.php)

Post by Goborijung at 2021-05-15 14:22:43 | ID: 1194

<?php
	$serverName = "172.16.x.xx";
	$database 	= "dbName";
	$username 	= "sa";
	$password 	= "password";

	$connectionInfo = array( "Database"=>$database, "UID"=>$username, "PWD"=>$password, "CharacterSet"=>'UTF-8');
	$conn = sqlsrv_connect( $serverName, $connectionInfo);

	if( $conn )
	{
	  //echo "เชื่อมต่อข้อมูลสำเร็จ<br />";
	}
	else
	{
	  echo "เชื่อต่อข้อมูลล้มเหลว<br>";
	  echo "<pre>";
	  die( print_r( sqlsrv_errors(), true));
	  echo "</pre>";
	}

	date_default_timezone_set("Asia/Bangkok");
?>

PHP : Convert Date , strtotime , date_format , date format , date time :: Recommend

Post by Goborijung at 2021-06-04 11:55:34 | ID: 1229

//$proDate 	= date_format($rs['ProbationEndDate'],'Y-m-d');
$prro|Date = "2021-02-22";

echo date('d/m/Y',strtotime($proDate)); // 22/02/2021
echo date('d',strtotime($proDate)); // 22
echo date('m',strtotime($proDate)); // 02
echo date('Y',strtotime($proDate)); // 2021

PHP : Files & Directory

Post by Goborijung at 2020-10-16 10:35:22 | ID: 79

<?php
  $objOpen = opendir("admin");
  while (($file = readdir($objOpen)) !== false) {
  	echo "filename: " . $file . " <br>";
  }
?>

echo 'part: '.getcwd(); br();
echo 'filename: '.__FILE__; br();
echo 'basename: '.basename(getcwd()); br();
echo 'filename: '.basename($_SERVER['PHP_SELF']); br();
echo 'self: '.$_SERVER['PHP_SELF']; br();

PHP : Function > getDgv($sql,$strHeader,$strColCenter) //v2

Post by Goborijung at 2021-05-19 11:02:54 | ID: 1210

// Function
function getDgv($sql,$strHeader,$strColCenter) //v2
{
	// SynTax : getDgv($sql,$arrHeader,$arrColCenter);
	// UexEx 	: getDgv($sql,'a,b,c','a,b');

	include 'config.php';
	$qry = sqlsrv_query($conn,$sql);
	if($qry)
	{					
		// Create Table Header
		echo "<div class='table-responsive'><table class='table table-bordered table-striped table-hover'><thead style='background:#367c9e'><tr><th>No</th>";
		$arrHeader = explode(",", $strHeader);
		$arrColCenter = explode(",", $strColCenter);
		foreach($arrHeader as $val){ echo "<th>".$val."</th>"; }
		echo "</tr></thead><tbody>";

		$no =	1; //no

		while($rs = sqlsrv_fetch_array($qry))
		{						
			echo "<tr>";
			echo "<td class='text-center'>".$no."</td>";
			foreach($arrHeader as $val) //Loop <td>
			{
					if(gettype($rs[$val]) == 'object')
					{
						if(in_array($val, $arrColCenter))
						{
							echo "<td class='text-center'>".date_format($rs[$val],'d/m/Y')."</td>";
						}
						else
						{
							echo "<td>".date_format($rs[$val],'d/m/Y')."</td>";
						}
					}
					else
					{
						if(in_array($val, $arrColCenter))
						{
							echo "<td class='text-center'>".$rs[$val]."</td>";
						}
						else
						{
							echo "<td>".$rs[$val]."</td>";
						}
					}
			}//end-foreach
			echo "</tr>";
			$no++;
		}//end-while

		echo "</tbody>";
		//echo "<tfoot><tr style='background-color: lightgray;'><td colspan='".(count($arrHeader)+1)."'> Total : ".number_format(($no-1))." Records</td></tr></tfoot>";
		echo "</table></div>";
		//echo "<div style='background-color: lightgray;'>Total : ".number_format(($no-1))." Records</div>";
	}//end-if-qry
	sqlsrv_close($conn);
}//end-function

// การใช้งาน
include 'class/mainClass.php';
$db = new class_conn();
$db->getDGV("Select EmpID,enPrefix,enName,enLastName,thPrefix,thName,thLastName,Department,Position,thPosition From VHR_Gogo Where EmpID = '".$txtEmpID."' "
,"thName,thLastName,Department,Position"
,"Department,Position");

PHP : Function > getIssetPost($arrPost, $showVar = false) //V2

Post by Goborijung at 2021-05-19 10:57:53 | ID: 1209

// Function
function getIssetPost($arrPost, $showVar = false) //V2
{
	foreach($arrPost as $val) { $ { $val } = isset($_POST[$val]) ? $_POST[$val] : ''; }
	if ($showVar == true) {
		echo "<div class='row'><div class='col-sm-12'>";
		foreach($arrPost as $val) { echo "<small>".$val. " : <span class=\"text-danger\">".$ { $val }. "</span></small> | "; }
		echo "</div></div>";
	}
}

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

$arrPost = array('txtEmpID');
foreach($arrPost as $val) { ${ $val } = isset($_POST[$val]) ? $_POST[$val] : ''; }
$ct->getIssetPost($arrPost,true); //Show valPost

PHP : Function > issetPOST($val)

Post by Goborijung at 2021-05-19 10:44:20 | ID: 1208

// Function
function issetPOST($val)
{
	return isset($_POST[$val]) ? $_POST[$val] : '';
}

// การใช้งาน
$txtUserName = issetPOST('txtUserName');

PHP : Function > getCbo($sql,$cboName,$class,$fCode,$fName,$getPost)

Post by Goborijung at 2021-03-19 10:29:01 | ID: 1018

// Create Function
//สร้าง Option Select โดยใช้ Sql
    function getCbo($sql, $cboName, $class, $fCode, $fName, $getPost) 
    {
        include 'config.php';
        echo "<select name='".$cboName. "' id='".$cboName. "' class='".$class. "'>";
        echo "<option value=''>ทั้งหมด</Option>";
        $qry = sqlsrv_query($conn, $sql);
        if ($qry) 
        {
          while ($rs = sqlsrv_fetch_array($qry)) 
          {
             $selected = $rs[$fCode] == @$getPost ? "selected" : "";
             echo "<option value='".$rs[$fCode]. "' $selected >".$rs[$fName]. "</option>";
          }
        }
        echo "</select>";
    }

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

// Syntax : $db->getCbo($sql,$cboName,$class,$fCode,$fName,$getPost);
$db->getCbo("Select OID,Name From Customer Where GCRecord is null",'customer','form-control','OID','Name',@$customer);

PHP : Function > getCbo_arrList($cboName,$arrList,$getPost)

Post by Goborijung at 2021-03-19 10:29:23 | ID: 1019

// ตัวอย่างาการเขียน function
function getCbo_arrList($cboName, $arrList, $getPost) {
  echo "<select name='".$cboName."' id='".$cboName."' class='form-control'>";
  foreach($arrList as $key => $val) {
    $selected = ($key == @$getPost ? 'selected' : '');
    echo "<option value='{$key}' {$selected }>".$val."</option>";
  }
  echo "</select>";
}

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

$arrList = array('a' , 'b' , 'c');
// Syntax : $db->getCbo_arrList($cboName,$arrList,$getPost);
$db->getCbo_arrList('qctype',array(''=>'All','NULL'=>"NULL",1=>'Pass',2=>'No Pass'),@$qctype);