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

PHP : Random String Function , Random Password , Password Generater

Post by Goborijung at 2021-02-11 09:09:46 | ID: 619

<?php

function randomString($length = 6) {
	$str = "";
	$characters = array_merge(range('A','Z'), range('a','z'), range('0','9'));
	$max = count($characters) - 1;
	for ($i = 0; $i < $length; $i++) {
		$rand = mt_rand(0, $max);
		$str .= $characters[$rand];
	}
	return $str;
}

echo randomString();

?>

// Password Generater

<?php
function randomString($length = 6) {
	$str = "";
	$characters = array_merge(range('A','Z'), range('a','z'), range('0','9'),range(chr(33),chr(47)));
	$max = count($characters) - 1;
	for ($i = 0; $i < $length; $i++) {
		$rand = mt_rand(0, $max);
		$str .= $characters[$rand];
	}
	return $str;
}

$row = 20;
for($i=1; $i<=$row; $i++)
{
	echo randomString(10).'<br>';
}
?> 

PHP : Remember Me

Post by Goborijung at 2020-05-26 21:06:02 | ID: 585

/* ob_start and session() */
<?php
  ob_start(); //ประมวลผลคำสั่งทุกบรรทัดให้เสร็จก่อน ค่อยส่งให้ client ทีเดียว
  session_start();

  //ตรวจสอบว่ามีการเก็บ cookie ของ member เอาไว้หรือไม่ ถ้ามี ก็เอาไปแสดงในฟอร์ม
  $ck_email = isset($_COOKIE['ck_email'])?$_COOKIE['ck_email']:'';
  $ck_pwd   = isset($_COOKIE['ck_pass'])?$_COOKIE['ck_pass']:'';

  //ถ้า cookie-email ไม่ว่าง ให้ input-checkbox = checked
  if($ck_email=="")
  {
    $checked = "";
  }
  else
  {
    $checked = "checked";
  }
?>

/* html form */
<form method="post">
  <input type="email" name="email" value="<?=$ck_email?>" class="form-control" placeholder="Email">
  <input type="password" name="pass" value="<?=$ck_pwd?>" class="form-control" placeholder="Password">
  <input type="checkbox" name="keep_login" value="on" <?=$checked;?> > Remember Me
  <button type="Submit" name="btnSign" class="btn btn-primary btn-block btn-flat"><i class="fa fa-sign-in"></i> Sign In</button>
</form>

/* php do submit */
<?php
  
  if(user==user && pass==pass)
  {
    $keep_login = @$_POST['keep_login']; //echo 'keep_login: '.$keep_login; // --------------------------- (1)
    if($keep_login=='on')
    {
      //echo "<script>alert('keeped');</script>";
      setcookie('ck_email',$_POST['email'],time()+86400,'/');
      setcookie('ck_pass',$_POST['pass'],time()+86400,'/');
    }
    else
    {
      //echo "<script>alert('not keep');</script>";
      setcookie('ck_email','',time()-3600,'/');
      setcookie('ck_pass','',time()-3600,'/');
    }

    $rs = mysqli_fetch_array($qry);          
    $_SESSION['user_login_id'] = $rs['uid'];
    echo "<script>window.location.href='welcome';</script>";
  }
?>

PHP : Select Option

Post by Goborijung at 2024-10-17 15:16:18 | ID: 2023

<?php
    $arr1 = array(''=>'','N'=>'N','Y'=>'Y');
    echo "<select id='wait_flag' class='form-control custom-select'>";
    foreach($arr1 as $key => $val) {
    $SELECTed = ($key == $rs['WAIT_FLAG'] ? 'SELECTed' : '');
    echo "<option value='{$key}' {$SELECTed }>".$val."</option>";
    }
    echo "</select>";
?>

PHP : SET Option

Post by Goborijung at 2020-03-13 11:49:57 | ID: 424

<?php
function setOption($name,$arrVal,$post)
{
	echo "<select name='".$name."' id='".$name."' class='form-control form-control-sm'>";
	foreach($arrVal as $key => $val)
	{
		if($key == @$post)
		{
			echo "<option value='".$key."' selected>".$val."</option>";
		}
		else
		{
			echo "<option value='".$key."'>".$val."</option>";
		}
	}
	echo "</select>";
} //end-function

>> การใช้งาน <<

$htmlForm = new htmlForm();
$arrBranch = array(
	'NULL'			=>	''
	,'SAI4'			=>	'SAI4'
	,'SAI4-2'		=>	'SAI4-2'
	,'304'			=>	'304'
	,'RAMA2'		=>	'RAMA2'
 	//,'3FACTORY'	=>	'3Factory'
);
$htmlForm -> setOption('branch',$arrBranch,@$branch);
?>

PHP : Show Query (Admin Only)

Post by Goborijung at 2020-08-20 08:50:25 | ID: 731

<?php
	if($_SESSION['UserDepartmentCode'] == 'Admin')
	{
		$checked = '';
		if(@$chkQuery <> ''){ $checked = 'checked'; }
		echo "<input type='checkbox' name='chkQuery' ".$checked."> ShowQuery";
	}
?>

PHP : site: ที่เกียวข้อง

Post by Goborijung at 2018-12-24 17:03:53 | ID: 74

www.reviva.co.th/store/