PHP ³õʶ
ÒÔS2µÄBBSÂÛ̳ÏîÄ¿×÷ΪÕû¸ö»ù´¡¿Î³ÌµÄ°¸Àý¡£
1.Á¬½ÓÊý¾Ý¿âºÍÖ´ÐеÚÒ»¸öSQLÓï¾ä:
1)PHPÌṩÁËÁ¬½ÓÊý¾Ý¿âµÄº¯Êý--mysqli_connect(agrs0,agrs1,agrs3)£¬ÎÒÃÇÖ±½ÓʹÓþͿÉÒÔÁË¡£
´Ëº¯Êý°üÀ¨Èý¸ö±ØÒªµÄ²ÎÊý£¬·Ö±ðΪ£ºlocalhost£¬Êý¾Ý¿âÓû§Ãû£¬Êý¾ÝÔ´¡£
ÒÔbbsÂÛ̳Á¬½ÓMySQLÊý¾Ý¿âΪÀý:
Á¬½ÓÊý¾Ý¿â£º
$db = mysqli_connect('localhost','root','bbs');
Ö´ÐÐSQLÓï¾ä£º
$sql="set names utf8"; //²åÈëÊý¾ÝʱµÄͳһ±àÂë¸ñʽÃüÁî¡£
mysqli_query('$db',$sql); //SQLÖ´ÐÐ
2)ÓÉÓÚIE¾Þ´óµÄÈÝ´íÄÜÁ¦ºÍPHPµÄÎÞ´íÎóÌáʾ£¬µ¼ÖÂÎÒÃÇÔÚÖ´ÐÐSQLÓï¾ä³ö´íʱ²»»áÏñJSPÒ»ÑùÃ÷È·µÄÌáʾÎÒÃÇ£¬ÎªÁËÎÒÃǵŤ×÷½øÕ¹¸ü˳Àû£¬ÕâʱÎÒÃǾÍÐèÒªÊÖ¶¯µÄÈÃÎÒÃǵĴíÎóÅ׳öÀ´£¬¾ßÌå´¦Àí·½Ê½ºÜÓÐÒÔϼ¸ÖÖ£º
a. ÔÚÖ´ÐеÄSQLÓï¾äºóÃæ½ô¸úÆäºóÌí¼ÓÒ»¾ä£ºecho $sql; "$sql" ¾ÍÊÇÎÒÃÇËùдµÄSQLÓï¾ä¡£
b.´ýÐø........
2.MYSQLÊý¾Ý¿âÂÒÂë´¦Àí
1) ÔÚ´´½¨±íʱעÒâÔÚ×îºó¼ÓÈëÒ»¾äÃüÁî¾Í¿ÉÒÔÁË£ºcharset ±àÂë¸ñʽ eg: charset utf8
2) ÔÚPHP´úÂëÀï(²åÈëÊý¾ÝʱµÄÏÈÖ´ÐÐÕâ¾ä´úÂë)£º mysql_query("SET NAMES utf8"); //²åÈëÊý¾ÝµÄͳһ±àÂë¸ñʽÃüÁî¡£
3.±êÇ©µÄÔÀí¾ÍÊǽ«ÎÒÃǵÄPHP½Å±¾´úÂëÌæ´ú³ÉÎÒÃÇÊìϤµÄÕýÔò±í´ïʽ¡£
4.ÔÚPHPÀïÖ´ÐÐSQLÓï¾äʱµÄ×¢ÒâÊÂÏ
1) µ±Ò»¸ö´úÂë¿éÐèÒªµ±×öÒ»¸öÕûÌåÀ´Ö´ÐÐʱ£¬ÎÒÃÇÐèÒª¶ÔÆä½øÐд¦Àí£¬Ò²¾ÍÊǽ«ÆäÓôóÀ¨ºÅÀ¨ÆðÀ´£ºeg: {$user['uPass']}
2) ÔÚPHPÀïµÄ SQLÓï¾ä²»»áÏñjsp ÀïÒ»Ñù»áͨ¹ý setString()À´×Ô¶¯Ê¶±ð±äÁ¿ÊÇ·ñΪ×Ö·û´®£¬ÓÉÓÚPHPÊÇÈõÓïÑÔ£¬ÎÒÃÇÐèÒª½«×Ö·û´®Êµ¼ÊµÄ±í´ï³öÀ´£¬¾ÍÊǽ«ÆäÓõ¥ÒýºÅÀ¨ÆðÀ´¡£
eg: '{$user['uName']}'
3) PHPÀïµÄº¯ÊýÐèÒªÓõ½PHPÀﶨÒåµÄÈ«¾Ö±äÁ¿Ê±ÐèÒªÔÚÒýÓõĺ¯ÊýÀïÓÃglobalÉùÃ÷һϡ£eg: global $db;
ÒÔBBSÂÛ̳ΪÀý,ÒÔÉÏÎÊÌâ¾ßÌå´¦ÀíÈçÏÂ:
<?php
// µ¼ÈëÊý¾Ý¿âÁ¬½Ó lib_db.php Îļþ
include('lib_db.php');18:05:24
// Ìí¼ÓÓû§º¯Êý
function addUser($user) //$user ÊÇÒ»¸öÊý×é
{
global $db;
$sql="insert into user value
Ïà¹ØÎĵµ£º
×òÌìÉϰàµÄʱºò£¬·¢ÏÖgoogle adµÄ¹ã¸æÉÏÓÐÁËÊÕÈ룬µ«ÊÇϰëÖ®ºó¾ÓÈ»·¢ÏÖad±»“0”ÁË¡£È¥ÍøÉϲéÁËÏà¹Ø×ÊÁÏ£¬·¢ÏÖÁËÎÊÌâ¡£
ÄÇôGoogleÊÇÈçºÎÈ·¶¨AdsenseÓû§×ÔÐеã»÷¹ã¸æµÄÄØ£¿
¼Çס£¬¾ÍÔÚÄãÔø¾×¢²áGoogle AdsenseÓû§µÄʱºò£¬Google¾ÍÖªµÀÄãµÄIPµØÖ·£¬×ÓÍøÒÔ¼°ÄãµçÄÔϵͳµÄÆäËû×ÊÁÏ¡£ÔÚGoogleµÄÊý¾Ý¿âÖÐÒ»Ö±¼ ......
ÎÒ×îÔç½Ó´¥µÄ±à³Ì¹¤¾ßÊÇDreamweaver£¬ÆäʵӦ¸ÃÊÇ×¼±à³Ì¹¤¾ß°É£¬ÎÒÄÇʱºòÓõĺÃÏñÊÇ
4£¬Èç¹ûÎÒûÓмǴíµÄ»°£¬È»ºóºóÀ´»¹ÓÐÒ»¸ö°æ±¾½ÐUtralµÄ£¬´Ó×î³õÆÚµÄ°æ±¾Ò»Ö±µ½ÏÖÔÚµÄCS4£¬µ±ÄêµÄMicromedia¹«Ë¾ÒѾ±»Adobe¹«Ë¾
ÊÕ¹ºÁË£¬ÎÒ»¹ÊÇÔÚÓá£ÔÚHTMLµÄ±à¼·½Ã棬DWÓÐ×ÅÎ޿ɱÈÄâµÄÓÅÊÆ£¬ÎÒÏÖÔÚд.Net»¹ÊÇϰ¹ßÔÚDWÀï½øÐÐÒ³Ãæ²¼¾ ......
#./configure --prefix=/usr/local/php5 --with-config-file-path=/usr/local/php5 --with-apxs2=/usr/local/apache2/bin/apxs --with-bz2 --with-curl - --with-curlwrappers --enable-ftp --enable-sockets --disable-ipv6 --with-gd --with-jpeg-dir=/usr/local --with-png-dir=/usr/local --w ......
1.È·ÈÏϵͳÖа²×°ÁËphp-cli
°²×°ÃüÁî:
apt-get install php5-cli
2.н¨Óû§crontab
ÃüÁ
crontab -e
ÎÒµÄcrontabÄÚÈÝÎļþÈçÏ£º
# m h dom mon dow command
SHELL=/bin/sh
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin
* */1 * * * /root/myshell/proj1.sh
*/1 * ......
ÉùÃ÷£¨±¾ÎÄ×ªÔØ×Ô£©£ºhttp://www.phpzc.com/read.php?tid=643
ltrim();//È¥µô×Ö·û´®×ó¿Õ¸ñ;
rtrim();//È¥µô×Ö·û´®ÓÒ¿Õ¸ñ;
trim(); //È¥µô×Ö·û´®Á½±ß¿Õ¸ñ;
//È¥µô¿Õ¸ñÊÇ·µ»ØÒ»¸öеÄ×Ö·û´®;Ô×Ö·û´®²»±ä;
strlen(); //¼ÆËã×Ö·û´®³¤¶È;
......