Questions tagged [mysqli]
The MySQLi extension, or as it is sometimes known, the MySQL Improved extension, was developed to take advantage of new features found in MySQL systems versions 4.1.3 and newer. The MySQLi extension is included with PHP versions 5 and later.
261
questions
0
votes
1
answer
36
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:
...
- 39
1
vote
1
answer
127
views
Follow up to Validation Script in PHP
So I've implemented the suggestions in Original question
And now my code looks like this:
...
- 39
1
vote
1
answer
88
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 ...
- 39
0
votes
1
answer
87
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 ...
- 39
3
votes
1
answer
149
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
1
vote
0
answers
21
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 ...
- 8,534
4
votes
3
answers
365
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
4
votes
4
answers
474
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 ...
4
votes
2
answers
2k
views
using PHP and JS to fetch data for an entry
I need to fetch some data from a mysql database. For that I created get_data.php on the server and a js function to retrieve that data on the client. Is this the proper way to do it? What would you ...
0
votes
0
answers
52
views
Adding more fields to a Questionnaire in a CRUD system
Background on Project
When a customer orders a machine, I have to do something called a telephone site survey, which involves asking them questions about their site making sure everything is okay ...
4
votes
2
answers
279
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
2
votes
1
answer
752
views
MySQL database custom session handler using PHP with MySQLi extension
I have made the decision to move the storing of session data to the database.
Any new ideas, suggestions are welcome.
Please also give security suggestions.
Like SQL injection is possible here, etc...
...
2
votes
1
answer
39
views
Input text upload to MySQL DB
I am uploading and selecting code from my MySQL DB and I have a feeling some of it could be written in a much shorter way but I don't know how. Can someone tell me if this is clean code or if it's too ...
- 439
-2
votes
1
answer
206
views
Query builder class pdo,sql
Need some advices to create class that handles sql query operations with given array (having full control of the array and obtaining record information). My code works properly (it is just example), ...
- 1
-1
votes
2
answers
132
views
My Script Inserts users into a database and hashes the password, I need to know how to prevent SQL injection with Procedural-Oriented MySQLi [closed]
My script works but I just want to know how I can protect myself from SQL injection with Procedural Oriented MySQLi. Most of the tutorials are about Object-Oriented MySQLi and I'm not familiar with it ...
2
votes
1
answer
36
views
Is there a way to consolidate Ajax dropdowns that filters data from MYSQLi database
I recently started a project which has a database of rail cars for a train simulator. Im trying to set up a way to filter the data based upon 4 categories "Car Type", "Road Name", &...
- 121
3
votes
1
answer
96
views
OOP: The correct use of classes and optimizing code
I am trying to improved my coding skills. I mainly work in web development. I had a "system" that I use in all my projects to fetch data from my DB to the browser. I tried an implementation ...
- 39
3
votes
1
answer
78
views
Secure upload script
I am creating a social network that let's users upload a profile picture. I just want to know if this is a secure way of doing it. Thanks.
...
- 439
2
votes
3
answers
75
views
Receiving a user's registration submission and inserting row into database #2
I asked this question before and mickmackusa and Your Common Sense gave me some good answers. I went over them and made as much ...
- 439
1
vote
2
answers
107
views
Receiving a user's registration submission and inserting row into database
I have improved my code since the last time asking for its review.
I'd like to know if it is up to the current standards.
...
- 439
1
vote
2
answers
3k
views
Return row count from mysqli prepared statement
I want to know if it is okay/safe to use a prepared statement and mysqli_num_rows like this:
...
- 439
2
votes
1
answer
78
views
Securely connecting to my DB [closed]
Hello all I have a short question. Is this a good and secure way to connect to my DB ?
...
- 439
3
votes
2
answers
365
views
messages.php file security and efficiency
I am creating a social network and I want to know how secure and clean this code is. I had to update it to prepared statements because I was following a tutorial and even though it was made in 2019 it ...
- 439
3
votes
1
answer
142
views
How secure is my login and signup code
I am creating a social network and I've been told a few times a lot of things are outdated and prone to SQL injections so I am going over everything with a very fine comb and checking what's good and ...
- 439
4
votes
2
answers
192
views
Security of post submission, picture upload and post fetch
I am a newbie and have been following a tutorial I bought on Udemy. But I was told it is old and teaches bad code practices. I used this in some code from my old projects. Now I'd like to know how ...
- 439
1
vote
1
answer
131
views
PHP MySQLi database object
I've been learning more about PHP Objects and Classes, and my immediate reaction was to create a Database Object for handling the MySQLi Connection, Statements and Results. Its not meant to be an ...
- 107
3
votes
1
answer
74
views
User Class and MySQL Connection Handler
Mainly used Stack Overflow, so first time over here for a code review. I am trying to make some enhancements to a legacy application. I have some minor experience using Laravel, but this application ...
- 133
1
vote
1
answer
767
views
Custom PHP MySQL database queries function - Suggestions for improvement or additions
For my website needs I made a custom procedural MySQL function in PHP which can INSERT, UPDATE, SELECT or DELETE data from database. I would like a review and any suggestions for improvement or ...
- 13
1
vote
0
answers
45
views
InnoDB Row Locking with Transaction & Helper [closed]
I have recently started to work with InnoDB as well trying to use "helper" functions. The code below seems to work correctly however I am not sure if the true ...
- 259
7
votes
2
answers
733
views
PHP MySQLi Connection File
I have recently adjusted the way I create my mysqli connections. Initially I would include the connection file and use ...
- 259
1
vote
0
answers
88
views
The code is displaying my mysql table in a bootstrap table using php templates
I am trying to simplify the code so i do not need to make a new add_content function and home template every time my homepage content gets bigger.
template_class....
3
votes
2
answers
179
views
Registration form using procedural MySQLi
I'm relatively new to coding with PHP and mySQLi. I want to learn more but I'm really limited in resources. Most of my research went into W3Schools, PHP.net, and of course whatever I could find on ...
- 107
6
votes
3
answers
221
views
php one-time prepared statement execution function
I use prepared statements often even when I only need to execute the statement once (for security), so I implemented a function to abstract away all the function calls on the mysqli_stmt object, as ...
- 1,122
2
votes
1
answer
2k
views
PHP santization of textarea input
My application will accept textarea content that is submitted by a user, and i would like some people to review my code to make sure there is no security vulnerability such as XSS.
My mySQL column ...
- 63
2
votes
2
answers
174
views
Shoutbox system
I wrote a little Shoutbox System which is working fine, but I want to know if there is something I can improve about this code.
Here is my Shoutbox Overlay:
...
- 193
4
votes
1
answer
117
views
Demotion/Promotion Script
I wrote a code which is creating a Session and write in the Session Arrays diffrent things like: Username and Rank.
I wrote then a function which is checking the Visited Profile Name and Rank and the ...
- 193
3
votes
1
answer
48
views
Creating a booking based on a POST request
I want to make a booking entry. I want to ask whether the code that i wrote below is rightly format or not?
I haven't tried it, because there's still more code that needs to be written. I just want ...
- 31
-1
votes
1
answer
67
views
Login to a school system and get account type
I'm new to MySQL database design.
My question is this database is correctly built or not.
We used the users table to login and get account type
and here the code to login
...
- 13
4
votes
1
answer
51
views
Displaying a user's uploaded posts
I'm working on prepared statements for my website and I'm wondering if it's possible to have multiple prepared statements one after another. In this example, I have 2 select statements. I'm hoping ...
- 43
1
vote
2
answers
64
views
1
vote
1
answer
53
views
Fetching table using mysqli, closing statement before displaying results
I am confused if I can do like this:
...
- 215
1
vote
1
answer
519
views
PHP MySQLi Prepared Statements: Can this select query be hacked/injected?
i want to know can this be hacked/injected?
...
- 215
1
vote
1
answer
102
views
Simple MySql or MySqli Class
Which one of these methods is better/safer to use? And what benefits could I get using one or other?
Simple mysqli:
connection.php
...
- 215
2
votes
2
answers
116
views
PHP New User Creation
I'm learning more about PHP, so I've decided to create a simple login/create account system. Entering information for creating a new account sends the data to my ...
- 9,948
5
votes
2
answers
105
views
PHP password-resetting page
I am producing a PHP code and I want to implement it in my server to do its function. My question is, are there any vulnerabilities that I should correct?
I tried to establish the session first then ...
- 59
1
vote
1
answer
64
views
When slide show web page is reopen, the web page loading is very slow
Here is a script that opens about 200 pictures, the first time you open the webpage, loading of the 200 pictures is fast, However if you reopen the page, it takes about 4 minutes to load the same page ...
- 21
1
vote
2
answers
779
views
Simple wrapper for PHP mysqli connection
I'm creating some web apis to sync some data between desktop/mobile apps.
Working on it, I wrote a simple wrapper for mysqli connection to simplify querying like:
<...
- 55
4
votes
1
answer
3k
views
Using singleton pattern for a MySQL connection
I'm new to web programming, and writing some web apis to enable users to sync their data between devices.
Is it okay to use singleton pattern to prevent reconnecting the MySQL database on every api ...
- 55
3
votes
1
answer
112
views
Authentication system (no browser) with mail verification
I made an authentication system for my software (no browser is used) that works like this:
User receives a Key on it's mail after buying the software
User registers account using that key and inputs ...
4
votes
3
answers
376
views
Adding / updating user info into MySQL database
I'm working on an app that will be used for employee management and I'm using MySQL for the database. You can add employees, view/update/delete them, and on the dashboard I'm listing them in different ...
- 43