php add inputs with same name to mysql

Question

I have a form with some generated input fields like theese:

 <input value="March" name="month[March]" type="hidden"> 
<input value="April" name="month[April]" type="hidden"> 
<input value="May" name="month[May]" type="hidden">

I need to add the data from each input to mysql, but i don`t know how if they have name[monthname].The table structure is id, name and month_name. So i need to add the input data to month_name column. Thanks!

Voting to close as too localized. You've got two questions going on here: one about duplicate GET or POST variable names, and one about inserting into MySQL. — David Wolever
– David Wolever, Commented Mar 25, 2012 at 7:12
To expand on Michael and Mayank's comments, sample code is king. If you have a question that concerns databases, include appropriate SQL statements, such as the table schema (as CREATE TABLE statements) and (if appropriate) sample data (as INSERT ... VALUES statements). See Writing the Perfect Question for more. — outis
– outis, Commented Mar 25, 2012 at 7:26
@DavidWolever, What do you think about my answer? Should be enough for such type of question, dont you think? — Starx
– Starx, Commented Mar 25, 2012 at 7:29

Starx · Accepted Answer · 2012-03-25 07:26:16Z

1

You can iterate over different input with same name in this way

foreach($_POST['month'] as $value) {
   echo $value;
   //Use the value in the query, it gets April March may, one by one
}

_{P.S: Assuming you are using POST method to submit the form.}

answered Mar 25, 2012 at 7:26

Starx

79.3k50 gold badges187 silver badges265 bronze badges

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

Comments

Tabrez Ahmed · Accepted Answer · 2012-03-25 07:30:51Z

0

<input value="March" name="month[March]" type="hidden"> 
<input value="April" name="month[April]" type="hidden"> 
<input value="May" name="month[May]" type="hidden">

You can add them separated by commas (or any other delimiter provided it does not create SQL injection). Like

<?php
$months = $_REQUEST['month'];
$sql = "INSERT INTO `YOURTABLE` values ('$id','$name','";
$comma_flag = false;
foreach ($months as $month)
{
    $sql = $sql.($comma_flag?",":"").$month;
    $comma_flag = true;
}
$sql .="');";
$dbc = mysql('localhost','username','password');
mysql_select_db('your_database',$dbc);
mysql_query($sql,$dbc);
?>

Note: The MySQL Column month_name must be varchar of larger size.

Later if you want to retreive, after 'SELECT FROM ... ' you can split it using

$months = explode($result,",");

answered Mar 25, 2012 at 7:30

Tabrez Ahmed

3,0007 gold badges35 silver badges50 bronze badges

1 Comment

outis Over a year ago

The sample code is vulnerable to SQL injection, which is a very serious security risk. Moreover, the mysql extension is outdated and on its way to deprecation. New code should use mysqli or PDO, both of which have important advantages, such as support for prepared statements. Prepared statement parameters aren't vulnerable to injection.

Collectives™ on Stack Overflow

php add inputs with same name to mysql

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related