Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

php Á¬½ÓÊý¾Ý¿âµÄÀà

<?php
class Access//AccessÊý¾Ý¿â²Ù×÷Àà
{
var $databasepath,$constr,$dbusername,$dbpassword,$link;//ÀàµÄÊôÐÔ
function Access($databasepath,$dbusername,$dbpassword)//¹¹Ô캯Êý
{
$this->databasepath=$databasepath;
$this->username=$dbusername;
$this->password=$dbpassword;
$this->connect();
}

function connect()//Êý¾Ý¿âÁ¬½Óº¯Êý
{
$this->constr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath($this->databasepath);
$this->link=odbc_connect($this->constr,$this->username,$this->password,SQL_CUR_USE_ODBC);
return $this->link;
//if($this->link) echo "¹§Ï²Äã,Êý¾Ý¿âÁ¬½Ó³É¹¦!";
//else echo "Êý¾Ý¿âÁ¬½Óʧ°Ü!";
}

function query($sql)//ËÍÒ»¸ö²éѯ×Ö·û´®µ½Êý¾Ý¿âÖÐ
{
return @odbc_exec($this->link,$sql);
}

function first_array($sql)//´ÓaccessÊý¾Ý¿âÖзµ»ØÒ»¸öÊý×é
{
return @odbc_fetch_array($this->query($sql));
}

function fetch_row($query)//·µ»Ø¼Ç¼ÖеÄÒ»ÐÐ
{
return odbc_fetch_row($query);
}

function total_num($sql)//È¡µÃ¼Ç¼×ÜÊý
{
return odbc_num_rows($this->query($sql));
}

function close()//¹Ø±ÕÊý¾Ý¿âÁ¬½Óº¯Êý
{
odbc_close($this->link);
}

function insert($table,$field)//²åÈë¼Ç¼º¯Êý
{
$temp=explode(',',$field);
$ins='';
for ($i=0;$i<count($temp);$i++)
{
$ins.="'".$_POST[$temp[$i]]."',";
}
$ins=substr($ins,0,-1);
$sql="INSERT INTO ".$table." (".$field.") VALUES (".$in


Ïà¹ØÎĵµ£º

phpÏÂÔØÎļþ´úÂë

Ò»°ãµÄÎļþ°²È«ÏÂÔØ·½·¨¿ÉÒÔʹÓÃÏÂÃæµÄ´úÂë:
1. <?php?
2.
3. $durl = 'file/phpcms2008_o2abf32efj883c91a.iso';
4. $filename = 'phpcms2008_o2abf32efj883c91a.iso';
5. $file = @fopen($durl, 'r');
6. header("Content-Type: application/octet-stream");
......

¹ØÓÚphp дÎļþ ²»»»ÐÐ µÄÎÊÌâ

  ½ñÌìÓöµ½ÁËÒ»¸ö¹ÖÎÊÌ⣬ÎÒÓÃ$fp=fopen("access_log.txt","ab")´ò¿ªÒ»¸öÎļþºó¿ªÊ¼ÍùÀïÃæÐ´Êý¾Ý£¬Ð´µÄÄÚÈÝÊÇ 'XXX\nXXX\n'£»
  µ«ÊÇÆæ¹ÖµÄÊÇ ²»¹ÜÎÒÔõôÍùÀïÃæÐ´ ËûÊDz»»»ÐÐ,¼Çʱ¾Àï¼Ç¼µÄÊý¾Ý ¾ÍÊÇ 'xxx\nxxx\n'£¬
  ºÜÊÇÄÕ»ð£¬È¥ÍøÉÏËѼ¯×ÊÁÏ£¬ÓеÄ˵¸Ä³É'\r\n'ʲôµÄ£¬½á¹ûÊÇд½øÈ¥ºó»¹ÊÇ 'xxx\r\nxx ......

php PDO Á´½Ó mysql ×î¼òµ¥ ʵÀý

define("DB_SERVER","127.0.0.1");
define("DB_PORT",3306);
define("DB_CATALOG","uab");
define("DB_USERID","root");
define("DB_PASSWORD","");
$dsn="mysql:host=".DB_SERVER.";port=".DB_PORT.";dbname=".DB_CATALOG;
self::$__PDO=new PDO($dsn, DB_USERID, DB_PASSWORD);
//support long connection
self:: ......

php½«excelµ¼Èëmysql

£¨×ª×Ôhttp://www.jb51.net/article/20829.htm£©
ÕâÀï½éÉÜÒ»¸öÖ±½Ó½«excelÎļþµ¼ÈëmysqlµÄÀý×Ó¡£ÎÒ»¨ÁËÒ»ÍíÉϵÄʱ¼ä²âÊÔ£¬ÎÞÂÛµ¼Èë¼ò·±Ìå¶¼²»»á³öÏÖÂÒÂ룬·Ç³£ºÃÓá£
PHP-ExcelReader,ÏÂÔØµØÖ·: http://sourceforge.net/projects/phpexcelreader
˵Ã÷£º
²âÊÔ»·¾³£ºMYSQLÊý¾Ý¿â²ÉÓÃutf8±àÂë.µ¼ÈëEXCELÎĵµÊÇxls¸ñʽ,¾­¹ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ