php表單寫入mysql數(shù)據(jù)庫的代碼

!--表單文件，拷入index.php--

創(chuàng)新互聯(lián)建站是一家專業(yè)提供博羅企業(yè)網(wǎng)站建設(shè),專注與做網(wǎng)站、成都網(wǎng)站設(shè)計(jì)、H5場(chǎng)景定制、小程序制作等業(yè)務(wù)。10年已為博羅眾多企業(yè)、政府機(jī)構(gòu)等服務(wù)。創(chuàng)新互聯(lián)專業(yè)網(wǎng)絡(luò)公司優(yōu)惠進(jìn)行中。

!DOCTYPE?html

html

head

style

label{display:inline-block;width:100px;margin-bottom:10px;}

/style

titleAdd?students/title

/head

body

!--?數(shù)據(jù)庫用mysqli?面向過程調(diào)用方法--

form?method="post"?action="write2db.php"

!--數(shù)據(jù)庫用mysqli?面向過程調(diào)用方法

form?method="post"?action="write2db_sqlio.php"

--

!--數(shù)據(jù)庫用PDO調(diào)用方法

form?method="post"?action="write2db_pdo.php"

--

labelFirst?Name/label

input?type="text"?name="first_name"?/

br?/

labelLast?Name/label

input?type="text"?name="last_name"?/

br?/

labeldepartment/label

input?type="text"?name="department"?/

br?/

labelEmail/label

input?type="text"?name="email"?/

br?/

input?type="submit"?value="Add?students"

/form

/body

/html

------------------------------

?php

//拷貝命名為write2db.php,數(shù)據(jù)庫用mysqli?面向過程調(diào)用方法

//print_r($_POST);

//?create?a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'];

$email=$_POST['email'];

//調(diào)試用

echo?"Your?input:?";

echo?$first_name;

echo?'br?/';

echo?$last_name;

echo?'br?/';

echo?$department;

echo?'br?/';

echo?$email;

echo?'br?/';

$servername?=?"localhost";

//Your?database?username?and?password

//$username?=?"username";

//$password?=?"password";

$username?=?"tester";

$password?=?"testerPassword";

//your?database?name

$dbname?=?"test";

$tablename?="student";

//?Create?陸侍connection

$connect?=?mysqli_connect($servername,?$username,?$password,?$dbname);

if?(!$connect)?{

die("Connection?failed:?"?.?mysqli_connect_error());

}

//Execute?the?query

$sql="INSERT?INTO?$tablename?(first_name,last_name,department,email)

VALUES('$first_name'閉悉并,'$last_name','$department','$email')";

if?(mysqli_query($connect,?$sql))?{

echo?"Hooray!?New?record?is?inserted?to?database?successfully.?Please?check?database.";

}?else?{

echo?"Error:?"?.?$sql?.?"br?/"?.?mysqli_error($connect);

}

mysqli_close($connect);

?

?php

//拷貝命名為write2db_sqlio.php,數(shù)據(jù)庫用mysqli?面向?qū)ο笳{(diào)用方法

//print_r($_POST);

//?create?a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'轎跡];

$email=$_POST['email'];

//調(diào)試用

echo?"Your?input:?";

echo?$first_name;

echo?'br?/';

echo?$last_name;

echo?'br?/';

echo?$department;

echo?'br?/';

echo?$email;

echo?'br?/';

$servername?=?"localhost";

//Your?database?username?and?password

//$username?=?"username";

//$password?=?"password";

$username?=?"tester";

$password?=?"testerPassword";

//database?name

$dbname?=?"test";

$tablename?="student";

//?Create?connection

$conn?=?new?mysqli($servername,?$username,?$password,?$dbname);

//?Check?connection

if?($conn-connect_error)?{

die("Connection?failed:?"?.?$conn-connect_error);

}?

$sql="INSERT?INTO?$tablename?(first_name,last_name,department,email)

VALUES('$first_name','$last_name','$department','$email')";

if?($conn-query($sql)?===?TRUE)?{

echo?"New?record?created?successfully";

}?else?{

echo?"Error:?"?.?$sql?.?"br"?.?$conn-error;

}

$conn-close();

?

?php

//拷貝為文件write2db_pdo.php,數(shù)據(jù)庫用PDO調(diào)用方法

//print_r($_POST);

a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'];

$email=$_POST['email'];

//調(diào)試用

echo?"Your?input:?";

echo?$first_name;

echo?'br?/';

echo?$last_name;

echo?'br?/';

echo?$department;

echo?'br?/';

echo?$email;

echo?'br?/';

$servername?=?"localhost";

//Your?database?username?and?password

//$username?=?"username";

//$password?=?"password";

$username?=?"tester";

$password?=?"testerPassword";

//your?database?name

$dbname?=?"test";

$tablename?="student";

//?Create?connection

try?{

$conn?=?new?PDO("mysql:host=$servername;dbname=$dbname",?$username,?$password);

//?set?the?PDO?error?mode?to?exception

$conn-setAttribute(PDO::ATTR_ERRMODE,?PDO::ERRMODE_EXCEPTION);

$sql="INSERT?INTO?$tablename?(first_name,last_name,department,email)

VALUES('$first_name','$last_name','$department','$email')";

//?use?exec()?

$conn-exec($sql);

echo?"New?record?created?successfully";

}

catch(PDOException?$e)

{

echo?$sql?.?"br"?.?$e-getMessage();

}

$conn?=?null;

?

--創(chuàng)建數(shù)據(jù)庫test,?將此文件存為test.sql?導(dǎo)入數(shù)據(jù)庫，或者手動(dòng)創(chuàng)建表結(jié)構(gòu)

--?phpMyAdmin?SQL?Dump

--?version?4.7.4

--?

--

--?Host:?127.0.0.1:3306

--?Generation?Time:?Mar?12,?2018?at?04:04?AM

--?Server?version:?5.7.19

--?PHP?Version:?7.1.9

SET?SQL_MODE?=?"NO_AUTO_VALUE_ON_ZERO";

SET?AUTOCOMMIT?=?0;

START?TRANSACTION;

SET?time_zone?=?"+00:00";

/*!40101?SET?@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT?*/;

/*!40101?SET?@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS?*/;

/*!40101?SET?@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION?*/;

/*!40101?SET?NAMES?utf8mb4?*/;

--

--?Database:?`test`

--

--?--------------------------------------------------------

--

--?Table?structure?for?table?`student`

--

DROP?TABLE?IF?EXISTS?`student`;

CREATE?TABLE?IF?NOT?EXISTS?`student`?(

`id`?tinyint(3)?UNSIGNED?NOT?NULL?AUTO_INCREMENT,

`first_name`?varchar(20)?NOT?NULL,

`last_name`?varchar(20)?NOT?NULL,

`department`?varchar(50)?NOT?NULL,

`email`?varchar(50)?NOT?NULL,

PRIMARY?KEY?(`id`)

)?ENGINE=MyISAM?AUTO_INCREMENT=2?DEFAULT?CHARSET=utf8;

--

--?Dumping?data?for?table?`student`

--

INSERT?INTO?`student`?(`id`,?`first_name`,?`last_name`,?`department`,?`email`)?VALUES

(1,?'first1',?'last1',?'cs',?'1985@qq點(diǎn)抗 ');

COMMIT;

/*!40101?SET?CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT?*/;

/*!40101?SET?CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS?*/;

/*!40101?SET?COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION?*/;

PHP中怎樣把表單單選按鈕的值寫入數(shù)據(jù)庫中

p代碼中獲取表單中單選按鈕的值：（單選按鈕只能讓我們選擇一個(gè)，這里有一個(gè)“checked”屬性，這是用來默認(rèn)選取的，我們每次刷新我們的頁面時(shí)就默認(rèn)為這個(gè)值。）

例：form name="myform" action="" method="post"

性別:

input type="radio" name="sex" value="男" checked /鋒讓男input name="sex" type="radio" value="女" /女

input type="submit" name="submit" value="提交" /

/銀雹局form

?php

echo "您的選擇是：";

echo $_POST["sex"];

?

如果你選擇的是男，則出來的值就是“男”，要是你選擇的是女肆旁，則出來的值就是“女”。

如何通過PHP把html的表單提交到mysql數(shù)據(jù)庫？

首先，你得在diaocha.php這個(gè)文件，接收表單傳的值州橡

$radiogroup = isset($_POST['radiogroup'])?$radiogroup:'';

isset用來掘或檢測(cè)是否有選中提交，然后就是數(shù)據(jù)庫的鏈接

$con = mysql_connect('localhost','root',''); //三個(gè)參數(shù)，分別是，連接的主機(jī)名，mysql的賬號(hào)，mysql密碼

mysql_query('set names utf8'); //設(shè)置連接的字符集，如果頁面是utf8的編碼，就是utf8，如果是gbk的話，那就寫 set names gbk

mysql_select_db('xxx',$con);nbsp; //xxx就是你要選擇的數(shù)據(jù)庫名稱

插入數(shù)據(jù)

$sql = "insert into xxxx set xxx = $radiogroup" //xxxx 是你要插入的表名，xxx就判跡伍是字段名

mysql_query($sql);

文章題目：php網(wǎng)頁表單存入數(shù)據(jù)庫 php網(wǎng)頁表單存入數(shù)據(jù)庫怎么操作
分享地址：http://chinadenli.net/article18/dshocdp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)站營銷、自適應(yīng)網(wǎng)站、虛擬主機(jī)、用戶體驗(yàn)、動(dòng)態(tài)網(wǎng)站、App設(shè)計(jì)

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)