PostgreSQL insert not working

Question

I'm trying to set up a simple database with Heroku/PGSQL. So far I've made a connection and created the table I want, but whenever I try and insert data to the table nothing happens.

For testing purposes, I'm using the code

$dbconn = pg_connect(pg_connection_string());
if (!$dbconn) {
   echo "Database connection error. ";
}
else {
// Create table
    $create="CREATE TABLE IF NOT EXISTS users (
        id INT PRIMARY KEY NOT NULL, 
        gender CHAR(30), 
        age INT, 
        location CHAR(30), 
        timestamp CHAR(30)
        )";

// Execute query
    if (pg_query($dbconn,$create))  {
        echo "Table users created successfully. ";
    }
    else  {
        echo "Error creating table. ";
    }
}

function insert() {
    $dbconn = pg_connect(pg_connection_string());
    if (!$dbconn) {
        echo "Database connection error 2. ";
    }
    else {
        # Insert query
        $insert = "INSERT INTO users (id, gender, age, location, timestamp) VALUE (1234, 'male', 99, 'UK', '31/05/2013')";
        # Execute query
        if (pg_query($dbconn,$insert)) {
            echo "Data entered successfully. ";
        }
        else {
            echo "Data entry unsuccessful. ";
        }
    }

}

When run, it returns "Table users created successfully." However, when I call the $$insert$$ function (I will later use this to insert different values into the table) it always returns unsuccessful.

What am I doing wrong?

steven · Accepted Answer · 2013-05-30 20:02:34Z

3

$insert = "INSERT INTO users (id, gender, age, location, timestamp)
VALUES (1234, 'male', 99, 'UK', '31/05/2013')";

maybe you shouldn't use char for timestamp

answered May 30, 2013 at 20:02

steven

4,8952 gold badges31 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

steven Over a year ago

that was just an advice, the main error was VALUES like i posted

eternay Over a year ago

+1 It wasn't clear in your answer, but you saw and solved the mistake.

Benjamin King Over a year ago

Thank you steven and eternay, you've no idea how silly I feel for missing that. I trawled other threads for examples and simply couldn't see it! Thanks again

eternay · Accepted Answer · 2013-05-30 20:02:44Z

3

In the insert statement, VALUE should be VALUES.

Anyway, you should try to recover the error message given by database. I think it's possible in PHP. You'll have much more information about the reason of your error.

answered May 30, 2013 at 20:02

eternay

3,8142 gold badges32 silver badges28 bronze badges

Collectives™ on Stack Overflow

PostgreSQL insert not working

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related