[AJUDA]Ajuda Aki Configurar um config.php

[PooF]

<?php


CLASS DB_MYSQL {

    var $Host;                // Hostname of our MySQL server.
    var $Database;            // Logical database name on that server.
    var $User;                // User and Password for login.
    var $Password;
    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 $DDtable="_dt";        // Data Dictionary Tables
    var $DDfield="_df";        // Data Dictionary Fields
    
    function check_logon() {
        $all_okay=false;
        $error_msg="All is okay";
        if ( 0 == $this->Link_ID ) { $this->Link_ID=mysql_pconnect($this->Host, $this->User, $this->Password); }

        if (!$this->Link_ID) {
            $error_msg = "Link-ID == false, connect failed";
        } else if (!mySQL_query(sprintf("use %s",$this->Database),$this->Link_ID)) {
            $error_msg = "cannot use database ".$this->Database;
        } else if (!mySQL_query(sprintf("select TableName from %s",$this->DDtable),$this->Link_ID)) {
            $error_msg = "no datadictionary tables in ".$this->Database;
        } else if (!mySQL_query(sprintf("select TableName from %s",$this->DDfield),$this->Link_ID)) {
            $error_msg = "no datadictionary fields in ".$this->Database;
        } else {
            $all_okay=true;
        }
        
        if (!$all_okay) {
            $this->Errno = mysql_errno();
            $this->Error = mysql_error();
            $this->warn_not_loggedon($error_msg);
        }
        return $all_okay;
    }

    function warn_not_loggedon($msg) {
        printf("</td></tr></TABLE><b>Not Logged on to Database:</b><br> %s<br>\n", $msg);
        printf("<b>MySQL Error</b>: %s (%s)<p>\n",
            $this->Errno,
            $this->Error);
        printf("Host     : %s<br>\n",$this->Host);
        printf("Database : %s<br>\n",$this->Database);
        printf("User     : %s<br>\n",$this->User);
    }

    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);
        echo "<p>\n";
        echo "Host :    ".$this->Host."<BR>\n";
        echo "Database :    ".$this->Database."<BR>\n";
        echo "User :    ".$this->User."<BR>\n";
        die("Session halted.");
    }

    function warn($msg) {
        printf("</td></tr></TABLE><b>Database warning:</b> %s<br>\n", $msg);
        printf("<b>MySQL Error</b>: %s (%s)<p>\n",
            $this->Errno,
            $this->Error);
    }

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

            $this->Link_ID=mysql_pconnect($this->Host, $this->User, $this->Password);
            if (!$this->Link_ID) {
                $this->halt("Link-ID == false, connect failed".mysql_error());
            }
            if (!mySQL_query(sprintf("use %s",$this->Database),$this->Link_ID)) {
                $this->halt("cannot use database ".$this->Database);
            }
        }
    }


    function query($Query_String) {
        $this->connect();
        $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 no_stop_query($Query_String) {
        $this->connect();
        $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) {
        }

      return $this->Query_ID;
    }

    function table_exist($table) {
        $this->connect();
    
        $Query_String = "select * from ".$table." limit 1";
        $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)    return 0;
        else                    return 1;
    } 

    function next_record() {
        $this->record = mysql_fetch_array($this->Query_ID,MYSQL_ASSOC);
        $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 next_raw_record() {
        $this->record = mysql_fetch_array($this->Query_ID,MYSQL_ASSOC);
        $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 $this->record;
    }

    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 auto_ID() {
        return mysql_insert_id($this->Link_ID);
    }

    function fetch_row() {
        $this->record = mysql_fetch_row($this->Query_ID,MYSQL_ASSOC);
        $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 $this->record;
    }

    function field_link($table) {
        return mysql_list_fields($this->Database,$table,$this->Link_ID);
    }

    function field_name($field_num) {
        return mysql_field_name($this->Query_ID,$field_num);
    }

    function field_names() {
        for ($i=0; $i<=$this->num_fields()-1; $i++) {
             $fields[$i]=$this->field_name($i);
        } 
        return $fields;
    }

    function field_len($table,$field_num) {
        return mysql_field_len($this->Query_ID,$field_num);
    }

    function field_type($table,$field_num) {
        return mysql_field_type($this->Query_ID,$field_num);
    }

    function field_flags($table,$field_num) {
        return mysql_field_flags($this->Query_ID,$field_num);
    }

    function fetch_table($field_num) {
        $obField=$this->fetch_field($field_num);
        return $obField->table;
    } 
    
    function Dbinfomation() {
        $Fieldval = array("Host" => $this->Host,"User" => $this->User, "Password" => $this->Password, "Database" => $this->Database);
        return $Fieldval;
    } 
    
    function fetch_field($field_num) {

        /******************************************************
        The properties of the object are: 
        
        name
        table
        max_length
        not_null
        primary_key
        unique_key
        multiple_key
        numeric
        blob
        type
        unsigned
        zerofill
        /******************************************************
        name:                column name 
        table:            name of the table the column belongs to 
        max_length:        maximum length of the column 
        not_null:        1 if the column cannot be null 
        primary_key:    1 if the column is a primary key 
        unique_key:        1 if the column is a unique key 
        multiple_key:    1 if the column is a non-unique key 
        numeric:            1 if the column is numeric 
        blob:                1 if the column is a BLOB 
        type:                the type of the column 
        unsigned:        1 if the column is unsigned 
        zerofill:        1 if the column is zero-filled 
        /******************************************************/
         return mysql_fetch_field($this->Query_ID,$field_num);
    } 
}

?>

Como Configuro isso pra minha database senha e user ?

[Denis Courcy]

Movendo MySQL -->> PHP

[Willian Gustavo Veiga]

<?php
//...
var Host = 'seu hostname';
 //...
?>

Um abraço.

Edited September 28, 2011 by Willian Gustavo Veiga