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();

}

});

}

Program to demonstrate multithreading.

April 20, 2017 admin

package demo;

class RunnableDemo implements Runnable {
   private Thread t;
   private String threadName;
   
   RunnableDemo( String name) {
      threadName = name;
      System.out.println("Creating " +  threadName );
   }
   
   public void run() {
      System.out.println("Running " +  threadName );
      try {
         for(int i = 4; i > 0; i--) {
            System.out.println("Thread: " + threadName + ", " + i);
            // Let the thread sleep for a while.
            Thread.sleep(100);
         }
      }catch (InterruptedException e) {
         System.out.println("Thread " +  threadName + " interrupted.");
      }
      System.out.println("Thread " +  threadName + " exiting.");
   }
   
   public void start () {
      System.out.println("Starting " +  threadName );
      if (t == null) {
         t = new Thread (this, threadName);
         t.start ();
      }
   }
}

public class TestThread {

   public static void main(String args[]) {
      RunnableDemo R1 = new RunnableDemo( "Thread-1");
      R1.start();
      
      RunnableDemo R2 = new RunnableDemo( "Thread-2");
      R2.start();
   }   
}

package demo;

class RunnableDemo implements Runnable {

private Thread t;

private String threadName;

RunnableDemo( String name) {

threadName = name;

System.out.println("Creating " + threadName );

}

public void run() {

System.out.println("Running " + threadName );

try {

for(int i = 4; i > 0; i--) {

System.out.println("Thread: " + threadName + ", " + i);

// Let the thread sleep for a while.

Thread.sleep(100);

}

}catch (InterruptedException e) {

System.out.println("Thread " + threadName + " interrupted.");

}

System.out.println("Thread " + threadName + " exiting.");

}

public void start () {

System.out.println("Starting " + threadName );

if (t == null) {

t = new Thread (this, threadName);

t.start ();

}

public class TestThread {

public static void main(String args[]) {

RunnableDemo R1 = new RunnableDemo( "Thread-1");

R1.start();

RunnableDemo R2 = new RunnableDemo( "Thread-2");

R2.start();

}

Program to demonstrate function overloading for calculation of average.

April 20, 2017April 20, 2017 admin

package demo;

public class Demo {

    public static double avg(double m, double n) {
        return (m + n) / 2;
    }

    public static double avg(double m, double n, double o) {
        return (m + n + o) / 3;
    }

    public static void main(String[] args) {
        double a = 10, b = 20, c = 30;
        System.out.println("Avg of Two Numbers " + avg(a, b));
        System.out.println("Avg of Three Numbers " + avg(a, b, c));
    }

}

package demo;

public class Demo {

public static double avg(double m, double n) {

return (m + n) / 2;

}

public static double avg(double m, double n, double o) {

return (m + n + o) / 3;

}

public static void main(String[] args) {

double a = 10, b = 20, c = 30;

System.out.println("Avg of Two Numbers " + avg(a, b));

System.out.println("Avg of Three Numbers " + avg(a, b, c));

}

Write a program to calculate addition of two number using prototyping of methods.

April 20, 2017 admin

package demo;

public class Demo {

    public static int sum(int m, int n) {
        return m + n;
    }

    public static void main(String[] args) {
        int a = 10, b = 20;
        System.out.println(" Sum of Numberes " + sum(a, b));
    }

}

package demo;

public class Demo {

public static int sum(int m, int n) {

return m + n;

}

public static void main(String[] args) {

int a = 10, b = 20;

System.out.println(" Sum of Numberes " + sum(a, b));

}

Write a program to convert decimal number into binary numbers.

April 20, 2017 admin

package demo;
public class Demo {
     public static void printBinaryFormat(int number){
        int binary[] = new int[25];
        int index = 0;
        while(number > 0){
            binary[index++] = number%2;
            number = number/2;
        }
        for(int i = index-1;i >= 0;i--){
            System.out.print(binary[i]);
        }
    }
    
     public static void main(String[] args) {
          printBinaryFormat(25);    
    }
   
}

package demo;

public class Demo {

public static void printBinaryFormat(int number){

int binary[] = new int[25];

int index = 0;

while(number > 0){

binary[index++] = number%2;

number = number/2;

}

for(int i = index-1;i >= 0;i--){

System.out.print(binary[i]);

}

public static void main(String[] args) {

printBinaryFormat(25);

}

Write a program for matrix addition.

April 20, 2017 admin

package demo;

import java.util.Scanner;

public class Demo {

    public static void main(String[] args) {
        int rows, columns, c, d;
        Scanner in = new Scanner(System.in);
        System.out.println("Enter the number of rows and columns of matrix");
        rows = in.nextInt();
        columns = in.nextInt();
        int matrix1[][] = new int[rows][columns];
        int matrix2[][] = new int[rows][columns];
        int sum[][] = new int[rows][columns];
        System.out.println("Enter the elements of matrix1");
        for (c = 0; c < rows; c++) {
            for (d = 0; d < columns; d++) {
                matrix1[c][d] = in.nextInt();
            }
        }
        System.out.println("Enter the elements of matrix2");
        for (c = 0; c < rows; c++) {
            for (d = 0; d < columns; d++) {
                matrix2[c][d] = in.nextInt();
            }
        }
        for (c = 0; c < rows; c++) {
            for (d = 0; d < columns; d++) {
                sum[c][d] = matrix1[c][d] + matrix2[c][d];
            }
        }
        System.out.println("Sum of entered matrices:");
        for (c = 0; c < rows; c++) {
            for (d = 0; d < columns; d++) {
                System.out.print(sum[c][d] + "\t");
            }
            System.out.println();
        }
    }
}

package demo;

import java.util.Scanner;

public class Demo {

public static void main(String[] args) {

int rows, columns, c, d;

Scanner in = new Scanner(System.in);

System.out.println("Enter the number of rows and columns of matrix");

rows = in.nextInt();

columns = in.nextInt();

int matrix1[][] = new int[rows][columns];

int matrix2[][] = new int[rows][columns];

int sum[][] = new int[rows][columns];

System.out.println("Enter the elements of matrix1");

for (c = 0; c < rows; c++) {

for (d = 0; d < columns; d++) {

matrix1[c][d] = in.nextInt();

}

System.out.println("Enter the elements of matrix2");

for (c = 0; c < rows; c++) {

for (d = 0; d < columns; d++) {

matrix2[c][d] = in.nextInt();

}

for (c = 0; c < rows; c++) {

for (d = 0; d < columns; d++) {

sum[c][d] = matrix1[c][d] + matrix2[c][d];

}

System.out.println("Sum of entered matrices:");

for (c = 0; c < rows; c++) {

for (d = 0; d < columns; d++) {

System.out.print(sum[c][d] + "\t");

}

System.out.println();

}

Write a program to find that given number is Armstrong or not.

April 18, 2017 admin

package demo;

public class Demo {

    public static boolean isArmstrongNumber(int number) {
        int tmp = number;
        int noOfDigits = String.valueOf(number).length();
        int sum = 0;
        int div = 0;
        while (tmp > 0) {
            div = tmp % 10;
            int temp = 1;
            for (int i = 0; i < noOfDigits; i++) {
                temp *= div;
            }
            sum += temp;
            tmp = tmp / 10;
        }
        if (number == sum) {
            return true;
        } else {
            return false;
        }
    }

    public static void main(String[] args) {
        int n = 1634;
        System.out.println(isArmstrongNumber(n));

    }
}

package demo;

public class Demo {

public static boolean isArmstrongNumber(int number) {

int tmp = number;

int noOfDigits = String.valueOf(number).length();

int sum = 0;

int div = 0;

while (tmp > 0) {

div = tmp % 10;

int temp = 1;

for (int i = 0; i < noOfDigits; i++) {

temp *= div;

}

sum += temp;

tmp = tmp / 10;

}

if (number == sum) {

return true;

} else {

return false;

}

public static void main(String[] args) {

int n = 1634;

System.out.println(isArmstrongNumber(n));

}