MySQL WHERE = OR =
How to do a MySQL WHERE query whilst filtering for multiple values from the different columns. An example being the need to SELECT data where name = value OR last_name …
Tag: MYSQL
MySQL COUNT where COUNT greater than
Using MySQL COUNT with GROUP BY gives the total occurrence of each value in the database as determined with what is Grouped by. See here or here for more information….
Storing and reading a JSON file in MySQL with PHP
Storing values from a json output into a database is a common occurence, but storing the whole json call into a column not so much. Traditionally it is more efficient…
MySQL count for multiple conditions
MySQL COUNT allows you to count rows in your MySQL database, a useful way to use this is to apply a condition like: SELECT COUNT(*) FROM invoices WHERE `paid` =…
PHP check if MySQL row found for query
If you want to check if a row will be returned using PHP and MySQL you can use mysqli_num_rows which counts how many rows will be returned from the query….
PHP MySQL injection; What, how and avoid
MySQL injection is the method in which “hackers” can get unauthorized data or inject it. Good news is that its easy to fix, bad news is that PHP code with…
Caching a MySQL HTML table with PHP
MySQL and PHP, the perfect match right?! Well close enough, anyway displaying a table with data from a MySQL database is a common task for a web developer. It’s easily…
MYSQL get Max and Min for each day
To get the Max and Min value of a column for each day in MYSQL with a WHERE clause: SELECT DATE(t.datetimecol), MAX(t.col1), MIN(t.col2) FROM TABLENAME t WHERE id = 1…
MySQL vs JSON for storing and reading data in PHP
I have always been curious about the handling and usability of data between a MySQL database and JSON files in PHP. I decided to do some reasonable case examples using…