Magento 2 Module Development

 Magento 2 Module Development

In this educational activity, we have made absolute "News" module in Magento 2. You can learn module improvement process easily. We deal with head and fronted both side features like as make executive menu, manager framework, add/modify/delete overseer network things, news posting on fronted with pagination and moreover get single record from arrangement.

Create admin menu in magento 2

Create system config in magento 2

Create helper and get system config value Magento 2

How to create table and install sample data in Magento 2

Create collection in Magento 2

Create admin grid listing in Magento 2

How to add grid items in Magento 2

How to edit grid items in Magento 2

How to delete grid items in Magento 2

How to show collection on frontend with pagination in Magento 2

How to get single record from collection in Magento 2

Read More

 

Create Tree View and Get category and subcategory in php

Create categories table

CREATE TABLE `categories` (
`id` int(11) NOT NULL,
`parent_id` int(11) NOT NULL,
`category_name` varchar(100) DEFAULT NULL,
`is_active` tinyint(1) NOT NULL,
`created_at` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Copy

Database connection

Create function dbconnect()

<?php
function dbconnect(){
	$host = "localhost";
	$dbuser = "root";
	$dbpass = "";
	$dbname = "corephp";

	$conn = new mysqli($host, $dbuser, $dbpass, $dbname);

	if($conn->connect_error){
		die("Connection failed: ".$conn->connect_error);
	}
	
	return $conn;
}
?>

Copy

Create function categories

Get all parent categories

<?php 
function categories()
{
	$conn = dbconnect();
	
	$sql = "SELECT * FROM categories WHERE parent_id=0";
	$result = $conn->query($sql);
	
	$categories = array();
	
	while($row = $result->fetch_assoc())
	{
		$categories[] = array(
			'id' => $row['id'],
			'parent_id' => $row['parent_id'],
			'category_name' => $row['category_name'],
			'subcategory' => sub_categories($row['id']),
		);
	}
	
	return $categories;
}
?>

Copy

Create function sub categories

Get all sub categories

function sub_categories($id)
{	
	$conn = dbconnect();
	
	$sql = "SELECT * FROM categories WHERE parent_id=$id";
	$result = $conn->query($sql);
	
	$categories = array();
	
	while($row = $result->fetch_assoc())
	{
		$categories[] = array(
			'id' => $row['id'],
			'parent_id' => $row['parent_id'],
			'category_name' => $row['category_name'],
			'subcategory' => sub_categories($row['id']),
		);
	}
	return $categories;
}

Copy

Create viewsubcat function

Get all sub categories for view

<?php
function viewsubcat($categories)
{
	$html = '<ul class="sub-category">';
	foreach($categories as $category){

		$html .= '<li>'.$category['category_name'].'</li>';
		
		if( ! empty($category['subcategory'])){
			$html .= viewsubcat($category['subcategory']);
		}
	}
	$html .= '</ul>';
	
	return $html;
}
?>

Copy

Create view file

Get all categories and sub categories

<?php $categories = categories(); ?>
<?php foreach($categories as $category){ ?>
		<ul class="category">
			<li><?php echo $category['category_name'] ?></li>
		<?php 
			if( ! empty($category['subcategory'])){
				echo viewsubcat($category['subcategory']);
			} 
		?>
	</ul>
<?php } ?>

Copy

Output

Dynamic MenuTree ViewTree View in PHP

Read More