PHP help pls....

[Theekshana vimukthi]

<?php
$name=$_POST["username"];
$email=$_POST["email"];
$password=$_POST["password"];

$con=mysqli_connect("localhost","root","","aaa");
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}


$result=mysqli_query($con,"INSERT INTO students (fname,email,password )
VALUES ('$name', '$email','$password')");



mysqli_close($con);

if ($result == 1){
header("Location:../../view/students/login.php");
}else{
header("Location: ../../view/students/registration.php");
}
?>



mata one db eke email eka already exist nam eka check karala $get use karala html page eke error msg ekak print karanna..danna aya help ekak dennako...

 

[KPZ]

machan mysqli_connect("localhost","root","","aaa"); kiyana eka waradi neda?

mysqli_connect( host, username, password, databasename)
kiyala parameter 4k enna one neda machan?

 

[ilanganthilaka]

$sql = "SELECT * FROM students WHERE email='$email' ";
$que = mysql_query($sql);

if(mysql_num_rows($que)>0){
echo "email already exist ";
}
else{
//run insert query
}

 

[IveyStyle]

machan mysqli_connect("localhost","root","","aaa"); kiyana eka waradi neda?

mysqli_connect( host, username, password, databasename)
kiyala parameter 4k enna one neda machan?

uba niwan dekala kiyala mama nam hithuwe..mahana une nedda tawama

 

[Fox Mulder89]

$sql = "SELECT * FROM students WHERE email='$email' ";
$que = mysql_query($sql);

if(mysql_num_rows($que)>0){
echo "email already exist ";
}
else{
//run insert query
}

oyaa dilaa thiyenne answer eka ela ela

 

[KPZ]

uba niwan dekala kiyala mama nam hithuwe..mahana une nedda tawama

thawa naha ban
gedarin kamaththa denne nahane. gedarin kamaththa nathuwa ganne naha neda machan mahana karanna??

 

[Theekshana vimukthi]

$sql = "SELECT * FROM students WHERE email='$email' ";
$que = mysql_query($sql);

if(mysql_num_rows($que)>0){
echo "email already exist ";
}
else{
//run insert query
}

ela thanks machn..mekata use karanne MVC.etakota me code eka controller eke tyenne.eka view eke tyena registration.php kiyana page ekata pass karanna one $_GET widiyata.eka mata terenne nane.poddak help ekak dennako....