U ka kenya data joang tafoleng ea database ea MySQL? php kenya mohlala oa polelo ea data ho MySQL

Mokhoa oa ho kenya data tafoleng ea database ea MySQL ? Mohlala oa lipolelo tsa PHP bakeng sa ho kenya data ho MySQL.

MySQL kenya data

Ho MySQL, polelo ea INSERT INTO SQL e sebelisoa ho kenya data tafoleng.

O ka kenya data ka har'a tafole ea data ka mysql> fensetere ea taelo ea taelo, kapa kenya data ka sengoloa sa PHP.

sebōpeho-puo

Se latelang ke syntax e akaretsang ea INSERT INTO SQL bakeng sa ho kenya data tafoleng ea MySQL :

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

Haeba data e le mofuta oa litlhaku, mantsoe a qotsitsoeng a le mong kapa a mabeli a tlameha ho sebelisoa, joalo ka "value".

Kenya data ka fensetere ea taelo ea litaelo

Ka tlase, re tla sebedisa polelo ya SQL INSERT INTO ho kenya data tafoleng ya MySQL chenweiliang_tbl.

Mohlala

Mohlaleng o latelang re tla kenya likarolo tse tharo tsa data tafoleng ea 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>

Hlokomela: Motsu -> ha se karolo ea polelo ea SQL; o mpa o bontša mola o mocha. Haeba polelo ea SQL e le telele haholo, re ka theha mola o mocha ka ho tobetsa Enter. Sephetho sa taelo bakeng sa polelo ea SQL ke semicolon ;.

Mohlala o ka holimo, ha rea ​​fana ka lintlha tsa chenweiliang_id hobane re ne re behile tšobotsi ea AUTO_INCREMENT bakeng sa sebaka sena ha re theha tafole. Ka hona, sebaka sena se tla eketseha ka bohona ntle le hore re hloke ho se beha. Mohlala oa NOW() ke ts'ebetso ea MySQL e khutlisetsang letsatsi le nako.

E latelang re ka sheba data ea tafole ea data ka polelo e latelang:

Kenya data u sebelisa mongolo oa PHP

O ka sebedisa mosebetsi wa mysqli_query() wa PHP ho phethahatsa taelo ya SQL INSERT INTO ho kenya data.

Ts'ebetso e na le liparamente tse peli 'me e khutlisa TRUE haeba ts'ebetso e atlehile, ho seng joalo e khutlisa FALSE.

sebōpeho-puo

mysqli_query(connection,query,resultmode);

Mohlala

Mohlaleng o latelang, lenaneo le fumana lintlha tse tharo tsa tšimo tse kentsoeng ke mosebelisi ebe li li kenya tafoleng ea 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);
?>

E latelang re ka sheba data ea tafole ea data ka polelo e latelang: