Sida loo geliyo xogta miiska xogta MySQL? php geli tusaale bayaanka xogta MySQL

Sidee xogta loogu gelin karaa miiska xogta MySQL ? Tusaalaha weedhaha PHP ee loogu talagalay gelinta xogta MySQL.

MySQL geli xogta

MySQL, bayaanka INSERT INTO SQL waxaa loo isticmaalaa in xogta lagu geliyo jadwal.

Waxaad xogta geli kartaa miiska xogta iyada oo loo marayo mysql> daaqada degdega ah, ama iyada oo loo marayo qoraalka PHP si aad xogta u geliso.

naxwaha

Soo socdaa waa hab-dhiska guud ee INSERT INTO SQL ee loogu talagalay gelinta xogta jadwalka MySQL :

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

Haddii xogtu ay tahay nooca xarfaha, waa inaad isticmaashaa hal-xigasho ama xigasho labanlaab ah, sida: "value".

Geli xogta iyada oo loo marayo daaqada degdega ah

Hoos, waxaan u isticmaali doonnaa bayaanka SQL INSERT INTO si aan xogta ugu gelinno jadwalka MySQL chenweiliang_tbl.

tusaale

Tusaalaha soo socda waxaanu gelin doonaa saddex qaybood oo xog ah shaxda 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>

Fiiro gaar ah: Fallaadha -> ma aha qayb ka mid ah bayaanka SQL; waxay si fudud u tilmaamaysaa sadar cusub. Haddii bayaanka SQL uu aad u dheer yahay, waxaan abuuri karnaa sadar cusub annagoo riixayna Enter. Joojiyaha amarka ee bayaanka SQL waa semicolon ;.

Tusaalaha kore, ma aanan bixinin xogta chenweiliang_id, sababtoo ah goobtan waxaa loo dejiyay sifada AUTO_INCREMENT markii aan abuurnay miiska.Sidaa darteed, goobta si toos ah ayaa loo kordhin doonaa iyada oo aan u baahnayn in aan dejino.Tusaalaha hadda () waa shaqada MySQL oo soo celisa taariikhda iyo waqtiga.

Marka xigta, waxaan ku arki karnaa xogta miiska xogta leh bayaankan soo socda:

Geli xogta adoo isticmaalaya qoraalka PHP

Waxaad isticmaali kartaa shaqada mysqli_query() ee PHP si aad u fuliso amarka SQL INSERT INTO si aad xogta u geliso.

Shaqadu waxay leedahay laba xuduud waxayna soo celisaa RUN haddii fulinta lagu guuleysto, haddii kale waxay soo noqotaa BEEN.

naxwaha

mysqli_query(connection,query,resultmode);

tusaale

Barnaamijka tusaalahan soo socda wuxuu helayaa saddex qaybood oo xog ah oo uu galiyay isticmaaluhu wuxuuna geliyaa shaxda xogta:

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

Marka xigta, waxaan ku arki karnaa xogta miiska xogta leh bayaankan soo socda: