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»ÊÇǰºó»¹ÓдúÂ룿
ûÓÐÆäËû´úÂëÁË
ÊÇ¿ÉÒÔÖ´ÐÐÁ
Ïà¹ØÎÊ´ð£º
ÎÒÒѾ°´Õս̳ÌÉÏÅäÖÃtomcatµÄserver.xml
<Context path = "/POS" docBase = "POS" debug = "5" reloadable = "true" crossContext = "true" workDir = &quo ......
±±¾©2ÄêPHP¾ÑéÇó¼æÖ°
½Ó·Ö
·¹ý½Ó·Ö£¡.¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
jf~~~~~~~~~~~~~~Ö§³Ö
ßÀ¡£¡£ÎÒÃÇÐèÒª¼æÖ°£¬¿ÉÊÇÔõôÁªÏµÄãѽ£¿
¶¥¡£¡£¡£ »Ø¸´ÄÚÈÝ »Ø¸´ÄÚÈÝÌ«¶ÌÁË£¡
º¼ÖÝÄãÈ¥²»È¥°¡ ¡£¡£¡£¡£¡ ......
×î½üÒ»¸öÏîÄ¿ÖÐÓöµ½Ò»¸öÎÊÌ⣺ÔÚÔÓеÄÒ»Ì×ϵͳÖÐ(php¿ª·¢)Ìí¼ÓһЩС¹¦ÄÜ(jsp¿ª·¢)£¬ÔÀ´Óû§ÏµÍ³¶¼ÊÇphp¿ª·¢µÄ£¬ÎÒÈçºÎÔÚjsp¿ª·¢µÄ¹¦ÄÜÖÐ×öµ½Óû§ÐÅÏ¢sessionͬ²½ÄØ£¿ ÓÐÈËÊÇ·ñÓÐ×ö¹ýÀàÒÔÏîÄ¿£¬ÏëÌýÌý´ó¼ÒµÄ¿´·¨
......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
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)ÖеÄÊý¾ ......