PHP Variable variables when saving to database

Question

I have a save.php page that is being called using Ajax, it contains the following elements:

$q1 = $_POST["q1"];
$q2 = $_POST["q2"];
$q3 = $_POST["q3"];
$q4 = $_POST["q4"];
$q5 = $_POST["q5"];

$proc = mysqli_prepare($link, "INSERT INTO tresults 
(respondent_id, ip, browser, company, q1, q2, q3, q4, q5) 
VALUES (?, ?, ?, ?, ?, ?, ?, ?);");

mysqli_stmt_bind_param($proc, "issiiiii", 
$respondent_id, $ip, $browser, $company, 
$q1, $q2, $q3, $q4, $q5);

At the moment, the save.php page is manually coded but I am sure there must be a way of using variable variables to automate this page to a degree, especially when the number of fields exceeds 100 that I am saving to the database.

I am, however, having trouble getting my head around using variable variables and could use some guidance.

I am have, to no avail, tried the following:

for ($i = 1; $i <= 5; $i++) {
    echo '$q.$i = $_POST["q".$i];';
}

and also

for ($i = 1; $i <= 5; $i++) {
   $q.$i = $_POST["q".$i];
}

Any and all advice welcomed.

Thanks.

$var = "q$i"; $$var = $_POST[$var];. But seriously, look into naming your form fields better. — cHao
– cHao, Commented May 15, 2014 at 4:55
Even if you do this, I guess there will be a scope issue since they are being declared inside the loop, I suggest you name your fields as q[] that way the system auto-indexes your fields and you can loop through them easy. — AyB
– AyB, Commented May 15, 2014 at 4:56
@Homer_J Have a look at this answer. It's using a checkbox but the same can be implemented for any other input/select. — AyB
– AyB, Commented May 15, 2014 at 5:29

sh03 · Accepted Answer · 2014-05-15 05:17:56Z

2

You can use:

${'q'.$i} = $_POST['q'.$i];

Also:

for ($i = 1; $i <= 5; $i++) {
    echo '$q.$i = $_POST["q".$i];';
}

should be:

for ($i = 1; $i <= 5; $i++) {
    echo "$q.$i = $_POST['q'.$i];";
    //   ^                       ^
}

otherwise variables won't be interpolated within the string.

edited May 15, 2014 at 5:17

answered May 15, 2014 at 4:54

sh03

76.5k39 gold badges177 silver badges282 bronze badges

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

Comments

Jenz · Accepted Answer · 2014-05-15 05:00:45Z

0

Wrap them in {} like

for ($i = 1; $i <= 5; $i++) {
${'q'.$i}=$_POST['q'.$i];
}

Please got through this once for reference http://www.php.net/manual/en/language.variables.variable.php

edited May 15, 2014 at 5:00

answered May 15, 2014 at 4:55

Jenz

8,3718 gold badges50 silver badges83 bronze badges

1 Comment

Jenz Over a year ago

@Jefffrey..sorry I didn't see your answer while I was posting this.

Collectives™ on Stack Overflow

PHP Variable variables when saving to database

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related