Skip to main content

Posts

Showing posts from November, 2019

REACT NATIVE DEVICE PERMISSIONS

Write uses permissions in  “Project/android/app/src/main/AndroidManifest.xml”     <uses-permission android:name="android.permission.INTERNET" />        <uses-permission android:name="android.permission.CAMERA" />     <uses-permission android:name="android.permission.RECORD_AUDIO"/>     <uses-permission android:name="android.permission.READ_EXTERNAL_STORAGE" />     <uses-permission android:name="android.permission.WRITE_EXTERNAL_STORAGE" />     <!-- setMicrophoneMute() and setSpeakerphoneOn() -->     <uses-permission android:name="android.permission.MODIFY_AUDIO_SETTINGS" />             <!-- setBrightness() & setScreenMode() & saveBrightness() -->     <uses-permission android:name="android.permission.WRITE_SETTINGS" />     ...

SORT BASE ON COUNT

Query to select feilds group by column and order by number of counts of feilds. || SELECT type , count (*) FROM vehicles group by type order by count (*) desc   || SELECT `userid`, count( *) FROM `library` group by `userid` order by count( *) desc   || SELECT `userid`, count( favourite) FROM `library` group by `userid` order by count( favourite) desc   ERROR : SELECT list is not in GROUP BY clause and contains nonaggregated column … incompatible with sql_mode=only_full_group_by SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));

REST

REST stands for REpresentational State Transfer and is used to access and manipulate data using several stateless operations. These operations are integral to the HTTP protocol and represent an essential CRUD functionality (Create, Read, Update, Delete). The HTTP operations available are: POST (create a resource or generally provide data) GET (retrieve an index of resources or an individual resource) PUT (create or replace a resource) PATCH (update/modify a resource) DELETE (remove a resource)