MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.
2
votes
0answers
20 views
Custom session handler
I'm new to PDO and haven't been coding in a while. Is the following custom session handler industry-acceptable?
...
3
votes
1answer
32 views
Join - order by vote-sum and check if user has voted
I have a vote and a comment table. Now I want to display all comments and order them by votes-sum. Sum because some votes can have a higher value than others.
Therefore I want to display if the user ...
3
votes
3answers
131 views
Cron PHP script to pull newly added clients from remote db, add their information to local db
I wrote a PHP script and was wondering if it was well written or if it could be improved upon to read or run more efficiently, any help or critique would be greatly appreciated.
The file will be ...
3
votes
2answers
49 views
Small library for logging to MySQL
I've thrown together a utility for my programs to log to a database, but the code looks like a mess and I don't know how to clean it up. This library is going to be used from all of my other programs ...
5
votes
1answer
27 views
Implementing EXCEPT functionality for social networking exercise
I am taking Stanford's Introduction to Databases Self-Paced online course. I have gone through the videos in the SQL mini-course, and I am having trouble completing the exercises.
The following is ...
2
votes
1answer
20 views
Simplify SQL query that utilizes GROUP BY and HAVING BY and uses aggregation
I am taking Stanford's Introduction to Databases Self-Paced online course. I have gone through the videos in the SQL mini-course, and I am having trouble completing the exercises.
The following is ...
3
votes
2answers
80 views
Is my login system secure?
I am recently making a CMS and I need a secure login system, so this is my code. How is it?
First: the HTMLcode for signup and login:
...
3
votes
1answer
36 views
Query about advertiser calls times out
I'm a bit of a rookie MySQL coder and I've been tasked with building a query that will join and filter several very large tables (one with ~210 million rows, one with 10 million, one with 2.5 million, ...
5
votes
3answers
50 views
Performing database interactions
I wrote this CRUD class in PHP that has methods to do database interactions, but I want to know if it is good/secure/elegant?
It works fine and all and it hasn't ever given me any troubles, but I'm ...
3
votes
2answers
94 views
Finding max rating for a movie
I am taking Stanford's Introduction to Databases Self-Paced online course. I have gone through the videos in the SQL mini-course, and I am having trouble completing the exercises.
The following is ...
0
votes
1answer
31 views
3
votes
2answers
71 views
Displaying a random poem from a database
I'm new to web development, and I'm constantly torn between good code and bad code. I was wondering if you could help me improve my following code and see if I'm doing it right in terms of how I use ...
-1
votes
1answer
68 views
Php code not efficient [closed]
This code works but I am assuming it is very inefficient.
Basically it does:
Add to the variable $a if the scoreavg is over 3
...
2
votes
1answer
35 views
SMS relay --> MySQL database
The main purpose of my program is to extract GPS information from text messages sent to several GSM modems send from various GPS tracking devices. The main flow of my program loops in three steps:
...
0
votes
0answers
7 views
Using a Drupal function to return ranked results [migrated]
I need some help with my syntax. I've posted some code below but I'm unsure about the SQL and the PHP code that follows it. Note that this is for a custom Drupal form module.
This is just the ...
2
votes
1answer
57 views
Open source Pastebin tool made in JSP and servlet
I'm a student and still studying. I just made my own Pastebin tool to generate source code. I've also contributed this project as an open source. You could see this project from here.
If you wish to ...
5
votes
2answers
70 views
Optimise web panel users statistics query
Details
Can anyone instruct me on a more optimised way of querying this statistics of registered users? I currently lack the knowledge to create a better query. Right now it works fine, but I want ...
1
vote
1answer
38 views
Magento MySQL search based on phone number
I'm building a search for Magento. Magento API doesn't provide an easy way to look up a customer using a phone number so I created a custom solution. My MySQL/PHP OOP skills are limited. Did I miss ...
2
votes
1answer
37 views
SQL query to order by the difference between FIRST and BEST scores
Can anyone help me optimise this query? I have the following table:
...
2
votes
1answer
54 views
Uploading images via MySQL in Blob
Is it safe to upload images via MySQL in Blob? I've constructed my code like the following:
...
1
vote
0answers
32 views
Selecting all posts with a certain tag
The task is to select all posts tagged with a certain tag, along with other tags the post may have, given as text rather than ID.
Table posts
...
1
vote
1answer
39 views
Handling errors when using PDO to connect to a database instead of MySQLi
What would be the preferred method for handling errors when using the PDO to connect to a MySQL database? I was using mysqli_error($this->pdo), but I heard this ...
2
votes
4answers
66 views
Selecting three stylesheets in a specific order
I'm somewhat new to SQL (only had to use it in Database classes). I have a simple table of stylesheets, from which I want to select specific ones in a specific order (e.g. reset, then layout, then ...
3
votes
0answers
45 views
Instagram-like news feed display
I am writing an application that shows a news feed, much like Instagram. For this, I have a function in the model to select the feeds as shown in the code. For some reason, this runs quite slow and I ...
2
votes
0answers
66 views
Programming with PHP & jQuery
I'm programming a system and I want to know if this is the correct way or if there are a better way to do it.
Container:
I have more fields but I only added one to show you the container.
...
1
vote
2answers
84 views
Class for multithreaded insert into database
Here I have class that supposed to take dictionaries of product objects and their articles (kind of unique identifier) from queue and insert or update them in database table.
Received dictionary ...
1
vote
3answers
79 views
Looping to update article codes on one server based on queries on another server
I've read somewhere on Stack Overflow that doing queries in a loop is very inefficient. It will hammer your SQL server and make your script very slow.
Sample code:
...
3
votes
1answer
71 views
Inserting data into database
I started learning PHP and MySQL, was using MySQL_ functions. Then I learned they are deprecated, had to choose between PDO and MySQL. I chose MySQL and started using it.
As I learn OOP PHP, I ...
5
votes
1answer
40 views
Slow query joining orders and products
The end result I am trying to achieve is an array containing the total ordered qty for each product. I have been successful but the query takes about 20 minutes to run and I'm wondering if there is ...
4
votes
1answer
103 views
Fetching objects and adding a calculated field in Doctrine 2
I'm making a section that shows a list of blogs and how many comments it has without loading any comment data. My Blog entity is as follows:
...
5
votes
2answers
83 views
Inserting values of Date type into a MySQL database
I have got a JTable implementing a TableModel interface. There are ID (primary key, ...
2
votes
1answer
21 views
4
votes
2answers
261 views
My method of escaping MySQL strings in C++
This is how I'm currently escaping MySQL strings in C++:
...
2
votes
3answers
80 views
A class which represents an SQL table
I'm representing DB tables as classes (in this case PHP classes). This has the goal of modeling every section of the web page, where you will get inputs from the user.
My actual base design is:
One ...
1
vote
2answers
108 views
PDO class extend
I am moving in to OOP PHP and having some problems extending my database class to my objects. I am still new to the variable scoping in OOP PHP, so if it a tiny syntax error I apologize. If my ...
5
votes
1answer
62 views
TrackDAO: what can be improved?
In this specific situation there is a table with trackdata and a form to add rows. For the sake of clarity I won't include the view-related code here. The added rows are added to a LinkedList when ...
3
votes
1answer
56 views
JOIN and sprintf rather than two queries and echo
It works fine, however it's a little messy. I understand it would be better for performance to use JOIN and have been advised before to use sprintf. However, it's ...
1
vote
1answer
37 views
Web Service implementation on the client
I will be creating a web service as part of a group project for university, which will be developed using Java within the Eclipse IDE.
Having no prior experience using web services, I managed to ...
4
votes
2answers
1k views
Possible SQL injection vulnerability searching for a product by ID?
I want to be sure that this isn't vulnerable to SQL injection. If yes, then how can it be improved?
...
1
vote
2answers
50 views
Safety of globalizing config data
I have some framework in PHP/MySQL for developing web services. Finally my code works on two servers - production and developer. My idea is to create one code without differences, which will work ...
1
vote
2answers
53 views
Inserting e-mail subscribers into MySQL
I'm new to Python and I am learning database connections from here.
This is the code I am using to insert e-mail subscribers into a table:
...
4
votes
2answers
240 views
Calculator using PHP with logging to MySQL database
I have made a calculator in PHP and I need some feedback in terms of security and performance or any other general improvements.
You can download a zip file with all the contents from this link if ...
3
votes
1answer
60 views
Checking if my code is secure
I'm deploying a PHP project, and I always try to use prepared statements, but unfortunately, GoDaddy does not have the mod mysqlnd which I use it for the function ...
0
votes
2answers
394 views
Connecting to a MySQL database with C#
Can anyone help me with checking this code? It is for connecting to a database. The method getFromDatabase is to take values from the database and put it to a ...
2
votes
1answer
32 views
Bash-based MySQL inventory scanner
I am trying to create a bash-based inventory scanner, and was wondering if there is anything 'glaringly' incorrect about my syntax or usage. I was hoping I could get some feedback on:
bash ...
2
votes
2answers
83 views
Querying multiple tables to pull data to show to the user
I have a function that I use to display a relatively large amount of data to the user:
...
4
votes
2answers
82 views
Find minutes with no data in database
I'm trying to show a table, for each ID, to see if there is data available. In this case, its measurements. If there's no data, that means the logger isn't doing its job properly.
I currently have ...
6
votes
1answer
96 views
Entering information about a business and finding matches
I'm writing a Java Servlet application where the users must enter information about a business. I'd like to prevent as many duplicate entries in the MySQL database as possible and I'd appreciate ...
3
votes
1answer
131 views
Enhance CSV file database import
I'm using the script below to import a large .csv file to my database. If the table is empty the process takes about 5 minutes to finish on a local machine. If I'm using the file to update existing ...
0
votes
2answers
73 views
Django ListView with MySQL query for the queryset
(Note: Even if you don't know Django, it's probably the query that needs work anyway, so you probably don't need to know Django/Python)
I have a ListView that ...
