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] Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/ 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 Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85074 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... Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85106 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] Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85115 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] Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85139 Share on other sites More sharing options...
rallokkcaz Posted September 3, 2006 Share Posted September 3, 2006 try setting up an array? Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85146 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 Link to comment https://forums.phpfreaks.com/topic/19559-_get-is-not-working/#findComment-85150 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.