phpÁ¬½ÓmysqlµÄÎÊÌâ - PHP / »ù´¡±à³Ì
[s:2]ÊäÈëÕâ¶Î´úÂë³öÏÖÒÔϵĴíÎóÌáʾ£º
<?php
$host="localhost";
$username="root";
$password="root";
if($connid=mysql_connect($host,$username,$password)){
echo"<script language='javascript'>alert('Êý¾Ý¿âÁ¬½Ó³É¹¦');</script>";
}else{
echo"<script language='javascript'>alert('Êý¾Ý¿âÁ¬½Óʧ°Ü'>;</script>";
}
?>
ÌáʾµÄ´íÎó
Warning: mysql_connect() [function.mysql-connect]: OK packet 6 bytes shorter than expected. PID=288 in D:\AppServ\www\asd\Untitled-1.php on line 13
Warning: mysql_connect() [function.mysql-connect]: mysqlnd cannot connect to MySQL 4.1+ using old authentication in D:\AppServ\www\asd\Untitled-1.php on line 13
Warning: mysql_connect() [function.mysql-connect]: in D:\AppServ\www\asd\Untitled-1.php on line 13
Çó½â°¡
¿´ÄãµÄ·þÎñ¶¼ÆôÁËô
¿ªÆôÁË£¡£¡£¡½ø³ÌÀïÃæÓÐmysql.exeÕâÏî°¡
»¹ÊÇÄãµÄÊý¾Ý¿âÓÐÎÊÌ⣬ÄãÓõÄmysql°É£¬²»ÐоÍÖØ×°Ò»ÏÂÊý¾Ý¿â
ÎÒ×°µÄÊÇappserv×éºÏ°ü£¡£¡
³ýÁË
PHP code:
echo"<script language='javascript'>alert('Êý¾Ý¿âÁ¬½Óʧ°Ü'>;</script>";
ÕâÐÐµÄ alert('Êý¾Ý¿âÁ¬½Óʧ°Ü'>; > Ó¦¸Ã¸Ä³É ) ÒÔÍ⣬ûÓÐÆäËûÎÊÌ⣬ÄÜÖ´ÐС£
ÊDz»ÊÇǰºó»¹ÓдúÂ룿
ûÓÐÆäËû´úÂëÁË
ÊÇ¿ÉÒÔÖ´ÐÐÁ
Ïà¹ØÎÊ´ð£º
ĿǰÔÚÎ人ÕÒ¹¤×÷
·¢Ïִ󲿷ֹ«Ë¾ÎÞÍâºõÁ½ÖÖ
Ò»ÖÖÊǸãÍâ°üµÄ ÒªÓÃzend,cakephpµÈÍâ¹ú¿ò¼Ü
»¹ÒªÊìϤÍâ¹ú¿ªÔ´ÏµÍ³
Ò»ÖÖ¹úÄÚµÄ ÎÞÍâºõ dedecms ecshop shopexÕ⼸ÖÖ¸ÄÕ¾µã ÓеĹ«Ë¾ÉõÖÁÄÃһЩ¸üСµÄϵͳ¸ ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
1¡¢ÊDz»ÊÇPHPÖÐÖ»ÄÜʹÓÃmysql_query("update user_aa set money=money2-".$bpanmm." where uid=".$userppp);¸üÐÂÊý¾Ý£¿£¿£¿
2¡¢PHP¸üÐÂmysql_fetch_row($res)Óëmysql_fetch_array($res)ÖеÄÊý¾ ......