PHP - Looping inside a loop, maybe?

Question

I am currently using a foreach loop to display some radio buttons like so

<?php
foreach($roles as $role){
    $output .= '<div class="row">';
    $output .= '    <input name="_'.$role->key.'" type="radio" id="'.$role->key.'" class="radio" />';
    $output .= '    <label for="'.$role->key.'" style="text-transform: lowercase;">'.$role->name.'</label>';
    $output .= '</div>';
}

?>

So thats fairly straight forward .... The bit that i need to do next is confusing ... i need to take the $role->key and see if it matches an entry in another table, if so, echo 'checked="checked"' on the radio button.

It will need to be matched by the $role->key and also the $userid.

Any help would be great.

KJYe.Name · Accepted Answer · 2010-12-05 00:59:48Z

2

Basically you can write a function with a boolean return that Queries to see if the $userid and $role->key exists in the table. if it does return true else return false. Lets say the

function is checkExist it would go something like this.

    $output .= '    <input name="_'.$role->key.'" type="radio" id="'.$role->key.'" class="radio"';
    if(checkExist($userid, $role->key))
         $output .= ' checked '; 
    $output .= '/>';

function checkExist($userid, $key){
     //do a query to check if userid $key exists in table
     //code will look like this :-
     //$search = mysql_query("SELECT COUNT(*) FROM yourtable WHERE user='$userid' and   key='$key'");
     //$total_records = mysql_num_rows($search);
     //the mysql_num_rows() will return the number of records from the query...

     if(mysql_num_rows() == 0)
         return false;
     else
         return true;
}

edited Dec 5, 2010 at 0:59

answered Dec 5, 2010 at 0:43

KJYe.Name

17.2k5 gold badges51 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Chris Over a year ago

Thanks ... Is there any way you could give me an example of the checkExist() code? ... Im kind of new to doing things in functions

jon_darkstar Over a year ago

do you want to query that many times? if size doesn't prohibit maybe the whole table should be loaded and checked against. i guess its an issue of $roles size vs tables

SLaks · Accepted Answer · 2010-12-05 00:28:10Z

0

You can put loops wherever you want, even inside of another one.

answered Dec 5, 2010 at 0:28

SLaks

891k182 gold badges1.9k silver badges2k bronze badges

3 Comments

Chris Over a year ago

When i put the loop inside the one i already have, it echos out the result the amount of times the first loop results.

KJYe.Name Over a year ago

is the $userid in a MySQL table? or another php array?

Chris Over a year ago

The user id is global $userid when the page loads ... in the table with the keys, it also has the userid .. so what it needs to do is link the current userid to the one in the database, take the key assocciated and print echo 'checked="checked"' to the ones it finds in the table

Sasha Kostic · Accepted Answer · 2010-12-05 00:56:53Z

0

for checkExists($id) you can write something like:

function checkExists($id){
    $result = $mysql_query("SELECT ID from tablename WHERE ID=$id");
    return mysql_num_rows($result);
}

btw. I'm writing directly here, you might need to tune up something

answered Dec 5, 2010 at 0:56

Sasha Kostic

464 bronze badges

Collectives™ on Stack Overflow

PHP - Looping inside a loop, maybe?

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related