我看不懂：PHP代碼根據(jù)數(shù)據(jù)表結(jié)構(gòu)自動(dòng)生成數(shù)據(jù)錄入頁(yè)面

數(shù)組{name=張三，age=10歲}

我們提供的服務(wù)有：網(wǎng)站設(shè)計(jì)、成都做網(wǎng)站、微信公眾號(hào)開(kāi)發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、麻陽(yáng)ssl等。為近千家企事業(yè)單位解決了網(wǎng)站和推廣的問(wèn)題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的麻陽(yáng)網(wǎng)站制作公司

array1={0=name,1=age}

array2={0=張三,1=10歲}

implode(",",$array)就是用逗號(hào)連接字符串

結(jié)果str=name,age; str1=張三，10歲

insert into tb_form (name,age) values('張三，10歲')能看懂的吧？

幾種常用PHP連接數(shù)據(jù)庫(kù)的代碼示例

PHP連接數(shù)據(jù)庫(kù)之PHP連接MYSQL數(shù)據(jù)庫(kù)代碼

?php???

$mysql_server_name='localhost';?

//改成自己的mysql數(shù)據(jù)庫(kù)服務(wù)器??

$mysql_username='root';?

//改成自己的mysql數(shù)據(jù)庫(kù)用戶名??

$mysql_password='12345678';?

//改成自己的mysql數(shù)據(jù)庫(kù)密碼??

$mysql_database='mycounter';

//改成自己的mysql數(shù)據(jù)庫(kù)名??

$conn=mysql_connect($mysql_server_name,

$mysql_username,$mysql_password,

$mysql_database);???

$sql='CREATE?DATABASE?mycounter?

DEFAULT?CHARACTER?SET?gbk?COLLATE?gbk_chinese_ci;???

';???

mysql_query($sql);???

$sql='CREATE?TABLE?`counter`?

(`id`?INT(255)?UNSIGNED?NOT?NULL?

AUTO_INCREMENT?,`count`?INT(255)?

UNSIGNED?NOT?NULL?DEFAULT?0,PRIMARY?KEY?

(?`id`?)?)?TYPE?=?innodb;';???

mysql_select_db($mysql_database,$conn);???

$result=mysql_query($sql);???

//echo?$sql;???

mysql_close($conn);???

echo?"Hello!數(shù)據(jù)庫(kù)mycounter已經(jīng)成功建立！";???

??

PHP連接數(shù)據(jù)庫(kù)之PHP連接ACCESS數(shù)據(jù)庫(kù)代碼方法

???

$conn?=?new?com("ADODB.Connection");???

$connstr?=?"DRIVER={Microsoft

Access?Driver?(*.mdb)};?

DBQ=".?realpath("data/db.mdb");???

$conn-Open($connstr);???

$rs?=?new?com("ADODB.RecordSet");???

$rs-Open("select?*

from?szd_t",$conn,1,1);???

while(!?$rs-eof)?{???

$f?=?$rs-Fields(1);???

echo?$f-value;???

$rs-MoveNext();???

}???

?

PHP代碼數(shù)據(jù)

public?function?rules(){

return?array(

array('Sex','required','message'=''),

)

}

你這段代碼返回的是一個(gè)數(shù)組，假設(shè)為數(shù)組A。這個(gè)數(shù)組A只有一個(gè)元素，這個(gè)元素也是一個(gè)數(shù)組，假設(shè)為數(shù)組B。數(shù)組B有三個(gè)字符串元素，兩個(gè)為值，一個(gè)未名/值對(duì)。

我推測(cè)你的意圖是，當(dāng)required為何值是，不檢測(cè)message的值。

那么你的數(shù)組可以這樣修改：

array('Sex','required'='','message'='')

這樣，你只要在稍后判斷required的值就可以了。

$a?=?rules();

$rule?=?$a[0]//返回的是多維數(shù)組，所以你要取第一個(gè)

if($rule['required']){

//這里是觸發(fā)message效果的代碼

}else{

//這里是不觸發(fā)

}

PHP數(shù)據(jù)庫(kù)查詢代碼問(wèn)題

首先你的sql語(yǔ)句寫(xiě)的有問(wèn)題： $catsql="SELECT * FROM categories;";中的語(yǔ)句不用加“；”；

這里是出現(xiàn)了warning：當(dāng)你的搜索結(jié)果是空集的時(shí)候，就會(huì)出現(xiàn)類似的情況

用if語(yǔ)句結(jié)合echo進(jìn)行判斷你的結(jié)果集是不是空的；

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

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

!DOCTYPE?html

html

head

style

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

/style

titleAdd?students/title

/head

body

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

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

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

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

--

!--數(shù)據(jù)庫(kù)用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ù)庫(kù)用mysqli?面向過(guò)程調(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ù)庫(kù)用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ù)庫(kù)用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ù)庫(kù)test,?將此文件存為test.sql?導(dǎo)入數(shù)據(jù)庫(kù)，或者手動(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.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數(shù)據(jù)填報(bào)代碼 php表格代碼
分享URL：http://chinadenli.net/article16/hgcjgg.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供靜態(tài)網(wǎng)站、營(yíng)銷型網(wǎng)站建設(shè)、微信公眾號(hào)、面包屑導(dǎo)航、手機(jī)網(wǎng)站建設(shè)、品牌網(wǎng)站設(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í)需注明來(lái)源： 創(chuàng)新互聯(lián)