Group items tagged

Filter: All | Bookmarks | Topics Simple Middle

shared by sloansteddi on 02 Mar 09 - Cached

- sloansteddi on 02 Mar 09
  
  Prepare takes the $sql (with '?'s where data will go), along with the TYPES (array) of data to prepare the sql for, and a 3rd paramater for manipulating or result-getting (see next paragraph). It assigns this to $prepared_statement. Another array is created with the data (in the same order as the types, of course), and the RESULT is aquired by running the execute() method on the $prepared_statement object, passing the execute method the "$data" array to fill in the '?'s After this do everything as normal.
  
  <div class="cArrow"> </div><div class="cContentInner">Prepare takes the $sql (with '?'s where data will go), along with the TYPES (array) of data to prepare the sql for, and a 3rd paramater for manipulating or result-getting (see next paragraph). It assigns this to $prepared_statement. Another array is created with the data (in the same order as the types, of course), and the RESULT is aquired by running the execute() method on the $prepared_statement object, passing the execute method the "$data" array to fill in the '?'s After this do everything as normal.</div>
  
  ...
  
  Cancel
...

Cancel
column = ?
...

Cancel
id = ?
...

Cancel
...1 more annotation...
I have a feeling that MDB2 lower cases all field names - so you'll probably need : echo $row['name'] A good idea would be to print_r($row) or similar, to see what's in it
...

Cancel

shared by sloansteddi on 22 Mar 09 - Cached

shared by sloansteddi on 20 Mar 09 - Cached

 array('integer'), array('text', 'text')
- sloansteddi on 20 Mar 09
  
  Make sure to pass TWO types arrays when selecting data with a where clause: prepare($sql, $typesIN, $typesOUT) inserting just takes one...
  
  <div class="cArrow"> </div><div class="cContentInner">Make sure to pass TWO types arrays when selecting data with a where clause: prepare($sql, $typesIN, $typesOUT) inserting just takes one...</div>
  
  ...
  
  Cancel
...

Cancel
$sth = $mdb2->prepare('INSERT INTO numbers (number) VALUES (?)', array('integer'), MDB2_PREPARE_MANIP); $sth->execute(1); $sth->execute(8);
...

Cancel

1 - 3 of 3

Showing 20▼ items per page