Untitled

filename: exer4.php

<?php
	$action=$_GET['action'];
	$id=$_GET['id'];
	$db=mysqli_connect('localhost', 'root', '', 'exer4');

	if($action=='delete'){
		$sql="DELETE FROM user_reg WHERE id=".$id;
	}else{
		$username=$_POST['username'];
		$password=$_POST['password'];
		$gender=$_POST['gender'];
		$source=$_POST['source'];
		$list=isset($_POST['list']);

		if($action =='edit'){
			$sql="UPDATE user_reg SET
			username='$username',
			password='$password'
			gender='$gender',
			source='$source',
			list='$list'
			WHERE id=".$id;
		}
		else{
			$sql="INSERT INTO user_reg(username, password, gender, source, list)
		VALUES('$username','$password','$gender','$source','$list')";
		}
	}
	mysqli_query($db, $sql);
	header('Location:exer4s.php');
?>


filename: exer4s.php
<html>
	<head><title>CS321 Exercise 2</title></head>
		<body>
			<?php
				$labels=array('Id', 'Username', 'Password', 'Gender', 'Source', 'List', 'Action');
			?>
		<table border="1">
		<?php
			foreach($labels as $label){?>
			<th>
				<?php echo $label?>
			</th>
		<?php } ?>
		<?php
			$ctr=1;
			$db=mysqli_connect('localhost', 'root', '', 'exer4');
			$sql="SELECT * FROM user_reg";
			$result=mysqli_query($db, $sql);
			while($row=mysqli_fetch_array($result)){?>
				<tr>
					<td><?php echo $ctr++ ?></td>
					<td><?php echo $row['username']?></td>
					<td><?php echo $row['password']?></td>
					<td><?php echo $row['gender']?></td>
					<td><?php echo $row['source']?></td>
					<td><?php echo $row['list']?></td>
					<td><a href="exer4_view.php?action=edit&id=<?php echo $row['id']?>">Edit</a>|
						<a href="exer4.php?action=delete&id=<?php echo $row['id']?>">Delete</a></td>
				</tr>
			<?php } ?>
	</table>
		<a href="exer4_view.php?action=add&id=new">New</a>
	</body>
</html>