-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
04-13-2024, 08:29 AM
(This post was last modified: 04-13-2024, 08:46 AM by HarmW94.)
Hi,
Based on the data below, I want to create a list/table with the data that ends up in the array. However, I can't figure it out and I have tried everything regarding array format, count, etc.
I hope it's clear because I can't figure it out. As an example (from Excel);
Code: Participants Category
20 Boklam
12 Jeugbok
6 Jongerebok
9 Ouderebok
2 Veteranenbok
60 Geitlam
30 Jeugdgeit
20 Jongeregeit
15 Ouderegeit
5 Veteranengeit
This is my query (where $id = 24);
Code: SELECT show_participants.*,
zoo_easy.Gender,
zoo_easy.Born,
zoo_easy.Name,
zoo_easy.OwnerName
FROM show_participants,
zoo_easy
WHERE show_participants.participant_show = ' . $id . '
AND show_participants.participant_animal = zoo_easy.RegistrationNumber
ORDER BY zoo_easy.Gender,
zoo_easy.Born DESC
And this is the result I get from print_r;
Code: Array
(
[0] => Array
(
[participant_id] => 106
[participant_animal] => A22035
[participant_show] => 24
[participant_category] => 4
[Gender] => Bok
[Born] => 2022-03-10
[Name] => Abel van de Zwartberg
[OwnerName] => B. Segers Bert
)
[1] => Array
(
[participant_id] => 105
[participant_animal] => NN24-195
[participant_show] => 24
[participant_category] => 2
[Gender] => Geit
[Born] => 2024-03-18
[Name] => Pearl van de Pijpjes
[OwnerName] => S.H. Dekker
)
[2] => Array
(
[participant_id] => 104
[participant_animal] => NN24-195
[participant_show] => 24
[participant_category] => 3
[Gender] => Geit
[Born] => 2024-03-18
[Name] => Pearl van de Pijpjes
[OwnerName] => S.H. Dekker
)
[3] => Array
(
[participant_id] => 103
[participant_animal] => A23001
[participant_show] => 24
[participant_category] => 2
[Gender] => Geit
[Born] => 2023-01-01
[Name] => Mit van het Heieinde
[OwnerName] => B. Van den Broeck Ben
)
)
This is the helper that's calculates the Category for me;
PHP Code: <?php use App\Models\CategoriesModel; use CodeIgniter\CodeIgniter;
function getCategory($data) { $categoriesModel = new CategoriesModel();
$gender = $data['Gender'];
$born = substr($data['Born'], 0 ,4); $year = date("Y"); $count = date("Y") - substr($data['Born'], 0 ,4);
// Lam if ($count == 0) { $sql = $categoriesModel->getCategoryData('1'); $result = $gender . strtolower($sql['category_name']); }
// Jeugd if ($count == 1) { $sql = $categoriesModel->getCategoryData('2'); $result = $sql['category_name'] . strtolower($gender); }
// Jongere if ($count == 2) { $sql = $categoriesModel->getCategoryData('3'); $result = $sql['category_name'] . strtolower($gender); }
// Oudere if ($count == 3 OR $count == 4 OR $count == 5) { $sql = $categoriesModel->getCategoryData('4'); $result = $sql['category_name'] . strtolower($gender); }
// Veteraan if ($count >= 6) { $sql = $categoriesModel->getCategoryData('5'); $result = $sql['category_name'] . strtolower($gender); }
// Error handling if (empty($result)) { $result = 'Onjuiste data'; }
return $result; }
I hope someone can help me, because I've been stuck on this for several days now and running out of time. I can't and do not want to change anything in the zoo_easy table. This is loaded using a CSV file because it comes from a different system.
Cheers.
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
Thanks, i'll take a look at it!
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
04-14-2024, 04:08 PM
So, after 9 hours i did came up with something temp. But it is ugly as f*.. I was erroring with the keys in the array because when it's empty i need some output and the maximum will always be 10. For now it's working but this is no-go for me. So if somebody has a decent and better solution. I love to hear!
This is the helper...
PHP Code: function calculateParticipantsAtShow($data) { $categoryModel = new CategoryModel();
// COUNT 1 if (!empty(array_count_values(array_column($data, 'participant_category'))['1'])) { $count_1 = array_count_values(array_column($data, 'participant_category'))['1']; } else { $count_1 = 0; } // COUNT 2 if (!empty(array_count_values(array_column($data, 'participant_category'))['2'])) { $count_2 = array_count_values(array_column($data, 'participant_category'))['2']; } else { $count_2 = 0; } // COUNT 3 if (!empty(array_count_values(array_column($data, 'participant_category'))['3'])) { $count_3 = array_count_values(array_column($data, 'participant_category'))['3']; } else { $count_3 = 0; } // COUNT 4 if (!empty(array_count_values(array_column($data, 'participant_category'))['4'])) { $count_4 = array_count_values(array_column($data, 'participant_category'))['4']; } else { $count_4 = 0; } // COUNT 5 if (!empty(array_count_values(array_column($data, 'participant_category'))['5'])) { $count_5 = array_count_values(array_column($data, 'participant_category'))['5']; } else { $count_5 = 0; } // COUNT 6 if (!empty(array_count_values(array_column($data, 'participant_category'))['6'])) { $count_6 = array_count_values(array_column($data, 'participant_category'))['6']; } else { $count_6 = 0; } // COUNT 7 if (!empty(array_count_values(array_column($data, 'participant_category'))['7'])) { $count_7 = array_count_values(array_column($data, 'participant_category'))['7']; } else { $count_7 = 0; } // COUNT 8 if (!empty(array_count_values(array_column($data, 'participant_category'))['8'])) { $count_8 = array_count_values(array_column($data, 'participant_category'))['8']; } else { $count_8 = 0; } // COUNT 9 if (!empty(array_count_values(array_column($data, 'participant_category'))['1'])) { $count_9 = array_count_values(array_column($data, 'participant_category'))['1']; } else { $count_9 = 0; } // COUNT 10 if (!empty(array_count_values(array_column($data, 'participant_category'))['10'])) { $count_10 = array_count_values(array_column($data, 'participant_category'))['10']; } else { $count_10 = 0; }
$result = array( // COUNT 1 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('1')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('1')['category_id'], 'participantCategoryCount' => $count_1 ), // COUNT 2 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('2')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('2')['category_id'], 'participantCategoryCount' => $count_2 ), // COUNT 3 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('3')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('3')['category_id'], 'participantCategoryCount' => $count_3 ), // COUNT 4 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('4')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('4')['category_id'], 'participantCategoryCount' => $count_4 ), // COUNT 5 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('5')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('5')['category_id'], 'participantCategoryCount' => $count_5 ), // COUNT 6 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('6')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('6')['category_id'], 'participantCategoryCount' => $count_6 ), // COUNT 7 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('7')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('7')['category_id'], 'participantCategoryCount' => $count_7 ), // COUNT 8 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('8')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('8')['category_id'], 'participantCategoryCount' => $count_8 ), // COUNT 9 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('9')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('9')['category_id'], 'participantCategoryCount' => $count_9 ), // COUNT 10 array( 'participantCategoryName' => $categoryModel->getShowCategoryById('10')['category_name'], 'participantCategoryId' => $categoryModel->getShowCategoryById('10')['category_id'], 'participantCategoryCount' => $count_10 ) );
return $result; }
And in the view...
PHP Code: <?php if(!empty($showCategories) AND !empty($showPartacipants)) : ?> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-12 mt-4"> <table class="mb-5 mt-3 w-25"> <thead> <tr> <th>Categorie</th> <th>Aantal</th> </tr> </thead> <tbody> <?php foreach($showCategories as $showCategorie) : ?> <?php $key = $showCategorie['category_id'] - 1; ?> <tr> <td><?= $showCategorie['category_name'] ?></td> <td><?= calculateParticipantsAtShow($showPartacipants)[$key]['participantCategoryCount']; ?></td> </tr> <?php endforeach; ?> </tbody> </table> </div> </div> </div> </div> <?php endif; ?>
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
(04-18-2024, 11:10 PM)paulkd Wrote: Hi,
Can you post the HTML of the table rendered from your print_r array data?
Code: Array
(
[0] => Array
(
[participant_id] => 75
[participant_animal] => NN24-247
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 2
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-03-27
[Name] => Valeriaan 18 v.d. Optimist
[OwnerName] => P. Sibma
)
[1] => Array
(
[participant_id] => 76
[participant_animal] => WAP042
[participant_show] => 24
[participant_category] => 4
[participant_match_number] => 3
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2021-05-13
[Name] => Iep v.d. Leemputten
[OwnerName] => R. Dijck, van
)
[2] => Array
(
[participant_id] => 77
[participant_animal] => OAP065
[participant_show] => 24
[participant_category] => 4
[participant_match_number] => 4
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2021-04-14
[Name] => Narco v.h. Grensdörpke
[OwnerName] => J.G.G. Buiting
)
[3] => Array
(
[participant_id] => 78
[participant_animal] => NN24-208
[participant_show] => 24
[participant_category] => 6
[participant_match_number] => 5
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2024-03-24
[Name] => Linde v.d. Oldehove
[OwnerName] => R. Dijkstra
)
[4] => Array
(
[participant_id] => 79
[participant_animal] => NN24-209
[participant_show] => 24
[participant_category] => 6
[participant_match_number] => 6
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2024-03-24
[Name] => Sinne v.d. Oldehove
[OwnerName] => R. Dijkstra
)
[5] => Array
(
[participant_id] => 80
[participant_animal] => NN24-217
[participant_show] => 24
[participant_category] => 6
[participant_match_number] => 7
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2024-03-23
[Name] => Janis 553 v.d. Kikkert
[OwnerName] => J. Laning
)
[6] => Array
(
[participant_id] => 81
[participant_animal] => ON23-282
[participant_show] => 24
[participant_category] => 7
[participant_match_number] => 8
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2023-09-26
[Name] => Meghan v.h. Laar
[OwnerName] => Het Laar Gemeente Ommen t.a.v. R. Boezelman
)
[7] => Array
(
[participant_id] => 82
[participant_animal] => ON23-281
[participant_show] => 24
[participant_category] => 7
[participant_match_number] => 9
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2023-09-02
[Name] => Elis 22 v.h. Laar
[OwnerName] => Het Laar Gemeente Ommen t.a.v. R. Boezelman
)
[8] => Array
(
[participant_id] => 83
[participant_animal] => NAR276
[participant_show] => 24
[participant_category] => 8
[participant_match_number] => 10
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2022-05-11
[Name] => Linsy v.d. Weerehoeve
[OwnerName] => A. Smit
)
[9] => Array
(
[participant_id] => 84
[participant_animal] => CAR018
[participant_show] => 24
[participant_category] => 8
[participant_match_number] => 11
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2022-04-29
[Name] => Cissy v.h. Höfke
[OwnerName] => A.P.M. Lier,van
)
[10] => Array
(
[participant_id] => 545343544
[participant_animal] => NN24-246
[participant_show] => 24
[participant_category] => 6
[participant_match_number] => 12
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2024-03-26
[Name] => Catharina
[OwnerName] => G. van der Meer
)
[11] => Array
(
[participant_id] => 74
[participant_animal] => CAR051
[participant_show] => 24
[participant_category] => 3
[participant_match_number] => 13
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2022-06-19
[Name] => Camel v.h. Höfke
[OwnerName] => E.H.P.J. Weijer, van de
)
[12] => Array
(
[participant_id] => 73
[participant_animal] => CAR061
[participant_show] => 24
[participant_category] => 3
[participant_match_number] => 14
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2022-09-09
[Name] => Gijs
[OwnerName] => J. Blok
)
[13] => Array
(
[participant_id] => 72
[participant_animal] => NN23-296
[participant_show] => 24
[participant_category] => 2
[participant_match_number] => 15
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2023-05-13
[Name] => Yuki v.d. Empne
[OwnerName] => . WILDLANDS
)
[14] => Array
(
[participant_id] => 58
[participant_animal] => ME 657
[participant_show] => 24
[participant_category] => 10
[participant_match_number] => 16
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 0000-00-00
[Name] => Kittie v.Beulekamp
[OwnerName] => H. Pol v.d.
)
[15] => Array
(
[participant_id] => 59
[participant_animal] => BS 233
[participant_show] => 24
[participant_category] => 10
[participant_match_number] => 17
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 1980-01-12
[Name] => Adelina v.d.Venkanthoeve
[OwnerName] => L. Doelen, v.d.
)
[16] => Array
(
[participant_id] => 62
[participant_animal] => NSS684
[participant_show] => 24
[participant_category] => 10
[participant_match_number] => 20
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2000-12-31
[Name] => Ottelien v. Tronde ût Elsloo
[OwnerName] => C.O. Rosema
)
[17] => Array
(
[participant_id] => 63
[participant_animal] => NN23-279
[participant_show] => 24
[participant_category] => 2
[participant_match_number] => 21
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2023-05-20
[Name] => Spot
[OwnerName] => T. Leenstra
)
[18] => Array
(
[participant_id] => 64
[participant_animal] => NN23-290
[participant_show] => 24
[participant_category] => 2
[participant_match_number] => 22
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2023-05-17
[Name] => Rothko v.d. Veenhorst
[OwnerName] => A. Blokzijl
)
[19] => Array
(
[participant_id] => 67
[participant_animal] => NN24-190
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 23
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-03-11
[Name] => Valeriaan 17 v.d. Optimist
[OwnerName] => P. Sibma
)
[20] => Array
(
[participant_id] => 70
[participant_animal] => NH24-001
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 23
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-01-02
[Name] => Jan
[OwnerName] => K. van Nispen
)
[21] => Array
(
[participant_id] => 68
[participant_animal] => NN24-161
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 24
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-03-01
[Name] => Timo van Beniwenfra
[OwnerName] => B.A. de Boer
)
[22] => Array
(
[participant_id] => 69
[participant_animal] => NN24-065
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 25
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-01-29
[Name] => Hotse 56 fan Lytse Wâld
[OwnerName] => F. & M. Solle
)
[23] => Array
(
[participant_id] => 60
[participant_animal] => NN24-073
[participant_show] => 24
[participant_category] => 1
[participant_match_number] => 35
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 2024-02-03
[Name] => Mees van de Chevrettehoeve
[OwnerName] => J. de Vries
)
[24] => Array
(
[participant_id] => 61
[participant_animal] => ORR615
[participant_show] => 24
[participant_category] => 5
[participant_match_number] => 46
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Bok
[Born] => 1999-08-12
[Name] => Amor 31 v.d. Jagershoeve
[OwnerName] => H.G. Jager, de
)
[25] => Array
(
[participant_id] => 57
[participant_animal] => A14001
[participant_show] => 24
[participant_category] => 10
[participant_match_number] => 99
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2014-01-06
[Name] => Fien van Hoeve de Gracht
[OwnerName] => G. Van Dyck Gert
)
[26] => Array
(
[participant_id] => 545343545
[participant_animal] => NN24-072
[participant_show] => 24
[participant_category] => 6
[participant_match_number] => 99
[participant_match_category] =>
[participant_match_predicate] =>
[participant_match_champ] =>
[participant_match_points] =>
[Gender] => Geit
[Born] => 2024-01-27
[Name] => X-ell fan Lytse Wâld
[OwnerName] => F. & M. Solle
)
)
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
paulkd Member
  
-
Posts: 76
Threads: 17
Joined: Oct 2015
Reputation:
0
Sorry,
I meant the actual rendered HTML table, like if I used "view source" in the browser.
Just a few rows would be enough.
-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
04-19-2024, 11:04 AM
(This post was last modified: 04-19-2024, 11:04 AM by HarmW94.)
(04-19-2024, 01:00 AM)paulkd Wrote: Sorry,
I meant the actual rendered HTML table, like if I used "view source" in the browser.
Just a few rows would be enough.
PHP Code: <!-- DEBUG-VIEW START 2 APPPATH/Views/admin/shows/view.php --> <!-- DEBUG-VIEW START 1 APPPATH/Views/admin/layouts/default.php --> <!doctype html> <html lang="en"> <head> <script id="debugbar_loader" data-time="1713549746.266648" src="https://api.wesselinkmedia.nl/?debugbar"></script><script id="debugbar_dynamic_script"></script><style id="debugbar_dynamic_style"></style><script class="kint-rich-script">void 0===window.kintShared&&(window.kintShared=function(){"use strict";var e={dedupe:function(e,n){return[].forEach.call(document.querySelectorAll(e),function(e){e!==(n=n&&n.ownerDocument.contains(n)?n:e)&&e.parentNode.removeChild(e)}),n},runOnce:function(e){"complete"===document.readyState?e():window.addEventListener("load",e)}};return window.addEventListener("click",function(e){var n;e.target.classList.contains("kint-ide-link")&&((n=new XMLHttpRequest).open("GET",e.target.href),n.send(null),e.preventDefault())}),e}()); void 0===window.kintRich&&(window.kintRich=function(){"use strict";var l={selectText:function(e){var t=window.getSelection(),a=document.createRange();a.selectNodeContents(e),t.removeAllRanges(),t.addRange(a)},toggle:function(e,t){var a=l.getChildren(e);a&&(e.classList.toggle("kint-show",t),1===a.childNodes.length)&&(a=a.childNodes[0].childNodes[0])&&a.classList&&a.classList.contains("kint-parent")&&l.toggle(a,t)},toggleChildren:function(e,t){var a=l.getChildren(e);if(a){var o=a.getElementsByClassName("kint-parent"),s=o.length;for(void 0===t&&(t=e.classList.contains("kint-show"));s--;)l.toggle(o[s],t)}},switchTab:function(e){var t=e.previousSibling,a=0;for(e.parentNode.getElementsByClassName("kint-active-tab")[0].classList.remove("kint-active-tab"),e.classList.add("kint-active-tab");t;)1===t.nodeType&&a++,t=t.previousSibling;for(var o=e.parentNode.nextSibling.childNodes,s=0;s<o.length;s++)s===a?(o[s].classList.add("kint-show"),1===o[s].childNodes.length&&(t=o[s].childNodes[0].childNodes[0])&&t.classList&&t.classList.contains("kint-parent")&&l.toggle(t,!0)):o[s].classList.remove("kint-show")},mktag:function(e){return"<"+e+">"},openInNewWindow:function(e){var t=window.open();t&&(t.document.open(),t.document.write(l.mktag("html")+l.mktag("head")+l.mktag("title")+"Kint ("+(new Date).toISOString()+")"+l.mktag("/title")+l.mktag('meta charset="utf-8"')+l.mktag('script class="kint-rich-script" nonce="'+l.script.nonce+'"')+l.script.innerHTML+l.mktag("/script")+l.mktag('style class="kint-rich-style" nonce="'+l.style.nonce+'"')+l.style.innerHTML+l.mktag("/style")+l.mktag("/head")+l.mktag("body")+'<input class="kint-note-input" placeholder="Take some notes!"><div class="kint-rich">'+e.parentNode.outerHTML+"</div>"+l.mktag("/body")),t.document.close())},sortTable:function(e,a){var t=e.tBodies[0];[].slice.call(e.tBodies[0].rows).sort(function(e,t){if(e=e.cells[a].textContent.trim().toLocaleLowerCase(),t=t.cells[a].textContent.trim().toLocaleLowerCase(),isNaN(e)||isNaN(t)){if(isNaN(e)&&!isNaN(t))return 1;if(isNaN(t)&&!isNaN(e))return-1}else e=parseFloat(e),t=parseFloat(t);return e<t?-1:t<e?1:0}).forEach(function(e){t.appendChild(e)})},showAccessPath:function(e){for(var t=e.childNodes,a=0;a<t.length;a++)if(t[a].classList&&t[a].classList.contains("access-path"))return t[a].classList.toggle("kint-show"),void(t[a].classList.contains("kint-show")&&l.selectText(t[a]))},showSearchBox:function(e){var t=e.querySelector(".kint-search");t&&(t.classList.toggle("kint-show"),t.classList.contains("kint-show")?(e.classList.add("kint-show"),t.focus(),t.select(),l.search(e.parentNode,t.value)):e.parentNode.classList.remove("kint-search-root"))},search:function(e,t){e.querySelectorAll(".kint-search-match").forEach(function(e){e.classList.remove("kint-search-match")}),e.classList.remove("kint-search-match"),e.classList.toggle("kint-search-root",t.length),t.length&&l.findMatches(e,t)},findMatches:function(e,t){var a,o,s,n=e.cloneNode(!0);if(n.querySelectorAll(".access-path").forEach(function(e){e.remove()}),-1!=n.textContent.toUpperCase().indexOf(t.toUpperCase())){for(r in e.classList.add("kint-search-match"),e.childNodes)if("DD"==e.childNodes[r].tagName){a=e.childNodes[r];break}if(a)if([].forEach.call(a.childNodes,function(e){"DL"==e.tagName?l.findMatches(e,t):"UL"==e.tagName&&(e.classList.contains("kint-tabs")?o=e.childNodes:e.classList.contains("kint-tab-contents")&&(s=e.childNodes))}),o&&s&&o.length==s.length)for(var r=0;r<o.length;r++){var i=!1;(i=-1!=o[r].textContent.toUpperCase().indexOf(t.toUpperCase())||((n=s[r].cloneNode(!0)).querySelectorAll(".access-path").forEach(function(e){e.remove()}),-1!=n.textContent.toUpperCase().indexOf(t.toUpperCase()))?!0:i)&&(o[r].classList.add("kint-search-match"),[].forEach.call(s[r].childNodes,function(e){"DL"==e.tagName&&l.findMatches(e,t)}))}}},getParentByClass:function(e,t){for(;;){if(!(e=e.parentNode)||!e.classList||e===document)return null;if(e.classList.contains(t))return e}return null},getParentHeader:function(e,t){for(var a=e.nodeName.toLowerCase();"dd"!==a&&"dt"!==a&&l.getParentByClass(e,"kint-rich");)a=(e=e.parentNode).nodeName.toLowerCase();return l.getParentByClass(e,"kint-rich")?(e="dd"===a&&t?e.previousElementSibling:e)&&"dt"===e.nodeName.toLowerCase()&&e.classList.contains("kint-parent")?e:void 0:null},getChildren:function(e){for(;(e=e.nextElementSibling)&&"dd"!==e.nodeName.toLowerCase(););return e},isFolderOpen:function(){if(l.folder&&l.folder.querySelector("dd.kint-foldout"))return l.folder.querySelector("dd.kint-foldout").previousSibling.classList.contains("kint-show")},initLoad:function(){l.style=window.kintShared.dedupe("style.kint-rich-style",l.style),l.script=window.kintShared.dedupe("script.kint-rich-script",l.script),l.folder=window.kintShared.dedupe(".kint-rich.kint-folder",l.folder);var t,e=document.querySelectorAll("input.kint-search");[].forEach.call(e,function(t){function e(e){window.clearTimeout(a),t.value!==o&&(a=window.setTimeout(function(){o=t.value,l.search(t.parentNode.parentNode,o)},500))}var a=null,o=null;t.removeEventListener("keyup",e),t.addEventListener("keyup",e)}),l.folder&&(t=l.folder.querySelector("dd"),[].forEach.call(document.querySelectorAll(".kint-rich.kint-file"),function(e){e.parentNode!==l.folder&&t.appendChild(e)}),document.body.appendChild(l.folder),l.folder.classList.add("kint-show"))},keyboardNav:{targets:[],target:0,active:!1,fetchTargets:function(){var e=l.keyboardNav.targets[l.keyboardNav.target];l.keyboardNav.targets=[],document.querySelectorAll(".kint-rich nav, .kint-tabs>li:not(.kint-active-tab)").forEach(function(e){l.isFolderOpen()&&!l.folder.contains(e)||0===e.offsetWidth&&0===e.offsetHeight||l.keyboardNav.targets.push(e)}),e&&-1!==l.keyboardNav.targets.indexOf(e)&&(l.keyboardNav.target=l.keyboardNav.targets.indexOf(e))},sync:function(e){var t=document.querySelector(".kint-focused");t&&t.classList.remove("kint-focused"),l.keyboardNav.active&&((t=l.keyboardNav.targets[l.keyboardNav.target]).classList.add("kint-focused"),e||l.keyboardNav.scroll(t))},scroll:function(e){var t,a;l.folder&&e===l.folder.querySelector("dt > nav")||(e=(t=function(e){return e.offsetTop+(e.offsetParent?t(e.offsetParent):0)})(e),l.isFolderOpen()?(a=l.folder.querySelector("dd.kint-foldout")).scrollTo(0,e-a.clientHeight/2):window.scrollTo(0,e-window.innerHeight/2))},moveCursor:function(e){for(l.keyboardNav.target+=e;l.keyboardNav.target<0;)l.keyboardNav.target+=l.keyboardNav.targets.length;for(;l.keyboardNav.target>=l.keyboardNav.targets.length;)l.keyboardNav.target-=l.keyboardNav.targets.length;l.keyboardNav.sync()},setCursor:function(e){if(!l.isFolderOpen()||l.folder.contains(e)){l.keyboardNav.fetchTargets();for(var t=0;t<l.keyboardNav.targets.length;t++)if(e===l.keyboardNav.targets[t])return l.keyboardNav.target=t,!0}return!1}},mouseNav:{lastClickTarget:null,lastClickTimer:null,lastClickCount:0,renewLastClick:function(){window.clearTimeout(l.mouseNav.lastClickTimer),l.mouseNav.lastClickTimer=window.setTimeout(function(){l.mouseNav.lastClickTarget=null,l.mouseNav.lastClickTimer=null,l.mouseNav.lastClickCount=0},250)}},style:null,script:null,folder:null};return window.addEventListener("click",function(e){var t=e.target;if(l.mouseNav.lastClickTarget&&l.mouseNav.lastClickTimer&&l.mouseNav.lastClickCount)if(t=l.mouseNav.lastClickTarget,1===l.mouseNav.lastClickCount)l.toggleChildren(t.parentNode),l.keyboardNav.setCursor(t),l.keyboardNav.sync(!0),l.mouseNav.lastClickCount++,l.mouseNav.renewLastClick();else{for(var a=t.parentNode.classList.contains("kint-show"),o=document.getElementsByClassName("kint-parent"),s=o.length;s--;)l.toggle(o[s],a);l.keyboardNav.setCursor(t),l.keyboardNav.sync(!0),l.keyboardNav.scroll(t),window.clearTimeout(l.mouseNav.lastClickTimer),l.mouseNav.lastClickTarget=null,l.mouseNav.lastClickTarget=null,l.mouseNav.lastClickCount=0}else if(l.getParentByClass(t,"kint-rich")){var n=t.nodeName.toLowerCase();if("dfn"===n&&l.selectText(t),"th"===n)e.ctrlKey||l.sortTable(t.parentNode.parentNode.parentNode,t.cellIndex);else if((t=l.getParentHeader(t))&&(l.keyboardNav.setCursor(t.querySelector("nav")),l.keyboardNav.sync(!0)),t=e.target,"li"===n&&"kint-tabs"===t.parentNode.className)"kint-active-tab"!==t.className&&l.switchTab(t),(t=l.getParentHeader(t,!0))&&(l.keyboardNav.setCursor(t.querySelector("nav")),l.keyboardNav.sync(!0));else if("nav"===n)"footer"===t.parentNode.nodeName.toLowerCase()?(l.keyboardNav.setCursor(t),l.keyboardNav.sync(!0),(t=t.parentNode).classList.toggle("kint-show")):(l.toggle(t.parentNode),l.keyboardNav.fetchTargets(),l.mouseNav.lastClickCount=1,l.mouseNav.lastClickTarget=t,l.mouseNav.renewLastClick());else if(t.classList.contains("kint-popup-trigger")){var r=t.parentNode;if("footer"===r.nodeName.toLowerCase())r=r.previousSibling;else for(;r&&!r.classList.contains("kint-parent");)r=r.parentNode;l.openInNewWindow(r)}else t.classList.contains("kint-access-path-trigger")?l.showAccessPath(t.parentNode):t.classList.contains("kint-search-trigger")?l.showSearchBox(t.parentNode):t.classList.contains("kint-search")||("pre"===n&&3===e.detail?l.selectText(t):l.getParentByClass(t,"kint-source")&&3===e.detail?l.selectText(l.getParentByClass(t,"kint-source")):t.classList.contains("access-path")?l.selectText(t):"a"!==n&&(t=l.getParentHeader(t))&&(l.toggle(t),l.keyboardNav.fetchTargets()))}},!0),window.addEventListener("keydown",function(e){if(e.target===document.body&&!e.altKey&&!e.ctrlKey)if(68===e.keyCode){if(l.keyboardNav.active)l.keyboardNav.active=!1;else if(l.keyboardNav.active=!0,l.keyboardNav.fetchTargets(),0===l.keyboardNav.targets.length)return void(l.keyboardNav.active=!1);l.keyboardNav.sync(),e.preventDefault()}else if(l.keyboardNav.active)if(9===e.keyCode)l.keyboardNav.moveCursor(e.shiftKey?-1:1),e.preventDefault();else if(38===e.keyCode||75===e.keyCode)l.keyboardNav.moveCursor(-1),e.preventDefault();else if(40===e.keyCode||74===e.keyCode)l.keyboardNav.moveCursor(1),e.preventDefault();else{var t,a,o=l.keyboardNav.targets[l.keyboardNav.target];if("li"===o.nodeName.toLowerCase()){if(32===e.keyCode||13===e.keyCode)return l.switchTab(o),l.keyboardNav.fetchTargets(),l.keyboardNav.sync(),void e.preventDefault();if(39===e.keyCode||76===e.keyCode)return l.keyboardNav.moveCursor(1),void e.preventDefault();if(37===e.keyCode||72===e.keyCode)return l.keyboardNav.moveCursor(-1),void e.preventDefault()}o=o.parentNode,65===e.keyCode?(l.showAccessPath(o),e.preventDefault()):"footer"===o.nodeName.toLowerCase()&&o.parentNode.classList.contains("kint-rich")?32===e.keyCode||13===e.keyCode?(o.classList.toggle("kint-show"),e.preventDefault()):37===e.keyCode||72===e.keyCode?(o.classList.remove("kint-show"),e.preventDefault()):39!==e.keyCode&&76!==e.keyCode||(o.classList.add("kint-show"),e.preventDefault()):32===e.keyCode||13===e.keyCode?(l.toggle(o),l.keyboardNav.fetchTargets(),e.preventDefault()):39!==e.keyCode&&76!==e.keyCode&&37!==e.keyCode&&72!==e.keyCode||(t=39===e.keyCode||76===e.keyCode,o.classList.contains("kint-show")?l.toggleChildren(o,t):t||(a=l.getParentHeader(o.parentNode.parentNode,!0))&&(l.keyboardNav.setCursor((o=a).querySelector("nav")),l.keyboardNav.sync()),l.toggle(o,t),l.keyboardNav.fetchTargets(),e.preventDefault())}},!0),l}()),window.kintShared.runOnce(window.kintRich.initLoad); void 0===window.kintMicrotimeInitialized&&(window.kintMicrotimeInitialized=1,window.addEventListener("load",function(){"use strict";var a={},t=Array.prototype.slice.call(document.querySelectorAll("[data-kint-microtime-group]"),0);t.forEach(function(t){var i,e;t.querySelector(".kint-microtime-lap")&&(i=t.getAttribute("data-kint-microtime-group"),e=parseFloat(t.querySelector(".kint-microtime-lap").innerHTML),t=parseFloat(t.querySelector(".kint-microtime-avg").innerHTML),void 0===a[i]&&(a[i]={}),(void 0===a[i].min||a[i].min>e)&&(a[i].min=e),(void 0===a[i].max||a[i].max<e)&&(a[i].max=e),a[i].avg=t)}),t.forEach(function(t){var i,e,r,o,n=t.querySelector(".kint-microtime-lap");null!==n&&(i=parseFloat(n.textContent),o=t.dataset.kintMicrotimeGroup,e=a[o].avg,r=a[o].max,o=a[o].min,i!==(t.querySelector(".kint-microtime-avg").textContent=e)||i!==o||i!==r)&&(n.style.background=e<i?"hsl("+(40-40*((i-e)/(r-e)))+", 100%, 65%)":"hsl("+(40+80*(e===o?0:(e-i)/(e-o)))+", 100%, 65%)")})})); </script><style class="kint-rich-style">.kint-rich{font-size:13px;overflow-x:auto;white-space:nowrap;background:rgba(255,255,255,.9)}.kint-rich.kint-folder{position:fixed;bottom:0;left:0;right:0;z-index:999999;width:100%;margin:0;display:block}.kint-rich.kint-folder dd.kint-foldout{max-height:calc(100vh - 100px);padding-right:8px;overflow-y:scroll;display:none}.kint-rich.kint-folder dd.kint-foldout.kint-show{display:block}.kint-rich::selection,.kint-rich::-moz-selection,.kint-rich::-webkit-selection{background:#aaa;color:#1d1e1e}.kint-rich .kint-focused{box-shadow:0 0 3px 2px red}.kint-rich,.kint-rich::before,.kint-rich::after,.kint-rich *,.kint-rich *::before,.kint-rich *::after{box-sizing:border-box;border-radius:0;color:#1d1e1e;float:none !important;font-family:Consolas,Menlo,Monaco,Lucida Console,Liberation Mono,DejaVu Sans Mono,Bitstream Vera Sans Mono,Courier New,monospace,serif;line-height:15px;margin:0;padding:0;text-align:left}.kint-rich{margin:8px 0}.kint-rich dt,.kint-rich dl{width:auto}.kint-rich dt,.kint-rich div.access-path{background:#f8f8f8;border:1px solid #d7d7d7;color:#1d1e1e;display:block;font-weight:bold;list-style:none outside none;overflow:auto;padding:4px}.kint-rich dt:hover,.kint-rich div.access-path:hover{border-color:#aaa}.kint-rich>dl dl{padding:0 0 0 12px}.kint-rich dt.kint-parent>nav,.kint-rich>footer>nav{background:url("data:image/svg+xml;base64,PHN2ZyB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciIHZpZXdCb3g9IjAgMCAzMCAxNTAiPjxwYXRoIGQ9Ik02IDdoMThsLTkgMTV6bTAgMzBoMThsLTkgMTV6bTAgNDVoMThsLTktMTV6bTAgMzBoMThsLTktMTV6bTAgMTJsMTggMThtLTE4IDBsMTgtMTgiIGZpbGw9IiM1NTUiLz48cGF0aCBkPSJNNiAxMjZsMTggMThtLTE4IDBsMTgtMTgiIHN0cm9rZS13aWR0aD0iMiIgc3Ryb2tlPSIjNTU1Ii8+PC9zdmc+") no-repeat scroll 0 0/15px 75px rgba(0,0,0,0);cursor:pointer;display:inline-block;height:15px;width:15px;margin-right:3px;vertical-align:middle}.kint-rich dt.kint-parent:hover>nav,.kint-rich>footer>nav:hover{background-position:0 25%}.kint-rich dt.kint-parent.kint-show>nav,.kint-rich>footer.kint-show>nav{background-position:0 50%}.kint-rich dt.kint-parent.kint-show:hover>nav,.kint-rich>footer.kint-show>nav:hover{background-position:0 75%}.kint-rich dt.kint-parent.kint-locked>nav{background-position:0 100%}.kint-rich dt.kint-parent+dd{display:none;border-left:1px dashed #d7d7d7}.kint-rich dt.kint-parent.kint-show+dd{display:block}.kint-rich var,.kint-rich var a{color:#06f;font-style:normal}.kint-rich dt:hover var,.kint-rich dt:hover var a{color:red}.kint-rich dfn{font-style:normal;font-family:monospace;color:#1d1e1e}.kint-rich pre{color:#1d1e1e;margin:0 0 0 12px;padding:5px;overflow-y:hidden;border-top:0;border:1px solid #d7d7d7;background:#f8f8f8;display:block;word-break:normal}.kint-rich .kint-popup-trigger,.kint-rich .kint-access-path-trigger,.kint-rich .kint-search-trigger{background:rgba(29,30,30,.8);border-radius:3px;height:16px;font-size:16px;margin-left:5px;font-weight:bold;width:16px;text-align:center;float:right !important;cursor:pointer;color:#f8f8f8;position:relative;overflow:hidden;line-height:17.6px}.kint-rich .kint-popup-trigger:hover,.kint-rich .kint-access-path-trigger:hover,.kint-rich .kint-search-trigger:hover{color:#1d1e1e;background:#f8f8f8}.kint-rich dt.kint-parent>.kint-popup-trigger{line-height:19.2px}.kint-rich .kint-search-trigger{font-size:20px}.kint-rich input.kint-search{display:none;border:1px solid #d7d7d7;border-top-width:0;border-bottom-width:0;padding:4px;float:right !important;margin:-4px 0;color:#1d1e1e;background:#f8f8f8;height:24px;width:160px;position:relative;z-index:100}.kint-rich input.kint-search.kint-show{display:block}.kint-rich .kint-search-root ul.kint-tabs>li:not(.kint-search-match){background:#f8f8f8;opacity:.5}.kint-rich .kint-search-root dl:not(.kint-search-match){opacity:.5}.kint-rich .kint-search-root dl:not(.kint-search-match)>dt{background:#f8f8f8}.kint-rich .kint-search-root dl:not(.kint-search-match) dl,.kint-rich .kint-search-root dl:not(.kint-search-match) ul.kint-tabs>li:not(.kint-search-match){opacity:1}.kint-rich div.access-path{background:#f8f8f8;display:none;margin-top:5px;padding:4px;white-space:pre}.kint-rich div.access-path.kint-show{display:block}.kint-rich footer{padding:0 3px 3px;font-size:9px;background:rgba(0,0,0,0)}.kint-rich footer>.kint-popup-trigger{background:rgba(0,0,0,0);color:#1d1e1e}.kint-rich footer nav{height:10px;width:10px;background-size:10px 50px}.kint-rich footer>ol{display:none;margin-left:32px}.kint-rich footer.kint-show>ol{display:block}.kint-rich a{color:#1d1e1e;text-shadow:none;text-decoration:underline}.kint-rich a:hover{color:#1d1e1e;border-bottom:1px dotted #1d1e1e}.kint-rich ul{list-style:none;padding-left:12px}.kint-rich ul:not(.kint-tabs) li{border-left:1px dashed #d7d7d7}.kint-rich ul:not(.kint-tabs) li>dl{border-left:none}.kint-rich ul.kint-tabs{margin:0 0 0 12px;padding-left:0;background:#f8f8f8;border:1px solid #d7d7d7;border-top:0}.kint-rich ul.kint-tabs>li{background:#f8f8f8;border:1px solid #d7d7d7;cursor:pointer;display:inline-block;height:24px;margin:2px;padding:0 12px;vertical-align:top}.kint-rich ul.kint-tabs>li:hover,.kint-rich ul.kint-tabs>li.kint-active-tab:hover{border-color:#aaa;color:red}.kint-rich ul.kint-tabs>li.kint-active-tab{background:#f8f8f8;border-top:0;margin-top:-1px;height:27px;line-height:24px}.kint-rich ul.kint-tabs>li:not(.kint-active-tab){line-height:20px}.kint-rich ul.kint-tabs li+li{margin-left:0}.kint-rich ul.kint-tab-contents>li{display:none}.kint-rich ul.kint-tab-contents>li.kint-show{display:block}.kint-rich dt:hover+dd>ul>li.kint-active-tab{border-color:#aaa;color:red}.kint-rich dt>.kint-color-preview{width:16px;height:16px;display:inline-block;vertical-align:middle;margin-left:10px;border:1px solid #d7d7d7;background-color:#ccc;background-image:url('data:image/svg+xml;utf8,<svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 2 2"><path fill="%23FFF" d="M0 0h1v2h1V1H0z"/></svg>');background-size:100%}.kint-rich dt>.kint-color-preview:hover{border-color:#aaa}.kint-rich dt>.kint-color-preview>div{width:100%;height:100%}.kint-rich table{border-collapse:collapse;empty-cells:show;border-spacing:0}.kint-rich table *{font-size:12px}.kint-rich table dt{background:none;padding:2px}.kint-rich table dt .kint-parent{min-width:100%;overflow:hidden;text-overflow:ellipsis;white-space:nowrap}.kint-rich table td,.kint-rich table th{border:1px solid #d7d7d7;padding:2px;vertical-align:center}.kint-rich table th{cursor:alias}.kint-rich table td:first-child,.kint-rich table th{font-weight:bold;background:#f8f8f8;color:#1d1e1e}.kint-rich table td{background:#f8f8f8;white-space:pre}.kint-rich table td>dl{padding:0}.kint-rich table pre{border-top:0;border-right:0}.kint-rich table thead th:first-child{background:none;border:0}.kint-rich table tr:hover>td{box-shadow:0 0 1px 0 #aaa inset}.kint-rich table tr:hover var{color:red}.kint-rich table ul.kint-tabs li.kint-active-tab{height:20px;line-height:17px}.kint-rich pre.kint-source{margin-left:-1px}.kint-rich pre.kint-source[data-kint-filename]:before{display:block;content:attr(data-kint-filename);margin-bottom:4px;padding-bottom:4px;border-bottom:1px solid #f8f8f8}.kint-rich pre.kint-source>div:before{display:inline-block;content:counter(kint-l);counter-increment:kint-l;border-right:1px solid #aaa;padding-right:8px;margin-right:8px}.kint-rich pre.kint-source>div.kint-highlight{background:#f8f8f8}.kint-rich .kint-microtime-lap{text-shadow:-1px 0 #aaa,0 1px #aaa,1px 0 #aaa,0 -1px #aaa;color:#f8f8f8;font-weight:bold}input.kint-note-input{width:100%}.kint-rich .kint-focused{box-shadow:0 0 3px 2px red}.kint-rich dt{font-weight:normal}.kint-rich dt.kint-parent{margin-top:4px}.kint-rich dl dl{margin-top:4px;padding-left:25px;border-left:none}.kint-rich>dl>dt{background:#f8f8f8}.kint-rich ul{margin:0;padding-left:0}.kint-rich ul:not(.kint-tabs)>li{border-left:0}.kint-rich ul.kint-tabs{background:#f8f8f8;border:1px solid #d7d7d7;border-width:0 1px 1px 1px;padding:4px 0 0 12px;margin-left:-1px;margin-top:-1px}.kint-rich ul.kint-tabs li,.kint-rich ul.kint-tabs li+li{margin:0 0 0 4px}.kint-rich ul.kint-tabs li{border-bottom-width:0;height:25px}.kint-rich ul.kint-tabs li:first-child{margin-left:0}.kint-rich ul.kint-tabs li.kint-active-tab{border-top:1px solid #d7d7d7;background:#fff;font-weight:bold;padding-top:0;border-bottom:1px solid #fff !important;margin-bottom:-1px}.kint-rich ul.kint-tabs li.kint-active-tab:hover{border-bottom:1px solid #fff}.kint-rich ul>li>pre{border:1px solid #d7d7d7}.kint-rich dt:hover+dd>ul{border-color:#aaa}.kint-rich pre{background:#fff;margin-top:4px;margin-left:25px}.kint-rich .kint-source{margin-left:-1px}.kint-rich .kint-source .kint-highlight{background:#cfc}.kint-rich .kint-parent.kint-show>.kint-search{border-bottom-width:1px}.kint-rich table td{background:#fff}.kint-rich table td>dl{padding:0;margin:0}.kint-rich table td>dl>dt.kint-parent{margin:0}.kint-rich table td:first-child,.kint-rich table td,.kint-rich table th{padding:2px 4px}.kint-rich table dd,.kint-rich table dt{background:#fff}.kint-rich table tr:hover>td{box-shadow:none;background:#cfc} </style>
<meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1">
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet"> <link rel="stylesheet" href="https://cdn.datatables.net/2.0.0/css/dataTables.dataTables.css" /> <link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/[email protected]/font/bootstrap-icons.min.css" /> <link href="/assets/admin/css/script.css" rel="stylesheet"> <link href="/assets/admin/css/style.css" rel="stylesheet">
<title>Veldhoeve API</title>
</head> <body> <div class="d-flex" id="wrapper"> <div id="page-content-wrapper"> <nav class="navbar navbar-expand-lg navbar-light bg-light border-bottom"> <div class="container-fluid"> <span>Veldhoeve API</span> <button class="navbar-toggler" type="button" data-bs-toggle="collapse" data-bs-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation"><span class="navbar-toggler-icon"></span></button> <div class="collapse navbar-collapse" id="navbarSupportedContent"> <ul class="navbar-nav ms-auto mt-2 mt-lg-0"> <li class="nav-item active"><a class="nav-link" href="/admin/dashboard"><i class="bi bi-speedometer"></i> Dashboard</a></li> <li class="nav-item dropdown"> <a class="nav-link dropdown-toggle" id="navbarDropdown" href="#" role="button" data-bs-toggle="dropdown" aria-haspopup="true" aria-expanded="false"><i class="bi bi-card-checklist"></i> Keuringen</a> <div class="dropdown-menu dropdown-menu-end" aria-labelledby="navbarDropdown"> <a class="dropdown-item" href="/admin/shows">Overzicht</a> <a class="dropdown-item" href="/admin/shows/create">Toevoegen</a> <!-- <div class="dropdown-divider"></div> <a class="dropdown-item" href="">Something else here</a> --> </div> </li> <li class="nav-item"><a class="nav-link" href="/admin/logout"><i class="bi bi-box-arrow-right"></i> Uitloggen</a> </ul> </div> </div> </nav> <div class="container-fluid mt-2"> <div class="container-fluid"> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-12"> <h3>Keuring overzicht</h3> <p><button type="button" class="btn btn-primary bi bi-backspace-fill" onclick="location.href = '/admin/shows'"> Terug naar overzicht</button></p> </div> </div> <div class="row"> <div class="col-md-12"> <div class="card"> <h5 class="card-header"> Jesseren </h5> <div class="card-body"> <p class="card-text"> <table class="col-md-2"> <tr> <td><b>Datum</td> <td>19-06-2024</td> </tr> <tr> <td><b>Tijd</b></td> <td>10:00</td> </tr> <tr> <td><b>Locatie</b></td> <td>Jesseren </td> </tr> <tr> <td><b>Type</b></td> <td>Club</td> </tr> </table> </p>
<span><b>Notitie:</b><br />test</span> </div> </div> </div> </div> </div> </div>
<div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-12 mt-4"> <table class="mb-5 mt-3 w-25"> <thead> <tr> <th>Categorie</th> <th>Aantal</th> </tr> </thead> <tbody> <tr> <td>Boklam</td> <td>6</td> </tr> <tr> <td>Jeugdbok</td> <td>3</td> </tr> <tr> <td>Jongerebok</td> <td>2</td> </tr> <tr> <td>Ouderebok</td> <td>2</td> </tr> <tr> <td>Veteranenbok</td> <td>1</td> </tr> <tr> <td>Geitlam</td> <td>5</td> </tr> <tr> <td>Jeugdgeit</td> <td>2</td> </tr> <tr> <td>Jongeregeit</td> <td>2</td> </tr> <tr> <td>Ouderegeit</td> <td>6</td> </tr> <tr> <td>Veteranengeit</td> <td>4</td> </tr> </tbody> </table> </div> </div> </div> </div> <div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-12 mt-4">
<form action="/admin/shows/24/view/getAnimalData" method="post"> <div class="input-group mb-3 mt-3"> <input type="text" class="form-control" placeholder="Dier toevoegen" name="animal_id" id="animal_id"> <div class="input-group-append"><button class="btn btn-outline-secondary" type="submit">Zoeken</button></div> </div> </form> </div>
</div> <div class="row"> <div class="col-md-12">
</div> </div> </div> </div>
<div class="row"> <div class="col-md-12"> <div class="row"> <div class="col-md-12 mt-4 mb-5">
<form action="/admin/shows/24/view/saveMatchData" method="post"> <input type="hidden" name="form_action" value="save_match_number" /> <table class="table table-hover table-striped"> <thead> <tr> <th>Voorbrengnummer</th> <th>Rubriek</th> <th>Naam</th> <th>Categorie</th> <th>Geboortedatum</th> <th>Registratienummer</th> <th>Eigenaar</th> <th>Actie</th> </tr> </thead> <tbody> <tr> <input type="hidden" name="participant_animal[]" value="NN24-247" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="2" maxlength="3" size="3" /></td> <td></td> <td>Valeriaan 18 v.d. Optimist</td> <td>Boklam</td> <td>27-03-2024</td> <td>NN24-247</td> <td>P. Sibma</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-247" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="WAP042" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="3" maxlength="3" size="3" /></td> <td></td> <td>Iep v.d. Leemputten</td> <td>Ouderebok</td> <td>13-05-2021</td> <td>WAP042</td> <td>R. Dijck, van</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/WAP042" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="OAP065" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="4" maxlength="3" size="3" /></td> <td></td> <td>Narco v.h. Grensdörpke</td> <td>Ouderebok</td> <td>14-04-2021</td> <td>OAP065</td> <td>J.G.G. Buiting</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/OAP065" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-208" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="5" maxlength="3" size="3" /></td> <td></td> <td>Linde v.d. Oldehove</td> <td>Geitlam</td> <td>24-03-2024</td> <td>NN24-208</td> <td>R. Dijkstra</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-208" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-209" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="6" maxlength="3" size="3" /></td> <td></td> <td>Sinne v.d. Oldehove</td> <td>Geitlam</td> <td>24-03-2024</td> <td>NN24-209</td> <td>R. Dijkstra</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-209" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-217" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="7" maxlength="3" size="3" /></td> <td></td> <td>Janis 553 v.d. Kikkert</td> <td>Geitlam</td> <td>23-03-2024</td> <td>NN24-217</td> <td>J. Laning</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-217" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="ON23-282" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="8" maxlength="3" size="3" /></td> <td></td> <td>Meghan v.h. Laar</td> <td>Jeugdgeit</td> <td>26-09-2023</td> <td>ON23-282</td> <td>Het Laar Gemeente Ommen t.a.v. R. Boezelman</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/ON23-282" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="ON23-281" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="9" maxlength="3" size="3" /></td> <td></td> <td>Elis 22 v.h. Laar</td> <td>Jeugdgeit</td> <td>02-09-2023</td> <td>ON23-281</td> <td>Het Laar Gemeente Ommen t.a.v. R. Boezelman</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/ON23-281" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NAR276" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="10" maxlength="3" size="3" /></td> <td></td> <td>Linsy v.d. Weerehoeve</td> <td>Jongeregeit</td> <td>11-05-2022</td> <td>NAR276</td> <td>A. Smit</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NAR276" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="CAR018" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="11" maxlength="3" size="3" /></td> <td></td> <td>Cissy v.h. Höfke</td> <td>Jongeregeit</td> <td>29-04-2022</td> <td>CAR018</td> <td>A.P.M. Lier,van</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/CAR018" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-246" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="12" maxlength="3" size="3" /></td> <td></td> <td>Catharina</td> <td>Geitlam</td> <td>26-03-2024</td> <td>NN24-246</td> <td>G. van der Meer</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-246" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="CAR051" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="13" maxlength="3" size="3" /></td> <td></td> <td>Camel v.h. Höfke</td> <td>Jongerebok</td> <td>19-06-2022</td> <td>CAR051</td> <td>E.H.P.J. Weijer, van de</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/CAR051" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="CAR061" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="14" maxlength="3" size="3" /></td> <td></td> <td>Gijs</td> <td>Jongerebok</td> <td>09-09-2022</td> <td>CAR061</td> <td>J. Blok</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/CAR061" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN23-296" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="15" maxlength="3" size="3" /></td> <td></td> <td>Yuki v.d. Empne</td> <td>Jeugdbok</td> <td>13-05-2023</td> <td>NN23-296</td> <td>. WILDLANDS</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN23-296" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="ME 657" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="16" maxlength="3" size="3" /></td> <td></td> <td>Kittie v.Beulekamp</td> <td>Veteranengeit</td> <td>30-11--0001</td> <td>ME 657</td> <td>H. Pol v.d.</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/ME 657" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="BS 233" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="17" maxlength="3" size="3" /></td> <td></td> <td>Adelina v.d.Venkanthoeve</td> <td>Veteranengeit</td> <td>12-01-1980</td> <td>BS 233</td> <td>L. Doelen, v.d.</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/BS 233" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NSS684" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="20" maxlength="3" size="3" /></td> <td></td> <td>Ottelien v. Tronde ût Elsloo</td> <td>Veteranengeit</td> <td>31-12-2000</td> <td>NSS684</td> <td>C.O. Rosema</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NSS684" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN23-279" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="21" maxlength="3" size="3" /></td> <td></td> <td>Spot</td> <td>Jeugdbok</td> <td>20-05-2023</td> <td>NN23-279</td> <td>T. Leenstra</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN23-279" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN23-290" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="22" maxlength="3" size="3" /></td> <td></td> <td>Rothko v.d. Veenhorst</td> <td>Jeugdbok</td> <td>17-05-2023</td> <td>NN23-290</td> <td>A. Blokzijl</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN23-290" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-190" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="23" maxlength="3" size="3" /></td> <td></td> <td>Valeriaan 17 v.d. Optimist</td> <td>Boklam</td> <td>11-03-2024</td> <td>NN24-190</td> <td>P. Sibma</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-190" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NH24-001" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="23" maxlength="3" size="3" /></td> <td></td> <td>Jan</td> <td>Boklam</td> <td>02-01-2024</td> <td>NH24-001</td> <td>K. van Nispen</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NH24-001" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-161" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="24" maxlength="3" size="3" /></td> <td></td> <td>Timo van Beniwenfra</td> <td>Boklam</td> <td>01-03-2024</td> <td>NN24-161</td> <td>B.A. de Boer</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-161" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-065" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="25" maxlength="3" size="3" /></td> <td></td> <td>Hotse 56 fan Lytse Wâld</td> <td>Boklam</td> <td>29-01-2024</td> <td>NN24-065</td> <td>F. & M. Solle</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-065" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-073" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="35" maxlength="3" size="3" /></td> <td></td> <td>Mees van de Chevrettehoeve</td> <td>Boklam</td> <td>03-02-2024</td> <td>NN24-073</td> <td>J. de Vries</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-073" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="ORR615" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="46" maxlength="3" size="3" /></td> <td></td> <td>Amor 31 v.d. Jagershoeve</td> <td>Veteranenbok</td> <td>12-08-1999</td> <td>ORR615</td> <td>H.G. Jager, de</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/ORR615" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="A14001" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="99" maxlength="3" size="3" /></td> <td></td> <td>Fien van Hoeve de Gracht</td> <td>Veteranengeit</td> <td>06-01-2014</td> <td>A14001</td> <td>G. Van Dyck Gert</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/A14001" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> <tr> <input type="hidden" name="participant_animal[]" value="NN24-072" />
<td><input type="text" name ="participant_match_number[]" onkeypress="return /[0-9]/i.test(event.key)" value="99" maxlength="3" size="3" /></td> <td></td> <td>X-ell fan Lytse Wâld</td> <td>Geitlam</td> <td>27-01-2024</td> <td>NN24-072</td> <td>F. & M. Solle</td> <td> <!-- <a href="/admin/shows/24/view/deleteAnimalFromShow/NN24-072" class="table-icon" onclick="return confirm('Weet je het zeker?')"><i class="bi bi-trash3"></i> --> </td> </tr> </tbody> </table> <div class="formbuilder-button form-group field-formSubmit"> <button type="submit" class="btn-success btn" name="formSubmit" style="success"> <span class="bi bi-calculator-fill"> Berekenen</span> </button> <button type="reset" class="btn-warning btn" name="formReset" style="warning" onclick="if (confirm('Weet je het zeker?')) window.location.href='/admin/shows/24/view/resetMatchNumbers';"> <span class="bi bi-arrow-clockwise"> Opnieuw invullen</span> </button> </div> </form> </div> </div> </div> </div> </div>
</div> </div> </div> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.bundle.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/jquery.min.js"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/5.3.0/js/bootstrap.bundle.min.js"></script> <script src="https://cdn.datatables.net/2.0.0/js/dataTables.js"></script> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/jquery-ui.min.js"></script> <script src="https://cdn.jsdelivr.net/npm/[email protected]/dist/js/bootstrap.min.js"></script> <script src="/assets/admin/js/app.js"></script>
</body> </html> <!-- DEBUG-VIEW ENDED 1 APPPATH/Views/admin/layouts/default.php -->
<!-- DEBUG-VIEW ENDED 2 APPPATH/Views/admin/shows/view.php -->
(04-19-2024, 01:00 AM)paulkd Wrote: Sorry,
I meant the actual rendered HTML table, like if I used "view source" in the browser.
Just a few rows would be enough.
Oh, I did copy paste the full page source haha.
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
HarmW94 Junior Member
 
-
Posts: 20
Threads: 6
Joined: Dec 2023
Reputation:
0
Hi,
Is it possible to calculate this in the database? I've tried so many queries but without the result I want because SQL is not my expertise...
Or I've to re-write my script because right now it's working but the code is bad.
Suggestions?
<?php echo "Programming and perfectionism sucks sometimes..."; ?>
-
paulkd Member
  
-
Posts: 76
Threads: 17
Joined: Oct 2015
Reputation:
0
Hi,
Sorry it's taken a while to come back, I didn't get an alert to your HTML posting, but I did get an alert to the last post.
What SQL engine are you using (e.g. MySQL, Postgres, MariaDB) ?
|