Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help with Error Desperate! MySQL Connection Failed


oclgroup

Recommended Posts

Posted

Warning: Access denied for user: 'sharpweb@localhost' (Using password: YES) in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 19

 

Warning: MySQL Connection Failed: Access denied for user: 'sharpweb@localhost' (Using password: YES) in /home/virtual/site22/fst/var/www/html/catalog/admin/includes/functions/database.php on line 19

Unable to connect to database server!

 

Please is there anyone who can help me?????? The person who usually does this is in the hospital. :oops:

Posted
<?php

/*

 $Id: database.php,v 1.18 2003/02/11 01:31:01 hpdl Exp $



 osCommerce, Open Source E-Commerce Solutions

 http://www.oscommerce.com



 Copyright (c) 2003 osCommerce



 Released under the GNU General Public License

*/



 function tep_db_connect($server = DB_SERVER, $username = xxxxxxxx, $password = xxxxx, $database = xxxxxxxxxxxx_com, $link = 'db_link') {

   global $$link;



   if (USE_PCONNECT == 'true') {

     $$link = mysql_pconnect($server, $username, $password);

   } else {

     $$link = mysql_connect($server, $username, $password);

   }



   if ($$link) mysql_select_db($database);



   return $$link;

 }



 function tep_db_close($link = 'db_link') {

   global $$link;



   return mysql_close($$link);

 }



 function tep_db_error($query, $errno, $error) { 

   die('<font color="#000000"><b>' . $errno . ' - ' . $error . '<br><br>' . $query . '<br><br><small><font color="#ff0000">[TEP STOP]</font></small><br><br></b></font>');

 }



 function tep_db_query($query, $link = 'db_link') {

   global $$link;



   if (STORE_DB_TRANSACTIONS == 'true') {

     error_log('QUERY ' . $query . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   $result = mysql_query($query, $$link) or tep_db_error($query, mysql_errno(), mysql_error());



   if (STORE_DB_TRANSACTIONS == 'true') {

      $result_error = mysql_error();

      error_log('RESULT ' . $result . ' ' . $result_error . "n", 3, STORE_PAGE_PARSE_TIME_LOG);

   }



   return $result;

 }



 function tep_db_perform($table, $data, $action = 'insert', $parameters = '', $link = 'db_link') {

   reset($data);

   if ($action == 'insert') {

     $query = 'insert into ' . $table . ' (';

     while (list($columns, ) = each($data)) {

       $query .= $columns . ', ';

     }

     $query = substr($query, 0, -2) . ') values (';

     reset($data);

     while (list(, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= 'now(), ';

           break;

         case 'null':

           $query .= 'null, ';

           break;

         default:

           $query .= ''' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ')';

   } elseif ($action == 'update') {

     $query = 'update ' . $table . ' set ';

     while (list($columns, $value) = each($data)) {

       switch ((string)$value) {

         case 'now()':

           $query .= $columns . ' = now(), ';

           break;

         case 'null':

           $query .= $columns .= ' = null, ';

           break;

         default:

           $query .= $columns . ' = '' . tep_db_input($value) . '', ';

           break;

       }

     }

     $query = substr($query, 0, -2) . ' where ' . $parameters;

   }



   return tep_db_query($query, $link);

 }



 function tep_db_fetch_array($db_query) {

   return mysql_fetch_array($db_query, MYSQL_ASSOC);

 }



 function tep_db_num_rows($db_query) {

   return mysql_num_rows($db_query);

 }



 function tep_db_data_seek($db_query, $row_number) {

   return mysql_data_seek($db_query, $row_number);

 }



 function tep_db_insert_id() {

   return mysql_insert_id();

 }



 function tep_db_free_result($db_query) {

   return mysql_free_result($db_query);

 }



 function tep_db_fetch_fields($db_query) {

   return mysql_fetch_field($db_query);

 }



 function tep_db_output($string) {

   return stripslashes($string);

 }



 function tep_db_input($string) {

   return addslashes($string);

 }



 function tep_db_prepare_input($string) {

   if (is_string($string)) {

     return trim(stripslashes($string));

   } elseif (is_array($string)) {

     reset($string);

     while (list($key, $value) = each($string)) {

       $string[$key] = tep_db_prepare_input($value);

     }

     return $string;

   } else {

     return $string;

   }

 }

?>

Posted

Give the user permission to access the database using the password in your configure.php files

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...