[SOLVED] array help

[adam291086]

i have this array

Array

(

    [username] => l

    [password] => h

    [title] =>

    [forename1] => kjhkjh

    [forename2] => kjhk

    [surname] => kjhkjhkjh

    [addressLine1] =>

    [addressLine2] =>

    [town] =>

    [postcode] =>

    [secondEmail] =>

    [personalUrl] =>

    [postcodeStart] =>

    [authorityToWorkStatement] =>

    [contactPreference] => Mobile

    [EducationLevels_idEducationLevel] =>

    [noOfGcses] => 000

    [gcseEnglishGrade] =>

    [gcseMathsGrade] =>

    [noOfAlevels] => 0000

    [ucasPoints] => 0000

    [studentStatus] => Full-time

    [mobile] =>

    [landline] =>

    [dob] => Array

        (

            [MONTH] =>

            [DAY] =>

            [YEAR] =>

        )

 

    [penaltyPoints] =>

)

 

i need to take dob array and join the month, day and year values and join them together yyyy/mm/dd and put it back into the array for example

Array

(

    [username] => l

    [password] => h

    [title] =>

    [forename1] => kjhkjh

    [forename2] => kjhk

    [surname] => kjhkjhkjh

    [addressLine1] =>

    [addressLine2] =>

    [town] =>

    [postcode] =>

    [secondEmail] =>

    [personalUrl] =>

    [postcodeStart] =>

    [authorityToWorkStatement] =>

    [contactPreference] => Mobile

    [EducationLevels_idEducationLevel] =>

    [noOfGcses] => 000

    [gcseEnglishGrade] =>

    [gcseMathsGrade] =>

    [noOfAlevels] => 0000

    [ucasPoints] => 0000

    [studentStatus] => Full-time

    [mobile] =>

    [landline] =>

    [dob] => 2000/10/27

 

    [penaltyPoints] =>

)

 

i have no idea how to go about this can some push me in the right direction

 

 

[jcombs_31]

How is the array populated to begin with?

[adam291086]

its basically just all the $_POST variables

 

print_r($_POST);

[kickstart]

Hi

 

Can you not just (assuming the array is called $fred):-

 

$fred['dob'] = $fred['dob']['YEAR']."/".$fred['dob']['MONTH']."/".$fred['dob']['DAY'];

 

Although would be tempted to avoid doing that to the $_POST array (ie, copy the bits of that array elsewhere to play with).

 

All the best

 

Keith

[adam291086]

Well this is a uni project and we need to make it so that anyone can add fields into that database and the forms will automaticalyy up date.

 

so i am using this function to generate an insert query

 

function mysql_insert_array($table, $data)
        {

            foreach ($data as $field=>$value)
            {

                $fields[] = sprintf("`%s`", $value);
            }
            $field_list = join(',', $fields);

            $query = sprintf("INSERT INTO `%s` VALUES %s ", $table, $field_list);

            return $query;
        }

hence the reason i use $_POST array so that all the form info will update automatically as the input field names ect = the names within the database table.

[jcombs_31]

So do you plan to have 2 arrays?  I don't quite understand why you can't just concatenate the date fields.

[adam291086]

if i concatenate the data fields which is possible how would i go about create one array from the $_POST array and the new concatenated variable

[adam291086]

i solved it by doing

 

$date = $_POST['dob']['YEAR']."-".$_POST['dob']['MONTH']."-".$_POST['dob']['DAY'];
$test = array();

foreach ($_POST as $key => $value)
{
    if ($key == 'dob')
    {
        $test[$key] = $date;
        continue;
    }
    else
    {
        $test[$key] = $value;
    }
}