Ajay Khatri

PHP and MySql Database Connectivity

July 26, 2017July 26, 2017 admin

<form method="GET" action="insert.php">
<input type="text" name="eno" placeholder="Enter EMP No"/>
<input type="text" name="ename" placeholder="Enter EMP NAME"/>
<input type="text" name="esal" placeholder="Enter EMP Salary"/>
<input type="submit" name="addButton" value="Add EMP"/>
</form>

</form>

<?php
$eno = $_GET['eno'];
$ename = $_GET['ename'];
$sal = $_GET['esal'];
$conn = new mysqli("localhost", "root", "","atc");

if ($conn->connect_error) {
  echo "Not Connected";
}else{ 
echo "Connected successfully";
}
$sql = "insert into emp (eno,ename,sal) values (".$eno.",'".$ename."',".$sal.")";
if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}
$conn->close();
?>

<?php

$eno = $_GET['eno'];

$ename = $_GET['ename'];

$sal = $_GET['esal'];

$conn = new mysqli("localhost", "root", "","atc");

if ($conn->connect_error) {

echo "Not Connected";

}else{

echo "Connected successfully";

}

$sql = "insert into emp (eno,ename,sal) values (".$eno.",'".$ename."',".$sal.")";

if ($conn->query($sql) === TRUE) {

echo "New record created successfully";

} else {

echo "Error: " . $sql . "<br>" . $conn->error;

}

$conn->close();

CREATE TABLE emp (
  eno int(11) NOT NULL,
  ename varchar(50) NOT NULL,
  sal double NOT NULL
)

CREATE TABLE emp (

eno int(11) NOT NULL,

ename varchar(50) NOT NULL,

sal double NOT NULL

)

Send SMS using SmsManager in Android

July 10, 2017 admin

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context="in.ajaykhatri.smsexample.MainActivity">

    <EditText
        android:id="@+id/mobileNumber"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Enter Mobile Number"
        android:inputType="number" />

    <EditText
        android:id="@+id/messageBox"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:hint="Enter Message" />

    <Button
        android:id="@+id/buttonSendMessage"
        android:layout_width="match_parent"
        android:layout_height="wrap_content"
        android:text="Send Message" />

</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical"

tools:context="in.ajaykhatri.smsexample.MainActivity">

<EditText

android:id="@+id/mobileNumber"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:hint="Enter Mobile Number"

android:inputType="number" />

<EditText

android:id="@+id/messageBox"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:hint="Enter Message" />

<Button

android:id="@+id/buttonSendMessage"

android:layout_width="match_parent"

android:layout_height="wrap_content"

android:text="Send Message" />

</LinearLayout>

package in.ajaykhatri.smsexample;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.telephony.SmsManager;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    EditText mobileNumber,message;
    Button buttonSendSMS;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        mobileNumber = (EditText)findViewById(R.id.mobileNumber);
        message = (EditText)findViewById(R.id.messageBox);

        buttonSendSMS = (Button)findViewById(R.id.buttonSendMessage);

        buttonSendSMS.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View view) {
                String number = mobileNumber.getText().toString().trim();
                String msg = message.getText().toString().trim();

                SmsManager smsManager;
                smsManager = SmsManager.getDefault();

                smsManager.sendTextMessage(number,null,msg,null,null);

                Toast.makeText(getApplicationContext(),
                        "Msg Sent successfully.",Toast.LENGTH_LONG).show();
            }
        });

    }
}

package in.ajaykhatri.smsexample;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.telephony.SmsManager;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

EditText mobileNumber,message;

Button buttonSendSMS;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

mobileNumber = (EditText)findViewById(R.id.mobileNumber);

message = (EditText)findViewById(R.id.messageBox);

buttonSendSMS = (Button)findViewById(R.id.buttonSendMessage);

buttonSendSMS.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View view) {

String number = mobileNumber.getText().toString().trim();

String msg = message.getText().toString().trim();

SmsManager smsManager;

smsManager = SmsManager.getDefault();

smsManager.sendTextMessage(number,null,msg,null,null);

Toast.makeText(getApplicationContext(),

"Msg Sent successfully.",Toast.LENGTH_LONG).show();

}

});

}

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="in.ajaykhatri.smsexample">

    <uses-permission android:name="android.permission.SEND_SMS"/>


    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:roundIcon="@mipmap/ic_launcher_round"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

package="in.ajaykhatri.smsexample">

<uses-permission android:name="android.permission.SEND_SMS"/>

<application

android:allowBackup="true"

android:icon="@mipmap/ic_launcher"

android:label="@string/app_name"

android:roundIcon="@mipmap/ic_launcher_round"

android:supportsRtl="true"

android:theme="@style/AppTheme">

<intent-filter>

</intent-filter>

</activity>

</application>

</manifest>

Android Spinner

April 29, 2017April 29, 2017 admin

Android Spinner is like the combox box of AWT or Swing. It can be used to display the multiple options to the user in which only one item can be selected by the user.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context="in.ajaykhatri.testdemo.MainActivity">

    <Spinner
        android:layout_width="wrap_content"
        android:layout_height="match_parent"
        android:id="@+id/spinner"></Spinner>
</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical"

tools:context="in.ajaykhatri.testdemo.MainActivity">

<Spinner

android:layout_width="wrap_content"

android:layout_height="match_parent"

android:id="@+id/spinner"></Spinner>

</LinearLayout>

package in.ajaykhatri.testdemo;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.AdapterView;
import android.widget.ArrayAdapter;
import android.widget.Spinner;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    // Array of choices
    String colors[] = {"Select","Red","Blue","White","Yellow","Black", "Green","Purple","Orange","Grey"};

    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
       setContentView(R.layout.activity_main);

        // Selection of the spinner
        Spinner spinner = (Spinner) findViewById(R.id.spinner);

        // Application of the Array to the Spinner
        ArrayAdapter<String> spinnerArrayAdapter = new ArrayAdapter<String>(this,   android.R.layout.simple_spinner_item, colors);
        spinnerArrayAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); // The drop down view
        spinner.setAdapter(spinnerArrayAdapter);

        spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {
            @Override
            public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {
                if(position>0) {
                    Toast.makeText(MainActivity.this, colors[position], Toast.LENGTH_SHORT).show();
                }else{
                    Toast.makeText(MainActivity.this, "Nothing Selected", Toast.LENGTH_SHORT).show();
                }
            }

            @Override
            public void onNothingSelected(AdapterView<?> parent) {

            }
        });
    }
}

package in.ajaykhatri.testdemo;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.view.View;

import android.widget.AdapterView;

import android.widget.ArrayAdapter;

import android.widget.Spinner;

import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

// Array of choices

String colors[] = {"Select","Red","Blue","White","Yellow","Black", "Green","Purple","Orange","Grey"};

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

// Selection of the spinner

Spinner spinner = (Spinner) findViewById(R.id.spinner);

// Application of the Array to the Spinner

ArrayAdapter<String> spinnerArrayAdapter = new ArrayAdapter<String>(this, android.R.layout.simple_spinner_item, colors);

spinnerArrayAdapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item); // The drop down view

spinner.setAdapter(spinnerArrayAdapter);

spinner.setOnItemSelectedListener(new AdapterView.OnItemSelectedListener() {

@Override

public void onItemSelected(AdapterView<?> parent, View view, int position, long id) {

if(position>0) {

Toast.makeText(MainActivity.this, colors[position], Toast.LENGTH_SHORT).show();

}else{

Toast.makeText(MainActivity.this, "Nothing Selected", Toast.LENGTH_SHORT).show();

}

@Override

public void onNothingSelected(AdapterView<?> parent) {

}

});

}

Android Radio Buttons

April 28, 2017April 28, 2017 admin

If we check one radio button that belongs to a radio group, it automatically unchecks any previously checked radio button within the same group.

<?xml version="1.0" encoding="utf-8"?>
<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:app="http://schemas.android.com/apk/res-auto"
    xmlns:tools="http://schemas.android.com/tools"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    android:orientation="vertical"
    tools:context="in.ajaykhatri.testdemo.MainActivity">

    <RadioGroup
        android:layout_width="match_parent"
        android:layout_height="wrap_content">

        <RadioButton
            android:id="@+id/radioCS"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="CS" />


        <RadioButton
            android:id="@+id/radioIT"
            android:layout_width="wrap_content"
            android:layout_height="wrap_content"
            android:text="IT" />

    </RadioGroup>

    <Button
        android:id="@+id/buttonClickMe"
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Click Me"/>
</LinearLayout>

<?xml version="1.0" encoding="utf-8"?>

<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:app="http://schemas.android.com/apk/res-auto"

xmlns:tools="http://schemas.android.com/tools"

android:layout_width="match_parent"

android:layout_height="match_parent"

android:orientation="vertical"

tools:context="in.ajaykhatri.testdemo.MainActivity">

<RadioGroup

android:layout_width="match_parent"

android:layout_height="wrap_content">

<RadioButton

android:id="@+id/radioCS"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="CS" />

<RadioButton

android:id="@+id/radioIT"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="IT" />

</RadioGroup>

<Button

android:id="@+id/buttonClickMe"

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Click Me"/>

</LinearLayout>

package in.ajaykhatri.testdemo;

import android.support.v7.app.AppCompatActivity;
import android.os.Bundle;
import android.view.View;
import android.widget.Button;
import android.widget.RadioButton;
import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

    Button buttonClickMe;
    RadioButton radioCS,radioIT;
    @Override
    protected void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.activity_main);

        buttonClickMe = (Button) findViewById(R.id.buttonClickMe);
        radioCS = (RadioButton) findViewById(R.id.radioCS);
        radioIT = (RadioButton) findViewById(R.id.radioIT);

        buttonClickMe.setOnClickListener(new View.OnClickListener() {
            @Override
            public void onClick(View v) {
                if(radioCS.isChecked()){
                    Toast.makeText(MainActivity.this, "CS Selected", Toast.LENGTH_SHORT).show();
                }else if(radioIT.isChecked()){
                    Toast.makeText(MainActivity.this, "IT Selected", Toast.LENGTH_SHORT).show();
                }else{
                    Toast.makeText(MainActivity.this, "Please select branch", Toast.LENGTH_SHORT).show();
                }

            }
        });
    }

}

package in.ajaykhatri.testdemo;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.RadioButton;

import android.widget.Toast;

public class MainActivity extends AppCompatActivity {

Button buttonClickMe;

RadioButton radioCS,radioIT;

@Override

protected void onCreate(Bundle savedInstanceState) {

super.onCreate(savedInstanceState);

setContentView(R.layout.activity_main);

buttonClickMe = (Button) findViewById(R.id.buttonClickMe);

radioCS = (RadioButton) findViewById(R.id.radioCS);

radioIT = (RadioButton) findViewById(R.id.radioIT);

buttonClickMe.setOnClickListener(new View.OnClickListener() {

@Override

public void onClick(View v) {

if(radioCS.isChecked()){

Toast.makeText(MainActivity.this, "CS Selected", Toast.LENGTH_SHORT).show();

}else if(radioIT.isChecked()){

Toast.makeText(MainActivity.this, "IT Selected", Toast.LENGTH_SHORT).show();

}else{

Toast.makeText(MainActivity.this, "Please select branch", Toast.LENGTH_SHORT).show();

}

});

}

Android – Styles For TextView

February 22, 2017March 1, 2017 admin

style.xml

 <!-- Base application theme. -->
    <style name="AppTheme" parent="Theme.AppCompat.Light.DarkActionBar">
        <!-- Customize your theme here. -->
        <item name="colorPrimary">@color/colorPrimary</item>
        <item name="colorPrimaryDark">@color/colorPrimaryDark</item>
        <item name="colorAccent">@color/colorAccent</item>

        <item name="android:textViewStyle">@style/MyFontStyle</item>
    </style>

    <style name="MyFontStyle">
        <item name="android:layout_width">fill_parent</item>
        <item name="android:layout_height">wrap_content</item>
        <item name="android:capitalize">characters</item>
        <item name="android:typeface">monospace</item>
        <item name="android:textSize">12pt</item>
        <item name="android:textColor">@color/colorAccent</item>/>
    </style>

<item name="colorPrimary">@color/colorPrimary</item>

<item name="colorPrimaryDark">@color/colorPrimaryDark</item>

<item name="colorAccent">@color/colorAccent</item>

<item name="android:textViewStyle">@style/MyFontStyle</item>

</style>

<item name="android:layout_width">fill_parent</item>

<item name="android:layout_height">wrap_content</item>

<item name="android:capitalize">characters</item>

<item name="android:typeface">monospace</item>

<item name="android:textColor">@color/colorAccent</item>/>

</style>

activity_main.xml

<?xml version="1.0" encoding="utf-8"?>
<RelativeLayout 
    xmlns:android="http://schemas.android.com/apk/res/android"
    xmlns:tools="http://schemas.android.com/tools"
    android:id="@+id/activity_main"
    android:layout_width="match_parent"
    android:layout_height="match_parent"
    tools:context="in.ajaykhatri.myapplication.MainActivity">

    <TextView
        android:layout_width="wrap_content"
        android:layout_height="wrap_content"
        android:text="Hello World!" />
</RelativeLayout>

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout

xmlns:android="http://schemas.android.com/apk/res/android"

xmlns:tools="http://schemas.android.com/tools"

android:id="@+id/activity_main"

android:layout_width="match_parent"

android:layout_height="match_parent"

tools:context="in.ajaykhatri.myapplication.MainActivity">

<TextView

android:layout_width="wrap_content"

android:layout_height="wrap_content"

android:text="Hello World!" />

</RelativeLayout>

AndroidManifest.xml

<?xml version="1.0" encoding="utf-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
    package="in.ajaykhatri.myapplication">

    <application
        android:allowBackup="true"
        android:icon="@mipmap/ic_launcher"
        android:label="@string/app_name"
        android:supportsRtl="true"
        android:theme="@style/AppTheme">
        <activity android:name=".MainActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN" />

                <category android:name="android.intent.category.LAUNCHER" />
            </intent-filter>
        </activity>
    </application>

</manifest>

<?xml version="1.0" encoding="utf-8"?>

<manifest xmlns:android="http://schemas.android.com/apk/res/android"

package="in.ajaykhatri.myapplication">

<application

android:allowBackup="true"

android:icon="@mipmap/ic_launcher"

android:label="@string/app_name"

android:supportsRtl="true"

android:theme="@style/AppTheme">

<intent-filter>

</intent-filter>

</activity>

</application>

</manifest>

Output

AlertDialog Box in Android

February 21, 2017April 28, 2017 admin

AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);

builder.setMessage("Hello Ajay");

builder.setTitle(R.string.app_name);

builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {
    public void onClick(DialogInterface dialog, int id) {
        // User clicked OK button
    }
});
builder.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {
    public void onClick(DialogInterface dialog, int id) {
        // User cancelled the dialog
    }
});

AlertDialog dialog = builder.create();

dialog.show();

AlertDialog.Builder builder = new AlertDialog.Builder(MainActivity.this);

builder.setMessage("Hello Ajay");

builder.setTitle(R.string.app_name);

builder.setPositiveButton("OK", new DialogInterface.OnClickListener() {

public void onClick(DialogInterface dialog, int id) {

// User clicked OK button

}

});

builder.setNegativeButton("Cancel", new DialogInterface.OnClickListener() {

public void onClick(DialogInterface dialog, int id) {

// User cancelled the dialog

}

});

AlertDialog dialog = builder.create();

dialog.show();

An intent is an abstract description of an operation to be performed. It can be used with startActivity to launch an Activity, broadcastIntent to send it to any interested BroadcastReceiver components, and startService(Intent) or bindService(Intent, ServiceConnection, int) to communicate with Read More …

Most Common Mistakes That Android Developers Make

February 4, 2017February 20, 2017 admin

Developing for iOS – Avoid using apps for Android which are in reality an iOS clone or designed according to iOS design standards. With Android being in the market for quite some time now, one needs to respect this platform and Read More …

Android 7.0 Nougat: Features of Google’s latest OS

February 3, 2017February 20, 2017 admin

Expanded emoji – There are now over 1,500 different emoji built into Android, including 72 new ones. Quick Settings controls – Quick Settings gives you easy access to things like bluetooth, WiFi and the all-important flashlight. With Android Nougat, you can actually Read More …

Category: Android

PHP and MySql Database Connectivity

Send SMS using SmsManager in Android

Android Spinner

Android Radio Buttons

Android – Styles For TextView

AlertDialog Box in Android

Android Intents Cheatsheet

Most Common Mistakes That Android Developers Make

Android 7.0 Nougat: Features of Google’s latest OS