ddeveloper

ddeveloper supports this item

Supported

50 comments found.

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! Any way to close connections?

Hi, PHP PDO doesn’t require close connections like mysql. Thanks

thank you! cool!

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

love this script! :) great job!

MWNS

MWNS Purchased

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”);

MWNS

MWNS Purchased

thank you

MWNS

MWNS Purchased

Hi, as for sql injections, do you have that controlled in your script?

we are using PDO with proper data binding so it’s safe from sql injection. Thanks

MWNS

MWNS Purchased

Thank you

Hi, Every file from demo folder that I access gives me this error: Fatal error: Uncaught Error: Call to a member function prepare() on null in D:\EasyPHP\eds-www\PDOModel\script\PDOModel.php:446 Stack trace: #0 D:\EasyPHP\eds-www\PDOModel\demo\html-export.php(19): PDOModel->select(‘emp’) #1 {main} thrown in D:\EasyPHP\eds-www\PDOModel\script\PDOModel.php on line 446 and I see that all errors are related to this code: $stmt = $this->dbObj->prepare($this->sql);

Am I doing something wrong?

I am using Nginx 1.12.0 PHP 7.1.3×86 or PHP 5.6.30×86 MySQL 5.7.17×86

Hi,

It is giving error that suggest that object is not created. Please check whether it is able to connect to database or not. Make sure all credentials are correct. In case of still issue, give me FTP and db access via email, I will check. Thanks

I have used this code here https://pastebin.com/2c6iffAP to test the connection to db (here is a screenshot with the results http://prntscr.com/ewt02c). If I use mysqli to connect to db it works but not with pdo. Now I’m wondering, knowing that in both cases I didn`t use a pass to connect to db, can pdo connect to a db with no pass?

Hey there,

How can i check if there is already a row with a specefic name? Sort of Count()...?

Greets, Cherimo

Hi,

I am not able to understand your question. Please explain. Just to let you know for complex queries use executeQuery function.

Thanks

Heyy,

For an example, this how i check if a row exist.

$dbPDO->where(“name”,$_POST[‘form_name’]); $dbPDO->where(“id”,$getID,’!=’); $result = $dbPDO->select(“forms”);

if(count($result)...

Is there an easier way?

Hi,

You are doing that correctly. No shortcut method available for that. Thanks

does the table generated has pagination?

Hi,

It is basically query helper so it doesn’t have many function related to table and pagination. I think you should check this one

https://codecanyon.net/item/pdocrud-advanced-php-crud-application-database-management-system/17674879

Thanks

Hi, I’ve already asked you something similar, but I want to confirm, to prevent sql injection is it enough to apply the way you use your script in the examples you have? Or should I do something else? thank you

by
by
by
by
by
by