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

MySQL databaseMokhoa oa ho kenya data tafoleng? php hoMySQLKenya mohlala oa polelo ea data

MySQL kenya data

E sebelisoa litafoleng tsa MySQL KENANG KENYA Lipolelo tsa SQL ho kenya data.

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

E latelang ke mokhoa o akaretsang oa ho kenya data tafoleng ea data ea MySQL KENANG KENYA SQL syntax:

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 sebelisa SQL KENANG KENYA Polelo ea ho kenya data tafoleng ea data ea 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>

Tlhokomeliso: Sebelisa matšoao a metsu -> Ha se karolo ea polelo ea SQL. E emela feela mola o mocha. Haeba polelo ea SQL e le telele haholo, re ka theha mola o mocha ka ho tobetsa konopo ea Enter ho ngola statemente sa SQL. semikholone. ;.

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

U ka sebelisa mosebetsi oa PHP's mysqli_query() ho etsa SQL KENYA HOtaelo ea 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: