Momwe mungayikitsire deta mu tebulo la database la MySQL? php ikani chitsanzo cha data ku MySQL

MySQL databaseMomwe mungayikitsire deta mu tebulo? php kuMySQLIkani chiganizo cha data

MySQL ikani data

Kugwiritsa ntchito tebulo la MySQL Lowetsani SQL statement kuti muyike data.

Mutha kuyika zambiri patebulo la data kudzera pa mysql> zenera lofulumira, kapena kudzera pa PHP script kuti muyike data.

galamala

Zotsatirazi ndizofala pakuyika deta mumatebulo a data a MySQL Lowetsani SQL syntax:

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

Ngati deta ili ndi mtundu wa anthu, muyenera kugwiritsa ntchito mawu amodzi kapena mawu awiri, monga: "mtengo".

Lowetsani deta kudzera pawindo la Command Prompt

Pansipa tidzagwiritsa ntchito SQL Lowetsani Mawuwa amaika deta mu MySQL data table chenweiliang_tbl

Chitsanzo

Muchitsanzo chotsatira tiyika zidutswa zitatu za data mu tebulo la 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>

Chidziwitso: Chongani ndi mivi -> Sichigawo cha SQL statement, chikungoyimira mzere watsopano.Ngati mawu a SQL ndi otalika kwambiri, titha kupanga mzere watsopano kuti tilembe mawu a SQL podina batani la Enter. The terminator of the SQL statement is a semicoloni ;.

Muchitsanzo chapamwambachi, sitinapereke deta ya chenweiliang_id, chifukwa gawoli lakhazikitsidwa ngati chikhalidwe cha AUTO_INCREMENT pamene timapanga tebulo.Chifukwa chake, gawolo lidzangowonjezereka popanda ife kufunikira kuliyika.Mu chitsanzo TSOPANO () ndi ntchito ya MySQL yomwe imabwezeretsa tsiku ndi nthawi.

Kenako, titha kuwona deta ya tebulo la data ndi mawu awa:

Lowetsani deta pogwiritsa ntchito PHP script

Mutha kugwiritsa ntchito mysqli_query() ntchito ya PHP kuti muchite SQL INSERT MUlamula kuti muyike deta.

Ntchitoyi ili ndi magawo awiri ndipo imabweretsanso TRUE ngati ntchitoyo ikuyenda bwino, apo ayi imabwezeretsa FALSE.

galamala

mysqli_query(connection,query,resultmode);

Chitsanzo

Pulogalamu mu chitsanzo chotsatirachi imalandira magawo atatu a data omwe amalowetsedwa ndi wogwiritsa ntchito ndikuyika patebulo la 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);
?>

Kenako, titha kuwona deta ya tebulo la data ndi mawu awa: