[SOLVED] i keep getting redirected to another post

contra10 · December 30, 2008

hi i keep getting redirected to another post when i click submit

and the values are entered in the other post. however if i click back in the browser and refresh the page the value is entered into that post

when i click into the group i get a usrl such as

http://localhost/groupsio/post.php?id=2

when i click on post i get a url such as

http://localhost/groupsio/post.php

heres my code

<?php

mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert1= "SELECT * FROM groups WHERE id = '$id'";
$topic1 = mysql_query($insert1) or die(mysql_error());

while ($topica = mysql_fetch_assoc($topic1))
{
$grpname= "{$topica['name']}";
}
}

//This code runs if the form has been submitted
if (isset($_POST['post'])) { 

//This makes sure they did not leave any fields blank
if (!$_POST['userpost']){
die('You did not complete all of the required fields');
}

$query2= "SELECT id FROM users WHERE username = '$username'";
$result2 = mysql_query($query2) or die(mysql_error());
$usera = mysql_fetch_assoc($result2);
$userid = "{$usera['id']}";

$userpost = mysql_real_escape_string($_POST['userpost']);
$grpnamea = mysql_real_escape_string($_POST['grpname']);
$ida = mysql_real_escape_string($_POST['grpid']);

//This gets today's date 
$date = time () ; 


//This puts the day, month, and year in seperate variables 
$day = date('d', $date) ; 
$month = date('F', $date) ; 
$year = date('Y', $date) ;

// now we insert it into the database
$insert = "INSERT INTO post_grp (grpid, grpname, userid, username, grppost, month, day, year)
VALUES ('$ida', '$grpnamea', '$userid', '$username', '$userpost', '$month', '$day', '$year')";
$add_group = mysql_query($insert) or die(mysql_error());	

?>

<?php echo($grpname);?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
else
{
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
?>

<?php
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert3= "SELECT * FROM post_grp WHERE grpid = '$id' ORDER BY pgid DESC";
$topic3 = mysql_query($insert3) or die(mysql_error());


}
//This checks to see if there is a page number. If not, it will set it to page 1 
if (!isset($pagenum)) 
{ 
$pagenum = (isset($_GET['pagenum'])) ? $_GET['pagenum'] : 1; 
} 

//Here we count the number of results 
//Edit $data to be your query 
$data = mysql_query("SELECT * FROM post_grp WHERE grpid = '$id' ORDER BY pgid DESC") or die(mysql_error()); 
$rows = mysql_num_rows($data); 

//This is the number of results displayed per page 
$page_rows = 4; 

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows); 

//this makes sure the page number isn't below one, or more than our maximum pages 
if ($pagenum < 1) 
{ 
$pagenum = 1; 
} 
elseif ($pagenum > $last) 
{ 
$pagenum = $last; 
} 

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; 

//This is your query again, the same one... the only difference is we add $max into it
$data_p = mysql_query("SELECT * FROM post_grp WHERE grpid = '$id' ORDER BY pgid DESC $max") or die(mysql_error()); 

//This is where you display your query results
while($info = mysql_fetch_array( $data_p )) 
{ 
$userpost= "{$info['grppost']}";
$username= "{$info['username']}";
$usermonth= "{$info['month']}";
	$userday= "{$info['day']}";
	$useryear= "{$info['year']}";

echo "<table border='1' align='center'>";
echo "<tr>";
	echo"<td width= '500' align='center'> $userpost</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right'>Posted by $username on $usermonth, $userday $useryear</td>";
echo "<tr>"; 
echo"</table>";
} 
echo "<p>";

// This shows the user what page they are on, and the total number of pages
echo " --Page $pagenum of $last-- <p>";

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
if ($pagenum == 1) 
{
} 
else 
{
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$previous'> <-Previous</a> ";
} 

//just a spacer
echo " ---- ";

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last) 
{
} 
else {

$next = $pagenum+1;
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$last'>Last ->></a> ";
} 

?>

contra10 · December 30, 2008

btw sry forr the length of the code

contra10 · December 30, 2008

is there a way to stop the redirection

from example

http://localhost/groupsio/post.php?id=2
to
http://localhost/groupsio/post.php

dennismonsewicz · December 30, 2008

instead of

action="<?php echo $_SERVER['PHP_SELF']; ?>"

use this:

action="http://localhost/groupsio/post.php"

contra10 · December 30, 2008

i thought this would work but apparently i get a connection error

<?php
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error()); 

if(is_numeric($_GET['id'])){
$id = $_GET['id'];

  $insert1= "SELECT * FROM groups WHERE id = '$id'";
$topic1 = mysql_query($insert1) or die(mysql_error());
while ($topica = mysql_fetch_assoc($topic1))
{
$grpname= "{$topica['name']}";
}
}

?>

<?php

mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert1= "SELECT * FROM groups WHERE id = '$id'";
$topic1 = mysql_query($insert1) or die(mysql_error());

while ($topica = mysql_fetch_assoc($topic1))
{
$grpname= "{$topica['name']}";
}
}

//This code runs if the form has been submitted
if (isset($_POST['post'])) { 

//This makes sure they did not leave any fields blank
if (!$_POST['userpost']){
die('You did not complete all of the required fields');
}

$query2= "SELECT id FROM users WHERE username = '$username'";
$result2 = mysql_query($query2) or die(mysql_error());
$usera = mysql_fetch_assoc($result2);
$userid = "{$usera['id']}";

$userpost = mysql_real_escape_string($_POST['userpost']);
$grpnamea = mysql_real_escape_string($_POST['grpname']);
$ida = mysql_real_escape_string($_POST['grpid']);

//This gets today's date 
$date = time () ; 


//This puts the day, month, and year in seperate variables 
$day = date('d', $date) ; 
$month = date('F', $date) ; 
$year = date('Y', $date) ;

// now we insert it into the database
$insert = "INSERT INTO post_grp (grpid, grpname, userid, username, grppost, month, day, year)
VALUES ('$ida', '$grpnamea', '$userid', '$username', '$userpost', '$month', '$day', '$year')";
$add_group = mysql_query($insert) or die(mysql_error());	

?>

<?php echo($grpname);?>

<form action=<?php header ( "Location: http://localhost/groupsio/post.php?id=$ida" ) ;?> method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
else
{
?>

<form action=<?php header ( "Location: http://localhost/groupsio/post.php?id=$ida" ) ;?> method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
?>

<?php
mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert3= "SELECT * FROM post_grp WHERE grpid = '$ida' ORDER BY pgid DESC";
$topic3 = mysql_query($insert3) or die(mysql_error());


}
//This checks to see if there is a page number. If not, it will set it to page 1 
if (!isset($pagenum)) 
{ 
$pagenum = (isset($_GET['pagenum'])) ? $_GET['pagenum'] : 1; 
} 

//Here we count the number of results 
//Edit $data to be your query 
$data = mysql_query("SELECT * FROM post_grp WHERE grpid = '$ida' ORDER BY pgid DESC") or die(mysql_error()); 
$rows = mysql_num_rows($data); 

//This is the number of results displayed per page 
$page_rows = 4; 

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows); 

//this makes sure the page number isn't below one, or more than our maximum pages 
if ($pagenum < 1) 
{ 
$pagenum = 1; 
} 
elseif ($pagenum > $last) 
{ 
$pagenum = $last; 
} 

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; 

//This is your query again, the same one... the only difference is we add $max into it
$data_p = "SELECT * FROM post_grp WHERE grpname = '$grpname' ORDER BY pgid DESC $max";
$posts = mysql_query($data_p) or die(mysql_error()); 

//This is where you display your query results
while($info = mysql_fetch_array($posts)) 
{ 
$userpost= "{$info['grppost']}";
$username= "{$info['username']}";
$usermonth= "{$info['month']}";
	$userday= "{$info['day']}";
	$useryear= "{$info['year']}";

echo "<table border='1' align='center'>";
echo "<tr>";
	echo"<td width= '500' align='center'> $userpost</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right'>Posted by $username on $usermonth, $userday $useryear</td>";
echo "<tr>"; 
echo"</table>";
} 
echo "<p>";

// This shows the user what page they are on, and the total number of pages
echo " --Page $pagenum of $last-- <p>";

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
if ($pagenum == 1) 
{
} 
else 
{
echo " <a href= 'http://localhost/groupsio/post.php?id=$ida?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='http://localhost/groupsio/post.php?id=$ida?pagenum=$previous'> <-Previous</a> ";
} 

//just a spacer
echo " ---- ";

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last) 
{
} 
else {

$next = $pagenum+1;
echo " <a href='http://localhost/groupsio/post.php?id=$ida?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='http://localhost/groupsio/post.php?id=$ida?pagenum=$last'>Last ->></a> ";
} 

?>

dennismonsewicz · December 30, 2008

make sure your apache is running and Mysql is running...

contra10 · December 30, 2008

my wamp server is running, when i change the code back to the first one stated it runs, but when i change it i get


mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10048)

even after i restart the connection

dennismonsewicz · December 30, 2008

are you sure MySQL is running? Don't allow MySQL to run as a service.

contra10 · December 30, 2008

yes its runing, but that code isn't working. is there any other way?

premiso · December 30, 2008

yes its runing, but that code isn't working. is there any other way?

It is running and yet you get that error?

In my opinion, something is screwed up on your server. I would uninstall WAMP and reinstall it and see if that fixes it. Before you do that besure to backup the webserver files and the database.

contra10 · December 30, 2008

i guess i should, but the server was workking fine until i entered that code, everything else connect on my other pages and all runs smoothly

premiso · December 30, 2008

Well you are doing mysql_connect twice. I would remove the second one as that is not needed once a connection is established.

dMilesFox · December 30, 2008

Same thing for "mysql_select_db()" you are selecting the same DB twice as well

contra10 · December 30, 2008

updated

<?php

mysql_connect("localhost", "root", "") or die(mysql_error()); 
mysql_select_db("registration") or die(mysql_error());

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert1= "SELECT * FROM groups WHERE id = '$id'";
$topic1 = mysql_query($insert1) or die(mysql_error());

while ($topica = mysql_fetch_assoc($topic1))
{
$grpname= "{$topica['name']}";
}
}

//This code runs if the form has been submitted
if (isset($_POST['post'])) { 

//This makes sure they did not leave any fields blank
if (!$_POST['userpost']){
die('You did not complete all of the required fields');
}


$query2= "SELECT id FROM users WHERE username = '$username'";
$result2 = mysql_query($query2) or die(mysql_error());
$usera = mysql_fetch_assoc($result2);
$userid = "{$usera['id']}";

$userpost = mysql_real_escape_string($_POST['userpost']);
$grpnamea = mysql_real_escape_string($_POST['grpname']);
$ida = mysql_real_escape_string($_POST['grpid']);

//This gets today's date 
$date = time () ; 


//This puts the day, month, and year in seperate variables 
$day = date('d', $date) ; 
$month = date('F', $date) ; 
$year = date('Y', $date) ;

// now we insert it into the database
$insert = "INSERT INTO post_grp (grpid, grpname, userid, username, grppost, month, day, year)
VALUES ('$ida', '$grpnamea', '$userid', '$username', '$userpost', '$month', '$day', '$year')";
$add_group = mysql_query($insert) or die(mysql_error());	

?>

<?php echo($grpname);?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
else
{
?>

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<table border="0" width="800" align="center" height="100">
<tr>
<td align="center"><textarea name="userpost" type="description" cols="50" rows="5" maxlength="10" STYLE="color: #FFFFFF; font-family: Verdana; font-weight: bold; font-size: 12px; background-color: #72A4D2;"></textarea></td></tr>
<tr><td><?php echo "<input type='hidden' name='grpname' value='$grpname'>";?></tr></td>
<tr><td><?php echo "<input type='hidden' name='grpid' value='$id'>";?></td>
</tr>
<tr><td align="center"><input type="submit" name="post" value="Post"></td></tr>
</table>
</form>

<?php
}
?>

<?php

if(is_numeric($_GET['id'])){

$id = $_GET['id'];

  $insert3= "SELECT * FROM post_grp WHERE grpid = '$ida' ORDER BY pgid DESC";
$topic3 = mysql_query($insert3) or die(mysql_error());


}
//This checks to see if there is a page number. If not, it will set it to page 1 
if (!isset($pagenum)) 
{ 
$pagenum = (isset($_GET['pagenum'])) ? $_GET['pagenum'] : 1; 
} 

//Here we count the number of results 
//Edit $data to be your query 
$data = mysql_query("SELECT * FROM post_grp WHERE grpid = '$ida' ORDER BY pgid DESC") or die(mysql_error()); 
$rows = mysql_num_rows($data); 

//This is the number of results displayed per page 
$page_rows = 4; 

//This tells us the page number of our last page 
$last = ceil($rows/$page_rows); 

//this makes sure the page number isn't below one, or more than our maximum pages 
if ($pagenum < 1) 
{ 
$pagenum = 1; 
} 
elseif ($pagenum > $last) 
{ 
$pagenum = $last; 
} 

//This sets the range to display in our query 
$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows; 

//This is your query again, the same one... the only difference is we add $max into it
$data_p = "SELECT * FROM post_grp WHERE grpname = '$grpname' ORDER BY pgid DESC $max";
$posts = mysql_query($data_p) or die(mysql_error()); 

//This is where you display your query results
while($info = mysql_fetch_array($posts)) 
{ 
$userpost= "{$info['grppost']}";
$username= "{$info['username']}";
$usermonth= "{$info['month']}";
	$userday= "{$info['day']}";
	$useryear= "{$info['year']}";

echo "<table border='1' align='center'>";
echo "<tr>";
	echo"<td width= '500' align='center'> $userpost</td>";
echo "</tr>";
echo "<tr>";
echo "<td align='right'>Posted by $username on $usermonth, $userday $useryear</td>";
echo "<tr>"; 
echo"</table>";
} 
echo "<p>";

// This shows the user what page they are on, and the total number of pages
echo " --Page $pagenum of $last-- <p>";

// First we check if we are on page one. If we are then we don't need a link to the previous page or the first page so we do nothing. If we aren't then we generate links to the first page, and to the previous page.
if ($pagenum == 1) 
{
} 
else 
{
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=1'> <<-First</a> ";
echo " ";
$previous = $pagenum-1;
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$previous'> <-Previous</a> ";
} 

//just a spacer
echo " ---- ";

//This does the same as above, only checking if we are on the last page, and then generating the Next and Last links
if ($pagenum == $last) 
{
} 

else {

$next = $pagenum+1;
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$next'>Next -></a> ";
echo " ";
echo " <a href='http://localhost/groupsio/post.php?id=$id?pagenum=$last'>Last ->></a> ";
} 

?>

premiso · December 30, 2008

Are you still getting the same error? Or is this resolved?

contra10 · December 30, 2008

i get no errors with this code, but i keep getting directed to

http://localhost/groupsio/post.php

where it echos all the post from every group not specific to this group

Sign In

[SOLVED] i keep getting redirected to another post

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information