All Questions
Tagged with object-oriented mysql
64 questions
2
votes
1
answer
314
views
PHP OOP: Configuring MySQL DB & query w/ Twig
I decided to up my PHP game and learn some OOP.
I am re-building my website from procedural to OOP, but since I don't want to use a full framework I fiddle with some components.
As a router I use ...
- 21
7
votes
2
answers
229
views
Connect to MYSQL database in PHP with prepared statements
I have recently learned about using the functions exposed by the PDO extension. I created a db class which can handle common actions like create, update, delete and select. Is this method a correct ...
- 173
4
votes
2
answers
304
views
OOP - Contact Form PHP Backend - Procedural to OOP - Dynamic MySQL Prepared Statement PHP
I just converted procedural code to OOP code. Is there any performance or security issue with this code or what should I consider further?
interface
...
- 51
4
votes
2
answers
457
views
API for SQL queries with PHP PDO
I'm writing a very simple CRUD application, and I'm wondering if the way I'm using static methods throughout the code makes sense. I'd very much like to simplify ...
- 143
1
vote
2
answers
134
views
Repeated DB connection at max user connections
I am trying to create class with connect to mysql database. And if there is max number of connections I want to wait and try it again. I figured out, how it can works, but I am not sure, if its the ...
- 169
2
votes
1
answer
447
views
PHP Mad Libs with OOP and SQL
I've been learning PHP and I've just gotten into using OOP. Classes/objects/methods etc. My end goal is to take an old Mad libs program I did with PHP, and convert it to OOP. The gist of the project ...
- 21
2
votes
0
answers
84
views
One class for MySQL and MSSQL Queries
EDIT BELOW
I am trying to create resusable classes for MSSQL and MySQL queries (later also Update and Delete queries). I tried it doing the OOP-way. Here is my result:
Einstellungen.vb:
...
- 21
4
votes
1
answer
25k
views
Basic object-oriented PHP login, logout, and registration scripts
I am new to OOP in general and have recently started trying to develop object-oriented PHP code instead of relying on a primarily procedural style, as this is a requirement for my studies. One part of ...
- 93
4
votes
1
answer
1k
views
PHP Application layers
I'm dealing with design layers of an application. Basically what I've so far are:
Business
Architecture: Client-Server
Techonologies: PHP+MySQL, HTML5, JS, 3rd parties APIs
My app
Data Sources: MySql ...
- 41
2
votes
3
answers
2k
views
Connection to MySQL database
I'd created a C# class to connect to a MySQL database (Connection.cs) and a separate class for the user validation (User.cs).
Connection.cs
...
- 21
1
vote
2
answers
1k
views
Custom PDO wrapper class
I somewhat recently asked a question on here for advice on a PDO function that I had written. I got some good advice from a user, and went with it. I had used that function for about 3 months which is ...
- 466
5
votes
1
answer
204
views
Automatic database migration system
Github here: https://github.com/cmancone/mygrations
I'm working on a different kind of database migration system for helping manage web applications. I asked a question about part of the system just ...
- 1,279
5
votes
1
answer
101
views
Resolving MySQL 1215 errors in a declarative MySQL migration system
Github here: https://github.com/cmancone/mygrations
I'm building a migration system for MySQL that operates in a very different way than the usual. Rather than recording changes in the database, the ...
- 1,279
8
votes
1
answer
222
views
A PHP API which has an endpoint for processing a user's facebook login details
I'm working on a PHP API for my angular JS Phonegap application.
At the moment I'm focusing on working with a user's facebook public profile data.
I'll explain the process a little first:
The user ...
- 401
5
votes
1
answer
6k
views
A Discord bot that connects to a local database (OOP)
I am currently working on a Discord bot as a way to learn and practice Python. I have been trying to learn object-oriented programming, and apply the "don't repeat yourself" principle.
The code ...
- 85