php - Trying to Automate/Loop a Save Function -

edit: difference between pages $q1, $q2, $q3 becomes, example, $q13, $q14, $q15 - questions in form.

hi all,

i have following code:

$rguid = $_post["r"]; $ip=substr($_server['remote_addr'], 0, 50); $browser=substr($_server['http_user_agent'], 0, 255);     $q1 = $_post["q1"]; $q2 = $_post["q2"]; $q3 = $_post["q3"]; $q4 = $_post["q4"]; $q5 = $_post["q5"]; $q6 = $_post["q6"]; $q7 = $_post["q7"]; $q8 = $_post["q8"];  $respondent_id = decode_respondent_guid($rguid); $rcount=respondent_status($respondent_id);  if ($rcount==0) {      $proc = mysqli_prepare($link, "insert tresults (respondent_id, ip, browser, q1, q2, q3, q4, q5, q6, q7, q8) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);");     mysqli_stmt_bind_param($proc, "issiiiiiiii", $respondent_id, $ip, $browser, $q1, $q2, $q3, $q4, $q5, $q6, $q7, $q8);     mysqli_stmt_execute($proc);     $mysql_error = mysqli_error($link);     if ($mysql_error!="") {         printf("unexpected database error: %s\n", $mysql_error);         mysqli_stmt_close($proc);         mysqli_clean_connection($link);         exit();     } else     {         mysqli_stmt_close($proc);         mysqli_clean_connection($link);         update_completion_status($respondent_id, 'started');         header("location: page2.php?r=".$rguid);     } } 

this code works treat - no problem.

at moment, code appears on 'save' page relates 'form' page (i.e. if have 5 .php pages form on each, need 5 save.php pages save each pages data database) save data sql database. have single save.php page work many 'form' pages have. instead of manually having setup , change each save page, automates it.

i've no idea of coding this, though suspect foreach or loop etc.

any suggestions?

thanks,

homer.

you can set "action" of form on each of 5 form pages same "save" page. have aware of each save page doing might different rest, , generalize. instance, @ end of script redirecting particular page (page2.php). if save #1 supposed go different page, have pass in script (from form) enough information determine redirect should go.