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
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 packetnamee in the database. Your script uses POST method data handling and a verifyAccess function for verification, employing prepared statements to retrieve access period and QR ID details. I will meticulously debug the script, rectifying the logic to ensure precise access verification. My goal is to redirect users correctly based on database matches, either to [login to view URL] or rejection pages in case of discrepancies. Let's collaborate to swiftly resolve this issue and ensure accurate access control.
$50 USD w 1 dzień
5,0 (101 opinii)
7,0
7,0
12 freelancerzy składają oferty o średniej wysokości $32 USD dla tej pracy
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 to determine if the submitted qr_id is associated with the submitted packetname. This prepared statement should be added immediately after the statement to retrieve access period information from the database based on the submitted packetname.
In the code, you can add an if statement that checks if the qr_id exists in the database when the packetname is provided. If the qr_id is not found, the user is redirected to an error page. You can also use a boolean variable to indicate whether the qr_id exists in the database or not. If the variable is false, the user is redirected to an error page.
To ensure the validity of the query results, you need to add a couple of checks. Firstly, you can check if the number of rows returned from the query is more than zero. Secondly, you can check that the qr_id obtained from the query result is the same as the submitted one. If either of these checks fails, the user is redirected to an error page.
By adding this check, you can ensure that the submitted qr_id is associated with the submitted packetname in the database. This will solve your bug and ensure that your script works correctly.
Best regards,
Giáp Văn Hưng
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.
Our team of experienced developers has a proven track record of delivering high-quality, user-friendly websites and apps that are designed to meet the unique needs of our clients. We use the latest technologies and industry best practices to ensure that your solution is not only functional, but also visually appealing and easy to navigate.
We would be happy to work with you to understand your specific requirements and develop a custom solution that meets your needs. Our process typically includes the following steps:
Discovery and requirements gathering: We will work with you to understand your goals, target audience, and key features that are required for your solution.
Design and prototyping: We will create a design that is visually appealing and user-friendly and create a prototype of your solution so you can get a sense of how it will function.
Development and testing: Our developers will build the solution according to the design and prototype, and thoroughly test it to ensure it meets your requirements.
Thank you
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 JavaScript, HTML, PHP, Software Architecture and MySQL.
To have an idea about my experience, skills and previous client reviews, you can check my profile:
https://www.freelancer.com/u/LionConcepts
I have 3 years of experience in providing such services
i am ready to discuss about your likeness over chat so we may both get on to one page
Do you have any text to incorporate in the design?
Looking Forward
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.
Specifically, I have experience working with HTML, JavaScript, MySQL, and PHP which will be crucial for your project. Additionally, my expertise in web development enables me to design and build applications that are seamless for users. This is particularly important for projects such as this where accuracy is key - I ensure that everything is done correctly so that you don't have any issues with delays or errors later on down the line.
I understand how important it is to have accurate access controls for your system that involve managing QR codes on wristbands - this is why I am here to help! With my experience in web development as well as flutter expertise, I am able to create an engaging user experience while guaranteeing accuracy at all times so that you don't run into any problems down the road.
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.
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.
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 can take a look and try to figure out the why your script is working abnormally. I am placing the bid please before accepting send me the php script in the message.
