Hey everyone.
I've never really used classes or constructors/destructors or anything like that before. I did some code to play with them and kinda learn how to do it... This is a mysql database class I wrote today. Any tips? Further information so I can learn more about it? I still don't understand how to extend classes.
<?PHP
class database {
function connect($host, $user, $pass, $database) {
$link = mysql_connect($host, $user, $pass);
if (!$link) {
die('Could not connect: ' . mysql_error());
}
// set $database active
$selected = mysql_select_db($database, $link);
if (!$selected) {
die('Could not set '.$database.' as the active database: ' . mysql_error());
}
return $link;
}
function sanitize($input) {
// sanitizes a string for input into an SQL statement
if (get_magic_quotes_gpc()) {
$input = stripslashes($input);
}
$input = mysql_real_escape_string($input);
return $input;
}
function query($query) {
// in case the query wasn't escaped...
$query = mysql_real_escape_string($query);
$result = mysql_query($query);
if (!$result) {
// the query failed. Spit out errors and kill script.
$dieMessage = 'The query failed: ' . mysql_error() . "\n" . 'Whole query: ' . $query;
die($dieMessage);
}
// the query ran successfully, return result
return $result;
}
}
?>
