<?php session_start(); header('Access-Control-Allow-Origin: *'); ini_set('error_reporting', E_WARNING); // E_ALL : get deprecated ini_set('display_errors', 'on'); /* à¸à¸²à¸£à¸à¸™à¸¸à¸à¸²à¸•à¹ƒà¸«à¹‰à¸—ำ CORS (Cross Origin Resource Sharing) ผ่าน chrome https://chrome.google.com/webstore/detail/allow-cors-access-control/lhobafahddgcelffkeicbaginigeejlf?hl=en http://www.thaiall.com/php/adminlte357.png */ ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <meta http-equiv="X-UA-Compatible" content="IE=edge"> <title>AdminLTE 357 - 1 table and 3 fields </title> <meta name="viewport" content="width=device-width, initial-scale=1"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/fontawesome-free/css/all.min.css"> <link rel="stylesheet" href="https://code.ionicframework.com/ionicons/2.0.1/css/ionicons.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/tempusdominus-bootstrap-4/css/tempusdominus-bootstrap-4.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/icheck-bootstrap/icheck-bootstrap.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/jqvmap/jqvmap.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/dist/css/adminlte.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/overlayScrollbars/css/OverlayScrollbars.min.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/daterangepicker/daterangepicker.css"> <link rel="stylesheet" href="https://adminlte.io/themes/v3/plugins/summernote/summernote-bs4.css"> <link href="https://fonts.googleapis.com/css?family=Source+Sans+Pro:300,400,400i,700" rel="stylesheet"> <style> @font-face{ font-family:"Font Awesome 5 Brands"; font-style:normal;font-weight:normal;font-display:auto; src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.eot'); src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.eot?#iefix') format("embedded-opentype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.woff2') format("woff2"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.woff') format("woff"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.ttf') format("truetype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-brands-400.svg#fontawesome') format("svg") }.fab{font-family:"Font Awesome 5 Brands"} @font-face{ font-family:"Font Awesome 5 Free"; font-style:normal;font-weight:400;font-display:auto; src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.eot'); src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.eot?#iefix') format("embedded-opentype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.woff2') format("woff2"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.woff') format("woff"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.ttf') format("truetype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-regular-400.svg#fontawesome') format("svg") }.far{font-weight:400} @font-face{ font-family:"Font Awesome 5 Free"; font-style:normal;font-weight:900;font-display:auto; src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.eot'); src:url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.eot?#iefix') format("embedded-opentype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.woff2') format("woff2"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.woff') format("woff"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.ttf') format("truetype"), url('https://adminlte.io/themes/v3/plugins/fontawesome-free/webfontsfa-solid-900.svg#fontawesome') format("svg") }.fa,.far,.fas{font-family:"Font Awesome 5 Free"}.fa,.fas{font-weight:900} </style> </head> <body class="hold-transition sidebar-mini layout-fixed"> <div class="wrapper"> <!-- Navbar --> <nav class="main-header navbar navbar-expand navbar-white navbar-light"> <!-- Left navbar links --> <ul class="navbar-nav"> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte-3.0.4/pages/examples/burin1.htm" class="nav-link">Burin1 </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte/adminlte_fa_font.rar" class="nav-link">fa_font.rar </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte/adminlte.htm" class="nav-link">in dir </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte/adminlte.php" class="nav-link">outside </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte/adminlte_cors.htm" class="nav-link">12 cors </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="http://www.thaiall.com/adminlte/adminlte-3.0.4.htm" class="nav-link">origin </a> </li> <li class="nav-item d-none d-sm-inline-block"> <a href="https://thaiall.github.io/www/adminlte/adminlte_github.htm" class="nav-link">github.io </a> </li> </ul> </nav> <!-- /.navbar --> <!-- Main Sidebar Container --> <aside class="main-sidebar sidebar-dark-primary elevation-4" style="background-color:#000044;"> <!-- Sidebar --> <div class="sidebar"> <!-- Sidebar user panel (optional) --> <div class="user-panel mt-3 pb-3 mb-3 d-flex" style="background-color:black"> <div class="image"> <img src="http://www.thaiall.com/me/picme.jpg" class="img-circle elevation-2" alt="User Image"> </div> <div class="info"> <a href="https://github.com/thaiall" class="d-block">Burin <br/>Rujjanapan </a> </div> </div> <!-- Sidebar Menu --> <nav class="mt-2"> <ul class="nav nav-pills nav-sidebar flex-column" data-widget="treeview" role="menu" data-accordion="false"> <li class="nav-item"> <a href="http://localhost/adminlte357.php?" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>Home / Select </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/perlphpasp/source.pl?key=9116" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>9116 mysqlworking </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/perlphpasp/source.pl?key=9144" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>9144 update 357 </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/adminlte-3.0.4/" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>AdminLTE 3.0.4 </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/adminlte-3.0.4/pages/examples/projects.html" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>Project Template </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/project/indexo.html" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>/Project </p> </a> </li> <li class="nav-item"> <a href="http://www.thaiall.com/sponsor" class="nav-link"> <i class="fas fa-circle nav-icon"> </i> <p>/Sponsor </p> </a> </li> </ul> </nav> <!-- /.sidebar-menu --> </div> <!-- /.sidebar --> </aside> <!-- Content Wrapper. Contains page content --> <div class="content-wrapper"> <!-- Main content --> <section class="content"> <div class="container-fluid"> <!-- Main row --> <div class="row"> <?php /* ปรับปรุง 13 ตุลาคม 2563 - เผยà¹à¸žà¸£à¹ˆà¹ƒà¸™ http://www.thaiall.com/source - เริ่มต้นต้à¸à¸‡à¸ªà¸£à¹‰à¸²à¸‡à¸•à¸²à¸£à¸²à¸‡à¸à¹ˆà¸à¸™ ดูที่ตัวà¹à¸›à¸£ $create_sql - ตัวà¸à¸¢à¹ˆà¸²à¸‡à¸—ี่ http://www.thaiall.com/perlphpasp/source.pl?key=9144 (à¸à¹ˆà¸à¸™à¸›à¸£à¸±à¸š) - ตัวà¸à¸¢à¹ˆà¸²à¸‡à¸—ี่ http://www.thaiall.com/perlphpasp/source.pl?key=9146 (หลังปรับ) */ /* # 01 - ส่วนà¸à¸³à¸«à¸™à¸”ค่าเริ่มต้นขà¸à¸‡à¸£à¸°à¸šà¸š */ $host = "localhost"; $db = "mysql"; $tb = "test"; $user = "root"; /* รหัสผู้ใช้ ให้สà¸à¸šà¸–ามจาà¸à¸œà¸¹à¹‰à¸”ูà¹à¸¥à¸£à¸°à¸šà¸š */ $password = ""; /* รหัสผ่าน ให้สà¸à¸šà¸–ามจาà¸à¸œà¸¹à¹‰à¸”ูà¹à¸¥à¸£à¸°à¸šà¸š */ $create_sql = "create table test (id varchar(20), ns varchar(20), salary varchar(20)) engine = InnoDB default charset=utf8 collate=utf8_unicode_ci;"; $drop_sql = "drop table test"; if (isset($_REQUEST{'action'})) $act = $_REQUEST{'action'}; else $act = ""; /* # จัดà¸à¸²à¸£ session ขà¸à¸‡ php7 */ if (isset($_REQUEST["v7"])) { $_SESSION["v7"] = false; if($_REQUEST["v7"] == "obj") $_SESSION["v7"] = true; } /* # 02 - ส่วนสร้าง à¹à¸¥à¸°à¸¥à¸šà¸•à¸²à¸£à¸²à¸‡ */ if (strlen($act) > 0 && ($act == "createtable" || $act == "droptable")) { doconnect(); if($act == "droptable") doquery($drop_sql); else doquery($create_sql); footer("$act : completely <br/> <a href='?'>back </a>"); echo ' <meta http-equiv="refresh" content="0; url='. $_SERVER["SCRIPT_NAME"] .'">'; } /* # 03 - ส่วนà¹à¸ªà¸”งผลหลัภทั้งปà¸à¸•à¸´ à¹à¸¥à¸°à¸«à¸¥à¸±à¸‡à¸à¸”ปุ่ม del หรืภedit */ if (strlen($act) == 0 || $act == "del" || $act == "edit") { doconnect(); doquery("select * from test"); if ($r) echo ' <table class="table table-striped projects"> <thead> <tr> <th style="width: 10%">id </th> <th style="width: 40%">name - lastname </th> <th style="width: 10%" class="text-center">Salary </th> <th style="width: 40%">Process </th> </tr> </thead>'; while (dofetch("object")) { if (isset($_REQUEST{'id'}) && $_REQUEST{'id'} == getfld("object","id")) $chg = " style='background-color:#f9f9f9"; else $chg = " readonly style='background-color:#ffffdd"; echo " <tr> <form action='' method=post> <td> <input name=id size=5 value='". getfld("object","id") . "' style='background-color:#dddddd' readonly> </td> <td> <input name=ns size=40 value='". getfld("object","ns") . "' $chg'> </td> <td> <input name=salary size=20 value='". getfld("object","salary") . "' $chg;text-align:right'> </td> <td>"; if (isset($_REQUEST{'id'}) && $_REQUEST{'id'} == getfld("object","id")) { if ($act == "del") echo " <input type=submit name=action value='del : confirm' class='btn btn-info btn-sm' style='background-color:#440000'>"; if ($act == "edit") echo " <input type=submit name=action value='edit : confirm' class='btn btn-info btn-sm' style='background-color:#000044'>"; } else { echo " <input type=submit name=action value='del' class='btn btn-info btn-sm' style='background-color:red'>"; echo " <input type=submit name=action value='edit' class='btn btn-info btn-sm' style='background-color:blue'>"; } echo " </td> </form> </tr>"; } /* dofetch */ if ($r == true) { echo " <tr> <form action='' method=post> <td> <input name=id size=5> </td> <td> <input name=ns size=40> </td> <td> <input name=salary size=20> </td> <td> <input type=submit name=action value='add' class='btn btn-info btn-sm'> </td> </tr> </form> </table>"; if (isset($_SESSION["msg"]) && strlen($_SESSION["msg"]) > 1) { echo ' <div class="col-12"> <div class="small-box card-body"> <div class="inner"> <p style="text-align:center;">'; echo $_SESSION["msg"]; /* à¹à¸ªà¸”งผลค่านี้ หลังà¸à¸²à¸£ Refresh */ echo ' </p> </div> </div> </div>'; } $_SESSION["msg"] = ""; /* เมื่à¸à¹à¸ªà¸”งผลà¹à¸¥à¹‰à¸§ à¸à¹‡à¸¥à¹‰à¸²à¸‡à¸„่านี้จาà¸à¸•à¸±à¸§à¹à¸›à¸£ msg */ footer(null); } } /* # 04 - ส่วนเพิ่มข้à¸à¸¡à¸¹à¸¥ */ if ($act == "add") { doconnect(); doquery("insert into $tb values('". $_REQUEST{'id'} . "','". $_REQUEST{'ns'} . "','". $_REQUEST{'salary'} . "')"); if ($r) $_SESSION["msg"] = "insert : completely"; footer("refresh"); } /* # 05 - ส่วนลบข้à¸à¸¡à¸¹à¸¥ */ if ($act == "del : confirm") { doconnect(); doquery("delete from $tb where id ='". $_REQUEST{'id'} . "'"); if ($r) $_SESSION["msg"] = "delete : completely"; footer("refresh"); } /* # 06 - ส่วนà¹à¸à¹‰à¹„ขข้à¸à¸¡à¸¹à¸¥ */ if ($act == "edit : confirm") { doconnect(); doquery("update $tb set ns ='". $_REQUEST{'ns'} . "', salary ='". $_REQUEST{'salary'} . "' where id =" . $_REQUEST{'id'}); footer("refresh"); } /* # 07 - footer */ function footer($msg){ global $conn; if($msg == "refresh") { echo ' <meta http-equiv="refresh" content="0; url='. $_SERVER["SCRIPT_NAME"] .'">'; if (isset($_SESSION["v7"]) && $_SESSION["v7"] == true) mysqli_close($conn); else $conn->close(); } if (strlen($msg) > 1) { echo ' <div class="col-lg-3 col-12"> <div class="small-box bg-info"> <div class="inner"> <p>'. $msg .' </p> </div> </div> </div>'; } if ((int)phpversion() >=7) echo ' <div class="col-lg-8 col-4"> <div class="small-box card-body">'; else echo ' <div class="col-12"> <div class="small-box bg-warning">'; echo ' <div class="inner"> <p style="text-align:center;">'; echo " <a href=?action=createtable>create table </a> : <a href=?action=droptable>drop table </a>"; echo " <br/>version " . (int)phpversion() . " : "; echo ' </h3> </div> </div> </div>'; if ((int)phpversion() >=7) { echo ' <div class="col-lg-4 col-8"> <div class="small-box bg-warning"> <div class="inner"> <p>'; if (isset($_SESSION["v7"]) && $_SESSION["v7"] == false) echo " <a href=?v7=obj>mysqli object </a> : mysqli no object"; else echo "mysqli object : <a href=?v7=noobj>mysqli no object </a>"; echo ' </p> </div> </div> </div>'; } } /* # 08 - connect */ function doconnect(){ global $conn,$host,$user,$password,$db; if ((int)phpversion() >=7) { if (isset($_SESSION["v7"]) && $_SESSION["v7"] == false) { /* v7 เลืà¸à¸ connect ได้ 2 à¹à¸šà¸š */ /* à¹à¸šà¸šà¹à¸£à¸ mysqli_connect */ $conn = mysqli_connect($host, $user, $password, $db); if (!$conn) footer("Connection failed: " . mysqli_connect_error()); } else { /* à¹à¸šà¸šà¸—ี่สà¸à¸‡ new mysqli */ $conn = new mysqli($host, $user, $password, $db); if ($conn->connect_error) footer("Connection failed: " . $conn->connect_error); } } else { /* v5 ใช้à¹à¸šà¸š mysql_connect */ $conn = mysql_connect($host, $user, $password); if (!$conn) footer("Connection failed: " . mysql_error()); } } /* # 09 - query */ function doquery($myq){ global $r,$conn,$db; if ((int)phpversion() >=7) { if (isset($_SESSION["v7"]) && $_SESSION["v7"] == false) { $r = mysqli_query($conn,$myq); } else { $r = $conn->query($myq); } if (!$r) footer("Query : Fail <br/>$myq"); } else { $r = mysql_db_query($db,$myq); if (!$r) footer("Query : Fail <br/>$myq"); } } /* # 10 - fetch */ function dofetch($t) { global $o, $r; /* object, assoc, array */ if(!$r) { $o = false; return false; } if ((int)phpversion() >=7) { if($t == "object") return $o = $r->fetch_object(); } else { if($t == "object") return $o = mysql_fetch_object($r); } } /* # 11 - get field value ตามชื่à¸à¹€à¸‚ตข้à¸à¸¡à¸¹à¸¥ */ function getfld($t,$fld) { global $o; /* à¸à¸²à¸£à¸à¹‰à¸²à¸‡à¸à¸´à¸‡à¹€à¸‚ตข้à¸à¸¡à¸¹à¸¥à¹€à¸«à¸¡à¸·à¸à¸™à¸à¸±à¸™à¸—ั้งใน php7 à¹à¸¥à¸° php5 */ if($t == "object") return ($o->{$fld}); } ?> </div> <!-- /.row (main row) --> </div> <!-- /.container-fluid --> </section> <!-- /.content --> </div> <!-- /.content-wrapper --> <footer class="main-footer"> <strong>Copyright © 2014-2019 <a href="http://adminlte.io">AdminLTE.io </a>. </strong> All rights reserved. <div class="float-right d-none d-sm-inline-block"> <b>Version </b> 3.0.4 </div> </footer> </div> <!-- ./wrapper --> <!-- jQuery --> <script src="https://adminlte.io/themes/v3/plugins/jquery/jquery.min.js"> </script> <!-- jQuery UI 1.11.4 --> <script src="https://adminlte.io/themes/v3/plugins/jquery-ui/jquery-ui.min.js"> </script> <!-- Resolve conflict in jQuery UI tooltip with Bootstrap tooltip --> <script>$.widget.bridge('uibutton', $.ui.button) </script> <!-- Bootstrap 4 --> <script src="https://adminlte.io/themes/v3/plugins/bootstrap/js/bootstrap.bundle.min.js"> </script> <!-- ChartJS --> <script src="https://adminlte.io/themes/v3/plugins/chart.js/Chart.min.js"> </script> <!-- Sparkline --> <script src="https://adminlte.io/themes/v3/plugins/sparklines/sparkline.js"> </script> <!-- JQVMap --> <script src="https://adminlte.io/themes/v3/plugins/jqvmap/jquery.vmap.min.js"> </script> <script src="https://adminlte.io/themes/v3/plugins/jqvmap/maps/jquery.vmap.usa.js"> </script> <!-- jQuery Knob Chart --> <script src="https://adminlte.io/themes/v3/plugins/jquery-knob/jquery.knob.min.js"> </script> <!-- daterangepicker --> <script src="https://adminlte.io/themes/v3/plugins/moment/moment.min.js"> </script> <script src="https://adminlte.io/themes/v3/plugins/daterangepicker/daterangepicker.js"> </script> <!-- Tempusdominus Bootstrap 4 --> <script src="https://adminlte.io/themes/v3/plugins/tempusdominus-bootstrap-4/js/tempusdominus-bootstrap-4.min.js"> </script> <!-- Summernote --> <script src="https://adminlte.io/themes/v3/plugins/summernote/summernote-bs4.min.js"> </script> <!-- overlayScrollbars --> <script src="https://adminlte.io/themes/v3/plugins/overlayScrollbars/js/jquery.overlayScrollbars.min.js"> </script> <!-- AdminLTE App --> <script src="https://adminlte.io/themes/v3/dist/js/adminlte.min.js"> </script> <!-- AdminLTE for demo purposes --> <script src="https://www.masterhook.net/public/assets/dist/js/adminlte.js"> </script> <!-- AdminLTE dashboard demo (This is only for demo purposes) --> <script src="https://adminlte.io/themes/v3/dist/js/pages/dashboard.js"> </script> <!-- AdminLTE for demo purposes --> <script src="https://adminlte.io/themes/v3/dist/js/demo.js"> </script> </body> </html>