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»ÊÇǰºó»¹ÓдúÂ룿
ûÓÐÆäËû´úÂëÁË
ÊÇ¿ÉÒÔÖ´ÐÐÁ
Ïà¹ØÎÊ´ð£º
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......
ÇëÎÊ
Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó
Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£»
·þÎñÆ÷Ãû£º
Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿
ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡
Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿
ÒýÓÃ
ÇëÎÊ
......
String sqlCount="select count(*) from usertable where username='"+
userName+"'";Õâ¾ä»° ʲôÒâ˼°¡£¡
Õâ¾ä»°Êä³ö³öÀ´¾ÍÊÇ
select count(*) from usertable where username='ÄãµÄ±äÁ¿ ......
ÈçÉÏËùʾ£¬Èç¹ûÎÒ¶¨ÒåÁËÒ»¸ölayout()º¯Êý£¬ÎÒµ÷ÓÃʱÓвÎÊýÔÙcontent£¬ÎÒÏëÔÚlayoutº¯ÊýÀïÃæ²¶×½contentÕâ¸ö²ÎÊý£¬ÄÜ·ñ×öµ½£¿¼´ÎÒÔÚlayoutº¯ÊýÄÜÊä³öcontentÕ⼸¸ö×Öĸ£¬±ÈÈçphpµÄ__get($name)º¯Êý£¬µ±ÎÒÔÚÀàÖв¢Î´¶¨ ......