PHP And MySQL : PHP ( PDO ) Using Foreach Loop Fetch All Data From MySQL Database

database How To Fetch All Data From MySQL Database Table In Php Using PDO mysql pdo php php freach loop php pdo php pdo foreach loop Using Foreach Loop Fetch All Data From MySQL Database

PHP PDO Tutorial: Display MySQL Database Records Using PDO In PHP

_______________________________________________________

In this Php Tutorial we will see How To Fetch All  Data From MySQL Database Table
 In Php Using PDO  .
I Use In This Tutorial:
- NetBeans IDE .
- XAMPP .
- PhpMyAdmin .
-MySQL Database .


*INFO : Learn Php And Buid Cms Project Course 


 

Php Source Code:

<!--Using Php Foreach Loop With MySQL Databse-->

<?php

$dsn = 'mysql:hosy=localhost;dbname=test_db';

$username = 'root';

$password = '';

try{

    // connect to mysql

    $con = new PDO($dsn,$username,$password);

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

} catch (Exception $ex) {

    echo 'Not Connected '.$ex->getMessage();

}

// mysql select query

$stmt = $con->prepare('SELECT * FROM users');

$stmt->execute();

$users = $stmt->fetchAll();

foreach ($users as $user)

{

    echo $user['id'].' - '.$user['fname'].' - '.$user['lname'].' - '.$user['age'].'<br>';

}

?>

Bagikan

Jangan lewatkan

PHP And MySQL : PHP ( PDO ) Using Foreach Loop Fetch All Data From MySQL Database

4/ 5

Oleh insurance

insurance 06.13 Komentar