[Mysqli_Real_Escape_String() Vs Escape_Data() Function]

Sorry didn't read the errata.

[Mysqli_Real_Escape_String() Vs Escape_Data() Function]

In ecommerce1, shouldn't we be using escape_data() instead of mysqli_real_escape_string() when checking forms anyway?

Do we not want to be trimming the data off form fields like escape_data() does or at least adding trim to all the checks of the form fields  in say register.php?

 

Or if there is a reason we don't want to trim data off a particualr field, can we not add an else clause to escape_data() that matches the fields we dont want trimmed then returns an untrimmed version of the data?  then that way making use of escape_data() in the application

 

Regards,

 

Rob

[Openssl - Https://Localhost Points To Another Htdocs Directory]

Sorry to waste anyones time here. I have found the problem.

 

Within httpd-sll.conf I was pointing the wrong document root.

 

<VirtualHost _default_:443>

#   General setup for the virtual host
DocumentRoot "c:/wamp/htdocs"

 

 

 

Rob

[Openssl - Https://Localhost Points To Another Htdocs Directory]

Hi,

 

I have just installed openssl but I am getting the problem in the topic title.

 

When I was pressing the checkout button in the coffee site example I was getting the following error

 

The requested URL /ecommerce_2/stage_2/html/checkout.php was not found on this server.

(my BASE_URL is localhost/ecommerce_2/stage_2/html/)

 

It took me a while to realise that https://localhost was pointing to a htdocs folder I don't use

(C:/wamp/apache22/htdocs)

 

I have set my document root to (c:/wamp/htdocs) where I keep the coffee site and thats where http://localhost points to and the site works fine to the point of pressing checkout.

 

The only solution I have come up with so far is to place another copy of the site in (C:/wamp/apache22/htdocs) so that when I press checkout https finds checkout.php and this seems to work. but surely this is not how it's intended?

 

I have trawled through the apache configurations files, and I'm having no luck trying to get https to point to my actual document root (c:/wamp/htdocs) any ideas?

 

Regards,

 

Rob