nn

<?php

$dbhost = "localhost";

$dbuser = "root";

$dbpass = "";

$db = "stud_rank";

$conn = mysqli_connect($dbhost, $dbuser, $dbpass,$db) or die("Connect failed: %s\n". $conn -> error);

// echo "Connected Successfully";

session_start();

// print_r($_SESSION);

$a0= $_SESSION['name'];

$a1 = $_POST['club'];

$a2 = $_POST['desig'];

$a3 = $_POST['st_date'];

$a4 = $_POST['end_date'];

$sql="insert into manage(email,club,desig,sdate,edate)values('$a0','$a1','$a2','$a3','$a4')";

$result = $conn->query($sql);

if($result)

{

// echo "<br>";

// echo "1 record added";

}

else

{

echo mysqli_error($conn);

}

//$uname='kavi3@gmail.com';

$sql1 = "SELECT * FROM manage where email='".$a0."'";

$result = $conn->query($sql1);

$i=0;

$s=0;

$sum=0;

$count=0;

if ($result->num_rows > 0)

{

   // output data of each row

   while($row = $result->fetch_assoc())

   {

       $user=$row["email"];

      $s= $row["desig"];

       $i=$i+1;

       $sum=$sum+$s;

       $count=$count+1;

   }

}

$i=$i*17;

$i=$i+$sum;

// echo $i;

$sql1 = "SELECT * FROM score where email='".$a0."'";

$result = $conn->query($sql1);

if(mysqli_num_rows($result)==0)

{   echo "aaaaaaaa";

   $sql3="insert into score(email,manage)values('$a0','$i')";

   $result1 = $conn->query($sql3);

   if($result1)

   {

   //echo "<br>";

       header("location: manage.php?a=1");

   }

   else

   {

   echo mysqli_error($conn);

   }

}

else{

   $sql3="UPDATE score SET manage='$i' WHERE email='$a0'";

   $result1 = $conn->query($sql3);

   if($result1)

    {

   // echo "<br>";

       header("location: manage.php?a=1");

   }

   else

   {

   echo mysqli_error($conn);

   }

}

?>