Parse recordID on update

[mrt003003]

Hi im using dream weaver and ive created a form that can be updated:

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE ships SET FleetName=%s, HealthA=%s, HealthB=%s WHERE ShipID=%s",
                       GetSQLValueString($_POST['select'], "text"),
                       GetSQLValueString($_POST['textfield'], "int"),
                       GetSQLValueString($_POST['textfield2'], "int"),
                       GetSQLValueString($_POST['hiddenField'], "int"));

  mysql_select_db($database_swb, $swb);
  $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());

  $updateGoTo = "fleet.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $updateGoTo));
}

 

I want to parse a parameter after its updated and directed to another page but i cant seem to get it to work:

  $updateGoTo = "fleet.php?recordID=$row_Ship['FleetName']";

 

Someone mentioned a http build query would help here:

$qs = $_GET; // copy everything from the URL
$qs["recordID"] = $row_Ship["FleetName"];

header("Location: fleet.php?" . http_build_query($qs));
exit; // important!

 

Thing is im new to php and am not sure how to integrate this query with the exisitng code..

 

Any help would be greatly appreciated.

 

Thank You

[Fadion]

Let's see if I'm getting this right. You have a form that after submitted, updates a row in the database. After that you want to send the user to another PHP file, append to the url a parameter (recordID) and finally use that parameter? If that's the case, those parameters appended to the url are stored in the GET superglobal.

 

In your current file

<?php
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
     $updateSQL = sprintf("UPDATE ships SET FleetName=%s, HealthA=%s, HealthB=%s WHERE ShipID=%s",
                                        GetSQLValueString($_POST['select'], "text"),
                                        GetSQLValueString($_POST['textfield'], "int"),
                                        GetSQLValueString($_POST['textfield2'], "int"),
                                        GetSQLValueString($_POST['hiddenField'], "int"));

     mysql_select_db($database_swb, $swb);
     $Result1 = mysql_query($updateSQL, $swb) or die(mysql_error());
     
     //recordID is the GET parameter in the URL
     if (isset($_GET['recordID'])) {
          header('Location: fleet.php?recordID=' . $_GET['recordID']);
     }
?>

 

In fleet.php

<?php
if (isset($_GET['recordID'])) {
     $id = $_GET['recordID'];
     //make further processing
}
?>

 

Hope that clears it up.

[mrt003003]

Thats solved it, brilliant! Thank you for your help