Post by Goborijung at 2021-03-19 10:29:41 | ID: 1021
function getCbo_Month($cboName,$getPost) { $arrMonth = 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' ); echo "<select name='".$cboName."' id='".$cboName."' class='form-control'>"; foreach($arrMonth as $key => $val) { if($key == @$getPost) { echo "<option value='".$key."' selected>".$val."</option>"; } else { echo "<option value='".$key."'>".$val."</option>"; } } echo "</select>"; } // การใช้งาน $db->getCbo_Month($cboName,$getPost);
Post by Goborijung at 2021-03-19 15:51:14 | ID: 1022
// Function
function getDgv($sql, $arrHeader, $arrColCenter) { 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><tr><th>No</th>"; 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// การใช้งาน
$db->getDgv($sql,$arrHeader,$arrColCenter);
Post by Goborijung at 2021-03-19 10:30:45 | ID: 1023
// ตัวอย่าง Function
function getIssetPost($arrPost, $showVar = false) { foreach($arrPost as $val) { $ { $val } = issetPOST($val); } if ($showVar == true) { echo "<div class='container-fluid'><div class='row'><div class='col-sm-12'>"; foreach($arrPost as $val) { echo $val. " : <span class="text-danger">".$ { $val }. "</span> | "; } echo "</div></div></div>"; } }// การใช้งาน
$ct - > getIssetPost($arrPost, $showVar = false);// ตัวอย่างการใช้งานจริง
include 'class/mainClass.php'; $db = new dbConn(); $ct = new classTools(); $arrPost = array('txtStartDate', 'txtEndDate', 'txtVendor', 'txtDocumentNo','cboInterfaceType'); foreach($arrPost as $val) { ${ $val } = issetPOST($val); } $ct->getIssetPost($arrPost,true); //Show valPost
Post by Goborijung at 2021-03-19 10:31:03 | ID: 1024
// Create Function
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 $key => $val) { if ($key == @$getKey) { echo " < div class = 'form-check form-check-inline' > < input class = 'form-check-input' type = 'radio' name = '".$rdoGroupName."' value = '".$key."' 'checked' > < label class = 'form-check-label' > ".$val." < /label> < /div> "; } else { echo " < div class = 'form-check form-check-inline' > < input class = 'form-check-input' type = 'radio' name = '".$rdoGroupName."' value = '".$key."' > < label class = 'form-check-label' > ".$val." < /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'));
Post by Goborijung at 2021-04-30 09:35:11 | ID: 1158
Function
function getThisPage() { return $_SERVER["PHP_SELF"]; }การใช้งาน
include 'class/mainClass..php'; $ct = new classTools(); //Syntax : $ct->getThisPage(); <button class="btn btn-sm btn-danger" type="button" name="reset" onclick="window.location.href='<?=$ct->getThisPage()?>' "><i class="fa fa-times"></i> Reset</button>
Post by Goborijung at 2021-03-19 10:31:21 | ID: 1025
function setTableHeader($arrHeader) { echo "<thead style='background-color:#80b4c5;'><tr>"; foreach($arrHeader as $val) { echo "<th>".$val."</th>"; } echo "</tr></thead>"; }// การใช้งาน
$ct->setTableHeader($arrHeader);
Post by Goborijung at 2021-03-19 10:18:16 | ID: 1017
include 'class/mainClass.php'; $db = new dbConn(); $ct = new classTools(); // การใช้งาน $arrBranch = array( 'NULL' => '', 'SAI4' => 'SAI4', 'SAI4-2' => 'SAI4-2', '304' => '304', 'RAMA2' => 'RAMA2', 'TUW' => 'TUW' ); $db->getCbo_arrList('cboName',$arrBranch ,@$cboName);
Post by Goborijung at 2021-03-19 10:29:58 | ID: 1020
function getCbo_Year($cboName,$getPost) { include 'config.php'; $sql = "Select Code From Year Where GCRecord is null"; $qry = sqlsrv_query($conn,$sql); if($qry) { echo "<select name='".$cboName."' id='".$cboName."' class='form-control'>"; while($rs = sqlsrv_fetch_array($qry)) { if($rs['Code'] == @$getPost) { echo "<option value='".$rs['Code']."' selected>".$rs['Code']."</option>"; } else { echo "<option value='".$rs['Code']."'>".$rs['Code']."</option>"; } } echo "</select>"; } } // การใช้งาน $db->getCbo_Year($cboName,$getPost);
Post by Goborijung at 2021-05-31 10:24:50 | ID: 1223
// ตัวอย่าง
$inOID = ""; foreach($id as $val) { $inOID .= $val.','; } $final_inOID = substr($inOID,0,strlen($inOID)-1); //echo $final_inOID; br();
Post by Goborijung at 2021-05-31 13:21:19 | ID: 1226
<?php
$proDate = date_format($rs['ProbationEndDate'],'Y-m-d');
$getDay = strtotime($proDate);
$day = date('d',$getDay); // หรือ date('d',strtotime($proDate));
echo $proDate.' , '.$day; br();
?>