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
Ïà¹ØÎĵµ£º
½ñÌìÓÖͻȻ·¢ÏÖÁËÒ»¸ö¼¼ÇÉ£¬¾ÍÊÇPHP¿ÉÒÔ´«Öµ¸øjs£¬ÈçºÎ×öÄØ£¿
ÔÀ´PHPµÄÔÀíÊÇÕâÑùµÄ£º
PHPµÄËùÓÐÓ¦ÓóÌÐò¶¼ÊÇͨ¹ýWEB·þÎñÆ÷(ÈçIIS»òApache)ºÍPHPÒýÇæ³ÌÐò½âÊÍÖ´ÐÐÍê³ÉµÄ£¬¹¤×÷¹ý³Ì£º
(1)µ±Óû§ÔÚä¯ÀÀÆ÷µØÖ·ÖÐÊäÈëÒª·ÃÎʵÄPHPÒ³ÃæÎļþÃû£¬È»ºó»Ø³µ¾Í»á´¥·¢Õâ¸öPHPÇëÇ󣬲¢½«ÇëÇó´«ËÍ»¯Ö§³ÖPHPµÄWEB·þÎñÆ÷¡£
(2)WEB·þÎñÆ ......
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 ......
1.ÀàºÍ¶ÔÏó¡£
ÀàÊÇÒ»ÀàÊÂÎïµÄÃèÊö¡£³éÏ󣬸ÅÄîÉϵ͍Òå¡£
¶ÔÏóÊÇʵ¼Ê´æÔÚµÄÿ¸ö¸öÌå¡£Ò²½ÐʵÀý¡£¶ÔÏóÊÇnew³öÀ´µÄ¡£$p = new Person();
2.ÊôÐÔ
ÓÃÀ´ÃèÊöÀàÖеÄÊý¾ÝÔªËØ¡££¨Ò²½ÐÊý¾Ý/״̬£©
ÐÞÊηû£¨PHP5ÖбØÐëÐÞÊΣ©:public(¹«¿ª,ÀàµÄÄÚÍⲿ¶ÁÈ¡ÐÞ¸Ä),private(˽ÓÐÖ»ÔÚµ±Ç°ÀàÖжÁÈ¡ÐÞ¸Ä),protected(±£»¤,ÄÜÔÚÕâ¸öÀàºÍ ......
=================================
mb_substr($str, 0, 1, "gbk");
Èç¹ûÌṩÁ˵ÚËĸö²ÎÊý£¬php»á½âÎöÕâ¸ö²ÎÊý
1. ½«Õâ¸ö²ÎÊýת»»³É×Ö·û´®.
2. µ÷ÓÃmbfl_name2no_encoding»ñµÃ±àÂëÆ÷ÐòºÅ
3. µÚ¶þ²½»áµ÷ÓÃmbfl_name2encoding£¬Õâ¸öº¯ÊýÔÚÑ»·ÖÐʹÓÃÁËstrcasecmp
strcasecmpÊǺöÂÔ´óСдµÄ×Ö·û´®Æ¥Å䣬ÐÔÄܺܵͣ¬
......