CODEWITHSUNDEEP
phpmysqlhtml
Masroor_Shah
Masroor_Shah

Reputation: 313

Updating Data in Mysql through php on a current page

Hey All i have an issue while updating a data in MYSQL from front end php when i click once it update data when i click again without any change it again update and bring previous data. I am beginner to php and do not know what is the problem as code have no error and no warning please help and guide thanks and appreciation for your time in Advance

My code is

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Update in PHP</title>
</head>
<body>


<?php
		$servername="localhost";
		$username="root";
		$password="";
		$conn=mysql_connect($servername,$username,$password);
	 
	if(!$conn ) {
     		die('Could not connect: ' . mysql_error());
	}

		$sq1 = 'select * from biodata';
		mysql_select_db('firstdb');
		$display=mysql_query($sq1,$conn);

	if(!$display ) {
	
				die('Could not get data: ' . mysql_error());
				exit;
	}

	if (mysql_num_rows($display) == 0) {
				echo "No rows found, nothing to print so am exiting";
				exit;
	}
?>
 

<table border="2" style= "background-color: #84ed86; color: #761a9b; margin: 0 auto;" >
      <thead>
        <tr>
          <th>ID</th>
          <th>Fname</th>
          <th>Lname</th>
          <th>Email</th>
          <th>Phone</th>
          <th>Message</th>
		  <th>Update</th>
        </tr>
      </thead>
      <tbody>
<?php
          while( $row = mysql_fetch_assoc( $display ) ){
            echo
            "<form method= 'post' />
				<tr>
					  <td><input name='UID' value='{$row['ID']}' /></td>
					  <td><input name='upfname' value='{$row['fname']}' /></td>
					  <td><input name='uplname' value='{$row['lname']}' /></td>
					  <td><input name='upemail' value='{$row['email']}' /></td>
					  <td><input name='upphone' value='{$row['phone']}' /></td>
					  <td><input name='upmessage' value='{$row['message']}' /></td> 
					  <td><input type='Submit' name='update' value='Update' id='".$row["ID"]."' </td> 
			 	</tr>
			 </form>";
         	}
?>
      </tbody>
</table>
<?php
		if(isset($_REQUEST['update']))
		{
			
			$id   = $_REQUEST['UID'];
		 	$upfn = $_REQUEST['upfname'];
			$upln = $_REQUEST['uplname'];
		        $upem = $_REQUEST['upemail'];
			$upph = $_REQUEST['upphone'];
			$upms = $_REQUEST['upmessage'];
			
			$up="UPDATE biodata 
			SET
			fname='$upfn',
			lname='$upln',
			email='$upem',
			phone='$upph',
			message='$upms' 
			WHERE ID = $id";
			$updbb=mysql_query($up,$conn);
			
			

	  
	  }
?>
			
</body>
</html>

Upvotes: 0

Views: 75

Answers (1)

user6773019
user6773019

Reputation:

redirect the same page

header('Location: url'); like header('Location: inbox.php?u='.$log_username.'');

Upvotes: 1

Related Questions