Using PHP and SQLite

Posted by Barry Shittpeas on Stack Overflow See other posts from Stack Overflow or by Barry Shittpeas
Published on 2010-05-11T02:39:18Z Indexed on 2010/05/11 2:44 UTC
Read the original article Hit count: 356

Filed under:
|
|

I am going to use a small SQLite database to store some data that my application will use.

I cant however get the syntax for inserting data into the DB using PHP to correctly work, below is the code that i am trying to run:

<?php
    $day = $_POST["form_Day"];
    $hour = $_POST["form_Hour"];
    $minute = $_POST["form_Minute"];
    $type = $_POST["form_Type"];
    $lane = $_POST["form_Lane"];

    try
    {
        $db = new PDO('sqlite:EVENTS.sqlite');
        $db->exec("INSERT INTO events (Day, Hour, Minute, Type, Lane) VALUES ($day, $hour, $minute, $type, $lane);");
        $db = NULL;
    }
    catch(PDOException $e)
    {
        print 'Exception : '.$e->getMessage();
    }
?>

I have successfully created a SQLite database file using some code that i wrote but i just cant seem to insert data into the database.

© Stack Overflow or respective owner

Related posts about php

Related posts about pdo