<?php
// Database Information:
        $host="your_host_name"; // Host name
        $username1="your_username_for_database"; // Mysql username
        $password1="your_password_for_database"; // Mysql password
        $db_name="database_name"; // Database name
        $tbl_users="users"; // Users Table (You just made this!)[/b]
     // Catch Post Data
$cmd = $_POST['command'];
        $user = $_POST['username'];
        $pass = $_POST['password'];[/b][b]      // Check post data
        $cmd = checkString($cmd);
$user = checkString($user);
$pass = checkString($pass);[/b]
[b]if ($cmd == 'login') {[/b][b]  sql = "SELECT * FROM  " . $tbl_users . " WHERE  username =  '" . $user . "' AND password =  '" . $pass . "'";
         $query = mysql_query($sql);
         $count = mysql_num_rows($query);[/b]
      if ($count > 0) {
                 echo '"true"';
         } else {
                 echo '"false"';
         }[/b][b]} elseif ($cmd == 'insert') {
  mysql_query("INSERT INTO $tbl_name(username, password) VALUES('$myusername', '$mypassword')");
                $affect_rows = mysql_affected_rows();
                if ($affect_rows > 0) {
                        echo '"true"';
                } else {
                        echo '"false"';
                }
} elseif ($cmd == 'delete') {
  mysql_query("DELETE FROM $tbl_name WHERE username = '" . $myusername . "' AND password = '" . $mypassword . "'");
                $affect_rows = mysql_affected_rows();
                if ($affect_rows > 0) {
                        echo '"true"';
                } else {
                        echo '"false"';
                }
} elseif ($cmd == 'get') {
  $sql="SELECT * FROM " . $tbl_name . " WHERE username = '" . $myusername . "' AND password = '" . $mypassword . "'";
                $result=mysql_query($sql);
                $count=mysql_num_rows($result);
                if ($count == 1){
                        while($row = mysql_fetch_array($result)){
                                foreach($row as $key => $value){
                                        if (!is_numeric ($key)){
                                          $data[$key] = $value;
                                        }
                                }
                        }
                }else{
                        $data['error'] = '"false"';
                }
                header('Content-Type:text/json');[/b]
             $total = count($data);
                $count = 0;[/b][b]              foreach ($data as $d) {

                        if ($count == 0) {
                           echo '{' . PHP_EOL;
                        }

                        echo '"' . $d . '",' . PHP_EOL;

                        $count++;

                        if ($count == $total) {
                                echo '}';
                        }

                }
}
function checkString($string) {
                $string = stripslashes($string);
                $string = mysql_real_escape_string($string);
                return $string;
        }
?>