                        課程
                    
                        /前端開(kāi)發(fā)
                        
                            /JavaScript
                        
                        /Ajax全接觸

//TODO: 獲取POST表單數(shù)據(jù)并保存到數(shù)據(jù)庫(kù)

誰(shuí)會(huì)寫(xiě)啊加我q 260348993 給錢(qián)

doupeng

2016-05-12

源自：Ajax全接觸 3-2

關(guān)注問(wèn)題我要回答

522

操作

收起

2 回答

Elly
2016-05-12

給你一個(gè)例子：數(shù)據(jù)庫(kù)采用的是mysql

<?php
?$con=mysql_connect("localhost","root","gl");
?mysql_select_db("happysea");

?$name=$_POST['name'];
?$password=$_POST['password'];
?$sex=$_POST['sex'];
?$e_mail=$_POST['e_mail'];
?$question=$_POST['question'];
?$answer=$_POST['answer'];

?$sql="insert into userinfo(name,password,sex,e_mail,question,answer)
? values('$name','$password','$sex','$e_mail','$question','$answer')";
?
?if(!$sql)
?{
? echo('注冊(cè)失敗!');
?}
?else
?{
? echo('注冊(cè)成功!');
?}

?>

這是數(shù)據(jù)庫(kù)。

mysql> describe userinfo;
+----------+-------------+------+-----+---------+----------------+
| Field??? | Type??????? | Null | Key | Default | Extra????????? |
+----------+-------------+------+-----+---------+----------------+
| id???????????? | int(11)???????? | NO??? | PRI | NULL??? | auto_increment |
| name?????? | text????????????? | YES? |??????? | NULL??? |??????????????? |
| password | varchar(20) | YES? |??????? | NULL??? |??????????????? |
| sex?????????? | char(4)???????? | YES? |??????? | NULL?? |??????????????? |
| e_mail????? | varchar(30)? | YES? |??????? | NULL??? |??????????????? |
| question?? | text?????????????? | YES? |??????? | NULL??? |??????????????? |
| answer???? | text?????????????? | YES? |??????? | NULL??? |??????????????? |
+----------+-------------+------+-----+---------+----------------+