PHP - Foreach Loop Question.

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"?

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

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

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);
    
}
        
?>

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?

Hello all,   I have the following code (which obviously has unnecessary redundancy) and I would like to replace it with a ForEach loop in order to make the code shorter, and perhaps more efficient.

        // validate input
        $valid = true;
        if (empty($store_name)) {
            $storeNameError = 'Please enter a Store Name';
            $valid = false;
        }

        if (empty($item_description)) {
            $itemDdescriptionError = 'Please enter an Item Description';
            $valid = false;
        }

        if (empty($qty_pkg)) {
            $qtyPkgError = 'Please enter Quantity or Package';
            $valid = false;
        }

        if (empty($pkg_of)) {
            $pkgOfError = 'Please enter the Count/Quantity';
            $valid = false;
        }

At this point (being a newbie) I'm trying to wrap my head around the ForEach statement, but all I can achieve is to tie-my-knickers-in-a-knot. I know this is childs-play for some of you here, and I hope you can help me get a working ForEach statement.   The following is the declaration of some related arrays (which potentially may be incorrect/inefficient as well):

    // Create an array of the fields we want to capture, along with their labels
    $fields = array(
        'store_name'=>'Store Name',
        'item_description'=>'Item Description',
        'qty_pkg'=>'Qty / Pkg',
        'pkg_of'=>'Pkg. Of',
        'price'=>'Price',
        'flyer_page'=>'Flyer Page #',
        'limited_time_sale'=>'Limited Time Sale Days',
        'nos_to_purchase'=>'Nos. to Purchase'
    );

    // Create an array-type variable to keep track of validation errors
    $fieldsErrorMsgs = array(
        'storeNameError'=>'Please enter a Store Name',
        'itemDescriptionError'=>'Please enter an Item Description',
        'qtyPkgError'=>'Please enter Qty or Pkg',
        'pkgOfError'=>'Please enter the Qty',
        'priceError'=>'Please enter the Price',
        'flyerPageError'=>'Please enter the Flyer Page #',
        'limitedTimeSaleError'=>'Please enter the Limited Time Sale Days',
        'nosToPurchaseError'=>'Please enter the No(s). to Purchase'
    );

And here's what I've tried...but there seems to be the following two problems with the ForEach portion of the code: 1) No errors are being displayed (inspite of the fact that I'm leaving all fields blank and clicking on the [Create] button 2) A row is being created (with all blank columns)

        $valid = true;
        $errors = array();
        
        foreach($fields AS $field=>$label){
            //The following line is using the ternary operator, it's basically a shorthand if/else assignment.  
            $errors[$field] = (!isset($values['store_name']) || !strlen($values['store_name'])) ? $errors[$label] = 'Mandatory field, input required!' : NULL;

            if(!strlen($errors[$label])){
                $valid = false;            
            }
        }  
 
        // insert data
        if ($valid) {
            $pdo = Database::connect();
            $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
            $sql = "INSERT INTO shoplist (store_name,item_description,qty_pkg,pkg_of,price,flyer_page,limited_time_sale,nos_to_purchase,shopper1_buy_flag,shopper2_buy_flag,purchased_flag,purchase_later_flag)
                    VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
            $q = $pdo->prepare($sql);
            $q->execute(array($store_name,$item_description,$qty_pkg,$pkg_of,$price,$flyer_page,$limited_time_sale,$nos_to_purchase,$initialize_flag,$initialize_flag,$initialize_flag,$initialize_flag));
            Database::disconnect();
            header("Location: index.php");
        }

The following is the FORM portion of the code, which is where the logic for displaying the "error messages" is defiend

            <form class="form-horizontal" action="create.php" method="post">            
                <?php
                    foreach($fields AS $field=>$label){
                        //Print the form element for the field.
                        echo "<label>{$label}:<br>";
                        //If the field had an error, display it.
                        if(isset($errors[$field])){
                            echo ' <span class="error">'.$errors[$field].'</span><br>';
                        }
                        //Echo the actual input. If the form is being displayed with errors, we'll have a value to fill in from the user's previous submission.
                        echo '<input type="text" name="'.$field.'"';
                        if(isset($values[$field])){
                            echo ' value="'.$values[$field].'"';
                        }
                        echo '/></label>';
                    }
                ?>
                <div class="form-actions">
                    <button type="submit" class="btn btn-success">Create</button>
                    <a class="btn" href="index.php">Back</a>
                </div>
            </form> 

Appreciate the help guys.   Thanks

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.

 

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.'">';
}

?>

Object-  Take array of IP addresses and add up all occurrences of a particular IP address. 



//$item is an array of IP addresses

foreach ($item as $key => $unique_ip)
{
         if($unique_ip == $ip) 
                                                 $a++;
}
echo $a;

I get a blank page.  What am I missing?

Hiya!

I have an issue, here is my code.


<?php
class generateInvoice {

private $invoiceID;

public function __construct($invoiceID) {
$this->_INID = mysql_real_escape_string($invoiceID);
}

public function __drawInvoice() {
$get_invoice = "SELECT * FROM `invoices` WHERE `id` = '$this->_INID' LIMIT 1";
$run_get_invoice = mysql_query($get_invoice);

if($run_get_invoice) {
if(mysql_num_rows($run_get_invoice) == 1) {
while($invoice_m = mysql_fetch_assoc($run_get_invoice)) {

if($invoice_m == 1) {
$status = 'Awaiting Payment';
} elseif($invoice_m == 2) {
$status = 'Paid';
}

$items_mass = explode(',', $invoice_m['items']);

foreach($items_mass as $item_key => $item_value) {
$item_split = explode('-', $item_value);

echo '<pre>' . print_r($item_split, true) . '</pre>';

foreach($item_split as $item_key_final => $item_value_final) {
$invoice .= '
<tr class="item-row">
<td class="item-name"><div class="delete-wpr">' . $item_value_final[1] . '</div></td>
<td class="description">THIS IS THE DESCRIPTION</td>
<td><span class="cost">$650.00</span></td>
<td><span class="qty">1</span></td>
<td><span class="price">$650.00</span></td>
</tr>';
}
}
}

return $invoice;
} else {
return false;
}
} else {
return false;
}
}
}
?>


This is what is displayed.

Array
(
    => 1 [1] => Test Product
    [2] => 6.99
    [3] => 2
)

Array
(
    => 5 [1] => Tester Product
    [2] => 600.99
    [3] => 1
)

THIS IS THE DESCRIPTION $650.00 1 $650.00
e
THIS IS THE DESCRIPTION $650.00 1 $650.00
.
THIS IS THE DESCRIPTION $650.00 1 $650.00
THIS IS THE DESCRIPTION $650.00 1 $650.00
THIS IS THE DESCRIPTION $650.00 1 $650.00
e
THIS IS THE DESCRIPTION $650.00 1 $650.00
0
THIS IS THE DESCRIPTION $650.00 1 $650.00
THIS IS THE DESCRIPTION $650.00 1 $650.00

I need it so that I can use each of the array's above and echo out each item (key) individually. I don't understand whats going wrong?

Many thanks,

James.

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

$array = array("1","2","3");

foreach ($array as $value){

echo $value;

}

Put its only echoing out 3, not the whole array.

I have the following form the just has one field. 

Code: [Select]
<html>
    <head>
        <title>Post</title>
    </head>
    <body>
        <form action="worldpay_callback.php" method="post">
            <input type="text" name="username" id="username" />
            <input type="submit" name="submit" id="submit" value="send" />
        </form>
    </body>
</html>

I am then posting the form to the following page that is meant to loop through all of the post values and save them to a text file.  For some reason my foreach loop doesn't seem to be working as done of the post values are getting written to the text file.  Can anyone see anything I'm doing wrong?

Code: [Select]
$myFile ="notifications.txt";
$fh = fopen($myFile, 'w+') or die("can't open file");

foreach($_POST as $k=>$v)
{
   $data = 'POST: Key:'.$k.' - Value:'.$v ." \n";
   fwrite($fh, $data);
}
   
fclose($fh);

return "[OK]";

Thanks for any help

Hello to all

I have problem a with my foreach loop..

First : Is it possible to rename each element that's been outputted  everytime the loop execute?
Code: [Select]
<?php
$arr = array(mikel, 17, cambodia, 50kgs, 5 feet, anna, 21, peru, 45kgs, 6 feet);
foreach ($arr as &$value) {
    $value = $value;
}
?>
What i would like on the result of the foreach loop is
name : mikel
Age : 17
address : cambodia
weight : 50kgs
height : 5 feet
is this possible?

Second : i want to echo the result of the for each loop in every 5 turns.
result 1 = mikel, 17, cambodia, 50kgs, 5 feet
result 2 = anna, 21, peru, 45kgs, 6 feet

Can anyone help me on this? thanks