MySQL is an open-source, relational database management system.
1
vote
1answer
42 views
How can this layered PHP architecture be improved?
This is my first "large scale" system I've designed for myself. Since I'm more of a front end developer than backend developer, I'm not sure if my architecture is sound.
I've created a Factory class ...
1
vote
1answer
23 views
PHP PDO mysql multiple queries mak
I ran into a problem, I'm using MyIsam tables in mysql database, using PDO to connect.
In all my tests (calling for 1 user everything works fine), now having around 300 users connected at the same ...
-1
votes
0answers
22 views
Object Oriented PHP - mysql database manipulation [closed]
Been working with this code but it won't run. Please help me find the problem with this.
THis is my class :
<?php
class mysqlcon
{
private $connection;
private $database;
public $query;
...
2
votes
1answer
74 views
Optimise this mysql query
This query is serving me a home page for users where a user can see all posts by him/her and his/her friends. This is an excellent query without any errors but i only wish to make it shorter if ...
4
votes
0answers
43 views
Code Reiview for an PHP PDO Queries? is there a better way to do it?
so this is my code for a equipping an item in my game dev't:
try {
$db = getConnection();
$db->beginTransaction();
$sql_chara_gold = $db->query("SELECT chara_gold ...
1
vote
2answers
32 views
Using AJAX to look up MySQL value using two dropdown inputs
I have a list of cities, and a set of "travel time" between any given two cities. The "travel time" is fixed and not necessarily dependent on absolute distance between the two cities, and it currently ...
2
votes
0answers
38 views
Practical advise for CMS
I'm working on a CMS system. The basis is pretty much done but before going any further I would like to know if there are things I really should change in the way I code things.
I am pretty sure ...
1
vote
2answers
79 views
Assist cleaning up messy HTML/PHP code
I really hate messy code, but I seem to be rolling in it. I just want to see if anyone has some helpful advice on how to tidy this up.
<table>
<tbody>
<tr>
<th>Zona</th>
...
1
vote
2answers
62 views
MySQL GEAR, C# class for ASP.NET project
I've developed my own class in ASP.NET project to access MySQL and make queries, scalars and read the result from it.
I want you to review my class and tell me where did I make a mistake, thanks!
...
0
votes
2answers
59 views
JSON API in C++ with Node.native, RapidJSON, and MySQL
Hey folks, I was hoping I might get some feedback and ideas for improvement on this, particularly the WebRouter class. Any tips or suggestions would be great!
#include <native/native.h>
...
2
votes
1answer
40 views
Is there a more optimized way for this MySql Query
with below query i'm getting the results that i want but it's quite slow taking nearly 0.2 seconds (on an i5 machine). Is there a more optimized way to get the same results.
Basically this query ...
2
votes
1answer
65 views
Better way to have output code?
When a user is created, deleted and update the system will give feed back. e.g. User Deleted/Updated/Create success or unsuccessfully, but I'm sure there is a better way to do it than what I have done ...
2
votes
1answer
65 views
Clean PHP IF Statement
This script updates a mySQL data with golf scores and calculates how many strokes under the player is in real time and is working. Just looking for a better way to make it cleaner and compact. Any ...
5
votes
2answers
162 views
Strategy to create audit trails for a SQL database
I wish to create audit trails for specific tables and columns in my database, and document who made the change, when it was made, and what the change was.
To do so, I will create the following ...
1
vote
4answers
179 views
Making this code 'more' OOP
I have just started to try and learn 'OOP' but it appears I'm doing this wrong, according to the people on StackOverflow the code below is far from Object Orientated, but I'm finding it hard as I'm ...
