mysql type字段写不进去_为什么加不进去mysql

"method="post">姓名学号专业手机出生日期" method="post">

姓名	学号	专业	手机	出生日期

if(isset($_POST['submit']))

{

$hostname='127.0.0.1';

$user='root';

$password='123456';

mysql_connect($hostname, $user, $password) or die ('连接数据库失败!');

mysql_select_db('school') or die ('选择数据失败!');

mysql_query('set names utf8');

$name = $_POST['name'];

$sid = $_POST['sid'];

$major = $_POST['major'];

$tel = $_POST['mark'];

$birthday= $_POST['birthday'];

$sql=<<

INSERT INTO student (name,sid,major,tel,birthday) VALUES("{$name}", {$sid}, "{$major}", {tel},{birthday});

sql;

$result=mysql_query($sql) or die('SQL执行错误!');

if($result)

{

echo'';

}

mysql_close();

}

?>

展开