Selecting Date from Current_timestamp Field

Array
(
    [0] => Array
        (
            [id] => 1
            [name] => Walter
            [abcd] => 06-07-2015
        )

    [1] => Array
        (
            [id] => 2
            [name] => Ray
            [abcd] => 06-07-2015
        )

    [2] => Array
        (
            [id] => 3
            [name] => Marco
            [abcd] => 06-07-2015
        )

)

Select all Open in new window

<?php // demo/temp_dloj.php
ini_set('display_errors', TRUE);
error_reporting(E_ALL);
echo '<pre>';


// CREATE AN ARRAY OF NAMES TO USE FOR TEST DATA
$test_names_arrays = [['name' => 'Walter'], ['name' => 'Ray'], ['name' => 'Marco']];


// OPEN A CONNECTION TO THE DATA BASE SERVER AND SELECT THE DB
$db_host = "localhost"; // PROBABLY THIS IS OK
$db_name = "??";
$db_user = "??";
$db_word = "??";

$dsn = "mysql:host=$db_host;dbname=$db_name";
try {
    $pdo = new PDO($dsn, $db_user, $db_word);
}
catch(PDOException $exc) {
    var_dump($exc);
    trigger_error($exc->getMessage(), E_USER_ERROR);
}
// SET PDO TO TELL US ABOUT WARNINGS OR TO THROW EXCEPTIONS
$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING );
$pdo->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );


// CREATING A TABLE FOR OUR TEST DATA
$sql
=
"
CREATE TEMPORARY TABLE my_table
( id    INT         NOT NULL AUTO_INCREMENT PRIMARY KEY
, name  VARCHAR(24) NOT NULL DEFAULT ''
, abcd  TIMESTAMP   NOT NULL DEFAULT CURRENT_TIMESTAMP
)
"
;

// RUN QUERY TO CREATE THE TABLE
try {
    $pdos = $pdo->query($sql);
}
catch(PDOException $exc) {
    var_dump($exc);
    trigger_error($exc->getMessage(), E_USER_ERROR);
}


// PREPARE THE QUERY TO LOAD THE NAMES ("PREPARE" ONLY NEEDED ONCE)
$sql = "INSERT INTO my_table ( name ) VALUES ( :name )";
try {
    $pdos = $pdo->prepare($sql);
}
catch(PDOException $exc) {
    var_dump($exc);
}


// LOADING OUR DATA INTO THE TABLE
foreach ($test_names_arrays as $person)
{
    // USE THE ARRAY OF KEYWORD => VALUE TO ATTACH name
    try {
        $pdos->execute($person);
    }
    catch(PDOException $exc) {
        var_dump($exc);
        trigger_error($exc->getMessage(), E_USER_ERROR);
    }
}


// QUERY TO RETRIEVE THE ROWS FROM THE DATABASE TABLE
try {
    $pdos = $pdo->query("SELECT id, name, DATE_FORMAT(abcd,'%m-%d-%Y') AS abcd FROM my_table");
    $rows = $pdos->fetchAll(PDO::FETCH_ASSOC);
    print_r($rows);
}
catch(PDOException $exc) {
    var_dump($exc);
    trigger_error($exc->getMessage(), E_USER_ERROR);
}

Select all Open in new window