How to store $_POST data in an array and access it with foreach and save into mysql [duplicate]

Question

Possible Duplicate:
PHP $_POST print variable name along with value

I am just wondering how to store $_POST variables in an array.

I have several $_POST variables, as follows:

$_POST['cCode'];
$_POST['sSubject'];
$_POST['lect'];
$_POST['rRoom'];
$_POST['dDay'];
$_POST['sTime'];
$_POST['eTime'];

How can I access them all at the same time using a foreach()?

I know how to access one, like this:

   $data = $_POST['cCode'];
    foreach($data as $code){
        echo $code;
    }

Then I want to save it into mysql..

Here is my database:

DROP TABLE IF EXISTS `ocs_database`.`schedule`;
CREATE TABLE  `ocs_database`.`schedule` (
  `schedID` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `courseCode` varchar(30) NOT NULL,
  `subjectName` varchar(45) NOT NULL,
  `roomName` varchar(45) NOT NULL,
  `lecturerName` varchar(45) NOT NULL,
  `day` varchar(45) NOT NULL,
  `startTime` varchar(45) NOT NULL,
  `endTime` varchar(45) NOT NULL,
  PRIMARY KEY (`schedID`)
) ENGINE=InnoDB AUTO_INCREMENT=82 DEFAULT CHARSET=latin1;

Glavić · Accepted Answer · 2012-10-02 18:20:25Z

6

foreach ($_POST as $key => $value) {
    echo "$key = $value<br>";
}

answered Oct 2, 2012 at 18:20

Glavić

43.6k13 gold badges79 silver badges108 bronze badges

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

6 Comments

mario Over a year ago

Just code explains very little. OP is obviously new to PHP programming.

user1715120 Over a year ago

However, if I want to save the data from each $_POST into a database how will I do this? I have this query: INSERT INTO schedule (courseCode, subjectName, roomName, lecturerName, day, startTime, endTime) VALUES() how will I put the data into the VALUES()? I'm still new at this PHP thing.

Glavić Over a year ago

You have only one $_POST. $_POST is array of submitted data. Fetch data that you need, and save it to DB. Where is the problem? What have you tried?

user1715120 Over a year ago

From the $_POST's that I have mentioned earlier, I want to save them all at the same time into my DB with the help of foreach.

Glavić Over a year ago

What is the database table structure? p.s. in your question there is nothing about saving to DB... Update your question.

|

poudigne · Accepted Answer · 2012-10-02 18:21:41Z

2

$_POST itself is an array, so you don't need to store it in an other array. do as glavic said.

answered Oct 2, 2012 at 18:21

poudigne

1,7664 gold badges18 silver badges43 bronze badges

Comments

Teena Thomas · Accepted Answer · 2012-10-02 18:24:09Z

1

$array = $_POST; as $_POST itself is an array. just in case, you want $array for future use. and access it using foreach() as you have shown. you can use array_values($_POST), if its only values that you're concerned with. so something like,

    $values = array_values($_POST);
    var_dump($values);

answered Oct 2, 2012 at 18:24

Teena Thomas

5,2091 gold badge15 silver badges17 bronze badges

Comments

ForceMan · Accepted Answer · 2012-10-02 18:24:44Z

0

You can used like this for view all variables in $_POST array. print_r($_POST)

answered Oct 2, 2012 at 18:24

ForceMan

251 silver badge8 bronze badges

Collectives™ on Stack Overflow

How to store $_POST data in an array and access it with foreach and save into mysql [duplicate]

4 Answers 4

6 Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

6 Comments

Comments

Comments

Comments

Linked

Related