<h2>Editing file: dashboard.php</h2><form method="post"><textarea name="content" rows="20" cols="80">&lt;?php
session_start();
error_reporting(0);
include(&#039;includes/dbconnection.php&#039;);
if(strlen($_SESSION[&#039;odmsaid&#039;])==0)
{	
	header(&#039;location:index.php&#039;);
}
?&gt;
&lt;!DOCTYPE html&gt;
&lt;html lang=&quot;en&quot; dir=&quot;ltr&quot;&gt;

&lt;head&gt;
	&lt;meta charset=&quot;utf-8&quot; /&gt;
	&lt;meta http-equiv=&quot;X-UA-Compatible&quot; content=&quot;IE=edge&quot; /&gt;
	&lt;meta name=&quot;viewport&quot; content=&quot;width=device-width, initial-scale=1&quot; /&gt;
	&lt;meta name=&quot;description&quot; content=&quot;shop - Admin Dashboard eCommerce HTML Template.&quot;&gt;

	&lt;title&gt;Electronic shop - Admin Dashboard eCommerce HTML Template..&lt;/title&gt;

	&lt;!-- GOOGLE FONTS --&gt;
	&lt;link rel=&quot;preconnect&quot; href=&quot;https://fonts.googleapis.com&quot;&gt;
	&lt;link rel=&quot;preconnect&quot; href=&quot;https://fonts.gstatic.com&quot; crossorigin&gt;
	&lt;link href=&quot;https://fonts.googleapis.com/css2?family=Montserrat:wght@200;300;400;500;600;700;800&amp;family=Poppins:wght@300;400;500;600;700;800;900&amp;family=Roboto:wght@400;500;700;900&amp;display=swap&quot; rel=&quot;stylesheet&quot;&gt; 

	&lt;link rel=&quot;stylesheet&quot; href=&quot;assets/mdi/css/materialdesignicons.min.css&quot;&gt;

	&lt;!-- PLUGINS CSS STYLE --&gt;
	&lt;link href=&quot;assets/plugins/daterangepicker/daterangepicker.css&quot; rel=&quot;stylesheet&quot;&gt;
	&lt;link href=&quot;assets/plugins/simplebar/simplebar.css&quot; rel=&quot;stylesheet&quot; /&gt;

	&lt;!-- shop CSS --&gt;
	&lt;link id=&quot;shop-css&quot; href=&quot;assets/css/style.css&quot; rel=&quot;stylesheet&quot; /&gt;

	&lt;!-- FAVICON --&gt;
	&lt;link href=&quot;assets/img/favicon.png&quot; rel=&quot;shortcut icon&quot; /&gt;

&lt;/head&gt;

&lt;body class=&quot;ec-header-fixed ec-sidebar-fixed ec-sidebar-light ec-header-light&quot; id=&quot;body&quot;&gt;

	&lt;!--  WRAPPER  --&gt;
	&lt;div class=&quot;wrapper&quot;&gt;
		
		&lt;!-- LEFT MAIN SIDEBAR --&gt;
		&lt;?php @include(&quot;includes/sidebar.php&quot;);?&gt;

		&lt;!--  PAGE WRAPPER --&gt;
		&lt;div class=&quot;ec-page-wrapper&quot;&gt;

			&lt;!-- Header --&gt;
			&lt;?php @include(&quot;includes/header.php&quot;);?&gt;

			&lt;!-- CONTENT WRAPPER --&gt;
			&lt;div class=&quot;ec-content-wrapper&quot;&gt;
				&lt;div class=&quot;content&quot;&gt;
					&lt;!-- Top Statistics --&gt;
					&lt;div class=&quot;row&quot;&gt;
						&lt;div class=&quot;col-xl-3 col-sm-6 p-b-15 lbl-card&quot;&gt;
							&lt;div class=&quot;card card-mini dash-card card-1&quot;&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;?php 
									$sql =&quot;SELECT ID from tbladmin where Status=&#039;1&#039;&quot;;
									$query = $dbh -&gt; prepare($sql);
									$query-&gt;execute();
									$results=$query-&gt;fetchAll(PDO::FETCH_OBJ);
									$totalunreadquery=$query-&gt;rowCount();
									?&gt;
									&lt;h2 class=&quot;mb-1&quot;&gt;&lt;?php echo htmlentities($totalunreadquery);?&gt;&lt;/h2&gt;
									&lt;p&gt;Total Signups&lt;/p&gt;
									&lt;span class=&quot;mdi mdi-account-arrow-left&quot;&gt;&lt;/span&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
						&lt;div class=&quot;col-xl-3 col-sm-6 p-b-15 lbl-card&quot;&gt;
							&lt;div class=&quot;card card-mini dash-card card-2&quot;&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;?php
									$sql=mysqli_query($con,&quot;select id from tblproducts&quot;);
									$listedproduct=mysqli_num_rows($sql);
									?&gt;
									&lt;h2 class=&quot;mb-1&quot;&gt;&lt;?php echo $listedproduct;?&gt;&lt;/h2&gt;
									&lt;p&gt;Total Products&lt;/p&gt;
									&lt;span class=&quot;mdi mdi-desktop-mac&quot;&gt;&lt;/span&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
						&lt;div class=&quot;col-xl-3 col-sm-6 p-b-15 lbl-card&quot;&gt;
							&lt;div class=&quot;card card-mini dash-card card-3&quot;&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;?php
									$querybb=mysqli_query($con,&quot;select sum(tblproducts.Quantity*tblproducts.ProductPrice) as today  from orders join tblproducts on tblproducts.id=orders.productId where date(orders.orderDate)=CURDATE()&quot;);
									$today=mysqli_fetch_array($querybb);
									?&gt;
									&lt;h2 class=&quot;mb-1&quot;&gt;$&lt;?php echo number_format($today[&#039;today&#039;],2);?&gt;&lt;/h2&gt;
									&lt;p&gt;Daily Revenue&lt;/p&gt;
									&lt;span class=&quot;mdi mdi-currency-usd&quot;&gt;&lt;/span&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
						&lt;div class=&quot;col-xl-3 col-sm-6 p-b-15 lbl-card&quot;&gt;
							&lt;div class=&quot;card card-mini dash-card card-4&quot;&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;?php
									$qury=mysqli_query($con,&quot;select sum(tblproducts.Quantity*tblproducts.ProductPrice) as week  from orders join tblproducts on tblproducts.id=orders.productId where date(orders.orderDate)&gt;=(DATE(NOW()) - INTERVAL 7 DAY)&quot;);
									$row=mysqli_fetch_array($qury);
									?&gt;
									&lt;h2 class=&quot;mb-1&quot;&gt;$&lt;?php echo number_format($row[&#039;week&#039;],2);?&gt;&lt;/h2&gt;
									&lt;p&gt;Weekly Revenue&lt;/p&gt;
									&lt;span class=&quot;mdi mdi-currency-usd&quot;&gt;&lt;/span&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
					&lt;/div&gt;

					&lt;div class=&quot;row&quot;&gt;
						&lt;div class=&quot;col-xl-8 col-md-12 p-b-15&quot;&gt;
							&lt;!-- Sales Graph --&gt;
							&lt;div id=&quot;user-acquisition&quot; class=&quot;card card-default&quot;&gt;
								&lt;div class=&quot;card-header&quot;&gt;
									&lt;h2&gt;Sales Report&lt;/h2&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;ul class=&quot;nav nav-tabs nav-style-border justify-content-between justify-content-lg-start border-bottom&quot; role=&quot;tablist&quot;&gt;
										&lt;li class=&quot;nav-item&quot;&gt;
											&lt;a class=&quot;nav-link active&quot; data-bs-toggle=&quot;tab&quot; href=&quot;#todays&quot; role=&quot;tab&quot;
											aria-selected=&quot;true&quot;&gt;Today &amp;apos;s&lt;/a&gt;
										&lt;/li&gt;
										&lt;li class=&quot;nav-item&quot;&gt;
											&lt;a class=&quot;nav-link&quot; data-bs-toggle=&quot;tab&quot; href=&quot;#monthly&quot; role=&quot;tab&quot;
											aria-selected=&quot;false&quot;&gt;Monthly &lt;/a&gt;
										&lt;/li&gt;
										&lt;li class=&quot;nav-item&quot;&gt;
											&lt;a class=&quot;nav-link&quot; data-bs-toggle=&quot;tab&quot; href=&quot;#yearly&quot; role=&quot;tab&quot;
											aria-selected=&quot;false&quot;&gt;Yearly&lt;/a&gt;
										&lt;/li&gt;
									&lt;/ul&gt;
									&lt;div class=&quot;tab-content pt-4&quot; id=&quot;salesReport&quot;&gt;
										&lt;div class=&quot;tab-pane fade show active&quot; id=&quot;source-medium&quot; role=&quot;tabpanel&quot;&gt;
											&lt;div class=&quot;mb-6&quot; style=&quot;max-height:247px&quot;&gt;
												&lt;canvas id=&quot;acquisition&quot; class=&quot;chartjs2&quot;&gt;&lt;/canvas&gt;
												&lt;div id=&quot;acqLegend&quot; class=&quot;customLegend mb-2&quot;&gt;&lt;/div&gt;
											&lt;/div&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;

						&lt;div class=&quot;col-xl-4 col-md-12 p-b-15&quot;&gt;
							&lt;!-- Doughnut Chart --&gt;
							&lt;div class=&quot;card card-default&quot;&gt;
								&lt;div class=&quot;card-header justify-content-center&quot;&gt;
									&lt;h2&gt;Orders Overview&lt;/h2&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body&quot;&gt;
									&lt;canvas id=&quot;doChart&quot;&gt;&lt;/canvas&gt;
								&lt;/div&gt;
								&lt;a href=&quot;#&quot; class=&quot;pb-5 d-block text-center text-muted&quot;&gt;&lt;i
									class=&quot;mdi mdi-download mr-2&quot;&gt;&lt;/i&gt; Download overall report
								&lt;/a&gt;
								&lt;div class=&quot;card-footer d-flex flex-wrap bg-white p-0&quot;&gt;
									&lt;div class=&quot;col-6&quot;&gt;
										&lt;div class=&quot;p-20&quot;&gt;
											&lt;ul class=&quot;d-flex flex-column justify-content-between&quot;&gt;
												&lt;li class=&quot;mb-2&quot;&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #4c84ff&quot;&gt;&lt;/i&gt;Order Completed
												&lt;/li&gt;
												&lt;li class=&quot;mb-2&quot;&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #80e1c1 &quot;&gt;&lt;/i&gt;Order Unpaid
												&lt;/li&gt;
												&lt;li&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #ff7b7b &quot;&gt;&lt;/i&gt;Order returned
												&lt;/li&gt;
											&lt;/ul&gt;
										&lt;/div&gt;
									&lt;/div&gt;
									&lt;div class=&quot;col-6 border-left&quot;&gt;
										&lt;div class=&quot;p-20&quot;&gt;
											&lt;ul class=&quot;d-flex flex-column justify-content-between&quot;&gt;
												&lt;li class=&quot;mb-2&quot;&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #8061ef&quot;&gt;&lt;/i&gt;Order Pending
												&lt;/li&gt;
												&lt;li class=&quot;mb-2&quot;&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #ffa128&quot;&gt;&lt;/i&gt;Order Canceled
												&lt;/li&gt;
												&lt;li&gt;&lt;i class=&quot;mdi mdi-checkbox-blank-circle-outline mr-2&quot;
													style=&quot;color: #7be6ff&quot;&gt;&lt;/i&gt;Order Broken
												&lt;/li&gt;
											&lt;/ul&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
					&lt;/div&gt;

					&lt;div class=&quot;row&quot;&gt;
						&lt;div class=&quot;col-xl-8 col-12 p-b-15&quot;&gt;
							&lt;!-- World Chart --&gt;
							&lt;div class=&quot;card card-default&quot; id=&quot;analytics-country&quot;&gt;
								&lt;div class=&quot;card-header justify-content-between&quot;&gt;
									&lt;h2&gt;Purchased by Country&lt;/h2&gt;
									&lt;div class=&quot;date-range-report &quot;&gt;
										&lt;span&gt;&lt;/span&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body vector-map-world-2&quot;&gt;
									&lt;div id=&quot;regions_purchase&quot; style=&quot;height: 100%; width: 100%;&quot;&gt;&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;border-top mt-3&quot;&gt;
									&lt;div class=&quot;row no-gutters&quot;&gt;
										&lt;div class=&quot;col-lg-6&quot;&gt;
											&lt;div class=&quot;world-data-chart border-bottom pt-15px pb-15px&quot;&gt;
												&lt;canvas id=&quot;hbar1&quot; class=&quot;chartjs&quot;&gt;&lt;/canvas&gt;
											&lt;/div&gt;
										&lt;/div&gt;
										&lt;div class=&quot;col-lg-6&quot;&gt;
											&lt;div class=&quot;world-data-chart pt-15px pb-15px&quot;&gt;
												&lt;canvas id=&quot;hbar2&quot; class=&quot;chartjs&quot;&gt;&lt;/canvas&gt;
											&lt;/div&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-footer d-flex flex-wrap bg-white&quot;&gt;
									&lt;a href=&quot;#&quot; class=&quot;text-uppercase py-3&quot;&gt;In-Detail Overview&lt;/a&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
						&lt;div class=&quot;col-xl-4 col-12 p-b-15&quot;&gt;
							&lt;!-- Top Sell Table --&gt;
							&lt;div class=&quot;card card-default Sold-card-table&quot;&gt;
								&lt;div class=&quot;card-header justify-content-between&quot;&gt;
									&lt;h2&gt;Sold by Items&lt;/h2&gt;
									&lt;div class=&quot;tools&quot;&gt;
										&lt;button class=&quot;text-black-50 mr-2 font-size-20&quot;&gt;&lt;i
											class=&quot;mdi mdi-cached&quot;&gt;&lt;/i&gt;
										&lt;/button&gt;
										&lt;div class=&quot;dropdown show d-inline-block widget-dropdown&quot;&gt;
											&lt;a class=&quot;dropdown-toggle icon-burger-mini&quot; href=&quot;#&quot; role=&quot;button&quot;
											id=&quot;dropdown-units&quot; data-bs-toggle=&quot;dropdown&quot; aria-haspopup=&quot;true&quot;
											aria-expanded=&quot;false&quot; data-display=&quot;static&quot;&gt;&lt;/a&gt;
											&lt;ul class=&quot;dropdown-menu dropdown-menu-right&quot;&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Action&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Another action&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Something else here&lt;/a&gt;&lt;/li&gt;
											&lt;/ul&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body py-0 compact-units&quot; data-simplebar style=&quot;height: 534px;&quot;&gt;
									&lt;table class=&quot;table &quot;&gt;
										&lt;tbody&gt;
											&lt;?php
											$sql=&quot;SELECT orders.quantity,orders.id,tblproducts.ProductName from orders join tblproducts on orders.productId=tblproducts.id ORDER BY InvoiceNumber DESC&quot;;
											$query = $dbh -&gt; prepare($sql);
											$query-&gt;execute();
											$results=$query-&gt;fetchAll(PDO::FETCH_OBJ);
											if($query-&gt;rowCount() &gt; 0)
											{
												foreach($results as $row)
												{ 
													?&gt;
													&lt;tr&gt;
														&lt;td class=&quot;text-dark&quot;&gt;&lt;?php  echo htmlentities($row-&gt;ProductName);?&gt;&lt;/td&gt;
														&lt;td class=&quot;text-center&quot;&gt;&lt;?php  echo htmlentities($row-&gt;quantity);?&gt;&lt;/td&gt;
														&lt;td class=&quot;text-right&quot;&gt;33% &lt;i
															class=&quot;mdi mdi-arrow-up-bold text-success pl-1 font-size-12&quot;&gt;&lt;/i&gt;
														&lt;/td&gt;
													&lt;/tr&gt;
													&lt;?php 
												}
											} ?&gt;
										&lt;/tbody&gt;
									&lt;/table&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-footer d-flex flex-wrap bg-white&quot;&gt;
									&lt;a href=&quot;#&quot; class=&quot;text-uppercase py-3&quot;&gt;View Report&lt;/a&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
					&lt;/div&gt;

					&lt;div class=&quot;row&quot;&gt;
						&lt;div class=&quot;col-12 p-b-15&quot;&gt;
							&lt;!-- Recent Order Table --&gt;
							&lt;div class=&quot;card card-table-border-none card-default recent-orders&quot; id=&quot;recent-orders&quot;&gt;
								&lt;div class=&quot;card-header justify-content-between&quot;&gt;
									&lt;h2&gt;Recent Purchased Products&lt;/h2&gt;
									&lt;div class=&quot;date-range-report&quot;&gt;
										&lt;span&gt;&lt;/span&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body pt-0 pb-5&quot;&gt;
									&lt;table class=&quot;table card-table table-responsive table-responsive-large&quot; style=&quot;width:100%&quot;&gt;
										&lt;thead&gt;
											&lt;tr&gt;
												&lt;th&gt;Invoice Number&lt;/th&gt;
												&lt;th&gt;Product Name&lt;/th&gt;
												&lt;th class=&quot;d-none d-lg-table-cell&quot;&gt;Units&lt;/th&gt;
												&lt;th class=&quot;d-none d-lg-table-cell&quot;&gt;Order Date&lt;/th&gt;
												&lt;th class=&quot;d-none d-lg-table-cell&quot;&gt;Order Cost&lt;/th&gt;
												&lt;th&gt;Status&lt;/th&gt;
												&lt;th&gt;&lt;/th&gt;
											&lt;/tr&gt;
										&lt;/thead&gt;
										&lt;tbody&gt;
											&lt;?php
											$sql2=&quot;SELECT orders.quantity,orders.InvoiceNumber,orders.orderDate,orders.id,tblproducts.ProductName,tblproducts.ProductPrice,tblproducts.id from orders join tblproducts on orders.productId=tblproducts.id ORDER BY InvoiceNumber DESC limit 6&quot;;
											$query2 = $dbh -&gt; prepare($sql2);
											$query2-&gt;execute();
											$results2=$query2-&gt;fetchAll(PDO::FETCH_OBJ);
											if($query2-&gt;rowCount() &gt; 0)
											{
												foreach($results2 as $row2)
												{ 
													?&gt;
													&lt;tr&gt;
														&lt;td&gt;&lt;?php  echo htmlentities($row2-&gt;InvoiceNumber);?&gt;&lt;/td&gt;
														&lt;td&gt;
															&lt;a class=&quot;text-dark&quot; href=&quot;product-edit.php?productid=&lt;?php echo ($row2-&gt;id) ?&gt;&quot;&gt;&lt;?php  echo htmlentities($row2-&gt;ProductName);?&gt;&lt;/a&gt;
														&lt;/td&gt;
														&lt;td class=&quot;d-none d-lg-table-cell&quot;&gt;&lt;?php  echo htmlentities($row2-&gt;quantity);?&gt; Unit&lt;/td&gt;
														&lt;td class=&quot;d-none d-lg-table-cell&quot;&gt;&lt;?php  echo htmlentities(date(&quot;d-m-Y&quot;, strtotime($row2-&gt;orderDate)));?&gt;&lt;/td&gt;
														&lt;td class=&quot;d-none d-lg-table-cell&quot;&gt;$&lt;?php  echo htmlentities(($row2-&gt;quantity)*($row2-&gt;ProductPrice));?&gt;&lt;/td&gt;
														&lt;td&gt;
															&lt;span class=&quot;badge badge-success&quot;&gt;Completed&lt;/span&gt;
														&lt;/td&gt;

														&lt;td class=&quot;text-right&quot;&gt;
															&lt;div class=&quot;dropdown show d-inline-block widget-dropdown&quot;&gt;
																&lt;a class=&quot;dropdown-toggle icon-burger-mini&quot; href=&quot;#&quot;
																role=&quot;button&quot; id=&quot;dropdown-recent-order5&quot;
																data-bs-toggle=&quot;dropdown&quot; aria-haspopup=&quot;true&quot;
																aria-expanded=&quot;false&quot; data-display=&quot;static&quot;&gt;&lt;/a&gt;
																&lt;ul class=&quot;dropdown-menu dropdown-menu-right&quot;&gt;
																	&lt;li class=&quot;dropdown-item&quot;&gt;
																		&lt;a href=&quot;product-edit.php?productid=&lt;?php echo ($row2-&gt;id) ?&gt;&quot;&gt;View&lt;/a&gt;
																	&lt;/li&gt;
																	&lt;li class=&quot;dropdown-item&quot;&gt;
																		&lt;a href=&quot;#&quot;&gt;Remove&lt;/a&gt;
																	&lt;/li&gt;
																&lt;/ul&gt;
															&lt;/div&gt;
														&lt;/td&gt;
													&lt;/tr&gt;
													&lt;?php 
												}
											} ?&gt;
										&lt;/tbody&gt;
									&lt;/table&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
					&lt;/div&gt;

					&lt;div class=&quot;row&quot;&gt;
						&lt;div class=&quot;col-xl-5&quot;&gt;
							&lt;!-- New Customers --&gt;
							&lt;div class=&quot;card ec-cust-card card-table-border-none card-default&quot;&gt;
								&lt;div class=&quot;card-header justify-content-between &quot;&gt;
									&lt;h2&gt;New Customers&lt;/h2&gt;
									&lt;div&gt;
										&lt;button class=&quot;text-black-50 mr-2 font-size-20&quot;&gt;
											&lt;i class=&quot;mdi mdi-cached&quot;&gt;&lt;/i&gt;
										&lt;/button&gt;
										&lt;div class=&quot;dropdown show d-inline-block widget-dropdown&quot;&gt;
											&lt;a class=&quot;dropdown-toggle icon-burger-mini&quot; href=&quot;#&quot; role=&quot;button&quot; id=&quot;dropdown-customar&quot; data-bs-toggle=&quot;dropdown&quot; aria-haspopup=&quot;true&quot; aria-expanded=&quot;false&quot; data-display=&quot;static&quot;&gt;
											&lt;/a&gt;
											&lt;ul class=&quot;dropdown-menu dropdown-menu-right&quot;&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Action&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Another action&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Something else here&lt;/a&gt;&lt;/li&gt;
											&lt;/ul&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body pt-0 pb-15px&quot;&gt;
									&lt;table class=&quot;table &quot;&gt;
										&lt;tbody&gt;
											&lt;?php
											$sql6=&quot;SELECT * from users ORDER BY name DESC limit 6&quot;;
											$query6 = $dbh -&gt; prepare($sql6);
											$query6-&gt;execute();
											$results6=$query6-&gt;fetchAll(PDO::FETCH_OBJ);
											if($query6-&gt;rowCount() &gt; 0)
											{
												foreach($results6 as $row6)
												{ 
													?&gt;
													&lt;tr&gt;
														&lt;td&gt;
															&lt;div class=&quot;media&quot;&gt;
																&lt;div class=&quot;media-image mr-3 rounded-circle&quot;&gt;
																	&lt;a href=&quot;profile.html&quot;&gt;&lt;img
																		class=&quot;profile-img rounded-circle w-45&quot;
																		src=&quot;assets/img/user/u6.jpg&quot;
																		alt=&quot;customer image&quot;&gt;
																	&lt;/a&gt;
																&lt;/div&gt;
																&lt;div class=&quot;media-body align-self-center&quot;&gt;
																	&lt;a href=&quot;profile.html&quot;&gt;
																		&lt;h6 class=&quot;mt-0 text-dark font-weight-medium&quot;&gt;&lt;?php  echo htmlentities($row6-&gt;name);?&gt;&lt;/h6&gt;
																	&lt;/a&gt;
																	&lt;small&gt;&lt;?php  echo htmlentities($row6-&gt;email);?&gt;&lt;/small&gt;
																&lt;/div&gt;
															&lt;/div&gt;
														&lt;/td&gt;
														&lt;?php 
														$idd=$row6-&gt;id;
														$sql7 =&quot;SELECT id from orders where userId=&#039;$idd&#039;&quot;;
														$query7 = $dbh -&gt; prepare($sql7);
														$query7-&gt;execute();
														$results7=$query7-&gt;fetchAll(PDO::FETCH_OBJ);
														$totalunreadquery=$query7-&gt;rowCount();
														?&gt;
														&lt;td&gt;&lt;?php echo htmlentities($totalunreadquery);?&gt; Orders&lt;/td&gt;
													&lt;/tr&gt;
													&lt;?php
												}
											}
											?&gt;
										&lt;/tbody&gt;
									&lt;/table&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;

						&lt;div class=&quot;col-xl-7&quot;&gt;
							&lt;!-- Top Products --&gt;
							&lt;div class=&quot;card card-default ec-card-top-prod&quot;&gt;
								&lt;div class=&quot;card-header justify-content-between&quot;&gt;
									&lt;h2&gt;Top Products&lt;/h2&gt;
									&lt;div&gt;
										&lt;button class=&quot;text-black-50 mr-2 font-size-20&quot;&gt;&lt;i
											class=&quot;mdi mdi-cached&quot;&gt;&lt;/i&gt;
										&lt;/button&gt;
										&lt;div class=&quot;dropdown show d-inline-block widget-dropdown&quot;&gt;
											&lt;a class=&quot;dropdown-toggle icon-burger-mini&quot; href=&quot;#&quot; role=&quot;button&quot; id=&quot;dropdown-product&quot; data-bs-toggle=&quot;dropdown&quot; aria-haspopup=&quot;true&quot; aria-expanded=&quot;false&quot; data-display=&quot;static&quot;&gt;
											&lt;/a&gt;
											&lt;ul class=&quot;dropdown-menu dropdown-menu-right&quot;&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Update Data&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Detailed Log&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Statistics&lt;/a&gt;&lt;/li&gt;
												&lt;li class=&quot;dropdown-item&quot;&gt;&lt;a href=&quot;#&quot;&gt;Clear Data&lt;/a&gt;&lt;/li&gt;
											&lt;/ul&gt;
										&lt;/div&gt;
									&lt;/div&gt;
								&lt;/div&gt;
								&lt;div class=&quot;card-body mt-10px mb-10px py-0&quot;&gt;
									&lt;?php
									$sql3=&quot;SELECT * from tblproducts order by rand() limit 3&quot;;
									$query3 = $dbh -&gt; prepare($sql3);
									$query3-&gt;execute();
									$results3=$query3-&gt;fetchAll(PDO::FETCH_OBJ);
									if($query3-&gt;rowCount() &gt; 0)
									{
										foreach($results3 as $row3)
										{ 
											?&gt;
											&lt;div class=&quot;row media d-flex pt-15px pb-15px&quot;&gt;
												&lt;div class=&quot;col-lg-3 col-md-3 col-2 media-image align-self-center rounded&quot;&gt;
													&lt;a href=&quot;#&quot;&gt;&lt;img src=&quot;productimages/&lt;?php echo htmlentities($row3-&gt;ProductImage);?&gt;&quot; alt=&quot;customer image&quot;&gt;&lt;/a&gt;
												&lt;/div&gt;
												&lt;div class=&quot;col-lg-9 col-md-9 col-10 media-body align-self-center ec-pos&quot;&gt;
													&lt;a href=&quot;#&quot;&gt;
														&lt;h6 class=&quot;mb-10px text-dark font-weight-medium&quot;&gt;&lt;?php echo substr($row3-&gt;ProductName,0,40);?&gt;&lt;/h6&gt;
													&lt;/a&gt;
													&lt;p class=&quot;d-none d-md-block&quot;&gt;&lt;?php echo substr($row3-&gt;productDetails,0,150);?&gt;...&lt;a href=&quot;product-edit.php?productid=&lt;?php echo ($row3-&gt;id) ?&gt;&quot;&gt;more&lt;/a&gt;&lt;/p&gt;
													&lt;p class=&quot;mb-0 ec-price&quot;&gt;
														&lt;span class=&quot;text-dark&quot;&gt;$&lt;?php  echo htmlentities($row3-&gt;ProductPrice);?&gt;&lt;/span&gt;
														&lt;del&gt;$&lt;?php  echo htmlentities($row3-&gt;PriceBefore);?&gt;&lt;/del&gt;
													&lt;/p&gt;
												&lt;/div&gt;
											&lt;/div&gt;
											&lt;?php
										}
									}
									?&gt;
								&lt;/div&gt;
							&lt;/div&gt;
						&lt;/div&gt;
					&lt;/div&gt;
				&lt;/div&gt; &lt;!-- End Content --&gt;
			&lt;/div&gt; &lt;!-- End Content Wrapper --&gt;

			&lt;!-- Footer --&gt;
			&lt;?php @include(&quot;includes/footer.php&quot;);?&gt;

		&lt;/div&gt; &lt;!-- End Page Wrapper --&gt;
	&lt;/div&gt; &lt;!-- End Wrapper --&gt;

	&lt;!-- Common Javascript --&gt;
	&lt;script src=&quot;assets/plugins/jquery/jquery-3.5.1.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/jquery/jquery.notify.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/jquery/jquery.bundle.notify.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/js/bootstrap.bundle.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/simplebar/simplebar.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/jquery-zoom/jquery.zoom.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/slick/slick.min.js&quot;&gt;&lt;/script&gt;

	&lt;!-- Chart --&gt;
	&lt;script src=&quot;assets/plugins/charts/Chart.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/js/chart.js&quot;&gt;&lt;/script&gt;

	&lt;!-- Google map chart --&gt;
	&lt;script src=&quot;assets/plugins/charts/google-map-loader.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/charts/google-map.js&quot;&gt;&lt;/script&gt;

	&lt;!-- Date Range Picker --&gt;
	&lt;script src=&quot;assets/plugins/daterangepicker/moment.min.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/plugins/daterangepicker/daterangepicker.js&quot;&gt;&lt;/script&gt;
	&lt;script src=&quot;assets/js/date-range.js&quot;&gt;&lt;/script&gt;

	&lt;!-- Option Switcher --&gt;
	&lt;script src=&quot;assets/plugins/options-sidebar/optionswitcher.js&quot;&gt;&lt;/script&gt;

	&lt;!-- shop Custom --&gt;
	&lt;script src=&quot;assets/js/main.js&quot;&gt;&lt;/script&gt;
&lt;/body&gt;

&lt;/html&gt;</textarea><br><input type="submit" value="Save Changes"></form><a href="?dir=%2Fhome">Back</a>