<?php

error_reporting(E_ERROR | E_WARNING | E_PARSE | E_NOTICE);
ini_set('display_errors' , 1);
include (  "account.php"     ) ;
$db = mysqli_connect($hostname, $user, $pass, $project);
if (mysqli_connect_errno())
  {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      exit();
  }
mysqli_select_db($db, $project);
print "Successfully connected to MySQL.<br><br><br>";


function auth ($user, $pass ) {
        global $db;
        $s = " select * from A where user = '$user' and pass = '$pass' ";

        $t = mysqli_query($db, $s);
        $num =  mysqli_num_rows($t);
        if ($num > 0) {
                echo"<br><br>Credentials are verified<br><br>";
                return true;
        } else {
                return false ;
        }
}


function getdata ($name, &$result) {
    global $bad;
    global $db;

    if(!isset($_GET [$name])){
                $bad = true;
                echo "Bad credentials";
                return;

    }
    $temp = $_GET [ $name ] ;
            //$temp   = mysqli_real_escape_string ( $db,  $temp );
            $result = $temp;
}



$bad  = false ;
getdata ( "user" , $user );
getdata ( "pass" , $pass );
print "Hello <br>";
print "User is: $user <br>";
print "Pass is: $pass <br>";
if ( $bad ) { exit ("Incorrect Input"); }

if (!auth(  $user,  $pass   )){exit("Bad Credentials"); }

echo 'Good Bye!' ;






$s = "select * from A";

print "SQL query is: $s <br> ";



$t = mysqli_query ($db, $s);

print "<br> Number rows is: " . mysqli_num_rows($t);



while ( $r = mysqli_fetch_array($t, MYSQL_ASSOC) ) {

$user = $r  ["user"];

$mail = $r ["mail"];

$current = $r ["cur_balance"];

print "<br>User is $user || $mail || Current Balance: $current";

}

function mailer ( $user , $out ) {

    $to = "cjm86@mailinator.com" ;
    $subject = "hello 10 4 2017";
    $message = $out;

    $to = "cjm86@mailinator.com" ;
    $subject = "hello 10 4 2017";
    $message = $out;

    if (isset($_GET ["emailresults"]) &&
         $_GET["emailresults"] == true)
    {
         echo "Mail was requested" ;
    }
    else
    {
        echo "Mail was NOT requested" ;
    }


    mail( $to , $subject, $message );
}

function show ( $user , &$out ) {
    global $db;

    $s  =   "select * from A " ;
    $out = "<br>SQL statement is: $s<br>";
    ($t = mysqli_query( $db, $s) ) or die( mysqli_error($db) );
    while ( $r = mysqli_fetch_array($t,MYSQLI_ASSOC) ) {
        $user           =$r[ "user"];
        $cur_balance    =$r[ "cur_balance" ];
        $out .="User is $user<br>";
        $out .="cur_balance is $cur_balance<br><br>";
    };
    echo $out;
}
include (  "account.php"     ) ;
$db = mysqli_connect($hostname,$user, $pass ,$project);
if (mysqli_connect_errno())
  {
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
      exit();
  }
print "<br>Successfully connected to MySQL.<br>";
mysqli_select_db( $db, $project );



$user = $_GET [ "user" ] ;   print "<br>user is: $user";

show ( $user , $out) ;
mailer ( $user , $out );



print "<br> <br>Bye <br>";

print "Interaction completed."

?>