Wednesday, December 31, 2014

7-**


define('DB_SERVER', 'localhost'); define('DB_USERNAME', 'USERNAME'); define('DB_PASSWORD', 'PASSWORD'); define('DB_DATABASE', 'DATABASE_NAME'); $connection = mysql_connect(DB_SERVER, DB_USERNAME, DB_PASSWORD) or die(mysql_error()); $database = mysql_select_db(DB_DATABASE) or die(mysql_error()); $query=mysql_query("select emp, manager from employees") or die(mysql_error()); # Collect the results while($obj = mysql_fetch_object($query)) { $arr[] = $obj; } # JSON-encode the response $json_response = json_encode($arr); // # Return the response echo $json_response;

No comments: