| 0,0 → 1,91 |
|---|
| <?php |
| |
| /** |
| * IO class. |
| * @license http://opensource.org/licenses/gpl-license.php GNU General Public License |
| * @copyright (c)2003, 2004 Tamlyn Rhodes |
| * @version $Id: io_mysql.class.php,v 1.7 2005/11/30 23:02:18 tamlyn Exp $ |
| */ |
| |
| //include the base IO class and generic SQL class |
| require_once dirname(__FILE__)."/iosql.class.php"; |
| |
| /** |
| * Class used to read and write data to and from a MySQL database. |
| * @package singapore |
| * @author Tamlyn Rhodes <tam at zenology dot co dot uk> |
| * @copyright (c)2004 Tamlyn Rhodes |
| */ |
| class sgIO_mysql extends sgIOsql |
| { |
| /** |
| * @param sgConfig pointer to a {@link sgConfig} object representing |
| * the current script configuration |
| */ |
| function sgIO_mysql() |
| { |
| $this->config =& sgConfig::getInstance(); |
| mysql_connect($this->config->sql_host, $this->config->sql_user, $this->config->sql_pass); |
| mysql_select_db($this->config->sql_database); |
| } |
| |
| /** |
| * Name of IO backend. |
| */ |
| function getName() |
| { |
| return "MySQL"; |
| } |
| |
| /** |
| * Version of IO backend. |
| */ |
| function getVersion() |
| { |
| return "$Revision: 1.7 $"; |
| } |
| |
| /** |
| * Author of IO backend. |
| */ |
| function getAuthor() |
| { |
| return "Tamlyn Rhodes"; |
| } |
| |
| /** |
| * Brief description of IO backend and it's requirements. |
| */ |
| function getDescription() |
| { |
| return "Uses a MySQL database. Requires a MySQL database server and the MySQL PHP extension."; |
| } |
| |
| function query($query) |
| { |
| return mysql_query($query); |
| } |
| |
| function escape_string($query) |
| { |
| return mysql_escape_string($query); |
| } |
| |
| function fetch_array($res) |
| { |
| return mysql_fetch_array($res); |
| } |
| |
| function num_rows($res) |
| { |
| return mysql_num_rows($res); |
| } |
| |
| function error() |
| { |
| return mysql_error(); |
| } |
| |
| } |
| |
| ?> |