ddeveloper supports this item


79 comments found.


xml changed to csv error message on screen: Some error occured in file upload. Please check error. Error code: 0

Is some directory need to be set as write_access? which directory? Looking forward to hearing from you. Thanks

Can you please send message in “awesome-conversion-script” comment or via my profile so I can check. Thanks

hallo there, im rather new in database helper, and i have bought this item, can i use it as base class, so i can create class thas use your class as extends. case*

Class model extends yourclass() { function conect() { } functuin insert_to_tb{


function view_tb() {


functoin edit-tb($id) {

} }

thansk, and forgive me for my noob question

Yes, you can extend class.

can i have some example, or clue how to use them? thanks for advance

You can do this like you inhirate any other class, standard way.

Hi, I have just purchased this and don’t understand how to get it to work. Could you send me some more detailed instructions. Thanks

Hi, please go through the details documentation of script here


Let me know if you have any further doubt. Thanks

Thanks for your reply. The link just provides me with a blank page with some headings at the top; no instructions. I’ve been through the Quick Start guide and don’t understanding where I am supposed to be putting things . Please explain in more detail. Thanks

sorry, I have pasted wrong url, Here is correct one


I’ve looked at all this (most of it does nothing) and still don’t understand what it is trying to do. Please explain in more detail. Thanks

That was documentation of how you can perform database operation without running queries directly. Let me know what exactly you want to do. Thanks


how to use; SELECT * FROM opinions WHERE MATCH AGAINST (‘nice language’)

as query? i need to make a search but like_cols is not working for text

It should be $sdb->like_cols=array(“rdate”=>” $rs4 “, “rating”=>” $rs5 “);

great it works thanks

Just bought, nice class so far, thanks for your work. When running a limit x,y query (with a where clause), I need to also return the total rows for the full query. $sdb->rows_returned of course returns 10. What is your suggestion for the most efficient way to get the total rows? Does it need to be a separate result set e.g. $result1 based on Count(*) and then I parse that in? Any better way?

I think you are writing code for pagination. Yes, it will require running 2 separate queries, one for total and other for limit. Thanks

Exactly. OK, thanks

Any easy way to output the debug output $sdb->query to a text file?

You can easily write on text file using write file php functions.

It appears when including a where clause that $sdb->query shows the positional placeholders (question marks). Is there a way to see exactly what SQL is getting executed?

We have used parameter binding query execution in PDO as it’s most safest way to run queries, Placeholders are used in that and they are replaced by PDO internally. so it’s not possible directly. You can also print values to get ? values.

Did not see an example in the PDO select documentation on the exact syntax to use to engage the BETWEEN clause. However in the class itself there is a comment in line 39 illustrating it as: e.g. $sdb->between_columns=array(“col1”=>val1,”col1”=>val2); – however in my testing this does not work, instead what does work is e.g. $sdb->between_columns=array(“col1”=>val1,val2); – can you confirm?

Thanks. How about the multiple between statements?

Hi, its same way. Just call it multiple times

The multiple BETWEEN calls are not working for me. It is always applying only the last call. I can see this in the $sdb->query as well. Can you test on your end and confirm?

Need help;

When you dbInsert, and if defined value is missing in array script is not inserting db, how to fix it?

Sorry, I am not able to understand your question. If you are not passing value then how insert will work?

How does i code this in simplifiedDB

$db->exec("SET @num := 0; UPDATE hold SET hold_ID = @num := (@num+1);");


You can do like this

$query = “SET @num := 0; UPDATE hold SET hold_ID = @num := (@num+1); ”;



Hi. we have many duplicate records in our database and currently we are using mysql distinct to return unique results. i’m wondering if Simplified DB support The SELECT DISTINCT Statement? thank you

Yes, it supports. Any query can be run using the execute query operation. Thanks

last update Last Update 22 December 13 do you had made any changes and where we can see latest features


Yes, last update was on 22 Dec with most of the features added. If you need only PDO then you can buy my new script.



Hi Just bought the script. I want to show results without while ($rows = $result->fetch_array()) { print_r($row); } code, I tried: $sdb->output_array=true; but i get no results.

my code: <?php


$sdb= new SimplifiedDB();





$result is array. You can loop array elements using foreach or for statement.


Hello again, I just want to get all columns names and with those column names i want to make another query to another table. How can i possibly do this? I tried this but no luck: $columns is an array with column names




select query returns the array. You can get name of all columns directly using array_keys function.

Hello I am trying to use SimplifiedDBMysqli in my class but im a noob on oob concept. Here is what i tried: include("SimplifiedDBMysqli.php"); $sdb = new SimplifiedDB(); $sdb->dbConnect("localhost", "root", "pass", "mydb"); class Source extends SimplifiedDB { public $sdb; public function __construct($sdb) { } } class BlockShow extends Source { function blockshow (){ $rows = $sdb->dbSelect("mytable",array("id","lang"),array("lang"=>"en")); while ($rows = $result->fetch_array()) { print_r($rows); } } } and when i call $BlockShow = new BlockShow(); $BlockShow->blockshow(); it says: PHP Fatal error: Uncaught Error: Call to a member function dbSelect() on null in


You need to read more about oops concept if you want to use it another class. For example, you have created object of simplified db before your class definition so it won’t be available in that class that’s why it is showing fatal error.

Please follow the demo to know more about the class and regarding oops, please read more about extending a class. In case of issue, let me know. Thanks

Olá, como faço para mostrar as strings do banco de dados? Estou conseguindo somente por array.

you can use foreach loop to output content of array as string

Do you have an example?

it’s standard foreach loop..example below foreach($result as $data){ echo $data["col-name"];//replace col-name to actual column name }

Would this class work with postgres PDO?


It will work with some of the postgres basic operation after changing connection string like insert, update but other operation of postgres requires different way of implementation. You can check https://codecanyon.net/item/pdomodel-database-abstraction-and-helper-php-class/15832775 it support most of the postgres functions. Thanks

OK I will do some testing. I assume basic select stuff should work as well? Thanks for the quick reply

Hello! this looks great, I have a pre-sales question. I need to give a front end to my wordpress registered users so they can upload a xls or cvs file into a table in my mysql db. Will I be able to give that capability to my users with this system? thanks!


I have replied to your similar question in other message thread.

how to add pagination to Generate Html Table From Array? if it is 1000 rows of records, without pagination, it is difficult to browser.


Pagination feature is not available in the Simplified DB. You need to add code as per the count of the pages. Thanks