一.--

-- 表的結構 `userinfo`

--

CREATE TABLE `userinfo` (

`groudid` varchar(12) NOT NULL default '1',

`user` varchar(12) NOT NULL default 'heige',

`pass` varchar(122) NOT NULL default '123456'

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--

-- 導出表中的數據 `userinfo`

--

INSERT INTO `userinfo` VALUES ('2', 'heige', '123456');

------end-------

三.測試模式：

1,變量沒有帶''或""[MOD1]

lt;?php

//test1.php Mod1

$servername = "localhost";

$dbusername = "root";

$dbpassword = "";

$dbname = "test";

mysql_connect($servername,$dbusername,$dbpassword) or die ("數據庫連接失敗");

$sql = "update userinfo set pass=$p where user='heige'";//

$result = mysql_db_query($dbname, $sql);

$userinfo = mysql_fetch_array($result);

echo "