Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>This is a complete solution. I've just updated this example code with the information provided in the answer below by @mad. Also check the solution below from @Khobaib explaining how to deal with picasa images.</p> <h1>Update</h1> <p>I've just reviewed my original answer and created a simple Android Studio project you can checkout from github and import directly on your system. </p> <p><a href="https://github.com/hanscappelle/SO-2169649" rel="noreferrer">https://github.com/hanscappelle/SO-2169649</a></p> <p><em>(note that the multiple file selection still needs work)</em></p> <h1>Single Picture Selection</h1> <p>With support for images from file explorers thanks to user mad.</p> <pre><code>public class BrowsePictureActivity extends Activity { // this is the action code we use in our intent, // this way we know we're looking at the response from our own action private static final int SELECT_PICTURE = 1; private String selectedImagePath; public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); findViewById(R.id.Button01) .setOnClickListener(new OnClickListener() { public void onClick(View arg0) { // in onCreate or any event where your want the user to // select a file Intent intent = new Intent(); intent.setType("image/*"); intent.setAction(Intent.ACTION_GET_CONTENT); startActivityForResult(Intent.createChooser(intent, "Select Picture"), SELECT_PICTURE); } }); } public void onActivityResult(int requestCode, int resultCode, Intent data) { if (resultCode == RESULT_OK) { if (requestCode == SELECT_PICTURE) { Uri selectedImageUri = data.getData(); selectedImagePath = getPath(selectedImageUri); } } } /** * helper to retrieve the path of an image URI */ public String getPath(Uri uri) { // just some safety built in if( uri == null ) { // TODO perform some logging or show user feedback return null; } // try to retrieve the image from the media store first // this will only work for images selected from gallery String[] projection = { MediaStore.Images.Media.DATA }; Cursor cursor = managedQuery(uri, projection, null, null, null); if( cursor != null ){ int column_index = cursor .getColumnIndexOrThrow(MediaStore.Images.Media.DATA); cursor.moveToFirst(); String path = cursor.getString(column_index); cursor.close(); return path; } // this is our fallback here return uri.getPath(); } } </code></pre> <h1>Selecting Multiple Pictures</h1> <p>Since someone requested that information in a comment and it's better to have information gathered.</p> <p>Set an extra parameter <code>EXTRA_ALLOW_MULTIPLE</code> on the intent:</p> <pre><code>intent.putExtra(Intent.EXTRA_ALLOW_MULTIPLE, true); </code></pre> <p>And in the Result handling check for that parameter:</p> <pre><code>if (Intent.ACTION_SEND_MULTIPLE.equals(data.getAction())) &amp;&amp; Intent.hasExtra(Intent.EXTRA_STREAM)) { // retrieve a collection of selected images ArrayList&lt;Parcelable&gt; list = intent.getParcelableArrayListExtra(Intent.EXTRA_STREAM); // iterate over these images if( list != null ) { for (Parcelable parcel : list) { Uri uri = (Uri) parcel; // TODO handle the images one by one here } } } </code></pre> <p>Note that this is only supported by API level 18+.</p>
    singulars
    1. This table or related slice is empty.
    1. POGet/pick an image from Android's built-in Gallery app programmatically
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. UShcpl
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POGet/pick an image from Android's built-in Gallery app programmatically
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COIt doesn't work when I use Astro file manager. Any ideas why?
      singulars
      1. PO
      1. USRohith Nandakumar
    2. CO@rohith - look at my answer
      singulars
      1. PO
      1. USmad
    3. COanswered without reading the question.. -1
      singulars
      1. PO
      1. USkellogs
 

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.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload