php把數(shù)組寫入mysql的方法

您好，您可以參考如下代碼：

創(chuàng)新互聯(lián)建站專業(yè)提供成都主機托管四川主機托管成都服務(wù)器托管四川服務(wù)器托管，支持按月付款！我們的承諾：貴族品質(zhì)、平民價格，機房位于中國電信/網(wǎng)通/移動機房，電信機房托管服務(wù)有保障！

?php

/*?獲取HTML表單提交的數(shù)據(jù)?*/

$id?=?_POST["id"];

$catid?=?_POST["catid"];

$ly?=?array("data***");

/*?連接數(shù)據(jù)庫，如果出錯顯示消息結(jié)束程序，否則繼續(xù)執(zhí)行數(shù)據(jù)庫命令?*/

$con?=?mysql_connect("127.0.0.1","user","password");

if($con?==?false)

{

echo?"錯誤：系統(tǒng)數(shù)據(jù)庫連接失敗！錯誤信息：".mysql_error($con);

exit();

}else{

/*?選擇需要操作數(shù)據(jù)庫?*/

mysql_select_db("mydb",$con);

/*?根據(jù)ly數(shù)組的長度決定執(zhí)行多少次SQL語句?*/

for($i=0;$icount($ly);$i++)

{

/*?設(shè)置SQL查詢語句?*/

$sql?=?"INSERT?INTO?`biaoge`?VALUES('{$id}','{$catid}',".$ly[$i].")";

/*?如果SQL語句執(zhí)行失敗，返回錯誤代碼；?*/

if(mysql_query($sql,$con)?==?false)

{

echo?"數(shù)據(jù)庫查詢出錯！錯誤代碼：".mysql_errno($con);

mysql_close($con);

exit();

}

}

mysql_close($con);

echo?"記錄添加成功！";

}

?

至于遍歷數(shù)組，有很多種方式，如樓上用的foreach語句也是可以的。這里用for的原因是為了方便提問者理解。如果代碼仍有不足或不明白的地方，請您繼續(xù)追問，直到給您一個滿意的答復(fù)為止~

PHP操作mysql數(shù)據(jù)庫的步驟

PHP訪問MySQL數(shù)據(jù)庫：

因為連接數(shù)據(jù)庫需要較長的時間和較大的資源開銷，所以如果在多個網(wǎng)頁中都要頻繁地訪問數(shù)據(jù)庫，則可以建立與數(shù)據(jù)庫的持續(xù)連接。即調(diào)用mysql_pconnect()代替mysql_connect()。

基本步驟：

1.連接服務(wù)器：mysql_connect();

2.選擇數(shù)據(jù)庫：mysql_select_db();

3.執(zhí)行SQL語句：mysql_query();

查詢：select

顯示：show

插入：insert

into

更新：update

刪除：delete

4.關(guān)閉結(jié)果集：mysql_free_result($result);

5.關(guān)閉數(shù)據(jù)庫：mysql_close($link);

php寫mysql數(shù)據(jù)庫

$sql="insert into userinfo(name,password,sex,e_mail,question,answer) values('$name','$password','$sex','$e_mail','$question','$answer')"; if(!mysql_query($sql,$con)) { echo('注冊失敗!'); } else { echo('注冊成功!'); } 增加 SQL ...

如何用php創(chuàng)建mysql數(shù)據(jù)庫

使用EclipsePHP Studio 3 創(chuàng)建一個PHP工程名稱為test1,在工程名下面userinfo的文件夾，然后在文件夾創(chuàng)建一個PHP文件（userinfo_create.php）：

2

打開我們創(chuàng)建PHP文件：

先設(shè)置 地址，賬號，密碼：

$url = "127.0.0.1";//連接數(shù)據(jù)庫的地址

$user = "root"; //賬號

$password = "root";//密碼

//獲取連接$con = mysql_connect($url,$user,$password);

if(!$con){

die("連接失敗".mysql_error());

}

3

設(shè)置具體連接的數(shù)據(jù)，那我們這兒連接test數(shù)據(jù)庫，我們通過Navicat 打開mysql 數(shù)據(jù)庫

mysql_select_db("test");

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

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

!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ù)庫，或者手動創(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.com');

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怎么寫mysql PHP怎么寫fanclab
網(wǎng)站網(wǎng)址：http://chinadenli.net/article28/hghocp.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、、搜索引擎優(yōu)化、網(wǎng)站設(shè)計公司、網(wǎng)站策劃、網(wǎng)站設(shè)計

廣告

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