<html>
<head>
<title>php调用odbc函数演示</title>
</head>
<body bgcolor=#808080>
<center>
<table width=80% border=3 bgcolor=#cccccc>
<tr><td>
这个例程简单演示了 <b>php</b> 通过 <b>odbc</b> 访问数据库.
只需要通过 控制面板->ODBC 数据源->添加数据源(WebTest)即可.<br>
</td></tr>
</table>
<form method=post action="<? echo getenv("REDIRECT_URL"); ?>">
<table border=3 width=80% cols=2 bgcolor=#cccccc>
<tr><td colspan=2>操作</td></tr>
<tr><td colspan=2>操作</td></tr>
<tr><td align=center>
<table width=100% border=0>
<tr><td>编号</td><td><input type=text name="n">(数字)</td></tr>
<tr><td>名称</td><td><input type=text name="name" maxlength=40>(字符串
)</td></tr>
<tr><td colspan=2>
<input type=submit name="verb" value="Insert">
<input type=submit name="verb" value="Delete">
<input type=submit name="verb" value="Update">
<input type=reset value="Reset">
</td></tr>
</table>
</td>
<td align=center>
<input type=submit name="verb" value="Create Table"><br><br>
<input type=submit name="verb" value="Drop Table">
</td></tr>
</table>
</form>
<?
if($con_id = odbc_connect("WebTest","ABC","123",SQL_CUR_USE_ODBC)){
$n = (int) $n;
if(strcmp($verb,"")!=0){
if(strcmp($verb,"Create Table")==0){
$sql_string = "create table testtb (n integer, name char(40))";
$err_msg = "创建数据表时出错, 该表已经存在?";
}else if(strcmp($verb, "Drop Table")==0){
$sql_string = "drop table testtb";
$err_msg = "Drop数据表时出错, 该表不存在?";
}else if(strcmp($verb,"Insert")==0){
$sql_string = "insert into testtb values ($n,'$name')";
$err_msg = "添加新记录时出错, 请检查您填写的数据.";
}else if(strcmp($verb,"Delete")==0){
$sql_string = "delete from testtb where n = $n";
$err_msg = "删除记录时出错, 请检查您填写的数据.";
}else if(strcmp( $verb,"Update")==0){
$sql_string = "update testtb set name = '$name' where n = $n";
$err_msg = "更新记录时出错, 请检查您填写的数据.";
$err_msg = "更新记录时出错, 请检查您填写的数据.";
}
print $sql_string;
if(!odbc_exec($con_id,$sql_string))
echo $err_msg;
}
if($result=odbc_exec($con_id,"select n, name from testtb")){
?>
<hr size=1 width=80%>
<table border=3 width=80% cols=2 bgcolor=#cccccc>
<tr><td colspan=2 align=left>查询结果</td></tr>
<tr><td>编号</td><td>名称</td></tr>
<?
while(odbc_fetch_row($result))
printf( "<tr><td>%d</td><td>%s</td></tr>n",odbc_result($result,1)
,odbc_result($result,2));
?>
</table>
<?
printf( "<tr><td>%d</td><td>%s</td></tr>n",odbc_result($result,1)
}else
echo "查询失败, 请确认正确数据表存在.";
odbc_close($con_id);
}else
echo "连接数据库失败, 请检查您是否正确的配置了 ODBC 数据源.";
?>
</center>
</body>
</html>
|