connection problem with conneciton class

Discussion in 'PHP' started by dizyn, Nov 11, 2010.

  1. #1
    
    <?php
    
    	// site info
    	define('HTTP_PATH', 'http://go/twi.tter.me/');
    	define('URL_SHFT', 1);
    	define('FS_PATH', dirname(__FILE__) . '/');
    	
    	// database info
    	define('DB_PATH', 'localhost');
    	define('DB_USER', 'root');
    	define('DB_PASS', 'pass');
    	define('DB_NAME', 'user');
    	
    
      // database class
      
      class MySqlStuff {
    
    	public $connection = null;
    	public $database = null;
    
    	public function __construct() {
    	     
    //		$this->connection = mysql_connect(DB_PATH, DB_USER, DB_PASS);
    //		$this->database = mysql_select_db(DB_NAME);
    		$this->connection = mysql_connect("localhost", "user", "pass");
    		$this->database = mysql_select_db("db");
    
    		return true;
    
    	}
    
    	public function Query($sql) {
    
    		$result = mysql_query($sql);
    		return $result;
    	
    	}
    
    	public function FetchArray($sql) {
    
    		$result = $this->Query($sql);
    		$array = array();
    
    		while($row = mysql_fetch_assoc($result)) {
    
    			$array[] = $row;
    			
    		}
    
    		return $array;
    		
    	}
    	
    	public function FetchSArray($sql) {
    echo $sql;exit;
    		$result = $this->Query($sql);
    		$array = mysql_fetch_assoc($result);
    
    		return $array;
    		
    	}
    	
    	public function InsertID() {
    	
    		return mysql_insert_id();
    		
    	}
    	
    	public function NumberRows($sql) {
    	
    		$result = $this->Query($sql);
    		return mysql_num_rows($result);
    		
    	}
    
      }
      
      // connect to database
      $mysqlstuff = new MySqlStuff();
    	
    ?>
    
    
    
    PHP:

     
    dizyn, Nov 11, 2010 IP
  2. fr33lanc3

    fr33lanc3 Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Have you entered your proper database details in your code below and are only showing this for security purposes?

    $this->connection = mysql_connect("localhost", "user", "pass");
    $this->database = mysql_select_db("db");
     
    fr33lanc3, Nov 11, 2010 IP
  3. bencummins

    bencummins Peon

    Messages:
    55
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Add some error handling , it could be a wrong query

    public function Query($sql) {
    
            $result = mysql_query($sql) or die(mysql_error());
            return $result;
        
        }
    PHP:
     
    bencummins, Nov 11, 2010 IP
  4. fr33lanc3

    fr33lanc3 Peon

    Messages:
    38
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #4
    what output did mysql_error() give you?
     
    fr33lanc3, Nov 11, 2010 IP