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
Ïà¹ØÎĵµ£º
1¡¢Ç°ÑÔ
¡¡¡¡·ÖÒ³ÏÔʾÊÇÒ»Öַdz£³£¼ûµÄä¯ÀÀºÍÏÔʾ´óÁ¿Êý¾ÝµÄ·½·¨£¬ÊôÓÚweb±à³ÌÖÐ×î³£´¦ÀíµÄʼþÖ®Ò»¡£¶ÔÓÚweb±à³ÌµÄÀÏÊÖÀ´Ëµ£¬±àдÕâÖÖ´úÂëʵÔÚÊǺͺôÎüÒ»Ñù×ÔÈ»£¬µ«ÊǶÔÓÚ³õѧÕßÀ´Ëµ£¬³£³£¶ÔÕâ¸öÎÊÌâÃþ²»×ÅÍ·Ð÷£¬Òò´ËÌØµØ×«Ð´´ËÎĶÔÕâ¸öÎÊÌâ½øÐÐÏêϸµÄ½²½â£¬Á¦ÇóÈÿ´ÍêÕâÆªÎÄÕµÄÅóÓÑÔÚ¿´ÍêÒÔºó¶ÔÓÚ·ÖÒ³ÏÔʾµÄÔ ......
1.ÊÇ·ñ¿ÉÒÔÔÚÀàµÄÍⲿ·ÃÎÊÒ»¸öÊôÐÔÊÇÓÉ·ÃÎÊÐÞÊηûÀ´È·¶¨µÄ¡£
2.´ÓÀàµÄÍⲿֱ½Ó·ÃÎÊÀàµÄÊôÐÔÊÇÔã¸âµÄÏë·¨¡£ÃæÏò¶ÔÏóµÄÒ»¸ö·½·¨¾ÍÊǹÄÀø·â×°¡£ÔÚPHPÖУ¬ÎÒÃÇÒ»°ãͨ¹ý__get()Óë__set()º¯ÊýÀ´ÊµÏÖ¶Ô
ÊôÐԵķÃÎÊ.Èç¹û²»Ö±½Ó·ÃÎÊÒ»¸öÀàµÄÊôÐÔ¶øÊDZàд·ÃÎʺ¯Êý£¬ÄÇô¿ÉÒÔͨ¹ýÒ»¶Î´úÂëÖ´ÐÐËùÓзÃÎÊ¡£×î³õµÄ·ÃÎʺ¯ÊýÈçÏÂËùʾ:
cla ......
1.echo();2.print();3.die();4.printf();5.sprintf();6.print_r;7.var_dump();
1.echo()
Êä³ö¶à¸ö×Ö·û´®£¬¿ÉÒÔ¶à¸ö²ÎÊý£¬²»ÐèÒªÔ²À¨ºÅ£¬ÎÞ·µ»ØÖµ¡£
2.print()
Ö»ÄÜÊä³öÒ»Ñù¶«Î÷£¬ÐèÒªÔ²À¨ºÅ£¬Óзµ»ØÖµ£¬Ö´ÐÐʧ°ÜÊÇ·µ»Øflase.
3.die()
Êä³öÄÚÈÝ£¬Í£Ö¹³ÌÐò¡£*¶àÓÃÓÚÊý¾Ý¿âµÄÁ´½Óʱ£¬¼ìÑéÊÇ·ñ³ö´í¡£
4.printf()
prin ......
//¶ÁÈ¡±ê×¼Áбí
private void setModelList()
{
OleDbConnection Connection = null;
&n ......
<?
php define('__TYPECHO_ROOT_DIR__', dirname(__FILE__));
define('__TYPECHO_PLUGIN_DIR__', '/usr/plugins');
@set_include_path(get_include_path() . PATH_SEPARATOR . __TYPECHO_ROOT_DIR__ . '/var' . PATH_SEPARATOR . __TYPECHO_ROOT_DIR__ . __TYPECHO_PLUGIN_DIR__);
ÄÜÏêϸµÄ½âÊÍÕâ¸öº¯ÊýÂ𣿵±È»Î ......