PHP數據填報代碼 php表格代碼

我看不懂：PHP代碼根據數據表結構自動生成數據錄入頁面

數組{name=張三，age=10歲}

我們提供的服務有：網站設計、成都做網站、微信公眾號開發、網站優化、網站認證、麻陽ssl等。為近千家企事業單位解決了網站和推廣的問題。提供周到的售前咨詢和貼心的售后服務，是有科學管理、有技術的麻陽網站制作公司

array1={0=name,1=age}

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

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

結果str=name,age; str1=張三，10歲

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

幾種常用PHP連接數據庫的代碼示例

PHP連接數據庫之PHP連接MYSQL數據庫代碼

?php???

$mysql_server_name='localhost';?

//改成自己的mysql數據庫服務器??

$mysql_username='root';?

//改成自己的mysql數據庫用戶名??

$mysql_password='12345678';?

//改成自己的mysql數據庫密碼??

$mysql_database='mycounter';

//改成自己的mysql數據庫名??

$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!數據庫mycounter已經成功建立！";???

PHP連接數據庫之PHP連接ACCESS數據庫代碼方法

???

$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代碼數據

public?function?rules(){

return?array(

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

)

}

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

我推測你的意圖是，當required為何值是，不檢測message的值。

那么你的數組可以這樣修改：

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

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

$a?=?rules();

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

if($rule['required']){

//這里是觸發message效果的代碼

}else{

//這里是不觸發

}

PHP數據庫查詢代碼問題

首先你的sql語句寫的有問題： $catsql="SELECT * FROM categories;";中的語句不用加“；”；

這里是出現了warning：當你的搜索結果是空集的時候，就會出現類似的情況

用if語句結合echo進行判斷你的結果集是不是空的；

php表單寫入mysql數據庫的代碼

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

!DOCTYPE?html

html

head

style

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

/style

titleAdd?students/title

/head

body

!--?數據庫用mysqli?面向過程調用方法--

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

!--數據庫用mysqli?面向過程調用方法

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

!--數據庫用PDO調用方法

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,數據庫用mysqli?面向過程調用方法

//print_r($_POST);

//?create?a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'];

$email=$_POST['email'];

//調試用

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,數據庫用mysqli?面向對象調用方法

//print_r($_POST);

//?create?a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'];

$email=$_POST['email'];

//調試用

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,數據庫用PDO調用方法

//print_r($_POST);

a?variable

$first_name=$_POST['first_name'];

$last_name=$_POST['last_name'];

$department=$_POST['department'];

$email=$_POST['email'];

//調試用

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;

--創建數據庫test,?將此文件存為test.sql?導入數據庫，或者手動創建表結構

--?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數據填報代碼 php表格代碼
分享URL：http://m.kartarina.com/article16/hgcjgg.html

成都網站建設公司_創新互聯，為您提供靜態網站、營銷型網站建設、微信公眾號、面包屑導航、手機網站建設、品牌網站設計

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

猜你還喜歡下面的內容