Inserting Data in PostgreSQL

Question

I have a PostgreSQL query to insert data into my table but for some reason, It's not inserting the data into the table

When I var_dump the execute statement if returning false.

foreach($information as $data){
     $name = $data['name'];
     $id = $data['id'];
    $time = $data['time'];

    $query =  "INSERT INTO students(name,id,time)"
               ."VALUES('$name','$id','time')";
                  //prepare and execute
               $stmt = $psql->prepare($query);
               $result = $stmt->execute();

               var_dump($result);


}

Dhiraj · Accepted Answer · 2018-03-08 16:59:48Z

2

Most probably '$name' is not being understood in the query. Also, you should check for the existence of those variables

Try doing something like this

   if (isset($name, $id, $time)) {
    $query = 
    'DO$$
    BEGIN
        IF NOT EXISTS(select 1 from students where name = \'$name\')
            THEN
            INSERT INTO student("name", "id", "time")
            VALUES (\'$name\', \'$id\', \'$time\')
        END IF;
    END;
    $$;'
}

edited Mar 8, 2018 at 16:59

answered Mar 8, 2018 at 16:53

Dhiraj

2,7672 gold badges13 silver badges36 bronze badges

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

2 Comments

sam scoot1900 Over a year ago

After writing you above mention code how would I execute it?

Dhiraj Over a year ago

Just put it inside a variable $query see my updated answer

Collectives™ on Stack Overflow

Inserting Data in PostgreSQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related