PHP ÖÆ×÷ͨѶ¼£¨Î壩
ͨѶ¼ÒѾ´óÖÂÍê³ÉÁË£¬µ«Èç¹û¼Ç¼Êý¶àʱ£¬²éÕÒÆðÀ´ºÜ²»·½±ã£¬Èç¹û¼ÓÒ»¸öËÑË÷¹¦ÄܾͺÃÁË¡£½ñÌìÎÒÃǾÍÀ´ÖÆ×÷Ò»¸öËÑË÷¹¦ÄÜ
ÔÚIndex.phpºÏÊʵĵط½¼ÓÈëËÑË÷¿ò
<!---ËÑË÷¿ò--->
<!--ÕâÀïµÄËùÓÐÖµÇ°Ãæ¼Óǰ׺“S_”ÒÔÇø·Ö-->
<form id="form1" name="form1" method="post" action="Search.php">
ËÑË÷£º
<label>
<select name="select">
<option value="S_all" selected="selected">È«²¿</option>
<option value="S_name">ÐÕÃû</option>
<option value="S_birthday">ÉúÈÕ</option>
<option value="S_qq">QQ</option>
<option value="S_mobile">ÊÖ»ú</option>
<option value="S_email">ÓÊÏä</option>
<option value="S_address">µØÖ·</option>
</select>
</label>
<label>
<input name="S_word" type="text" id="S_word" />
</label>
<label>
<input type="submit" name="Submit" value="ËÑË÷" />
</label>
</form>
н¨Ò»¸öеÄPHPÎļþ£¬±£´æÎªSearch.php
<?php
include ('Config.php');
$word = $_POST['S_word']; //ËÑË÷¹Ø¼ü×Ö
$mode = $_POST['S_mode']; //ËÑË÷·½Ê½
switch($mode)
{
case 'S_all': $sql = 'SELECT * from `'.SqlDataBase.'`.`'.SqlTableName."`
WHERE `Name` LIKE '%$word%' OR `Birthday` LIKE '%$word%'
OR `QQ` LIKE '%$word%' OR `Mobile` LIKE '%$word%'
OR `Email` LIKE '%$word%' OR `Address` LIKE '%$word%'";break;
case 'S_name': $sql = 'SELECT * from `'.SqlDataBase.'`.`'.SqlTableName."`
WHERE `Name` LIKE '%$word%'"; break;
case 'S_birthday': $sql = 'SELECT * from `'.SqlDataBase.'`.`'.SqlTableName."`
WHERE `Birthday` LIKE '%$word%'"; break;
case 'S_qq': $sql =
Ïà¹ØÎĵµ£º
¡¡×î½üÔÚÕÛÌÚ PHP + MYSQL
µÄ±à³Ì¡£Á˽âÁËһЩ PHP SQL ×¢Èë¹¥»÷
µÄ֪ʶ£¬ÓÚÊÇдÁËÕâÆªÎÄÕ¡¡http://www.xiaohui.com/weekly/20070314.htm£¬×ܽáһϾÑé¡£ÔÚÎÒ¿´À´£¬Òý·¢ SQL ×¢Èë¹¥»÷
µÄÖ÷ÒªÔÒò£¬ÊÇÒòΪÒÔÏÂÁ½µãÔÒò£º
¡¡¡¡1. php ÅäÖÃÎļþ php.ini ÖÐµÄ magic_quotes_gpc
Ñ¡ÏîûÓдò¿ª£¬±»ÖÃΪ off
¡¡¡¡2. ¿ª·¢ ......
Ò»¡¢session¸ÅÊö
sessionÊÇʲô£¬¸Õ¿ªÊ¼ÎÒÒ²²»Ã÷°×£¬·Çרҵ´Êµä·ÒëΪ»áÒ飬»áÒéÆÚ¡£Ö±µ½½Ó´¥aspºó²ÅÖªµÀsessionÊǸÉʲôµÄ£¬ÓÐʲôÓá£×÷¸ö²»Ì«Ç¡µ±µÄ±ÈÓ÷°É£¨ËäÈ»²»Ç¡µ±£¬µ«ÒâÒåÈ´ÊÇÒ»ÑùµÄ£©£¬session¾ÍºÃÏóÄãºÍÄãÅ®ÓÑ(»òÆÞ×Ó)Ö®¼äµÄ¸ÐÇéËÆµÄ£¬sessionÊÇÄãºÍÍøÕ¾Ö®¼äµÄ¸ÐÇé¡£
se ......
1. ¼ÆËã»úÏà¹Ø×¨Òµ±¾¿Æ¼°ÒÔÉÏѧÀú£¬2ÄêÒÔÉÏÏà¹Ø¹¤×÷¾Ñé
2. ¾«Í¨PHP+Mysql¡¢AjaxµÈÏà¹Ø¿ª·¢
3. ¾«Í¨Javascript¡¢Html¡¢CSSµÈǰ¶Ë¼¼Êõ£¬²¢ÄÜÊìÁ·Ê¹ÓÃPrototype¡¢jQueryµÈ¿ªÔ´¿ò¼Ü
4. ¾«Í¨Mysql¡¢SqlServerµÈÊý¾Ý¿â
5. ÊìϤMVCģʽ¿ª·¢
6. ÊìϤWINDOWS¡¢LINUX¡¢UNIXµÈ²Ù×÷ϵͳ
7. ÊìϤApache¡¢IIS¡¢ZENDµÈÓ¦ÓÃ
3 ......
PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......