Skip to main content

Posts

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)

DATE PICKER REACT NATIVE USING FLATLIST

import React, { Component, Fragment } from "react"; import { StyleSheet, View, FlatList, Image, Text} from "react-native"; import { Appbar, TextInput, Caption, List, Button} from "react-native-paper"; import { Formik } from 'formik'; import * as yup from 'yup'; import DatePicker from 'react-native-date-picker'; const DATE_SCHEMA = yup.object().shape({     start_date: yup.string()     .required('Start Date Required'),   end_date: yup.string()     .required('End Date Required'), }); const IMAGE = require("../assets/voice/flag-blue.png"); export default class AlertButton extends Component {   state = {     start_date...

SEARCH BETWEEN DATES CODEIGNITER

# search the saved data by date.      public   function   searchBydate ()     {          $startdate     = ( trim ( $this -> input -> get ( 'startdate' )));          $enddate     = ( trim ( $this -> input -> get ( 'enddate' )));          $column  =  array (  'id' ,  'userid' ,  'filename'  );          // SELECT * FROM `library` WHERE `date` BETWEEN 'startdate' AND 'enddate '           $where  =  array (                       ...

CONTROLLER PROJECT II

<?php defined ( 'BASEPATH' ) OR  exit ( 'No direct script access allowed' ); require  APPPATH  .   '/libraries/API_Controller.php' ; class   Services   extends   API_Controller  {           public   function   __construct ()     {             header ( 'Access-Control-Allow-Origin: *' );          header ( "Access-Control-Allow-Methods: GET, POST, OPTIONS, PUT, DELETE" );          parent :: __construct ();          //SMTP & mail configuration          $config  =  array (              'protocol' ...