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>";
}
?>