PHP : Insert Null

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

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

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

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

PHP : PHP SQL SELECT (DAY,MONTH,YEAR)

Post by Goborijung at 2019-06-07 09:26:43 | ID: 86

SELECT * FROM table WHERE DAY(column) = 1

PHP : PHP การนับตัวอักษร (encode:utf-8)

Post by Goborijung at 2018-12-27 15:59:57 | ID: 80

<?php
	function utf8_strlen($s) {
		$c = strlen($s); $l = 0;
		for ($i = 0; $i < $c; ++$i)
		if ((ord($s[$i]) & 0xC0) != 0x80) ++$l;
		return $l;
	}

	$str = "ทดสอบนับอักขระภาษาไทย";
	echo utf8_strlen($str);
?>

Cradit : http://moshikub.com/strlen-php-นับตัวอักษร/

PHP : Pro PHP MVC (PDF)

Post by Goborijung at 2020-04-24 00:44:12 | ID: 512

http://web-algarve.com/books/MySQL%20&%20PHP/Pro%20PHP%20MVC.pdf

PHP : Pyramid

Post by Goborijung at 2021-01-31 14:12:24 | ID: 1003

https://codescracker.com/java/program/java-program-print-star-pyramid-patterns.htm
https://www.geeksforgeeks.org/programs-printing-pyramid-patterns-php/

>> Ex1
function loop_001($number)
{
	$i = 1; 
	while($i <= $number)
	{
		$j = 1;
		while($j <= $i)
		{
			echo $j." ";
			$j++;
		}
		echo "<br>";
		$i++;
	}
}

หรือ

function loop_001($number)
{
	for($i=1; $i<=$number; $i++)
	{
		$num = 1;
		for($j=1; $j<=$i; $j++)
		{
			echo $num++." ";
		}
		echo "<br>";
	}
}

loop_001(4);

// Output
1
1 2
1 2 3
1 2 3 4

>> Ex2
function loop_002($number)
{
	for($i=$number; $i>0; $i--)
	{
		
		for($j=$number-$i; $j>0; $j--)
		{
			echo "  ";
		}
		
		for($k=$i; $k>0; $k--)
		{
			echo $k;
		}
		
		echo "<br>";
	}
}

loop_002(4);

// Output
4321
  321
    21
      1