Sidee MySQL u waydiisaa xogta xogta miiska?Weydiinta Bayaanka/Amarka/Syntax

database MySQLSidee loo waydiiyaa xogta shaxda?Weydiinta Bayaanka/Amarka/Syntax

MySQL Xogta weydiinta

Xogta MySQL waxay isticmaashaa weedho SQL SELECT si ay u waydiiso xogta.

Waxaad waydiin kartaa xogta ku jirta kaydka iyada oo loo marayo mysql> daaqada degdega ah, ama qoraalka PHP.

naxwaha

Kuwa soo socdaa waa guud ahaan SELECT syntax ee xog weydiinta xogta MySQL:

SELECT column_name,column_name
FROM table_name
[WHERE Clause]
[OFFSET M ][LIMIT N]

• Bayaanka weydiinta, waxaad isticmaali kartaa hal ama in ka badan oo miisas ah, kala saar shaxaha hakadka leh (,), oo isticmaal qoraalka HALKEE si aad u dejiso shuruudaha weydiinta.
• Amarka SELECT wuxuu akhriyi karaa hal ama ka badan diiwaan.
• Waxaad isticmaali kartaa calaamad (*) si aad u bedesho meelaha kale, bayaanka SELECT ayaa soo celin doona dhammaan xogta goobta ee miiska
• Waxaad isticmaali kartaa bayaanka WHERE si aad ugu darto xaalad kasta.
• Waxaad qeexi kartaa xogta ka-dhaafka ah ee bayaanka SELECT uu ku bilaabo weydiinta OFFSET.Sida caadiga ah dhimashadu waa 0.
• Waxaad isticmaali kartaa hantida LIMIT si aad u dejiso tirada diiwaannada la soo celiyay.

Xogta ku hel degdeg degdeg ah

Tusaalaha soo socda, waxaan u isticmaali doonaa amarka SQL SELECT si aan u helno xogta miiska xogta MySQL chenweiliang_tbl:

tusaale

Tusaalaha soo socda ayaa soo celin doona dhammaan diiwaanada shaxda xogta chenweiliang_tbl:

select * from chenweiliang_tbl;

Isticmaal qoraalka PHP si aad u hesho xogta

iyadoo la isticmaalayo PHP functional mysqli_query() iyo Xulashada SQL amar si aad u hesho xogta.

Shaqadan waxaa loo isticmaalaa in lagu fuliyo amarrada SQL ka dibna lagu gudbiyo hawlaha PHP mysqli_fetch_array() si aad u isticmaasho ama u soo saarto xogta dhammaan weydiimaha.

mysqli_fetch_array() Shaqadu waxay ka soo saartaa saf ka soo baxa natiijada loo dejiyay sida isku xidhka isku xidhka, ama tirooyinka kala duwan, ama labadaba.Waxay soo celisaa array ka soo baxay safafka laga keenay natiijada la dhigay, ama been haddi aanay jirin safaf dambe.

Tusaalaha soo socdaa wuxuu akhriyaa dhammaan diiwaanada miiska xogta chenweiliang_tbl.

tusaale

Isku day tusaalahan soo socda si aad u muujiso dhammaan diiwaanada shaxda xogta chenweiliang_tbl.

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT chenweiliang_id, chenweiliang_title, 
 chenweiliang_author, submission_date
 FROM chenweiliang_tbl';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 mysqli_fetch_array 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{
 echo "<tr><td> {$row['chenweiliang_id']}</td> ".
 "<td>{$row['chenweiliang_title']} </td> ".
 "<td>{$row['chenweiliang_author']} </td> ".
 "<td>{$row['submission_date']} </td> ".
 "</tr>";
}
echo '</table>';
mysqli_close($conn);
?>

Tusaalaha kore, saf kasta oo diiwaanka la akhriyo waxaa lagu meeleeyaa doorsoomiyaha $ saf, ka dibna qiime kasta waa la daabacay.

Xusuusin:Xusuusnow haddii aad u baahan tahay inaad doorsoome ku isticmaashid xargaha, doorsoomaha geli xargaha laablaaban.

Tusaalaha kore, halbeegga labaad ee shaqada PHP mysqli_fetch_array() waa MYSQL_ASSOC, u deji cabbirkan si aad u waydiiso natiijada si aad u soo celiso array associative, waxaad isticmaali kartaa magaca goobta sida tusaha tusmada.

PHP wuxuu bixiyaa shaqo kale mysqli_fetch_assoc(), shaqadu waxay ka qaadanaysaa saf ka soo baxay natiijada loo dejiyay sida isku xidhka associative.Soo celisaa isku xidhka isku xidhka ee ka soo baxay safafka laga soo qaatay natiijada la dhigay, ama been haddii aanay jirin safaf dambe.

tusaale

Isku day tusaalahan soo socda, kaas oo isticmaalaya mysqli_fetch_assoc() shaqada si loo soo saaro dhammaan diiwaanada shaxda xogta chenweiliang_tbl:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT chenweiliang_id, chenweiliang_title, 
 chenweiliang_author, submission_date
 FROM chenweiliang_tbl';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 mysqli_fetch_assoc 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_assoc($retval))
{
 echo "<tr><td> {$row['chenweiliang_id']}</td> ".
 "<td>{$row['chenweiliang_title']} </td> ".
 "<td>{$row['chenweiliang_author']} </td> ".
 "<td>{$row['submission_date']} </td> ".
 "</tr>";
}
echo '</table>';
mysqli_close($conn);
?>

Waxa kale oo aad isticmaali kartaa MYSQL_NUM joogta ah oo ah halbeegga labaad ee PHP mysqli_fetch_array(), oo soo celisa tirooyin kala duwan.

tusaale

Tusaalooyinka soo socda ayaa isticmaala MYSQL_NUM Halbeeggu wuxuu soo bandhigayaa dhammaan diiwaannada shaxda xogta chenweiliang_tbl:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT chenweiliang_id, chenweiliang_title, 
 chenweiliang_author, submission_date
 FROM chenweiliang_tbl';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 mysqli_fetch_array 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_NUM))
{
 echo "<tr><td> {$row[0]}</td> ".
 "<td>{$row[1]} </td> ".
 "<td>{$row[2]} </td> ".
 "<td>{$row[3]} </td> ".
 "</tr>";
}
echo '</table>';
mysqli_close($conn);
?>

xusuusta sii deyn

Waa dhaqan wanaagsan in la xoreeyo xusuusta cursorka ka dib marka aan fulino bayaanka SELECT.

Xusuusta waxaa lagu sii deyn karaa shaqada PHP mysqli_free_result().

Tusaalaha soo socdaa wuxuu muujinayaa isticmaalka shaqadan.

tusaale

Isku day tusaalooyinka soo socda:

Xusuusta bilaashka ah oo leh mysqli_free_result:

<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
 die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
 
$sql = 'SELECT chenweiliang_id, chenweiliang_title, 
 chenweiliang_author, submission_date
 FROM chenweiliang_tbl';
 
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
 die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 mysqli_fetch_array 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_NUM))
{
 echo "<tr><td> {$row[0]}</td> ".
 "<td>{$row[1]} </td> ".
 "<td>{$row[2]} </td> ".
 "<td>{$row[3]} </td> ".
 "</tr>";
}
echo '</table>';
// 释放内存
mysqli_free_result($retval);
mysqli_close($conn);
?>