Converting code to use Prestashop classes?

[MrBaseball34]

I’m writing a new class for Prestashop.

I have some simple db access code in my current that looks like this:

Class Database {

 function query($query){
   $result = mysql_query($query);
   if($this->debug_mode)
   {
     echo mysql_error();
   }
   return $result;
 }

}

And using it in my code:

$db = new Database;
$sql = 'SELECT * FROM TABLE'
$result = $db->query($sql);
if($result) {
 while($row = mysql_fetch_row($result))
   // iterate and do something with row data
 }
}

How would I convert this to Prestashop “speak” using the Db class?
There is not going to be a template used here, only class code. This class
is to generate PDF files from database data so I do not need any presentation.
I already have everything, I just wanted to use PS classes to do it all.

[rocky]

Why aren't you using code like the following?

$result = Db::getInstance()->ExecuteS('SELECT * FROM TABLE');
foreach ($result as $row)
{
   // Do something with row data
}

[MrBaseball34]

That is what I was asking, how to change what I had to PS code.

[rocky]

I see. I thought you were unhappy with the way PrestaShop was doing queries and trying to write alternative code. Is this issue resolved now?

[MrBaseball34]

Not yet, I haven't tested it.
What is the difference between Execute and ExecuteS and s
Is there a function for running INSERT, UPDATE, DELETE and the like where no result
is returned?

[rocky]

Execute returns the resulting object from the query and ExecuteS returns an array of all the rows from the query. Use Execute for INSERT, UPDATE and DELETE queries and ExecuteS for SELECT queries.

[MrBaseball34]

In an instance where I do this:

$result = Db::getInstance()->Execute('INSERT INTO table VALUES (...)')

How would I obtain the mysql_insert_id?

[MrBaseball34]

Found it:

Db::getInstance()->Insert_ID()