🔒 Closed Mysql err

[Netflix]

mga boss ano po kaya ang problema dito? tulong po..

include('dbcon.php');
if (isset ($_POST['submit'])){

    $fname=$_POST['fname'];
    $lname=$_POST['lname'];
    $mname=$_POST['mname'];
    $bd_m=$_POST['bd_m'];
    $bd_d=$_POST['bd_d'];
    $bd_yr=$_POST['bd_yr'];
    $gender=$_POST['gen'];
    $address=$_POST['address'];
    $mnumber=$_POST['mnumber'];
    $email=$_POST['email'];
    $guardian=$_POST['guardian'];
    $guardiancontact=$_POST['guardiancontact'];
    $guardianadd=$_POST['guardianadd'];
    $course=$_POST['course'];
    $YEAR=$_POST['YEAR'];
}
 else{

$query=mysql_query("SELECT * FROM studentdata WHERE fname='$fname' and lname='$lname' ")or die(mysql_error());
$cnt=mysql_num_rows($query);

if ($cnt > 0){ ?>

<script>
    alert('Student Already Exist');
    window.location="Students.php";

</script>
 <?php  }else{
     mysql_query("INSERT INTO studentdata (fname,lname,mname,bd_m,bd_d,bd_yr,gen,address,mnumber,email,guardian,guardiancontact,guardianadd,course,YEAR)
         values ('$fname','$lname','$mname','$bd_m','$bd_d','$bd_yr','gen','address','mnumber','email','guardian','guardiancontact','guardianadd','course','YEAR') ") or die (mysql_error());
?>


  <script> alert ('Student has been added!');
 window.location="Student.php";
 </script>

<?php
}
}


?>

 

[Futility]

ano pong error?

 

[PHC_EUZtaszKIDDEvilDEAThS]

wow..sql..astig
gusto ko rin matuto nyan

 

[Futility]

ts, palitan mo po yung procedure, depreciated na yung mysql, gamit ka either mysqli o PDO,

 

[waze]

yung isang php dun alisin mo para maging:

else{} lang yung middle

 

[waze]

include('dbcon.php');
if (isset ($_POST['submit'])){

$fname=$_POST['fname'];
$lname=$_POST['lname'];
$mname=$_POST['mname'];
$bd_m=$_POST['bd_m'];
$bd_d=$_POST['bd_d'];
$bd_yr=$_POST['bd_yr'];
$gender=$_POST['gen'];
$address=$_POST['address'];
$mnumber=$_POST['mnumber'];
$email=$_POST['email'];
$guardian=$_POST['guardian'];
$guardiancontact=$_POST['guardiancontact'];
$guardianadd=$_POST['guardianadd'];
$course=$_POST['course'];
$YEAR=$_POST['YEAR'];
}
else{

$query=mysql_query("SELECT * FROM studentdata WHERE fname='$fname' and lname='$lname' ")or die(mysql_error());
$cnt=mysql_num_rows($query);

if ($cnt > 0){ ?>

<script>
alert('Student Already Exist');
window.location="Students.php";

</script>
else{
mysql_query("INSERT INTO studentdata (fname,lname,mname,bd_m,bd_d,bd_yr,gen,address,mnumber,email,guardian,guardiancontact,guardianadd,course,YEAR)
values ('$fname','$lname','$mname','$bd_m','$bd_d','$bd_yr','gen','address','mnumber','email','guardian','guardiancontact','guardianadd','course','YEAR') ") or die (mysql_error());


<script> alert ('Student has been added!');
window.location="Student.php";
</script>

<?php
}
}


?>

 

[Netflix]

ts, palitan mo po yung procedure, depreciated na yung mysql, gamit ka either mysqli o PDO,

Hindi ko po na gets..
ayaw gumana code ko :/

 

[Netflix]

bakit po ganyan??

 

[That Poppy]

tama sya depreciated na ang mysql. gumamit ka ng mysqli r PDO