Count Distinct or Grouped Database Records in SQL
Sunday, April 7th, 2019 MySQL,Say you have a SQL database table which has some type of repeating items, like suburbs in a table of contacts, or categories in a […]
Adding Batch / Multiple SQL Insert Queries with PHP’s mysqli_multi_query()
Saturday, February 16th, 2019 MySQL, PHP,I had a project which required to insert a batch of mySQL database rows in one go with PHP. I firstly wrote the script to simply […]
6 Awesome mySQL Statements That I Always Forget
Friday, November 17th, 2017 MySQL, PHP,A collection of some the simplest SQL examples that I always forget. Order by Random Want to return your result in a random order, just […]
An example of coverting old-school PHP mysql to more secure mysqli
Saturday, March 25th, 2017 MySQL, PHP,A very common way hackers can break into your website database is via targeting outdated PHP code and unsecured get variables, especially when the code retrieves […]