Skip to main content

Questions tagged [mysql]

MySQL is an open-source, relational database management system. If your PHP code uses MySQLi, use the MySQLi tag instead.

Filter by
Sorted by
Tagged with
2 votes
1 answer
242 views

MySQL interval search query suggestions

My database structure is: ...
friday-json's user avatar
7 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. ...
whiteman808's user avatar
2 votes
1 answer
100 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 ...
Sayaman's user avatar
  • 415
3 votes
1 answer
91 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? ...
whiteman808's user avatar
2 votes
1 answer
86 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 (<...
Roland Deschain's user avatar
1 vote
1 answer
88 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: ...
Marco's user avatar
  • 239
0 votes
1 answer
78 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: ...
Bebo's user avatar
  • 39
1 vote
1 answer
140 views

Follow up to Validation Script in PHP

So I've implemented the suggestions in Original question And now my code looks like this: ...
Bebo's user avatar
  • 39
1 vote
1 answer
116 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 ...
Bebo's user avatar
  • 39
0 votes
1 answer
218 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 ...
Bebo's user avatar
  • 39
2 votes
1 answer
328 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 ...
Ellie's user avatar
  • 549
0 votes
1 answer
164 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: ...
Ellie's user avatar
  • 549
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 ...
Marco's user avatar
  • 239
1 vote
2 answers
62 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? ...
Ellie's user avatar
  • 549
1 vote
4 answers
170 views

Is it good practice to have all my back end in one single file with all functions being static?

...
Ellie's user avatar
  • 549
0 votes
0 answers
28 views

MySQL join query to link valuations with associated valuation tasks

...
Michael LB's user avatar
3 votes
1 answer
224 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 ...
Bellator's user avatar
  • 131
1 vote
0 answers
23 views

Use API data to ensure current product prices in database data then sort by price

Because I've waited until now to bother learning the magical JSON functions that modern MYSQL affords, I wonder if my code is optimally written and if there are cautions/limitations to be aware of. My ...
mickmackusa's user avatar
  • 8,654
3 votes
0 answers
88 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 ...
DownrightBass's user avatar
-2 votes
1 answer
79 views

Preventing PHP SQL injection on login [closed]

I had a login code like this: ...
Bazim's user avatar
  • 19
1 vote
1 answer
359 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 ...
wonder95's user avatar
  • 111
1 vote
1 answer
48 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 ...
Gleichmut's user avatar
  • 121
3 votes
1 answer
94 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 ...
Thomas Herondale's user avatar
1 vote
0 answers
55 views

PHP PDO prepared statement with IN [closed]

Here's my code: ...
neubert's user avatar
  • 111
4 votes
3 answers
386 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 ...
Alpha.Ars's user avatar
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 ...
Rohit Gupta's user avatar
4 votes
4 answers
485 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 ...
Syed M. Sannan's user avatar
0 votes
2 answers
111 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? ...
cRiSs rOcCa's user avatar
0 votes
2 answers
184 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&...
user avatar
0 votes
1 answer
271 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 ...
user avatar
3 votes
1 answer
212 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 ...
jdf's user avatar
  • 31
4 votes
0 answers
77 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 ...
Javier G.Raya's user avatar
3 votes
1 answer
46 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 ...
Javier G.Raya's user avatar
2 votes
1 answer
633 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 ...
reiley's user avatar
  • 137
2 votes
1 answer
243 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 ...
sfarzoso's user avatar
  • 137
-3 votes
1 answer
52 views

How to select lots of friends posts from database [closed]

...
The concise's user avatar
2 votes
1 answer
30 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? ...
Chang Zhao's user avatar
1 vote
2 answers
95 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 ...
Metwesh's user avatar
  • 11
1 vote
1 answer
150 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 ...
Taa Lee's user avatar
  • 37
1 vote
1 answer
141 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 ...
user254603's user avatar
1 vote
0 answers
59 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() ...
Memo Haldan's user avatar
0 votes
4 answers
585 views

table name column name from GET parameter

This is a function that reads a setting data from DB. ...
flow Stack's user avatar
2 votes
1 answer
299 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 ...
bender's user avatar
  • 21
0 votes
3 answers
929 views

url encoding and storing (JS, PHP, MySQL) [closed]

This question is about how best to encode, send and store information between JavaScript, PHP, and MySQL I am doing a GET request from HTML/JavaScript to my PHP server, which is then storing the data ...
ControlAltDel's user avatar
1 vote
3 answers
186 views

SQL query joining applications to categories

I do have large database and my query takes about 2s to complete on production environment which is kinda slow and would like to ask is there a space for improvement? My initial inputs are ...
Marius's user avatar
  • 119
2 votes
1 answer
75 views

Calculate of the average of time discounted values

Given the current table: ...
Jossy's user avatar
  • 153
4 votes
0 answers
3k views

Student report card management Python program

The program is designed to take data from a MySQL database, using mysql-connector-python, and print it as a table in Python using the texttable module. The program also plots charts based on the data ...
Random Person's user avatar
0 votes
2 answers
3k views

PHP search multiple filter inputs

Okay so I built this search page that searches for posts but my current code seems so bloated and inefficient. My script(search page) ...
JÂK_JÂP_JÓ's user avatar
8 votes
3 answers
904 views

Schema design for user profile and transaction

I'm creating a schema design for a user profile and transactions. I am very new in data modeling and currently this is my design. The schema has multiple deposit ...
9years's user avatar
  • 81
7 votes
2 answers
206 views

Connect to MYSQL database in PHP with prepared statements

I have recently learned about using PDO. I created a db class which could handle common actions like create, update, delete and select. Is this method a correct way to connect to the database using ...
Sanidhya's user avatar

1
2 3 4 5
22