Me pehea te whakauru raraunga ki roto i te ripanga papaa raraunga MySQL? php whakauru tauira tauākī raraunga ki MySQL

pātengi raraunga MySQLMe pehea te whakauru raraunga ki te ripanga? php kiMySQLKōkuhu tauira tauākī raraunga

MySQL whakauru raraunga

whakamahi tepu MySQL Whakauru atu ki roto Tauākī SQL hei kōkuhu raraunga.

Ka taea e koe te whakauru raraunga ki te ripanga raraunga ma te mysql> matapihi whakahau whakahau, ma te tuhinga PHP ranei hei whakauru raraunga.

wetereo

Ko nga mea e whai ake nei he mea noa mo te whakauru raraunga ki nga ripanga raraunga MySQL Whakauru atu ki roto Kuputuhi SQL:

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

Mēnā he momo pūāhua te raraunga, me whakamahi korukī kotahi, korukī rua rānei, pēnei i: "uara".

Kōkuhu raraunga mā te matapihi wawe whakahau

Kei raro ka whakamahia e matou te SQL Whakauru atu ki roto Ko te tauākī ka kōkuhu raraunga ki te ripanga raraunga MySQL chenweiliang_tbl

Akoranga

I roto i te tauira e whai ake nei ka whakauruhia e matou nga waahanga raraunga e toru ki te ripanga 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>

Tuhipoka: Tohu ki nga pere -> Ehara i te wahanga o te tauākī SQL, he tohu noa he rārangi hou. Mena he roa rawa te korero SQL, ka taea e tatou te hanga raina hou hei tuhi i te tauākī SQL mā te whakamahi i te kī Enter. Ko te kaiwhakamutu whakahau o te tauākī SQL he tohupiro ;.

I roto i te tauira i runga ake nei, kaore matou i whakarato i nga raraunga o chenweiliang_id, na te mea kua tohua tenei mara hei huanga AUTO_INCREMENT i te wa i hanga ai e matou te ripanga.No reira, ka whakanuia aunoatia te mara me te kore tatou e whakarite.I roto i te tauira NOW() he mahi MySQL e whakahoki mai ana i te ra me te wa.

I muri mai, ka taea e tatou te tiro i nga raraunga ripanga raraunga me te korero e whai ake nei:

Kōkuhu raraunga mā te hōtuhi PHP

Ka taea e koe te whakamahi i te mahi mysqli_query() a PHP hei mahi SQL KAUPAPA KI ROTOwhakahau ki te whakauru raraunga.

E rua nga tawhā o te mahi ka whakahoki i te TRUE mena ka angitu te mahi, ki te kore ka hoki mai te HERE.

wetereo

mysqli_query(connection,query,resultmode);

Akoranga

Ko te papatono i roto i te tauira e whai ake nei ka whiwhi e toru nga mara o nga raraunga i whakauruhia e te kaiwhakamahi ka whakauruhia ki roto i te ripanga raraunga:

<?
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);
?>

I muri mai, ka taea e tatou te tiro i nga raraunga ripanga raraunga me te korero e whai ake nei: