Return to Snippet

Revision: 68853
at March 6, 2015 02:32 by snstro

Initial Code
/* Connection string */
$db = new PDO('mysql:host=localhost;dbname=YOUR_DB_NAME', 'root', 'YOUR_DB_PASSWORD', array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8"));

$stmt = $db->prepare('select * from your_table');

// Get all records
$result = $stmt->fetchAll();

echo '<pre>';
print_r($result); // Show a data array with results

Initial URL

Initial Description
This is the basic code that you need to know to connect and list data with PDO.
Don't use de old method (mysql_connect and mysqli_connect) to connect and interact with databases.

Initial Title
Simple PDO Connection and select

Initial Tags
mysql, php, data, list

Initial Language