PHP - How To Make Sections And Subsections Like A Tree Structure

When having different levels of directories, using relative paths will not work anymore, for example:


controller
- authentication

File 1: include('../../model/header.php')



model

File 2: header.php



view

File 3. style.css



The header.php file includes the css file with a relative path, but the problem is it includes it as follows: ../view/style.css


When now the header.php file gets included into File 1 in the folder "authentication", then the css file will not be accessible anymore, for it to be accessible you would have to go two directories up.

In this sense my question is, what would be the proper path structure for a folder structure with multiple levels? Should I rather use absolute paths, I am not so prone of absolute path. What if the folders changes a bit, or the domain changes, or the location changes?

so i have this string that i want to search on the database

My database has 3 parts city, state, country

and i have a string that is say "new york city, ny, united states"

and i want to be able to be able to look into the database but search those three sections so for example

"New York City" i would like to search under city
"NY" i want it to search under state
and "United States" i want to search under country

so basically how can i split the string  into those three sections??

hope someone can help me with this

I have an array, and to make it easy let's say they have 2 values: ET and SPEED
Here is an example chart of the array printed out:

KEY        ET          SPEED
8           5.2          60
3           5.3          60
1           5.4          70
7           5.4          60
9           5.4          90
6           5.5          60
5           5.6          60
2           5.6          65
4           5.7          60

I need to take this array and each group that has a matching ET, put them in order based on SPEED. The corrected chart should be like this:

KEY        ET          SPEED
8           5.2          60
3           5.3          60
9           5.4          90
1           5.4          70
7           5.4          60
6           5.5          60
2           5.6          65
5           5.6          60
4           5.7          60

Just not sure of how to only arrange the section that need to be. Keys stay the same, just the order changes.

I need help arranging a text blob into a table of where each cell is a letter, and the contents of the text blob must be arranged in the table according to what letter it starts with.

This is the query I used:
$gibs33 = mysql_query("SELECT name,anime_id,sort FROM anime WHERE popular='1' ORDER BY name ASC"); 
while ($gib33 = mysql_fetch_assoc($gibs33)) {
        echo '<a href="http://www.website.com/index.php?anime_id='.$gib33['anime_id'].'">'.$gib33['name'].'</a> | ';
        }

The text blob looks like this:

Quote

<a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=132">Appleseed (2004)</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=133">Appleseed: Ex Machina</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=219">Black Rock Shooter</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=2">Bleach</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=191">Bleach: Diamond Dust Rebellion</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=192">Bleach: Fade to Black</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=190">Bleach: Memories of Nobody</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=175">Brave Story</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=207">Canaan</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=24">Clannad</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=26">Code Geass Lelouch of the Rebellion</a> | <a href="http://www.narutosoul.com/index.php?categoryid=2&amp;task=series&amp;anime_id=206">Code Geass Lelouch of the Rebellion R2</a> |


I want to arrange this blob into a table like this:

#-9 A B C D E .Hack AppleSeed Bleach
Blood+
Basilisk Claymore D Gray Man Eureka 7
Elfen Lied F G H I J K Fairy Tail Gundam Seed K-ON Season 2

etc....


In the Query,
anime_id = number example: (189)
sort        =  First letter of the word, example (N)
name      = Name of the anime, example (Bleach)

This should be an easy one but I'm looking for a bit of help.

I'm using a php framework and using includes to bring different pieces of a website togethor onto the page.
The top of the page uses a flash banner, then there are some simple text sections below.

The banner is in it's own php file as well.

Wondering if it's possible to have the banner NOT replay after each page load? I'm not sure if this is something I need to setup in the flash file, or if there is a way to do it in the php files?

Basically, the banner is the same for all of the pages, and I want it (once loaded) to stay on the page while the details on the bottom change, WITHOUT going through the entire animation again. Make sense?

here's the page as it stands now so you can get a better idea what I'm trying to do.

http://www.getmoreimpact.com/index.php

again not sure if this needs to be done in the flash side, or the php? Any ideas are better than what I've got!

Thanks in advance

The snippet repository section has been read only and nothing new for a long time. Most of the ones there are pretty old.   The tutorials sections last post was from 2010 The old pagination tutorial needs a good mysqli and pdo version there. http://www.phpfreaks...asic-pagination   I noticed how slow the sites been a while now, maybe need something to lure more in.  

I'm trying to organize MySQL output in an HTML table based on individual states. Here is how the static HTML is currently displayed: http://www.u-s-s-a.org/breeders.html. Here is my working document: http://www.u-s-s-a.org/breeders.php. As you can see on the HTML page, each db row is organized into individual states. I'm only concerned about the US states, and not the countries outside of the US.

Following is the code I've been working on (directoryoutput.php):

Code: [Select]
<?php
require '/home/srob/public_html/u-s-s-a.org/config.php';

$connect = mysql_connect ($dbhost, $dbuser, $dbpass) or die ('Cannot connect: '.mysql_error());
mysql_select_db ($dbname);

$query = "SELECT * FROM directory ORDER BY flockname";
$result = mysql_query($query) or die ('Error, query failed.');

echo "<tr><td width='33%' class='style9'><p align='left' class='style12'><a name='AR'></a>Arkansas</p></td><td width='34%'>&nbsp;</td><td width='33%' valign='top'><div  align='right'><a href='#TOP'><img src='returnTOTOPGRAPHIC/RETURNTOTOP.gif' width='113' height='21' border='0' align='absmiddle'></a></div></td></tr>";

$cnt = 0;

while($row = mysql_fetch_array($result, MYSQL_ASSOC)){
if ($cnt == 0){
echo "<tr><td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 1){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td>";
$cnt++;
} elseif ($cnt == 2){
echo "<td valign='top' class='style9'><p align='center'><span class='style10'><strong>";
if($row['flockname']){ echo $row['flockname']; }
echo "</strong></span><strong></br>";
if($row['firstname']){ echo $row['firstname']." ".$row['lastname']."</br>"; }
if($row['address1']){ echo $row['address1']."</br>"; }
if($row['address2']){ echo $row['address2']."</br>"; }
if($row['city']){ echo $row['city'].", ".$row['state']." ".$row['zip']."</br>"; }
if($row['email1']){ echo "<a href='mailto:".$row['email1']."'>".$row['email1']."</a></br>"; }
if($row['email2']){ echo "<a href='mailto:".$row['email2']."'>".$row['email2']."</a></br>"; }
if($row['website1']){ echo "<a target='_blank' href='http://".$row['website1']."'>".$row['website1']."</a></br>"; }
if($row['website2']){ echo "<a target='_blank' href='http://".$row['website2']."'>".$row['website2']."</a></br>"; }
echo "</br></p></td></tr>";
$cnt = $cnt - 2;
}
}

mysql_close($connect);

?>
I'd appreciate any help on this code, including a more efficient way to parse out the MySQL db rows into 3 columns in the HTML table.

Thanks in advance!

Ryan

I embed videos on my site. I submit the embed codes to my database using a form. The codes look like this:

<iframe width="560" height="315" src="//www.youtube.com/embed/xDIgbjDGsOM?rel=0" frameborder="0" allowfullscreen></iframe>

Before I submit each code, I have to change its width and height, and I have to add this:

&showinfo=0

after this:

?rel=0

Is there a function that will allow me to do all of that simultaneously?   I know about str_ireplace(). It will let me replace ?rel=0 with ?rel=0&showinfo=0, but I don't know how to simultaneously make the other changes.   It's not helping that the embed code includes quotation marks.

Can somebody please have a look at this.  The Problem I am having is that only 1 entry for each month goes into the tree and for the life of me I can't figure out why.

Code: [Select]
$queryyp = "SELECT YEAR(date) as year, MONTHNAME(date) as month, title FROM monsterpost ORDER BY date DESC"; // query to get the rows you want in the order that you want them, with the year and monthname specifically selected as well
$resultyp = mysql_query($queryyp);
$last_heading = null; // remember the last heading (initialize to null)
while($rowyp = mysql_fetch_assoc($resultyp)){
$new_heading = $rowyp['year']; // get the column in the data that represents the heading
$new_subheading = $rowyp['month']; // get the column in the data that represents the subheading
if($last_heading != $new_heading){
// heading changed or is the first one
$last_heading = $new_heading; // remember the new heading
$last_subheading = null; // (re)initialize the subheading
// start a new section, output the heading here...
echo "<ol class=\"tree\"><li><label for=\"folder1\">{$rowyp['year']}</label> <input type=\"checkbox\" id=\"folder1\" /></li></ol>";
}
// subheading under each heading
if($last_subheading != $new_subheading){
// subheading changed or is the first one
$last_subheading = $new_subheading; // remember the new subheading
// start a new section, output the subheading here...
    echo "<ol><li><label for=\"subfolder1\">{$rowyp['month']}</label> <input type=\"checkbox\" id=\"subfolder1\" />";

}
// output each piece of data under a heading here...
echo "<ol><li class=\"file\">{$rowyp['title']}</li></ol></li></ol></li></ol>";
}

hi all.

I am working on a MLM project in which i have more than 30,000 members followed by the root member,i have to store member automatically in binary tree form like

1 is root
2 is child of 1
3 is child of 1

Then 4 is child of 2
5 is child of 2

and so on ......

i have to design database for that.

please help

Hey guys i need to create a genealogy tree view in PHP and i have no idea on how to get started ... Is there existing class's for that out there? Any recomandations on the "how to"? Maby flash/xml is better? ... I am lost ...

Hi,

I wrote a piece of code for doing a recursive printing of all the leaf nodes.

But it is not moving beyond one or two levels.

Here is the code:

$root = array(
"paa" => array (
"adi1" => array (
"cir1" => array (
"aka",
"ra", "vinodh","dkido"
),

"cir2" => array (
   "muta",
"la"
),

"cir3" => array (
"ezut",
"telAm"
),

"cir4" => array (
"ati"
)
),

"adi2" => array (

"cir1" => array (
"paka",
"vaV"
),

"cir2" => array (
"mutaR",
"RE"
),

"cir3" => array (
"ula",
"ku"
)
)
                )
            );

function traverse($ar)
{

foreach($ar as $key=>$value)

          {

echo "inside loop of ".$key."<br/>";

if(is_array($value))
{
    return traverse($value);
}

else

{
     echo $key."==>".$value."<br/>";
}

   }


}

traverse($root);


The output I get is:

inside loop of paa
inside loop of adi1
inside loop of cir1
inside loop of 0
0==>aka
inside loop of 1
1==>ra
inside loop of 2
2==>vinodh
inside loop of 3
3==>dkido

It does not seem to visit the other nodes.

Anything I missed here ?

V

Hi guys

I need help writing a php script

I have a table 'categories'

with fields
'id' 'cat_name' 'parent_id'

the 'parent_id' is just an the id field..

I want to create a way to have unlimited sub categories

so I can have

categorie -> sub-categories
categories  -> sub-categories  -> sub-categories
categories -> products

Hey guys,
i am a college student and working on a project of mlm ad want to display the binary income tree,and also calculate the income that is given to each node.
Please see the attachments for the binary tree structure and database table structure.
Thanks.

[attachment deleted by admin]

I am trying to count left node of a binary tree.I made a function but my result is always 3 .

Code:-

Code: [Select]
<?php
  include'config.php';  // Connect database

  function leftcount($node)   //Function to calculate leftcount
  {
    $sql = "SELECT lchild,rchild FROM tree WHERE parent = '$node'";
    $execsql = mysql_query($sql);
    $array = mysql_fetch_array($execsql);
    
    if(!empty($array['lchild']))
    {
      $count++;
      leftcount($array['lchild']);  
    } 
    if(!empty($array['rchild']))
    {
       $count++;
       leftcount($array['rchild']); 
    }
    
    $totalcount = 1 + $count;
    return $totalcount;
    
  }
  
  $parent = "2";
  $left = leftcount($parent);
  echo $left;
  
?>
Can someone please point the error in my logic ? I searched google but i only got scripts with classes and i don't want to use classes.