<?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="&nbs
