Jump to content

Archived

This topic is now archived and is closed to further replies.

Gruzin

$_GET is not working

Recommended Posts

hi guys,
I have a form where I use id at the end of the URL, like http://www.mysite.com?link_id=65
so I want to GET this variable for database, on the other page it works ok, but on EDIT page it doesn't get the variable... here is the code, your help will be greatly appreciated.

[code]<?php
$name = nl2br($_POST['webname']); // name inputed in form
$url = nl2br($_POST['weburl']); // URL inputed in form
$weburl = "<a href=".$url.">$url</a>"; //greb the link
$rank = nl2br($_POST['rank']); // page rank inputed in form
$comment = nl2br($_POST['webcom']); // comment inputed in form
if(empty($name)){
  echo "Please Enter Website name";
  exit();
}
$con = mysql_connect("localhost","george","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("george", $con);

$link_id = $_GET['link_id']; // get id for db

$update = "UPDATE link_manager SET name = '$name' WHERE id = '$link_id'";
if(!mysql_query($update,$con))
{
  die('Error:'.mysql_error());
}
header( 'Location: http://www.mysite.net/links/' ) ;
mysql_close($con);
?>[/code]

Share this post


Link to post
Share on other sites
put the link_id in a hidden field on your form, instead of in the querystring. Then it gets POSTed with rest of the form data.

[code]<input type='hidden' name='link_id' value='65'>[/code]

Why all the nl2br() calls? You don't want to store 'br' in db fields, just the raw data

Share this post


Link to post
Share on other sites
Here is my modified code, but it doesn't update a record in db and returns error:

[color=red]Warning: Cannot modify header information - headers already sent by (output started at /home/nycapart/public_html/links/add_edit.php:3) in /home/nycapart/public_html/links/add_edit.php on line 28[/color]

[code]<html>
<body>
<input type='hidden' name='link_id' value='<?php $link_id = $_GET['link_id'];?>'>
<?php
$name = $_POST['webname']; // name inputed in form
$url = $_POST['weburl']; // URL inputed in form
$weburl = "<a href=".$url.">$url</a>"; //greb the link
$rank = $_POST['rank']; // page rank inputed in form
$comment = $_POST['webcom']; // comment inputed in form
if(empty($name)){
  echo "Please Enter Website name";
  exit();
}
$con = mysql_connect("localhost","george","pass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }
mysql_select_db("george", $con);

$link_id = $_GET['link_id']; // get id for db

$update = "UPDATE link_manager SET name = '$name' WHERE id = '$link_id'";
if(!mysql_query($update,$con))
{
  die('Error:'.mysql_error());
}
header( 'Location: http://www.mysite.net/links/' ) ;
mysql_close($con);
?>
</body>
</html>[/code]

Share this post


Link to post
Share on other sites
Read my post again

[quote]put the link_id in a hidden field on your form[/quote]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.