Bii o ṣe le fi data sinu tabili data MySQL? php fi apẹẹrẹ alaye alaye si MySQL

MySQL databaseBawo ni lati fi data sinu tabili? php siMySQLFi apẹẹrẹ alaye alaye sii

MySQL fi data sii

MySQL tabili lilo Fi sii Gbólóhùn SQL lati fi data sii.

O le fi data sii sinu tabili data nipasẹ mysql> window tọ aṣẹ, tabi nipasẹ iwe afọwọkọ PHP kan lati fi data sii.

girama

Awọn atẹle jẹ wọpọ fun fifi data sii sinu awọn tabili data MySQL Fi sii SQL sintasi:

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

Ti data ba jẹ iru ohun kikọ, o gbọdọ lo awọn agbasọ ẹyọkan tabi awọn agbasọ ọrọ ilọpo meji, gẹgẹbi: “iye”.

Fi data sii nipasẹ window kiakia

Ni isalẹ a yoo lo SQL Fi sii Gbólóhùn naa fi data sii sinu tabili data MySQL chenweiliang_tbl

Apeere

Ninu apẹẹrẹ atẹle a yoo fi awọn ege data mẹta sii sinu tabili 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>

Akiyesi: Samisi pẹlu awọn ọfa -> Kii se lara gbolohun SQL, o kan duro laini tuntun, ti gbolohun SQL ba gun ju, a le seda ila tuntun lati ko gbolohun SQL nipa lilo bọtini Enter. semicolon ;,

Ninu apẹẹrẹ ti o wa loke, a ko pese data ti chenweiliang_id, nitori aaye yii ti ṣeto bi abuda AUTO_INCREMENT nigba ti a ṣẹda tabili naa.Nitorinaa, aaye naa yoo jẹ afikun laifọwọyi laisi a nilo lati ṣeto rẹ.Ninu apẹẹrẹ NOW () jẹ iṣẹ MySQL ti o da ọjọ ati akoko pada.

Nigbamii, a le wo data tabili data pẹlu alaye atẹle:

Fi data sii nipa lilo iwe afọwọkọ PHP

O le lo iṣẹ mysqli_query() PHP lati ṣe SQL SINUpipaṣẹ lati fi data sii.

Iṣẹ naa ni awọn paramita meji ati pada TÒÓTỌ ti ipaniyan ba ṣaṣeyọri, bibẹẹkọ o pada FALSE.

girama

mysqli_query(connection,query,resultmode);

Apeere

Eto naa ni apẹẹrẹ atẹle gba awọn aaye data mẹta ti olumulo ti tẹ ati fi sii wọn sinu tabili data:

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

Nigbamii, a le wo data tabili data pẹlu alaye atẹle: