Author: KevenD

  • Validation for league CSV

    I love league/csv. However I often want to do validation for the files people are uploading or my site is scraping. To make this easier I decided to write a class to make this faster to implement instead of rewriting it over and over. I included in it a few common validators are included such…

  • JQuery Ajaxize Forms

    Sometimes you just want a form to push through ajax without having to write so much dang code. To this end I have a universal function I include in a few of my admin area sites which have a lot of little forms which need easy access to ajax posting and here’s the jquery I…

  • PHP PDO qrs()

    So I started working with Web Development using ASP and still mentally think of SQL calls in my mind as “RecordSets” so when I went to make PDO faster to access data in my code I created a function called qrs() which stands for “Quick Record Set”. This also wraps a “SafePDO” extension to the…

  • SQL PROCEDURE: getAsJSON(schema,name,where)

    So there doesn’t seem to be a convenient way to retrieve an asterisk of a table to a JSON in mySQL natively so this simple procedure does the job for me. Execution is simple. {“Eventid”: 52658, “Seasoncode”: 2023, “Sectorcode”: “AL”, “Eventname”: “UAE PARA Alpine Competition – Asia Cup”, “Startdate”: “2022-11-06”, “Enddate”: “2022-11-07”, “Nationcodeplace”: “UAE”, “Orgnationcode”:…