sports-arena-website / update_member.php
update_member.php
Raw
<?php
//For security purpose
session_start();
// if don't have session user..then
if(! isset($_SESSION['memname']))
{
session_write_close();
die("<script>alert('Please login first before proceed!');window.location.href='login.html';</script>");
}



	include "conn.php";

	$id = $_POST['id'];
	$name = $_POST['memname'];
	$address = $_POST['address'];
	$email = $_POST['email'];
	$phone = $_POST['phone'];


	$sql = "UPDATE member SET ".
	"Mem_Name = '$name',".
	"Mem_Phone = '$phone',".
	"Mem_Email = '$email',".
	"Mem_Address = '$address' WHERE Mem_ID = $id";

	mysqli_query($conn, $sql);
	if(mysqli_affected_rows($conn)<=0)
	{
		echo ("<script>alert('Unable to update data!');</script>");
		die ("<script>window.history.go(-1);</script>")	;
	}
	mysqli_close($conn);
	echo "<script>alert('Info updated successfully!');</script>";
	echo "<script>window.location.href='member_profile.php';</script>";

?>