StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POAndroid get info from mysql - php
primarykey
Id
20272825
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
7
CommunityOwnedDate
CreationDate
2013-11-28T18:33:51.930
FavoriteCount
0
LastActivityDate
2013-11-28T18:47:58.540
LastEditDate
2013-11-28T18:47:58.540
LastEditorUserId
2141889
OwnerUserId
2141889
ParentId
0
PostTypeId
1
Score
0
ViewCount
325
LastEditorDisplayName
text
Body
I am trying to fetch some info from my mysql database, the user unique_id. I have been following tutorial online and changing the parts to just create simple function that returns json object. However when I am trying to launch that method I'm getting errors: <pre><code>No database selected value no of java.lang.String cannot be converted to JSONObject </code></pre> The second one comes because the connection or retrieving data from database did not succeed I guess, but I couldn't find where the problem lies. Here is my code config.php <pre><code><?php define("DB_HOST", "localhost"); define("DB_USER", "root"); define("DB_PASSWORD", ""); define("DB_DATABASE", "test"); ?> </code></pre> DB_Connect.php <pre><code><?php class DB_Connect { function __construct() { } function __destruct() { } // Connecting to database public function connect() { require_once 'config.php'; // connecting to mysql $con = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD); // selecting database mysql_select_db(DB_DATABASE); // return database handler return $con; // Closing database connection public function close() { mysql_close(); } } ?> </code></pre> DB_Functions.php <pre><code><?php class DB_Functions { private $db; //put your code here // constructor function __construct() { require_once 'DB_Connect.php'; // connecting to database $this->db = new DB_Connect(); $this->db->connect(); if(!$this->db){ echo "Please try later."; } } // destructor function __destruct() { } // Check if user exists. public function isUserExisted($unique_id) { $result = mysql_query("SELECT unique_id from users WHERE unique_id = '$unique_id'"); if($result === FALSE) { die(mysql_error()); } $no_of_rows = mysql_num_rows($result); if ($no_of_rows > 0) { // user existed return true; } else { // user not existed return false; } } } ?> </code></pre> index.php <pre><code><?php if (isset($_POST['tag']) && $_POST['tag'] != '') { // get tag $tag = $_POST['tag']; // include db handler require_once 'include/DB_Functions.php'; $db = new DB_Functions(); $response = array("tag" => $tag, "success" => 0, "error" => 0); if ($tag == 'check') { // Request unique_id $unique_id = $_POST['unique_id']; // check if user is already existed if ($db->isUserExisted($unique_id)) { // user is already existed - error response $response["error"] = 2; $response["error_msg"] = "User already existed"; echo json_encode($response); } else { $response["error"] = 1; $response["error_msg"] = "USER UNKNOWN!"; echo json_encode($response); } } } ?> </code></pre> And inside my android JSONParses looks like that: <pre><code>public class JSONParser { private static InputStream inputStream; private static JSONObject jSONObject; private static String json; JSONParser(){ inputStream = null; jSONObject = null; json = " "; } public JSONObject getJSONFromUrl(String url, List<NameValuePair> parameters) throws ClientProtocolException{ try { DefaultHttpClient defaultHttpClient = new DefaultHttpClient(); HttpPost httpPost = new HttpPost(url); httpPost.setEntity(new UrlEncodedFormEntity(parameters)); HttpResponse httpResponse = defaultHttpClient.execute(httpPost); HttpEntity httpEntity = httpResponse.getEntity(); inputStream = httpEntity.getContent(); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } try { BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream, "iso-8859-1"), 8); StringBuilder stringBuilder = new StringBuilder(); String line = null; while((line = bufferedReader.readLine()) != null){ stringBuilder.append(line + "n"); } inputStream.close(); json = stringBuilder.toString(); Log.e("JSON", json); } catch (UnsupportedEncodingException e) { e.printStackTrace(); } catch (IOException e) { e.printStackTrace(); } try { jSONObject = new JSONObject(json); } catch (JSONException e) { Log.e("ERROR PARSING DATA: ",e.toString()); } return jSONObject; } } </code></pre> And last piece of code, method to work with JSONParser (It is in an Async Call) <pre><code>private JSONObject checkIfUserExists(String unique_id){ List<NameValuePair> parameters = new ArrayList<NameValuePair>(); parameters.add(new BasicNameValuePair("tag", CHECK_TAG)); parameters.add(new BasicNameValuePair("unique_id", unique_id)); JSONObject json=null; try { json = jsonParser.getJSONFromUrl(loginURL, parameters); } catch (ClientProtocolException e) { // TODO Auto-generated catch block e.printStackTrace(); } return json; } </code></pre> And I am receiving the error about no Database Selected inside my JSONParser. I have been looking over the code and it seems to be good for me, I know the issue is somewhere small and thats why I cant find it. Any help would be very appreciated. Thanks in advance. @Edit. I have just checked and <pre><code> if($result === FALSE) { echo "DEAD"; die(mysql_error()); } </code></pre> this prints dead, so it seems that my query is wrong, or somewhat not realized but I have no idea what might be wrong with it...
Tags
<php><android><mysql>
Title
Android get info from mysql - php
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser2141889
UserOwnerUserId
1. USuser2141889
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.