ddeveloper

ddeveloper supports this item

Supported

217 comments found.

Hi, is it possible to work with more than 2 databases and joining table in those db together

Hi,

Currently it support 1 database at a time. Thanks

Puru991

Puru991 Purchased

Hi, is there any way to filter values displayed in a select input based on another field in the insertform? does the stepy plugin enable you to do that?

Hi, You can use the field data binding function to load value and use field dependent function load value on change. Please check demo for that. Thanks

Puru991

Puru991 Purchased

Hey there, I think this script is not fit for my project, can I request a refund please?

Hi, If script was not working then I was ready to accept refund. I have replied to your all questions also. You know that it takes lots of hardwork to develop this kind of big script. I hope you understand it. Thanks

Hi,

With fieldTypes() is set the type in my case radio buttons. With fieldDatabinding() i set the vals of my buttons, but how can i set a default value for one of the buttons so that a button is always selected if a page is loaded. like checked = “checked” in XHTML

bb708cb9-ab04-40d0-a7d7-82519e3b6a5d

Hi,

You can set field attribute to set checked=”checked”. Thanks

Hi,

1) I want to run a SQL query as mentioned in this link : http://stackoverflow.com/questions/15040414/select-sum-and-inner-join

So, I make a use of setQuery and render to run my query like this:

$pdocrud->setQuery(“select new_account.acc_no,new_account.f_name,sum(cash_entry.credit) as TotalCredit,sum(cash_entry.debit) as TotalDebit from new_account LEFT JOIN cash_entry ON new_account.acc_no = cash_entry.account_no group by new_account.acc_no ,new_account.f_name ,new_account.l_name”);

echo $pdocrud->render(“SQL”);

It is working fine,but their is a problem the $pdocrud->render(“SQL”) command producing a table without search, pagination and action buttons not working as we see the same look in your demo page : http://pdocrud.com/demo/pages/sql

Can you tell how we can run the same query and get the same result by using $pdocrud->dbTable(“tablename”)->render().Actually i can’t find any method that how to implement GROUP BY , SUM and Get the column of two tables .

2) Another thing i want as we see on this page : http://pdocrud.com/demo/pages/table-col-string-formatting their is a two columns First Name and Last Name is their any formating option that we can combine First Name and Last Name and make a new column Full Name only for display.

Hi

1. sql query can be of any type so it doesn’t allow pagination, search and action buttons.

2. Yes, you can join two columns to produce, I will let you know example of that. Thanks

So right now their is no way to use GROUP BY and SUM of SQL functions in $pdocrud->dbTable(“tablename”)->render() method ?

Hi,

Group by or SUM means that you are combining multiple result in a single row so it is not possible to give edit/delete option against that. For example, if we group by student having same age then there will be multiple entries so we dont know where to apply edit/delete.

I hope it’s clear now. Thanks

Hello filed type checkbox is not working in edit mode. forces to select all check boxes below is code i used

$pdocrud->fieldTypes(“language”, “checkbox”); // //$pdocrud->fieldDataBinding(“language”, array(“English”, “Hindi”, “French”, “Spanish”, “Chinese”), ””, ””, “array”); // $pdocrud->fieldDataBinding(“language”, array(“0”=>”English”,”2”=>”Hindi”,”5”=>”Chinese”), ””, ””,”array”);//

Thanks

Hello i added $pdocrud->fieldNotMandatory(“language”); Now working…....... but when i uncheck all checkboxes in edit mode. then after saving no editing is done. Plz. check Thanks

Ok..I will check that part. Thanks

Askancy

Askancy Purchased

Unfortunately, 29 days after any of the problems that I reported they were resolved https://codecanyon.net/comments/15680474, and the action of the two buttons that to me still does not work … I waited 20 days giving confidence to your script, but unfortunately I can not use for the many problems I’ve dealt with, and I wanted to ask if you can get a refund. Unfortunately it lacks many features that are essential for me.. Thanks

Askancy

Askancy Purchased

Excuse me, you said you were willing to refund, I have given confidence to you, waiting for a month. in this month you have not released any updates.

Now I ask you to refund, you ignore me?

Hi,

I am not ignoring you. I have uploaded today new version. So l was waiting for that.

Let me know if you want to refund now or want to wait for the new version. Thanks

Askancy

Askancy Purchased

Thanks a lot, unfortunately not seeing updates or news on updates, I developed a script alone. Thank you very much but I prefer a refund. Good luck with future updates.

egcoder

egcoder Purchased

Hi, When I use colRename it renames the col only in the view table, not in the edit form – which makes the client confused – how can we rename also fields in edit form ?

Thanks

Hi,

There are 2 types of function. One for the table (grid) display and one for the form display. e.g. colRename() is for the table(Grid) display and fieldRename() for field rename.Thanks

egcoder

egcoder Purchased

Hi, Thanks for fast reply

Is there also something similar to crudRemoveCol() that removes fields ?

Thanks

Hi,

http://pdocrud.com/documentation/#!/grid_column

It has details about all different functions. Please check. Thanks

etattva

etattva Purchased

Can I disable Print CSV, Excel and CSV export ? I want team members to edit data but not export them for any reason.

Yes, you can disable all these options using config settings. Thanks

xmannv

xmannv Purchased

Hi,

I want to change returned content of a column in database table, not same as data returned from database, how can i do this.

Ex: data returned from database was 1, and i want display it to 2 or something else.

And one more question, i want to join others table and display data from that table in crud, but i tried to call columns name, it was failed.

Regards.

xmannv

xmannv Purchased

Yeah, one of my question got answer.

i have two table:

- users (first_name, last_name, username)

- user_meta (birthday, country)

And i want to join 2 tables above and display all columns. My problem was just can use:

$pdocrud->crudTableCol(array(‘first_name’, ‘last_name’, ‘username’));

couldn’t use $pdocrud->crudTableCol(array(‘first_name’, ‘last_name’, ‘username’, ‘birthday’, ‘country’));

or even: $pdocrud->crudTableCol(array(‘first_name’, ‘last_name’, ‘username’, ‘user_meta.birthday’, ‘user_meta.country’));

Regards

xmannv

xmannv Purchased

please help ?

HI,

The grid shows columns of the main table by default. Just to explain why It is not allowed to show other table data because it can be a left join where multiple entries can match same entries. If you want to show the data of other table then you need to use the callback functions. Thanks

Hi. I am having some problems when running the script. It creates the diferent tables however it doesnt load the css or javascript files. I am working with Xampp. I copied the script folder and edited the config.php file. I have made a couple of tests with the insert form and it works well. However it doesnt load the css files.

Hi,

You might have not set url settings correctly in config file. Please check that. Thanks

Hi,

You might have not set url settings correctly in config file. Please check that. Thanks

What i need is, when the i select a personname (unique) in the form it fills automaticly the other data in the form (data that is in the same table like adress, age etc). Is there a function for that already or do i need to make a function for that by myself.

i think i can sort this out with the fieldDependent function.

pittercod

pittercod Purchased

Hello, I use PDO Crud in a secure area (admin area) with a session (secure_session_start ();) and PDO Crud uses @session_start (); The following error message occurs:

Notice: Undefined index: TawYmhLU6J in /homepages/xxxx/htdocs/xxxxxxx/script/classes/PDOCrudAjaxCtrl.php on line 9

Fatal error: Uncaught Error: Call to a member functionRender () on boolean in /homepages/xxx/htdocs/xxxxx/script/classes/PDOCrudAjaxCtrl.php:19 Stack trace: # 0 / homepages / xxx / htdocs / xxxxxx / script /pdocrud.php (18): PDOCrudAjaxCtrl-> handleRequest () # 1 {main} thrown in /homepages/xxxx/htdocs/xxxxx/script/classes/PDOCrudAjaxCtrl.php on line 19

Could you please help me?

Regard Peter

pittercod

pittercod Purchased

What do I have to change?

You need to change session code in the PDOCrud.php page. Thanks

pittercod

pittercod Purchased

What do I need to change? In the pdocrud.php, the code is @session_start ();

In the admin-arena is the code “secure_session_start ();”

Hi is it only possible to use a select field for the fieldDependent function because if i use a text field it wont fill it.

You can set the value of the text field also.

Please check

http://pdocrud.com/demo/pages/set-field-value

Thanks

thanadon

thanadon Purchased

How to debug PDOCrud?

I found that the page has problem with Language since it is not show in button left in export section.

Language file is exist on the server.

Thank you

Hi,

To set language file, you need to set the language name in config file.

http://pdocrud.com/documentation/#!/configuration_settings

Thanks

Hi, Is it possible go to my own form when i click in action icon? I mean that i have forms with distinct layouts and would like to use them with pdocrud. Thanks. Forgive the bad english.

Hi,

You can use something like this.

http://pdocrud.com/demo/pages/action-buttons

redirect to your forms on button click. Thanks

Yes, very good, i’m stupid. What about addbtn? I write md5(password) to table and standard form doesn’t allow this operation. The standard input form also fails when the mysql field type is enum (UserDep enum(‘Commercial’,’Gate’,’CustomerService’)). The dropbox is empty.

Found the dropbox soluction: fieldDataBinding(“UserDep”, array(‘Commercial’,’Gate’,’CustomerService’), ””, ””,”array”)

etattva

etattva Purchased

How do I add simple login mechanism or allow only selected users to access the application ?

Hi,

For login, you can use following example.

http://pdocrud.com/demo/pages/login-demo-example

PDOCrud provides support for the crud related operation but it doesn’t have role based feature. You need to add specific code for that.

etattva

etattva Purchased

I guess I will make question more explicit. I want to limit users who can access the application. A simple user name/pwd will do. As per documenation “You can easily create complete login form and add callback functions to save session related data to check login on various pages ”. I can set up a table with proper credentials. I want only authorized users to access any page. How do you suggest we do it ?

Hi,

Yes, the login example shows how to create callback function and save session related data. After saving data in session, then you need to check session value in each page to allow access or not as per role and user Id.

Thanks

by
by
by
by
by
by