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 */ } ?> Objects associated with: Birmingham, England (Page 1 of 5) - Birmingham Museums & Art Gallery Information Centre
             
Museums Home BMAGiC Home Search Browse BMAGiC Help About BMAGiC Contact Us
           

Objects associated with: Birmingham, England

42 items found.  
Page 1 of 5. View Page: 1 | 2 | 3 | 4 | 5 | Next | 

Click on each object below for more information.


19th Century 1 Guinea Banknote, Birmingham Bank

Accession Number:1965N221.174
Manufacturer:Birmingham Bank
Collection:Coins & Medals

Presented by R L Lloyd, 1965.
Birmingham Museums and Art Gallery


19th Century Commemorative Medal, Birmingham & Midland Institute

Accession Number:1941N253
Medallist:Joseph Moore
Collection:Coins & Medals

Birmingham Museums and Art Gallery


19th Century Commemorative Medal, Birmingham General Hospital Musical Festival

Accession Number:1885N1526.151
Maker:John Ottley
Collection:Coins & Medals

Purchased from John Staunton, William Staunton Collection, 1875.
Birmingham Museums and Art Gallery


19th Century Commemorative Medal, James Luckcock/Sunday School Jubilee

Accession Number:1977N25
Collection:Coins & Medals

Presented by Mr and Mrs C L Y Easton.
Birmingham Museums and Art Gallery


19th Century Commemorative Medal, Thomason's Warwick Vase

Accession Number:1885N1526.196
Maker:Sir Edward Thomason
Collection:Coins & Medals

Purchased from John Staunton, 1875.
Birmingham Museums and Art Gallery


19th Century Enamelled Coin Brooch/Burma Rupee

Accession Number:1973N95
Enameller:Edwin Steele
Collection:Coins & Medals

Purchase, F E Goldie Collection.
Birmingham Museums and Art Gallery


19th Century Penny Token by William Booth

Accession Number:1979N40
Maker:William Booth
Collection:Coins & Medals

Purchased from Peter Ireland (Format) Ltd.
Birmingham Museums and Art Gallery


19th Century Prize Medal Cliche, Birmingham & Midland Counties Exhibition

Accession Number:1955N196
Medallist: Thomas Ottley
Collection:Coins & Medals

Purchased from B Kent
Birmingham Museums and Art Gallery


19th Century Prize Medal for Birmingham Mechanics Institute

Accession Number:1885N1526.165
Collection:Coins & Medals

Presented by John Staunton, 1875.
Birmingham Museums and Art Gallery


19th Century Prize Medal, Awarded to Mrs S R Herbert, Birmingham Cattle & Poultry Show

Accession Number:1958N642
Medallist:John Ottley
Or: Thomas Ottley
Collection:Coins & Medals

Presented by A L Parry, 1958.
Birmingham Museums and Art Gallery

Page 1 of 5. View Page: 1 | 2 | 3 | 4 | 5 | Next | 

Refine your search:

My Bookmarks

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