Advertisement
Google Ad Slot: content-top
MySQL Select Data
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)
0) {
// Output data of each row
while ($row = mysqli_fetch_assoc($result)) {
echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "
"; } } else { echo "0 results"; } // Close connection mysqli_close($conn); ?>
"; } } else { echo "0 results"; } // Close connection mysqli_close($conn); ?>
Example (MySQLi Object-oriented)
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"] . "
"; } } else { echo "0 results"; } // Close connection $conn->close(); ?>
"; } } else { echo "0 results"; } // Close connection $conn->close(); ?>
Example (PDO)
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"] . "
"; } } else { echo "0 results"; } } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } // Close connection $conn = null; ?>
"; } } else { echo "0 results"; } } catch (PDOException $e) { echo "Error: " . $e->getMessage(); } // Close connection $conn = null; ?>