1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

recursion function problem..........

Discussion in 'PHP' started by dineshsingh1984, Oct 1, 2014.

0
  1. #1
    I want find out the parent category id which category id is 0 ????????????????
    my table :
    id name p_id
    1 hotels 0
    2 food 1
    3 lunch 2

    function find_pid($val)
   {
   $sqlfetch = mysql_query("select * from category_tb where id = '{$val}'");
   $refetch = mysql_fetch_array($sqlfetch);
   if($refetch['p_id'] > 0)
     {
       find_pid($refetch['p_id']);
     }
   else
     {
       $cat = $refetch['id'];
       return $cat;
     }
   }

echo find_pid(3);
    PHP:
    but here result is not display...................
    plz tell me what the problem, plz help me....................
     
    Solved! View solution.
    Last edited by a moderator: Oct 1, 2014
    dineshsingh1984, Oct 1, 2014 IP
  2. Anveto

    Anveto Well-Known Member

    Messages:
    697
    Likes Received:
    40
    Best Answers:
    19
    Trophy Points:
    195
    #2
    Try this

    function find_pid($val)
{
    $sqlfetch = mysql_query("select * from category_tb where id = '".$val."'");
    while ($row = mysql_fetch_array($sqlfetch)) {
        if ($row['p_id'] == 0)
        {
            return $row['p_id']);
        }
    }
    return "failed to find a result with p_id == 0";
}
    PHP:
     
    Last edited by a moderator: Oct 1, 2014
    Anveto, Oct 1, 2014 IP
  3. Sano000

    Sano000 Active Member

    Messages:
    52
    Likes Received:
    4
    Best Answers:
    5
    Trophy Points:
    53
    #3
    Hello,
    Your script doing several queries into database, it is not a good idea. You may make this with just a single query.

    SELECT t.id, t.name, @pv := t.p_id as p_id
FROM (SELECT * FROM category_tb ORDER BY id DESC) t
JOIN (SELECT @pv := YOUR_VAL_HERE) tmp
WHERE t.id = @pv
    Code (markup):
    You will get several rows (full path) where the last one will be your parent element
     
    Sano000, Oct 1, 2014 IP
    sarahk likes this.
  4. Anveto

    Anveto Well-Known Member

    Messages:
    697
    Likes Received:
    40
    Best Answers:
    19
    Trophy Points:
    195
    #4
    Ah, I think what Sano000 is trying to say is that you could solve this with a much simpler query and just skip the loop and recursion like this

    $sqlfetch = mysql_query("SELECT * FROM category_tb WHERE id = '".$val."' AND p_id = 0");
    Code (markup):
    This will give you all the rows that have your value and and have a p_id equal to 0
     
    Anveto, Oct 1, 2014 IP
  5. Sano000

    Sano000 Active Member

    Messages:
    52
    Likes Received:
    4
    Best Answers:
    5
    Trophy Points:
    53
    #5
    No, I trying to say, that you can make a recursivity on a Mysql server side. It will be faster and easier. Just add my query into mysql_query function and pop a last row.
     
    Sano000, Oct 1, 2014 IP
  6. #6
    how about this?
    function find_pid($val)
{
$sqlfetch = mysql_query("select * from category_tb where id = '{$val}'");
$refetch = mysql_fetch_array($sqlfetch);
if($refetch['p_id'] > 0)
{
return find_pid($refetch['p_id']);
}
else
{
$cat = $refetch['id'];
return $cat;
}
}
    PHP:

    ​
     
    Last edited by a moderator: Oct 1, 2014
    brealmz, Oct 1, 2014 IP
  7. sarahk

    sarahk iTamer Staff

    Messages:
    29,016
    Likes Received:
    4,584
    Best Answers:
    124
    Trophy Points:
    665
    #7
    if @Sano000's approach scares you off and you know that there is only one layer of "parent" - ie not grandparent, great grandparent then you can try this

    $sql = "select Parent.* 
from category_tb as Parent,
category_tb as Child
where Child.p_id = Parent.id
and Child.id = '{$val}'"
    PHP:
    and once you have that up and running look for a database handler script that will do nice things like return you an array of results and that doesn't use "depricated" functions like mysql_query
     
    sarahk, Oct 1, 2014 IP
  8. dineshsingh1984

    dineshsingh1984 Active Member

    Messages:
    154
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    51
    #8
    thanks for reply....
     
    dineshsingh1984, Oct 1, 2014 IP