Hi

what you have tried? Let me know.

I have given one example in demo for adding plugin ckeditor. Can you check with that. It will help you.

Thanks

Hi

sorry,I am not able to understand your question. Please explain. Thanks

Hi,

I do not understand why you have a double select in the filter, the selectfilter returns -1 what is the utility? Sorry for my question but I have never seen this kind of filter work like this. For me the recovery of the database is sufficient and if you want to delete the filter just delete it with the Delete Cross .

Hi, i back again, i try understand, please read demo: http://pdocrud.com/demo/pages/filters If a choose classic car i have result ok perfect, now choose “select” => no result, Choose “SelectProductLineFilter” => no result, Choose radio + select or Select productline filter => error sql. you can help me?

Ok, you mean that if you re-select, it doesn’t show any result. Reason is that, when you choose “select” , it searches “-1” in the table so instead of that you need to remove that using the cross sign.

Thanks

Hi

When you are including “make_id” in crudTableCol function() then is it giving error also or not? Let me know

Please send me structure of both table so I can check accordingly. Thanks

Hi – yes, I still get the error unfortunately – I’ve tried with adding make_id from each table and also together – updated code snippet below.

$pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array("measured_model.make_id", "measured_make.make_id", "make_name", "measured_model.model_id", "model_name","measured_model_enabled")); $pdocrud->joinTable("measured_make", "measured_model.make_id = measured_make.make_id", "INNER JOIN"); echo $pdocrud->dbTable("measured_model")->render(); The db structure is as follows: measured_make

• make_id (PK)
• make_name
• measured_make_enabled

measured_model

• model_id (PK)
• make_id (FK)
• model_name
• measured_model_enabled

I hope this helps!? Thanks for your support!

Hi,

Ok. Let me create same db structure and test it with same code. I will check and let you know in some time. Thanks

Hi

I have checked it. There was some changes in last version that cause this issue. Please contact me via profile. I will send you required solution. Thanks

Great news – thank you. I’ve just sent you a message!

I have replied to email. Thanks

Thank you. I tried to reply via email, but suspect the code I included may have been stripped out so thought I’d post here!

Thank you very much for fix to the above issue! This seems to have fixed that issue… however I think it’s revealed a new one.

My code is now as follows:

$pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array("make_name", "model_id", "model_name","measured_model_enabled")); $pdocrud->joinTable("measured_make", "measured_model.make_id = measured_make.make_id", "INNER JOIN"); $pdocrud->fieldTypes("make_id", "select");//change state to select dropdown $pdocrud->fieldDataBinding("make_id", "measured_make", "make_id", "make_name", "db");//add data using another table name country $pdocrud->fieldTypes("measured_model_enabled", "select");//change state to select dropdown $pdocrud->fieldDataBinding("measured_model_enabled", array("Disabled","Enabled"), "", "","array"); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("1" => "Enabled")); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("0" => "Disabled")); echo $pdocrud->dbTable("measured_model")->render();

The table render displays as I’d expect. However when I Edit or Add, I think there’s a new issue.

On both the Edit and Add screens, I also get all the fields from the ‘joined’ tables – and these are mandatory. I’ve got another page where I do 2 joins, and the fields from both ‘joined’ tables are shown.

If I use $pdocrud->fieldNotMandatory(“make_name”); then I get an error on Submit.

If I use $pdocrud->crudRemoveCol(array(“make_name")); then it also removes the column from the table on the render.

Finally, if I fill in the fields of the ‘joined’ table then it alters the records of the ‘joined’ table – which is not desirable.

I guess the fields from the ‘joined’ table shouldn’t be requested all? Would you be able to confirm for me please? Am I doing something incorrectly?

Many thanks

Hi,

You can remove which fields not to be shown using the formRemoveFields function or you can use formFields function to show specific fields.

Please note that for crud table and form fields, we have different sets of functions. Sorry for late reply as my office got shifted and I was having some trouble in accessing internet.

I hope it clears now.

Thanks

Thank you – that’s great and makes sense!

I’ve just tried it for Edit and it works really well!

For Add/Insert though there’s an error on submit… SQLSTATE[HY000]: General error: 1364 Field 'make_name' doesn't have a default value

My code is now as follows – would you be able to confirm for me?

Note – I’m adding a record to the measured_model table. make_name is a value in the measured_make table and is not a PK or FK.

$pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array("make_name", "model_id", "model_name","measured_model_enabled")); $pdocrud->joinTable("measured_make", "measured_model.make_id = measured_make.make_id", "INNER JOIN"); $pdocrud->fieldRenameLable("make_id", "Make Name (ID)"); //Rename label $pdocrud->fieldTypes("make_id", "select");//change state to select dropdown $pdocrud->fieldDataBinding("make_id", "measured_make", "make_id", "make_name", "db");//add data using another table name country $pdocrud->formFieldValue("make_id", $makeid); //set the value of model_id to be as per the selection of the top form - i.e. default to what the user selected $pdocrud->fieldDataAttr("model_id", array("disabled"=>"disabled")); $pdocrud->fieldTypes("measured_model_enabled", "select"); //change state to select dropdown $pdocrud->fieldDataBinding("measured_model_enabled", array("Disabled","Enabled"), "", "","array"); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("1" => "Enabled")); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("0" => "Disabled")); $pdocrud->formRemoveFields(array("make_name", "measured_make_enabled")); $pdocrud->where("measured_model.make_id", $makeid, "="); echo $pdocrud->dbTable("measured_model")->render(); }

Any thoughts at all?

Many thanks

Hi

It’s related to table/sql error not script related. Please check this

http://stackoverflow.com/questions/15438840/mysql-error-1364-field-doesnt-have-a-default-values

Hi – thanks very much for this. I’ve had a read, but I’m struggling to understand why an insert to the measured_model table, is causing an error to the measured_make table. The insert should only impact the _model table? The script shouldn’t be trying to add any details to the _make table?

Hi

Please check your table. There must be some constraint like foriegn key/primary key defined for both tables that’s why it is giving these message.

Hi – thanks for coming back to me – I really appreciate the support. I’ve been doing some testing to try and get to the bottom of this.

I have 2 constraints – a FK between measured_make.make_id and measured_model.make_id and a unique index on measured_make.make_name.

Also to confirm, measured_make.make_name does not have a default value set as it needs to be unique for that table.

The error that is being displayed suggests that when I do an Insert on the _model table, it is also trying to do an insert on the _make table – which it shouldn’t be doing – it should only be doing an insert on the _model table.

Because I don’t have a default value set in the make_name field it is throwing the error.

To test this, I set a default value for make_name to be “bob1”. When I ran the add/insert on the _model table, the insert succeeded with no error. HOWEVER, there is now an entry of “bob1” in the make_name column of the _make table – which is incorrect behaviour for what I want to achieve…

I think the issue lies with the $pdocrud->joinTable because if I remove this then the Add/Insert succeeds (sort of – it does 3 inserts!?).

So I guess it’s worth me explaining what I’m trying to achieve because I suspect I’m either using incorrect lines of code, or there is a bug.

To recap – my table structures are as follows:

measured_make

• make_id (PK)
• make_name
• measured_make_enabled

measured_model

• model_id (PK-Unique)
• make_id (FK)
• model_name
• measured_model_enabled

Note – one make (make_id) can be used on many models.

When I load the measured_model PDOCrud page, I want the following columns to be displayed: .

• measured_make.make_name
• measured_model.model_id
• measured_model.model_name
• measured_model.measured_model_enabled

This works with the following lines of code: . $pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array("measured_make.make_name","model_id", "model_name","measured_model_enabled")); $pdocrud->joinTable("measured_make", "measured_model.make_id = measured_make.make_id", "INNER JOIN"); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("1" => "Enabled")); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("0" => "Disabled")); echo $pdocrud->dbTable("measured_model")->render(); .

NOTE: I think the documentation says that where there is a one-to-many relationship I should use LEFT JOIN… but when i do this, I get an error that measured_make.make_name is an unknown column even though it’s joined… is this a bug or have I set the join incorrectly?

So the display of the CRUD table works. But then the Edit and Add/Insert need a bit extra. For this, I only want to show the measured_model fields because I only want to edit or add to the measured_model table. Additionally, I want to have a dropdown box that contains the measured_make.make_name values instead of the measured_model.make_id.

The render of the forms is achieved with this code: $pdocrud = new PDOCrud(); $pdocrud->crudTableCol(array("make_name","model_id", "model_name","measured_model_enabled")); $pdocrud->joinTable("measured_make", "measured_model.make_id = measured_make.make_id", "INNER JOIN"); $pdocrud->fieldRenameLable("make_id", "Make Name (ID)"); //Rename label $pdocrud->fieldTypes("make_id", "select");//change state to select dropdown $pdocrud->fieldDataBinding("make_id", "measured_make", "make_id", "make_name", "db");//add data using another table name country $pdocrud->formFieldValue("make_id", $makeid); //set the value of model_id to be as per the selection of the top form - i.e. default to what the user selected $pdocrud->fieldDataAttr("model_id", array("disabled"=>"disabled")); $pdocrud->fieldTypes("measured_model_enabled", "select"); //change state to select dropdown $pdocrud->fieldDataBinding("measured_model_enabled", array("Disabled","Enabled"), "", "","array"); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("1" => "Enabled")); $pdocrud->tableColFormatting("measured_model_enabled", "replace",array("0" => "Disabled")); $pdocrud->formFields(array("make_id", "model_name", "measured_model_enabled")); echo $pdocrud->dbTable("measured_model")->render(); .

This displays the forms correctly and the drop downs contain the correct data.

When I use Edit (following your advice in your previous reply above) everything works really well.

However, when I use Add, I get the error that the field make_name doesn’t have a default value – which as described above is correct (it doesn’t have a default value).

So I think my questions become – how can I display the make_name column on the crud render, when I’m viewing measured_model table. And how can I only Edit the values of or Add/Insert to the measured_model table?

Please could you confirm what the expected behaviour is when doing an Insert where a join has been used?

Sorry for the long reply, I thought it important to explain what I’m trying to do!

Hi,

I have tried to read 2-3 times but still I am not getting this long post. can you be more specific. I know that you tried to elaborate as much but I am not able to get that. sorry about that.

Hi,

No problem – sorry for being confusing!!

The code uses an Inner Join to create the Crud table.

I think the problem is that I expect that when I do an “Add” to the _model table, that the script will only do an Insert to the _model table.

However, the behaviour I’m seeing is that the script is also doing an Insert to the _make table (I’ve been able to test and prove this – it’s not a db issue). I don’t want the script to do that. I only want the insert to the model table.

So I think the question is – how do I stop the insert to the ‘joined’ table?

I need to use the Join to make the CRUD display the correct fields, but when I do Add or Edit (although I can hide the _make fields), how do I stop it from trying to update or insert into the _make table?

I hope this helps to clarify?

Many thanks

Hi,

Yes, I understood your problem that you don’t want to insert data in other table. Script was designed in a way that it insert data in both tables. Let me try to find some solution for that. Thanks

Great news – thank you!

Hi – I wondered if you’d had any joy with this? Is there any input I can provide to help find a solution? Many thanks

Hi, I am working on same. I will release it with new version asap. Thanks

Hi – Just wondered how the new version was going? Sorry for the chaser – my project is stalled at the moment, so thought I’d ask for an update!!

Hi

I have completed all other points in new version but stuck at this point. I am trying to figure out it asap. I will let you know once done.

Thanks

Hi

in which operation, you are getting this message. Please let me know. THanks

Hello    Best regards.    Giacomo Racioppi

When I use:
$pdocrud->setPK("id");
echo $pdocrud->dbTable("users")->render("EDITFORM",array("id" => "$sel_id_utente"));

Top of the page I get:

{message":""}
or
{message eseguita con successo",error":""}

When I use:
echo $pdocrud->dbTable("users")->render();

I get:

Notice: Undefined index: i in /var/www/vhosts/grwebservice.it/httpdocs/ar/script/classes/templates/bootstrap/template-table.php on line 83

of all records.

How to solve? Look for an answer with confidence.

Thank you.

Thanks

Let me know how you can help us. Thanks

We will file a complaint to the website illegally hosting your contents, asking them to permanently remove it. We are very experienced in this so we assure that 99% we will success. The process usually take 2-3 business days

How much you charge for this work? Thanks