PHP - Oop - Accessing Parent/child Classes

Hello.

i have some code that works with out using parent and child but i dont think im doing it in the correct oop way. would someone maybe please just have a little look for me please.

by the way.. i know im not ment to use global but thats how i was shown to do that on my tutorial videos.. i'll address that in another post

so.
in this example i have this pages class
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Pages {



protected static $table_name="pages";

protected static $db_fields = array(
'id',
'pageName',
'contTemp_id',
'contElements_id',
  'title',
'sub_title',
'description',
'about',
'image',
'created',
'dateMod',
'timeMod');


public $id;
public $pageName;
public $contTemp_id;
public $contElements_id;
public $title;
public $sub_title;
public $description;
public $about;
public $image;
public $created;
public $dateMod;
public $timeMod;



// "new" is a reserved word so we use "make"(or "build")
public static function make(

$id="",
$pageName="",
$contTemp_id="",
$contElements_id="",
  $title="",
$sub_title="",
$description="",
$about="",
$image="",
$created="",
$dateMod="",
$timeMod="") {

if(!empty($title)) {

$kw = new NavL3();
$kw->id = (int)$id;
$kw->pageName = $pageName;
$kw->contTemp_id = (int)$contTemp_id;
$kw->contElements_id = (int)$contElements_id;
$kw->title = $title;
$kw->sub_title = $sub_title;
$kw->description = $description;
$kw->about = $about;
$kw->image = $image;
$kw->created = $created;
$kw->dateMod = $dateMod;
$kw->timeMod = $timeMod;

return $kw;
}else{
return false;
}
} //end function make


public static function find_by_pageName($id){
    global $database;

$sql = "SELECT * FROM ".self::$table_name." WHERE id='".$database->escape_value($id)."'";
$result_array = self::find_by_sql($sql);

return !empty($result_array) ? array_shift($result_array) : false;
}


public static function find_by_pageID($pageID=0){
global $database;
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$database->escape_value($pageID)." LIMIT 1";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}


// Common Database Methods
public static function find_all(){
global $database;
$sql = "SELECT * FROM ".self::$table_name."";
return self::find_by_sql($sql);
}

public static function find_by_id($id=0){
global $database;
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$database->escape_value($id)." LIMIT 1";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}

public static function find_by_sql($sql){
global $database;
$results_set = $database->query($sql);
$object_array = array();
while($row = $database->fetch_array($results_set)){
$object_array[] = self::instantiate($row);
}
return $object_array;
}

public static function count_all(){
global $database;
$sql = "SELECT COUNT(*) FROM ".self::$table_name;
$results_set = $database->query($sql);
$row = $database->fetch_array($results_set);
return array_shift($row);
}

public static function instantiate($result){
$object = new self;
foreach($result as $attribute => $value){
if($object->has_attribute($attribute)){
$object->$attribute = $value;
}
}
return $object;
}

private function has_attribute($attribute){
$object_vars = $this->attributes();
return array_key_exists($attribute, $object_vars);
}


protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}



} //end class blogs
?>



and i have this conttemp class
Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Conttemps {

protected static $table_name="contTemps";

protected static $db_fields = array(
'id',
'name',
'created',
'dateMod',
'timeMod');


public $id;
public $name;
public $created;
public $dateMod;
public $timeMod;



// "new" is a reserved word so we use "make"(or "build")
public static function make(

$id,
$name="",
$created="",
$dateMod="",
$timeMod="") {

if(!empty($name)) {

$kw = new Templates();
$kw->id = (int)$id;
$kw->name = $name;
$kw->created = $created;
$kw->dateMod = $dateMod;
$kw->timeMod = $timeMod;

return $kw;
}else{
return false;
}
} //end function make



public function find_contTemp($pageID){

$page = Pages::find_by_pageID($pageID);
$pageCID = $page->contTemp_id;

$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$pageCID."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}


// Common Database Methods
public static function find_all(){
global $database;
$sql = "SELECT * FROM ".self::$table_name."";
return self::find_by_sql($sql);
}

public static function find_by_id($id=0){
global $database;
$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$database->escape_value($id)." LIMIT 1";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}

public static function find_by_sql($sql){
global $database;
$results_set = $database->query($sql);
$object_array = array();
while($row = $database->fetch_array($results_set)){
$object_array[] = self::instantiate($row);
}
return $object_array;
}

public static function count_all(){
global $database;
$sql = "SELECT COUNT(*) FROM ".self::$table_name;
$results_set = $database->query($sql);
$row = $database->fetch_array($results_set);
return array_shift($row);
}

public static function instantiate($result){
$object = new self;
foreach($result as $attribute => $value){
if($object->has_attribute($attribute)){
$object->$attribute = $value;
}
}
return $object;
}

private function has_attribute($attribute){
$object_vars = $this->attributes();
return array_key_exists($attribute, $object_vars);
}


protected function attributes(){
$attributes = array();
foreach(self::$db_fields as $field){
if(property_exists($this, $field)){
$attributes[$field] = $this->$field;
}
}
return $attributes;
}

protected function sanitized_attributes(){
global $database;
$clean_attributes = array();
foreach($this->attributes() as $key => $value){
$clean_attributes[$key] = $database->escape_value($value);
}
return $clean_attributes;
}

public function save(){
return !empty($this->id) ? $this->update() : $this->create();
}

public function create(){
global $database;
$attributes = $this->sanitized_attributes();
$sql = "INSERT INTO ".self::$table_name." (";
$sql .= join(", ", array_keys($attributes));
$sql .= ") VALUES ('";
$sql .= join("', '", array_values($attributes));
$sql .= "')";
if($database->query($sql)){
$this->id = $database->insert_id();
return true;
}else{
return false;
}
}

public function update(){
global $database;
$attributes = $this->sanitized_attributes();
$attribute_pairs = array();
foreach($attributes as $key => $value){
$attribute_pairs[] = "{$key}='{$value}'";
}
$sql = "UPDATE ".self::$table_name." SET ";
$sql .= join(", ", $attribute_pairs);
$sql .= " WHERE id=".$database->escape_value($this->id);
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}

public function delete(){
global $database;
$sql = "DELETE FROM ".self::$table_name." ";
$sql .= "WHERE id=".$database->escape_value($this->id);
$sql .= " LIMIT 1";
$database->query($sql);
return ($database->affected_rows() == 1) ? true : false;
}




} //end class blogs
?>


the bit im interested in is this function in the Conttemp class

Code: [Select]
public function find_contTemp($pageID){

$page = Pages::find_by_pageID($pageID);
$pageCID = $page->contTemp_id;

$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$pageCID."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}


it call a function in from the Pages class.

i could take the function from here and put it in the Pages class i guess but i was wondering about Exends.

should i do class Conttemps extends Pages {

and use something like

Code: [Select]
public function find_contTemp($pageID){

$pageCID= Pages::contTemp_id;


$sql = "SELECT * FROM ".self::$table_name." WHERE id=".$pageCID."";
$result_array = self::find_by_sql($sql);
return !empty($result_array) ? array_shift($result_array) : false;
}

i guess that wont work because its not getting the $pageID

but anyway..

any thoughts ????

thanks
rick

I have a major problem;

I have two tables - Category and Product

The catID is the primary key for Category and acts as the foreign key for Product. I have some example data below;

CATEGORY
catID: 3
cat: Pink

PRODUCT
prodID: 1
product: Fuchsia
catID: 3

prodID: 2
product: Dark Pink
catID: 3

what I want is the page to display the data like this?

Header: Pink

Content:
Fuchsia
Dark Pink

Below is the code thus far;




Code: [Select]
<?php

error_reporting(E_ALL ^ E_NOTICE);
ini_set("display_errors", 1);

require ('includes/config.inc.php');

include ('./includes/header.html');

require (MYSQL);

include ('./includes/main.html');

if($id = isset($_GET['catID'])) 
{
$q = ('SELECT `category`.`catID` , `category`.`cat` , `product`.`product`
FROM `product`
LEFT JOIN `hairext`.`category` ON `product`.`catID` = `category`.`catID`
WHERE `product`.`catID`="'.$_GET['catID'].'"');

$r = mysqli_query($dbc, $q);

echo '<div id="right">';

$num = mysqli_num_rows($r);

for ($j = 0 ; $j < $num ; ++$j)
{
$row = mysqli_fetch_row($r);
echo '<h1>' . $row[1] . '</h1>';
}

while($row = mysqli_fetch_array($r))
{
echo '<p>';
echo $row[2];
echo "<br />";
echo '</p>';
}

echo '</div>';

}

include ('./includes/footer.html');

?>
At the moment, this is not doing what I want, I apologise if this is very long winded, but how do I solve this problem please?

I have a user class that is very dependent on the database class, which is why the user class extends the database. I tried creating a protected method in the parent class called getDBCObject, which returned the database object/variable/handle that I want the user to have access to. I tried the method below, but it doesn't work:


<?php

/*
 * @DATABASE
 * ~~~~~~~~~~~~
 * @FILE DESCRIPTION: Handles all database related processes
 * @LAST MODIFIED: April 4, 2012
 */

class database
{
    protected $dbc;
    
    function __construct($db_host, $db_name, $db_user, $db_password)
    {
        try
        {
            $this->dbc = new PDO("mysql:host=$db_host;dbname=$db_name", $db_user, $db_password);
        }
        catch(PDOException $e)
        {
            echo '<b>An error occured while trying to create a database connection: </b>'. $e->getMessage();
        }
    }
    
    /*
     * @METHOD  getDBCObject
     * @DESC    Gives the $dbc object/variable to its child classes
     */
    
    protected function getDBCObject()
    {
        return $this->dbc;
    }
}

?>



My user class:


<?php

/*
 * @DATABASE
 * ~~~~~~~~~~~~
 * @FILE DESCRIPTION: User related proccess
 * @LAST MODIFIED: April 5, 2012
 */

class user extends database
{
    protected $dbc;
    
    public function __construct()
    {
        if(parent::getDBCObject() == null)
        {
            echo '<br/>A database class/connection is required before creating the user class.';
        }
    }
    
    public function isLoggedIn()
    {
        if($_COOKIE['user'])
        {
            //soon to come
        }
        else
        {
            return false;
        }
    }
}

?>



Any feedback on how I can let the user class use the $dbc variable in the database class?

Hi,
I've a two classes A,B. A is a parent class and B is a child class. B is extends from A. I made an object of class A. Now i want to access function of class B from this object instance.
e.g
Code: [Select]
class A
{
    function myfunctiona()
    {
        .......
        .......
    }
}

class B extends A
{
   function chlidfunction()
   {
       return "hyne";
   }
}

$sani = new A();
//here i want to access
echo $sani->b->childfunction();

please guide how can called child class function from parent object instance?
Thanks

Ok, here is the whole code for the downline, but the problem is that it doesn't show members below that one

I mean if b follows a, and c follows b and I opened the page of A, it will only show A's info, and not bring B and C in the downline


Code: [Select]
<?php

if($_REQUEST["i"]){
GenerateTree($_REQUEST["i"]);
} else{
GenerateTree($_GET['id']);
}

function GenerateTree($memberid){
$l1="<img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' />";$l2="<img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' />";
$query = "SELECT * FROM users where recruiteris='".$memberid."' order by type";
//echo $query;
$result = mysql_query($query);
//var_dump($result);

while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     if($row["type"]=="Company"){$l1=getDownline($row["id"]);}
if($row["type"]=="client"){$l2=getDownline($row["id"]);}
}
mysql_free_result($result);

echo "<table border='0' class='mainTable' cellspacing='0' cellpadding='3' style='width:100%'>\n";
echo "<tr><td colspan='3' style='text-align:center;'>Login ID: ".$memberid.getInfo($memberid)."<br />"."</td></tr>";
echo "<tr><td colspan='3'>".getDownline($memberid)."</td></tr>";
echo "<tr><td style='width:33%;'>".$l1."</td><td style='width:33%;'>".$l2."</td>";
echo "</table>\n";
}

function getDownline($memberid){
$query = "SELECT * FROM users where recruiteris='".$memberid."' order by type";
//echo $query;
$result = mysql_query($query);
//var_dump($result);
$final = "<table border='0' style='width:100%;' class='internalTable' cellspacing='0' cellpadding='2'>\n";
$final .= "<tr>";
$nothing=true; $x=0; $pre;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
$x++; $_SESSION['s']=0;
if($row["type"]=="Company" && $x==1){$final .= "<td style='width:33%; background-color:#FFFFEC;' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";}
if($row["type"]=="client" && $x==2){$final .= "<td style='width:33%; background-color:#E1F0FF;' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";}
if($row["type"]=="client" && $x==1){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td><td style='width:33%; background-color:#E1F0FF' title='".getToolTip($row["login_id"])."'><a href='gen.php?i=".$row["login_id"]."'>".$row["login_id"]."</a><br />".$row["m_name"]."<br />Position: ".$row["form_type"]."<br />Downline - ".getCount($row["login_id"]).$_SESSION['s']."</td>";}

$pre = $row["type"];
$nothing=false;
}
if($nothing){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td><td style='width:34%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td>"; }
if($x==1 && $pre=="Company"){$final .= "<td style='width:33%'><img src='icon.gif' width='33' height='45' alt='No Record' longdesc='#' /></td>";}
mysql_free_result($result);
$final .= "</tr>";
$final .= "</table>\n";
return $final;
}

function getToolTip($id){
$query = "SELECT * FROM users where id ='".$id."'";
$result = mysql_query($query);
$res;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     $res = "fade=[off] cssheader=[toolHeader] cssbody=[toolBody] header=[Detail For ID () - ".$id."] body=[".$row["m_name"]."<br />Address:<br />".$row["address"]."]";
}
mysql_free_result($result);
return $res;
}

function getInfo($id){
$query = "SELECT * FROM users where id='".$id."'";
$result = mysql_query($query);
$res;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     $res = "<br />Name: ".$row["fname"]."<br />National ID: ".$row["nid"]."<br />";
}
mysql_free_result($result);
return $res;
}

function getCount($id){
$query = "SELECT * FROM users where recruiteris='".$id."'";
$result = mysql_query($query);
$count = mysql_num_rows($result);

$_SESSION['s'] = $_SESSION['s']+$count;
while ($row = mysql_fetch_array($result, MYSQL_BOTH)) {
     getCount($row["id"]);
}
mysql_free_result($result);
//echo $count."<br />";
return "";
}

// Closing connection
mysql_close($link);


?>

Why won't my unset remove the array from the parent $data[0] array?

Code: [Select]
foreach ($data[0] as $k => $r)
{
if (($r['feedid'] !== $user_info['uid']) && ($r['action_id'] == 'newuser'))
{
unset($data[0][$k]);
}
}

I'm pulling a list of topics from my DB and they are structured hierarchally using the typical id | parent_id scheme
The array I end up with from the DB is one large one with keys representing the unique id of each data result...The problem is getting past the 2d scope of the array.  I know this will require a recursive function and I've been at it for hours but can't seem to wrap my hurting head around it!  How do I get my orignal array in this form:
Array
(
    [0] => Array
        (
            [1] => top parent
            [2] => top parent
            [3] => top parent
            [9] => top parent
        )

    [2] => Array
        (
            [4] => #1 child of 2
            [5] => #2 child of 2
        )

    [3] => Array
        (
            [6] => #1 child of 3
        )

    [4] => Array
        (
            [7] => #1 child(subsub) of 4
            [8] => #2 child(subsub) of 4
        )

)


To look something more like this? :
Array
(
    [1] => top parent
    [2] => Array
        (
            [4] => Array
                (
                    [7] => #1 child(subsub) of 4
                    [8] => #2 child(subsub) of 4
                )

            [5] => #2 child of 2
        )

    [3] => Array
        (
            [6] => #1 child of 3
        )

    [9] => top parent
)


notice how the 2nd array has all the proper dimensions according the the DB hierarchy.
Thank you

ps. or maybe I should work from a different array to start from...I'm open to suggestions

I have these two classes:
Code: [Select]
<?php
class A {
private $id;
public function __construct() {
$this->id = '11111';
}
public function getProperty($prop) {
return $this->$prop;
}
}?>
Code: [Select]
<?php
class B extends A {
private $message = "Nope, can't see it";
public function __construct() {
parent::__construct();
$this->message = "Yep, I can see it";
}
}?>
I tried this, but it just outputs the id (the first call)
Code: [Select]
$class = new B;
echo $class->getProperty('id');
echo $class->getProperty('message');
Why is that? I thought I could use a parent method on a child property..


*EDIT* Using a public or protected visibility on the message property gets me the output I expect...how come?

Mmm i'm not sure if i'm approaching this correctly.

Anyways, I wanted to create a multi-level thread, Where the child thread would be after the parent thread.

Something like this:

Hello World
       - Hello World
               - Hi!
               - What's up?
       - Hi Bob!
Goodbye World
       - ....This guy got issues
       - Dude! You should watch Despicable Me! "It's so fuzzy i'm going to dieee!"


Anyways, so my table looks something along the line of this:

|    post id   |    parent_id    |            title            |      body    |   date      |
      1                |       NULL        |    Hello                  | Hi, i'm K    |   date
      2                |       NULL        |    Thread One       | Body One  |   date
      3                |          1           |    Hello World | Body One  |   date
      4                |          2           |    Thread post 4   | Body One  |   date
      5                |          1           |    Thread post 5   | Body One  |   date
      6                |          1           |    Thread post 6   | Body One  |   date
      7                |          3           |    Hi What's up    | Body One  |   date


And here's the PHP code, although it's not very neat I want to clean it up and make it neater.  I can only go two level deep so far.   Any suggestion or recommendations? 

Using while & for:


// Select * Threads
$q = "SELECT * FROM test_db ORDER BY post_id ASC";
$r = @mysql_query($q);



while ($pid_row = @mysql_fetch_object($r)) {

// Array
$pid_arr[] = $pid_row->post_id; // Assign Indexes to Post ID
$ppid_arr[] = $pid_row->parent_id; // Assign Indexes to ParentID
$md_arr = array($pid_arr, $ppid_arr);  // Create multi-dimensional array matrix

$parent_id = $pid_row->parent_id;




}

for ($i = 0; $i < count($pid_arr); $i++) {

for ($a = 0; $a < count($ppid_arr); $a++) {
$pid = $pid_arr[$i]; // pid = post id
$ppid = $ppid_arr[$i]; // ppid = parent id

//echo "<div>~~ PID $pid ~~ PPID $ppid ~~</div>";

if ($ppid === NULL) {
$ppid_is_null = " & parent_id is NULL";
} else {
$ppid_is_null = NULL;
}

// Select Top level Thread
$z = "SELECT * FROM test_db WHERE post_id = '$pid'";
$y = @mysql_query($z);

while ($t_row = @mysql_fetch_object($y)) 
{

$title = $t_row->title;  // title of child thread
$level = $t_row->level;  // level of child thread...is this useful?
}




// Display top level thread lvl 1
if ($ppid === NULL) {  // If the parent_id is NULL, display top level thread
echo '<div>PID: ' . $pid . ' || PPID: ' . $ppid . " || Title: " . $title . "</div><br>\n";

$post = $pid; // PostID = 1
$parent = $ppid; // Parent ID ex: [1]

// Get child id, where parent id = [1]
// trying to get the child thread here...but it's not working
$child_q = "SELECT * FROM test_db WHERE parent_id = '$post'";
$child_r = @mysql_query($child_q);

while($c_row = @mysql_fetch_object($child_r)) {
$c_arr[] = $c_row->post_id;
$c_ppid_arr[] = $c_row->parent_id;
}
for ($n = 0; $n < count($c_arr); $n++) {
if ($c_ppid_arr[$n] === $post) {
echo "<div>$c_arr[$n]</div>";



}

}
break;

//echo "<div>PID: $pid</div>";




} 




break;
}

}



Using While:

<?php 
require_once('db_connection');
echo '<hr><hr><br>';

// I just realized that selecting * where parent id is null might limit the amount of rows retrieved.

// Query to select threads
$n = NULL;
$q = "SELECT * FROM test_db WHERE (test_db.parent_id is NULL) Order By date ASC";
$r = @mysql_query($q);

while ($threads = @mysql_fetch_object($r)){
$pid = $threads->post_id;
$sid = $threads->subject_id;
$parent_id = $threads->parent_id;
$title = $threads->title;
$body = $threads->body;



echo '<div>PostID: ' . $pid . ' || Parent: ' . $parent_id . ' || SubjectID: ' . $sid . ' || Title: ' . $title . ' || Body: ' . $body . '</div>';

$q2 = "SELECT * FROM test_db WHERE parent_id = '$pid' Order by date DESC";
$r2 = @mysql_query($q2);

while ($level2 = @mysql_fetch_object($r2)) {
$level2_pid = $level2->post_id;
$level = 1.5 *($level2->level); // lvl 2: 3em


echo '<div style="text-indent:' . $level . 'em">' . 'PostID: ' . $level2->post_id . ' || ParentID: ' . $level2->parent_id . '</div>';


$q3 = "SELECT * FROM test_db WHERE parent_id = '$level2_pid'";
$r3 = @mysql_query($r3);
while ($level3 = @mysql_fetch_object($r3)) {

$level3 = 1.5 + $level;

echo '<div style="text-indent:' . $level3 . 'em">' . 'PostID: ' . $level3->post_id . ' || ParentID: ' . $level3->parent_id . '</div>';

}






}


}


?>


I'm not a comp. sci major or anything, so I'm learning this as I go.  Any help would be greatly appreciated.   It seems like the while & for is more practical, but i'm not quiet sure.  What am I doing wrong?

- K

I just joined this forum today ^_^  Hope to be good friends with you guys and gals

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=356195.0

Hello Guys,

Need a little help here. I have a db structure like this

cat_id |  cat_name | cat_status | parent_id
1        First Test         1                  0
2        Just testing       1                    0
4        Books               1                    2
5        Cars               1                    0
6        Ford               1                  5

If the parent_id = 0 it is considered to be the parent.
If it is a number it is considered a child and referencing the parent

I want to be able to query the database and grab the cat and the sub cat and echo it on my page. Its like a classified ads application.

Here is my while loop that I currently have which only echo's out the parent category. I would like to echo the child category under the respective parent category.

I think I would have to do a loop within a loop, but not sure how to do it..


$query  = "SELECT * FROM ad_category WHERE cat_status='1' && Parent_id='0' ORDER BY cat_name";
$result = mysql_query($query);

while($row = mysql_fetch_row($result))
{
   
    $cat_name = $row[1];
    

$cupper = UCWords($cat_name);

    echo $cupper . "<br>" ;
    
        
} 




Thanks for your help in advance

I've been spending long hours learning about classes and their magic methods. I just came across a tutorial which showed a constructor like this:

class Device {
    //...
    public function  __construct(Battery $battery, $name) {
        // $battery can only be a valid Battery object
        $this->battery = $battery;
        $this->name = $name;
        // connect to the network
        $this->connect();
    }
    //...
}

the Battery part instantly caught my attention. Here had previously made a Battery class (and a more complete Device class) but the next thing he did really caught my interest:

$device = new Device(new Battery(), 'iMagic');
// iMagic connected
echo $device->name;
// iMagic

what the hell is going on here? Is this another way to include the methods and properties of one class into another class, in order words is this the same thing as:

class Device extends Battery

I don't think so because this new Battery() thing looks more like its creating an object inside the Device object. Previously the only way I could to that was to type $battery = new Battery() inside one of my methods. But this looks like hes doing something different. Can anyone explain whats going on here?   The whole tutorial is he http://code.tutsplus...-php--net-13085 in the main Device method he has a premade $battery variable to hold the Battery object. Sometimes I have multiple classes containing functions which I'd like to include in my main class. I can only extend one class, so I usually extent a class containing only properties, no methods. I still don't know what difference making that info class abstract is, I'd appreciate if anyone could tell me.   Also I'd love to know what the point in static methods is. I've never used them because I've never seen the point. Is it just to make it easier to call the methods because you don't need to create an object instance to call them? Sorry for the extra questions, the first one is what I'm really wondering about.    

Not sure how to describe what I'm trying to do here in the title, but here goes with what I am trying to accomplish.

I've got a few hundred lines of code in total so far, so I'll try to keep it as short as I can. I've got an application that I am programming using classes for each module and right now I am coding the base classes that I need in order for it to run (database, errors, logging, etc). What I'm doing for my database class is I have a query factory and it extends the MySQLi class so I can process, clean and code the rest of my app faster. I also have another, unrelated class "Error", which will be used for processing errors I might come across.

I'd rather do it this way instead of having to call trigger_error and error_log every time there is an error. I'd also not like to have to call a new instance of an object every time I need to use something from that class. Is there any way I can call a class within a class and return it as an object for all the methods within the class?

I've tried the methods below, but no luck I've tried others, but I'm trying to keep it brief and get what I'm trying to do across.

<?php

class QueryFactory extends MySQLi {

public  $err = new error(); //Doesn't work.
public  $err = error(); //Nope.

#This is the function that I need the $err object for.
function set($fields, $newvals) {

if ( is_array($fields) && is_array($newvals) ) {

if ( count($fields) != count($newvals) ) {
//Instead of below, I want to do something like $err->('Array lengths must match for method', 256, $islogged = 1);
                              trigger_error('Array lengths must match for method', 256);
}

}
}

}


The thing is, I have a "run.inc.php" which does include and create new objects for running just the basic app and if I try to redeclare the error class in query.class.php, it gives me an error saying I can't do that, but if i try to call $err from the page that has all the classes defined it throws an error saying that my method is undeclared. I'd like my error class be available to every other class I create so I can display and log errors as needed. Any suggestions or links to point me where I'd like to go?

Hey guys!

I have the following strange problem:

Listing 1:

echo $n;   // Result is 20167 !

      if($child->id == $n){
      $image = array();
      $image[] = '"' . $child->id . '"';
      $image[] = '"' . $child->name . '"';
      $image[] = '"' . $misc->clean_path($child->file) . '"';
      $image[] = '"' . $child->file_name . '"';
      $image[] = '"' . $child->file_type . '"';
        $image[] = '"' . $path . '"';
      
      $images[] = implode("\t", $image);
      }

The if-statement is not true... so probably there's no $child->id with value 20167.... but watch this:

Listing 2:
if($child->id == 20167){
      $image = array();
      $image[] = '"' . $child->id . '"';
      $image[] = '"' . $child->name . '"';
      $image[] = '"' . $misc->clean_path($child->file) . '"';
      $image[] = '"' . $child->file_name . '"';
      $image[] = '"' . $child->file_type . '"';
        $image[] = '"' . $path . '"';
      
      $images[] = implode("\t", $image);
      }

Now with the hard coded value 20167 the statement is true and gives one result....

Strange, isn't it?

I placed the following three functions/test direct before the if-statement:
var_dump($n);    
Result: NULL


echo $n
Result: 20167 

echo "{$n}";
Result:


I tested one function at a time.


How can this happen?


Thanks to all! :-)

HEy Guys
Here is a snippet of an array:

SimpleXMLElement Object
(
    [report1] => SimpleXMLElement Object
        (
            [ReportHost] => Array
                (
                    => SimpleXMLElement Object
                        (
                            [HostName] => 192.168.2.34
                            [startTime] => Thu Dec 17 13:58:49 2009
                            [stopTime] => Thu Dec 17 15:13:13 2009
                            [netbios_name] => (unknown)
                            [mac_addr] => (unknown)
                            [dns_name] => (unknown)
                            [os_name] => (unknown)
                            [num_ports] => 2
                            [num_lo] => 0
                            [num_med] => 0
                            [num_hi] => 0
                            [ReportItem] => Array
which is printed using print_r($a)
now how can i access [HostName] => 192.168.2.34 in the $a array??
Thanks in advance