Re: possible variable declaration error

On Fri, Mar 25, 2011 at 8:23 AM, <james@nixsecurity.org> wrote: > Correct me if I wrong, but you're declaring $id AFTER binding the SQL > parameter, therefore your :id isn't being bound to anything, hence the empty > returned array. > > I think: > $d_series_fetch = $db->prepare("SELECT * FROM defaultseries WHERE publisher > >> :id"); > $id = 'DC Comics'; > $d_series_fetch->bindParam(':id',$id); > > *should* work. > > No that doesn't work either, I have a few INSERT statements using prepared statements like so $defaultseries = 'Batman'; //declare the php variable $publisher = 'DC Comics'; //declare the php variable $d_series->execute(); //execute the prepared statement and they work just fine. Not entirely sure yet why, I am just starting to really get into PDO's. >---- Original Message ---- > >From: matty jones <urlugal@gmail.com> > >To: php-general@lists.php.net > >Sent: Fri, Mar 25, 2011, 8:19 AM > >Subject: [PHP] possible variable declaration error > > > >I get the following error " PHP Notice: Undefined index: publisher in > >/var/www/testfunctions.php on line 65" and I have narrowed it down to what > I > >*think* is a variable not being declared. Here is the code. > > > > > >//this will fetch the data from a table > >$d_series_fetch = $db->prepare("SELECT * FROM defaultseries WHERE > publisher > >= :id"); > >$d_series_fetch ->bindParam(':id', $id); > >$id = 'DC Comics'; > > > > > >if ($d_series_fetch ->execute(array($_GET['publisher']))) { > >while ($row = $d_series_fetch -> fetch()) { > >print_r($row); > >} > >} > > > >I have prepared statements to open a connection and insert data and they > >work fine if I comment the preceding block out so I am fairly certain the > >problem is in there somewhere. I am using the latest version of PHP and > am > >running Postgres8.4 as my db. If I use the isset() function and add an > echo > >(code below) I get no errors but the query still doesn't work so again I > am > >fairly certain that I am forgetting to declare something somewhere. > > > >//this will fetch the data from a table > >$d_series_fetch = $db->prepare("SELECT * FROM defaultseries WHERE > publisher > >= :id"); > >$d_series_fetch ->bindParam(':id', $id); > >$id = 'DC Comics'; > > > >$publisher = ''; > > > >if (isset($_GET['publisher'])) > >{ > > > >if ($d_series_fetch ->execute(array($_GET['publisher']))) { > >while ($row = $d_series_fetch -> fetch()) { > >print_r($row); > > > >} > >} > >} > > > >else {echo"this didn't work";} > > > >$dbh = null; //close the database connection by setting the PDO object to > >NULL > > } > > > >I am fairly new to PHP and have very little idea on PDO's so this is most > >likely a simple error(s) I know. > >Thank > > > >Matt > >