Hi there,

i bought your tool today.

First i followed your “config-instructions”...

From this point on:

That’s all !!!! Only these settings are required to start your project. Apart from these required settings, there are various settings to ease out various operations of PDO CRUD. You can find all these settings here

Now you can create any php file and include the following file.

require_once “script/pdocrud.php”; Please note that if script folder is at different location then you need to provide path till script folder, For example require_once “abc/script/pdocrud.php”;

You can create an object of PDOCrud class and start calling functions to do required work. For example,

$pdocrud = new PDOCrud(); echo $pdocrud->dbTable(“table_name”)->render();

— i created a new php file including your code snippets.. but when i navigate / call the php .. i got a blank page..

Can you tell me what i`m doing wrong?

Best wishes…

Hi, when will the new version be released?

Can i connect this to a microsoft SQL Database Server?

hi, multi upload option ?

we having issue withdeprecated function strtoupper at every demo page

I am using PHP version 8.1

what should I do to remove that, I also notice that at each page CSS not applying on tables and data

hello

how can I make the code return array not html ??

thanks

Hi,

Regarding the csv or excel bulk import function, do you have to first upload the file to the upload folder or can that be part of the task? and can duplication validation be part of the import process? Sure all of that is possible but it’s just knowing how

Thanks in advance.

error funcrion multiTableRelation(“ip”, “ip”, $pSection);

SQLSTATE⁴²⁰⁰⁰: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near

Hi ddeveloper,

I have used your library last period. I think, very useful, but containing many bugs.

I have solved a lot of bugs by myself and added some functionality. Since the support is very limited in my opinion, it would be desirable if this project would just be open source on github so that we as users can help you and each other and improve the library.

Can you give me your opinion about this?

regards, Hugo

if i need it like json not html to used it for api how i can do it ?? thanks

Hello ddeveloper

I purchased PDOCRUD and love it! Thank you for a great program Have a couple of questions… 1) Is there any way to export the data on a filtered display list so I can use it on another (PHP) page?

2) How can I add a Clear search / filter button?

3) when using Tags can one enable linking to see all records with that tag? ( ie: animals)

4) for some reason PDF Export does not work - am I missing something? - works on the demo. pages on my site…

THANK YOU again for a great tool!!!

Jorge

Hi tried for a day or two in development environment, but not used it.

Now I installed in https://xxxxx.rcom.cccc/demo/pages/ – But script is not working – The left menu links – they return blank 404 error pages .What should I do to make them work

@dhuerta: thx for your quick response and YES i want to show or edit the numeric value in edit fields. In the grid i followed your suggestion, and it works perfect. If you like, we can send feedbacks by e-Mail (olaf@mannack.de).Thx.

@omanaco do you want to show the numeric value in the edit field?

@dhuerta29: Do you have experiences with number_format in pdocrud edit-form? I need currency-value (e.g. 1.234,56 EUR) format in numeric fields in an edit-formular. In the view grid formulars i use callback function “formatTableData”. Any idea? Thx.

For all those who want to learn how to use pdocrud, I know all its secrets and I guarantee that everything can be done.

how I can show in a column of the grid one calculated value? I have the field ‘year_birth’ and I want to show not the date, I want to show how old are (years).

year_birth -> is the data field 2022 – year_of_birth -> this must show in grid

Thanks in advance,

I use date fields with this format: dd/mm/yy and I change in config file, but if I generate a data table don’t work or if I edit one date field, don’t show well. How I can do?

If I click on one file of data, down open all the fields for view or edit, but if I close this, open a new data table and in the page I see two data tables. How I can solve this error?

I tried adding where clause in your update function in pdomodel, still where clause is not working when doing trigger operation. can you clarify whats the issue ??? Your function did not have wheredate i added it.

public function update($dbTableName, $updateData, $whereData) {

try {
        if ($this->dbTransaction && $this->dbRollBack  true)
            return;
}

if ($this->dbTransaction && $this->dbTansactionStatus  0) {
        $this->dbObj->beginTransaction();
        $this->dbTansactionStatus = 1;
    }
    $this->sql = $this->getUpdateQuery($dbTableName, $updateData, $whereData);
    $stmt = $this->dbObj->prepare($this->sql);
    $stmt->execute($this->values);
    $this->rowsChanged = $stmt->rowCount();
    $this->resetAll();
} catch (PDOException $e) {
    if ($this->dbTransaction == true) {
        $this->dbRollBack = true;
        $this->dbObj->rollBack();
    }
    $this->setErrors($e->getMessage());
}