search

vinaysreddy / Wedz-Group-9

2 stars 0 forks source link

commit:contact and users communicate to db scripts #51

Closed Aravindac01 closed 10 months ago

Aravindac01 commented 10 months ago 
$name = mysqli_real_escape_string($conn, $_POST['name']);
$email = mysqli_real_escape_string($conn, $_POST['email']);
$number = mysqli_real_escape_string($conn, $_POST['number']);
$msg = mysqli_real_escape_string($conn, $_POST['message']);

$select_message = mysqli_query($conn, "SELECT * FROM `message` WHERE name = '$name' AND email = '$email' AND number = '$number' AND message = '$msg'") or die('query failed');

if(mysqli_num_rows($select_message) > 0){
    $message[] = 'message sent already!';
}else{
    mysqli_query($conn, "INSERT INTO `message`(user_id, name, email, number, message) VALUES('$user_id', '$name', '$email', '$number', '$msg')") or die('query failed');
    $message[] = 'message sent successfully!';
}

}