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
Ïà¹ØÎĵµ£º
ÎÒÃÇÖªµÀÓÃpowerdesignerµ¼³öµÄsqlÎļþºó׺Ϊ'.sql'£»ÓÃphpmyadminºÜÈÝÒ×µ¼ÈëMysQLÊý¾Ý¿â£¬µ«ÊÇÓÃPHPÔõôµ¼ÈëÊý¾Ý¿âÄØ?
ÎÒÓÃpowerdesignerÉè¼ÆÒ»¸öÊý¾Ý¿âºóµ¼³ösqlÎļþ£¨Ò»¸öͶƱϵͳ£©Îª'vote.sql'£»
ÎļþÄÚÈÝΪ£¨Ò»Ð©sqlÓï¾äºÍ×¢ÊÍ£©£º
/*======================= ......
PHP³ÌÐòÉè¼ÆÖÐÖÐÎıàÂëÎÊÌâÔø¾À§ÈźܶàÈË£¬µ¼ÖÂÕâ¸öÎÊÌâµÄÔÒòÆäʵºÜ¼òµ¥£¬Ã¿¸ö¹ú¼Ò(»òÇøÓò)¶¼¹æ¶¨Á˼ÆËã»úÐÅÏ¢½»»»ÓõÄ×Ö·û±àÂ뼯£¬ÈçÃÀ¹úµÄÀ©Õ¹
ASCII Âë, ÖйúµÄ GB2312-80£¬ÈÕ±¾µÄ JIS
µÈ¡£×÷Ϊ¸Ã¹ú¼Ò/ÇøÓòÄÚÐÅÏ¢´¦ÀíµÄ»ù´¡£¬×Ö·û±àÂ뼯Æð×Åͳһ±àÂëµÄÖØÒª×÷Óá£×Ö·û±àÂ뼯°´³¤¶È·ÖΪ
SBCS(µ¥×Ö½Ú×Ö·û¼¯)£¬DBCS( ......
ÕÒÁ˺ܶàÕâÑùµÄº¯Êý£¬»¹ÊǾõµÄÕâ¸ö×îºÃÁË
$a = 'aadfdsf¶á¶¥ÌæÒ»¿Ý»ù22245¶¥ÌæsdffhѹÏÂ';
/**
* ½ØÈ¡utf-8×Ö·û
* @param string $string
* @param int$length
*
* return string
*/
function cutstr($string, $length) {
preg_match_all("/./u", $string, $info);
$i = 0;
$str = '';
foreach($inf ......
´úÂ룺
<?php
$im = imagecreatefromjpeg("ok.jpg");
$black = @imagecolorallocate($im, 0,0,0);
$jpgnumid = "ÕâÊÇǶÈ뵽ͼƬµÄÎÄ×Ö£¬½â¾öÁËÂÒÂëÎÊÌâ,
ÉÏÃæµÄok.jpgÊÇͬĿ¼ÏµÄÕÕƬ.ʹÓÃËüʱ£¬»¹ÐèÒªÓÐiconv
Ä£¿é£¡Ò²¾ÍÊÇ˵ÔÚphp.iniÀォ
[iconv]
iconv.input_encoding = ISO-8859-1
iconv.internal_encodin ......
ÖÕÓڷżÙÁË£¬ÕýÏëÔÚÕâ¸ö¼ÙÆÚÀïѧѧPHP£¬ÓÉÓÚ×Ô¼ºÓõÄÊÇ×ÀÃæ°æµÄUbuntu8.04,ÓÚÊǾÍÏë¼ÜÉèÒ»¸öLAMP»·¾³À´Ñ§PHP£¬Ò²³Ã´Ë»ú»áѧһÏÂPHP·þÎñÆ÷µÄ¼ÜÉè¡£
Ò»¡¢°²×°Ubuntu8.04
ËäȻ˵ÊÇÅäÖÃLAMP»·¾³£¬µ«ÔÚÎÄÕÂÀï²¢²»»á½²ÊöÈçºÎ°²×°Ubuntu8.04,ÒòΪ¹ØÓÚÈçºÎUbuntu8.04ÔÚÍøÉÏÒѾÓкܶàµÄ½Ì³ÌÁË£¬¾ÍËãÊÇÓ²ÅÌ°²×°Ò²ÊÇÒ»¼þºÜ¼òµ¥µÄÊÂÁ ......