Storing array items in MySQL using foreach

Question

I have arrays within an array and I want to loop through each item of the nested arrays and put them into different mysql columns. There is a limit of 3 entries per array, and I need $workexp_array_t to go into the work experience column, the $credentials_array_t items to go into the credentials column etc.

The problem I'm having is that using these nested foreach loops it just places the first letter of the entry into the column instead of the proper entry. How can I get each array items to go into their proper column? Do I really need to set up separate tables for each thing (ie. education experience, credentials, work experience, etc.)?

    $tutor_background = array($workexp_array_t, $credentials_array_t, $education_array_t, $extra_array_t);

foreach ($tutor_background as $entry) {
    foreach ($entry as $background) {
        $query = "INSERT INTO tutor_background (login_value, work_history, credentials, education_history, extra_skills) VALUES ('{$_SESSION['login_value']}', '{$background[0]}', '{$background[1]}', '{$background[2]}', '{$background[3]}')";
        $process_query = mysql_query($query);
    }
}

Can you show us how your array is setup with a print_r($tutor_background) — Jared
– Jared, Commented Dec 8, 2012 at 0:53
is each $background a string? that would explain why it's only entering one character. either that, or the column is set to varchar(1) — kennypu
– kennypu, Commented Dec 8, 2012 at 0:53

Jared · Accepted Answer · 2012-12-08 00:55:09Z

1

Going to take a guess here and say you only need one foreach.

$tutor_background = array($workexp_array_t, $credentials_array_t, $education_array_t, $extra_array_t);

foreach ($tutor_background as $entry) {
        $query = "INSERT INTO tutor_background (login_value, work_history, credentials, education_history, extra_skills) VALUES ('{$_SESSION['login_value']}', '{$entry[0]}', '{$entry[1]}', '{$entry[2]}', '{$entry[3]}')";
        $process_query = mysql_query($query);
    }
}

answered Dec 8, 2012 at 0:55

Jared

12.5k1 gold badge37 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

Storing array items in MySQL using foreach

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related