Gruzin Posted September 3, 2006 Share Posted September 3, 2006 hi guys,I have a form where I use id at the end of the URL, like http://www.mysite.com?link_id=65so 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 formif(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] Quote Link to comment Share on other sites More sharing options...
Barand Posted September 3, 2006 Share Posted September 3, 2006 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 Quote Link to comment Share on other sites More sharing options...
Gruzin Posted September 3, 2006 Author Share Posted September 3, 2006 ok, Thanks Barand, I'll try that... Quote Link to comment Share on other sites More sharing options...
Gruzin Posted September 3, 2006 Author Share Posted September 3, 2006 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 formif(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] Quote Link to comment Share on other sites More sharing options...
Barand Posted September 3, 2006 Share Posted September 3, 2006 Read my post again[quote]put the link_id in a hidden field on your form[/quote] Quote Link to comment Share on other sites More sharing options...
rallokkcaz Posted September 3, 2006 Share Posted September 3, 2006 try setting up an array? Quote Link to comment Share on other sites More sharing options...
Gruzin Posted September 3, 2006 Author Share Posted September 3, 2006 Thanks a lot it works and I'am happy ;D Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.