0 && ($act == "createtable" || $act == "droptable")) { doconnect(); if($act == "droptable") doquery($drop_sql); else doquery($create_sql); footer("$act : completely
back "); echo ' '; } /* # 03 - ส่วนแสดงผลหลัก ทั้งปกติ และหลังกดปุ่ม del หรือ edit */ if (strlen($act) == 0 || $act == "del" || $act == "edit") { doconnect(); doquery("select * from test"); if ($r) echo ' '; 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 " "; } /* dofetch */ if ($r == true) { echo "
id name - lastname Salary Process
"; if (isset($_REQUEST{'id'}) && $_REQUEST{'id'} == getfld("object","id")) { if ($act == "del") echo " "; if ($act == "edit") echo " "; } else { echo " "; echo " "; } echo "
"; if (isset($_SESSION["msg"]) && strlen($_SESSION["msg"]) > 1) { echo '

'; echo $_SESSION["msg"]; /* แสดงผลค่านี้ หลังการ Refresh */ echo '

'; } $_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 ' '; if (isset($_SESSION["v7"]) && $_SESSION["v7"] == true) mysqli_close($conn); else $conn->close(); } if (strlen($msg) > 1) { echo '

'. $msg .'

'; } if ((int)phpversion() >=7) echo '
'; else echo '
'; echo '

'; echo " create table : drop table "; echo "
version " . (int)phpversion() . " : "; echo '

'; if ((int)phpversion() >=7) { echo '

'; if (isset($_SESSION["v7"]) && $_SESSION["v7"] == false) echo " mysqli object : mysqli no object"; else echo "mysqli object : mysqli no object "; echo '

'; } } /* # 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
$myq"); } else { $r = mysql_db_query($db,$myq); if (!$r) footer("Query : Fail
$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}); } ?>