Code

Discussion on PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Discussion on PDO Crud – Advanced PHP CRUD application (Form Builder & Database Management)

Cart 2,301 sales

ddeveloper supports this item

Supported

2608 comments found.

May I know when will be the version with the invoice released?

Probable around 1st Nov. Just to let you know that if you want to buy, do that before the next version release as prices will increase after the next release. Thanks

Hi Few Pressle questions please.

1. For clients can I disable most of navigation and only leave few options there? 2. I want to use this as progress tracker teaching kids safety of camping can I add individual child to specific parent so that parents can see progress their child is making. 3. Can I add list of things they learning and progress they making to make things easy for them to understand where they childish with learning spesific skills

Thank you

Please provide me latest product. I am your registered user.

Purchase Code : 07ab6cc0-6fc9-XXXXXXXXXXXXXXXXXXXXXXXXX

I had a need to be able to have a link to specific record without searching for it. I could copy this link and send it to others and when they followed the link it would go directly to the record.

So something like this: http://www.mywebpage/database/view.php?var=ID10003

This is my solution to that, and I hope it’s helpful.

PDO Crud, this creates an html link based on the id so you can link to the VIEWFORM.

//html url for single record viewing
$pdocrud->tableColFormatting("id", "html",array("type" =>"html","str"=>"{col-name}"));
//Column tooltip
$pdocrud->crudColTooltip("id", "Click for Direct Link of Record");
echo $pdocrud->dbTable("yourtable")->render();

Create a new view.php and add below info

<?php require_once ‘script/pdocrud.php’; ?>

<?php //Pulls var from previous page $var = $_GET[“var”]; // it will echo out var for testing // it will echo out var for testing comment out for production echo $var; ?>

<?php
    $pdocrud = new PDOCrud();
// SetsPK to be id but can be any record you choose as long as it's unique 
$pdocrud->setPK("id");
// applies that variable we called above to that id. the "id" below has to be names id to make it work, but is variable above
echo $pdocrud->dbTable("yourtable")->render("VIEWFORM",array("id" =>"$var"));
    ?>

This works great! However, I do have a couple questions.

When making a form field a radio button, how can I get the values to be something other than 1 or 0. I have tried everything and nothing seems to work. Here is the original and the last edit I tried:

Original: $pdocrud->fieldTypes(“will_travel”, “radio”);//change gender to radio button $pdocrud->fieldDataBinding(“will_travel”, array(“Yes”,”No”), ””, ””,”array”);//add data for radio button

Last Edit Tried: $pdocrud->fieldTypes(“will_travel”, “radio”);//change gender to radio button $pdocrud->fieldDataBinding(“will_travel”, array(“Yes”,”No”), “Yes”, “No”,”array”);//add data for radio button

Second, is there a way to have the form fill in a default value? For example will_travel in above have a default of no unless user changes it?

Finally, I have no idea how to display images. I have tried following the instructions but am having no luck.

Thank you!

The dbOrderBy code does NOT seem to work when adding multiple columns

$pdocrud = new PDOCrud(); $pdocrud->dbOrderBy(“id desc”);//descending //$pdocrud->dbOrderBy(array(“id desc”,”order_no desc”));//pass in array echo $pdocrud->dbTable(“orders”)->render();

If using the array format errors are thrown:

Fatal error: Uncaught TypeError: implode(): Argument #2 ($array) must be of type ?array, string given in /home/swimacademynull8.com/public_html/wp-content/plugins/SwimAcademyNull8-master-plugin/script/classes/PDOCrud.php:447 Stack trace: #0

if multiple columns are concatenated with commas then you get no column found errors.

Can you provide guidance as to the correct format for allows two columns to be assigned to order by

In your code the $this->orderByCols = implode($orderbyCols, ”,”); is not valid php – it should be implode(separator,array) for starters

and even when that is fixed – the order still doesnt seen to be a two column sort – it still seems to default to a single column

Dear community and developer, I have managed to repair several bugs that pdocrud had, here I list them

- In the action buttons in the url you can now pass any field in the column and multiples too

- In the buttons when using this condition $pdocrud->addWhereConditionActionButtons(“edit”, $colname_where,”!=”, array(76778)); It is now possible to pass any column in the table, not just the id

- In the SQL type grid, pagination, mass deletion, search, filters and deletion already work and you can also apply the logic of hiding buttons and the data is built already paginated with a query.

- In the search filter I have managed to repair some things such as now when filtering by several fields when deleting one at a time the previous one remains filtered and I have added a button that when pressed the search is done in the filter

- Added a button that is responsible for refreshing the crud table just like xcrud does

- The recaptcha was repaired because when inserting data with the configured paba it gave an error because it was also trying to insert the recaptcha into the database that error has already been repaired

- I also repaired the captcha because it did not generate the random image, change the image generation logic to SVG

- It was also fixed that when searching in the search engine by pressing enter in multiple instances towards the action in all of them it is now done only in the one where enter is given

- I have also added a functionality similar to that of xcrud that now the fields can be passed through curly braces {} in an html and given to a set_template method of pdocrud, which means that you can have any type of order you want, making it very flexible and powerful

- Change php excel to phpspreadsheet and now when downloading the excel grid it is downloaded with a more elegant format saying the amount of data there is

Those are some of the improvements and fixes I’ve added so far

we are having issues with the EDITFORM / VIEWFORM render not working It is also NOT working on the live demo on your own site

Hi

Let me know what error message you are getting? Also, you cna try one thing…comment out following line in pdocrud.php file

//ini_set(‘display_startup_errors’, 1); //ini_set(‘display_errors’, 1); //error_reporting(-1);

the EDITFORM , VIEWFORM functionality does NOT appear to be working at all It also doesnt work in the current live demo

I have a database file saved in .txt format that is almost 8GB. I am looking for a way to access the content. Will I be able to use your script? If decide to go with your script will it involve simply uploading the file to view the content?

I installed the script plus the demo data. It loads, however, it appears that none of the scripts are working. I can not do any inline editing, even the menu hider does not work. I tried looking around but don’t want to break anything. Could you please tell me what is wrong? Also, I had to add the .php to the sidemenu as they were not loading any pages.

Hi

It must be due to incorrect url in config[“script_url”]. It must be path till script folder..but shouldn’t include the script folder. Please check.

Regarding side menu, please check the htaccess file inside the demo folder. Thanks

Working perfect now! Thank you!

Dear, I am making changes to the core of pdocrud in its dbsql function. I have managed to make the pagination work, the records per page, the mass deletion and now it is possible to create the crud by writing a query. Who said it was not possible? You said you had that limitation because I have achieved it among other things.

Hi

It’s Great. I have also added some more features. If you want to share your latest file, please feel free to do so on my email. Thanks

Hi. Can i work in php 7.x? I just don’t know how to work.

I am not getting any response to my questions and now I have a new issue. This is the error I get when I use the Where condition:

Deprecated: Creation of dynamic property PDOCrud::$whereCondition is deprecated

PDOCrud.php on line 1379

Its Deprecated message that means the functionality is Deprecated in the latest version of PHP. You can either hide that message by setting error_reporting(-1) in pdocrud.php or you can declare a variable named $whereCondition in file as mentioned in the error. Please check. Thanks

Insert form result error: Deprecated: Creation of dynamic property PDOModel::$parameters is deprecated in /home/infodevc/subdominios/senar.rm4.com.br/public/script/classes/PDOModel.php on line 896

Hi, Work this version with PHP 7.3.x?

Thanks,

How do I create another view button on one table another joined table by id value.

Its for wordpress?

SQLSTATE22001: String data, right truncated: 1406 Data too long for column ‘active’ at row 1

When: $action = array( 1 => 0, 0 => 1 );//action to be performed, like when value is 1 set it to 0 $text = array( 1 => ‘’, 0 => ‘’ ); $_pdoc -> enqueueActions( $action, “switch”, $text, “active”, array( ) );

“active” column is a tinyint, either 1 or 0

Changing the data type of the field is certainly NOT the answer to this issue. Where in the code is this being checked for? I will modify your code to make sure it is corrected to handle it properly…

Just for HaHa’s I changed the datatype to VARCHAR ... and guess what happens? The same exact issues… so … thats obviously NOT the issue here.

share your complete code then I will be able to check it properly. The code you shared is from example and it works perfectly with the demo database. So something must be happening at your end, thats why its not working.

When utilizing ‘enqueueActions’ switch for an “active” / “inactive” column, and a callback to change another columns ID to the users name, clicking the “active / inactive” reverts the Usersname to the ID. How to stop this?

Also would like to know if there is a way to turn off “tableCellEdit” for specific columns?

The same thing happens when the edit/new form is shown… the usersname reverts back to the ID

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey