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

phpÁ¬½Ómysql²âÊÔºÍÅäÖÃ


phpÁ¬½Ómysql²âÊÔ´úÂ룺
$link=mysql_connect('localhost','root','123456');
if(!$link) echo "ʧ°Ü!";
else echo "³É¹¦!";
mysql_close();
?>
ÔËÐдúÂë³öÏÖ£ºCall   to   undefined   function   'mysql_connect()'… ʧ°Ü
°Ù¶ÈÕÒµ½½á¹ûÊÇPHP+MYSQL »·¾³Ã»ÅäÖúÃ, php5 µÄĬÈÏ mysql ÊǹرյÄ
½«php_mysql.dllºÍlibmysql.dllÎļþ¿½±´ÖÁc:\winnt\system32ÖУ¨ÎÒ©ÁËlibmysql.dll£©
ÕÒµ½php.iniÖеÄ;extension=php_mysql,È¥µôÇ°ÃæµÄ";"   ÖØÆô·þÎñÆ÷.


Ïà¹ØÎĵµ£º

phpÊý¾Ý¿âµ¼³öÀà µ¼³öJSON,XML,WORD,EXCEL

from£ºhttp://www.xland.com.cn/article/7/81/0804/28778.htm
±¾ÀàʵÏÖ£º
Êý¾Ý¿âÐÅÏ¢µ¼³ö£ºword£¬excel£¬json£¬xml£¬sql
Êý¾Ý¿â»Ö¸´£º´Ósql£¬´ÓÎļþ
¾ßÌåÓ÷¨:
Ê×ÏÈн¨²âÊÔÓÃÊý¾Ý¿âmytest£¬È»ºóÔÚÀïÃæ½¨Õűí
PHP´úÂë:
ÒÔÏÂÊÇ´úÂëÆ¬¶Î£º
--
-- ±íµÄ½á¹¹ `test`
--
CREATE TABLE `test` (
   `id ......

MySQLÊý¾Ý¿âÈÕÖ¾

MySQLÊý¾Ý¿âÈÕÖ¾
selectÈÕÖ¾
slow selectÈÕÖ¾
±ä¸üÈÕÖ¾
¶þ½øÖƱä¸üÈÕÖ¾(binlog)
¸æ¾¯ÈÕÖ¾
´íÎóÈÕÖ¾¡£
¿ÉÒÔÔÚmy.cnfÖÐÅäÖÃ
²ÎÊý
˵Ã÷
log
Îı¾selectÈÕÖ¾£¬¼ÇÏÂËùÓеÄMySQLµÄÃüÁî²Ù×÷£¬
log-update
Îı¾±ä¸üÈÕÖ¾
log-bin
Õâ¸ö¶¼ÖªµÀÁË£¬Êý¾Ý¿â¸´ÖƵÄʱºò±Ø±¸
binlog_cache_size
ÁÙʱ´æ·Åij´ÎÊÂÎñµÄSQL ......

mysqlµÃµ½²éѯ½á¹ûµÄͬʱͳ¼Æ²éѯ½á¹ûµÄÊýÄ¿

×öһЩÊý¾Ý¿â²éѯ£¬²»½öÏ£ÍûµÃµ½Òª²éѯµÄ½á¹û£¬»¹Ï£Íû·½±ãµØÍ³¼ÆÒ»Ï²éѯ½á¹ûÖÐÓжàÉÙÌõ¼Ç¼¡£ÎÒͨ³£µÄ×ö·¨ÊÇ£º
$q = "select * from $fromTable where $where limit $start,$pageSize";
$r = mysql_query($q);
$q = "select count(*) from $fromTable where $where";
$cnt = mysql_query($q);
µ± ......

json + js + php ¼òµ¥½»»¥

×î½üÔÚдһ¸ö ǰ̨»ùÓÚ javascript. µÄ¿Í»§¶Ë ·þÎñÆ÷¶ËPHP µÄ·ÖÎöϵͳ¡£
Ô­Ïȼƻ®Ê¹ÓÃXMLΪÊý¾Ý½»»¥»ù´¡ µ«ÊÇ×îÖÕ»¹ÊÇÑ¡ÓýÏÇáÁ¿¼¶µÄJSON×îΪÊý¾Ý½»»¥»ù´¡¡£
Ê×ÏȽéÉÜjsonµÄ¸ñʽ
json ˵¼òµ¥ÆäʵÊÇÒ»ÖÖÊý¾Ý¸ñʽ  ¸ü¼òµ¥µÄ¿ÉÒÔ¿´×ö¼òµ¥µÄÊý×é¡£
ʵÀý £¨Ò»£©
<script>
  var jsonArray=[
   ......

MySql ±íµÄÖ÷¼üË÷ÒýÎÊÌâ

²é¿´Ä³¸ö±íµÄ½¨±íÓï¾ä £ºshow create table data_statdata;
drop index ts on data_statdata;
Ë÷ÒýÊǼÓËÙ²éѯµÄÖ÷ÒªÊֶΣ¬Ìرð¶ÔÓÚÉæ¼°¶à¸ö±íµÄ²éѯ¸üÊÇÈç´Ë¡£±¾½ÚÖУ¬½«½éÉÜË÷ÒýµÄ×÷Óá¢Ìص㣬ÒÔ¼°´´½¨ºÍɾ³ýË÷ÒýµÄÓï·¨¡£
13.4.1 ʹÓÃË÷ÒýÓÅ»¯²éѯ
Ë÷ÒýÊÇ¿ìËÙ¶¨Î»Êý¾ÝµÄ¼¼Êõ£¬Ê×ÏÈͨ¹ýÒ»¸öʾÀýÀ´Á˽âÆäº¬Òå¼°×÷Óã ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ