125 comments found.
Hi, how can I use orderByCols with asc and desc. thank you
Example of order by asc
$pdomodel->orderByCols = array(“firstName”);
example of order by desc
$pdomodel->orderByCols = array(“firstName desc”);
thank you
love this script! 
great job!
I have a wordpress multisite network with a lot of sub-sites (> 1000 sub-sites). Is your script capable to modify automatically every user of the database for each of the subsites, please?
Hi,
script is database abstraction helper class so basically it helps in database related operation. You can write queries using it and perform the operation but it doesn’t do anything automatically. Thanks
Thanks, I understand. But I do not know how to do SQL queries, will your plugin help me doing that? And do that easily?
(“Do that”, I mean: to modify every user of the database for each of the subsites in my multisite network).
You need to understand what kind of operation you are going to do in sql to use same in the pdomodel without writing sql, for example, if you are going to perform update sql query “update table_name set user_birth_date=’’ where user_id=’’” then you can do same in pdocrud by passing tablename and user column details in pdocrud.
Thanks
hi! Any way to close connections?
Hi, PHP PDO doesn’t require close connections like mysql. Thanks
thank you! cool!
Hi, I like your script, I have a question, in the PDF Export option how can I do to place the results in different PDF places? it’s possible? To export the pdf can I use the where clause?
i solved, thank you! well, not quite, can I distribute the result of a query in exact PDF sites?
Ok..Thanks
hi!, works mysqli?
Hi,
It works with PDO and support all 4 major database. You need to pass data in array format only. Thanks
hi, works on php 5.6?
Yes, for all version >=5.3 as PDO was intruduced in php version 5.3. Thanks
thank you!
Am I missing something or is dbTansactionStatus meant to be dbTransactionStatus?
Hi,
I am not able to understand what you mean by is dbTansactionStatus meant to be dbTransactionStatus?
please explain.
Please how do I do this using your code:
$sql = “INSERT INTO tbl_loan(loanid,full_name,cifno,appdate,purpose_of_loan,amount_required,collateral_value,tenure,home_verification_done) VALUES ON DUPLICATE KEY UPDATE full_name= VALUES , cifno= VALUES , appdate= VALUES , purpose_of_loan= VALUES , amount_required= VALUES , collateral_value= VALUES , tenure= VALUES , home_verification_done= VALUES ”;
Thanks
That does not answer my question. I want to insert into a table (the link answers that) and ON DUPLICATE KEY UPDATE some column. Please check my question again. Thanks
Hi,
For this, you need to use execute query function. Thanks
I see you just updated this item. What is new?
PDOModel now supports SQL Server along with PGSQL, SQLite and Mysql.
I have updated details also on file description.
Sorry but pagination works but does not work the link to select the different pages, mistake anything?
Hi,
You need to write code to get data as per pagination. Pagination just generates link, rest you need to do. Thanks
OK, you just know, practically throws the numbers, but the javascript that shows the number and the next does not produce any action, what’s the point then?
It’s basically generate the selected page link, required no. of pages links etc. Rest needs to be done as it’s just a database abstraction script. These task needs to be done separately. Thanks
How use SUM ? couple months ago you said you was making a update, still nothing?
Hi,
over last 2 months, I have released many updates with many features. I am still adding some more features, I will add this also. Thanks
here say last update was in May, did you released something last 2 months?
I have replied about the SUM function on your email.
Yesterday, I have uploaded a new version with sql server connection. It will be available once reviewed by the codecanyon team.
Thanks
can we used in MSSQL Database & vb.net
Hi,
1. Current version doesn’t support MSSQL, we are working on next version that will have MSSQL support. 2. It is php based script so can’t be run using vb.net. You can create rest api to pass data using this.
Thanks
Hi, I have a software property management system develop in cake php, I want my admin panel have backup section and when I click on that it will export database into mysql, cakephp version is I think 2014, can this do that ? Will it export all database or can be a specific table. Thanks.
Plus will it automatically store in google drive ?
Thanks
Hi,
No, script doesn’t do this. It basically provide database abstraction so you don’t have to write queries. Thanks
Thankyou for super quick response.. Any idea where can I get mentioned script ?
Sorry, I don’t have idea about that. Thanks
Thankyou
Pre Purchase Questions. I am wanting to use this specifically for Export as a PDF. Will the export to PDF option automatically run or would end user need to run it?
I need to name the PDF from a fields in database. Is there a way to modify the $fileName so it outputs like below example.
firstname = John lastname = Smith
john_smith.pdf
Thank You
Hi
Not possible with this script. Thanks
Hi ddeveloper,
is there a way for select distinct. I would like to exclude duplicate results. How does this work with the pagination in a query? Please specify a sample code. Thanks! This is a nice PHP class.
Hi,
For that you need to use execute query function. Please make sure to set $this->backticks = ”” ; (Empty) before using any sql function like select, count etc.
Regarding pagination, you can pass total records generated and current page to generate the pagination code.
Thanks
Hi, I have replied to your same message in other thread. Please check. Thanks
Here’s my question again in the right profile:
I’m trying to loop through the results with :
while($rs = mysql_fetch_assoc($result))
But I’m getting: Warning: mysql_fetch_array() expects parameter 1 to be resource
It’s returning 2 when I use the $pdomodel->totalRows but for some reason I can’t loop the result.
Can you help me?
Hi,
The result return is array not mysql result object. It works with PDO and returns data as array format.and you can read array data as any array you read in PHP.
foreach($result as $row){ $user_name = $row[“user_name”];//to get it in variable echo $user_name;//echo variable }
Thanks
Hmmm ok, I got it! Thanks
I’m trying to loop through the results with :
while($rs = mysql_fetch_assoc($result))
But I’m getting: Warning: mysql_fetch_array() expects parameter 1 to be resource
It’s returning 2 when I use the $pdomodel->totalRows but for some reason I can’t loop the result.
Can you help me?
Hi, it is not showing purchased with your profile. You need to provide purchase code before I can provide support.
Look a this
//$row['Todo_Id'] returns 1,2,3
// works just fine
$res = $pdomodel->executeQuery("select * from users where id IN (".$row['Todo_Id'].")");
// dont work
$pdomodel->where('id',array($row['Todo_Id']),'IN');
$res = $pdomodel->select("users");
$pdomodel->where('id',$row['Todo_Id'],'IN');
$res = $pdomodel->select("users");
I have no idea what is wrong
Hi,
As you mentioned
//$row['Todo_Id'] returns 1,2,3
it is not array, it became one single element “1,2,3” so correct code
$data = explode(",". $row['Todo_Id']);
$pdomodel->where('id',$data,'IN');
Thanks
