触摸屏租赁
Touch screen rental
广告机租赁
Advertising rental
机器人租赁
Robot leasing
 当前位置:首页 > 全部 > php操作ACCESS(增删改查)

增:
<?
$Password=md5($_POST['Password']);
$UserName=$_POST['UserName'];
$AdminPurview_Others=$_POST['AdminPurview_Others'];
$oskey=$_POST['oskey'];
$rs=new COM("adodb.recordset");
$rs->open("INSERT INTO [admin] (UserName,Password,AdminPurview_Others,oskey) VALUES ('$UserName','$Password','$AdminPurview_Others','$oskey')",$conn,1,1);
echo "<script>alert('操作成功!');location='Admin_Manage.php';</script>";
?>

删:
<?
$action=$_GET['action'];
$id = $_GET[id];
if($action=='del'){
$conn->execute ("delete from [job] where [id]=$id");
echo "<script type='text/javascript'>alert('删除成功!');window.location.href='Admin_HrDemand.php';</script>";
}    
?>

改:
<?
$id=$_GET['id'];
$Title=$_POST['Title'];
$BigClassID=$_POST['BigClassName'];
$content=$_POST['content'];
$action=$_GET['action'];
if($action=='save'){
$rs=new COM("adodb.recordset");
$rs->open("UPDATE [News] SET Title = '$Title',bigclassid = $BigClassID,Content = '$content' where [ID]=".$id,$conn,1,1);
echo "<script type='text/javascript'>alert('更改成功!');window.location.href='News_Manage.php';</script>";
}
?>

查:
<?php
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . getcwd() . "\\db.mdb";
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from class",$conn,1,1);
while(! $rs->eof) {
  $f = $rs->Fields(0);
  echo $f->value;
  $rs->MoveNext();
}
$rs->close;
?>


工作室地址:重庆石桥铺电脑城B座 | 微信:z35544216 | 网址:www.35544216.com