contra10 Posted December 30, 2008 Share Posted 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> "; } ?> Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted December 30, 2008 btw sry forr the length of the code Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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 Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted December 30, 2008 Share Posted December 30, 2008 instead of action="<?php echo $_SERVER['PHP_SELF']; ?>" use this: action="http://localhost/groupsio/post.php" Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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> "; } ?> Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted December 30, 2008 Share Posted December 30, 2008 make sure your apache is running and Mysql is running... Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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 Quote Link to comment Share on other sites More sharing options...
dennismonsewicz Posted December 30, 2008 Share Posted December 30, 2008 are you sure MySQL is running? Don't allow MySQL to run as a service. Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted December 30, 2008 yes its runing, but that code isn't working. is there any other way? Quote Link to comment Share on other sites More sharing options...
premiso Posted December 30, 2008 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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 Quote Link to comment Share on other sites More sharing options...
premiso Posted December 30, 2008 Share Posted 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. Quote Link to comment Share on other sites More sharing options...
dMilesFox Posted December 30, 2008 Share Posted December 30, 2008 Same thing for "mysql_select_db()" you are selecting the same DB twice as well Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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> "; } ?> Quote Link to comment Share on other sites More sharing options...
premiso Posted December 30, 2008 Share Posted December 30, 2008 Are you still getting the same error? Or is this resolved? Quote Link to comment Share on other sites More sharing options...
contra10 Posted December 30, 2008 Author Share Posted 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 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.