dynamically created PHP array field not saving data in table using mysql

Question

Hi I have a section where I am cloning a div for "Add another" button everytime it's clicked, the form fields are set as arrays. The query runs but saves nothing and just displays empty rows... can someone please tell me where could I be wrong?

<label for="GCSESubject[]">GCSE Subjects</label>
<select name="GCSESubject[]" id="GCSESubject[]" style="width: 178px; float: left; margin-right: 12px;"> 
    <option value=""></option> 
    <?php echo getGCSESubjectsOptions(false, true);?> 
</select>

Then I save it using these lines of code:

function saveGCSEEducation() 
{ 
    if (isset($_POST['saveGCSEEducation'])) { 

        $db = new Connection(DB_HOST, DB_USER, DB_PASS, DB_NAME); 

        $GCSESubjectSerialized = serialize($_POST['GCSESubject']); 
        $GCSESubject=mysql_real_escape_string($GCSESubjectSerialized); 
        $userID = $_SESSION['user']['userID']; 

        $db->query('
            INSERT INTO GCSEEducation 
            (userID, GCSESubject, GCSEGrade) 
            VALUES 
            ("'.$userID.'", "'.$GCSESubject.'", "'.$GCSEGrade.'")  
        '); 
    }
}

عثمان غني · Accepted Answer · 2014-03-05 10:25:36Z

1

You must loop an array before entering its values to database as follows:

function saveGCSEEducation() 

{ 
    if (isset($_POST['saveGCSEEducation'])) { 

        $db = new Connection(DB_HOST, DB_USER, DB_PASS, DB_NAME); 
        $count= count($_POST['GCSESubject']);
        for($i=0;$i<$count;$i++)
        {
        $GCSESubjectSerialized = serialize($_POST['GCSESubject'][$i]); 
        $GCSEGradeSerialized = serialize($_POST['GCSEGrade'][$i]); 
        $GCSESubject=mysql_real_escape_string($GCSESubjectSerialized); 
        $GCSEGrade=mysql_real_escape_string($GCSEGradeSerialized); 
        $userID = $_SESSION['user']['userID']; 
        $db->query(' 

            INSERT INTO GCSEEducation 

            (userID, GCSESubject, GCSEGrade) 

            VALUES 

            ("'.$userID.'", "'.$GCSESubject.'", "'.$GCSEGrade.'")  

            '); 
           }
    }
}

Hope it helps!!

edited Mar 5, 2014 at 10:25

answered Mar 5, 2014 at 10:18

عثمان غني

2,7056 gold badges55 silver badges82 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user3297381 Over a year ago

Hey thanks a lot, it works but just one prob, it's adding an extra blank record containing 0, 0 values, how can I get rid of that ?

عثمان غني Over a year ago

can you please write print_r($_POST['GCSESubject']); so that I can find the problem

user3297381 Over a year ago

On your suggestion @Echo I am doing this as there are two fields. $count= count($_POST['GCSESubject']); for($i=0;$i<$count;$i++) { $GCSESubject = mysql_real_escape_string($_POST['GCSESubject'][$i]); $GCSEGrade = mysql_real_escape_string($_POST['GCSEGrade'][$i]); $db->query(' INSERT INTO GCSEEducation (userID, GCSESubject, GCSEGrade) VALUES ("'.$userID.'", "'.$GCSESubject.'", "'.$GCSEGrade.'") '); }

عثمان غني Over a year ago

right print_r($_POST['GCSESubject']); at start of function then tell me the output of it

user3297381 Over a year ago

It was not printing anything but I just applied a !empty check for one of the two and it worked, yayyy, thanks a lot Echo, You Rock!!

Collectives™ on Stack Overflow

dynamically created PHP array field not saving data in table using mysql

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related