Where condition doesn’t work on joined tables.
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.
Please share your code so that I can check. Thanks
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
When rendering a form so it can be edited, is there a way of displaying a checkbox where the fildtype is a boolean?
$pdocrud = new PDOCrud();
Yes, you can set the field type to checkbox and pass data as array using fielddatabidning.
Thanks but I did try this, and all kinds of other combinations. I can not get a checkbox to appear for bulk editing.
$pdocrud = new PDOCrud();
$pdocrud->fieldDataBinding("MyBoolCol", array(1, 0), "", "", "array");
Do you having a working example?
In bulk editing, checkbox is currently not available. Thanks
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:
The problem is now, that it overrides my settings :
It shows pagination and recordsPerPageDropdown even if I set them to false in the config.php.
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.
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?
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.
hello, help me with the following questions
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.
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?
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.
1. Is it possible to show a table which includes column “date” by the actual day?
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?
1. You can use the callback function to modify the data coming from database to add column like this. direct addition of these type of column is not available.
2. Yes, you can set the type of search field also.
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?
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
check for date example
I saw that with version 2.6 now it is possible change the column heading.
Can it also be renamed for column values? thx
You can directly rename the column heading. To change column values, you need to use the callback function.
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!
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?
You can create 2 separate object with different connection parameters.
Hi This support to oracle connection?
It supports mysql, sqlite, sqlserver(>2012) and pgsql but sadly it doesn’t work with oracle now.
Hallo, I would like to provide a german lang ini. How can I send it to you?
It’s great. You can send me via email using my profile page. Thanks
Any news on the update with improved search and filters?
Use, by you or one client, in a single end product which end users are not charged for. The total price includes the item price and a buyer fee.
Use, by you or one client, in a single end product which end users can be charged for. The total price includes the item price and a buyer fee.
View license details
Get it now and save up to $9
This item was featured on CodeCanyon
Deliver better projects faster. Photos, templates & courses
Unlimited downloads. Only $29/month
Learn almost anything with
Envato Tuts+ for free
9000 free tutorials, 3000 paid courses
Designers matched perfectly to
you on Envato Studio
2000 artists ready to undertake your work