unemployment Posted March 8, 2011 Share Posted March 8, 2011 How do I check to see if a value is in an array and then echo it? If index.php is found in the pages column. Check to see if it's value is in the $pages array. If the value matches, echo the value. function fetch_feedback_top_performers() { $sql = "SELECT `page`, SUM(`like`) FROM `feedback` GROUP BY `page` ORDER BY SUM(`like`) DESC LIMIT 10"; $rs = mysql_query($sql); while($row = mysql_fetch_assoc($rs)) { $results[] = $row; } return $results; } $pages = array( 'about' => 'About', 'index' => 'Homepage', ); Echo it here... <?php $results = fetch_feedback_top_performers(); foreach ($results as $result) { $page = $result['page']; $total = $result['SUM(`like`)']; $extremoved = substr($page, 0, -4); ?> <div class="mhl mvs"><span class="left"><?php echo ucwords($extremoved); ?></span><span class="f_right">(<?php echo $total; ?>)</span></div> <?php } ?> I just have no idea how to perform the check. I want to do this for security. Link to comment https://forums.phpfreaks.com/topic/230021-if-value-is-in-array-echo-its-key/ Share on other sites More sharing options...
TOA Posted March 8, 2011 Share Posted March 8, 2011 http://php.net/manual/en/function.in-array.php Link to comment https://forums.phpfreaks.com/topic/230021-if-value-is-in-array-echo-its-key/#findComment-1184688 Share on other sites More sharing options...
unemployment Posted March 8, 2011 Author Share Posted March 8, 2011 http://php.net/manual/en/function.in-array.php I took your advice but couldn't get it to work. <?php $results = fetch_feedback_top_performers(); foreach ($results as $result) { $page = $result['page']; $total = $result['SUM(`like`)']; $extremoved = substr($page, 0, -4); if (in_array("${extremoved}", $pages)) { ?> <div class="mhl mvs"> <span class="left"><?php echo ucwords($extremoved); ?></span> <span class="f_right">(<?php echo $total; ?>)</span> </div> <?php } } ?> Link to comment https://forums.phpfreaks.com/topic/230021-if-value-is-in-array-echo-its-key/#findComment-1184705 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.