php-link-pdo.php

<?php
$database = "wp_costamarweb";
try {
    $pdo = new PDO("mysql:host=10.0.2.2;port=3306;dbname=$database", 'root', 'root');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);


    $stmt = $pdo->prepare("SELECT * FROM ");
    $stmt->execute();
    
    // set the resulting array to associative
    $stmt->setFetchMode(PDO::FETCH_ASSOC);

    echo "<pre>",__FILE__." on line ".__LINE__,": "; print_r($stmt->fetchAll()); echo "</pre>"; 


    


} catch(PDOException $err) {
    die($err->getMessage());
}

$pdo = null;