Problem I have a pandas DataFrame and a (MySQL) database with the same columns. The database is not managed by […]
Category: MySQL
All-core MediaWiki website upgrade script
Problem I wrote the following Bash script to upgrade All-core MediaWiki websites (no added extensions/skins or images – besides logo […]
Did you like my product?
Problem I have the following MySQL query which selects product details and whether the viewing user likes them. I feel […]
Object-oriented shopping cart
Problem I have just started to try and learn ‘OOP’ but it appears I’m doing this wrong, according to the […]
Periodic Table and Simulation of Elements
Problem I’ve been working on my first real “project” and decided to make the periodic table that can simulate each […]
PHP PDO statements
Problem I wrote a piece of code. and to be honest it seems a bit messy so I would like […]
A like/unlike system using MySQL and PDO
Problem I have created a Like/Unlike system. The user clicks one to indicate a “like”, and clicks again to “unlike” […]
Database design for an online learning application
Problem It is an online learning application with different types of learnable items, that different users learn. The users learn […]
SELECTing percentage and count of votes
Problem I have the following tables structures: CREATE TABLE IF NOT EXISTS `options` ( `option_id` tinyint(4) unsigned NOT NULL, `poll_id` […]
Database schema for a Minecraft logging plugin
Problem This is my attempt at creating a database schema for a Minecraft logging plugin. I’m by no means a […]