E faʻafefea ona faʻaogaina e MySQL database faʻamatalaga i luga o se laulau?Fa'amatalaga Fa'amatalaga/Poloaiga/Fa'aupuga

Fa'afefea ona fesiligia fa'amaumauga mai se laulau i totonu o se fa'amaumauga MySQL ? Fa'amatalaga/poloaiga/fa'atulagaga fesili

MySQL Fa'amatalaga fesili

MySQL database fa'aoga SQL SELECT fa'amatalaga e su'e ai fa'amaumauga.

E mafai ona e su'eina fa'amaumauga i totonu o fa'amaumauga e ala ile mysql> fa'amalama fa'atonu, po'o fa'amatalaga fa'amatalaga e ala ile PHP script.

kalama

O loʻo taua i lalo le faʻasologa masani SELECT mo le suʻeina o faʻamatalaga i totonu o le MySQL database:

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

• E mafai ona e fa'aoga se tasi pe sili atu fo'i laulau ile fa'amatalaga ole fesili Fa'aoga koma (,) e tu'uese'ese ai laulau, ma fa'aoga le fa'amatalaga WHERE e seti ai tu'utu'uga ole fesili.
• O le SELECT poloaiga e mafai ona faitau se tasi pe sili atu faʻamaumauga.
• E mafai ona e fa'aogaina se fa'ailoga (*) e sui ai isi matā'upu.
• E mafai ona e fa'aogaina le fa'amatalaga WHERE e aofia ai so'o se tulaga.
• E mafai ona e fa'aogaina le OFFSET e fa'ama'oti ai le fa'asologa o fa'amaumauga lea e amata ai ona fesili le fa'amatalaga SELECT. O le fa'aletonu o le offset e 0.
• E mafai ona e fa'aogaina le uiga LIMIT e seti ai le numera o fa'amaumauga ua toe fa'afo'i mai.

Maua fa'amatalaga e ala ile fa'atonuga vave

I le faʻataʻitaʻiga o loʻo mulimuli mai, o le a matou faʻaogaina le SQL SELECT poloaiga e maua ai faʻamatalaga o le MySQL data table chenweiliang_tbl:

Fa'ata'ita'iga

Ole fa'ata'ita'iga lea ole a toe fa'afo'i fa'amaumauga uma ole laulau fa'amaumauga chenweiliang_tbl:

select * from chenweiliang_tbl;

Fa'aoga le PHP script e maua ai fa'amaumauga

Faaaoga le galuega tauave PHP mysqli_query() ma le poloaiga SQL SELECT e toe aumai ai faʻamatalaga.

O lenei galuega faatino e faʻaaogaina e faʻatino ai poloaiga SQL, ona faʻaaogaina lea o le galuega faatino PHP mysqli_fetch_array() e maua ai pe faʻalauiloa mai ai faʻamatalaga uma o loʻo fesiligia.

O le galuega mysqli_fetch_array() e toe aumai ai se laina mai le seti o taunuuga o se fa'asologa fa'atasi, o se fa'asologa numera, po'o mea uma e lua, ma toe fa'afo'i mai ai se fa'asologa na gaosia mai le laina na toe maua mai le seti o taunuuga. Afai e leai ni isi laina, e toe fa'afo'i mai ai le sese.

Ole fa'ata'ita'iga lea e faitau fa'amaumauga uma mai le laulau fa'amaumauga chenweiliang_tbl.

Fa'ata'ita'iga

Fa'ata'ita'i le fa'ata'ita'iga lea e fa'aali uma fa'amaumauga o le laulau fa'amaumauga 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);
?>

I le fa'ata'ita'iga o lo'o i luga, o laina ta'itasi o fa'amaumauga o lo'o faitauina e tu'uina atu i le fesuiaiga $laina, ona lolomi lea o tau ta'itasi.

Manatua: Ia manatua e tu'u le fesuia'iga i totonu o ni fa'amau fa'apipi'i pe a mana'omia ona e fa'aogaina i se manoa.

I le faʻataʻitaʻiga o loʻo i luga, o le parakalafa lona lua o le galuega tauave PHP mysqli_fetch_array() o le MYSQL_ASSOC . O le setiina o lenei parakalafa e toe faʻafoʻi mai ai se faʻasologa faʻatasi, ma e mafai ona e faʻaogaina le igoa o le fanua e fai ma faʻasino i le faʻasologa.

E tu'uina atu e le PHP se isi galuega, `mysqli_fetch_assoc()` , lea e toe aumai ai se laina e tasi mai le seti o taunuuga o se fa'asologa fa'atasi. E toe fa'afo'i mai ai se fa'asologa fa'atasi e fa'atatau i laina na toe maua mai le seti o taunuuga; afai e leai ni isi laina e avanoa, e toe fa'afo'i mai ai le sese.

Fa'ata'ita'iga

Taumafai i le faʻataʻitaʻiga lenei, lea e faʻaaogaina ai le galuega mysqli_fetch_assoc() e faʻaalia ai faʻamaumauga uma o le laulau 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);
?>

E mafai fo'i ona e fa'aogaina le MYSQL_NUM faifai pea e fai ma finauga lona lua ile PHP mysqli_fetch_array() galuega, lea e toe fa'afo'i ai se numera numera.

Fa'ata'ita'iga

O le faʻataʻitaʻiga lenei e faʻaaogaina ai le parakalafa MYSQL_NUM e faʻaalia ai faʻamaumauga uma i le laulau 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);
?>

fa'amalologa manatua

O se mausa lelei le fa'asa'olotoina o le mafaufau pe a uma ona tatou fa'atinoina le fa'amatalaga SELECT.

E mafai ona maua le fa'asa'olotoga e ala i le galuega PHP mysqli_free_result().

O le fa'ata'ita'iga lea e fa'aalia ai le fa'aogaina o lenei galuega.

Fa'ata'ita'iga

Fa'ata'ita'i fa'ata'ita'iga nei:

Faʻaaoga mysqli_free_result e faʻasaʻo ai le manatua:

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