Yuav ua li cas ntxig cov ntaub ntawv rau hauv MySQL database table? php ntxig cov ntaub ntawv nqe lus piv txwv rau MySQL

MySQL databaseYuav ua li cas ntxig cov ntaub ntawv rau hauv lub rooj? php rauMySQLInsert data statement piv txwv

MySQL ntxig cov ntaub ntawv

MySQL cov lus siv QHIA RAU INTO SQL nqe lus los ntxig cov ntaub ntawv.

Koj tuaj yeem ntxig cov ntaub ntawv rau hauv cov ntaub ntawv cov lus los ntawm mysql> hais kom ua lub qhov rais, lossis los ntawm PHP tsab ntawv los ntxig cov ntaub ntawv.

qauv sau ntawv

Cov hauv qab no yog ib qho rau kev ntxig cov ntaub ntawv rau hauv MySQL cov ntaub ntawv cov lus QHIA RAU INTO SQL syntax:

INSERT INTO table_name ( field1, field2,...fieldN )
                       VALUES
                       ( value1, value2,...valueN );

Yog tias cov ntaub ntawv yog tus cwj pwm, koj yuav tsum siv ib qho lus lossis ob nqe lus, xws li: "tus nqi".

Ntxig cov ntaub ntawv ntawm lub qhov rais hais kom ua

Hauv qab no peb yuav siv SQL QHIA RAU INTO Cov nqe lus ntxig cov ntaub ntawv rau hauv MySQL cov ntaub ntawv rooj chenweiliang_tbl

piv txwv

Hauv qhov piv txwv hauv qab no peb yuav ntxig peb daim ntaub ntawv rau hauv lub rooj chenweiliang_tbl:

root@host# mysql -u root -p password;
Enter password:*******
mysql> use chenweiliang;
Database changed
mysql> INSERT INTO chenweiliang_tbl 
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("学习 PHP", "菜鸟教程", NOW());
Query OK, 1 rows affected, 1 warnings (0.01 sec)
mysql> INSERT INTO chenweiliang_tbl
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("学习 MySQL", "菜鸟教程", NOW());
Query OK, 1 rows affected, 1 warnings (0.01 sec)
mysql> INSERT INTO chenweiliang_tbl
    -> (chenweiliang_title, chenweiliang_author, submission_date)
    -> VALUES
    -> ("JAVA 教程", "chenweiliang.com", '2016-05-06');
Query OK, 1 rows affected (0.00 sec)
mysql>

Nco tseg: Kos nrog xub -> Nws tsis yog ib feem ntawm SQL nqe lus, nws tsuas yog sawv cev rau kab tshiab, yog tias SQL nqe lus ntev dhau lawm, peb tuaj yeem tsim kab tshiab los sau SQL nqe lus los ntawm kev siv tus yuam sij Enter. semicolon ;.

Hauv qhov piv txwv saum toj no, peb tsis tau muab cov ntaub ntawv ntawm chenweiliang_id, vim tias daim teb no tau raug teeb tsa ua AUTO_INCREMENT tus cwj pwm thaum peb tsim lub rooj.Yog li ntawd, daim teb yuav cia li incremented yam tsis muaj peb yuav tsum tau teem nws.Hauv qhov piv txwv NOW() yog MySQL muaj nuj nqi uas rov qab hnub thiab sijhawm.

Tom ntej no, peb tuaj yeem saib cov ntaub ntawv cov ntaub ntawv nrog cov lus hauv qab no:

Ntxig cov ntaub ntawv siv PHP tsab ntawv

Koj tuaj yeem siv PHP's mysqli_query() ua haujlwm SQL INSERT rau hauvtxib kom ntxig cov ntaub ntawv.

Qhov kev ua haujlwm muaj ob qhov tsis muaj thiab rov qab TRUE yog tias kev ua tiav tiav, txwv tsis pub nws rov FALSE.

qauv sau ntawv

mysqli_query(connection,query,resultmode);

piv txwv

Qhov kev zov me nyuam hauv qhov piv txwv hauv qab no tau txais peb qhov chaw ntawm cov ntaub ntawv nkag los ntawm tus neeg siv thiab ntxig rau hauv cov ntaub ntawv cov ntaub ntawv:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
echo '连接成功
';
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$chenweiliang_title = '学习 Python';
$chenweiliang_author = 'chenweiliang.com';
$submission_date = '2016-03-06';
 
$sql = "INSERT INTO chenweiliang_tbl ".
 "(chenweiliang_title,chenweiliang_author, submission_date) ".
 "VALUES ".
 "('$chenweiliang_title','$chenweiliang_author','$submission_date')";
 
 
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法插入数据: ' . mysqli_error($conn));
}
echo "数据插入成功\n";
mysqli_close($conn);
?>

Tom ntej no, peb tuaj yeem saib cov ntaub ntawv cov ntaub ntawv nrog cov lus hauv qab no: