<?php

    $mysql_host = "mysql10.000webhost.com";
    $mysql_database = "a1693608_points";
    $mysql_user = "a1693608_harry";
    $mysql_password = "lolnope";

    $conn =  mysql_connect($mysql_host, $mysql_user, $mysql_password)or die("Couldn't connect to DB" . mysql_error());
    mysql_select_db($mysql_database, $conn);


    $email = $_GET[email];
    $sql='select * from users where email=\'$email\'';

    $result=mysql_query($sql,$conn) or die(mysql_error());

    if (mysql_num_rows($result) == "1") {
       $user = mysql_fetch_array( $result );
       $password = $user["id"];
         $result = array("code" => "125", "account_id" => $user[id]);

    } else {
       $result = array("code" => "126");
    }

   $JSON_Result = json_encode($result);
    echo $JSON_Result;
?>

<?php

    $mysql_host = "mysql10.000webhost.com";
    $mysql_database = "a1693608_points";
    $mysql_user = "a1693608_harry";
    $mysql_password = "olyeah?";

    $conn =  mysql_connect($mysql_host, $mysql_user, $mysql_password)or die("a . " . mysql_error());
    mysql_select_db($mysql_database, $conn);


    $sql="select * from manPoints";
    $result=mysql_query($sql,$conn) or die(mysql_error());

    $myJSonArray = array();
    while($row = mysql_fetch_array($result)) {
       
        //print_r ($row['Title']);
        $emptyArrayItem = array();

        for ($i=0; $i<9; $i++) {
            array_push($emptyArrayItem, $row[$i]);
        }

        array_push($myJSonArray, $emptyArrayItem);

    }

    $encoded_array = json_encode($myJSonArray);
    echo $encoded_array;
?>