Re: [PHP] hierarchies
PJ wrote:
> Not quite, but interesting option. This would be fine on my local
> intranet, if needed; but I don't think this would be allowed on a
> virtual hosted site.
>
> Actually, my problem is to use a header.php (for example) in pages in
> the webroot directory or any directory within (or under) webroot:
>
> / < webroot
> /site1
>/files
>/images
>/lib
>/more files
>/admin
> /other_files
> /still_others
> /site2
> /site3
> files
> files
> files...
>
> I have the header.php file in /lib .
> If I put include dirname(_FILE_)."/lib/header.php"; in a file under
> /site1, the header is displayed.
> If I put the same include statement in a file under /site1/files, the
> header is not displayed; if I change the include to
> ..."/../lib/header.php"; it then works.
> I want to be able to point to the include to the same file in the same
> directory without having to change the include directive.
>
The problem is with how you are organizing your app. Includes are
relative to the first file that's loaded, so if the first file that is
loaded is in /site1/files/ then you have to know where /lib/header.php
is from there.
Most people don't load individual files (at least not from different
dirs) as you seem to be doing. My advice is to always load the same
file first from the root dir and then include your other files. Then
those files will include header.php relative to the root dir.
*** Example:
(/site1/index.php)
(/site1/files/yourfile.php)
*** Better Example:
(/site1/index.php)
(/site1/files/yourfile.php)
Above when I say "based upon some criteria", it would be something like
this (example only):
switch ($_GET['file']) {
case 'yourfile':
include('files/yourfile.php');
break;
case 'somefile':
include('more_files/somefile.php');
break;
}
--
Thanks!
-Shawn
http://www.spidean.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] hierarchies
PJ wrote:
Jason Pruim wrote:
PJ wrote:
I do have a bit of a problem which has not been clearly explained in
the suggestions to my previous posts and that is the question of
hierarchies. I have not yet understood how to include a file anywhere in
a directory tree and have it point to the right file which may be in the
top directory or, most likely, in a /lib/ directory from the file that
is including.
Any suggestions, or should I just make myself small and
wait for the rotten eggs and spoiled tomatoes to come raining down on my
head? :'(
Are you talking about having a file structure such as:
/home
/include
/webroot
/->images
/->css
/->java
And you want to include a file from the include folder which is above
the webroot, so doesn't have access to it?
If that's the case... you just need to set the path such as:
ini_set("include_path", "/home/include");
then in your PHP file you should be able to: include("mysupperfile.php");
and it should work :)
Not quite, but interesting option. This would be fine on my local
intranet, if needed; but I don't think this would be allowed on a
virtual hosted site.
Actually, my problem is to use a header.php (for example) in pages in
the webroot directory or any directory within (or under) webroot:
/ < webroot
/site1
/files
/images
/lib
/more files
/admin
/other_files
/still_others
/site2
/site3
files
files
files...
I have the header.php file in /lib .
If I put include dirname(_FILE_)."/lib/header.php"; in a file under
/site1, the header is displayed.
If I put the same include statement in a file under /site1/files, the
header is not displayed; if I change the include to
..."/../lib/header.php"; it then works.
I want to be able to point to the include to the same file in the same
directory without having to change the include directive.
I actually use that on a shared host... Really depends on the host
though... My actual file path is something more like:
/home/
/myusername/
/include/
/public_html/ < Web root
/file.php
/another folder/
So all my files are inside my home folder on the server, but nothing
outside of public_html is accessible from the web.
As for the rest... I haven't started using dir(__FILE__) stuff yet so I
won't be any help with that...
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] hierarchies
Jason Pruim wrote:
>
>
> PJ wrote:
>> I do have a bit of a problem which has not been clearly explained in
>> the suggestions to my previous posts and that is the question of
>> hierarchies. I have not yet understood how to include a file anywhere in
>> a directory tree and have it point to the right file which may be in the
>> top directory or, most likely, in a /lib/ directory from the file that
>> is including.
>> Any suggestions, or should I just make myself small and
>> wait for the rotten eggs and spoiled tomatoes to come raining down on my
>> head? :'(
>>
>>
> Are you talking about having a file structure such as:
>
> /home
> /include
> /webroot
> /->images
> /->css
> /->java
>
> And you want to include a file from the include folder which is above
> the webroot, so doesn't have access to it?
>
> If that's the case... you just need to set the path such as:
> ini_set("include_path", "/home/include");
> then in your PHP file you should be able to: include("mysupperfile.php");
> and it should work :)
>
>
Not quite, but interesting option. This would be fine on my local
intranet, if needed; but I don't think this would be allowed on a
virtual hosted site.
Actually, my problem is to use a header.php (for example) in pages in
the webroot directory or any directory within (or under) webroot:
/ < webroot
/site1
/files
/images
/lib
/more files
/admin
/other_files
/still_others
/site2
/site3
files
files
files...
I have the header.php file in /lib .
If I put include dirname(_FILE_)."/lib/header.php"; in a file under
/site1, the header is displayed.
If I put the same include statement in a file under /site1/files, the
header is not displayed; if I change the include to
..."/../lib/header.php"; it then works.
I want to be able to point to the include to the same file in the same
directory without having to change the include directive.
--
unheralded genius: "A clean desk is the sign of a dull mind. "
-
Phil Jourdan --- p...@ptahhotep.com
http://www.ptahhotep.com
http://www.chiccantine.com/andypantry.php
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] hierarchies
PJ wrote:
I do have a bit of a problem which has not been clearly explained in
the suggestions to my previous posts and that is the question of
hierarchies. I have not yet understood how to include a file anywhere in
a directory tree and have it point to the right file which may be in the
top directory or, most likely, in a /lib/ directory from the file that
is including.
Any suggestions, or should I just make myself small and
wait for the rotten eggs and spoiled tomatoes to come raining down on my
head? :'(
Are you talking about having a file structure such as:
/home
/include
/webroot
/->images
/->css
/->java
And you want to include a file from the include folder which is above
the webroot, so doesn't have access to it?
If that's the case... you just need to set the path such as:
ini_set("include_path", "/home/include");
then in your PHP file you should be able to: include("mysupperfile.php");
and it should work :)
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] hierarchies
I do have a bit of a problem which has not been clearly explained in the suggestions to my previous posts and that is the question of hierarchies. I have not yet understood how to include a file anywhere in a directory tree and have it point to the right file which may be in the top directory or, most likely, in a /lib/ directory from the file that is including. Any suggestions, or should I just make myself small and wait for the rotten eggs and spoiled tomatoes to come raining down on my head? :'( -- unheralded genius: "A clean desk is the sign of a dull mind. " - Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com/andypantry.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hierarchies and MySQL with PHP
Warren Vail wrote: I did one once where the key to the table was a string, and the string contained 1 to n Node Numbers separated by a separator character. "1" "1.1" "1.1.1" "1.2" select data from table where node between (1 and 2) resulted in an entire limb of the tree being retrieved. Limitations were the size of the string, depth of the tree (the string was truncated), and the number of digits in each node number. Problem also with ordering node numbers, node number 1 tended to be followed by node number 10, 11, 12, etc, then number 2, until I pre-determined the number of leading zeros for each node. Not pretty, but it works well for small trees. Warren Vail Been there, done that, ran into the same limitations :-) The "flat table" solution in the article suggested by Marek keeps a running "display order" integer column, updated only when items are added (or removed, but that's not strictly necessary if you don't mind holes in the sequence). When inserting a new item, it gets the display order value of the parent + 1, and the following items have their display order incremented by 1. Simple. There's also an "indentation level" column, which is simple enough to maintain. /Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hierarchies and MySQL with PHP
Marek Kilimajer wrote: This should be of your interest: http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ Indeed! The "flat table model" is simple, efficient and - I think - sufficient. Thanks! I also found this article which explains the "fourth" method not really described above, despite the title: http://www.sitepoint.com/article/hierarchical-data-database/ That method is a bit more complicated but it also allows you to determine the (total) number of child nodes of a node, without an extra SQL query. /Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Hierarchies and MySQL with PHP
I did one once where the key to the table was a string, and the string contained 1 to n Node Numbers separated by a separator character. "1" "1.1" "1.1.1" "1.2" select data from table where node between (1 and 2) resulted in an entire limb of the tree being retrieved. Limitations were the size of the string, depth of the tree (the string was truncated), and the number of digits in each node number. Problem also with ordering node numbers, node number 1 tended to be followed by node number 10, 11, 12, etc, then number 2, until I pre-determined the number of leading zeros for each node. Not pretty, but it works well for small trees. Warren Vail -Original Message- From: Mattias Thorslund [mailto:[EMAIL PROTECTED] Sent: Sunday, June 27, 2004 9:59 AM To: PHP General Mail List Subject: [PHP] Hierarchies and MySQL with PHP Hi, I wonder what you think are the best (or "least worst") strategies to store and retrieve hierarchial data (such as a "threaded" discussion or a multi-level menu tree) in MySQL using PHP? I have been using table structures where each row contains a parent reference, such as: Table Example: Field namedata type/db flagsComents = RowID int unsigned auto_increment not null (primary key) ParentRowID int unsigned 0 (or NULL if at top level) Name varchar(50) ... which is OK for *defining* the hierarchy. However, it's a pain to retrieve the data so that it can be displayed in a nice threaded/sorted way, where children are sorted directly below their parents. I also want the items to be nicely sorted within their own branch, of course. On MS SQL, I successfully used stored procedures that employ temporary tables and while statements and the like. That method is not available in MySQL (yet), so I'll have to do a lot of the manipulation on the web server instead, using PHP. Any suggestions? /Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hierarchies and MySQL with PHP
This should be of your interest: http://www.evolt.org/article/Four_ways_to_work_with_hierarchical_data/17/4047/ Mattias Thorslund wrote --- napísal:: Hi, I wonder what you think are the best (or "least worst") strategies to store and retrieve hierarchial data (such as a "threaded" discussion or a multi-level menu tree) in MySQL using PHP? I have been using table structures where each row contains a parent reference, such as: Table Example: Field namedata type/db flagsComents = RowID int unsigned auto_increment not null (primary key) ParentRowID int unsigned 0 (or NULL if at top level) Name varchar(50) ... which is OK for *defining* the hierarchy. However, it's a pain to retrieve the data so that it can be displayed in a nice threaded/sorted way, where children are sorted directly below their parents. I also want the items to be nicely sorted within their own branch, of course. On MS SQL, I successfully used stored procedures that employ temporary tables and while statements and the like. That method is not available in MySQL (yet), so I'll have to do a lot of the manipulation on the web server instead, using PHP. Any suggestions? /Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Hierarchies and MySQL with PHP
Hi, I wonder what you think are the best (or "least worst") strategies to store and retrieve hierarchial data (such as a "threaded" discussion or a multi-level menu tree) in MySQL using PHP? I have been using table structures where each row contains a parent reference, such as: Table Example: Field namedata type/db flagsComents = RowID int unsigned auto_increment not null (primary key) ParentRowID int unsigned 0 (or NULL if at top level) Name varchar(50) ... which is OK for *defining* the hierarchy. However, it's a pain to retrieve the data so that it can be displayed in a nice threaded/sorted way, where children are sorted directly below their parents. I also want the items to be nicely sorted within their own branch, of course. On MS SQL, I successfully used stored procedures that employ temporary tables and while statements and the like. That method is not available in MySQL (yet), so I'll have to do a lot of the manipulation on the web server instead, using PHP. Any suggestions? /Mattias -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Hierarchies
I've tried to convert this function to ODBC. Anyone that can help?
Tx
MH
Dimitris Kossikidis <[EMAIL PROTECTED]> wrote in message
000801c177eb$adea5500$0300a8c0@mits">news:000801c177eb$adea5500$0300a8c0@mits...
> You can do it only in few lines of code with a recursive function... You
> can display full tree structure with unlimited levels.
>
> Mysql Table :
> cid int,
> parent int,
> Name varchar
>
> Cid parent varchar
> 1 0 A
> 2 1 C
> 3 0 B
> 4 1 D
> 5 2 E
> 6 3 F
> This should output :
>
> - A
> - - C
> - - - E
> - - D
> - B
> - - F
>
>
> function ShowTree($parent=0,$level=0){
> $query=mysql_query("select cid,parent,name from categories where
> parent='$parent'");
> $level++;
> while ($row=mysql_fetch_object($query) ){
>$cnt=$row->cid;
>$element[$cnt]['cid']=$row->cid;
>$element[$cnt]['parent']=$row->parent;
>$element[$cnt]['name']=$row->name;
>echo str_repeat('-', $level) ."".$element[$cnt]['name']."
> (level=$level)(counter=$cnt)";
>ShowTree($element[$cnt]['cid'],$level);
> }
> }
>
> ShowTree(0,0);
>
> > -Original Message-
> > From: MindHunter [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, November 28, 2001 9:27 AM
> > To: [EMAIL PROTECTED]
> > Subject: [PHP] Hierarchies
> >
> >
> > Hi,
> >
> > I need to display hierarchies (hierarchical structures). I
> > have a MYSQL table with data like this:
> >
> > Node,Parent
> > A,
> > B,A
> > C,A
> > D,B
> > E,B
> > F,D
> > G,A
> >
> > It can go down to 10 levels.
> >
> > I do not want display one level and then click to display the
> > next, I want to see the entire tree at once, say like this:
> >
> > A
> > ---B
> > --D
> > -F
> > --E
> > ---C
> > ---G
> >
> > Any ideas, scripts on how I can do this? I seems like I have
> > to use a recursive function and /or arrays?
> >
> > Any help will be appreciated!
> >
> > Thanks
> > MH
> >
> >
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail:
> > [EMAIL PROTECTED] To contact the list
> > administrators, e-mail: [EMAIL PROTECTED]
> >
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
RE: [PHP] Hierarchies
You can do it only in few lines of code with a recursive function... You
can display full tree structure with unlimited levels.
Mysql Table :
cid int,
parent int,
Name varchar
Cid parent varchar
1 0 A
2 1 C
3 0 B
4 1 D
5 2 E
6 3 F
This should output :
- A
- - C
- - - E
- - D
- B
- - F
function ShowTree($parent=0,$level=0){
$query=mysql_query("select cid,parent,name from categories where
parent='$parent'");
$level++;
while ($row=mysql_fetch_object($query) ){
$cnt=$row->cid;
$element[$cnt]['cid']=$row->cid;
$element[$cnt]['parent']=$row->parent;
$element[$cnt]['name']=$row->name;
echo str_repeat('-', $level) ."".$element[$cnt]['name']."
(level=$level)(counter=$cnt)";
ShowTree($element[$cnt]['cid'],$level);
}
}
ShowTree(0,0);
> -Original Message-
> From: MindHunter [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, November 28, 2001 9:27 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP] Hierarchies
>
>
> Hi,
>
> I need to display hierarchies (hierarchical structures). I
> have a MYSQL table with data like this:
>
> Node,Parent
> A,
> B,A
> C,A
> D,B
> E,B
> F,D
> G,A
>
> It can go down to 10 levels.
>
> I do not want display one level and then click to display the
> next, I want to see the entire tree at once, say like this:
>
> A
> ---B
> --D
> -F
> --E
> ---C
> ---G
>
> Any ideas, scripts on how I can do this? I seems like I have
> to use a recursive function and /or arrays?
>
> Any help will be appreciated!
>
> Thanks
> MH
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED] To contact the list
> administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
[PHP] Hierarchies
Hi, I need to display hierarchies (hierarchical structures). I have a MYSQL table with data like this: Node,Parent A, B,A C,A D,B E,B F,D G,A It can go down to 10 levels. I do not want display one level and then click to display the next, I want to see the entire tree at once, say like this: A ---B --D -F --E ---C ---G Any ideas, scripts on how I can do this? I seems like I have to use a recursive function and /or arrays? Any help will be appreciated! Thanks MH -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
