[RESOLVED] Parse recordID after UPDATE

drax007

Hi there,

I have a form that updates a record in a database...At the moment on Update the user is directed to another page....

Is there a way i can parse the ID value that was just updated to the other page (like a hyperlink, e.g. ?recordID=<?php echo $row_record['ID']; ?>)......Because i need to parse the ID to the other page!

Is this possible??? If so how please??

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "form1")) {
  $updateSQL = sprintf("UPDATE animal SET BreedID=%s, Age=%s, Sex=%s, Image=%s WHERE AnimalID=%s",
                       GetSQLValueString($_POST['select'], "text"),
                       GetSQLValueString($_POST['age'], "int"),
                       GetSQLValueString($_POST['sex'], "text"),

                   GetSQLValueString($_POST['image'], "text"),
                   GetSQLValueString($_POST['AnimalID'], "int"));

  mysql_select_db($database_woodside, $woodside);
  $Result1 = mysql_query($updateSQL, $woodside) or die(mysql_error());

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

Thanks 🙂

ucffool

$updateGoTo .= '&' . $_POST['AnimalID'];

like that?

drax007

Hi there,

Thanks for the reply! I tried what you suggested and cant see it working Yet ...

Tested it and in the browser address: view_animal_details.php?&53....

Im sorry if im being really stupid, but normally when i parse a hyperlink parameter the browser says view_animal_details.php?recordID=53

and the recordset on the following page has been set to =recordID parameter....

I know its close to working, but just out of reach...

Would could i to get it to parse properly??

Thank You very much 🙂

ucffool

$updateGoTo = "view_animal_details.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
    $updateGoTo .= '&' . $_POST['AnimalID'];
   }else{
    $updateGoTo .= '?' . $_POST['AnimalID'];
  }

Now, I'm resisting the urge to throw out the above code and just make use of http_build_query(), but hey, it will work. 🙂

drax007

Hi there,

Yes!!! 🙂

Thats brilliant, thank you!

I have pondered on this situation for some time on various different projects and always wodered if it was possible and how to do it!

Thank you very much indeed, Its totally made my morning!!

🙂

drax007

Hi there,

Im sorry to post again on this thread, but i must be going mad! I tested it last night and it worked!! Cant beleive that it isnt any more?????

the recordID is not parsed because there are no records brought on the the 2nd page??? Oh man what the hells going on?? 🙁

The browser address says:http://localhost/woodside/view_animal_details.php?&55 Thats the sme as it was in the first place when i had only:

$updateGoTo .= '&' . $_POST['AnimalID'];

The code im using is:

$updateGoTo = "view_animal_details.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
    $updateGoTo .= '&' . $_POST['AnimalID'];
   }else{
    $updateGoTo .= '?' . $_POST['AnimalID'];
  }

Im so sure it was working fine last night.....I pretty sure i have not made any other changes to that page too.

What am i missing??? please help im going mad!

Thanks

drax007

Hi there,

Ok I managed to get it to work again but quite differently??

I manually added recordID and removed the & [AnimalID]...

 
  $updateGoTo = "view_animal_details.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";
    $updateGoTo .= $_SERVER['QUERY_STRING'];
 $updateGoTo .= 'recordID=' . $_POST['AnimalID'];

It works now....Hope this insnt going to open a can of worms form me later??

Thanks 🙂