<?php
session_start();
//include('include/connection.inc.php');
require_once'../include/dbcon.php' ;
$sn = $_POST['sn'] ;
$names = $_POST['names'] ;
$regno =$_POST['regno'] ;
$admyr = $_POST['admyear'] ;
$gen = $_POST['gender'] ;
$dob = $_POST['dob'] ;
$address = $_POST['address'] ;
$deno = $_POST['denomination'] ;
$town = $_POST['town'] ;
$lga = $_POST['lga'] ;
$states = $_POST['states'] ;
$nof = $_POST['nof'] ;
$pof = $_POST['pos'] ;
$phone = $_POST['stphone'] ;
$pvs = $_POST['pvs'] ;
$pvc = $_POST['pvc'] ;
$prc = $_POST['prc'] ;

$insert = $DBcon->prepare("update students set studentname =:a, admyear =:b, gender =:c, dob =:d, address =:e, denomination =:f, town =:g, lga =:h, states =:i, nof =:j, pof =:k, pvs =:l, pvc =:m, prc =:n, stphone =:o,regno =:p where sn =:sn") ;
$insert->bindparam(":a",$names) ;
$insert->bindparam(":b",$admyr) ;
$insert->bindparam(":c",$gen) ;
$insert->bindparam(":d",$dob) ;
$insert->bindparam(":e",$address) ;
$insert->bindparam(":f",$deno) ;
$insert->bindparam(":g",$town) ;
$insert->bindparam(":h",$lga) ;
$insert->bindparam(":i",$states) ;
$insert->bindparam(":j",$nof) ;
$insert->bindparam(":k",$pof) ;
$insert->bindparam(":l",$pvs) ;
$insert->bindparam(":m",$pvc) ;
$insert->bindparam(":n",$prc) ;
$insert->bindparam(":o",$phone) ;
$insert->bindparam(":sn",$sn) ;
$insert->bindparam(":p",$regno) ;
//$insert->bindparam("q",$stphone) ;
if($insert->execute()) header("location: viewregist.php") ;	
//echo $sn ;