Loop through POST array and update database

Question

I have a PHP page that dynamically generates forms based on the data received from a MySQL database. For example, say there is an entry for the Logo URL, it would be as follows:

configName = MainLogoURL; configValue = "blah";

That's the general idea. The task that I'm struggling with is updating the database, all of the data is sent through a POST request. The end result is like this

Array ( 
       Array ( configName => "MainLogoURL", configValue => "BLAH 2" )
)

And obviously there would be more arrays in that structure for each variable. If there is a more efficient way then could you please let me know (and how to do it) or could you just let me know how to do it.

Have to structured your database table for each of these post values? — Yatin Trivedi, Dec 20 '13 at 14:46
Than you just have to make use of foreach($_POST as $key=>$value) and fetch all the submitted values. — Yatin Trivedi, Dec 20 '13 at 14:48
But how would I make that into one single MySQL query ? I'm trying to make this as efficient as possible. — Brodie, Dec 20 '13 at 14:50
use PDO and prepare statements http://www.php.net/pdo.prepared-statements — ryder, Dec 20 '13 at 14:53
Is there any chance someone can give me an example ? I've never used PDO before, I wouldn't know what to search or where to begin. — Brodie, Dec 20 '13 at 14:54
just for me... after this i can help... you have an post array structured like (in your question) and you would like to update your db with these informations ? — Dwza, Dec 20 '13 at 15:01

score 0 · Answer 1 · edited May 23 '17 at 10:32

0

As Yatin said, foreach($_POST as $key => $value) is a good start.

You should take a look at the MySQL documentation for REPLACE statements. That should allow you to insert multiple values with a single statement.

The PHP manual has PDO examples to get you started, and there are a couple of working PDO multiple insert examples here.

edited May 23 '17 at 10:32

Community

1
1

answered Dec 20 '13 at 15:03

Gustav Bertram

14,591
3
40
65

Dwza · Accepted Answer · 2013-12-20T15:41:44.527

0

just like some people sayed... use pdo, in your case this should look like:

$dbh = new PDO('mysql:host=localhost;dbname=test', 'user', 'pass');
$stmt = $dbh->prepare("INSERT INTO myTable (configName, configValue) VALUES (:name, :value)");
$stmt->bindParam(':name', $name);
$stmt->bindParam(':value', $value);

$myArray = Array ( 
   Array ( "configName" => "MainLogoURL", "configValue" => "BLAH 2" )
)


foreach($myArray as $arr)
{
    $name  = $arr['configName'];
    $value = $arr['configValue'];
    $stmt->execute();
}

posted this because you sayed you want to have a sample :)

edited Dec 20 '13 at 15:41

answered Dec 20 '13 at 15:11

Dwza

6,494
6
41
73

of course if you want to update you have to change the statement :) – Dwza Dec 20 '13 at 15:25
you may have a look at [pdo stored procedur](https://www.google.de/#q=pdo+stored+procedure&safe=off) this looks like you can do some stuff to get it better running... in case there are to many array entrys :) but im still happy that i could help :) – Dwza Dec 20 '13 at 15:43

Loop through POST array and update database

2 Answers2