[RESOLVED] Where is my problem???

[bahamucio]

<?php
  class db //Class beginning.
    {
      var $DB_HOST="localhost";
      var $DB_USER="root";
      var $DB_PASSWORD="";
      var $DB="";
      var $DB_TABLE="";
      var $DB_LINK="";
      var $DB_SELECT="mamati";

  //Methods
  function DisplayErrMsg( $message ) //Diplays errors if any.
  {
    printf("<blockquote><blockquote><blockquote><h3><font color=\"#cc0000\">%s</font></h3></blockquote></blockquote></blockquote>\n", $message);
  }

  //Connect to the db

  function dbConnect() {
    if (!($this->DB_LINK = mysql_connect($this->DB_HOST, $this->DB_USER, $this->DB_PASSWORD))) {
  DisplayErrMsg(sprintf("internal error %d:%s\n", mysql_errno(), mysql_error()));
      return 0;
} else {
  $this->DB=mysql_select_db($this->DB_SELECT, $this->DB_LINK);

 }
      }

  //Close connection.

  function dbDisconnect()
  {
    if(!($closedb = mysql_close($this->DB_LINK)))
 {
   DIE ("Cannot close the db");
 }
      }
      //Displays error in mysql.

} //Class end.
?>

I wrote this code but it didn't run like I want. I tested it with a non-existent database but the result is unexpected : the code works without any errors.Any help will be appreciated.Thanks.

[bpat1434]

I think this might be it:

Line 22 should be:

$this->DisplayErrMsg(sprintf("internal error %d:%s\n", mysql_errno(), mysql_error()));

You're referencing a function within the same class, so you need the pointer "$this->" in front so it knows where to look.

~Brett

[bahamucio]

Thanks.I have tried your way but the result is the same.

[bpat1434]

Change this:

else {
      $this->DB=mysql_select_db($this->DB_SELECT, $this->DB_LINK);

} 

to

else {
      $this->DB=mysql_select_db($this->DB_SELECT, $this->DB_LINK);
  if(!$this->DB)
  {
    $this->displayErrMsg(sprintf('internal error: %d:%s', mysql_errno(), mysql_error()));
  }

} 

See if that does anything....

~Brett

[bahamucio]

The result is the same.Nothing happens.I cannot understand if I make misstake somewere, or the problem is other.

[thephpguy]

This might be me just being silly...but are you actually creating the object and using it?

<?

$db = new db();
$db -> dbConnect();

?>

Also, do you have the php extension enabled in php.ini ?

[bahamucio]

I have tried your way with the object but the result is the same .By the way where I can find the mysql extension in Linux

[bahamucio]

I have fixed the problem. Thanks a lot for all who helping me