EazSQL - PHP MySQL Helper

$res = $instance->get_rows("SELECT * FROM yourtable ORDER BY id ASC");
// or
$res = $instance->get_rows("SELECT * FROM yourtable AS tabl JOIN example AS ex ON ex.cc = tabl.cc2 WHERE ...");
// Now, show all
foreach($res as $r) { echo $r->example; }

$res = $instance->get_rows("SELECT * FROM yourtable LIMIT 2");

$res = $instance->pagin_query("SELECT * FROM youtable", 0, 2);

Hello. I think you are a little confused of what this helper does. For this time, it doesn’t has any design pattern, this is only designed for making code in a easy way. You can see the Screenshot where is the list of what you can do with this. Probably, in a future, I will do an update with MVC controller.

Escaping works in the classic way, adding slash (\) before any ’ or ” character, preventing Mysql Injection.

Thank you for being interested and thank you for your comment

• In ezSQL, debug only returns the last action, my helper can display the total ones
  
• You can select another database when you want
  
• In ezSQL, the delete, insert and update are made with the same query function, but my helper has a function for each one ($instance->delete(), $instance->insert(), $instance->update())
  
• My helper saves all the class-internal fails into a public var ($instance->errors)
  
• If you use multi-query with 2+ Selects, the function will return a nice ordered array with both results.
  Array(
  [0] = Object (first_results),
  [1] = Object (second_results)
  )
  
• My helper has better explained documentation
  
  And a lot of more feautres. Hope you buy this item.
  
  Thank you

Thank you for buying the item and thank you for your suggestion. All right, I will add demo of each code. I have in mind some updates, so I will do some corrections and include that. If you have any other suggestions, bugs, or you want something to be added, would be very nice.

Thank you again
Btw, if you liked the helper, please rate

Thank you for buying and evaluating. I’m happy you liked it.

Hello. Actually this item doesn’t supports that option, but I will consider to do an update including it, is a good idea.

Thank you for the suggestion

You are welcome

You can read the difference in the reply of the comment created by @NetReview

This is not exactly a class, this is a Helper. Allows to do queries with a easy syntax (as PHP ) and other things, like doing multi-queries. You can buy test it, but is not created to optimize queries (fast execution), just the syntax.

By the way, the most common classes doesn’t has ability to run queries in fast execution time. Why? Every one needs to assign private vars, call methods, and all this consumps so many time. In time, nothing is better than doing native queries

Good luck, thank you

No, as the own item name says, it only works with MySQL. Thank you.

Well. This is a class helping the user to write MySQL processes requiring long lines of code at least lines. Before buying this item, you may want to learn MySQL basics first. Thank you for being interested.

Hello. No, as the name says, it only uses MySQL. Thank you.

Sure, just let me a few more days to make the implementation. I am a little busy at this moment.

However, if you need the change at this moment, just buy the class, tell me via message and I’ll send you the modification.

Thank you.

Hello.
Sorry but that is impossible.
Anyway, if you want me to write a function for you to get the last ID, just contact me to the email provided in the Documentation.

Thank you.

UP!

Didn’t you receive my email?

Mick

Hello. You don’t need to spam my email or the script page. If I don’t send a response, is because I didn’t read the email because I am busy. Just wait until I get available.

Thank you.

Hello. Sorry but that is impossible. Anyway, if you want me to write a function for you to get the last ID, just contact me to the email provided in the Documentation.

Thank you.