PHP - Help With Foreach Loop Results

Hello everyone !

I am currently developing a module for my site that will allow me to classify each solution to help a disability by type.
For example, here's an example:

Type : Visual disability
Solution : Add screen readers

For this, I have a database in which these types and solutions are found. In this database, the solutions of one type or another are not in a defined order. They can be put randomly, when a user adds one.

I need to display, in a table, these Types first (as a title), then the solutions corresponding to this type.

I manage to generate a display thanks to a foreach loop, but my solutions are all mixed up and therefore not clearly sorted.

This is how it is currently displayed

Visual disability

    Audio-described cut-scenes

    Highlighted path to follow

    Sensitivity settings for all the controls

    Screen readers on menus

    Slow down the game speed

But I would need it to look like this:

Visual disability

    Audio-described cut-scenes

    Highlighted path to follow

    Screen readers on menus

    Slow down the game speed

Physical disability

    Sensitivity settings for all the controls

In my example above, only the solution "Sensitivity settings for all the controls" is part of the "Physical disability" type. The rest is part of the "Visual disability" type.

Here is the code I currently use to retrieve my information from my database and display it. It's a Wordpress.

 

/*====== Accessibility Options ======*/

function cloux_accessibility_options() {
    if ( function_exists( 'rwmb_meta' ) ) {
        $output = "";
        $accessibility_options = rwmb_meta( 'accessibility-options' );
        $accessibility_options_status = rwmb_meta( 'accessibility-options-status' );
        if( $accessibility_options_status == "1" ) {
            if( !empty( $accessibility_options ) ) {
                $output .= '<div class="accessibility-options widget-box">';
                    $output .= cloux_title( $title = esc_html__( 'Accessibility Options', 'cloux' ), $style = "style-4", $align = "left", $colored_title = '' );
                    $output .= '<ul>';
                        $output .= '<li class="title visual_disability">' . esc_html__( 'Visual disability', 'cloux' ) . '</li>';
                    $output .= '</ul>';

                        foreach ( $accessibility_options as $accessibility_options ) {
                            if( !empty( $accessibility_options ) ) {
                                $accessibility_name =  isset( $accessibility_options['accessibility-options-name'] ) ? $accessibility_options['accessibility-options-name'] : '';
                                $accessibility_type =  isset( $accessibility_options['accessibility-type-name'] ) ? $accessibility_options['accessibility-type-name'] : '';
                                $accessibility_type = get_term( $accessibility_type, 'accessibility' );
                                $accessibility_type_name = $accessibility_type->name;
                                $availability =  isset( $accessibility_options['availability'] ) ? $accessibility_options['availability'] : '';

                            if ( $accessibility_type_name == "Visual disability" ){
                                if( !empty( $accessibility_name ) or !empty( $availability )) {
                        $output .= '<ul>';
                                    $output .= '<li class="item accessibility_name">';
                                        if( !empty( $accessibility_name ) ) {
                                            $accessibility_name = get_term( $accessibility_name, 'accessibility' );
                                            if( ( !empty( $accessibility_name ) ) ) {
                                                $output .= '<a href="' . get_term_link( $accessibility_name ) . '">' . esc_attr( $accessibility_name->name ) . '</a>';
                                            }
                                        }
                                    $output .= '</li>';
                                    $output .= '<li class="item visual_disability status">';
                                        if( $availability == "1" ) {
                                            $output .= '<i class="fas fa-check" aria-hidden="true"></i>';
                                        } else {
                                            $output .= '<i class="fas fa-times" aria-hidden="true"></i>';
                                        }
                                    $output .= '</li>';
                                }
                            }
                            
                            
                            if ( $accessibility_type_name == "Motor/Physical disability" ){
                                if( !empty( $accessibility_name ) or !empty( $availability )) {
                        $output .= '<ul>';
                                    $output .= '<li class="item accessibility_name">';
                                        if( !empty( $accessibility_name ) ) {
                                            $accessibility_name = get_term( $accessibility_name, 'accessibility' );
                                            if( ( !empty( $accessibility_name ) ) ) {
                                                $output .= '<a href="' . get_term_link( $accessibility_name ) . '">' . esc_attr( $accessibility_name->name ) . '</a>';
                                            }
                                        }
                                    $output .= '</li>';
                                    $output .= '<li class="item visual_disability status">';
                                        if( $availability == "1" ) {
                                            $output .= '<i class="fas fa-check" aria-hidden="true"></i>';
                                        } else {
                                            $output .= '<i class="fas fa-times" aria-hidden="true"></i>';
                                        }
                                    $output .= '</li>';
                                }
                            }
                            
                            
                        $output .= '</ul>';
                        }
                    }
                $output .= '</div>';
            }
        }
        return $output;
    }
}

Thank you in advance for all the help you can give me!

 

Edited January 13 by Sagaroth

I would like to write all files from specific folder into .txt file. The output working just fine, but I'm getting only one file saved into my txt file. Any idea? Thanks!

$fileList = glob('C:\users\John\Documents\*pdf');
foreach($fileList as $filename){
if(is_file($filename)){

echo $filename, '<br>'; 

$save_files = fopen("list.txt", "w");
fwrite($save_files,$filename);
fclose($save_files);

}   
}  

 

Hey guys,

Got another question im hoping someone can help me with.

I have a foreach loop (for use in a mysql query):

   foreach ($interests as $interest) {
       $query .= "($id, $interest), ";
   }

problem is i do not want the comma(,) in the last loop.

Is there some kinda of function i can use so it does not insert it on last loop?

Or should i just use a for loop with a nested if loop? something like ;

   for($i=0; $i < count($interests); $i++){
      $query .=
      "($id, '$interests[$i]')";
      if($i + 1 < count($interests)) {
         $query .= ", ";
      }
      }


Cheers guys

what im trying to do is echo all of the results from the database query but add bold to results with a pid of 0. here is my code:


$list = '';
$query = $link->query("SELECT * FROM ".TBL_PREFIX."forums
                        ORDER BY f_lid ASC");
$result = $query->fetchAll();

foreach($result as $key => $val)
{
    if($result[$key]['f_pid'] == 0)
    {
        $list .= '<b>'.$result[$key]['f_name'].'</b><br />';
    }
    $list .= $result[$key]['f_name'].'<br />';
}
echo $list;


this works fine but the ones with a pid of 0 are displayed twice. once as bold and then once normal like so:

General
General
New Features

Testing
Testing
Sandbox
Bugs

my question is how to prevent this.

how do I echo "blah" after the first loop in a foreach loop and the in the rest of them echo "crazy"?

I have a foreach loop which shows the breadcrumb display. But it's stopped working. For some reason the links are no longer links. They are just echoed on screen with no <a> tags.

setting up array:

$crumb_query = mysqli_query($link, "SELECT 
f.forum_id, f.forum_cat_id, f.forum_name,
c.cat_id, c.cat_name
FROM ".TBL_PREFIX."forums as f
LEFT JOIN ".TBL_PREFIX."categories as c
ON c.cat_id = f.forum_cat_id
WHERE f.forum_id = '$forum_id'
") or die(mysqli_error($link));

$crumb_info = mysqli_fetch_array($crumb_query, MYSQLI_ASSOC);

$crumbs = array("index.php" => "Board Index",
"./view_category.php?cid={$crumb_info['cat_id']}" => $crumb_info['cat_name'],
"./view_topics.php?fid=$forum_id" => $crumb_info['forum_name']);

echo build_crumbs($crumbs);


the function:


function build_crumbs($crumbs)
{

foreach($crumbs as $key => $value)
{
$crumb_display = "<a href=\"{$key}\">{$value}</a>";
$crumb_display = implode(" - ", $crumbs);
}

return $crumb_display;
}


can anyone see where im going wrong?

Does anybody know how to make the following code correct? real sorry but its just absolutely blowing my mind im awful with loops and have pretty much no clue what the hell im doing in honesty, any help would be great, Thanks

Code: [Select]
$addIDs_ary = array_map('intval', $_POST['chkInv']);
$addIDs_ary = array_filter($addIDs_ary);
$value = $addIDs_ary;
//Check if hit_id is already in hitlist
$query = mysql_query("SELECT * FROM hitlist WHERE player_id  = '$playerID'");
$result = mysql_query($query);
while ($result = mysql_fetch_assoc($result))
foreach ($result as $hit_id => $value){
if($result[$hit_id] == $value);
$str = "";
}
}
else

For some reason I'm getting an invalid argument supplied for foreach error and I'm not sure why.

Code: [Select]
<?php

// Include the database page
require ('../inc/dbconfig.php');

if (isset($_POST['edit_event_lineup'])) {
    $event_items = $_POST['event_items'];
    $event_id = (int)$_POST['event_id'];
    
    foreach ($event_items as $items) { 
        print_r($items);
        $segment_writer_id = (int)$_POST['segment_writer_id'];
        $introduction = mysqli_real_escape_string($dbc, $_POST['introduction']);
        $conclusion = mysqli_real_escape_string($dbc, $_POST['conclusion']);
        $segment_type = mysqli_real_escape_string($dbc, $_POST['segment_type']);
        $match_number = (int)$_POST['match_number'];
        $segment_number = (int)$_POST['segment_number'];
        $match_type_id = (int)$_POST['match_type_id'];
        $segment_title = mysqli_real_escape_string($dbc, $_POST['segment_title']);
        $match_type_id = mysqli_real_escape_string($dbc, $_POST['match_type_id']);
        $titles_id_list = mysqli_real_escape_string($dbc, $_POST['titles_id_list']);
        $stipulations_id_list = mysqli_real_escape_string($dbc, $_POST['stipulations_id_list']);
        $characters_id_list = mysqli_real_escape_string($dbc, $_POST['character_id_list']);
        $preview = mysqli_real_escape_string($dbc, $_POST['preview']);
    }

    $query = "INSERT INTO `event_segments` 
            (event_id, segment_writer_id, segment_type, sort_order_preview, segment_title, preview, is_submitted_yes_or_no_id) 
        VALUES 
            ('".$event_id."', '".$match_writer_id."', '".$segment_type."' ,'".$sort_order_preview."','".$segment_title."','".$preview."',2)";
    mysqli_query($dbc, $query);
    
}
        
?>

Hey guys, need help on some addition.




foreach($login as $line_num => $line)
{
  $login = explode(" ", htmlspecialchars(str_replace(" "," ",$line)));
  if(stristr($login[1], "\n")) $login[1] = substr($login[1], 0, strlen($login[1])-2);
  $account_data[$line_num] = array($login[0], $login[1]);
$UserID = $login[0];
$AuthKey = $login[1];
$MobLink = "http://mobsters-fb-apache-dynamic-lb.playdom.com/mob_fb/";
$RefreshStat = file_get_contents($MobLink."refresh_stat_manual?user_id=".$UserID."&auth_key=".$AuthKey);
$Cash = explode ("<cash>", $RefreshStat);
$Cash = explode ("<", $Cash[1]);
$Cash = $Cash[0];
$CashForEcho = "$".number_format($Cash[0]);
echo $CashForEcho."<br/>";
echo "<br/><br/>";
}




The variable $Cash will be dynamic for each user I put in the $login_file, and I need to add all of those values up. So say I put in 3 users within the $login_file, and the $Cash for user 1 was $3,000, the $cash for user 2 was $6,000 and the $cash for user 3 was $1,000, I want to be able to automatically add them all up, so it would echo '$10,000' at the end. Hope I've explained it for you guys to understand easily enough, if not let me know.

Thanks

I am working on a photo gallery script in which I need to show 9 images at a time.

Here is my script so far

Code: [Select]
<?php foreach($pictures->result() as $p): ?>
<?php for($i = 1; $i <= 9; $i++) { ?>
    <div class="item">
     <ul>
      <li><a href="images/gallery/<?=$p->category;?>/<?=$p->photo_name;?>" rel="example1" ><img src="images/gallery/<?=$p->category;?>/thumb_<?=$p->photo_name;?>" alt="#" /></a></li>
     </ul>
    </div><!-- end item -->
<?php } ?>
<?php endforeach; ?>

At the moment the script is showing one image at a time 9 times and for every entry in my database.

I have been battling this for a little while now. Thanks in advance for all of your help!

ok.

say i have a list with a foreach loop in it.
like this:

Code: [Select]
echo'
<ul>';

$link = Link::find_all();
foreach($link as $links){
$name = $links->name;

echo'
<li>'.$name.'</li>';

}
echo'
</ul>';




now.
say that i want to put this part :
Code: [Select]
$link = Link::find_all();
foreach($link as $links){
$name = $links->name;

into a function so i can reuse the code...

like this:

FUNCTION
Code: [Select]
function(find_li){
  $link = Link::find_all();
  foreach($link as $links){
  $name = $links->name;
}
Code: [Select]
echo'
<ul>';

find_li();

echo'
<li>'.$name.'</li>';
}
echo'
</ul>';


the problem is the foreach } its not inside the function so the function will not work. but it needs to be after the </li> so that i get all the results in the <li>

so is there a way to put the function before the <li> and the } after the </li>

Hello gurus,

I've been pounding my head against the wall on this one.  It must be something simple I'm missing.  I have a text field that posts ($_POST['case_ids']) a comma separated value such as 10067,10076  When I use explode to break it up it should make it an array.  However when I use it in a foreach loop I get an invalid argument error.  If I do a check for is_array() it fails the check. 

If I print the array I get:
Code: [Select]
Array ( [0] => 10067 [1] => 10076 )
So I thought maybe I get the error because the individual array elements don't have commas between them so I wrote this to put commas in between each element except the last:
Code: [Select]
$cases = array();
$numItems = count($case_ids);//get count of array
$i = 0;//initialize counter
foreach($case_ids as $key => $value){
if($i+1 != $numItems) {
$cases[$key] = $value.',';
}else{
$cases[$key] = $value;
}//end if $i+1
$i++;
}
However this new array still gets the invalid argument error.  Are these not valid arrays?

Any help would be greatly appreciated.

Thanks in advance,
Twitch

Hi everybody

I am new to arrays, and loops pretty much, so please dont be mean!

I am trying to turn a single upload form into a multiple upload form.  My logic is I need to use arrays and loop the code for uploading the data from the form to the database (for each of these files, create a thumbnail, resize and rename original, move to folder, create path, and insert all that information into the db)

But I have no idea how

I've got this in the form (now) ....
<pick an album to put the files into>
<input type="file" name="image[]" >
<input type="file" name="image[]" >

and this is the code for the whole upload. It worked for single uploads ... but I'm now at a loss ...

The code is abit messy, sorry.  I'm fairly sure I need a foreach loop, but I dont know where to put it

Really Really hoping you can help. Many thanks in advance

Code: [Select]
<?php 
ini_set("memory_limit","120M");
include ("DBCONNECT");
include ("CHECK ADMIN");
if ($admin != 1)
{
header("location:./login.php");
}
else {
define ("MAX_SIZE","5000"); 
define ("WIDTH","150"); 
define ("HEIGHT","100"); 
function make_thumb($img_name,$filename,$new_w,$new_h)
{
$ext=getExtension($img_name);
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);
if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2) {
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else {
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

Imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 
if(!strcmp("png",$ext))
imagepng($dst_img,$filename); 
else
imagejpeg($dst_img,$filename); 
imagedestroy($dst_img); 
imagedestroy($src_img); 
}
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}
$errors=0;
if(isset($_POST['submit1']) && !$errors)
{
$sqlalbum="INSERT INTO album (album_name) VALUES ('$_POST[newalbumname]')";
mysql_query($sqlalbum) or die ('Error, album_query failed : ' . mysql_error());
}

If(isset($_POST['Submit']))
{
$image=$_FILES['image']['name'];
// if it is not empty
if ($image) 
{
$filename = stripslashes($_FILES['image']['name']);

$extension = getExtension($filename);
$extension = strtolower($extension);

if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png")) 
{
echo '<h1>Unknown extension! You can only upload jpg, jpeg and png files</h1>';
$errors=1;
}
else
{
$size=getimagesize($_FILES['image']['tmp_name']);
$sizekb=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}
$image_name=time().'.'.$extension;
$newname="uploads/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied) 
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
$thumb_name='uploads/thumbs/thumb_'.$image_name;
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

If(isset($_POST['Submit']) && !$errors) 
{
$album = $_POST['album'];
$query = "INSERT INTO upload (name, path, album_id, thumbpath ) ".
"VALUES ('$image_name', '$newname' , '$album', '$thumb_name')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
}

?>

Hello. 

I was wondering if anyone could please help with a problem I seem to be having a problem with my foreach loops. I have an array that holds other arrays. When I am trying to populate the database tables with the information in each array, things are going horribly wrong.

This is my code:

$tabledata = $this->db->get('tableinfo');

$i = 0;
$_temp = array();
foreach($tabledata->result() as $row) {
	$data[$i] = $this->callAPI("lateststandings&records=3&category=" . $row->category . "&distance=" . $row->distance_id);
	array_push($_temp, $row->dbname);
	$i++;
}

$j = 0;
foreach($data[$j]['Records']['Record'] as $record) {
	$record['FirstName'] .= " " . $record['LastName'];
	$this->db->replace($_temp[$j], $record);
	$j++;
}

 

When this is run 2 things are happening:

1) What I am expecting to happen is, there should be 3 rows added to each table. But only 1 is being added to each table.
2) The 3 rows that are being created (1 in each table), are the 3 rows I am expecting to see in the first table.

I am not sure what I am doing wrong in these loops.

 

hello

why does my div move when i use a foreach loop ?

if i use the code below i get the following

i added a border style to the div so i can see that some are in and some are out:

result 1 = not in a div
result 2 = in a div
result 3 = in a div
etc
then on the end i get a div with no result in it


Code: [Select]
function  name(){

echo'
<div id="divName">';

   $a = Class::find_all();

   foreach ($a as $ab){
   $name = $ab->name;
   $dest = $ab->destination;

   <ul>
   <li><a href="index.php?pageID='.$dest.'">'.$name.'</a></li>
   </ul>';
   }

echo'</div>';
}


thanks
rick