I cannot insert a data with Postgres and PHP

Question

I'm developing a software with PHP and Postgres. So, I have a problem with insert code:

function create(){
    $query = "INSERT INTO " . $this->table_name . " VALUES (" . $this->pess_nome . ")";
            
    $result = pg_query($this->conn, $query);
    
    if($result){
        return true;
    }else{
        return false;
    }
}

The error message :

Warning: pg_query(): Query failed: ERROR: column "test" does not exist LINE 1: INSERT INTO pessoa VALUES (test) ^ in C:\xampp\htdocs\Projeto_GPass\objects\pessoa.php on line 26

JazZ · Accepted Answer · 2016-11-08 17:59:13Z

3

String values in SQL queries need to be enclosed in apostrophes or quotes. Modify the second line of your code to read:

$query = "INSERT INTO " . $this->table_name . " VALUES ('" . $this->pess_nome . "')";

EDIT: When you use a string value in a query and do not enclose it in quotes ("test") or apostrophes ('test'), PostgreSQL takes it as a name of the column, hence the error message.

edited Nov 8, 2016 at 17:59

JazZ

4,5792 gold badges24 silver badges43 bronze badges

answered Nov 8, 2016 at 17:51

Jirka Hrazdil

4,0211 gold badge16 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

I cannot insert a data with Postgres and PHP

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related