增: <? $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; ?>
|