PHP - Generating Hierarchical Categories Based On Product Row

I have got a script which is able to create hierarchical categories infinitely and display them as items in a ul.

What I need now is to get these categories to appear in a hierarchical dropdown i.e. the user clicks a menu and the dropdown drops down, then the categories that don't have any children will simply be displayed whereas the categories that do have children will have an arrow pointing to the right and once hovered over all of their children will be displayed in a new menu with their children and so on a nd so forth. Very similar to the way the windows menu bar works except with more levels.

Basically I want it to function sort of like a spry menu bar except it can go down then across etc etc and any further categories and sub categories that are added in will be shown. Can anybody help me out with this or perhaps point me in the direction of a tutorial that helps to avhieve this effect.

Heres my code that creates them in an unordered list:--



<?php

$link = mysqli_connect('localhost','','');
mysqli_select_db($link,'mydb');

$query = mysqli_query($link,'SELECT * FROM nested_categories');
while ( $row = mysqli_fetch_assoc($query) ){        
$menu_array[$row['id']] = array('name' => $row['name'],'parent' => $row['parent_id']);
}

function generate_menu($parent){        
$has_childs = false;        

global $menu_array;        

foreach($menu_array as $key => $value){                
if ($value['parent'] == $parent){ 
                              
if ($has_childs === false){                                

$has_childs = true;                                
echo '<ul id="categories">';                        
}                        

echo '<li>'. $value['name'];                        
generate_menu($key);                        

echo '</li>';                
}        
}        
if ($has_childs === true) echo '</ul>';
}

generate_menu(0);

?>

I have made a custom post type for products, and am using a custom taxonomy for the product categories. The thing that I am wondering about is that sometimes a product category is a parent, and sometimes a child, but sometimes both. For instance, if you have a top level category named shoes, then you might have a sub category named Nike. However, Nike also has shirts, so you could say that shoes and shirts were both subcategories of Nike. Do you know what I'm saying? It's like there is no real parent to child relationship, but they are both parents and both children of each other. How do you handle this type of situation?

Hello!

I have a database like this:

Product Name | Category1 | Category 2 | Category 3
Iphone            | Apple        | Iphone       |
WD HD            | PC             | Hard-drive  | External
Monitor 17"     | LCD Screen|                  |


What I want to do is to allow people to search for any categories and also the junction of the categories.

For example, if the the URL is like this &category=External;PC;Hard-Drive it will show WD HD and all the other products which have any combination of these three categories.

Another example, if the URL is like &category=Iphone it will show Iphone. If the URL is &category=LCD screen;Apple it will not show anything, because the ; is basically an AND.

The problem is that the keywords could be in any category, so a search for a single keyword would have to be made on all the columns and a search for 3 keywords, like the first example, would have to be made 3 times on these columns for the 3 keywords, which would mean 9 searches in total!!

How could I do this the fastest way?

Hi,

I have a trouble figuring out how to properly convert a list of product data from XML into CSV format.

My source is a XML file containing a list of products with attributes like color, size, material etc. with the following structu
Code: [Select]
    <?xml version="1.0" encoding="utf-8" ?>
<store>
        <products>
            <product>
                <name>T-Shirt</name>
                <price>19.00</price>
                <attributes>
                    <attribute>
                        <name>Color</name>
                        <options>
                            <option>
                                <name>White</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>Black</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>Blue</name>
                                <price>0.00</price>
                            </option>
                        </options>
                    </attribute>
                    <attribute>
                        <name>Size</name>
                        <options>
                            <option>
                                <name>XS</name>
                                <price>-5.00</price>
                            </option>
                            <option>
                                <name>S</name>
                                <price>-5.00</price>
                            </option>
                            <option>
                                <name>M</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>L</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>XL</name>
                                <price>5.00</price>
                            </option>
                        </options>
                    </attribute>
                </attributes>
            </product>
            <product>
                <name>Sweatshirt</name>
                <price>49.00</price>
                <attributes>
                    <attribute>
                        <name>Color</name>
                        <options>
                            <option>
                                <name>White</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>Black</name>
                                <price>0.00</price>
                            </option>
                        </options>
                    </attribute>
                    <attribute>
                        <name>Size</name>
                        <options>
                            <option>
                                <name>XS</name>
                                <price>-10.00</price>
                            </option>
                            <option>
                                <name>M</name>
                                <price>0.00</price>
                            </option>
                            <option>
                                <name>XL</name>
                                <price>10.00</price>
                            </option>
                        </options>
                    </attribute>
                    <attribute>
                        <name>Material</name>
                        <options>
                            <option>
                                <name>Cotton</name>
                                <price>10.00</price>
                            </option>
                            <option>
                                <name>Polyester</name>
                                <price>0.00</price>
                            </option>
                        </options>
                    </attribute>
                </attributes>
            </product>
            <product>
                <name>Earrings</name>
                <price>29.00</price>
            </product>
        </products>
    </store>

Each product has a number of elements like name, price etc. but also a random number of attributes (like color, size, material etc.) that also have a random number of options.
Each option can affect the price of the product, so ordering a XS sized t-shirt can be cheaper than ordering a XL sized t-shirt.

I would like to end up with a CSV representing one attribute combination on each line.

In my example that would result in 3 colors x 5 sizes = 15 lines for the T-Shirt , 2 colors x 3 sizes x 2 materials = 12 lines for the Sweatshirt and 1 line for the Earrings without any attributes:
Code: [Select]
        name,price,color,size,material
T-Shirt,14.00,White,XS,
T-Shirt,14.00,Black,XS,
T-Shirt,14.00,Blue,XS,
T-Shirt,14.00,White,S,
T-Shirt,14.00,Black,S,
T-Shirt,14.00,Blue,S,
T-Shirt,19.00,White,M,
T-Shirt,19.00,Black,M,
T-Shirt,19.00,Blue,M,
T-Shirt,19.00,White,L,
T-Shirt,19.00,Black,L,
T-Shirt,19.00,Blue,L,
T-Shirt,24.00,White,XL,
T-Shirt,24.00,Black,XL,
T-Shirt,24.00,Blue,XL,
    Sweatshirt,49.00,White,XS,Cotton
Sweatshirt,49.00,Black,XS,Cotton
Sweatshirt,59.00,White,M,Cotton
Sweatshirt,69.00,Black,M,Cotton
Sweatshirt,69.00,White,XL,Cotton
Sweatshirt,69.00,Black,XL,Cotton
Sweatshirt,39.00,White,XS,Polyester
Sweatshirt,39.00,Black,XS,Polyester
Sweatshirt,49.00,White,M,Polyester
Sweatshirt,49.00,Black,M,Polyester
Sweatshirt,59.00,White,XL,Polyester
Sweatshirt,59.00,Black,XL,Polyester
Earrings,29.00,,,
   
I already managed to generate the CSV Output for simple products like the Earrings and products with just one attribute, but am struggling to come up with a way to generate all possible product attribute combinations for products with more than one attribute.

My miserable attempts at this so far have produced following code:

Code: [Select]
    <?php
    mb_internal_encoding("UTF-8");
    header('Content-Type: text/html; charset=utf-8');

    $source = "example.xml";
    $handle = fopen($source, "r");
    $fp = fopen('export.csv', 'w');
    $xml = simplexml_load_file($source);

    // Generate list of attributes (for csv header etc.)
    $header_attributes = array();
    foreach ($xml->products->product as $product) {
        if(isset($product->attributes)) {
            foreach($product->attributes->attribute as $attribute) {
                array_push($header_attributes, $attribute->name);
            }
        }
    }
    $header_attributes = array_unique($header_attributes);

    $csvheader = array(
        'name','price' // these exist for all products, could also include weight, image, description, special price etc...
    );

    $static_csvheadercount = count($csvheader);

    foreach($header_attributes as $attribute) {
        array_push($csvheader, $attribute); // add variable number of attribute fields to csv header
    }

    fputcsv($fp, $csvheader);

    foreach ($xml->products->product as $product) {  // loop through each product
        if(isset($product->attributes)) $simple = 0;
        else $simple = 1;
        if($simple == 1) { // if product is a simple product with no attributes
            $output=array();
            array_push($output,(string)$product->name);
            array_push($output,(string)$product->price);
            for($i = $static_csvheadercount + $attribute_position; $i < count($csvheader); $i++) {
                        array_push($output, '');
            }
            fputcsv($fp, $output);
        }
        else { // is a configurable product with attributes
            $json = json_encode($product->attributes);
            $attributes = json_decode($json, TRUE);
            $attributes_number = count($product->attributes->attribute);
            if($attributes_number > 1) { // if product has more than 1 attributes so we have to generate each attribute combination
                //
                // I'm trying to figure out what should happen here
                //
            }
            else { // if product has only one attribute
                $attributename =  (string)$product->attributes->attribute->name;
                $attribute_position = array_search($attributename, $header_attributes);
                $options_number = count($product->attributes->options->option);
                $pos = 1;
                foreach($attributes['attribute']['options']['option'] as $option) { 
                    $output=array();
                    array_push($output,(string)$product->name);
                    array_push($output,(string)$product->price);
                    for($i = $static_csvheadercount - 1; $i < ($static_csvheadercount + $attribute_position); $i++) {
                        array_push($output, '');
                    }

                    $output[$static_csvheadercount + $attribute_position] = $option['name'];
                    for($i = $static_csvheadercount + $attribute_position; $i < count($csvheader) - 1 ; $i++) {
                        array_push($output, '');
                    }
                    fputcsv($fp, $output);
                    $pos++;
                }
                $output=array();
                array_push($output,(string)$product->name);
                array_push($output,(string)$product->price);
                for($i = $static_csvheadercount; $i < count($csvheader); $i++) {
                    array_push($output, '');
                }
                fputcsv($fp, $output);
            }
        }
    }

    ?>
      
I've been stuck at this problem for hours unable to figure out a solution.

Can someone give a few tips or pointer how to achieve the output for products with multiple attributes?

   

Hi all,

How can i auto populate the price of an item based on a chosen product and then auto calculate the price and quantity before hitting the ADD button.
I think it should be a javascript/ajax/jquery stuff but dont know how to go about it.

The Unit price should be auto populated based on valu from the database. The amount is the Unit Price times the Quantity of the Product Selected.

Thanks

My form

	<form action="" method="post" data-toggle="validator">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label>Item Name</label>
<select id="username" name="item_name" class="form-control inputs" data-error="Select Item" required>
<option value="">Chose Item</option>
<?php
$stmt = $pdo->query("
SELECT item_name FROM stocks
ORDER BY item_name ASC
");
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$item_name = $row['item_name'];
echo "<option value=\"$item_name\">
$item_name
</option>";
}
?>
</select>
<div class="help-block with-errors"></div>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Unit Price</label>
<input type="number" class="form-control" name="item_price">
<div class="help-block with-errors"></div>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Item Quantity</label>
<input type="number" class="form-control" name="item_qty" required data-error="Stock Quantity is missing">
<div class="help-block with-errors"></div>
</div>
</div>
<div class="col-md-2">
<div class="form-group">
<label>Amount</label>
<input type="number" class="form-control" name="amount" >
<div class="help-block with-errors"></div>
</div>
</div>
</div>
<br>
<span class="input-group-btn">
<input name="send" type="submit" class="btn btn-danger btn-form display-4 rounded" value="ADD">
</span>
</form>
	

Edited May 4, 2019 by I-AM-OBODO