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 */ } ?> Collection: Topographical Views - Lines Family Collection - Birmingham Museums & Art Gallery Information Centre
             
Museums Home BMAGiC Home Search Browse BMAGiC Help About BMAGiC Contact Us
           

Collection: Topographical Views - Lines Family Collection

There are 6 objects in this collection.
Page 1 of 1.
Click on each object below for more information.


Oil Painting - Birmingham from the Dome of St Philip's Church in 1821

Accession Number:1893P72
Artist:Samuel Lines Snr
Collection:Topographical Views - Lines Family Collection

Presented by Frederick Thomas Lines, 1893.
Birmingham Museums and Art Gallery


Oil Painting - Birmingham Town Hall and Queen's College

Accession Number:1937P369
Artist:Samuel Lines Snr
Collection:Topographical Views - Lines Family Collection

Presented by the Friends of Birmingham Museums and Art Gallery, 1937.
Birmingham Museums and Art Gallery


Pencil Drawing - St Mary's Church, Handsworth

Accession Number:1977V101
Artist:Lines Family
Collection:Topographical Views - Lines Family Collection

Birmingham Museums and Art Gallery


Pencil Drawing - View of Perry Barr

Accession Number:1977V94
Artist:Lines Family
Collection:Topographical Views - Lines Family Collection

Birmingham Museums and Art Gallery


Watercolour - Near Rose Mill 1826 - View Near Rose Mill 1826

Accession Number:1977V126
Artist:Lines Family
Collection:Topographical Views - Lines Family Collection

Transferred from Birmingham Reference Library.
Birmingham Museums and Art Gallery


Watercolour - Soho House Handsworth

Accession Number:1988V1538
Artist:Lines Family
Collection:Topographical Views - Lines Family Collection

Transferred from Birmingham Reference Library.
Birmingham Museums and Art Gallery

Page 1 of 1.

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.