Oh, I see – The ContactDate field in the pivot table is just text, so that’s why the ‘between’ oper didn’t work.  I changed the oper to ‘bw’ (begins with) and pass the year from the drop-down and it works perfectly.

All done!  Thanks again for your help.

Ken

• This reply was modified 4 days, 9 hours ago by kgrogers. Reason: figured out the problem with using the search operator 'bt'

I did see that in your original reply.

I did some testing and it turns out that all of the things I want to filter on aren’t actually in the pivot data – when I initially wrote this I didn’t realize that the initial data was a one-shot thing.

Thanks for the help – I need to go back to the drawing board and come up with a different method to accomplish what I have in mind.

Ken

Hi Will:

I guess I should have been more specific – and perhaps I posted in the wrong forum too.

I have a PHP pivotGrid that I want to add filtering to, if that’s possible.

Here is my code:

index.php

<?php include(“leaderboard.php”); ?> </body> </html>

leaderboard.php

• This reply was modified 1 week ago by kgrogers.

(For some reason the Code icon is missing from this compose window – sorry in advance for the ugly code block).

I made the changes you suggested:
<p style=”padding-left: 40px;”>// Set output format to json
$grid2->dataType = ‘json’;
$grid2->setTable = ‘tblLandOwners’;
$grid2->table = ‘tblLandOwners’;
$grid2->setPrimaryKeyID(‘LandOwnerID’);
$grid2->serialKey = true;
if ($grid2->oper == ‘add’) {
    $data = filter_input_array(INPUT_POST);
    $grid2->trans = false;
    if ($grid2->insert($data)) {
        // $sql = “select LAST_INSERT_ID()”;
        // $stmt = $conn->query($sql);
        // $lastInsertID = $stmt->fetch();
        $lastInsertID = $conn->lastInsertId();
        // Create a ‘blank’ record for this landowner in tblParcels
        $sql = “insert into tblParcels (LandOwnerID) values(“.$lastInsertID[0].”)”;
        $conn->query($sql);
    }
}
$grid2->add = false;</p>
<p style=”padding-left: 40px;”>// Let the grid create the model
$grid2->setColModel();</p>
The insert for tblLandOwners worked, but no record was created in tblParcels.

Ken

I added some test code based on what you said, but I never get any value with the $grid->getLastInsertId method.

Here’s what I added:

After I perform the insert, the text file I created (addloform.txt) contains:

Data: Array
(
[LandOwnerID] =>
[LandOwner] => Rogers, K&T
[LandOwnerNotes] => jj
[Status] => 1
[CurrentlyAssignedTo] => 26
[LandOwnerAddress1] => 86 Gruiver Rd
[LandOwnerAddress2] =>
[LandOwnerCity] => Branchburg
[LandOwnerState] => NJ
[LandOwnerZip] => 08876
[HowToContact] => kjh
[MailingSalutation] => lkjh
[AddressedTo] => lkjh
[oper] => add
)

Last insert LandOwnerID:

It looks like the $grid->getLastInsertId method is returning something (since the value got reset from “none set”), but it’s not the primary key from the insert.

The Help file for this method reads:

getLastInsertId( )

The method return the last inserted id when a add is performed and the primary key is serial. In order to have effect this method should be called after renderGrid, editGrid or insert methods – see below

API Tags:
Access: public

Thank you Will – I will give that a try.

Ken

Will:

Good grief, all that because I forgot to capitalize an ‘m’!

All I had to do was correct the select statement for the proper case.

Thank you for your quick reply.

Ken

Hi Will:

I implemented the changes but I am getting an error.  Here is my index.php file:

In my grid.php file I added the following:

The error is reported in the developer console:

Ken

• This reply was modified 5 months, 1 week ago by kgrogers.
• This reply was modified 5 months, 1 week ago by kgrogers.