Checkout on modified OS-Commerce shop
$30-250 USD
Paid on delivery
Hi,
On a shop with modified checkout, we have a MYSQL error when there is a quote in the addres or city.
This is the error when a quote is used in the city. Name of city: 's-Gravenwezel
Error:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's-Gravenwezel' and customers_id = '522'' at line 1
select address_book_id from address_book where entry_street_address = 'Sint-Jobsteenweg 51' and entry_postcode = '2970' and entry_city = ''s-Gravenwezel' and customers_id = '522'
[TEP STOP]
This is the error when a quote is in the address:
1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'testsstraat 125' and entry_postcode = '8020' and entry_city = 'Oostkamp' and cus' at line 1
select address_book_id from address_book where entry_street_address = 'J' testsstraat 125' and entry_postcode = '8020' and entry_city = 'Oostkamp' and customers_id = ''
[TEP STOP]
Project ID: #4324834
About the project
Awarded to:
9 freelancers are bidding on average $77 for this job
We are interested in assisting you in completing your project as we have the experience that is needed. Thank you for reviewing our bid.
We have 15 years of experience in MySQL and we will get it done with quality - Please see PMB for detail.
Hi, In response to the job advertisement published in the freelancer.com. I would like to offer myself as a candidate for the post. I am very interested in working on your project. I have experience with Web desig More