Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎĵµ£º

α¾²Ì¬URLÖØÐ´¼¼ÊõʵÏÖ·½·¨ php asp

α¾²Ì¬Óõ½ÖªÊ¶ºÜ¼òµ¥Ò»µ©Ñ§»á£¬¿ìÀÖÎÞÇֻÐèÒªÕýÔòºÍ·þÎñÆ÷ÉèÖá£
  ÏÈ˵iisÈçºÎÉèÖðɣ¬ÍùÏ¿´
  ÏÂÔØ(IIS RewriteÄ£¿é): http://www.isapirewrite.com/,ÏȰѲúÆ·ÏÂÔØÏÂÀ´,°²×°ÔÚ·þÎñÆ÷ÉÏ,¼ÇסĿ¼,»áÓÐÀàËÆRewrite.dllµÄÎļþÉú³É,MMC→IISÐÅÏ¢·þÎñ¹ÜÀíÆ÷→ÍøÕ¾→ÄúµÄÕ¾µã→ÊôÐÔ,ÔÚ“ ......

PHPµÄ°²×°ÒÔ¼°ÅäÖÃ

°²×°ÒÔ¼°ÅäÖÃ
1.       °²×°Apache-2.2.4(Apache_Dir=D:\myspace\Apache-2.2.4)
2.       ½âѹ°²×°PHP-5.2.11(PHP_Dir=D:\myspace\PHP-5.2.11)
3.       ÕÒµ½PHP-5.2.11ϵÄphp.ini-dist£¬¸ÄÃûΪphp.ini
4.  &nb ......

PHP ÎÞÏÞ·ÖÀà

<?php
//×÷Õß:ÁºÎÄÆ½ http://www.tyasp.net
session_start();
if($_SESSION["username"]!="admin")
{
echo("<mce:script type="text/javascript"><!--
alert("²Ù×÷³¬Ê±£¡ÇëÖØÐµÇ½...");window.location.href="../index.php";
// --></mce:script>");
//header("refresh:0;url=../"); ......

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ºÅ