Jump to content

Need some help with database ...


fwbbetsy

Recommended Posts

i have set up a site and I have an error and the site won't load becuase of an error ... This is the error:

 

arning: mysql_connect() [function.mysql-connect]: Access denied for user 'nicevill_fwbbets'@'localhost' (using password: YES) in /home/nicevill/public_html/includes/mysql.php on line 35

Database error: Link-ID == false, connect failed

MySQL Error: 0 ()

Session halted.

 

I am not sure what kind of information you might need to help me so just let me know.

 

Thanks

 

Betsy

Link to comment
Share on other sites

maybe this wll help this is the file I used to input the info on the database

 

<?

class DB_Sql {

  var $Host    = "localhost"; // Hostname of our MySQL server.

  var $Database = "nicevill_ptc"; // Logical database name on that server.

  var $User    = "123"; // User und Password for login.

  var $Password = "123";

 

  var $Link_ID  =0;  // Result of mysql_connect().

  var $Query_ID =0;  // Result of most recent mysql_query().

  var $Record  = array();  // current mysql_fetch_array()-result.

  var $Row;          // current row number.

 

  var $Errno    = 0;  // error state of query...

  var $Error    = "";

  var $num_queries = 0;

 

 

  function halt($msg) {

    printf("</td></tr></table><b>Database error:</b> %s<br>\n", $msg);

    printf("<b>MySQL Error</b>: %s (%s)<br>\n",

      $this->Errno,

      $this->Error);

    die("Session halted.");

  }

 

 

 

function free_result($sql) {

$this->free_result($sql);

}

 

 

  function connect() {

    if ( 0 == $this->Link_ID ) {

      $this->Link_ID=mysql_connect($this->Host, $this->User, $this->Password);

      if (!$this->Link_ID) {

        $this->halt("Link-ID == false, connect failed");

      }

      if (!mysql_query(sprintf("use %s",$this->Database),$this->Link_ID)) {

        $this->halt("cannot use database ".$this->Database);

      }

    }

 

  }

 

 

  function fetch_array($query_id=-1,$query_string="") {

    if ($query_id!=-1) {

      $this->query_id=$query_id;

    }

    if ( isset($this->query_id) ) {

      $this->record = mysql_fetch_array($this->query_id);

    } else {

      if ( !empty($query_string) ) {

        $this->halt("Invalid query id (".$this->query_id.") on this query: $query_string");

      } else {

        $this->halt("Invalid query id ".$this->query_id." specified");

      }

    }

    return $this->record;

}

 

 

    function query($Query_String) {

//  $this->connect();

$this->num_queries++;

#printf("<br><font color=red><b>Debug: query = %s</b></font><br>", $Query_String); // Use for debugging

    $this->Query_ID = mysql_query($Query_String,$this->Link_ID);

    $this->Row  = 0;

    $this->Errno = mysql_errno();

    $this->Error = mysql_error();

    if (!$this->Query_ID) {

      $this->halt("Invalid SQL: ".$Query_String);

    }

    return $this->Query_ID;

  }

 

 

  function next_record() {

    $this->Record = mysql_fetch_array($this->Query_ID);

    $this->Row  += 1;

    $this->Errno = mysql_errno();

    $this->Error = mysql_error();

    $stat = is_array($this->Record);

    if (!$stat) {

      mysql_free_result($this->Query_ID);

      $this->Query_ID = 0;

    }

    return $stat;

  }

 

 

  function seek($pos) {

    $status = mysql_data_seek($this->Query_ID, $pos);

    if ($status)

      $this->Row = $pos;

    return;

  }

 

 

  function num_rows() {

    return mysql_num_rows($this->Query_ID);

  }

 

  function num_fields() {

    return mysql_num_fields($this->Query_ID);

  }

 

 

  function f($Name) {

    return $this->Record[$Name];

  }

 

  function p($Name) {

    print $this->Record[$Name];

  }

 

  function affected_rows() {

    return @mysql_affected_rows($this->Link_ID);

  }

 

 

 

function get_temps() {

while ($row = mysql_fetch_array($this->Query_ID)) {

$templ[$row["id"]] = $row['con'];

}

echo "$templ[1]<br>$templ[2]";

}

 

function get_temp() {

return mysql_fetch_array($this->Query_ID);

}

 

  function query_first($query_string) {

    // does a query and returns first row

    $query_id = $this->query($query_string);

    $returnarray=$this->fetch_array($query_id, $query_string);

    $this->free_result($query_id);

    return $returnarray;

  }

 

 

function sql_close()

{

if($this->db_connect_id)

{

if($this->query_result)

{

@mysql_free_result($this->query_result);

}

$result = @mysql_close($this->db_connect_id);

return $result;

}

else

{

return false;

}

}

 

 

 

}

 

 

 

 

 

 

?>

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.