ddeveloper

ddeveloper supports this item

Supported

393 comments found.

lucybb

lucybb Purchased

Where condition doesn’t work on joined tables.

I am using the where condition as per this example: http://pdocrud.com/demo/pages/where-condition.php

I get an error like:

SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘r_id’ in ‘where clause’

I have worked out I get this on pages where I have LEFT JOIN tables only.

Thanks

Hi

Please share your code so that I can check. Thanks

lucybb

lucybb Purchased

I don’t think you will understand my code example as I’m using a custom database. But you get the error anytime you use both a WHERE and a JOIN TABLE. You do not get it immediately upon loading the page. But you get it once you try to edit a row. Thanks

Hi,

When rendering a form so it can be edited, is there a way of displaying a checkbox where the fildtype is a boolean?

The below example just show the form input as a number input, not a checkbox: $pdocrud = new PDOCrud(); $pdocrud->fieldTypes("myBoolCol", "checkbox"); echo $pdocrud->dbTable("myTable")->render();

Hi

In bulk editing, checkbox is currently not available. Thanks

Thanks for your reply. I’ve made a small JavaScript function that now does this dynamically when an attribute is parsed to the field in question.

Ok..great. Thanks

simsim08

simsim08 Purchased

Hallo, thx for your support. I have an issue that you can myabe help me with. I’m using the version 2.4 and with it the plugin-datatable.php, including it with: echo $pdocrud->loadPluginJsCode(“datatable”,”.pdocrud-table”); The problem is now, that it overrides my settings : $pdocrud->setSettings(“recordsPerPageDropdown”, false); $pdocrud->setSettings(“pagination”, false); $pdocrud->recordsPerPage(2000); It shows pagination and recordsPerPageDropdown even if I set them to false in the config.php.

Best regards

Hi

As you may know that datatable plugin has it’s own pagination and records per page down so it is showing that. You need to pass the parameter to hide that. Please check documentation of datatable plugin.

Thanks

A pre-purchase question:

I want to convert an MSAccess/VBScript generated order form that I use on a client website. The order form has products with image, description, the price and a checkbox for quantity for each product. No payment or shopping cart. I update this page monthly for my client.

I have already converted the Access database to MYSQL, now I need to develop the backend with PDO Crud.

I know I can use PDO Crud to update the backend, which I would do on my Wamp server then export the SQL to the web server database

Can I use PDO Crud to write the front-end page to display available products with the quantity checkbox and produce an email form previewing the selected items, quantities and customer details then send the result to my client?

Thanks!

Yes,

PDOCrud can be used for both frontend and backend.

you can use pdocrud to display crud table in frontend also and also you can use raw data operation to perform any type of query to get data.

Thanks

kaigu

kaigu Purchased

hello, help me with the following questions

1.how can i display meta_key & meta_value colums in this example http://pdocrud.com/demo/pages/join 2.how can i order date & time by current ? http://pdocrud.com/demo/pages/order-by

3.How can i hide some rows in form popup & redesign your own button (hiding fields) example if i want to hide (order no) in this demo. http://pdocrud.com/demo/pages/popup-form-on-click

4.how can i style the back ground appearance when i click on edit ?

5.in a table form, Can i prevent a particular column from being edited?

Hi

1. You can do the left join between tables similar to example. 2. You can use dbOrderBy() function and order by your date or time column 3.4. You need to write css for that. 5. You can hide by not displaying in table or using css.

Thanks

1. Is it possible to show a table which includes column “date” by the actual day?

For example: There are several entries in the table, even some of the last year and also some in next year. The table should be rendered at the position with the current day/date visible. For best results it also offers the option to only show entries with actual date +/- x days.

2. Is it possible to add a filter to render view of table, with two datefields where only entries between are shown?

Hi, thanks for your reply. I’m not sure if you got me right with 1). I mean the “date” column is already in the database. Every entry has its own date in this column. When the table is rendered I want to show only the entries which have got the actual date +/- x days set as “date”. Is this possible?

Hi,

It’s still not clear to me. Can you explain more using some example values. Thanks

okay, no problem. Some example here. There will be a database with a table called “tasks” with several columns called “id, title, description, due date”. Let’s say there are 500 entries in this database table. Some of them have got a “due date” in March (they are old), some have a due date this week and some of them have got a due date in september (future). I want to render this database table and jump to the page with the actual entries with a “due date” of today + 3 days. Maybe lets say this is page 150. So in the best case the whole table should be displayed, but page 150 is the one which will be visible because there are the entries with actual date. But you are still able to navigate to older tasks by clicking back in the paging, or to future tasks by clicking forward in the paging. Is this possible and how? Thanks a lot.

Hi, I have a problem. When I insert a date on a document it’s all ok. But when I don’t enter any date, the system writes 0000-00-00 by default. I would leave empty. How can I do? Thanks

Hi

Please check

http://pdocrud.com/demo/pages/field-formula

check for date example

Thanks

I saw that with version 2.6 now it is possible change the column heading. Can it also be renamed for column values? thx

Hi

You can directly rename the column heading. To change column values, you need to use the callback function.

Thanks

Nice script overall, but just ran into my first problem…

Enum database field shows only “Select” in form select dropdown, no other options. Database field is defined as enum(‘Free’, ’$’, ’’) so there should be those 3 options displayed, correct?

I am NOT using fieldTypes or fieldDataBinding options since script should pick up the correct enum values by default (although I did try using those options but to no avail).

Thanks in advance!

Hi,

it should get the data also, I will check once. Meanwhile you can use the fieldType and field Data binding option. Thanks

Hi, Is there a way of connecting to a different host? I’d like to run one query from one database/host and then change database/host and run another query. Currently this isn’t possible by the looks of things. Unless I use constants to define the connection settings in the config and then redefine them for the second query call?

Hi,

You can create 2 separate object with different connection parameters.

Hi This support to oracle connection?

Hi

It supports mysql, sqlite, sqlserver(>2012) and pgsql but sadly it doesn’t work with oracle now.

Thanks

Hallo, I would like to provide a german lang ini. How can I send it to you? Best regards

Hi,

It’s great. You can send me via email using my profile page. Thanks

Any news on the update with improved search and filters?

by
by
by
by
by
by