Kedu otu esi etinye data n'ime tebụl nchekwa data MySQL? php tinye nkwupụta data atụ na MySQL

MySQL nchekwa dataKedu ka esi etinye data na tebụl? php naMySQLFanye ọmụmaatụ nkwupụta data

MySQL tinye data

MySQL table eji Tinye n'ime Nkwupụta SQL iji tinye data.

Ị nwere ike itinye data na tebụl data site na mysql> windo ngwa ngwa, ma ọ bụ site na ederede PHP iji tinye data.

ụtọ asụsụ

Ihe ndị a na-emekarị maka itinye data n'ime tebụl data MySQL Tinye n'ime SQL syntax:

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

Ọ bụrụ na data ahụ bụ ụdị agwa, ị ga-ejirịrị otu nkwuputa ma ọ bụ nhụta okpukpu abụọ, dịka: "uru".

Tinye data site na windo ngwa ngwa

N'okpuru anyị ga-eji SQL Tinye n'ime Nkwupụta ahụ na-etinye data n'ime tebụl data MySQL chenweiliang_tbl

ihe atụ

N'ihe atụ na-esonụ, anyị ga-etinye data atọ n'ime tebụl 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>

Mara: Jiri akụ kaa akara -> Ọ bụghị akụkụ nke nkwupụta SQL, ọ na-anọchi anya ahịrị ọhụrụ, ọ bụrụ na nkwupụta SQL dị ogologo, anyị nwere ike ịmepụta ahịrị ọhụrụ iji dee nkwupụta SQL site na iji igodo Tinye. semicolon ;.

N'ihe atụ a dị n'elu, anyị enyeghị data nke chenweiliang_id, n'ihi na edobere mpaghara a ka àgwà AUTO_INCREMENT mgbe anyị mepụtara tebụl.Ya mere, ubi ga-akpaghị aka na-abawanye na-enweghị anyị mkpa ịtọ ya.Na ihe atụ UGBUA() bụ ọrụ MySQL na-eweghachi ụbọchị na oge.

Ọzọ, anyị nwere ike ịlele data tebụl data na nkwupụta ndị a:

Jiri script PHP tinye data

Ị nwere ike iji PHP's mysqli_query() ọrụ ime Tinye SQL n'imeiwu itinye data.

Ọrụ ahụ nwere parampat abụọ wee weghachi TRUE ma ọ bụrụ na ogbugbu ahụ gara nke ọma, ma ọ bụghị ya, ọ ga-alaghachi FALSE.

ụtọ asụsụ

mysqli_query(connection,query,resultmode);

ihe atụ

Ihe omume dị na ihe atụ a na-enweta mpaghara data atọ nke onye ọrụ tinyere wee tinye ha na tebụl 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);
?>

Ọzọ, anyị nwere ike ịlele data tebụl data na nkwupụta ndị a: