PHP - [php] Is This Normal I Think It Is :d

hello

i have some normal php functions that i want to put into a oop class.

i cant seem to make the right changes to make it work. could some one help please. thanks

these are the php functions

Code: [Select]
<?php

  function hasChild($parent_id)
  {
    $sql = "SELECT COUNT(*) as count FROM category WHERE parent_id = '" . $parent_id . "'";
    $qry = mysql_query($sql);
    $rs = mysql_fetch_array($qry);
    return $rs['count'];
  }
  
  function CategoryTree($list,$parent,$append)
  {
    $list = '<li>'.$parent['name'].'</li>';
    
    if (hasChild($parent['id'])) // check if the id has a child
    {
      $append++;
      $list .= "<ul class='child child".$append."'>";
      $sql = "SELECT * FROM category WHERE parent_id = '" . $parent['id'] . "'";
      $qry = mysql_query($sql);
      $child = mysql_fetch_array($qry);
      do{
        $list .= CategoryTree($list,$child,$append);
      }while($child = mysql_fetch_array($qry));
      $list .= "</ul>";
    }
    return $list;
  }
  function CategoryList()
  {
    $list = "";
    
    $sql = "SELECT * FROM category WHERE (parent_id = 0 OR parent_id IS NULL)";
    $qry = mysql_query($sql);
    $parent = mysql_fetch_array($qry);
    $mainlist = "<ul class='parent'>";
    do{
      $mainlist .= CategoryTree($list,$parent,$append = 0);
    }while($parent = mysql_fetch_array($qry));
    $list .= "</ul>";
    return $mainlist;
  }
?>


this is the class


Code: [Select]
<?PHP
require_once(LIB_PATH.DS.'database.php');

class Menu extends DatabaseObject {

protected static $table_name="menu";

protected static $db_fields = array(
'id',
'parent_id',
'name'
);


public $id;
public $parent_id;
public $name;


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

$id,
$parent_id,
$name) {

if(!empty($id)) {

$kw = new Menu();
$kw->id = (int)$id;
$kw->parent_id = (int)$parent_id;
$kw->name = $name;

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


//PUT FUNCTIONS HERE......

  function hasChild($parent_id)
  {
    $sql = "SELECT COUNT(*) as count FROM category WHERE parent_id = '" . $parent_id . "'";
    $qry = mysql_query($sql);
    $rs = mysql_fetch_array($qry);
    return $rs['count'];
  }
 
  function CategoryTree($list,$parent,$append)
  {
    $list = '<li>'.$parent['name'].'</li>';
   
    if (hasChild($parent['id'])) // check if the id has a child
    {
      $append++;
      $list .= "<ul class='child child".$append."'>";
      $sql = "SELECT * FROM category WHERE parent_id = '" . $parent['id'] . "'";
      $qry = mysql_query($sql);
      $child = mysql_fetch_array($qry);
      do{
        $list .= CategoryTree($list,$child,$append);
      }while($child = mysql_fetch_array($qry));
      $list .= "</ul>";
    }
    return $list;
  }
  function CategoryList()
  {
    $list = "";
   
    $sql = "SELECT * FROM category WHERE (parent_id = 0 OR parent_id IS NULL)";
    $qry = mysql_query($sql);
    $parent = mysql_fetch_array($qry);
    $mainlist = "<ul class='parent'>";
    do{
      $mainlist .= CategoryTree($list,$parent,$append = 0);
    }while($parent = mysql_fetch_array($qry));
    $list .= "</ul>";
    return $mainlist;
  }
?>

I have a string in php:
Quote

Sat, 28 Apr 2012 05:09:45 GMT

I want to convert it to timestamp
Example: 1335594473

Hi All,

When I put

echo memory_get_usage();

at the very beginning of a php file I get 51207808. Is this normal while there is not much processing to do ? This happens even for very small php files that only display html syntax.

Thanks!

Hello,   Is anybody aware of a statistical function in PHP which returns the inverse of the normal cumulative distribution, given a probability, mean and standard deviation as inputs?

Thank you.

i have Created a Session  with this code $_SESSION['USER_NAME'] = trim($_POST['username'])


How can i access the $_SESSION['USER_NAME'] in other Pages ;

and will this code for $var = $_SESSION[USER_NAME] 

can i get the SESSIOn value in " $var"  variable ??