PHP - Jquery Droppable() Get New Parent Container

I have one table but i try to make like the result not finished. Hmm.. can you see my table :  FireShot Screen Capture #003 - 'localhost _ 127_0_0_1 _ pmis_dbase _ rekening_kegiatan I phpMyAdmin 4_0_4_1' - localhost_phpmyadmin_index_php_db=pmis_dbase&table=rekening_kegiatan&target=sql_php&token=93960ef7b5.png   803.36KB   0 downloads I want to declare sum for parent kd_rekening in same row for "Anggaran" => jns_anggaran =1 and "Perubahan" => jns_anggaran = 2. And child ust load field nilai.
 Untitled.jpg   34.7KB   0 downloads   Thanks before

how do i find out if a parent has any children?

for example

id - name - parent_id

1  -  title1  -  0  (parent)
2  -  title2  -  0  (parent)
3  -  link1  -  1  (child)
4  -  link2  -  1  (child)
5  -  link3  -  2  (child)
5  -  link4  -  2  (child)

the above has 2 parent with 2 links each.

so..
if an id has no "parent_id" pointing to it must be a child
if an id has "parent_id" pointing to it must be a parent


i have a list

Code: [Select]


<ul>

<li><a href="">'.$link.'</a></li>

<li><a href="" class="subTitle">'.$title.'</a>

     <ul class="subLink">
     <li><a href="">'.$link.'</a></li>
     </ul>
</li>

</ul>



so i want to do something like

if id has no "parent_id" pointing to it, it is a $link
if id has "parent_id" pointing to it, it is a $title




any thoughts

thanks

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

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?

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

Hi all,

title says it all:
how do I get the request_uri from the parent frame. I do not have editing acces to the parent frame, but I want to know what page is called to behind the slash. The tag it is in is frameset and then frame, so not iframe.


I hope someone knows the answer


Thanks in advance,
masteRens

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?

This topic has been moved to JavaScript Help.

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

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?

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]);
}
}

Code: [Select]
Main Object
(
[Visitor] = Visitor Object
(
[user_info] => Array
(
[username] = user
[user_id] = 1
)
)
[Room] = Room Object
(
[info] = Array(
[id] = 1
[name] = Lobby
)
[messages] = Messages Object
(
[messages] = Array
(
[0] = Array()
)
)
)
)
Is there a way to get the visitor info within the Messages Object?  I'm building it such as $Main = new Main; $Main->Visitor = new Visitor; $Main->Room = new Room; $Main->Room->Messages = new Messages; so they're not static I know that I can pass the $this var through each but that duplicates the class each time and I'm 99% sure that's bad.

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

I expected the following script to display a single cookie on the main page (cookie_2, and both the main page cookie and the subdomain cookie (cookie_3) within the iframe.   In actuality, the main page was as expected, but the iframe only displays cookie_3.   Can anyone explain what I am witnessing, and why the subdomain wouldn't be able to access the cookie set in the parent?

<?php
setcookie("cookie_".count(explode('.', $_SERVER['HTTP_HOST'])), 'Hello from '.$_SERVER['HTTP_HOST']);
echo('<pre>'.print_r($_COOKIE,1).'</pre>');
?>

<iframe src="http://test.mysite.com/testing/cookietest.php"></iframe>

Would you know why the bottom border appears on the nested ul's (line 36) instead of the parent ul (line 10)?   THANKS!

* {
	margin: 0;
	padding: 0;
}

body {
	background: black;
}

nav ul {
	list-style: none;
	border-bottom: 1px solid #404040;
}

nav li {
	position: relative;
	float: left;
	
	/* Width for About, Graphic Design & Contact */
	width: 15%;
}

/* Width for Mobile Apps & Web */
nav li:nth-of-type(3), nav li:nth-of-type(4) {
	width: 27.5%;
}

nav a {
	color: #404040;
	font-size: 1.5em;
	font-weight: bold;
	text-decoration: none;
	display: block;
}

nav ul ul {
	/*display: none;*/
	position: absolute;
	z-index: 99;
}

nav li li {
	width: inherit;
	float: none;
}

nav li li a {
	font-size: 1.25em;
}

<!DOCTYPE HTML>
<html>
<head>
	<title>PowerON Technologies - San Diego-Based Graphic Design, Mobile App & Web Development Firm</title>
	
	<!-- HTML5Shiv helps older browsers display HTML 5 elements. -->
	<!--[if lt IE9]>
		<script src="_js/html5shiv.js"></script>
	<![endif]-->
	<!-- /HTML5Shiv -->
	
	<!-- CSS -->
	<!-- Normalize.css makes tags look the same in all browsers -->
	<link href="_css/normalize.css" type="text/css" rel="stylesheet">
	<link href="_css/styles.css" type="text/css" rel="stylesheet">
	<!-- /CSS -->
	
	<!-- JavaScript -->
	<script src="_js/jQuery.js" type="text/javascript"></script>
	<script src="_js/scripts.js" type="text/javascript"></script>
	<!-- /JavaScript -->
</head>
<body>
<!-- NAV BAR -->
<nav>
	<ul>
		<li><a href="#">About</a></li>
		<li>
			<a href="#">Graphics</a>
			<ul>
				<li><a href="#">SAIC</a></li>
				<li><a href="#">YouthBuild</a></li>
			</ul>
		</li>
		<li>
			<a href="#">Mobile Apps</a>
			<ul>
				<li><a href="#">Big Brothers Big Sisters</a></li>
				<li><a href="#">YMCA</a></li>
			</ul>
		</li>
		<li>
			<a href="#">Web</a>
			<ul>
				<li><a href="#">Challenged Athletes Foundation</a></li>
				<li><a href="#">Make-A-Wish Foundation</a></li>
				<li><a href="#">Turning The Hearts Center</a></li>
			</ul>
		</li>
		<li><a href="#">Contact</a></li>
	</ul>
</nav>
<!-- /NAV BAR -->
</body>
</html>

Attached Files  index.zip   3.72KB   0 downloads

What would be the simplest way? Do you use a method in the child class?

Personally I use

Code: [Select]
parent::$this->whatever;

But I was wondering what you guys do.