php test,Php Test

/*

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]

-------------------------------------------------------------

*/

?>

Add Delete Study

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}

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 "

echo "

Employee Infomation

";

printf("

%s%s%s%s",'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