Hướng dẫn while mysqli_fetch_array - trong khi mysqli_fetch_array
|
Hàm Show  Bài viết này được đăng tại freetuts.net, không được copy dưới mọi hình thức.freetuts.net, không được copy dưới mọi hình thức. Cú phápCú pháp: Trong đó::
Kết quả trả vềHàm sẽ trả về mảng kết hợp hoặc liên tục chứa thông tin của hàng kết quả. Bài viết này được đăng tại [free tuts .net] Ví dụCách sử dụng hàm Code $con=mysqli_connect("localhost","my_user","my_password","my_db");
// Check connection
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$sql="SELECT Lastname,Age FROM Persons ORDER BY Lastname";
$result=mysqli_query($con,$sql);
// Numeric array
$row=mysqli_fetch_array($result,MYSQLI_NUM);
printf ("%s (%s)\n",$row[0],$row[1]);
// Associative array
$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
printf ("%s (%s)\n",$row["Lastname"],$row["Age"]);
// Free result set
mysqli_free_result($result);
mysqli_close($con);Tham khảo: w3schools.com mysqli_fetch_array(PHP 5, PHP 7, PHP 8) mysqli_result::fetch_array -- mysqli_fetch_array — Fetch the next row of a result set as an associative, a numeric array, or both -- mysqli_fetch_array — Fetch the next row of a result set as an associative, a numeric array, or both DescriptionObject-oriented style publicmysqli_result::fetch_array(int mysqli_fetch_array(mysqli_result In addition to storing the data in the numeric indices of the result array, this function can also store the data in associative indices by using the field names of the result set as keys. If two or more columns of the result have the same name, the last column will take precedence and overwrite any previous data. To access multiple columns with the same name, the numerically indexed version of the row must be used.
ParametersKabul (AFG) Qandahar (AFG) Herat (AFG)6 Procedural style only: A mysqli_result object returned by mysqli_query(), mysqli_store_result(), mysqli_use_result() or mysqli_stmt_get_result().mysqli_result object returned by mysqli_query(), mysqli_store_result(), mysqli_use_result() or mysqli_stmt_get_result(). Kabul (AFG) Qandahar (AFG) Herat (AFG)7 This optional parameter is a constant indicating what type of array should be produced from the current row data. The possible values for this parameter are the constants Kabul (AFG) Qandahar (AFG) Herat (AFG)8, Kabul (AFG) Qandahar (AFG) Herat (AFG)9, or Kabul (AFG) Qandahar (AFG) Herat (AFG)1. Kabul (AFG) Qandahar (AFG) Herat (AFG)8, Kabul (AFG) Qandahar (AFG) Herat (AFG)9, or Kabul (AFG) Qandahar (AFG) Herat (AFG)1. By using the Kabul (AFG) Qandahar (AFG) Herat (AFG)8 constant this function will behave identically to the mysqli_fetch_assoc(), while Kabul (AFG) Qandahar (AFG) Herat (AFG)9 will behave identically to the mysqli_fetch_row() function. The final option Kabul (AFG) Qandahar (AFG) Herat (AFG)1 will create a single array with the attributes of both. Kabul (AFG) Qandahar (AFG) Herat (AFG)8 constant this function will behave identically to the mysqli_fetch_assoc(), while Kabul (AFG) Qandahar (AFG) Herat (AFG)9 will behave identically to the mysqli_fetch_row() function. The final option Kabul (AFG) Qandahar (AFG) Herat (AFG)1 will create a single array with the attributes of both. Return ValuesReturns an array representing the fetched row, Kabul (AFG) Qandahar (AFG) Herat (AFG)5 if there are no more rows in the result set, or mysqli_fetch_array()5 on failure. Kabul (AFG) Qandahar (AFG) Herat (AFG)5 if there are no more rows in the result set, or mysqli_fetch_array()5 on failure. ExamplesExample #1 mysqli_result::fetch_array() examplemysqli_result::fetch_array() example Object-oriented style
mysqli_fetch_array()8publicmysqli_result::fetch_array(int Kabul (AFG) Qandahar (AFG) Herat (AFG)0 = Kabul (AFG) Qandahar (AFG) Herat (AFG)1): array|null|false
mysqli_fetch_array( $result, $result_type);1mysqli_fetch_array(mysqli_result Kabul (AFG) Qandahar (AFG) Herat (AFG)0 = Kabul (AFG) Qandahar (AFG) Herat (AFG)1): array|null|false Kabul (AFG) Qandahar (AFG) Herat (AFG) In addition to storing the data in the numeric indices of the result array, this function can also store the data in associative indices by using the field names of the result set as keys.
Kabul (AFG) Qandahar (AFG) Herat (AFG)7 |
