sondmk header
การเขียนโปรแกรมด้วยภาษา PHP เบื้้องต้น

PHP : GET IP ADDRESS

Post by Goborijung at 2022-08-31 14:36:35 | ID: 1757

echo $_SERVER['REMOTE_ADDR'];
PHP : in array

Post by Goborijung at 2020-08-11 11:47:24 | ID: 712

https://www.w3schools.com/php/func_array_in_array.asp 

<?php
	$people = array("Peter", "Joe", "Glenn", "Cleveland");

	if (in_array("Glenn", $people))
	{
		echo "Match found";
	}
	else
	{
		echo "Match not found";
	}
?>
PHP : Login Page

Post by Goborijung at 2021-05-13 13:16:46 | ID: 1186

<?php
  ob_start(); //ประมวลผลคำสั่งทุกบรรทัดให้เสร็จก่อน ค่อยส่งให้ client ทีเดียว
  session_start();
  if($_SESSION['user_login_id']!='')
  {
    header('Location: index2');
    exit;
  }
?>

<!DOCTYPE html>
<html>
  <head>
  <meta charset="utf-8">
  <meta http-equiv="X-UA-Compatible" content="IE=edge">
  <title>Soundmk | Log in</title>
  <!-- Tell the browser to be responsive to screen width -->
  <!--font-awesome cdn-->
  <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">
  <meta content="width=device-width, initial-scale=1, maximum-scale=1, user-scalable=no" name="viewport">
  <!-- Bootstrap 3.3.7 -->
  <link rel="stylesheet" href="https://soundmk.com/admin/Admin-LTE/bower_components/bootstrap/dist/css/bootstrap.min.css">
  <!-- Ionicons -->
  <link rel="stylesheet" href="https://soundmk.com/admin/Admin-LTE/bower_components/Ionicons/css/ionicons.min.css">
  <!-- Theme style -->
  <link rel="stylesheet" href="https://soundmk.com/admin/Admin-LTE/dist/css/AdminLTE.min.css">
  <!-- iCheck -->
  <link rel="stylesheet" href="https://soundmk.com/admin/Admin-LTE/plugins/iCheck/square/blue.css">
  <link rel="icon" href="https://goo.gl/brdDiw">

  <!-- Google Font -->
  <link rel="stylesheet" href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,600,700,300italic,400italic,600italic">
    <script>
      function doCheckLogin()
      {
        //alert('doCheck');
        var theForm = document.form1;
        if(theForm.email.value=='')
        {
          alert('ฟวย! ใส่อีเมล์ก่อนสิว่ะ...สาด!');
          return false;
        }
        else if(theForm.pass.value=='')
        {
          alert('ฟวย! ใส่รหัสด้วย ไอ้โง่..!');
          return false;
        }
        else
        {
          return submit;
        }
      }
    </script>
  </head>

  <body class="hold-transition login-page">
  <div class="login-box">
  <div class="login-logo">
    <a href="javascript:;"><b>SOUND</b>MK</a>
  </div>

  <div class="login-box-body">
    <p class="login-box-msg">Sign in to start your session</p>

    <?php
      //ตรวจสอบว่ามีการเก็บ 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";
      }
    ?>

    <!--Form-login-page-->
    <form name="form1" action="" method="post" onsubmit="return doCheckLogin()">
      
      <!--Email-->
      <div class="form-group has-feedback">
        <input type="email" name="email" value="<?=$ck_email?>" class="form-control" placeholder="Email">
        <span class="fa fa-envelope form-control-feedback"></span>
      </div>
      
      <!--Password-->
      <div class="form-group has-feedback">
        <input type="password" name="pass" value="<?=$ck_pwd?>" class="form-control" placeholder="Password">
        <span class="fa fa-lock form-control-feedback"></span>
      </div>

      <!--Remember/SignIn-->
      <div class="row">
        <div class="col-xs-8">
          <div class="checkbox icheck">
            <label>
              <input type="checkbox" name="keep_login" value="on" <?=$checked;?> >    Remember Me
            </label>
          </div>
        </div>
        <!-- /.col -->
        <div class="col-xs-4">
          <button type="Submit" name="btnSign" class="btn btn-primary btn-block btn-flat">
            <i class="fa fa-sign-in"></i> Sign In
          </button>
        </div>
        <!-- /.col -->
      </div>
    </form>

<!-------------------------------------------------DO Submit Form-------------------------------------------------------->

    <?php
      // Do Login Submit Form
      $s = array($_POST['email'],$_POST['pass']);
      $pass = md5($s[1]);
      $errMessage = '';
      foreach($s as $val)
      {
        if($val=='')
        {
          $errMessage = 'email or pass is null!';
        }
      }

      if($errMessage=='')
      {
        //echo "<script>alert('pass validator');</script>";
        require_once 'include/config.php';
        $sql = "SELECT * FROM tb_users WHERE email='".$s[0]."' AND pass='".$pass."' AND level='admin' ";
        //echo $sql;
        $qry = mysqli_query($conn,$sql);
        if(mysqli_num_rows($qry)==1)
        {
          $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='index2';</script>";
        }
        else
        {
          echo "<script>alert('ฟวยเอ้ย....ไม่มีสิทธิ์ ยังอยากจะเข้าอีกนะมึง สลัด...');</script>";
        }
      }
    ?>

    <!--Social-Login-Link-->
    <div class="social-auth-links text-center" style="display: none;">
      <p>- OR -</p>
      <a href="#" class="btn btn-block btn-social btn-facebook btn-flat">
        <i class="fa fa-facebook"></i> Sign in using Facebook
      </a>
      <a href="#" class="btn btn-block btn-social btn-google btn-flat">
        <i class="fa fa-google-plus"></i> Sign in using Google+
      </a>
    </div>
    <!-- <a href="#">I forgot my password</a><br>
    <a href="register.html" class="text-center">Register a new membership</a> -->

  </div>
  <!-- /.login-box-body -->
</div>
<!-- /.login-box -->

<!-- jQuery 3 -->
<script src="https://soundmk.com/admin/Admin-LTE/bower_components/jquery/dist/jquery.min.js"></script>
<!-- Bootstrap 3.3.7 -->
<script src="https://soundmk.com/admin/Admin-LTE/bower_components/bootstrap/dist/js/bootstrap.min.js"></script>
<!-- iCheck -->
<script src="https://soundmk.com/admin/Admin-LTE/plugins/iCheck/icheck.min.js"></script>
<script>
  $(function () {
    $('input').iCheck({
      checkboxClass: 'icheckbox_square-blue',
      radioClass: 'iradio_square-blue',
      increaseArea: '20%' /* optional */
    });
  });
</script>
</body>
</html>
PHP : Logout

Post by Goborijung at 2021-05-13 14:10:51 | ID: 1189

<?php
	session_start();
	session_destroy();
	echo "<script>window.location='login.php'</script>";
?>
PHP : mysqli_real_escape_string

Post by Goborijung at 2021-03-27 21:50:48 | ID: 1064

<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");

if (mysqli_connect_errno()) {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  exit();
}

// Escape special characters, if any
$firstname = mysqli_real_escape_string($con, $_POST['firstname']);
$lastname = mysqli_real_escape_string($con, $_POST['lastname']);
$age = mysqli_real_escape_string($con, $_POST['age']);

$sql="INSERT INTO Persons (FirstName, LastName, Age) VALUES ('$firstname', '$lastname', '$age')";

if (!mysqli_query($con, $sql)) {
  printf("%d Row inserted.
", mysqli_affected_rows($con));
}

mysqli_close($con);
?>
PHP : Shorthand IF , Nested Shorthand IF

Post by Goborijung at 2021-04-30 15:09:52 | ID: 1163

แบบเงื่อนไขเดียว

echo ($a == 0) ? 'Yes' : 'No';


แบบหลายเงื่อนไข

echo ($a==0 ? 'clear' : ($a==1 ? 'Processing' : ($a==2 ? 'Marked for delete' : 'Unknow' )));


แบบมี && ในเงื่อนไข

echo ($a == 0 || $ == 1 ? 'Pass' : ($a == 2 || $a == 3 ? 'Confirm' : 'Error'));
PHP : sqlsrv_num_rows

Post by Goborijung at 2021-05-13 14:08:19 | ID: 1188

<?php
	$sql = "SELECT OID,UserName FROM [User] WHERE UserName='".$s[0]."' AND Password='".$pass."' ";
	$qry = sqlsrv_query($conn,$sql , array(), array( "Scrollable" => 'static' ));
	if(sqlsrv_num_rows($qry) > 0)
	{
		// Statement
	}
?>
PHP : sqlsrv_real_escape_string

Post by Goborijung at 2020-04-23 10:05:54 | ID: 504

<?php
	$uname = sqlsrv_real_escape_string($conn, trim($_POST['uname']));
	$pass  = sqlsrv_real_escape_string($conn, trim($_POST['pword']));
?>
PHP : การสร้าง Class

Post by Goborijung at 2022-03-11 15:18:02 | ID: 1406

Syntax : 
class ClassName {
    // members and specifications
    ...
}
PHP : Alert

Post by Goborijung at 2022-06-02 15:35:58 | ID: 1575

$s = '555';
echo "<script>alert('$s');</script>";
<<<12345678910...>>>
Programming

Framework

Library

Lernnings

เครื่องมือพัฒนาเว็บ

Computer Network

Computer Security

การออกแบบและพัฒนาเว็บไซต์

Download Tools

Download SourceCode

Operating System

Webs Hacking

copyAllright © 2016 soundmk.com