Maitiro ekuisa data muMySQL database tafura? php isa data statement muenzaniso kuMySQL

MySQL databaseNzira yekuisa sei data mutafura? php kutiMySQLIsa data statement muenzaniso

MySQL isa data

MySQL tafura kushandiswa PINDA SQL statement yekuisa data.

Iwe unogona kuisa data mutafura yedata kuburikidza ne mysql> yekuraira hwindo, kana kuburikidza neiyo PHP script yekuisa data.

girama

Izvi zvinotevera zvakajairika kuisa data muMySQL data matafura PINDA SQL syntax:

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

Kana iyo data iri yemhando yemhando, unofanirwa kushandisa makotesheni ega kana kaviri makotesheni, akadai se: "kukosha".

Isa data kuburikidza nemirairo yekukurumidza hwindo

Pazasi isu tichashandisa SQL PINDA Chirevo chinoisa data muMySQL data tafura chenweiliang_tbl

muenzaniso

Mumuenzaniso unotevera tichaisa zvidimbu zvitatu zve data muchenweiliang_tbl tafura:

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>

Ongorora: Maka nemiseve -> Haisi chikamu chechirevo cheSQL, inongomiririra mutsara mutsva.Kana SQL statement yakarebesa, tinogona kugadzira mutsara mutsva wekunyora SQL statement nekudzvanya Enter key.Command terminator yeSQL statement ndeye semicolon ;.

Mumuenzaniso wepamusoro, hatina kupa data ye chenweiliang_id, nokuti munda uyu wakaiswa seAUTO_INCREMENT hunhu patakasika tafura.Naizvozvo, munda unozowedzerwa otomatiki pasina isu kuda kuumisa.Mumuenzaniso ZVINO () ibasa reMySQL rinodzosa zuva nenguva.

Tevere, tinogona kuona iyo data tafura data neshoko rinotevera:

Isa data uchishandisa PHP script

Unogona kushandisa PHP's mysqli_query() basa kuita SQL INSERT INraira kuisa data.

Basa racho rine maparamendi maviri uye rinodzorera TRUE kana kuurayiwa kwabudirira, zvikasadaro inodzorera FALSE.

girama

mysqli_query(connection,query,resultmode);

muenzaniso

Chirongwa chiri mumuenzaniso unotevera chinogashira minda mitatu yedata yakaiswa nemushandisi uye inoiisa mutafura yedata:

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

Tevere, tinogona kuona iyo data tafura data neshoko rinotevera: