ÓÃPHP×ö¸öÈ˲ÅÕ¾
×î½üÓÐÈËÔÚÕбêÒª×ö¸öÏñ£ºwww.webjianzhi.com ÕâÑùµÄÈ˲ÅÕ¾£¬³õ¿´£¬Õâ¸öÍøÂç¼æÖ°Íø£¬½çÃæ»¹ÊDZȽÏÇåÎúµÄ¡£
ÕûÌå·ÖÎöÁËһϣ¬Ò»¸öÐÂÎÅÎÄÕ·¢²¼ÏµÍ³£¬Õâ¸ö²»ÊǺÜÄÑ£¬ÁíÒ»¸ö¾ÍÊÇ×ֶε÷ÓÃϵͳ£¬¾ÍÊÇÊ×Ò³µÄÖ°Òµ½éÉÜ£¬¼æÖ°ÈËÆø£¬µÄÕâЩµ÷Óá£
ÁíÒ»¸ö¾ÍÊÇ»áÔ±·¢²¼ÏµÍ³¡£
Õû¸öÓñí¸ñ²¼¾Ö£¬ÃÀ¹¤Éϲ»´æÔÚÈκÎÎÊÌâ¡£
ÓÃPHP×ö£¬Ò»¸öÐÇÆÚÀÖÕÓÚÕû³öºÍÕâ¸ö²î²»¶àµÄÍøÕ¾ÁË£¬Ö»ÊÇ»áÔ±ÉÏ»¹ÓÐЩ²î±ð¡£¡£
Ïà¹ØÎĵµ£º
ÉùÃ÷£¨±¾ÎÄ×ªÔØ×Ô£©£ºhttp://www.phpzc.com/read.php?tid=643
ltrim();//È¥µô×Ö·û´®×ó¿Õ¸ñ;
rtrim();//È¥µô×Ö·û´®ÓÒ¿Õ¸ñ;
trim(); //È¥µô×Ö·û´®Á½±ß¿Õ¸ñ;
//È¥µô¿Õ¸ñÊÇ·µ»ØÒ»¸öеÄ×Ö·û´®;Ô×Ö·û´®²»±ä;
strlen(); //¼ÆËã×Ö·û´®³¤¶È;
......
ÒÔS2µÄBBSÂÛ̳ÏîÄ¿×÷ΪÕû¸ö»ù´¡¿Î³ÌµÄ°¸Àý¡£
1.Á¬½ÓÊý¾Ý¿âºÍÖ´ÐеÚÒ»¸öSQLÓï¾ä:
1)PHPÌṩÁËÁ¬½ÓÊý¾Ý¿âµÄº¯Êý--mysqli_connect(agrs0,agrs1,agrs3)£¬ÎÒÃÇÖ±½ÓʹÓþͿÉÒÔÁË¡£
´Ëº¯Êý°üÀ¨Èý¸ö±ØÒªµÄ²ÎÊý£¬·Ö±ðΪ£ºlocalhost£¬Êý¾Ý¿âÓû§Ãû£¬Êý¾ÝÔ´¡£
ÒÔbbsÂÛ̳Á¬½ÓMy ......
¡¡×î½üÔÚÕÛÌÚ PHP + MYSQL
µÄ±à³Ì¡£Á˽âÁËһЩ PHP SQL ×¢Èë¹¥»÷
µÄ֪ʶ£¬ÓÚÊÇдÁËÕâÆªÎÄÕ¡¡http://www.xiaohui.com/weekly/20070314.htm£¬×ܽáһϾÑé¡£ÔÚÎÒ¿´À´£¬Òý·¢ SQL ×¢Èë¹¥»÷
µÄÖ÷ÒªÔÒò£¬ÊÇÒòΪÒÔÏÂÁ½µãÔÒò£º
¡¡¡¡1. php ÅäÖÃÎļþ php.ini ÖÐµÄ magic_quotes_gpc
Ñ¡ÏîûÓдò¿ª£¬±»ÖÃΪ off
¡¡¡¡2. ¿ª·¢ ......
phpºÍjavaͨÓÃsqlÓï¾ä·¨
SELECT max(id) from table
¸Ã·½·¨ÔÚ¶àÏ̵߳ÈÇé¿öÏ¿ÉÄÜ»áÔì³É²»ÕýÈ·¡£
javaÈýÖÖ·½·¨
1¡¢¸ù¾ÝpsµÄgetGeneratedKeys
PreparedStatement ps = conn.prepareStatement(sql,Statement.RETURN_GENERATED_KEYS); //ºìÉ«Êǹؼü
ps.executeUpdate(); //Ö´Ðкó
ResultSet rs = ps.getGeneratedKeys ......
PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......