Mysqli database data display using Order By

 <?php

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "heer";

//  Create Connection
$conn = new mysqli($servername, $username, $password, $dbname);

//  Check Connection
if($conn->connect_error)
{
    die("Connection Failed" . $conn->connect_error);
}
echo "Connection Successfully" . "<br>";

$sql = "SELECT id, name, age, gender, phone, city FROM student ORDER BY name";
$result = $conn->query($sql);

if($result->num_rows > 0)
{
    while($row = $result->fetch_assoc())
    {
        echo "Id: " . $row["id"] . ",  Name: " . $row["name"] . ",  Age: " . $row["age"] . ",  Gender: "
         . $row["gender"] . ",  Phone: " . $row["phone"] . ",  City: " . $row["city"] . "<br>";
    }
}
$conn->close();

//  OUTPUT:
//Connection Successfully
// Id: 4, Name: Aadit, Age: 29, Gender: M, Phone: 8544632217, City: Pune
// Id: 2, Name: Bhavesh, Age: 33, Gender: M, Phone: 9322587740, City: Ahmedabad
// Id: 3, Name: Chirag, Age: 44, Gender: M, Phone: 9855632210, City: Mumbai
// Id: 5, Name: Doe, Age: 23, Gender: M, Phone: 8533614227, City: Ahmedabad
// Id: 6, Name: heer, Age: 33, Gender: M, Phone: 9933614227, City: Ahmedabad
// Id: 10, Name: Kunj, Age: 22, Gender: M, Phone: 7455210036, City: Delhi
// Id: 9, Name: Lalu, Age: 25, Gender: M, Phone: 9022558466, City: Ahmedabad
// Id: 7, Name: Manish, Age: 33, Gender: M, Phone: 5499632207, City: Mumbai
// Id: 8, Name: Nishant, Age: 20, Gender: M, Phone: 8233012278, City: Delhi
// Id: 15, Name: Nishant, Age: 40, Gender: M, Phone: 9088432210, City: Ahmedabad
// Id: 12, Name: Pankaj, Age: 26, Gender: M, Phone: 9088558466, City: Ahmedabad
// Id: 14, Name: Prachi, Age: 55, Gender: F, Phone: 9355478801, City: Chennai
// Id: 16, Name: Pranav, Age: 22, Gender: M, Phone: 9133285546, City: Ahmedabad
// Id: 11, Name: Priyanshi, Age: 33, Gender: F, Phone: 9522473321, City: Pune
// Id: 1, Name: Ritesh, Age: 23, Gender: M, Phone: 8533614277, City: Ahmedabad
// Id: 13, Name: Urvashi, Age: 24, Gender: F, Phone: 9233048854, City: Mumbai
?>

Comments

Post a Comment

Popular posts from this blog

GROUP BY Clause and HAVING Clause in PHP

GROUP BY :  The GROUP BY clause is used in conjunction with the SELECT Statement and Aggregate functions to group rows together by common column values. SELECT with GROUP BY Syntax : SELECT columns FROM table_name WHERE condition GROUP BY column_name(s); (Here above "condition" is Optional in above query). In "personal" table, there are 6 columns named id, name, percentage, age, gender, city. In "personal" table, column name "id" is PRIMARY KEY and column name "city" is FOREIGN KEY. In "courses" table, there are 2 columns named course_id and course_name. In "courses" table, column name "course_id" is PRIMARY KEY. In "city" table, there are 2 columns named cid and cityname. In "city" table, column name "cid" is PRIMARY KEY. SELECT with GROUP BY with Two Tables Syntax : SELECT columns FROM table1 INNER JOIN table2 ON table1.column_name = table2.column_name WHERE condition GROUP B...
Read more

Method Overriding in Traits in PHP

Image
  <?php class Base {     public function abc ()     {         echo "ABC method from Base class." ;     } } //The trait method(Here, abc() Method) will get priority compared to Parent class Method(Here, abc() Method) trait Test {     public function abc ()     {         echo "ABC method from test trait." ;     } } class Child extends Base {     use Test ;     public function abc ()     {         echo "ABC method from Child class." ;     } } $obj = new Child (); $obj -> abc ();
Read more

Mysqli database Connection and Display Table Data from Database

  <?php $servername = "localhost" ; $username = "root" ; $password = "" ; $dbname = "heer" ; $conn = new mysqli ( $servername , $username , $password , $dbname ); if ( $conn -> connect_error ) {     die ( "Connection Failed : " . $conn -> connect_error ); } $sql = " SELECT * FROM student " ; $result = $conn -> query ( $sql ); if ( $result -> num_rows > 0 ) {     while ( $row = $result -> fetch_assoc ())     {         echo "<pre>" ;         echo "Id: { $row ["id"]} - Name: { $row ["name"]} - Age: { $row ["age"]} - Phone No: { $row ["phone"]} - City: { $row ["city"]}" ;         echo "</pre>" ;     } } else {     echo "No result fount" ; } $conn -> close (); //  OUTPUT: //Id: 0 - Name: Raj - Age: 25 - Phone No: 9854233621 - City: Ahmedabad // Id: 1 - Name: Amit - Age: 22 - Phone No: 8533...
Read more