Problem Recently I started working with TinyMVC, wrote a simple menu model and I have few questions for those who […]
Category: MySQL
DB abstraction, private methods in OOP PHP library
Problem This library registers a new user. Questions: Where should the DB class instantiation happen for user class? I tried […]
Connect to database, handling errors
Problem I try to handle or catch possible errors with PHP/MySQL for security reasons and would like to know if […]
SQL query to find expenditures of employees who have exceeded their limit
Problem I’ve 2 tables emp and expenditure. Emp: ID, NAME Expenditure: ID, EMP_ID, AMOUNT Each emp has a limit of […]
Code tidy-up for multiple queries
Problem I have the following code that I know can be written in a better way. Basically I query tables […]
Joining tables by skipping the intermediate parent table [closed]
Problem Closed. This question is off-topic. It is not currently accepting answers. Lacks concrete context: Code Review requires concrete code […]
A class which represents an SQL table
Problem I’m representing DB tables as classes (in this case PHP classes). This has the goal of modeling every section […]
Safely storing and output data
Problem On my application I use this method to store and to output the data. I would like to know […]
Adding more fields to a Questionnaire in a CRUD system
Problem Background on Project When a customer orders a machine, I have to do something called a telephone site survey, […]
MySQL JDBC integration into App from tutorial
Problem I was following this tutorial for JavaFX and Gradle: JavaFX with Gradle, Eclipse and, Scene Builder on OpenJDK11 After […]