PHP - Parent Url From Iframe

I want to pass button action at the parent page, this button is inside the iframe.

When displaying a webpage within iframe of facebook fan page, how I can detect that my page is viewed within the facebook iframe? I want to have a if else statement to change something within the page if it is viewed through facebook fanpage (not by direct visit).

hello.

say i have list and i want the correct children under each parent

so i have
$id
$parent_id
$type
$name

in the db i have
4 parents each with 2 children

id=1 - type=parent - parent_id=0 - name=p1
id=2 - type=parent - parent_id=0 - name=p2
id=3 - type=parent - parent_id=0 - name=p3
id=4 - type=parent - parent_id=0 - name=p4
id=5 - type=child - parent_id=1 - name=c1
id=6 - type=child - parent_id=1 - name=c2
id=7 - type=child - parent_id=2 - name=c3
id=8 - type=child - parent_id=2 - name=c4
id=9 - type=child - parent_id=3 - name=c5
id=10 - type=child - parent_id=3 - name=c6
id=11 - type=child - parent_id=4 - name=c7
id=12 - type=child - parent_id=4 - name=c8

so how would i do the code?

i thought i could do it like this but its not working.

Code: [Select]
<?php

$family = Family::find_all();
foreach($family as $familys){

$id = $familys->id;
$type = $familys->type;
$parent_id = $familys->parent_id;
$name = $familys->name;


echo'
<ul>';
if($type == "parent"){
echo $name;
} 
echo' </ul>


<li>';
if($type == "child" && $parent_id == $id){
echo $name;
} 
echo' 
</li>';
}
?>


all i get back is

    p1

    p2

    p3

    p4


no children

??



if i remove Quote

$parent_id == $id

from Quote

if($type == "child" && $parent_id == $id){


i get this

    p1

    p2

    p3

    p4

c1

c2

c3

c4

c5

c6

c7

c8

but they are not listed under the correct parent





i also tried moving the </ul> to the bottom but i get the same
Code: [Select]
<?php

$family = Family::find_all();
foreach($family as $familys){

$id = $familys->id;
$type = $familys->type;
$parent_id = $familys->parent_id;
$name = $familys->name;



echo'
<ul>';
if($type == "parent"){
echo $name;
} 
echo'


<li>';
if($type == "child"){
echo $name;
} 
echo' 
</li>
</ul>';
}
?>



any thoughts?

thanks

rick

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

Is there a way to get what page included it?

For example, if index.php includes header.php, how can header.php display 'index.php' automatically?