D dressterz New Member Sep 13, 2012 #1 This is my current \[code\]$_POST\[/code\] output.\[code\]Array( [fullname] => John Doe => [email protected] [phone] => 123-455-6444 [address] => 23-10 My Address [zip] => 12345 [fullname_2] => Array ( [0] => M. Owen [1] => V. Persie ) [email_2] => Array ( [0] => [email protected] [1] => [email protected] ) [phone_2] => Array ( [0] => 123-455-6555 [1] => 222-111-1111 ) [submit] => Submit)\[/code\]I want the data above will store to my current database format looks like below.\[code\]id | fullname | email | phone | address | zip | uid----------------------------------------------------------------------------------------1 | John Doe | [email protected] | 123-455-6444 | 23-10 My Address | 12345 | 12 | M. Owen | [email protected] | | | | 13 | V. Persie | [email protected] | | | | 1\[/code\]I'm getting blur how to save the array to MySQL.\[code\]$query = "INSERT INTO users SET fullname ='" . $fullname . "', email ='" . $email . "', phone='" . $phone . "', address ='" . $address . "', zip='" . $zip . "'";$db->rq($query);\[/code\]Let me know the clue.
This is my current \[code\]$_POST\[/code\] output.\[code\]Array( [fullname] => John Doe => [email protected] [phone] => 123-455-6444 [address] => 23-10 My Address [zip] => 12345 [fullname_2] => Array ( [0] => M. Owen [1] => V. Persie ) [email_2] => Array ( [0] => [email protected] [1] => [email protected] ) [phone_2] => Array ( [0] => 123-455-6555 [1] => 222-111-1111 ) [submit] => Submit)\[/code\]I want the data above will store to my current database format looks like below.\[code\]id | fullname | email | phone | address | zip | uid----------------------------------------------------------------------------------------1 | John Doe | [email protected] | 123-455-6444 | 23-10 My Address | 12345 | 12 | M. Owen | [email protected] | | | | 13 | V. Persie | [email protected] | | | | 1\[/code\]I'm getting blur how to save the array to MySQL.\[code\]$query = "INSERT INTO users SET fullname ='" . $fullname . "', email ='" . $email . "', phone='" . $phone . "', address ='" . $address . "', zip='" . $zip . "'";$db->rq($query);\[/code\]Let me know the clue.