Questions tagged [mysql]
MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.
1,090 questions
4
votes
2
answers
146
views
Polymorphic data models that save data to MySQL and restore data from MySQL
This is a follow up question to Inserting and retrieving data MySql Database access in C++ using Boost::ASIO and Boost::MySQL. I have reduced the amount of code to be reviewed by presenting only one ...
- 26.2k
2
votes
1
answer
91
views
My first attempt to insert and retrieve data from a MySQL database using the boost::mysql library
About the Project
This was a go/no go prototype for a project that would store the data a combined personal planner software with project planning software in a relational database. It was also a ...
- 26.2k
1
vote
0
answers
73
views
Inserting and retrieving data MySql Database access in C++ using Boost::ASIO and Boost::MySQL
About the Project
This is a unit test and a prototype for the database portion of a project that would store the data a combined personal planner software with project planning software in a ...
- 26.2k
2
votes
1
answer
70
views
Cmake build system for prototype planner software using boost and other previously written code
I'm prototyping/debugging some C++ code that I may turn into a longtime project. The build system is ready for review, the prototype is not.
The GitHub repository for the code listed below.
Like all ...
- 26.2k
6
votes
2
answers
739
views
Weather Observation Station 8 query
Here's my (correct) solution to a HackerRank question:
Weather Observation Station 8
Query the list of CITY names from STATION which have vowels (i.e., a, e, i, o, and u) as both their first and last ...
- 277
3
votes
1
answer
103
views
A function that returns correct number of inserted, updated and skipped rows for INSERT or UPDATE query
When MySQL executes a Data Modification Query, it provides some additional info on the outcome, which is usually displayed in the console. This info is also being exposed through MySQL C API and this ...
- 9,143
5
votes
3
answers
1k
views
Slow SQL query with nested subquery
I have written the below query in order to identify how many events (occur over a week) in each hour.
...
- 413
4
votes
2
answers
500
views
Improving upon the Security of my Export Remote Database to Local PHP API
I am working on an in-house application, and I am working on how our application communicates with our remote server.
I have a PHP script that acts as an API to call to our MySQL DB and dump its ...
- 43
7
votes
4
answers
2k
views
Program for an employee database using python
In this program I'm defining functions to perform different tasks on a data record book for employees.
Here is a summary of the code:
Intro() to make the presentation of the home page.
create_record()...
1
vote
0
answers
86
views
Connection pool design for Boost MySQL
I had to design a connection pool that handles Boost MySQL connection to use the asynchronous functions.
Here is the code:
...
- 41
3
votes
1
answer
166
views
Faster Query to Track State changes in a Large Table
I have a table that tracks state changes of an entity with timestamps. The schema of the table is as follows:
entityid
userid
originalvalue
newvalue
changetime
255
101
Draft
Submitted
2023-11-28 12:10:...
- 53
4
votes
1
answer
154
views
Evaluating Extended Operating Hours Past Midnight Across Timezones in PHP
I am working on a project that involves tracking the operating hours of businesses across different timezones. Some of these businesses operate past midnight, and to accommodate this, operating hours ...
- 433
2
votes
1
answer
277
views
8
votes
3
answers
1k
views
A simple PHP login form with PDO
I wrote a simple PHP login form for a website. It has an initialization script, as well as a form to allow a user to login, plus a link to log the user out after logging in.
...
- 601
3
votes
1
answer
141
views
Consuming sharded database using node.js
I think the only big improvement that can be made is to check which shard to query based on the userIds of the followed users. One easy way is to check the last ...
user225166
3
votes
1
answer
130
views
SQL query creating tables needed by a simple PHP CMS
I have written recently the SQL query to MariaDB that I want to move into PHP code. Below is my test.sql file. What do you think about my SQL code?
...
- 601
2
votes
1
answer
102
views
delete rows based on references to other tables in a mysql database?
I have a database with the following hierarchy.
A dataset can have multiple scans (foreign key scan.id_dataset -> dataset.id)
A scan can have multiple labels (<...
- 199
1
vote
1
answer
132
views
mySQL adjacency list model : Always retrieve parent and children/siblings
I’m using mySQL to create and adjacency list model type of table. I have only one level, that is a parent with children, like this:
...
- 239
0
votes
1
answer
103
views
PHP login codes suggestions
Now i have a fully functional PHP codes for login and registeration i was wondering if anyone could offer improvements to the code
The code:
Config.php:
...
- 47
0
votes
1
answer
213
views
Follow up to Validation Script in PHP
So I've implemented the suggestions in Original question
And now my code looks like this:
...
- 47
2
votes
1
answer
170
views
PHP Validation script
The code below is modified slightly from the code in this previous post.
I believe the code below could be improved and more secured but i don't know how so someone please show me how an improved ...
- 47
0
votes
1
answer
305
views
SQL & PHP login method
My code is working however it seems to be using old outdated php version so less secure and I'm still new to programming so I'd be more than thankful if someone shows me how an improved updated and ...
- 47
3
votes
1
answer
445
views
blog RESTFUL api with posts and comments
I built RESTFUL api for a blog using java and spring boot(without a frontend).
What it does
the code manages all the http methods on a post inside the blog and comments on that post.
the post consists ...
- 597
-1
votes
1
answer
296
views
is my code protected against SQL injections?
im using spring boot and CrudRepository for my queries, the project is about posting content on a blog, so I have a post record with id, creator name, post name, the content itself likes and dislikes:
...
- 597
5
votes
3
answers
2k
views
Count unique visitor using IP address and make sure that 24 hours has passed before incrementing the counter
I've created a unique page counter using a PHP script. Pages could be videos, images, publications, etc.
Every time a new user views a page, I record the entry and increment the view counter.
I cannot ...
- 239
1
vote
2
answers
122
views
backend Database authorization app using MySQL [V2]
here is my first virsion question: Is it good practice to have all my back end in one single file with all functions being static?
...
- 597
1
vote
4
answers
215
views
3
votes
1
answer
299
views
PHP MySQLi Wrapper Class For API
I've never had my code reviewed before, so I am taking this opportunity to see what can be improved with my coding style. I am still somewhat "new" to PHP, in the sense that I'm an old dog ...
- 131
3
votes
0
answers
114
views
Create table of yearly monthly temperatures from monthly data
I've got a series of tables with monthly data on USA regions over about 130 years, divided by either climate divisions (clim_div) or other federal standards (ncdc_fips). They all follow the same ...
-3
votes
1
answer
125
views
1
vote
1
answer
435
views
Three way Eloquent relationship definition and saving in Laravel
I'm building a Laravel app (with Vue3 and InertiaJS), and I'm attempting to create relationships between three models:
User
Area
WorkHours
where WorkHours is the ...
- 121
1
vote
1
answer
98
views
Find offers that can be matched with bids
I am working on a sql query for the following scenario:
Get all available offers for registered demand (offers from profiles
should not be from profile which had registered demand). After that
get ...
- 121
3
votes
1
answer
133
views
Company management app: Extracting data with JDBC and java.sql
I'm currently working on a company management system as a university project, and I have to get my hands in java.sql.
I have come to struggle with extracting a ...
4
votes
3
answers
446
views
Queries to get products selected in multiple stores
Project description
I'm making a website listing products. The listing goes as following (See here):
Product name
Shop name
Price in that shop
If the product appears multiple times in the table for ...
- 43
9
votes
5
answers
2k
views
Weekly MySQL database backup
I haven't used Unix, etc. for 40 years, so I am a bit rusty. I need to back up the databases on my website(s) once a week and then retrieve them automatically from my development machine. So this is ...
- 268
4
votes
4
answers
590
views
Functions in PHP to run basic MySQL crud
I wrote a list of functions in PHP that I want to use in my pet project as an autoloaded file for all parts of the app. The purpose of these function is to shorten the code you write for MySQL queries ...
0
votes
2
answers
153
views
Search between dates in a WP Query
In the posts I have a date field and a start and end date range. I need to query if it matches date or if it matches between the dates in the range. This Query works, but how can I optimize?
...
- 11
0
votes
2
answers
221
views
Version 2: Display visitor's number on your web page (changed code after getting answer for first version)
Version 2: Display visitor's number on your web page (changed code after getting answer for first version).
The first version is here: Display visitor's number on your web page
The "visitors&...
user245050
0
votes
1
answer
313
views
Display visitor's number on your web page
Display visitor's number on your web page.
The "visitors" table has only one column (visitor_count) and only one row. The column's initial value is 0.
I know goto should not be used but then ...
user245050
3
votes
1
answer
278
views
Proper PDO connection function
I am reviewing the database class for a live website. I am not sure if the current connect function is the best way to create a pdo object as it appears to create a new connection every time it is ...
- 31
5
votes
1
answer
123
views
A procedure that receives a letter and a number that shows for example : (A,3) A AA AAA
Make a procedure called paintletter, it receives two parameters,
a letter and a number. it will have to paint on the screen lines with the specified letters starting with a letter and ending with as ...
- 133
3
votes
1
answer
85
views
MySQL procedure to extract a letter from a phrase
Create a function called GETLYRICS, which will receive as parameters a word of at most 15 letters and a number. It must return the letter of the position indicated in the number.
My exercise is fine ...
- 133
2
votes
1
answer
745
views
SQL query to find expenditures of employees who have exceeded their limit
I've 2 tables emp and expenditure.
Emp:
ID, NAME
Expenditure:
ID, EMP_ID, AMOUNT
Each emp has a limit of 100 that he/she can ...
- 137
2
votes
1
answer
281
views
Optimization of laravel pivot table relationship
I have a pivot table called invite_riskarea which is designed as follows:
This table stores the permissions that have a specific user (through an invite id) to ...
- 117
-3
votes
1
answer
80
views
2
votes
1
answer
53
views
Shell script to backup db from mysql whether the mysql server is running in docker
I have written this shell script to backup MySQL database to disk. It works fine but I am not well proficient in shell scripting. So what do you think can it be improved?
...
- 175
1
vote
2
answers
137
views
Having trouble deleting multiple queries (PHP, MYSQL)
I'm having trouble making WHERE IN query work, I was only able to make it work as a foreach loop.
My payload looks like this:
sku[]: BOOK0002
sku[]: BOOK0003
My ...
- 21
1
vote
1
answer
196
views
Is this session manager secure?
I'm looking for best practices for writing secure session managers.
I'm making a table for the authorization token (UUID OR GUIDv4) with autoincrement, user_id, token, status (enum) then update status ...
- 37
1
vote
1
answer
176
views
Validate avatar image
I want to know if that code is correct and readable.
In class avatar the method getAvatar() validates the data. It checks if the field is not empty and if the photo extension is correct. If not, an ...
- 11
2
votes
1
answer
110
views
Calculate time interval excluding breaks
I have a solution for a question I asked on SO:
I am trying to create a database where I also need to find the time
difference inside a record. However, timediff() ...
- 21