PDO execute variable which stores array

Question

The $data variable stores an array containing a username and password, which need to be inserted in a certain table.

$data = array('username' => $username, 'password' => $password);
foreach($data as $key => $value){
   $values = $values . "'" . $value . "'" . ",";
}
$sql = "INSERT INTO table(username, password) VALUES (?, ?)";
$query = $con->prepare($sql);
$query->execute($values);

How can I change this code in such a way that it will print the values of the $values variable into the execute function? E.g. 'Newuser','mysecretpass'

meda · Accepted Answer · 2014-11-18 15:24:09Z

1

You can do it this way:

$data = array('username' => $username, 'password' => $password);
$sql = "INSERT INTO table(username, password) VALUES (:username, :password)";
$query = $con->prepare($sql);
foreach($data as $key => $value){
   $query->bindValue($key, $value);
   #echo 'key = '.$key.' | value = '.$value;
}
$query->execute();

The above binds each value to its placeholder, and if you want to print them you can.

edited Nov 18, 2014 at 15:24

answered Nov 17, 2014 at 19:57

meda

45.5k14 gold badges96 silver badges123 bronze badges

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

1 Comment

meda Over a year ago

@Pat4561 oh I know why , you need to use named placeholder , you see my edit INSERT INTO table(username, password) VALUES (:username, :password)

Asik · Accepted Answer · 2014-11-17 18:04:26Z

0

Try this! Execute a prepared statement by passing an array of insert values.

$sql = "INSERT INTO table(username, password) VALUES (?, ?)";
$query = $con->prepare($sql);  
$query->execute(array($username, $password));

answered Nov 17, 2014 at 18:04

Asik

7,9774 gold badges30 silver badges35 bronze badges

2 Comments

P.Yntema Over a year ago

I already know that way, but the problem is that the array is already stored in the variable $values.

Asik Over a year ago

you mean, you want to assign it from this $data = array('username' => 'Newuser', 'password' => 'mysecretpass');

pbaldauf · Accepted Answer · 2014-11-17 18:05:07Z

0

You can bind the params like

$sql = "INSERT INTO table(username, password) VALUES (:user, :pass)";
$query = $con->prepare($sql);
$query->bindParam(':user', $data['username'] );
$query->bindParam(':pass', $data['password']);
$query->execute();

answered Nov 17, 2014 at 18:05

pbaldauf

1,6812 gold badges26 silver badges35 bronze badges

Collectives™ on Stack Overflow

PDO execute variable which stores array

3 Answers 3

1 Comment

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

2 Comments

Comments

Related