Hi all, i tried to follow a tutorial on the website,
http://www.intranetjournal.com/articles/200408/ij_08_05_04a.html
to build a CMS website
i having a parse error on the code, but i dont see anything wrong with the coding. Hope someone here can point out my errors.
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in d:\easyphp1-8\www\cms est1.php on line 36
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in d:\easyphp1-8\www\cms est1.php on line 40
Thanks for reading.
<?php
class first_class{
var $settings;
function connection(){
$settings['host'] = "localhost";
$settings['username'] = "kitaeshi";
$settings['password'] = "cheeze";
$settings['database'] = "dababase1";
return $settings;
}
}
class second_class extends first_class{
var $link;
var $theQuery;
function setConnection(){
$setting = first_class::connection();
$host = $settings['host'];
$user = $settings['username'];
$pass = $settings['password'];
$db = $settings['database'];
$this->link = mysql_connect($host, $user, $pass);
mysql_select_db($db);
register_shutdown_function(array(&$this, 'close'));
}
function query($query){
$this->theQuery = $query;
return mysql_query($query, $this->link);
}
function fetchArray($result){
return mysql_fetch_array($result);
}
function close(){
mysql_close($this->link);
}
}
$connector = new second_class();
$result = $connector->query(“SELECT email FROM table1”);
$row = $connector->fetchArray($result);
print $row[“email”];
?>