FrEaKmAn
March 31st, 2007, 02:22 AM
ok here is more of the script. Now I added links to category tree:
index.php
<?php
//change the details!!!
$host = "localhost";
$user = "root";
$pass = "";
$db = "10";
// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");
// select database
mysql_select_db($db) or die ("Unable to select database!");
include 'functions.php';
//edit this to fit your settings. My file is located in http://localhost/test/10/
$link = substr($REQUEST_URI, 9);
if(substr($link, -1) == '/'){
$link = substr($link, 0,-1);
}
$top_level_catid = 0;
$counter_start = 0;
list_categories($top_level_catid,$counter_start);
echo '<br>';
echo 'And here we output the category id: '.output($link);
?>
functions.php
<?php
function create_link($category_id){
$check = 1;
$arr_number = 1;
$a[0] = $category_id;
//echo $category_title;
for($i=0; $i<1000; $i++){
if($check == 0){
//return 'error';
break;
}
else {
$result = mysql_query("SELECT * FROM menu_system_sub_categories WHERE sub_cat_id = '$category_id'");
$data = mysql_fetch_array($result);
if($data['cat_id'] !== '0'){
$category_id = $data['cat_id'];
$a[$arr_number] = $data[cat_id];
$arr_number = $arr_number+1;
}
else {
$check = 0;
}
}
}
sort($a);
$count = count($a);
//print_r($a);
for($j=0; $j<$count; $j++){
$output_id = $a[$j];
$result2 = mysql_query("SELECT * FROM menu_system_categories WHERE cat_id = '$output_id'");
$data2 = mysql_fetch_array($result2);
$b[$j] = $data2['cat_title'];
}
$complete = implode("/", $b);
return $complete;
}
function list_categories($catid,$counter){
$query = "SELECT c.cat_id, c.cat_title FROM menu_system_categories c, menu_system_sub_categories s WHERE c.cat_id = s.sub_cat_id AND s.cat_id = " . $catid;
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());
if (mysql_num_rows($result) > 0) {
$space = str_repeat(' ',$counter*10);
while($row = mysql_fetch_row($result)) {
$cat_title = $row[1];
$this_catid = $row[0];
echo $space .'<a href="http://localhost/test/10/'.create_link($this_catid).'">'.$cat_title.'</a>';
echo '<br>';
$counter++;
list_categories($this_catid,$counter);
$counter--;
}
}
}
function output($link){
$parts = explode('/', $link);
//print_r($parts);
//echo count($parts).'<br>';
$parts_count = count($parts);
if($parts_count == 1){
$title = $parts[0];
if($title == ''){
return 'Front page';
} else {
$result = mysql_query("SELECT * FROM menu_system_categories WHERE cat_title = '$title'");
$data = mysql_fetch_array($result);
if (mysql_num_rows($result) > 0){
return $data['cat_id'];
}
else {
return 0;
}
}
}
else {
$check = 1;
$counter = 0;
for ($i=0;$i<$parts_count;$i++) {
if($check == 0){
return 0;
break;
}
else {
$title1 = $parts[$i];
$title2 = $parts[$i+1];
//echo $parts[$i];
$result = mysql_query("SELECT * FROM menu_system_categories WHERE cat_title = '$title1'");
$data = mysql_fetch_array($result);
$result2 = mysql_query("SELECT * FROM menu_system_categories WHERE cat_title = '$title2'");
$data2 = mysql_fetch_array($result2);
$cat_id = $data['cat_id'];
$cat2_id = $data2['cat_id'];
$result3 = mysql_query("SELECT * FROM menu_system_sub_categories WHERE sub_cat_id = '$cat2_id' AND cat_id = '$cat_id'");
$data3 = mysql_fetch_array($result3);
if (mysql_num_rows($result3) > 0){
if($counter == $parts_count-2){
return $data3['sub_cat_id'];
}
}
else {
$check = 0;
}
}
$counter = $counter+1;
}
}
}
?>
+ you have to include htaccess file. Well I need a feedback...