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

MySQL databaseE fa'afefea ona fesiligia fa'amatalaga i le laulau? Fa'amatalaga fesili/poloaiga/syntax

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

Faʻaaogaina galuega PHP mysqli_query() ma le SQL FILIFILIA fa'atonuga ia maua fa'amaumauga.

O lenei galuega e faʻaaogaina e faʻatino ai tulafono SQL ona pasi ai lea o le PHP galuega mysqli_fetch_array() e fa'aaoga pe fa'aulu uma fa'amatalaga fesiligia.

mysqli_fetch_array() O le galuega e toe aumai se laina mai le fa'ai'uga seti o se la'au fa'atasi, se fa'asologa numera, po'o mea uma e lua.

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:Manatua pe afai e te manaʻomia le faʻaogaina o se fesuiaiga i totonu o se manoa, tuʻu le fesuiaiga i fusi faʻafefe.

I le faʻataʻitaʻiga o loʻo i luga, o le vaega lona lua o le PHP mysqli_fetch_array() galuega o MYSQL_ASSOC, Seti lenei ta'iala ma o le fa'ai'uga fesili e toe fa'afo'i ai se fa'asologa fa'atasi E mafai ona e fa'aogaina le igoa ole fanua e fai ma fa'asino ole laina.

PHP e maua ai se isi galuega mysqli_fetch_assoc(), e maua e lenei galuega se laina mai le fa'ai'uga ua setiina o se fa'asologa fa'atasi. Fa'afo'i se fa'asologa fa'atasi e fa'atatau i laina na maua mai le fa'ai'uga seti, pe sese pe a leai ni laina.

Fa'ata'ita'iga

Taumafai le faʻataʻitaʻiga o loʻo i lalo, lea e faʻaaogaina mysqli_fetch_assoc() Galuega e fa'atino ai fa'amaumauga uma 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_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 faʻataʻitaʻiga nei e faʻaaogaina MYSQL_NUM O fa'amaufa'ailoga e fa'aalia 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_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);
?>