tony on Date isn't inserted in the database

Mon, 13 Jun 2011 23:15:32 +0300

Hello,

For a PHP wrapper, please post your questions here:

http://www.trirand.net/forum/

Regards

Ahmed on Date isn't inserted in the database

Mon, 13 Jun 2011 21:01:21 +0300

Nevermind, problem fixed.

I had to enter the date in the user date format

"date_added"=>date('m/d/Y')

Ahmed on Date isn't inserted in the database

Mon, 13 Jun 2011 19:41:33 +0300

Greetings Folks,

I have an issue with the insertion of a date field in the database, here is my grid.php

<?php

/**
* @author Ahmed Ossama
* @copyright 2011
*/

session_start();

// require_once 'jq-config.php';
define('DB_DSN','mysql:host=localhost;dbname=videos');
define('DB_USER', 'ahmed');
define('DB_PASSWORD', 'P4ssW0rd');

define('ABSPATH', dirname(__FILE__).'/');

// include the jqGrid Class
require_once ABSPATH."php/jqGrid.php";

// include the driver class
require_once ABSPATH."php/jqGridPdo.php";

// Connection to the server
$conn = new PDO(DB_DSN, DB_USER, DB_PASSWORD);

// Tell the db that we use utf-8
$conn->query("SET NAMES utf8");

// Create the jqGrid instance
$grid = new jqGridEdit($conn);

// enable debugging
// $grid->debug = true;

// Write the SQL Query
$grid->SelectCommand = 'SELECT * FROM videos WHERE owner_id = ?';

// set the user date format to m/d/Y
$grid->setUserDate('m/d/Y');

// tell the grid which field is date
$grid->datearray = array('date_added');

// Set the table to where you update the data
$grid->table = 'videos';
$grid->setPrimaryKeyId('id');

// Set output format to json
$grid->dataType = 'json';
$user_id = $_SESSION['user_id'];
$data = $_POST;

switch ($_POST['oper']) {
case "add":
    $data = array(
      "uniq_id"=>substr(md5(rand(99999, 9999999999)), 1, 9),
      "caption"=>$_POST['caption'],
      "video_link"=>$_POST['video_link'],
      "owner_id"=>$user_id,
      "date_added"=>date('Y-m-d')
    );
    $grid->insert($data);
    break;
case "edit":
    $grid->editGrid();
    break;
case "del":
    $grid->delete($data);
    break;
default:
    $grid->queryGrid(null, array($user_id));
    break;
}

?>

and here is my grid js

and here is my debugging log (jqGrid.log):

Executed 2 query(s) - 2011-06-12 10:39:50
Array
(
    [0] => Array
        (
            [time] => 2011-06-12 10:39:50
            [query] => SELECT * FROM videos WHERE 1=2
            [data] =>
            [types] =>
            [fields] =>
            [primary] =>
            [input] =>
        )

    [1] => Array
        (
            [time] => 2011-06-12 10:39:50
            [query] => INSERT INTO videos (uniq_id, caption, video_link, owner_id, date_added) VALUES( ?, ?, ?, ?, ?)
            [data] => Array
                (
                    [0] => b99967390
                    [1] => bhmfgtthft
                    [2] => hfchgfhfghfgh
                    [3] => 1
                    [4] => 1970-01-01
                )

            [types] => Array
                (
                    [0] => string
                    [1] => string
                    [2] => blob
                    [3] => int
                    [4] => date
                )

            [fields] => Array
                (
                    [id] => Array
                        (
                            [type] => int
                        )

                    [uniq_id] => Array
                        (
                            [type] => string
                        )

                    => Array
                        (
                            [type] => string
                        )

                    [video_link] => Array
                        (
                            [type] => blob
                        )

                    [owner_id] => Array
                        (
                            [type] => int
                        )

                    [date_added] => Array
                        (
                            [type] => date
                        )

)

            [primary] => id
            [input] => Array
                (
                    [uniq_id] => b99967390
                    => bhmfgtthft
                    [video_link] => hfchgfhfghfgh
                    [owner_id] => 1
                    [date_added] => 2011-04-04
                )
        )
)

The problem is that the date goes into the database 1970-01-01, I have tried even setting the date with a default value in the grid.php array, but still the date is entered 1970-01-01.

Any help is very much appreciated.

Thanks in advance

jQuery Grid Plugin - jqGrid - Topic: Date isn't inserted in the database

tony on Date isn't inserted in the database

Ahmed on Date isn't inserted in the database

Ahmed on Date isn't inserted in the database