All Questions
35
questions
1
vote
0
answers
56
views
1
vote
1
answer
74
views
Updating multiple database tables when products are shipped back by customer
So, in this example I have to make these changes in my tables:
Select Product Data => SKU, QTY
Insert into shipping_back table
Update in shipping_back to current date
Update in customers to ...
- 75
4
votes
2
answers
205
views
Using a transaction to create account records
This is my first time using commit and rollback. I just need to know if this is a proper execution of the functions for this particular situation:
...
- 427
5
votes
1
answer
143
views
Storing and confirming user input
I am a beginner, and I'm trying to secure a sign-login system on my website. Is my code good/enough to prevent SQL injection?
THIS IS THE SIGN FILES
This is the index.php that takes user input:
...
- 173
3
votes
1
answer
806
views
Does PDO::quote helps me to protect me against sql injection?
I have to process raw sql user input with Laravel. I've backed them up as follows:
...
1
vote
1
answer
83
views
Reduce database touches for one to many data pull
I have the following function which works properly and returns all of the rows from a specific table, then loops through each row to add data related to it as a subarray.
...
- 466
1
vote
1
answer
101
views
Displaying a paginated list of forum topics using PHP PDO [closed]
Can someone tell me if this code is safe? Can be sql-injected or something else hacked? Code get some rows from db and show in pages with pagination... if i can improve let me know and show me how, ...
- 21
2
votes
2
answers
84
views
ORM class for Posts
I'm new to PHP OOP and I'm making some tests. I have 2 classes: database and posts and the two interact with each other.
Class Database:
...
- 173
3
votes
1
answer
1k
views
PHP + PDO - Inserting data on the table with a loop
First of all i made a simple code to insert data on my table, with the information from this code i made a loop to insert data on another table for a notification system.
I'm new to PHP and i think ...
- 249
2
votes
1
answer
89
views
2
votes
2
answers
101
views
1
vote
1
answer
4k
views
PDO Dynamic query builder
I'm trying to improve my php oop programming skills. As an exercise I wrote this class that will generate and execute dynamic sql queries. I've also writed a class to call various sanitization filters ...
- 353
4
votes
3
answers
345
views
PHP Signup & Login
I want everything to be well and secure with my authentication code. I've done many signup and login systems before but just for testing purposes, and didn't take into consideration all the security ...
- 41
1
vote
1
answer
62
views
Insert and update SQL entries for posts to be accessed by up to 3 other users
At first, I have this HTML I use here:
body {
text-align: center;
}
...
- 113
1
vote
2
answers
524
views
PHP PDO statements
I wrote a piece of code. and to be honest it seems a bit messy so I would like some opinions on it, and if I can make it cleaner. Or if there are better ways to do it:
...
- 113