PHP - Foreach Loop Processing Checkboxes

Hey all..

I have been messing around with some code with a form that has checkboxes on them, and the option of selecting more than one checkbox to submit to the database.  However, I keep getting the error," Warning: Invalid argument supplied for foreach() in (mydirectory)".

I have followed many tutorials and I don't see anything I am doing differently that they are, so I'm sure this is a simple fix, of something I am overlooking, or I am just horrible at this (new person).

Here is the snippet of the HTML code for the checkboxes.
Code: [Select]
<label>
  <input type="checkbox" name="project_list[]" value="chat"/>
  Chat Project (age 18+ requirement)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="forums"/>
  Forums Project (age 18+ requirement)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="content"/>
  Content/Editorial Project (postcasts, blogging, etc.)</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="technology"  />
  Technology Project</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="marketing"/>
  Marketing, Promotions and Publicity</label>
<br />
<label>
  <input type="checkbox" name="project_list[]" value="designartwork"/>
  Design and Artwork</label>
Here is the PHP code that I am using to do this.
Code: [Select]
include 'db.php';

mysql_select_db('skylers_training');

if($_POST['submit'])

{
$project_lists = $_POST['project_list'];

foreach($project_lists as $list); //This is the line the code is getting the error on.


And the section of the INSERT MYSQL CODE for this part.
Code: [Select]
$reginsert = mysql_query("INSERT INTO  ... // the rest of the code (that works fine) follows this.

'$list' // This is the line that is supposed to send data from the checklists to the database.




When I submit the form, in addition to the error, nothing is submitted to the database table for the list (everything else works fine).

Any insight into this, would be appreciated.

Thanks!

I made a loop in order to display a html table where a user can choose various items.

In this table there are several Items, each item has it's own checkbox.

each checkbox value is unique and stored in the Users_and_items mysql table (UserID, Item_ID, Item_Fullname, Item_Picture are the columns)

If a user chooses an item, then it's UserID and the Item_ID get stored in a preferences mysql table (User_ID, Item_ID are the 2 columns)

Everything runs fine but I would like to repopulate the checkboxes now.

I thought about a solution which I need to integrate in the loop to make this happen:



Code: [Select]
<?php

include 'connector.php';

echo "<form action='processor.php' method='post'>";

echo "<table>";

//loop to create AvailableItems html Table , each Item gets listed with it's unique Item_ID

$query1 = "SELECT UserID, Item_ID, Item_Fullname, Item_Picture FROM Users_and_items";
$result1 = @mysql_query($query1);

$num=mysql_numrows($result1);

$i=0;
while ($i < $num) {

//creates a new table row after 3 items displayed
if($i>0 && ($i%3==0)) { echo "<tr>"; }

//gets all the table data for the loop sequentially from mysql row by row

$UserID=mysql_result ($result1,$i,"UserID");
$Item_ID=mysql_result ($result1,$i,"Item_ID");
$Item_Fullname=mysql_result ($result1,$i,"Item_Fullname");
$Item_Picture=mysql_result ($result1,$i,"Item_Picture");

// ### NEW CODE INSERTION POINT - SEE OTHER CODEBOX IN THIS FORUM POST ###

echo "

<td>
<input type='checkbox' name='selecteditems[]' value='$Item_ID' id='$Item_ID' />
<img src='$Item_Picture'><br>
$Item_Fullname
</td>

";

$i++;

//creates a new table row after 3 items displayed
if($i>0 && ($i%3==0)) { echo "</tr>"; }


}

echo "</table>";

echo "
<input type='hidden' name='PRIMARYID' value='$UserID' />
<input type='submit' name='formSubmit' value='OK' />
</form>

";


?>
Code: [Select]
// POSSIBLE SOLUTION, I think that it would run fine but I am a mysql beginner and don't know how to code it completely!

// ### THIS CODE MUST BE INSERTED IN THE LOOP (the insertion point is specified in the other codebox):


$query_repopulate_chkboxes  = "SELECT Item_ID FROM preferences WHERE UserID=$UserID"; // we get all the past user preferences
$result_repopulate_chkboxes =  @mysql_query($query_repopulate_chkboxes); // we store the preferences in a variable

if $Item_ID of the html table that is being created by the php loop
is contained in $result_repopulate_chkboxes (which is the list of all the past user's chosen items)

then echo the function with the checkbox input checked='checked' ELSE
output the normal echo (which leaves the checkbox unchecked).

While I think that this is  a feasible solution,  I am having difficulties to code this section and implement it in the loop since I am a beginner with php. Any help is appreciated!

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

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

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

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?

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!

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.

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

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

Hey Guys.  I have a custom function that simply loops through an  array and outputs the menu categories  it finds in the array.    The foreach loop passes the function an array and the function returns the the value. The problem is that the function returns that last value.   Now I know some of you might say ... "Why don't you put the foreach inside the function and return the value when the foreach loop has been completed"   The reason why is because I to use that foreach loop through  another function as well. I was thinking about using globals to get the return value. But just wanted to get your perspective on the best option here.   Please let me know what you guys think Thanks     User Defined Function

function displayMenuCategories($menu_category){
        $display_menu ="";
        $category_id =  $menu_category['menu_cat_id'];
        $display_menu .=   "<div class='menu_cat'>{$menu_category['menu_cat_name']}</div><br>\n";
        if(!empty($menu_category['menu_cat_desc'])) {
        $display_menu .= "<div class='menu_desc'>{$menu_category['menu_cat_desc']}</div>\n";
        }


    $category_info = array("display" => $display_menu, "category_id" => $category_id );

    return $category_info;
}

Foreach loop

$left_menu_categories // Is the array that contains all the menu categories 

foreach($left_menu_categories as $left_menu_category){

    $get_categories =  displayMenuCategories($left_menu_category);

}
var_dump($get_categories);

Edited by eldan88, 06 July 2014 - 05:01 PM.

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.

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

foreach ($array as $value){

echo $value;

}

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

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

?>