After Submission, Page REdirect

cmccomas

Here's the code:

// generate and execute query

$query = "INSERT INTO archives(month, monthNAME) VALUES('$month', '$monthNAME')";
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

// print result
echo "<font class='text-blog'>Your archive was successfully added and saved to the database. </font>";

What I want to do, instead of echo'ing a link, I'd like it to just redirect to a page, how can I do that?

Kudose

[man]header[/man]("Location: http://www.mywebsite.com");

cmccomas

Thanks.

Got this error:

Warning: Cannot modify header information - headers already sent by (output started at /hsphere/local/home/asdf/domain.com/entry1.php:12) in /hsphere/local/home/asdf/domain.com/entry1.php on line 169

jazappi

just do a print statement like this:

print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.yoursite.com\">");

cmccomas

jazappi,

works great, here's what i need now.

i need the link to be:

http://www.yoursite.com/entry.php?blogID= GET BLOG ID

I tried

print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.christophermccomas.com/<? echo $_GET[\"blogID\"]; ?>\">");

But it didn't work.

Thanks

jazappi

try naming the varible first

$blogid= $_GET['blogid'];

print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.christophermccomas.com/blogid=$blogid\">");

that should work for you

cmccomas

This is what I have and it is not working, for some reason.

<?
						// includes
						include("dbconnex.php");

					// open database connection
					$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

					// select database
					mysql_select_db($db) or die ("Unable to select database!");

					// generate and execute query
					$query = "DELETE FROM comments WHERE commentID = '$commentID'";
					$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

					// close database connection
					mysql_close($connection);

					// print result 
					$blogID = $_GET['blogID']; 
					print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.domain.com/admin/edit_comments.php?blogID=$blogID\">");
					?>

kingbear

what error are you getting?

cmccomas

It redirects, but has the address:

/edit_comments.php?blogID=

And doesn't put the actual blogID at the end like it should.

kingbear

what's the exact URL you are using on this page?

cmccomas

It's password protected.

It is www.christophermccomas.com/admin/edit_comments.php?blogID=

kingbear

The reason I ask is because the URL which gets you to the script below needs to have blogID=10 (or whatever number) somewhere in the URL ... otherwise the $_GET['blogID'] is gonna return nothing.

Originally posted by cmccomas
This is what I have and it is not working, for some reason.

<?
						// includes
						include("dbconnex.php");

					// open database connection
					$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

					// select database
					mysql_select_db($db) or die ("Unable to select database!");

					// generate and execute query
					$query = "DELETE FROM comments WHERE commentID = '$commentID'";
					$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

					// close database connection
					mysql_close($connection);

					// print result 
					$blogID = $_GET['blogID']; 
					print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.domain.com/admin/edit_comments.php?blogID=$blogID\">");
					?>

[/B]

cmccomas

Originally posted by kingbear
The reason I ask is because the URL which gets you to the script below needs to have blogID=10 (or whatever number) somewhere in the URL ... otherwise the $_GET['blogID'] is gonna return nothing.

That's my entire script.

The address that views all the comments is:

http://www.christophermccomas.com/admin/edit_comments.php?blogID=12 (just the number I'm using as an example).

You click on delete and I want it to run the php script and go back to the page above, refreshed.

jazappi

So when you go to the "redirect page" in the URL is the blogid showing up or not?

cmccomas

Originally posted by jazappi
So when you go to the "redirect page" in the URL is the blogid showing up or not?

The blogID is not showing up. I just get blogID=

jazappi

So on the page that leads to redirect is there a form element or something that will contains the blogid? Some how you have to pass that varible to the redirect page.... can you post the code of that page???

cmccomas

<table width="390" border="0" cellspacing="1" cellpadding="2">
						    	<tr>
									<td align="center"><font class="text-blog"><b>DELETE COMMENT</b></font></td>
						  		</tr>
						   		<tr>
									<td align="center">
									<form name="theform" id="theform">
											<input type="hidden" name="blogID"  value="<? echo $_GET["blogID"]; ?>"></form>
									<?
						// includes
						include("dbconnex.php");

					// open database connection
					$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

					// select database
					mysql_select_db($db) or die ("Unable to select database!");

					// generate and execute query
					$query = "DELETE FROM comments WHERE commentID = '$commentID'";
					$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error());

					// close database connection
					mysql_close($connection);

					// print result 
					print ("<META HTTP-EQUIV=\"refresh\" CONTENT=\"0; URL=http://www.christophermccomas.com/admin/edit_comments.php?blogID=$blogID\">");
					?></td>
					  </tr>

				  </table>

jazappi

In your hidden field where is the blogid coming from? Make sure its in the url, again I would do the hidden field like this:

$blogID = $_GET['blogID'];

Thats how I do it not that it is the right or wrong way.

But make sure the varible is being passed to that page.

Sometimes it helps to do a print statement on the page for testing that shows the variable to see if it is there. Example:

print ("Blog ID: $blogID");

cmccomas

Ah ha! Figured out the problem we are having.

The main page where I select to delete the comment is:

edit_comments.php?blogID=

BUT the delete page, with the script to delete from the database is:

delete_comments.php?commentID=

So, the GET blogID doesn't work.

So it's a bit more confusing, but does that help?

jazappi

So did you figure it out or not?