<?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:
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");
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: