0

i want my code to Prevent fetching data on page refresh

<?php $name=$_POST['name']; ?>
<html>
<body>
<form method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="text" name="name">
<input type="submit" value="GO" name="submit">
</form>
</body>
</html>

<?php
	include ('db.php');
	if(isset($_POST['submit'])) 
	{
	mysql_query ("INSERT INTO example (name) VALUES('$name')") or die(mysql_error());
	}

	if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
	$startrow = 0;
	} 
	else {
	$startrow = (int)$_GET['startrow'];
	}
	
$query = "SELECT * FROM example ORDER BY id DESC LIMIT $startrow, 20"; 
$result = mysql_query($query) or die(mysql_error());

	while($row = mysql_fetch_array($result)){
	echo "<li>";
	echo $row['name'] ." "." <a href= 'like.php?quote=" . urlencode( $row['name'] ) . "'>Click Here</a>";
	echo "</li>";
}
	
	echo '<a href="'.$_SERVER['PHP_SELF'].'?startrow='.($startrow+10).'">Next</a>';
?>

when i am refreshing the page the same data is fetching again which i had posted before refresh.

2
Contributors
1
Reply
2
Views
6 Years
Discussion Span
Last Post by chrishea
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.