Skip to main content

Posts

Showing posts from January, 2015

login with android programing to database My SQL

Prerequisites This tutorial is combination of some of my previous tutorials. I hope you covered these tutorials before. Android making HTTP Requests Android JSON Parsing Tutorial Android SQLite Database Tutorial Android Login and Registration Screen Design API (Application Programming Interface) ⇒ Accepting requests by GET/POST methods ⇒ Interact with PHP classes to get data from database or store in database ⇒ Finally will give output in JSON format 1. Creating MySQL Database and Tables As I am writing API in PHP I selected MySql database to maintain users and other related information. Open your mysql console or phpmyadmin and run following query to create database and users table. create database android_api /** Creating Database **/ use android_api /** Selecting Database **/ create table users(     uid int( 11 ) primary key auto_increment,     unique_id varchar( 23 ) not null unique,     name varchar( 50 ) not null,     email