insert array data into mysql using PDO

Question

i have this array with data from a html form, and i want this array to be inserted into PHP function that handles the INSERT query into mysql.

how can i declare my array into PDO

   if (isset($_POST['submit'])); {
    $_POST['name'];
    $_POST['age'];


$myarray= array();
foreach ($_POST as $key => $value){
   $myarray[$key] = $value;
}

whatever($myarray);

}

functions whatever($myarray) {
    $sql=$db->prepare("INSERT INTO `user`(`name`, `age`) VALUES (:name,:age)");

    foreach($myarray as $row=>$value){
     $sql->bindValue(array($myarray)){
    }
    $sql->execute();
}

apology for forgetting the error.

this is what i get

    Warning: PDOStatement::bindValue() expects at least 2 parameters, 1 given in C:\Web\xampp\htdocs\submit.php on line 36

    Warning: PDOStatement::bindValue() expects at least 2 parameters, 1 given in C:\Web\xampp\htdocs\submit.php on line 36

    Warning: PDOStatement::bindValue() expects at least 2 parameters, 1 given in C:\Web\xampp\htdocs\submit.php on line 36

    Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: no parameters were bound' in 
C:\Web\xampp\htdocs\submit.php:38 Stack trace: #0 
C:\Web\xampp\htdocs\submit.php(38): PDOStatement->execute() #1 
C:\Web\xampp\htdocs\submit.php(12): register(Array) #2 {main} thrown in 
C:\Web\xampp\htdocs\submit.php on line 38

Take a look This Answer

David
– David

2013-11-06 14:58:22 +00:00
Commented Nov 6, 2013 at 14:58 — David
– David, Commented Nov 6, 2013 at 14:58
Okay. So what exactly is the problem here?

Ja͢ck
– Ja͢ck

2013-11-06 14:58:41 +00:00
Commented Nov 6, 2013 at 14:58 — Ja͢ck
– Ja͢ck, Commented Nov 6, 2013 at 14:58
What error message do you get?

TiMESPLiNTER
– TiMESPLiNTER

2013-11-06 14:59:13 +00:00
Commented Nov 6, 2013 at 14:59 — TiMESPLiNTER
– TiMESPLiNTER, Commented Nov 6, 2013 at 14:59

Your Common Sense · Accepted Answer · 2013-11-06 14:59:17Z

1

function pdoSet($fields, &$values, $source = array()) {
  $set = '';
  $values = array();
  if (!$source) $source = &$_POST;
  foreach ($fields as $field) {
    if (isset($source[$field])) {
      $set.="`".str_replace("`","``",$field)."`". "=:$field, ";
      $values[$field] = $source[$field];
    }
  }
  return substr($set, 0, -2); 
}

This function will produce a correct sequence for the SET operator,

`field1`=:field1,`field2`=:field2

to be inserted into query and store avtual data values in $values array for execute().

$fields = array('id','name','age','loc'); // allowed fields
$sql = "INSERT INTO `user` SET".pdoSet($fields,$values);
$stm = $dbh->prepare($sql);
$stm->execute($values);

answered Nov 6, 2013 at 14:59

Your Common Sense

158k42 gold badges226 silver badges373 bronze badges

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

Collectives™ on Stack Overflow

insert array data into mysql using PDO

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related