Find Jobs
Hire Freelancers

bug fix in my script

$10-30 USD

Đã hoàn thành
Đã đăng vào 6 tháng trước

$10-30 USD

Thanh toán khi bàn giao
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
Mã dự án: 37501920

Về dự án

12 đề xuất
Dự án từ xa
Hoạt động 6 tháng trước

Bạn muốn kiếm tiền?

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian
Nhận thanh toán cho công việc
Phác thảo đề xuất của bạn
Miễn phí đăng ký và cháo giá cho công việc
Đã trao cho:
Avatar người dùng
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 trong 1 ngày
5,0 (101 nhận xét)
7,0
7,0
12 freelancer chào giá trung bình $32 USD cho công việc này
Avatar người dùng
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
$43 USD trong 7 ngày
5,0 (119 nhận xét)
6,0
6,0
Avatar người dù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
$30 USD trong 2 ngày
5,0 (2 nhận xét)
2,8
2,8
Avatar người dùng
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
$100 USD trong 3 ngày
5,0 (3 nhận xét)
2,7
2,7
Avatar người dùng
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.
$20 USD trong 2 ngày
4,8 (2 nhận xét)
1,3
1,3
Avatar người dùng
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 trong 1 ngày
5,0 (1 nhận xét)
1,0
1,0
Avatar người dùng
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 trong 7 ngày
0,0 (0 nhận xét)
0,0
0,0
Avatar người dùng
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.
$15 USD trong 2 ngày
0,0 (0 nhận xét)
0,0
0,0

Về khách hàng

Cờ của DENMARK
fredericia, Denmark
5,0
91
Phương thức thanh toán đã xác thực
Thành viên từ thg 11 8, 2014

Xác thực khách hàng

Cảm ơn bạn! Chúng tôi đã gửi email chứa đường link để bạn lấy tín dụng miễn phí.
Đã xảy ra lỗi trong khi gửi email của bạn. Hãy thử lại.
Người Dùng Đã Đăng Ký Tổng Số Việc Đã Đăng
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Đang tải xem trước
Đã cấp quyền truy cập vị trí.
Phiên đăng nhập của bạn đã hết hạn và bạn đã bị đăng xuất. Hãy đăng nhập lại.