Today's Posts Follow Us On Twitter! TFL Members on Twitter  
Forum search: Advanced Search  
Navigation
Marketplace
  Members Login:
Lost password?
  Forum Statistics:
Forum Members: 24,256
Total Threads: 81,169
Total Posts: 566,839
There are 43 users currently browsing (tf).
 
  Our Partners:
 
  TalkFreelance     Design and Development     Programming     PHP and MySQL :

(PHP) Fetch from DB then print as list

Thread title: (PHP) Fetch from DB then print as list
Reply    
    Thread tools Search this thread Display Modes  
10-01-2011, 09:05 AM
#1
neojiphre is offline neojiphre
Status: I'm new around here
Join date: Sep 2011
Location:
Expertise:
Software:
 
Posts: 7
iTrader: 0 / 0%
 

neojiphre is on a distinguished road

  Old  (PHP) Fetch from DB then print as list

Maybe I'm being dumb here but I can't find what I'm doing wrong. I have a table of categories in my database.

ID-------Name--------Parent
20-------Apples------ 1
21-------Bananas-----2
22-------Oranges-----3
24-------Peaches-----1
25-------Tomato----- 1

I want to fetch all records where parent equals to a certain value (eg Parent = 1) and then print this as unordered list.

Right now I have:

PHP Code:
function getChild()
{
    
//Take value from url
    
$catId = (int)$_GET['c'];

    
//Query to DB
    
$sql "SELECT cat_id, cat_name FROM tbl_category WHERE cat_parent_id=$catId";
    
$result dbQuery($sql);

    
$childcat = array();
        while (
$row dbFetchAssoc($result)) {
        
$childcat[] = $row;
    }
    
    return 
$childcat;

So this takes the id and name of a category. The id is to be used later for URL purposes.

PHP Code:
<?php
    $child 
getChild();
        foreach (
$child as $childcat) {
            
$cat_id $childcat['cat_id'];
            
$cat_name $childcat['cat_name'];
            
$url $_SERVER['PHP_SELF'] . "?c=$cat_id";
        }

    
//Print array as list.
    
echo "\n<ul>\n" ;
        foreach(
$child as $childcat){
            echo 
"<li><a href=\"" $_SERVER['PHP_SELF'] . "?c=$cat_id"\">$cat_name</a></li>\n";
    }
    echo 
"</ul>" ;
?>
All this does is print the same record (it chooses the last one) over a number of times. It does get the number of records to be fetched right. So suppose it was to fetch all records with a parent of 1 (3 records) it will show the record Tomato in a list three times.

How can I fix this? Thanks in advance.

11-20-2011, 08:31 AM
#2
ExpertsGuide is offline ExpertsGuide
Status: I'm new around here
Join date: Nov 2011
Location:
Expertise:
Software:
 
Posts: 3
iTrader: 0 / 0%
 

ExpertsGuide is on a distinguished road

  Old

You are printing outside the foreach loop.
Try this,

PHP Code:
<?php 
    $child 
getChild(); 
    echo 
"\n<ul>\n" 
        foreach (
$child as $childcat) { 
            
$cat_id $childcat['cat_id']; 
            
$cat_name $childcat['cat_name']; 
            
$url $_SERVER['PHP_SELF'] . "?c=$cat_id"
            echo 
"<li><a href=\"" $_SERVER['PHP_SELF'] . "?c=$cat_id"\">$cat_name</a></li>\n";
        }  
    echo 
"</ul>" 
?>

07-30-2012, 06:03 AM
#3
unikorndesigns is offline unikorndesigns
unikorndesigns's Avatar
Status: Junior Member
Join date: May 2011
Location:
Expertise: Web Designing and Development
Software: Photoshop, Dreamweaver and etc
 
Posts: 41
iTrader: 0 / 0%
 

unikorndesigns is on a distinguished road

  Old

PHP Code:
<?php  
    $child 
getChild();  
    echo 
"\n<ul>\n" ;  
        foreach (
$child as $childcat) {  
            
$cat_id $childcat['cat_id'];  
            
$cat_name $childcat['cat_name'];  
            
$url $_SERVER['PHP_SELF'] . "?c=$cat_id";  
            echo 
"<li><a href='".$_SERVER['PHP_SELF']."?c=$cat_id"'>$cat_name</a></li>\n"
        }   
    echo 
"</ul>" ;  
?>
this should work!!!!!!

Reply With Quote
Reply    


Thread Tools
Display Modes

  Posting Rules  
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump:
 
  Contains New Posts Forum Contains New Posts   Contains No New Posts Forum Contains No New Posts   A Closed Forum Forum is Closed