phpÁ¬½ÓaccessµÄÎÊÌâ - PHP / »ù´¡±à³Ì
ÓÃphpÈçºÎÁ¬½ÓaccessÊý¾Ý¿â£¬²¢¶ÔÊý¾Ý½øÐÐÔöɾ¸Ä²é£¬ÒÔÏÂÊÇÎҵĴúÂ룬
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("..\shuju\pos.mdb ");
$conn->Open($connstr);
if($_POST[Submit2]=="Ìá½»")
{
$datea=date("Y-m-d");
$title=$_POST["title"];
$text=$_POST["text"];
$sql="insert into news (title,text,datea) values('$title','$text','$datea')";
$rs->open($sql,$conn,4,4);
echo "Ìí¼Ó³É¹¦";
}µ«ÊÇÌáʾÌí¼Ó³É¹¦¡£Êý¾Ý¿âÀïÃæÈ´Ã»ÓÐÊý¾Ý¡£¸÷λ´óÏÀ°ïæ½â¾öÏ¡£
ûÓùýphp+access£¬°ï¶¥
Óà php+mysql ²»ÊǺܺÃÂð£¿
ÄǸö¹«Ë¾ÊÇСÐ͹«Ë¾£¬Êý¾ÝÁ¿Ì«Ð¡¡£ºÇºÇ¡£²¢ÇÒÕâÒ²ÊÇÒ»¸ö³¢ÊÔ¡£
ÄãÅжÏÏÂÓÐûÓвåÈë°¡
ÔõôÅжϣ¬¶ÔÕâ¸ö¶«Î÷²»ÊǺܶ®¡£×Ôѧphp²ÅÒ»¸öÔ¡£
Óà php+mysql ²»ÊǺܺÃÂð£¿
Ïë³¢ÊÔÏ¡£²¢ÇÒ¿Í»§ÒªÇóÓÃaccess¡£
ÎҵĽ¨ÒéÊÇʹÓÃADODB¡£Õâ¸öºÃÓÃһЩ¡£
ÄãµÄÄǸö°æ±¾ÊÇÀÏʽµÄÁ¬½Ó·½·¨¡£
ÎÒÔø¾ÊÔ¹ý£¬²»¹ýÊÇͨ¹ýͼÐλ¯´î½¨µÄODODB ²Å³É¹¦¡£Ê¹ÓÃÓï¾äÒ²³öÁËÎÊÌâ¡£
ÎÒÒ²²»Çå³þΪʲôÓÐʱºòÄÇÖÖÓï¾äʽµÄÁ¬½ÓAccessÓÐÎÊÌâ¡£
Äã˵µÄÕâÖÖÐÂʽµÄÁ¬½ÓºÃÏñÄǸö·þÎñÆ÷²»Ö§³Ö¡£ÓôÃÆ¡£²»¹ýºÜлл¡£
ÏÔʾ Ìí¼Ó³É¹¦
Ö»±íʾ³ÌÐòûÓÐÒòΪ´íÎó¶øÖжÏ
ËùÓÐÈë¿âµÄÎı¾Êý¾Ý¶¼Òª×ªÒåÌØÊâ×Ö·û¡°'¡±,×¢ÒâÊÇת³É£º''£¬¶ø²»ÊÇ\'
²»ÖªµÀÄãµÄ datea ×
Ïà¹ØÎÊ´ð£º
ÎÒ¸ÕѧϰphpÇëÎÊ£¬Èç¹ûÎÒ°ÑphpÎļþÉÏ´«ÖÁ·þÎñÆ÷ºó£¬ÀýÈçhttp://www.****.com/cast.phpÕâ¸öÎļþ»á²»»á±»±ðÈËÏÂÔØ»ò¸´Öư¢£¿
¿ÉÒÔ±»ÏÂÔØ£¬Ò²¿ÉÒÔ²»±»ÏÂÔØ£¬¿´web·þÎñÆ÷¶Ô¸ÃÎļþȨÏÞµÄÅäÖÃ
¿´Äã¶ÔÎļþȨÏÞµÄÉèÖÃ
......
index.phpÄÚÈÝ£º
$smarty->assign('name',strtotime('-0'));
$smarty->display("index.html");
index.htmlÄÚÈÝ£º
{$name|date_format:'%Y-%m-%d'}<hr>
{$ ......
ÔÚfirefoxä¯ÀÀÆ÷ÏÂÕý³£µÇ½£¬µ«ÔÚIE ä¯ÀÀÆ÷ÏÂÎÞ·¨µÇ½£¬Ã¿´Î¶¼»áÖØÐÂÉú³ÉÒ»¸ösession,ÔÀ´µÄÄÚÈݻᶪʧ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£Ôõô»ØÊÂ......
¾ßÌåÇé¿ö£¿²Â²â¿ÉÄÜÊÇÄã±¾»úIEµÄcookie±»½ûÓÃÁ˰ɣ¬¿ÉÒÔ¿´¿´
cookie Æ ......
ÏÖÓÐÒ»PHP¿Õ¼ä£¬Ö§³ÖMYSQLÊý¾Ý¿â
Ϊ½ÚÊ¡·ÑÓã¬ÏÖÏëͨ¹ýÓòÃûתÏòĿ¼ÐÎʽ½øÐйÜÀí£¨¼´½«ÓòÃûA¼Ç¼£Û°üÀ¨¶¥¼¶ÓòÃû¼°¶þ¼¶ÓòÃû£Ý¶¼Ö¸Ïòͬһ¿Õ¼ä£©
È磺·ÃÎÊÓòÃû abcd.cn Ö±½Ó·ÃÎÊÍøÕ¾¸ùĿ¼
·ÃÎʶþ¼¶ÓòÃû ef.abcd.cn ......
ÎÒ×î½üдÁ˸ömailÖ´ÐкóûÓгöÏÖ´íÎóÐÅÏ¢Ö´ÐÐÍê±ÏºóÓÊÏäÀﲢû·¢ËÍÓʼþ£¬Çë¸÷λ°ïÎÒ¿´¿´
ÎÒÓõĵÄÊÇiis smtp
<?php
$to = 'xueyuxia1988@sohu.com';
$subject = 'the subject';
$message = 'hello';
$ ......