How to Make Active or Inactive in PHP With Mysql Database

We will Explain How to Make Active or Inactive in PHP With Database.

<?php
mysql_connect('localhost','root','');
mysql_select_db('database');
if(!empty($_GET['status_id'])&&isset($_GET['status_id']))
		{
			$status_id = $_GET['status_id'];
			$status = $_GET['status'];
			$query = "update menus set status = '$status' where id = '$status_id'";
			mysql_query($query);
			header("location:menus.php");
		}
	// Active / De-Active Record
?>
<html>
<head>
<title>Active/Deactive</title>
</head>
<body>
<form method="POST">
<table border="1">
			<?php 
				
				$query = "select * from table";
				$result = mysql_query($query);	
				
				$row = mysql_fetch_assoc($result)
			?>
			
			<tr>	
				
			<th>Items db</th>
				<?php
					$status =  $row['status']; 
					if($status == 1):	
				?>
				<td style="text-align:center;">
					<a href="menus.php?status_id=<?php echo $row['id'];?>&status=0">
						<img src="ok.png" title="Active / Deactivate Record" />
					</a>
				</td>
				<?php else:	?>
				<td style="text-align:center;">
					<a href="menus.php?status_id=<?php echo $row['id'];?>&status=1">
						<img src="cross.png" title="Active / Deactivate Record" />
					</a>
				</td>
				<?php endif; ?>
				</tr>
</table>
</form>
</body>
</hrml>

how to update data in PHP

Read on Facebook

Leave a Reply

Your email address will not be published. Required fields are marked *