bug fix in my script

Lengkap Disiarkan 2 bulan lepas Dibayar semasa penghantaran
Lengkap Dibayar semasa penghantaran

I'm having problems with my script. my script goes to [login to view URL] even though qr_id is not associated with packetnamee in db

abot my code so you understand the logic:This PHP script is designed to handle access control for a system that involves managing QR codes on wristbands. The purpose is to verify access based on submitted information from an HTML form containing details about the packet name (packetname) and QR ID (qr_id).

Functionality:

Receive Form Data:

The script first checks if data has been submitted from an HTML form by examining the server's request method (POST).

Call Verification Function:

If data has been submitted, the verifyAccess function is called with the packet name and QR ID information.

Verify Access:

The verifyAccess function prepares a prepared statement to retrieve access period information from the database based on the submitted packet name.

If the preparation of the statement fails, the user is redirected to an error page ([login to view URL]).

If the statement is executed successfully, information about the arena, access start date, and access end date is retrieved from the database.

If the arena name is empty, the user is redirected to an error page ([login to view URL]).

It checks if the current date is within the allowed date interval. If not, the user is redirected to a page informing that access is denied ([login to view URL]).

Verify QR ID and Status:

Another prepared statement is prepared to retrieve information about the QR ID from the database.

If the preparation fails, the user is redirected to an error page.

The result of the statement, QR ID, and status are retrieved and stored.

The statement is closed.

Check Access Status:

Based on the retrieved information about the arena, QR ID, and status, a decision about access is made.

If all conditions are met, the user is redirected to a success page ([login to view URL]).

If the conditions are not met, the user is redirected either to a rejection page ([login to view URL]) or an error page ([login to view URL]).

Notes:

The script uses prepared statements to guard against SQL injection.

The HTML form triggering this script should contain input fields with the correct names (packetname and qr_id).

If errors occur in the process, the user is redirected to an error page for further information.

my script are add

PHP MySQL Kejuruteraan Perisian JavaScript HTML

ID Projek: #37501920

Tentang projek

12 cadangan Projek jarak jauh Aktif 2 bulan lepas

Dianugerahkan kepada:

aqeeqabbas

I can do this asap. I have thoroughly examined your PHP script handling QR code access control on wristbands, especially the issue where it redirects to [login to view URL] despite the absence of qr_id associated with packetna Lagi

$50 USD dalam sehari
(101 Ulasan)
7.0

12 pekerja bebas membida secara purata $32 untuk pekerjaan ini

giaphung2k1

Hej Solution: To fix the bug in your script, you will need to ensure that your script verifies the packetname - qr_id association in the database. To do so, you can add a prepared statement that queries the database Lagi

$43 USD dalam 7 hari
(119 Ulasan)
6.0
shaguftaparveen9

Good evening bug fix in my script Thank you for considering us for your custom web and app development needs. We understand that you are looking for a solution that is tailored to your specific requirements and goals. Lagi

$30 USD dalam 2 hari
(2 Ulasan)
2.8
LionConcepts

G'day, I just red your project "bug fix in my script" and have seen your project description that "I'm having problems with my script......" so on I am experienced Swift graphics designer with skills including JavaScri Lagi

$100 USD dalam 3 hari
(3 Ulasan)
2.7
hammasunnabi123

Hi there! I'm Hammas, and I'm excited to hear about your project. As a web developer, graphic designer, and flutter expert, I have the skills necessary to help you create an outstanding digital experience. Specificall Lagi

$20 USD dalam 2 hari
(2 Ulasan)
1.3
MirhaKhan786

Hi, I am the best candidate for this job as I am proficient in web development specially in PhP and mySql. I can easily meet your targeted deadline. Please inbox me to further discuss.

$20 USD dalam sehari
(1 Ulasan)
1.0
Chrisian1

FULL STACK DEVELOPER >>>>>>>>>>>>>>>>>>>>>>>>>>> I am an experienced full stack developer who's familiar with HTML, Software Architecture, MySQL, JavaScript and PHP. Let's do it.

$20 USD dalam 7 hari
(0 Ulasan)
0.0
fabedin718

Hi I have carefully read and understand the flow of your script described by you, but unfortunately I am unable to download and view the script file you included. Could you please send me the file in message so that I Lagi

$15 USD dalam 2 hari
(0 Ulasan)
0.0