PHP MySQL ORDER BY Clause

PHP

Syntax:
Basic syntax for Order By - Order fulfillment by point: Let`s consider the following table" Data "with three columns" FirstName "," LastName "and" Age ". < / figure> To sort the FirstName column in the data table in ascending order, you can use the following code.Order by item using a procedural method: php $ link = mysqli_connect ("localhost", "root", "", "Mydb");  
if ($link === false) { die ("ERROR: Could not connect." . mysqli_connect_error()); } $ sql = "SELECT * FROM Data ORDER BY Firstname " ; if ($ res = mysqli_query ($link, $sql)) { if (mysqli_num_rows ($res) > 0) { echo "< table >"; echo "< tr > "; echo "< th > Firstname < / th > "; echo "< th > Lastname < / th > "; echo "< th > age < / th > "; echo "< / tr > "; while ($row = mysqli_fetch_array ($res)) { echo "< tr > "; echo "< td > " ... $row [`Firstname`]. "< / td >"; echo "< td > " ... $row [`Lastname`]. "< / td >"; echo "< td > " ... $row [`Age`]. "< / td >"; echo "< / tr > "; } echo" < / table > "; mysqli_free_result ($res); } else { echo "No matching records are found."; } } else { echo" ERROR: Could not be able to execute $sql. " . mysqli_error ($link); }
mysqli_close ($link);
?>
Output: Code explanation:
  • The "res" variable stores the data returned by mysql_query().
  • Each times, when mysqli_fetch_array() is called, it returns the next row from the set res().
  • The while loop is used to loop through all rows of the "data" table.
  • Sort by sentence using object-oriented method: php $ mysqli = new mysqli ("localhost", "root", "", "Mydb");  
    if ($mysqli === false) { die ("ERROR: Could not connect." . $mysqli-> connect_error); }  
    $sql = "SELECT * FROM Data ORDER BY Firstname";
    if ($res = $mysqli-> query ($sql)) { if ($res-> num_rows > 0) { echo "< table >"; echo "< tr > "; echo "< th > Firstname < / th > "; echo "< th > Lastname < / th > "; echo "< th > Age < / th > "; echo "< / tr > "; while ($row = $res-> fetch_array()) { echo "< tr > "; echo "< td > " ... $row [`Firstname`]. "< / td >"; echo "< td > " ... $row [`Lastname`]. "< / td >"; echo "< td > " ... $row [`Age`]. "< / td >"; echo "< / tr > "; } echo" < / table > "; $res-> free(); } else { echo "No matching records are found."; } } else { echo" ERROR: Could not be able to execute $sql. " . $mysqli-> error; }  
    $mysqli-> close();
    ?>
    Output: Order by item using PDO method: php try { $ pdo = new PDO (" mysql: host = localhost ; dbname = Mydb "," root "," "); $pdo-> setAttribute (PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); } catch (PDOException $e) {   die ("ERROR: Could not connect." . $e-> getMessage()); }
    try { $sql = "SELECT * FROM Data ORDER BY Firstname"; $res = $pdo-> query ($sql); if ($res-> rowCount() > 0) { echo "< table > "; echo "< tr > "; echo "< th > Firstname < / th > "; echo "< th > Lastname < / th > "; echo "< th > Age < / th > "; echo "< / tr > "; while ($row = $res-> fetch()) { echo "< tr > "; echo "< td > " ... $row [`Firstname`]. "< / td >"; echo "< td > " ... $row [`Lastname`]. "< / td >"; echo "< td > " ... $row [`Age`]. "< / td >"; echo "< / tr > "; } echo" < / table > "; unset ($res); } else { echo "No matching records are found."; } } catch (PDOException $e) { die (" ERROR: Could not be able to execute $sql. " . $e-> getMessage()); }  
    unset ($pdo);
    ?>
    Output:



    Get Solution for free from DataCamp guru