Yadda za a saka bayanai a cikin MySQL database tebur? php saka bayanin bayanin misali zuwa MySQL

MySQL databaseYadda za a saka bayanai a cikin tebur? php kuMySQLSaka misali bayanin bayanin

MySQL saka bayanai

MySQL tebur amfani Saka ciki Bayanin SQL don saka bayanai.

Kuna iya saka bayanai a cikin tebur ɗin bayanai ta taga mysql> umarni da sauri, ko ta hanyar rubutun PHP don saka bayanai.

nahawu

Wadannan sun zama ruwan dare don saka bayanai a cikin tebur na bayanan MySQL Saka ciki SQL syntax:

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

Idan bayanan nau'in haruffa ne, dole ne ku yi amfani da ƙididdiga ɗaya ko ƙididdiga biyu, kamar: "darajar".

Saka bayanai ta taga da sauri

A ƙasa za mu yi amfani da SQL Saka ciki Bayanin yana saka bayanai a cikin teburin bayanan MySQL chenweiliang_tbl

misali

A cikin misali mai zuwa za mu saka bayanai guda uku a cikin tebur na 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>

Lura: Yi alama da kibau -> Ba a cikin bayanin SQL ba, yana wakiltar sabon layi ne kawai, idan bayanin SQL ya yi tsawo, zamu iya ƙirƙirar sabon layi don rubuta bayanin SQL ta amfani da maɓallin Shigar. semicolon ;.

A cikin misalin da ke sama, ba mu samar da bayanan chenweiliang_id ba, saboda an saita wannan filin azaman sifa ta AUTO_INCREMENT lokacin da muka ƙirƙiri tebur.Don haka, filin za a ƙara ta atomatik ba tare da buƙatar saita shi ba.A cikin misalin NOW() shine aikin MySQL wanda ke dawo da kwanan wata da lokaci.

Na gaba, za mu iya duba bayanan teburin bayanai tare da sanarwa mai zuwa:

Saka bayanai ta amfani da rubutun PHP

Kuna iya amfani da aikin mysqli_query() na PHP don yin SQL SHIGAumarni don saka bayanai.

Aikin yana da sigogi biyu kuma yana dawo da GASKIYA idan aiwatarwar ya yi nasara, in ba haka ba ya dawo KARYA.

nahawu

mysqli_query(connection,query,resultmode);

misali

Shirin a cikin misali mai zuwa yana karɓar fage uku na bayanan da mai amfani ya shigar kuma ya sanya su cikin tebur ɗin bayanai:

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

Na gaba, za mu iya duba bayanan teburin bayanai tare da sanarwa mai zuwa: