Menu
Community /Pin to ProfileBookmark
@NogDogJul 13.2007 — #If you want to set the database connection values via the constructor of your database class, then the blog class will have to call its parent's constructor with the desired values.
Therefore, if you use this technique, you'll need to pass the $config array to your blog class when you instantiate it (along with the other parameters).@NogDogJul 14.2007 — #What I do is instantiate my database class once in my main script. Then for any other class that needs to use it, I pass the object to its constructor:
Then the main script would be something like:
I don't know if this is considered an OOP "best practice", but it works, and it keeps me from getting too confused. ?@NogDogJul 14.2007 — #I have a query result class, and when you use the select method from my db class, it returns an instance of that result class, with the MySQL result resource ID as an attribute. That result class has a number of different methods for accessing the result rows, such as:
relatively new to OOP passing VARs MySQL problem
I am fairly new to OOP with php and i’m having a problem with my SQL connection im getting this error:
Warning: mysql_connect() [function.mysql-connect]: Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2) in /home/.mantra/uername/myurl.com/includes/class_database.php on line 30
class database:
[code=php]
<?php
class database
{
public $host;
public $username;
public $password;
public $database;
function __construct($config)
{
$this->host = $config[‘db’][‘host’];
$this->username = $config[‘db’][‘username’];
$this->password = $config[‘db’][‘password’];
$this->dbname = $config[‘db’][‘database’];
}
function write()
{
echo $this->host.'<br/>’;
echo $this->dbname;
}
//connect to the database
function connect()
{
$conn = mysql_connect($this->host, $this->username, $this->password) or die(mysql_error());
$SelDB = mysql_select_db($this->dbname);
return $conn;
}
//run a mysql command
function execute($strSQL)
{
$result = mysql_query($strSQL) or mysql_error();
return $result;
}
//count the number of rows
function row_count($result)
{
$row = mysql_num_rows($result);
return $row;
}
}
?>
[code=php]
<?php
class blog extends database
{
public $title;
public $body;
public $meta;
//construct the
function __construct($title=NULL, $body=NULL, $meta=NULL)
{
$this->connect();
$this->title = $title;
$this->body = $body;
$this->meta = $meta;
}
//add a new item to the blog
function insert_blog($_POST)
{
foreach ($_POST as $name=>$value)
{
$name = mysql_real_escape_string(htmlspecialchars($value));
}
$query = “INSERT INTO `blog` (title, text, meta, author)
VALUES (‘$title’, ‘$body’, ‘$meta’, ‘John Knowles’)”;
mysql_query($query) or die(mysql_error());
return ‘New Blog Created’.”nr”;
}
//update an item in the blog
function edit_blog($_POST)
{
foreach ($_POST as $name=>$value)
{
$name = mysql_real_escape_string(htmlspecialchars($value));
}
$query = “UPDATE `blog` (title, text, meta, author)
VALUES ($title, $body, $meta, ‘John Knowles’) WHERE id=’$id'”;
}
//display the blog on a page
function display_blog($num, $id=”, $search=”)
{
if (!empty($id))
{
$id = “WHERE id=’$id'”;
}
if (!empty($search))
{
$id = “WHERE text=’$search'”;
}
$query = “SELECT * FROM `blog` $id ORDER BY ‘date’ DESC LIMIT $num”;
$result = mysql_query($query) or die(mysql_error());
return $result;
}
}
?>
please be aware this was just a list of functions so it is not in any OOP state atm its a slow work in progress.
any help will be greatly appreciated (including links to external ooPHP/MySQL resources if anyone has any)
Sign in
to post a comment8 Comments(s) ↴
0
@NogDogJul 13.2007 — #If you want to set the database connection values via the constructor of your database class, then the blog class will have to call its parent's constructor with the desired values.[code=php]
//construct the
function __construct($config, $title=NULL, $body=NULL, $meta=NULL)
{
parent::__construct($config);
$this->connect();
$this->title = $title;
$this->body = $body;
$this->meta = $meta;
}
[/code]Therefore, if you use this technique, you'll need to pass the $config array to your blog class when you instantiate it (along with the other parameters).
0
@NogDogJul 14.2007 — #What I do is instantiate my database class once in my main script. Then for any other class that needs to use it, I pass the object to its constructor:[code=php]
class MyClass
{
private $db;
function __construct($db)
{
if(is_object($db))
{
$this->db = $db;
}
else
{
throw new Exception("Non-object parameter supplied to constructor");
}
}
function myMethod()
{
$result = $this->db->query("SELECT * FROM table");
}
}
[/code]Then the main script would be something like:
[code=php]
require_once "Database.class.php";
require_once "MyClass.class.php";
$db = new Database();
$mc = new MyClass($db);
[/code]I don't know if this is considered an OOP "best practice", but it works, and it keeps me from getting too confused. ?
0
@NogDogJul 14.2007 — #I have a query result class, and when you use the select method from my db class, it returns an instance of that result class, with the MySQL result resource ID as an attribute. That result class has a number of different methods for accessing the result rows, such as:[code=php]
// returns one specified result row as an associative array:
function getRow($row = NULL)
{
if($row !== NULL and is_numeric($row))
{
mysql_data_seek($this->result, (int) abs($row));
}
return(mysql_fetch_assoc($this->result));
} // end getRow()
// returns entire result set as 2-dim array: dim 1 = row number, dim 2 = field name:
function getArray()
{
mysql_data_seek($this->result, 0);
$data = array();
while($row = mysql_fetch_assoc($this->result))
{
$data[] = $row;
}
return($data);
}
[/code]