Web Hosting Blog

Possible issues with OSCommerce and MySQL5

We have been made aware that some customers may have issues with their OSCommerce installations after your recent upgrade to MySQL5.

To solve this, two files in the installation directory need to be changed. the first set of changes are needed to index.php.

Remove the code below from that file …

// show the products of a specified manufacturer
if (isset($HTTP_GET_VARS['manufacturers_id'])) {
if (isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only a specific… Read full story

How do I query a MySQL database from a PHP script?

In todays web hosting tutorial we are going to cover :

How do I query a MySQL database from a PHP script?

Use the following outline to connect and begin querying the MySQL server from within your PHP scripts. Remember if you are a Pixel Internet customer you cannot connect to your databases remotely for security reasons; you can only connect from localhost.

1. Connect to the… Read full story