PHP pdo 链接access数据库并读取写入数据实例

来源：互联网发布：100本网络禁书打包下载编辑：程序博客网时间：2024/04/28 22:16

1.php pdo 链接access数据库：

<?php

try {

$conn = new PDO("odbc:driver={microsoft access driver (*.mdb)};
dbq=".realpath("MyDatabase.mdb"))
or die("链接错误！");

}
catch(PDOException $e){

echo $e->getMessage();
}

?>

2.读取access数据库mydatabase.mdb中users表中的所以数据

<?php

try {

$conn = new PDO("odbc:driver={microsoft access driver (*.mdb)};
dbq=".realpath("MyDatabase.mdb"))
or die("链接错误！");
//echo "链接成功！";

}
catch(PDOException $e){
echo $e->getMessage();
}

$sql = "select * from users";
$rs = $conn->query($sql);

?>

<table width="50%" cellpadding="0" cellspacing="0" border="1">
<tr>
<td>编号</td>
<td>用户名</td>
<td>密码</td>
</tr>

<?php
foreach ($conn->query($sql) as $row) {
//print_r($row); //你可以用 echo($GLOBAL); 来看到这些值
//echo "编号：".$row[0]."--用户名：".$row[1]."--密码：".$row[2]."<br>";
?>

<tr>
<td><?php echo $row["UserID"] ?></td>
<td><?php echo $row["UserName"] ?></td>
<td><?php echo $row["UserPassword"] ?></td>
</tr>

<?php

}
?>

</table>

3.通过表单想users表中添加数据

<br><br>
<form name="userform" action="<?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?>" method="post">
<p>用户名：<input type="text" name="username"> <?php echo $nameErr;?> </p>
<p>密 码：<input type="password" name="password"> <?php echo $nameErr;?></p>
<p><input type="submit" name="sub" value="提交"></p>
</form>
<?php
$username="";
$password="";
$usernameErr="";
$passwordErr="";
if ($_SERVER["REQUEST_METHOD"] == "POST"){
if (empty($_POST["username"]))
{$usernameErr = "用户名不能为空！";}
else
{$username = test_input($_POST["username"]);}

if (empty($_POST["password"]))
{$passwordErr = "用户名不能为空！";}
else
{$password = test_input($_POST["password"]);}

$sql="insert into Users(UserName,UserPassword) values('".$username."','".$password."')";
$conn->exec($sql);
echo "<script>alert('添加成功！');window.location.href='index.php';</script>";
}
?>

0 0