|
<? # เผยแพร่ใน http://www.thaiall.com/perlphpasp/source.pl?9138 # ปรับปรุง 19 กันยายน 2553 # === # ส่วนกำหนดค่าเริ่มต้นของระบบ $host = "localhost"; $db = "test"; $tb = "test"; // create table test (id varchar(20), ns varchar(20), salary varchar(20)); $user = "admin"; // รหัสผู้ใช้ ให้สอบถามจากผู้ดูแลระบบ $password = "p"; // รหัสผ่าน ให้สอบถามจากผู้ดูแลระบบ $conn = mysql_connect("$host","$user","$password"); if (isset($_REQUEST{'action'})) $act = $_REQUEST{'action'}; else $act = ""; # ส่วนเพิ่มข้อมูล if ($act == "add") insert_data(); if ($act == "del_confirm") delete_data(); if ($act == "update_confirm") update_data(); if ($act == "select" || $act == "del" || $act == "update") select_data(); else echo "<textarea rows=5 cols=60></textarea><br/>"; # ajax ?> <script type="text/javascript"> function ajax(act,eid,ns,salary) { var xmlHttp; var xdate = new Date(); try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { try { // Internet Explorer xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { try { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } catch (e) { alert("Your browser does not support AJAX!"); return false; } } } xmlHttp.onreadystatechange=function() { if(xmlHttp.readyState==4) { document.getElementById('area').innerHTML=xmlHttp.responseText; } } var url = "?action=" + act + "&eid=" + eid + "&ns=" + ns + "&salary=" + salary; xmlHttp.open("GET",url,true); xmlHttp.send(null); } </script> <div id="area"></div> <script>ajax('select','','','');</script> <? exit; function delete_data() { global $host, $db, $tb, $user, $password,$act,$conn; $q = "delete from test where id ='". $_REQUEST{'eid'} . "'"; $conn = mysql_connect("$host","$user","$password"); $r = mysql_db_query($db,$q); mysql_close($conn); select_data(); exit; } function update_data() { global $host, $db, $tb, $user, $password,$act,$conn; $q = "update $tb set ns ='". $_REQUEST{'ns'} . "', salary ='". $_REQUEST{'salary'} . "' where id =" . $_REQUEST{'eid'}; $conn = mysql_connect("$host","$user","$password"); $r = mysql_db_query($db,$q); mysql_close($conn); select_data(); exit; } function insert_data() { global $host, $db, $tb, $user, $password,$act,$conn; $q = "insert into test values('". $_REQUEST{'eid'} . "','". $_REQUEST{'ns'} . "','". $_REQUEST{'salary'} . "')"; $conn = mysql_connect("$host","$user","$password"); $r = mysql_db_query($db,$q); mysql_close($conn); select_data(); exit; } function select_data() { global $host, $db, $tb, $user, $password,$act,$conn; $q = "select * from $tb"; $rs = mysql_db_query($db,$q); echo "<table>"; while ($rs && $o = mysql_fetch_object($rs)) { if (isset($_REQUEST{'eid'}) && $_REQUEST{'eid'} == $o->id && strlen($act) < 7 && $act != "add") $chg = " style='background-color:#f9f9f9"; else $chg = " readonly style='background-color:#ffffdd"; echo "<tr><form action='' method=post> <td><input name=eid size=5 value='". $o->id . "' style='background-color:#dddddd' readonly></td> <td><input name=ns size=40 value='". $o->ns . "' $chg'></td> <td><input name=salary size=20 value='". $o->salary . "' $chg;text-align:right'></td> <td>"; if (isset($_REQUEST{'eid'}) && $_REQUEST{'eid'} == $o->id && strlen($act) < 7 && $act != "add") { if ($act == "del") echo "<input type=button name=action value='del_confirm' style='height:40;background-color:yellow' onclick='javascript:ajax(\"del_confirm\",eid.value,ns.value,salary.value)'>"; if ($act == "update") echo "<input type=button name=action value='update_confirm' style='height:40;background-color:#aaffaa' onclick='javascript:ajax(\"update_confirm\",eid.value,ns.value,salary.value)'>"; } else { echo "<input type=button name=action value='del' style='height:26' onclick='javascript:ajax(\"del\",eid.value,ns.value,salary.value)'> <input type=button name=action value='update' style='height:26' onclick='javascript:ajax(\"update\",eid.value,ns.value,salary.value)'>"; } echo "</td></form></tr>"; } echo "<tr><form action='' method=post><td><input name=eid size=5></td><td><input name=ns size=40></td><td><input name=salary size=20></td><td><input type=button name=action value='add' style='height:26' onclick='javascript:ajax(\"add\",eid.value,ns.value,salary.value)'></td></tr></form></table>"; exit; } ?> |