host = $host; $this->dbUser = $dbUser; $this->dbPass = $dbPass; $this->dbName = $dbName; $this->connectToDb(); } /** * Establishes connection to MySQL and selects a database * @return void * @access private */ function connectToDb() { // Make connection to MySQL server if (!$this->dbConn = @mysql_connect($this->host, $this->dbUser, $this->dbPass)) { trigger_error('Could not connect to server'); $this->connectError = true; // Select database } else if (!@mysql_select_db($this->dbName,$this->dbConn)) { trigger_error('Could not select database'); $this->connectError = true; } } /** * Checks for MySQL errors * @return boolean * @access public */ function isError() { if ($this->connectError) { return true; } $error = mysql_error($this->dbConn); if (empty($error)) { return false; } else { return true; } } /** * Returns an instance of MySQLResult to fetch rows with * @param $sql string the database query to run * @return MySQLResult * @access public */ function &query($sql) { if (!$queryResource = mysql_query($sql, $this->dbConn)) { trigger_error('Query failed: ' . mysql_error($this->dbConn) . ' SQL: ' . $sql); } else { return new MySQLResult($this, $queryResource); } } } /** * MySQLResult Data Fetching Class * @access public * @package SPLIB */ class MySQLResult { /** * Instance of MySQL providing database connection * @access private * @var MySQL */ var $mysql; /** * Query resource * @access private * @var resource */ var $query; /** * MySQLResult constructor * @param object mysql (instance of MySQL class) * @param resource query (MySQL query resource) * @access public */ function MySQLResult(&$mysql, $query) { $this->mysql = &$mysql; $this->query = $query; } /** * Fetches a row from the result * @return array * @access public */ function fetch() { if ($row = mysql_fetch_array($this->query, MYSQL_ASSOC)) { return $row; } else if ( $this->size() > 0 ) { mysql_data_seek($this->query, 0); return false; } else { return false; } } /** * Returns the number of rows selected * @return int * @access public */ function size () { return mysql_num_rows($this->query); } /** * Returns the ID of the last row inserted * @return int * @access public */ function insertID () { return mysql_insert_id($this->mysql->dbConn); } /** * Checks for MySQL errors * @return boolean * @access public */ function isError() { return $this->mysql->isError(); } /** * Returns an instance of MySQLResult to fetch rows with * @param $sql string the database query to run * @return MySQLResult * @access public */ } ?> Random Objects - Birmingham Museums & Art Gallery Information Centre
             
Museums Home BMAGiC Home Search Browse BMAGiC Help About BMAGiC Contact Us
           

Random Objects

Here are some objects from the BMAGiC collections shown at random. Every time you visit or refresh this page a new set of random objects will be displayed.
Click on each of the pictures below to find out more about each object.
See more random objects

Pencil and Chalk Drawing - Green Summer - Study of Back of Seated Girl |Letter - Letter from William Holman Hunt to J R Holliday |Chalk Drawing - Lethe - Head Study |Tile Design - Tile Design - The Marriage Feast at Cana (I) |Pencil Drawing - Pygmalion and the Image - Three Sketches for Pygmalion praying, Pygmalion entering his House |Pencil Drawing - Three Studies of Pigs |Wine Fountain |Bowl |Pencil Drawing - Study for Stained Glass Design - Study for Head of Christ |Oil Painting - Bengal Village Scene |Wood Engraving - The Boy Martyr - Proof |Watercolour - A Fortified Town on a Hilltop (North side of the Acropolis, Athens) |Pencil Drawing - The Sailor's Bride - Tracing for the Wood Engraving |Sculptural Form - Tidal Waters Bowl |Watercolour - Copy from the Psalter of Robert de Lisle - Two Figures |Collotype - The Flower Book - Venus'  Looking Glass |Ring |Postcard - Church Lane Handsworth |Caddy and Cover |Pencil Drawing - Female - Drapery Study - background figure for St Theophilus and the Angel? |

See more random objects

My Bookmarks

You currently have no objects bookmarked.
You can bookmark objects to help you find them again easily when using this computer.