what is better

Talguy

I have been hearing about database objects and found some information about two mysqli and pdo. I was just wondering which one is better too use.

laserlight

You will find PDO somewhat more flexible.

Talguy

OK so I have gotten PDO to work in my feed creator script and I have noticed that there is a performance increase. It took me a while to get it to work a lot of referencing of php.net, but from all that referencing I came across a line of code that confused me and had no explaination all of you OO gurus out there could tell me why I had to do this bc I have no clue since I am extremly new to OO progaming.

Why do I have to do this?

  // only select the columns you need, thus reducing the work the DBMS has to do
  $sql = "SELECT title_art, description_art, date_art, idtop_art FROM blg_article_art";
  $results = $db->prepare($sql);
  $results->execute();

  //print some stuff...

  while ($row = $results->fetch(PDO::FETCH_ASSOC)) 
  {
     //print some more stuff...
  }

and can't do this

  // only select the columns you need, thus reducing the work the DBMS has to do
  $sql = "SELECT title_art, description_art, date_art, idtop_art FROM blg_article_art";
  $db->prepare($sql);
  $db->execute();

  //print some stuff..

  while ($row = $db->fetch(PDO::FETCH_ASSOC)) 
  {
     //print some more stuff...
  }

laserlight

prepare() returns a PDOStatement. It is this statement that you want to execute and fetch the result set from.

The PHP Manual has more to say on the PDO Functions.

Talguy

thats not what I was asking. What I was asking is Why can I do this
$results = $db->prepare($sql);
$results->execute();

and not this
$db->prepare($sql);
$db->execute();

laserlight

What I wrote is indeed the answer. You cannot do the latter because you cannot use prepare() and execute() on the database connection object. You use them on the SQL statement object, since you prepare the statements and execute them.

Talguy

ok I understand now thanks man

since I am already asking about pdo does anybody know is there is a pdo equivalent to mysql_insert_id