Notes

<?php

class DB extends mysqli
{
public $parents = [];
public function __construct($hostname,$username,$password,$db){
parent::__construct($hostname,$username,$password,$db);
mysqli_set_charset($this,"utf8");
$this->getParents();
}
public function getAllDataByTableName($tablename){
$sql = "SELECT * from ".$tablename;
$result = $this->query($sql);
$allDatas = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($allDatas,$row);
}
}
return $allDatas;
}
public function getAllData($sql){
$result = $this->query($sql);
$allDatas = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($allDatas,$row);
}
}
return $allDatas;
}
public function getParents(){
$sql = "SELECT * from categories where parentid = -1";
$result = $this->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($this->parents,$row["katid"]);
}
}
}

public function createTemplate($template,$datas){
preg_match_all("/{%(.+?)%}/",$template,$result);
$keywords = $result[1];
$replace = $result[0];
foreach ($datas as $key => $value) {
$temp = $template;
for ($i=0; $i < count($replace); $i++) {
$temp = str_replace($replace[$i], $value[$keywords[$i]], $temp);
}
echo $temp;
}

}

public function recursive($id=-1){
$categories = [];
$sql = "SELECT * from categories where parentid=".$id;
$result = $this->query($sql);
$datas = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($datas,$row);
}
}
foreach ($datas as $key => $value) {
if($id == -1){

echo '<div class="panel panel-default">'.PHP_EOL;
echo '<div class="panel-heading">'.PHP_EOL;
echo '<h4 class="panel-title">'.PHP_EOL;
echo '<a data-toggle="collapse" data-parent="#accordian" href="#'.str_replace(' ','',$value['katadi']).'">'.PHP_EOL;
echo '<span class="badge pull-right"><i class="fa fa-plus"></i></span>'.PHP_EOL;
print_r($value["katadi"]);
echo '</a>'.PHP_EOL;
echo '</h4>'.PHP_EOL;
echo '</div>'.PHP_EOL;
echo '<div id="'.str_replace(' ','',$value["katadi"]).'" class="panel-collapse collapse">'.PHP_EOL;
echo '<div class="panel-body">'.PHP_EOL;
echo '<ul>'.PHP_EOL;
echo '<li><a href=""></a></li>'.PHP_EOL;
}else{
if(in_array($id, $this->parents)){
echo "<li style='margin-left:10px'><a href='urunler.php'>".$value["katadi"]."</a></li>".PHP_EOL;
}else{
echo "<li style='margin-left:20px'><a href='urunler.php'>-".$value["katadi"]."</a></li>".PHP_EOL;

}

}
$this->recursive($value["katid"]);
if($id==-1){
echo "</ul>
</div>
</div>
</div>";
}
}

}
public function rec_mobile($id=-1){
$sql = "SELECT * from categories where parentid=".$id;
$result = $this->query($sql);
$datas = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($datas,$row);
}
}
foreach ($datas as $key => $value) {
if($id == -1){
echo "<li class='dropdown-submenu'><a class='dropdown-item dropdown-toggle' href='#' style='color:orange;'>".$value["katadi"]."</a>
<ul class='dropdown-menu'>";
}else{
echo '<li><a class="dropdown-item" href="#">'.$value["katadi"].'</a></li>';
}
$this->rec_mobile($value["katid"]);
if($id == -1){
echo "</ul></li>";
}
}
}

public function recursive2($id=-1){
$categories = [];
$sql = "SELECT * from categories where parentid=".$id;
$result = $this->query($sql);
$datas = [];
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
array_push($datas,$row);
}
}
echo "<ul>";
foreach ($datas as $key => $value) {
if($value["parentid"] == -1){
echo "<li style='color:orange'>";
}else{
echo "<li>";

}
echo $value["katadi"];
$this->recursive($value["katid"]);
echo "</li>";
}
echo "</ul>";

}

public function rec_cat($id = -1){
$sql = "SELECT * from categories where parentid=".$id;
$result = $this->query($sql);
echo "<ul>";
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo '<li><a href="#">$value["katadi"]</a>';
'<li><a href="#" style="font-size:12px;">$row["katadi"]</a></li>';
echo "</ul>";}}
}

public function getProduct($id){
$sql = "SELECT * from products where id=".$id;
$result = $this->query($sql);
if ($result->num_rows > 0) {
$row = $result->fetch_assoc();
return array($row["id"],$row["product_name"],$row["price"],$row["image"],$row["descr"],$row["old_price"]);
}
}
}
$db = new DB("localhost","root","","rec");
//$db->rec_mobile();
?>