<?php /* Version: v1.0 CopyRight Davis.z 2010 Creation Date 2010-02-25 ----------------------- Table Script ------------------------ CREATE TABLE [dbo].[T_Employee]( [Name] [nvarchar](50) COLLATE Korean_90_CS_AS NOT NULL, [Age] [nvarchar](5) COLLATE Korean_90_CI_AS NULL, [City] [nvarchar](50) COLLATE Korean_90_CI_AS NULL, [Tel] [nvarchar](50) COLLATE Korean_90_CI_AS NULL ) ON [PRIMARY] ------------------------------------------------------------- */ ?> <html> <head><title>Add Delete Study</title></head> <style type="text/css"> table { margin-left:100; width: 40%; height: 60px; border-collapse:collapse; border:#FF0000 solid;border-width:1 0 0 1 } th { text-align:Left; padding:0; border:#CC0066 solid;border-width:0 1 1 0 } td { padding:0; border:#CC0066 solid;border-width:0 1 1 0 } body { color:#6699CC; /* background-color:#6699CC */ } .d1 {width:50px} </style> <body> <?php function GetDBConnection() { $server='192.168.10.98'; $username='Test'; $password='test'; $database='TestDB'; $connstr= "Driver={SQL Server};Server=$server;Database=$database"; $lconn=odbc_connect($connstr,$username,$password,SQL_CUR_USE_ODBC); return $lconn; } $conn=GetDBConnection(); function SelectRecord($pconn) { $ss="select * from T_Employee"; $dataSet=odbc_exec($pconn,$ss); if ($dataSet) { echo "<table>"; echo "<Caption><h1>Employee Infomation</h1></Caption>"; printf("<tr><th>%s</th><th>%s</th><th>%s</th><th>%s</th></tr>",'Name','Age','City','Tel'); while($rs=odbc_fetch_object($dataSet)) { $name=$rs->Name; $age=$rs->Age; $city=$rs->City; $tel=$rs->Tel; if ($name=="") $name=" "; if ($age=="") $age=" "; if ($city=="") $city=" "; if ($tel=="") $tel=" "; printf("<tr><td><a href='http://www.163.com' target=_blank>%s<a/></td> <td>%s</td><td>%s</td><td>%s</td></tr>",$name,$age,$city,$tel); } echo "</table>"; } $free=odbc_free_result($dataSet); } function IsRecordExist($pconn) { $name=$_POST['name']; $ss="select * from T_Employee where name='$name'"; $dataSet=odbc_exec($pconn,$ss); $rs=odbc_fetch_object($dataSet); if ($rs) { $free=odbc_free_result($dataSet); return true; } else { return false; } } function InsertRecord($pconn) { $name=$_POST['name']; $age=$_POST['age']; $city=$_POST['city']; $tel=$_POST['tel']; $sql = "Insert into T_Employee(name,age,city,tel) values ('$name','$age','$city','$tel')"; $dataSet=odbc_exec($pconn,$sql); $rows=odbc_num_rows($dataSet); if ($rows>0) echo "Insert OK!"; $free=odbc_free_result($dataSet); } function UpdateRecord($pconn) { $name=$_POST['name']; $age=$_POST['age']; $city=$_POST['city']; $tel=$_POST['tel']; $uu="Update T_Employee Set age='$age',city='$city',tel='$tel' where name='$name'"; $dataSet=odbc_exec($pconn,$uu); $rows=odbc_num_rows($dataSet); if ($rows>0) echo "Update OK!"; $free=odbc_free_result($dataSet); return 0; } function DeleteRecord($pconn) { $name=$_POST['name']; $dd="Delete from T_Employee where name='$name'"; $dataSet=odbc_exec($pconn,$dd); $rows=odbc_num_rows($dataSet); if ($rows>0) echo "Delete OK!"; $free=odbc_free_result($dataSet); } if(isset($_POST[AddBtn])) { if (IsRecordExist($conn)) { echo "Submit failed,record has exists!<br>"; } else { InsertRecord($conn); } } elseif(isset($_POST[DelBtn])) { DeleteRecord($conn); } elseif(isset($_POST[UptBtn])) { UpdateRecord($conn); } if(2>1) { SelectRecord($conn); } // odbc_close($conn); ?> <br><hr> <h2 class=d2>Add New Employee:</h2> <form name="AddSub" action="<?php echo $_SERVER['PHP_SELF']; ?> "method="POST"> <span class="d1">Name:</span><input type="Text" name="name" value="<?php echo $rs->Name ?>"><br> <span class="d1">Age: </span><input type="Text" name="age" value="<?php echo $rs->Age ?>"><br> <span class="d1">City:</span><input type="Text" name="city" value="<?php echo $rs->City ?>"><br> <span class="d1">Tel: </span><input type="Text" name="tel" value="<?php echo $rs->Tel ?>"><br> <span class="d1"></span><input type="Submit" name="AddBtn" value=" Add "> <span></span><input type="Submit" name="UptBtn" value="Update"> <span></span><input type="Submit" name="DelBtn" value="Delete"> </form> </body> </html>