Tag: mysql

  • 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”:…