Help Web developers Php mysqli

[shestheman]

Pa help naman po kung tama ginawa ko gusto ko kasi mangyari bago ako maka pag Insert sa table na Student_enrolled ay mag match yung email nya dun sa account nya sa table ng Useraccount,, bali di sya makakapag insert pag di nag match yung account email nya sa Useraccount

<?php

if(isset($_POST['enrollstudent'])) {
$studentid = $_POST['studentid'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$myemail = $_POST['email'];

}else{
header("location:./");
}
include '../db_config/connection.php';

$sql = "SELECT * FROM admin_info where email LIKE '$myemail'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {

while($row = $result->fetch_assoc()) {
$student = $row['first_name'];
header("location:my_class.php?msg=Email $myemail does not match any account in database");
}

}
else {
include '../db_config/connection.php';
$class_id = $_GET['ref'];
$sql = "INSERT INTO student_enrolled (userid, student_id, firstname, lastname, email, class_id)
VALUES ('$userid', '$studentid', '$firstname', '$lastname', '$myemail', '$class_id')";

if ($conn->query($sql) === TRUE) {
header("location:my_class.php?ref=$class_id&?message= have been successfully registered");
} else {
$error = $conn->error;
header("location:my_class.php?err=$error");
}
$conn->close();
}
$conn->close();
?>

 

[eugcar]

Pa help naman po kung tama ginawa ko gusto ko kasi mangyari bago ako maka pag Insert sa table na Student_enrolled ay mag match yung email nya dun sa account nya sa table ng Useraccount,, bali di sya makakapag insert pag di nag match yung account email nya sa Useraccount

$sql = "SELECT * FROM admin_info where email LIKE '%".$myemail."%'"

}
else {
include '../db_config/connection.php'; <- hindi mo na kailangan i call pa ito ulit
$class_id = $_GET['ref'];

- - - Updated - - -

<?php
include '../db_config/connection.php';

if(isset($_POST['enrollstudent']))
{
$class_id = $_GET['ref'];
$studentid = $_POST['studentid'];
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$myemail = $_POST['email'];

$sql = "SELECT * FROM admin_info where email LIKE '%".$myemail."%'";
$result = $conn->query($sql);

if ($result->num_rows > 0)
{
while($row = $result->fetch_assoc())
{
$student = $row['first_name'];
header("location:my_class.php?msg=Email $myemail does not match any account in database");
}
}else {
$insert = "INSERT INTO student_enrolled (userid, student_id, firstname, lastname, email, class_id)
VALUES ('".$userid."', '".$studentid."', '".$firstname."', '".$lastname."', '".$myemail."', '".$class_id."')";
$insertQuery = $conn->query($insert);
if($insertQuery)
{
header("location:my_class.php?ref=$class_id&?messa ge= have been successfully registered");
} else {
$error = $conn->error;
header("location:my_class.php?err=$error");
}
}
}else{
header("location:./");
}

$conn->close();
?>

 

[jskhulitz]

kokontrahin na kita sa gagawin mo ha. Bakit like? at bakit %%? kapag naglagay ako ng letter "a" lang, pasok agad yung entry... GL

email like '%a%'

 

[eugcar]

hahaha! yun lang.. di ko alam y like ang natipuhan nya

$sql = "SELECT * FROM admin_info where email = '".$myemail."'";

 

[bdalina54]

pwede naman direct na kaagad yan WHERE `email`='$email'

 

[dfasdf321]

walang basagan ng trip LIKE gusto nya e
anyway para kay ts yung LIKE is to match each character according sa gusto mo hanapin.
kung gusto mo mag match yung email, select mo with equal operator. Like sir eug said.