Jump to content

Foreach errors


Xtremer360

Recommended Posts

I'm not sure why but I'm getting the following errors inside of FireBug after my form submits.

 

<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/home/xtremer/public_html/efedmanager/processes/bookings.php</b> on line <b>49</b><br />

<br />

<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/home/xtremer/public_html/efedmanager/processes/bookings.php</b> on line <b>68</b><br />

<br />

<b>Warning</b>:  Invalid argument supplied for foreach() in <b>/home/xtremer/public_html/efedmanager/processes/bookings.php</b> on line <b>82</b><br />

 

 

 

<?php

error_reporting( E_ALL );

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

$eventItems = json_decode( $_POST[ 'event_items' ], true );
$event_id = (int)$_POST['event_id'];

for( $i = 0; $i < sizeof( $eventItems ); $i++ ) {
    
    $eventItem = $eventItems[ $i ];
    $segment_type = $eventItem['segment_type'];
    
    if ($eventItem[ 'segment_type' ] === 'Introduction' ) {
        
        $introduction_preview = $eventItem['introduction_preview'];
        
        $query = "INSERT INTO `event_segments` 
           (event_id, segment_type, introduction_preview) 
        VALUES 
           ('".$event_id."', '".$segment_type."','".$introduction_preview."')";
            
        mysqli_query($dbc, $query);
        
    }
    
    if ($eventItem[ 'segment_type' ] == "Match") {
    
        $segment_writer_id = $eventItem['segment_writer_id'];
        $match_number = $eventItem['match_number'];
        $match_type_id = $eventItem['match_type_id'];
        $segment_title = $eventItem['segment_title'];
        $titles_id_list = $eventItem['titles_id_list'];
        $stipulations_id_list = $eventItem['stipulations_id_list'];
        $characters_id_list = $eventItem['characters_id_list'];
        $segment_preview = $eventItem['segment_preview'];
        
        $query = "INSERT INTO `event_segments` 
                (event_id, segment_writer_id, segment_type, match_number, segment_title, segment_preview, is_submitted_yes_or_no_id) 
            VALUES 
                ('".$event_id."', '".$segment_writer_id."', '".$segment_type."' ,'".$match_number."','".$segment_title."','".$segment_preview."',2)";
                
        mysqli_query($dbc, $query);
        
        $event_segment_id = mysqli_insert_id($dbc);	
        
        foreach ($characters_id_list AS $character_id) {
            $query2 = "INSERT INTO `event_match_characters`
                (event_segment_id, character_id)
            VALUES
                ('".$event_segment_id."', '".$character_id."')";
        }
        
        mysqli_query($dbc, $query);
        
        $query = "INSERT `event_match_match_types`
            (event_segment_id, match_type_id)
        VALUES
            ('".$event_segment_id."', '".$match_type_id."')";
            
        mysqli_query($dbc, $query);
        
        
        if ($stipulations_id_list != "0") {
            
            foreach ($stipulations_id_list AS $stipulation_id) {
                
                $query = "INSERT `event_match_stipulations`
                    (event_segment_id, match_type_id)
                VALUES
                    ('".$event_segment_id."', '".$stipulation_id."')";
                    
                mysqli_query($dbc, $query);
                
            }
        }
        
        if ($titles_id_list != "0") {
            
            foreach ($titles_id_list AS $title_id) {
                
                $query = "INSERT `event_match_titles`
                    (event_segment_id, title_id)
                VALUES
                    ('".$event_segment_id."', '".$title_id."')";
                    
                mysqli_query($dbc, $query);
                
            }
        }
    }
    
    if ($eventItem[ 'segment_type' ] == "Segment") {
         
        $segment_writer_id = $eventItem['segment_writer_id'];
        $segment_number = $eventItem['segment_number'];
        
        $query = "INSERT INTO `event_segments` 
            (event_id, segment_writer_id, segment_type, segment_number, sort_order_preview, is_submitted_yes_or_no_id) 
        VALUES 
            ('".$event_id."', '".$segment_writer_id."', '".$segment_type."' ,'".$segment_number."','".$sort_order_number."',2)";
    
        mysqli_query($dbc, $query);
                
    }

    if ($eventItem[ 'segment_type' ] == "Conclusion") {
        
        $conclusion_preview = $eventItem['conclusion_preview'];
           
        $query = "INSERT INTO `event_segments` 
            (event_id, segment_type, conclusion_preview) 
        VALUES 
            ('".$event_id."', '".$segment_type."','".$conclusion_preview."')";
        
        mysqli_query($dbc, $query);
            
    }
    
    $query = "UPDATE `events` SET `event_status_id` = 2 WHERE id = '".$event_id."' LIMIT 1";
    mysqli_query($dbc, $query);
    
}
               
?>

Link to comment
https://forums.phpfreaks.com/topic/238012-foreach-errors/
Share on other sites

I decided to go to more of a for loop and now I'm not getting any errors however after trying to look through my code I'm having a hard time to figuring out why its duplicating the entries into said table.

 

Here is the updated code.

 

http://pastebin.com/jS4XEEU9

Link to comment
https://forums.phpfreaks.com/topic/238012-foreach-errors/#findComment-1223006
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.