php - Getting BLOB from mysql database to android -


i have mysql database following schema 

(int id, int sys_id, blob data)

there can multiple data same sys_id, i.e. (1,1, blobdata1), (2,1, blobdata2) etc. valid entries. blob data compressed audio. when rows particular sys_id combined valid compressed audio data produced.

i want send blob data android device. have tried following php code send data not received expected @ client side.

$conn = mysql_connect("localhost","root",""); mysql_select_db("mydb", $conn);  global $blobid; $blobid = $_get['id']; $result = mysql_query("select data table sys_id=$blobid"); if( mysql_num_rows($result) == 0 ) die("no rows returned");  while($row = mysql_fetch_array($result) ) {      // correct way of concatenating binary data      $temp .= $row['data']; }  // problem: should sent echo $temp;

i don't mind if rows can received @ client end , can concatenated or operated upon locally there.

at client side, following:

// connect server public void connect(url url) {  httpurlconnection urlconnection = null;     try {                    urlconnection = (httpurlconnection)url.openconnection();         inputstream in = new bufferedinputstream(urlconnection.getinputstream());         result = readstream(in);             //problem, how should parse resultant string             decompress(result.getbytes()); // result.getbytes() returns null      } catch (malformedurlexception e) {         e.printstacktrace();     } catch (ioexception e) {         e.printstacktrace();     } catch (exception e) {         e.printstacktrace();     } }  // reading incoming stream public static string readstream(inputstream in) throws ioexception {     stringbuilder sb = new stringbuilder();     bufferedreader r = new bufferedreader(new inputstreamreader(in),1000);     (string line = r.readline(); line != null; line =r.readline()){         sb.append(line);     }     in.close();     return sb.tostring(); }   // definition decompression utility  public short[] decompress(byte[] codbytes);

you can encode data want send in json format as

 echo json_encode($response);

and send json device , parse accordingly. parsing refer here


Comments

Post a Comment

Popular posts from this blog

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more

php - Controller/JToolBar not working in Joomla 2.5 -

relevant code: jtoolbarhelper::custom('savecategories', 'save', '', 'save', false, false); ... <input type="hidden" name="controller" value="easyblogcontroller"> according can dig docs , own previous questions, should call savecategories() function in easyblogcontroller . i've tried setting value easyblog , easyblog.php (file name) current easyblogcontroller (class name). clicking on save button refreshes page. not redirect, echo or var_dump test code put in savecategories() function. var_dump ing jrequest::getvar('controller') , 'task' return correct values. creating controller object , using $controller->execute('task'); works. the values going depend on location of controller trying call, , have couple options here. typically there controller in base folder of component (likely components/com_easyblog) in file called controller.php , class name inside ...
Read more