PHP & MySQL Programming Basic to Advance

Example Code Here

<?php

$conect = mysqli_connect("localhost", "id21868673_root_imrans01", "123456Imran,", "id21868673_student_id_card") or die("Connection Failed");

if(mysqli_connect_errno()) {

    echo "Database Connection Failed <br>" . mysqli_connect_error();

} else {

    echo "Database connected successfully";

}

$sql = "INSERT INTO `student` (`ID`, `name`, `age`, `class`) VALUES (NULL, 'JUBAYER', '22', 'CSE')";

$result = mysqli_query($conect, $sql);

if($result) echo"<br>Data Insert Successefully";

else echo "Query Error";

?>

Instead of passing data directly, we pass it into a variable.

<?php

$conect = mysqli_connect("localhost", "id21868673_root_imrans01", "123456Imran,", "id21868673_student_id_card") or die("Connection Failed");

//*---->>>> Variable Diclearetion <<<<----*

$name = "Md Mosabbir";

$age = "25";

$class = "CVIL";

//*---->>>> Checking Condition <<<<----*

if(mysqli_connect_errno()) {

    echo "Database Connection Failed <br>" . mysqli_connect_error();

} else {

    echo "Database connected successfully";

}

//*---->>>> SQL Query <<<<----*

$sql = "INSERT INTO `student` (`ID`, `name`, `age`, `class`) VALUES (NULL, '$name', '$age', '$class')";

$result = mysqli_query($conect, $sql);

//*---->>>> SQL Query Check <<<<----*

if($result) echo"<br>Data Insert Successefully";

else echo "Query Error";

?>

Insert Data through PHP Links (PHP Header) ?

I will insert a key of the data with a question mark (?) after the PHP normal link and set its value after the equal (=) to sign. If I want to insert multiple data then I will use and sign (&) after the first data key and value and write a key and a value for the second data.

To insert data through PHP links, we need to change a little bit between variables. Shown below....

//*---->>>> Variable Diclearetion <<<<----*

$name = $_GET['n'];

$age = $_GET['a'];

$class = $_GET['c'];

Here,

n = name ,  a = age ,  c = class

Example Link:-

https://thispractice.000webhostapp.com/apps/hello.php?n=Name&a=13&c=Class%20Name

//*---->>>> Variable Diclearetion <<<<----*

$name = $_GET['n'];

$age = $_GET['a'];

$class = $_GET['c'];

//*---->>>> Checking Condition <<<<----*

if(mysqli_connect_errno()) {

    echo "Database Connection Failed <br>". mysqli_connect_error();

} else {

    echo "Database connected successfully";

}

//*---->>>> SQL Query <<<<----*

$sql = "INSERT INTO `student` (`ID`, `name`, `age`, `class`) VALUES (NULL, '$name', '$age', '$class')";

$result = mysqli_query($conect, $sql);

//*---->>>> SQL Query Check <<<<----*

if($result) echo"<br>Data Insert Successfully";

else echo "Query Error";

?>

Insert data into the Database 

Class 263: Insert data into the Database with Android 

https://thispractice.000webhostapp.com/apps/hello.php?n=Name&a=13&c=Class%20Name

String sName = Name.getText().toString();
String sMobile = mobile.getText().toString();
String sEmail = email.getText().toString();

String url = "https://thispractice.000webhostapp.com

/apps/database.php

?n="+sName+"&m="+sMobile+"&e="+sEmail;

XML Code:-

Important:

Manifest Internet Permission Token

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

Input This code  android:windowSoftInputMode ="adjustResize" Below your Activity

<activity
android:name=".MainActivity"
android:windowSoftInputMode="adjustResize"

</activity>

<?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"
android:background="@drawable/backg"
tools:context=".MainActivity">



<TextView
android:layout_width="wrap_content"
android:layout_height="90dp"
android:text="INPUT"
android:textColor="#2956FF"
android:textSize="45sp"
android:fontFamily="@font/poppins_semibold"
android:layout_marginTop="100dp"
android:padding="20dp"/>
<TextView
android:layout_width="wrap_content"
android:layout_height="wrap_content"
android:textColor="#6D94F9"
android:textSize="20sp"
android:text="YOUR DATA"
android:layout_marginLeft="25dp"
android:layout_marginTop="-10dp"/>



<com.google.android.material.textfield.TextInputLayout
style="@style/Widget.MaterialComponents.TextInputLayout.OutlinedBox"
android:layout_width="match_parent"
android:layout_marginLeft="20dp"
android:layout_marginRight="20dp"
android:layout_marginTop="40dp"
android:hint="Your Name"
app:endIconMode="clear_text"
app:counterEnabled="true"
app:counterMaxLength="20"
app:startIconDrawable="@drawable/person"
app:boxStrokeWidth="2dp"
android:keyboardNavigationCluster="true"
app:boxStrokeErrorColor="#FB1C00"
app:boxStrokeColor="#2956FF"
app:iconTint="#FF0D82FF"
android:layout_height="wrap_content">

<com.google.android.material.textfield.TextInputEditText
android:id="@+id/Name"
android:layout_width="match_parent"
android:layout_height="60dp"
android:padding="10dp"
android:textSize="20sp"
android:inputType="textPersonName"
android:textColor="@color/black"
android:maxLength="20" />
</com.google.android.material.textfield.TextInputLayout>

<com.google.android.material.textfield.TextInputLayout
style="@style/Widget.MaterialComponents.TextInputLayout.OutlinedBox"
android:layout_width="match_parent"
android:layout_marginLeft="20dp"
android:layout_marginRight="20dp"
android:layout_marginTop="5dp"
android:hint="Your Email"
app:endIconMode="clear_text"
app:counterEnabled="true"
app:counterMaxLength="30"
app:startIconDrawable="@drawable/baseline_email_24"
app:boxStrokeWidth="2dp"
app:boxStrokeErrorColor="#FB1C00"
app:boxStrokeColor="#2956FF"
app:iconTint="#FF0D82FF"
android:layout_height="wrap_content">

<com.google.android.material.textfield.TextInputEditText
android:id="@+id/email"
android:layout_width="match_parent"
android:layout_height="60dp"
android:padding="10dp"
android:textSize="20sp"
android:inputType="textEmailAddress"
android:textColor="@color/black"
android:maxLength="30" />
</com.google.android.material.textfield.TextInputLayout>

<com.google.android.material.textfield.TextInputLayout
style="@style/Widget.MaterialComponents.TextInputLayout.OutlinedBox"
android:layout_width="match_parent"
android:layout_marginLeft="20dp"
android:layout_marginRight="20dp"
android:layout_marginTop="5dp"
android:hint="Your Mobile"
app:endIconMode="clear_text"
app:counterEnabled="true"
app:boxStrokeWidth="2dp"
app:boxStrokeErrorColor="#FB1C00"
app:counterMaxLength="11"
android:preferKeepClear="true"
app:startIconDrawable="@drawable/baseline_add_ic_call_24"
app:boxStrokeColor="#2956FF"
app:iconTint="#0D82FF"
android:layout_height="wrap_content">

<com.google.android.material.textfield.TextInputEditText
android:id="@+id/mobile"
android:layout_width="match_parent"
android:layout_height="60dp"
android:padding="5dp"
android:gravity="center_vertical"
android:textSize="20sp"
android:inputType="number"
android:textColor="@color/black"
android:maxLength="11" />
</com.google.android.material.textfield.TextInputLayout>


<androidx.appcompat.widget.AppCompatButton
android:id="@+id/insertBtn"
android:layout_width="200dp"
android:layout_height="60dp"
android:layout_gravity="center_horizontal"
android:background="@drawable/ed_style"
android:textColor="@color/white"
android:textSize="16sp"
android:text="Insert Your data"
/>

<TextView
android:id="@+id/tvDisplay"
android:layout_width="match_parent"
android:layout_height="wrap_content"
android:textSize="18sp"
android:padding="10dp"
android:textColor="#041543"/>



</LinearLayout>

Java code:-

public class MainActivity extends AppCompatActivity {

TextInputEditText Name,mobile,email;
TextView tvDisplay;
AppCompatButton insertBtn;

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

Name = findViewById(R.id.Name);
mobile = findViewById(R.id.mobile);
email = findViewById(R.id.email);
tvDisplay = findViewById(R.id.tvDisplay);
insertBtn = findViewById(R.id.insertBtn);

insertBtn.setOnClickListener(new View.OnClickListener() {
@Override
public void onClick(View v) {
String sName = Name.getText().toString();
String sMobile = mobile.getText().toString();
String sEmail = email.getText().toString();
String url = "https://thispractice.000webhostapp.com/apps/database.php?n="+sName+"&m="+sMobile+"&e="+sEmail;

insertBtn.setText("Data Inserting..");
StringRequest stringRequest = new StringRequest(Request.Method.GET, url,
new Response.Listener<String>() {
@Override
public void onResponse(String response) {
insertBtn.setText("Data Inserted");
// Do something with the response
new AlertDialog.Builder(MainActivity.this)
.setTitle("Server Response")
.setMessage(response)
.show();
}
},
new Response.ErrorListener() {
@Override
public void onErrorResponse(VolleyError error) {
// Handle error
}
});

if (Name.length()>0 && mobile.length()>0&& email.length()>0){
RequestQueue requestQueue = Volley.newRequestQueue(MainActivity.this);
requestQueue.add(stringRequest);
}
else {
Toast.makeText(MainActivity.this,"Please Input Your Data",Toast.LENGTH_LONG).show();
new android.app.AlertDialog.Builder(MainActivity.this)
.setTitle("No Data Found!")
.setMessage("Please Re-try\nAnd Input Your Data")
.setIcon(R.drawable.baseline_error_outline_24)
.show();
insertBtn.setText("Data Insert Failed!");
}



tvDisplay.setText("Name : "+sName+"\n"+"Mobile : "+sMobile+"\n"+"Email : "+sEmail+"\n");


}
});

}
}

PHP Array & JSON

Can be written two ways

First:

<?php

$user_info ["name"] = "MD IMRAN HASAN";

$user_info ["mobile"] = "0145654454";

$user_info ["email"] = "imran@hs.com";

echo json_encode ($user_info);

?>

Second:

<?php

$user_info = array(

    "name" = "MD IMRAN HASAN",

    "mobile" = "0145654454",

    "email" = "imran@hs.com");

echo json_encode ($user_info);

?>

header php json

Array Create

<?php

$data = array();

header('Content-Type: application/json; charset=utf-8');

$user_info = array(

    "name" => "MD IMRAN HASAN",

    "mobile" => "0145654454",

    "email"=> "imran@hs.com");

array_push($data,$user_info );

$user_info = array(

    "name" => "MD SALMAN",

    "mobile" => "01514654454",

    "email"=> "sal@hs.com");

array_push($data,$user_info );

echo json_encode ($data);

?>

OUTPUT=>>

Get Data Form Data Base

 Get all Data from the Database with PHP  

<?php

$con = mysqli_connect("localhost","id21868673_root_me","MyDataBase02,","id21868673_my_database");

$sql = " SELECT * FROM user_database ";

$result = mysqli_query($con,$sql);

$rows = mysqli_num_rows($result);

echo "Total row found: " .$rows;

?>

Data Base From Data Load.

<?php

$con = mysqli_connect("localhost","id21868673_root_me","MyDataBase02,","id21868673_my_database");

$sql = " SELECT * FROM user_database ";

$result = mysqli_query($con,$sql);

$rows = mysqli_num_rows($result);

echo "Total row found: " .$rows;

foreach ($result as $item){

   

    $name = $item['name'];

    $mobile = $item['mobile'];

    $email = $item['email'];

   

    echo "<br><br>".$name."<br>".$mobile."<br>".$email;

    echo "<br><br>";

   

}

?>