PHP MySQL SELECT Data: Retrieve Data from Database with Examples

Tutorial

Forum

PHP

PHP Basic Tutorial

Modify Strings

Concatenate Strings

Slicing Strings

Escape Characters

PHP If...Else...Elseif

PHP If...Else

PHP Shorthand If

PHP Nested If

PHP Switch

PHP Loops

While Loop

Do While Loop

For Loop

Foreach Loop

Indexed Arrays

Associative Arrays

Create Arrays

Access Arrays

Update Array Items

Add Array Items

Remove Array Items

Sorting Arrays

Multidimensional Arrays

Array Functions

PHP Forms

MySQL Connection

PHP Advanced

PHP File Create/Write

PHP OOP

PHP Static Properties

PHP Interview

MySQL Select Data

❮ Previous

Next ❯

To fetch records from a MySQL database using PHP, you can use MySQLi (Procedural & Object-Oriented) or PDO.

The SELECT statement is used to select data from one or more tables

Syntax:

SELECT column1, column2 FROM table_name;

or to select all columns:

SELECT * FROM table_name;

Example - MySQLi (Procedural)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase"; // Change to your database name

// Create connection

$conn = mysqli_connect($servername, $username, $password, $dbname);

// Check connection

if (!$conn) {

die("Connection failed: " . mysqli_connect_error());

}

// Select query

$sql = "SELECT id, name, email FROM users";

$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {

// Output data of each row

while ($row = mysqli_fetch_assoc($result)) {

echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";

}

} else {

echo "0 results";

}

// Close connection

mysqli_close($conn);

Example (MySQLi Object-oriented)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase";

// Create connection

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

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Select query

$sql = "SELECT id, name, email FROM users";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

// Output data of each row

while ($row = $result->fetch_assoc()) {

echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";

}

} else {

echo "0 results";

}

// Close connection

$conn->close();

Example (PDO)

<?php

$servername = "localhost";

$username = "root";

$password = "";

$dbname = "mydatabase";

try {

$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);

// Set PDO error mode to exception

$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

// Select query

$sql = "SELECT id, name, email FROM users";

$stmt = $conn->prepare($sql);

$stmt->execute();

// Fetch all results

$users = $stmt->fetchAll(PDO::FETCH_ASSOC);

if ($users) {

foreach ($users as $user) {

echo "ID: " . $user["id"] . " - Name: " . $user["name"] . " - Email: " . $user["email"] . "<br>";

}

} else {

echo "0 results";

}

} catch (PDOException $e) {

echo "Error: " . $e->getMessage();

}

// Close connection

$conn = null;

❮ Previous

Next ❯

Whereisstuff is simple learing platform for beginer to advance level to improve there skills in technologies.we will provide all material free of cost.you can write a code in runkit workspace and we provide some extrac features also, you agree to have read and accepted our terms of use, cookie and privacy policy.