<?php






                                                                                if( !isset($_POST['First_Name']) ){

                                                                                        die("You did not enter a valid first name.");
                                                                                }

                                                                                if( !isset($_POST['Last_Name']) ){

                                                                                        die("You did not set your last name properly.");
                                                                                }

                                                                                if( !isset($_POST['Email']) ){

                                                                                        die("You did not set the email right.");
                                                                                }

                                                                       $email = $_POST['Email'];

if (!filter_var($email, FILTER_VALIDATE_EMAIL) === false) {
  echo("$email is a valid email address");
} else {
  echo("$email is not a valid email address");
}

                                                                                //now connect

                                                                                $servername = "80.82.112.181";
                                        $username = "15095173u2";
                                        $password = "15095173p2";
                                        $dbname = "15095173_music_db";

                                        $conn = new mysqli($servername, $username, $password, $dbname);
                                        if ($conn->connect_error) {
                                             die("Connection failed: " . $conn->connect_error);
                                        }




                                                                                 //sanatize everything

                                                                                 $first= $conn->real_escape_string($_POST['First_Name']);
                                                                                 $last= $conn->real_escape_string($_POST['Last_Name']);
                                                                                 $email= $conn->real_escape_string($_POST['Email']);



                                                                                 //now set up your query.. it should be an insert
                                        $sql = "INSERT INTO customers (First_name, Last_name, Email) VALUES('" . $first . "','" . $last . "','" . $email . "')" ;
                                         echo "Welcome to iSongs: " . $first . " " . $last . ",         ";




                                                                                 //run your query
                                        if( $result = $conn->query($sql) ){
                                                                                                        //successful query
                                                                                } else {
                                                                                        die("query failed");
                                                                                }

                                                                                //were done.
                                                                                die("Thanks for signing up!");

                                                                        ?>