PHP : Get String Index ด้วย strpos

Post by Goborijung at 2020-07-11 10:04:06 | ID: 625

<?php
$str = "This is a book (JAPAN)";
$first = strpos($str,'(');
$end = strpos($str,')');

echo $first.'/'.$end;
echo '<br>';
echo substr($str,$first+1,$end-$first-1);
?> 

PHP : getDay , getMonth , getYear

Post by Goborijung at 2021-02-22 14:46:26 | ID: 1012

echo date('d');
echo date('m'); หรือ echo date('n');
echo date('Y');

PHP : GetOneParam

Post by Goborijung at 2021-10-01 10:46:15 | ID: 1343

// Function
function getOneParam($sql,$colName)
{
	include 'config.php';
	$qry 	= sqlsrv_query($conn,$sql);
	$rs 	= sqlsrv_fetch_array($qry);
	return $rs[$colName];
}

// การใช้งาน
$db = new classDB();
echo $db->getOneParam($sql,$colName);

PHP : Insert Null

Post by Goborijung at 2021-09-30 16:28:26 | ID: 1342

// ตัวอย่าง Code
$chkTest = "null";
if($chkTestData != "")
{
	$chkTest = '1';
}

// การใช้งาน
".$chkTest."

PHP : Isset

Post by Goborijung at 2024-11-18 10:19:29 | ID: 2026

// การรับค่าจากตัวแปลที่ส่งมาจาก Form
$oid = isset($_POST['oid']) ? $_POST['oid'] : '';
echo 'oid : '.$oid;

PHP : Loop CheckBox Row ID , array checkbox , array hidden

Post by Goborijung at 2021-03-25 13:08:48 | ID: 1057

// HTML
<input name="id[]" type="checkbox" id="id" value="2">

// PHP
<?php
	$delEmp = $_POST['id']; //id Array
	for($i=0; $i<count($delEmp); $i++)
	{
	//Statement
	}
?>

หรือ

<?php
  if(isset($_POST['btnDel']))
  {//(1)
    //echo "<script>alert('ok del');</script>";
    $delId = isset($_POST['id']) ? $_POST['id'] : '';
    if(is_array($delId))
    {//(2)
		
      $delStatus = false;
      foreach($delId as $val) //Loop Delete
      {
        $sql = "Delete FROM informing Where inform_id = ".$val." "; //echo $sql;
        $qry = mysqli_query($conn,$sql);
        if($qry)
        {
          $delStatus = true;
        }
      }

      if($delStatus == true) //Show Result
      {
        echo "<script>alert('ลบข้อมูลเรียบร้อยแล้ว'); window.location='repair.php';</script>";
      }

    }//(2)
  }//(1)
?>

php : modal dialog

Post by Goborijung at 2021-08-25 15:27:12 | ID: 1324

Readme :: Replace / to BlackSlash

<!-- bs3 -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
  
<!-- bs4 -->
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>

<!-- font-awesome -->
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

<!-- PHP -->
<?php
	// Function loopModal
	function loopModal($id,$created,$closed)
  {
  	?>
  	<!-- Modal -->
  	<div class="modal fade" id="myModal-<?=$id?>">
  		<div class="modal-dialog modal-lg">

  			<!-- Modal content-->
  			<div class="modal-content">

  				<!--Header-->
  				<div class="modal-header bg-primary">
  					<h4 class="modal-title text-center">Ticket Number : <?=$id?></h4>
  					<button type="button" class="close" data-dismiss="modal">×</button>
  				</div>

  				<!--Body-->
  				<div class="modal-body" style="padding: 4px;">
            <pre><?=$created?> , <?=$closed?></pre>
  				</div>

  				<!--Footer-->
  				<div class="modal-footer">
  					<button type="button" class="btn btn-danger" data-dismiss="modal"><i class="fa fa-times"></i> Close</button>
  				</div>

  			</div><!--/modall-content-->

  		</div><!--/modal-dialog-->
  	</div><!--/modal-->
  	<?php
  }//end-fnloopModal

  // Function btnCommand
	function btn_command($id)
  {
  	echo "<a data-toggle='modal' data-target='#myModal-".$id."' class='btn btn-xs btn-success'><i class='fa fa-eye'></i></a> ";
  	//echo "<a href='programming_edit?id=".$id."' class='btn btn-xs btn-primary'><i class='fa fa-pencil'></i></a> ";
  	//echo "<a href='index?delid=".$id."' onclick=/"return confirm('มึงแน่ใจแล้วนะแอ๊ด?')/" class='btn btn-xs btn-danger'><i class='fa fa-trash'></i></a>";
  }//end-btnCommand
?>

<!-- HTML -->
<td class="text-center">                    	
	<?php btn_command($rs['Ticket']); loopModal($rs['Ticket'],$rs['Date'],$rs['closeDate']); ?>
</td>

PHP : ODBC Connect SQL Server

Post by Goborijung at 2022-06-07 04:55:19 | ID: 1588

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

>> Code Example : 

<?php

$server = 'DESKTOP-S78U6DAMSSQL_GO';
$database = 'dbTest';
$user = 'sa';
$pass = 'kanomadmin';
$connection = odbc_connect("Driver={SQL Server};Server=$server;Database=$database;", $user, $pass);

if(!$connection)
{
    echo "Not Connected.";
}

$sql = "Select * From tblUser";
$qry = odbc_exec($connection,$sql);
if(odbc_num_rows($qry) > 0)
{
    while($rs = odbc_fetch_array($qry))
    {
        echo $rs['OID'];
    }
}

?>

PHP : PHP Redirect , php redirect

Post by Goborijung at 2021-03-25 10:35:30 | ID: 78

>> การ Redirect แบบต่างๆ

// Javascript
echo "<script>alert('บันทึกข้อมูลเรียบร้อย'); window.location = 'index.php'; </script>";

// PHP Header
<?php Header("location:index.php"); ?>
การ Redirect ด้วย javascript (History.back()) 

// PHP Meta Redirect
echo "<meta http-equiv='refresh' content='0; url=http://example.com/'>";

// History.Back()
echo "<a href=\"javascript:window.history.back()\"> กลับ </a>";
การ Redirect ด้วย javascript (Location.href) 

// Javascript Relocation
echo "<a href=\"javascript:window.location.href='index.php'\"> กลับ </a>";
การ Reload ด้วย javascript (location.reload) 

// Reload()
echo "<a href=\"javascript:window.location.reload()\"> Reload </a>";

PHP : PHP Encode Protect Source Code

Post by Goborijung at 2020-08-01 01:27:02 | ID: 691

https://www.gaijin.at/en/tools/php-obfuscator