學(xué)了這篇,用以下代碼不能再我的MYSQL寫入數(shù)據(jù)?請(qǐng)問(wèn)大家
<?php
$host = '127.0.0.1';
$user = 'root';
$pass = '';
//在這里編寫數(shù)據(jù)庫(kù)連接代碼
$link = mysql_connect($host, $user, $pass);
mysql_select_db('t1');
mysql_query("set names 'utf8'");
//在這里進(jìn)行數(shù)據(jù)查詢
//$res = mysql_query('select * from t1.1');
//$row = mysql_fetch_array($res);
//var_dump($row);
//已知的數(shù)據(jù)變量有
$username = '君子固本';
$age = 35;
$salary = '100000';
//在這里進(jìn)行數(shù)據(jù)查詢
$sql = "insert into user(username, age, salary) values('$username', '$age', '$salary')";
mysql_query($sql); //執(zhí)行插入語(yǔ)句
?>
2016-12-14
說(shuō)明你的PHP版本高了?,F(xiàn)在PHP不建議用my_connection來(lái)連接數(shù)據(jù)庫(kù),而建議用PDO或者mysqli來(lái)連接數(shù)據(jù)庫(kù)。我個(gè)人建議你使用PDO吧。畢竟現(xiàn)在PHP引入了對(duì)象編程。
2016-12-14
這是我mysql的表結(jié)構(gòu)
+----------+---------------------+------+-----+---------+-------+
| Field ? ?| Type ? ? ? ? ? ? ? ?| Null | Key | Default | Extra |
+----------+---------------------+------+-----+---------+-------+
| username | varchar(20) ? ? ? ? | YES ?| ? ? | NULL ? ?| ? ? ? |
| age ? ? ?| tinyint(3) unsigned | YES ?| ? ? | NULL ? ?| ? ? ? |
| salary ? | float(8,2) unsigned | YES ?| ? ? | NULL ? ?| ? ? ? |
+----------+---------------------+------+-----+---------+-------+
2016-12-14
2016-12-14
貼一下報(bào)錯(cuò)信息