PHP ²Ù×÷Access (ÕýÈ·)
µÚÒ»ÖÖ·½·¨£º
<?php
class Access{
function getConn(){
$conn = @new COM("ADODB.Connection") or die ("ADOÁ¬½Óʧ°Ü!");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath(__IMPL__."/db2.mdb");
$conn->Open($connstr);
return $conn;
}
}
?>
²Ù×÷£º
д£º
$sql="insert into stu (name) values ('$name')";
$rs = $conn->Execute($sql);
¶Á£º
$rs=$conn->Execute('select * from stu');
while(!$rs->EOF){
$id=$rs->fields['id']->value;
$name=$rs->fields['name']->value;
$rs->movenext();
}
$rs->close();
$conn->close();
¸Ä£º
$sql="update stu set age='".$age."' where id=".$id;
$rs=$conn->Execute($sql);
$conn->close();
ɾ£º
$sql="delete from stu where id=".$id;
$rs = $conn->Execute($sql);
$conn->close();
·½·¨¶þ£º
<?php
class Access1{
function getConn(){
$connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath(__IMPL__."/db2.mdb");
&nbs
Ïà¹ØÎĵµ£º
Ð¶ÔØMysql
[root@localhost ~]# rpm -qa | grep mysql
mysql-3.23.58-9
php-mysql-4.3.4-11
mod_auth_mysql-20030510-4.1
mysql-server-3.23.58-9
˵Ã÷£ºrpm –qa | grep mysql ÃüÁîÊÇΪÁ˰ÑmysqlÏà¹ØµÄ°ü¶¼ÁгöÀ´£¬Ð¶Ôض¼´Ó×îÏÂÃæµÄÒ»¸ö°ü¿ªÊ¼£¬Ö±µ½Ð¶ÔصôµÚÒ»¸öΪֹ¡£Ö´ÐÐrpm -q php£¬Èç¹û·µ»Øphp°æ±¾£¬ ......
±àд¹ØÓÚ PHP µÄϵÁÐÎÄÕÂÈÃÎÒ¸ü¼ÓÉî¿ÌµØÁ˽âÁË PHP ¿ª·¢ÈËÔ±µÄÊÀ½ç¡£ÎÒºÍÐí¶à PHP ³ÌÐòÔ±½»Ì¸¹ý£¬×îÁîÎÒ¾ªÆæµÄÊÇÖ»ÓкÜÉÙµÄÈËʹÓà IDE¡£´ó¶àÊý³ÌÐòԱʹÓÃÎı¾±à¼Æ÷£¬±ÈÈç Microsoft® Windows® ÉϵļÇʱ¾¡¢Emacs »òÕß Vim¡£
ÎÒÌáµ½µÄÕâЩÎı¾±à¼Æ÷£¨ÒÔ¼°ÎÒûÌáµ½£©¶¼ÊǺܲ»´íµÄ —— ÎÒ²»ÏëÌÖÂÛ ......
1.ËùÓеÄÊý¾Ý¶¼Ó¦¸ÃÒþ²ØÔÚËùÔÚµÄÀàµÄÄÚ²¿¡£
2.ÀàµÄʹÓÃÕß±ØÐëÒÀÀµÀàµÄ¹«¹²½Ó¿Ú£¬µ«À಻ÄÜÒÀÀµËûµÄʹÓÃÕß¡£
3.¾¡Á¿¼õÉÙÀàÐÒéÖеÄÏûÏ¢¡£
4.ʵÏÖËùÓÐÀà¶¼Àí½âµÄ×î»ù±¾µÄ½Ó¿Ú¡££¨¿½±´²Ù×÷£¬°üÀ¨É±´ºÍdz¿½±´£©£¬ÏàµÈÐÔÅжϣ¬ÕýÈ·Êä³öÄÚÈÝ£¬´ÓASC2ÃèÊö½âÎöµÈµÈ¡£
5.²»°ÑʵÏÖϸ½ÚÈç·ÀÖ¹¹«¹²´úÂëµÄ˽Óк¯Êý.·Åµ½ÀàµÄ¹²Óнӿ ......
HTML clipboard
Revealing the revolutionary fingerprint access clocking in/out system for
businesses. No more cards, no more paperwork, no more hassle! This digital
fingerprint access terminal and data logger registers finger prints for time
management plus also works as an authorized pe ......
//¶ÁÈ¡±ê×¼Áбí
private void setModelList()
{
OleDbConnection Connection = null;
&n ......