HI.
I made it to make a menu with all categories and subcategorie that works fine but not in theme.php
The file (sub-items.php) is in the root of my localhost and the code is:
<?php
define("DB_SERVER", "localhost");
define("DB_USER", "root");
define("DB_PASS", "pass");
define("DB_NAME", "cpg16");
// 1. Create a database connection
$connection = mysqli_connect(DB_SERVER, DB_USER, DB_PASS, DB_NAME);
// Test if connection succeeded
if(mysqli_connect_errno()) {
die("Database connection failed: " .
mysqli_connect_error() .
" (" . mysqli_connect_errno() . ")"
);
}
function db_query($db_query) {
if (!$db_query) {
die("Database query failed.");
}
}
$query = "SELECT * FROM cpg16x_categories WHERE parent = '0'";
$result = mysqli_query($connection, $query);
db_query($result);
$result = mysqli_fetch_all($result,MYSQLI_ASSOC);
foreach($result as $row) {
$output = '';
$output .= '
<ul class="main-category"><li>By <b>'.$row["cid"].'</b> on <i>'.$row["parent"].'</i>';
$output .= get_cats($connection, $row["cid"]);
echo $output . '</li></ul>';
}
function get_cats($connection, $parent = 0, $marginleft = 0) {
$query = "SELECT * FROM cpg16x_categories WHERE parent = '".$parent."'";
$output = '';
$result = mysqli_query($connection, $query);
db_query($result);
$result1 = mysqli_fetch_all($result);
$count = mysqli_num_rows($result);
if($count > 0) {
foreach($result as $row) {
$output .= '<ul class="sub-category"><li>By <b>'.$row["cid"].'</b> on <i>'.$row["parent"].'</i>';
$output .= get_cats($connection, $row["cid"], $marginleft);
}
}
return $output . '</li></ul>';
}
echo '<style>
.main-category{background-color:green;padding:5px;}.sub-category{background-color:blue;padding:5px;}
</style>';
?>
I replaced:
cpg16x_categories with {$CONFIG['TABLE_CATEGORIES']}
mysqli_query with cpg_db_query and others like cpg_db_num_rows
I added in get_cats()
global $CONFIG;
BUT NOTHING.
Not workin in theme.php
Maybe because of $result = mysqli_fetch_all($result,MYSQLI_ASSOC);
Not accepted by coppermine.
Need some help.
I have nested sub-sub categories.