Re: problem with serial - Mailing list pgsql-general

From Yvon Thoraval
Subject Re: problem with serial
Date
Msg-id CAG6bkBxtb32oYJcQ6f+Ztm5dox8kBC2w8OQjnYypQY=6Em6OxQ@mail.gmail.com
Whole thread Raw
In response to Re: problem with serial  (Raymond O'Donnell <rod@iol.ie>)
Responses Re: problem with serial  (Raymond O'Donnell <rod@iol.ie>)
List pgsql-general


2012/4/19 Raymond O'Donnell <rod@iol.ie>
Or better still - and easier - use parametrised queries.


Right it is easier something like :
$sql = "categories (idx, ctime, mtime, name) VALUES ( :idx, :ctime, :mtime, :name);";
$prep = $db->prepare($sql);
$prep->execute( array(':idx' => $_GET['idx'], ':ctime' => $ctime, ':mtime' => $mtime, ':name' => $name));

no more need to $db->quote()  in that case, as :
$name = $db->quote($name);
???
I mean, even if $name = "L'envers" ? (ie. with a ' in it ?)
--
Yvon


pgsql-general by date:

Previous
From: Raymond O'Donnell
Date:
Subject: Re: problem with serial
Next
From: Raymond O'Donnell
Date:
Subject: Re: problem with serial