mysql+php
php£«mysqlÔúʵ¸öÈË»ù±¾¹¦
Ò». 10¾ä»°
1.²»ÒªÒÀÀµregister_global=ONµÄ»·¾³£¬´ÓÄã¸Õ¶®µÃÅäÖÃphpÔËÐл·¾³ÉõÖÁÉв»Ã÷°×register_globalµÄON/OFF»á¶Ô×Ô¼ºÓÐʲôӰÏìµÄÄÇÌìÆð£¬¾ÍÓ¦¸ÃÓ¸ҵذÑËüÉèΪOFF.
2.д³ÌÐòǰ¿´¿´ÔõôÓÃerror_reporting.
3.²»¶®¾ÍÎʱ¾Éíû´í£¬µ«ÄãÐèÒªÔÚÄÇ֮ǰ²é²éÊֲᡣ
4.µ±È»£¬ÄãÐèÒª¶®µÃʹÓÃÊֲᡣÊÖ²áÉÏÕÒ²»µ½´ð°¸µÄʱºò£¬Ó¦¸Ã¿¼ÂÇÏÂÍøÂçÉϵÄËÑË÷ÒýÇæ¡£
5.¸Õѧ»áphp+mysqlÖ®ºó£¬²»Òª½ÐÈÂ×ÅҪдÂÛ̳£¬ÒªÐ´XXX¡£ÒªÃ÷°×£¬¸Õѧ»áдºº×Ö²¢²»±íʾÄãÓÐÄÜÁ¦Ð´Ê«¡£
6.ÔÚѧweb±à³ÌµÄʱºò£¬ÄãÓ¦¸ÃÏÈÈ¥ÈÏʶhtmlÕâ¸öÅóÓÑ¡£
7.ÓеãÄÜÁ¦ºó£¬ÊÔׯشðÐÂÊÖµÄÎÊÌ⣬²»Òª¿´µ½×Ô¼º¶®µÄ¶ø±ðÈ˲»¶®¾ÍÕ´Õ´×Ôϲ£¬ÈÓÏÂÒ»Ãû“¼òµ¥£¬ÄÇÊÇ»ù±¾µÄ¶«Î÷”¾Í×߸üÒª²»µÃ¡£
8.˼¿¼ÊÇÒ»¸öºÃϰ¹ß£¬²»¶¯ÊÖȥд¾ÍµÈÓÚ¿ÕÏ룬ʲôҲûÓС£
9.дºÃÒ»¶Î³ÌÐò£¬Èç¹û¾õµÃºÜÂúÒ⣬һÖܺóÔÙ¿´Ò»±é£¬Ò²ÐíÄã»áÈÏΪËüÓ¦¸ÃÓÐËù¸Ä±ä
10.Óпն࿴¿´±ðÈ˵ijÌÐò£¬ÕÒ³öËûÈ˵IJ»×ã»òÓŵ㣬×Ô¼ºµàÁ¿¡£
¶þ. ¸÷È¡ËùÐè
1.ÉÆÓÚʹÓÓÒýÓÔ,ËüÄÜÖ±½ÓÓ°Ïìµ½³ÌÐòµÄЧÂÊ¡£
2.ÉÆÓÚÓÃÈýÔªÔËËã×Ó,¿ÉÒÔÈóÌʽ½Ï¾«¼òÓÐЧÂÊ¡£
±ÈÈç:
PHP´úÂë:
if ($data[$i]['nickname'])
{
$nickname = $data[$i]['nickname'];
}
else
{
$nickname = $data[$i]['ip'];
}
¿ÉÒÔд³É:
PHP´úÂë:
$nickname = $data[$i]['nickname'] ? $data[$i]['nickname'] : $data[$i]['ip'];
3.ÉÆÓÚ×éÖ¯if...else...»ØÈ¦
±ÈÈç:
PHP´úÂë:
$ext_name = strtolower(str_replace(".", "", strrchr($upfilename, ".")));
if (!empty($type))
{
if (!strpos($type, $ext_name))
{
echo "Please upload the file of $type form.";
exit();
}
}
ÉÏÃæµÄ´úÂëÄãÓ¦¸Ãд³ÉÕâÑù:
PHP´úÂë:$ext_name = strtolower(str_replace(".", "", strrchr($upfilename, ".")));
if (!($type==='') && strpos($type, $ext_name)===false)
{
echo "Please upload the file of $type form.";
exit();
}
4.¾¡Á¿ÈÃÄãµÄ´úÂëÇåäÀЩ
Èç¹ûд³ÉÕâÑù£¬ÊDZȽÏÈÃÈËÍ·Í´µÄ:
PHP´úÂë:
$foo=$_post["foo"];
$username=$_post["user"];
$group=$_POST["group"];
Ïà¹ØÎĵµ£º
ÁíÍâMySql¹Ù·½³öÁËÒ»¸öÔÚcsharpÀïÃæÁ¬½ÓMySqlµÄConnector£¬¿ÉÒÔÊÔÊÔ
http://dev.mysql.com/downloads/#connector-net
<add name="mysql" connectionString="server=125.46.37.170;uid=root;pwd=;"/>
±¨´í£ºUnable to connect to any of the specified MySQL hosts.
½ñÌì×öÏîĿʱºò¾ÍÓöµ½ÕâÎÊ ......
http://hi.baidu.com/fish124423/blog/item/c6f9f310190dd779ca80c456.html½â¾öerror trying access httpd. conf file.you will need to manually configure theµÄÅäÖÃÎÊÌâ
Apache+mysql+phpÔÚwindowsϵÄÅäÖÃ(³É¹¦)
2008-12-16 14:49
ApcheÏÂÔØµØµã£ºhttp://www.apache/org
Or http://www.51cto.com/html/ ......
PHPµÄÒ»¸öÊý¾Ý¿â²Ù×÷Àà,ÒÔUTF8¸ñʽдÈë,Êý¾Ý¿âÄÚÖ±½ÓÏÔʾÕý³£ÖÐÎÄ,·ÀÖ¹²éѯ³ö´í
/**
* @author xggxnn
* ±¾ÀàÓÃÓÚʵÏÖÓйØÊý¾Ý¿âµÄ·ÃÎÊ
*
*/
class DBConnection {
private $host = "";
private $user = "";
private $pass = "";
private $DBname = "";
public $isConnected = false;
/**
* ¹¹Ôìº ......
Ò»°ãÔÚMYSQLʹÓÃÖÐÎIJéѯ
¶¼ÊÇÓà set NAMES character
character_set_client £¬ÕâÊÇÓû§¸æËßMySQL²éѯÊÇÓõÄʲô×Ö·û¼¯¡£
character_set_connection £¬MySQL½ÓÊܵ½Óû§²éѯºó£¬°´ÕÕcharacter_set_client½«Æäת»¯Îªcharacter_set_connectionÉ趨µÄ×Ö·û¼¯¡£
character_set_results £¬ MySQL½«´æ´¢µÄÊý¾Ýת»»³Écharact ......
ÕâÀïÊÇʹÓÃODBCÀ´×ª»»Êý¾Ý¿âµÄ¡£
1.°²×°mysqlÊý¾Ý¿âµÄODBCÇý¶¯£¬mysql¹ÙÍøÓÐÏÂÔØhttp://dev.mysql.com/downloads/connector/odbc/
2.´ò¿ª¿ØÖÆÃæ°å\¹ÜÀí¹¤¾ß\Êý¾ÝÔ´ODBC£¬ÔÚÓû§DSNÖÐÌí¼ÓÒ»¸öMySQL ODBC Êý¾ÝÔ´¡£
3.½Ó×ÅÔÚÏÂÃæµÄ´°ÌåÖÐÊäÈëÊý¾ÝÔ´Ãû³Æ£¬Èçmysqlodbc£»È»ºóÊäÈë·þÎñÆ÷ServerµØÖ·£¨localhost»òÆäËû£©£¬Óû§Us ......