PHP - Counting Results On Category And Subcategory Tree Structure

Hi,

I am working on a project, where i want to add sub-sections within a section , and add once again adding sub-subsection under that section.

How to make a table structure for that, any idea please

Thanks,

This topic has been moved to Application Design.

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

Hi there,

I think this is a big question but I'd appretiate any help you can provide!!
I have a list of items and subitems in a table that looks like this:

id    parent_id    title 1    0    House Chores 2    1    Take Out Trash 3    1    Clean Room 4    0    Grocery List 5    4    Eggs 6    4    Produce 7    6    Lettuce 8    6    Tomato 9    4    Milk
I want to display it like this:

(+) House Chores:
       > Take Out Trash
       > Clean Room

(+) Grocery List:
       > Eggs
       (+) Produce
            > Letutce
           > Tomato
       > Milk

 
So basically each entry in the table has an unique id and also a parent id if it's nested inside another item.
I "sort of" got it figured out in one way, but it doesnt really allow for nested subgroups. I'd like to know how would y'all PHP freaks to this

Also taking suggestions for the javascript code to expand/collapse the tree !!

Thank you!

Alright,
I need to find a way to display the top ten duplicated rows for a table in my database. I have tried multiple methods but I have failed. Can you please assist me with this problem. I currently run a query in phpmyadmin to get the result, but i cant figure out how to properly code the php script.

Hey there. Not sure how to word this. I've been flying blind as a newbie trying to figure out some pagination for a left joined query. I've got syntax errors trying to set up the SELECT COUNT function that adds up the results of the search on a previous page so it knows how many results matched both tables.

Right now, I've got this mess, and it's giving me a syntax error,
"You have an error in your SQL syntax; .... near 'LEFT JOIN plantae ON (descriptors.plant_id = plantae.pla' at line 12"
Code: [Select]
$data = "Select (SELECT COUNT(*)
                    FROM
                        descriptors
                    ) AS
                        count1,
                (SELECT COUNT(*)
                    FROM
                         plantae
                    ) AS
                        count2

                    LEFT JOIN
                        plantae ON (descriptors.plant_id = plantae.plant_name)
                    WHERE
                        `leaf_shape` LIKE '%$select1%'
                        AND `leaf_venation` LIKE '%$select3%'
                        AND `leaf_margin` LIKE '%$select4%'";
                   
 
$result = mysql_query ($data);
if (!$result) {
    die("Oops, my query failed.  The query is: <br>$data<br>The error is:<br>".mysql_error());
}

Hello,

I have been searching and trying all sorts of ways to get my sub categories drop down to show the correct info after selecting a category from the main drop down but im getting stuck.

It's pulling the categories and sub categories from the mysql database fine but no matter which main category i pick it keeps showing the same result in the sub category.

My brother said i need to use some sort of onchange do this so the sub category list refreshs but everything i have tried doesn't work..


PLEASE could some one help.

MANY MANY THANKS


This is the category form
Code: [Select]
  <select name="job_cats" style="width:165px">
    <?PHP

$query1 = "SELECT * FROM job_cats";
$result1 = mysql_query($query1) or die ("query 1 failed");
$count1 = mysql_num_rows($result1);

for ($i = 0; $i < $count1; $i++) {
$row1 = mysql_fetch_array($result1);
$job_cats_title1 = $row1['title'];
$job_cats_id1 = $row1['id'];


echo '<option value="'.$job_cats_id1.'">'.$job_cats_title1.'</option>';

echo $job_cats_id1;
}
    ?>
    </select>
this would echo this in the main category list:

cat1
cat2
cat3
cat4




this is the sub category form
Code: [Select]
  <select name="job_sub_cats" style="width:165px">
 
    <?PHP
$query1 = "SELECT * FROM job_sub_cats WHERE job_cats_id = $job_cats_id1";

$result1 = mysql_query($query1) or die ("query 1 failed");
$count1 = mysql_num_rows($result1);


for ($i = 0; $i < $count1; $i++) {
$row1 = mysql_fetch_array($result1);

$sub_cats_id1 = $row1['id'];
$sub_cats_title1 = $row1['subTitle'];
$cats_id1 = $row1['job_cats_id'];

echo '<option value="'.$sub_cats_id1.'">'.$cats_id1.'</option>';

}
    ?>
    </select>


this should echo this:

1
2
3
4

but it keeps echoing just the number 4.


THANKS
PLEASE HELP

ricky

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?

An array of "categories" is given:

    $categories = array(
        array("id" => 1, "title" => "Pants", "children" => array(
            array("id" => 2,
                "title" => "Boots",
                "children" => array(
                    array("id" => 3, "title" => "Leather"),
                    array("id" => 4, "title" => "Textile"),
                ),
            ),
            array("id" => 5, "title" => "Sneakers"),
        ),
        ),
        array(
            "id" => 6,
            "title" => "Sort",
            "children" => array(
                array(
                    "id" => 7,
                    "title" => "Balls",
                ),
            ),
        ),
    );

I need to write a function searchCategory ($categories, $id) that returns the name of the category by the category ID.

Help me please.

So I am having some difficulties with a category system. I want my code to search the database an unlimited amount of times to the very last directory and then display it in tree view on my screen. I'm having some trouble because I am having to specify how many depths the code will search. How can I get it to do this on it's own? Currently my code does this...
 

<?php
// Establish SQL Connection.

$mysqli			=	mysqli_connect( $sql['host'], $sql['user'], $sql['pass'], $sql['db'] ) or die( "DARN");
$query			=	$mysqli->query( "SELECT * FROM folders ORDER BY name ASC" );
$num_rows	=	$query->num_rows;


echo "Found <b>" . $num_rows . "</b> row(s) in the database!<br>";


	while ( $row = mysqli_fetch_array( $query ) )
	{
		// DO NOT REMOVE
		$id		=	$row['id'];
		$name	=	$row['name'];
		$parent	=	$row['parent'];
		
		/***************************************************************************************************/
		
		if ( $parent == 0 )
		{
			echo $id . " " . $name . " " . $parent . "<br>";
			
			$query2	=	$mysqli->query( "SELECT * FROM folders WHERE parent = " . $id . " ORDER BY name ASC" );
			
			while ( $row2 = mysqli_fetch_array( $query2 ) )
			{
				echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;" . $row2['name'] . "<br>";
			}
		}
	}
?>

I know it's messy, doing the best I can.     DB looks a little like this...   +----+---------+--------+

I have the following result that I am getting from a source.

Code: [Select]
SimpleXMLElement Object
(
    [CategoryID] => 1
    [Name] => Other
    [Order] => 0
    [link] => http://www.link.com?sub=1
)

SimpleXMLElement Object
(
    [CategoryID] => 1233916011
    [Name] => ceramic
    [Order] => 1
    [ChildCategory] => SimpleXMLElement Object
        (
            [CategoryID] => 1234016011
            [Name] => dish
            [Order] => 1
        )

    [link] => http://www.link.com?sub=13476
)

SimpleXMLElement Object
(
    [CategoryID] => 1233917011
    [Name] => laminate
    [Order] => 2
    [link] => http://www.link.com?sub=98247
)

I need to get it into a database with the following structure

Code: [Select]
id  categoryID  cName  cOrder  clink  cparent 

By using
Code: [Select]
foreach($this->resp->Store->CustomCategories->CustomCategory as $cat) {
$sub = $cat->CategoryID;
$ord = $cat->Order;
$linkto = "$stlink?fsub=$fsub";
$nm = htmlspecialchars($cat->Name);
$par=$cat->ChildCategory->Order;
$query = "INSERT INTO Cat (categoryID,cName,cOrder,clink,cparent) VALUES ('$sub','$nm','$ord','$linkto','$par')";
$result = @mysql_query ($query); // Run the query.
}

I can get
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
2    1233917011   laminate 2      http://www.link.com?sub=98247  0
But I need to get the ChildCategory in there w/ cparent like
Code: [Select]
id   categoryID   cName   cOrder  clink                          cparent
1    1            Other   0       http://www.link.com?sub=1      0
2    1233916011   ceramic 1       http://www.link.com?sub=13476  0
3    1234016011   dish    1                                      1  <--- like this
4    1233917011   laminate 2      http://www.link.com?sub=98247  0
any help appreciated...

Hope I am in the right area.  I am working on a project which is sort of a business directory.  I have a category table, a sub-category table then the actual account table.  So a user clicks on the category, then selects the sub-category to view information of accounts in that category, and then be able to click to see the full profile.  Here's where I am getting stuck.  A user may be listed in more than one sub.  As an example, let's say a parent is Cars, then subs might be New, Used, Parts, etc.  Now a particular user might be listed under all three subs.  How can I link them?  I have my cat/sub linked via parent/child id's.  However, how can I get the user to be linked to multiple subs?  Would I need to create a separate table to do similar to parent/child of the categories?  If so, then how would I insert the multiple id's into the table?  I assume at this point that I would use drop downs for the subs.  I am having a real hard time wrapping my head around this so any help is greatly appreciated.

Hi Guys (& Ladies of course) 

I'm having a problem trying to add post category to the H1 title, I have managed to butcher my theme so that the single post now removes the H1 from the title in the header & instead adds it to the post title.

But what I'd like to do now is keep the H1 blog title on all pages including home page, but I'd like to ammend the title with the addition of the post category, as follows;

currently shows "Top Rated Gadgets" on all pages.

would like it to show "Top Rated (category name)" when viewing a single post.

So if the category of the post was Asus Laptops it would show "Top Rated Asus Laptops" instead of the usual "Top Rated Gadgets"

The closest I have got to it so far is with
Code: [Select]
<?php the_category(', '); ?> but this returns a hyperlink ! Is there any method I can use that will simply return the category name as plain text..?

Any help would be much appreciated 

Thanks

Hey there, so as a personal project, I've been working on creating a forum software. You can check out what I have so far he  https://www.taziamoma.com/Forum/index.php

What I'm currently having trouble with right now is connecting a Category with a forum with the threads inside of it. For example, I have a Category that has 3 forums attached to it. How do I link that in the database and how do I indicate which threads belongs to which forums?

Hi
How can i see which category is being used in rss feed, this is my code to parse one rss feed.

$feed_url = "http://www.foo.com/feed/";
$xml = simplexml_load_file($feed_url);
foreach ($xml->channel->item as $item) { 
$ns_content = $item->children('http://purl.org/rss/1.0/modules/content/');
$title = $item->title; // This is title
$desc = $ns_content->encoded; // This is description
$category =""; // Here i am stuck, how can i get category associated with this feed
}


How can i see its category, i see in source code it looks like this and even categories have sub categories which looks same, i wants categories names to display wihich is associated with feed:

<category><![CDATA[Health]]></category> 
<category><![CDATA[Men]]></category> 


thanks for any help.