Kepiye cara nglebokake data menyang tabel database MySQL? php masang conto statement data menyang MySQL

database MySQLKepiye cara nglebokake data menyang tabel? php ikiMySQLSisipake conto statement data

MySQL nglebokake data

nggunakake tabel MySQL ING IKI Pernyataan SQL kanggo nglebokake data.

Sampeyan bisa nglebokake data menyang tabel data liwat mysql> jendhela command prompt, utawa liwat skrip PHP kanggo nglebokake data.

toto wicoro

Ing ngisor iki umume kanggo nglebokake data menyang tabel data MySQL ING IKI sintaks SQL:

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

Yen data jinis karakter, sampeyan kudu nggunakake kuotasi siji utawa kuotasi pindho, kayata: "nilai".

Lebokake data liwat jendhela command prompt

Ing ngisor iki kita bakal nggunakake SQL ING IKI Pernyataan kasebut nglebokake data menyang tabel data MySQL chenweiliang_tbl

Kadadeyan

Ing conto ing ngisor iki, kita bakal nglebokake telung potongan data menyang tabel 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>

Cathetan: Tandha nganggo panah -> Iku dudu bagean saka statement SQL, mung makili baris anyar. Yen statement SQL dawa banget, kita bisa nggawe baris anyar kanggo nulis statement SQL kanthi nggunakake tombol Enter. Terminator perintah saka statement SQL yaiku a titik koma ;.

Ing conto ing ndhuwur, kita ora menehi data chenweiliang_id, amarga lapangan iki wis disetel minangka atribut AUTO_INCREMENT nalika nggawe tabel.Mula, lapangan bakal ditambah kanthi otomatis tanpa kita kudu nyetel.Ing conto SAIKI () iku fungsi MySQL sing ngasilake tanggal lan wektu.

Sabanjure, kita bisa ndeleng data tabel data kanthi pratelan ing ngisor iki:

Lebokake data nggunakake skrip PHP

Sampeyan bisa nggunakake fungsi mysqli_query () PHP kanggo nindakake SQL INSERT INTOprintah kanggo nglebokake data.

Fungsi kasebut nduweni rong parameter lan ngasilake TRUE yen eksekusi kasebut sukses, yen ora, bakal ngasilake FALSE.

toto wicoro

mysqli_query(connection,query,resultmode);

Kadadeyan

Program ing conto ing ngisor iki nampa telung kolom data sing dilebokake pangguna lan dilebokake menyang tabel 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);
?>

Sabanjure, kita bisa ndeleng data tabel data kanthi pratelan ing ngisor iki: