Posts

view,edit and delete using PHP & Mysql

Image
view,edit and delete using PHP & Mysql In this tutorial i will discuss how to do view,edit and delete using PHP & Mysql. In this code for viewing the data from database i.e Mysql i am using HTML table.First data will be configured into the HTML table from there data will be deleted and edited/Updated. So lets check the tutorial on view,edit and delete using PHP & Mysql part by part. So lets see the code for view from database ,save this php file as viewstudent.php /*In this tutorial edit and delete script will be interlinked with the view page*/ <?php $con=mysqli_connect("localhost","root","","youtube"); $query="select * from registration"; $sql=mysqli_query($con,$query); ?> <title>View Example</title> <p align="center">View Of Registration Details</p> <hr/> <table width="1264" height="150"  border="1" align="center...

Responsive Registration Form Using Bootstrap

Image
Responsive Registration Form Using Bootstrap In this tutorial we will learn how to create a responsive Registration form Using Bootstrap. In 2018, 52.2 percent of all website traffic worldwide was generated through mobile phones, up from 50.3 percent in the previous year . In India this picture is more encouraging,According to a report " Mobile phones contribute 79% of all web traffic in India " .So in this scenario it is very much important to create web content or web pages which are more user friendly.Here comes bootstrap to help the web developer. Check the code for " Responsive Registration Form In HTML ". <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <!-- Latest c...

How to select data from mysql database using PHP

Image
In this tutorial we will learn how to select data from mysql database.First of all we need to connect to the database from which we will collect data.            $con=mysqli_connect("localhost","root","","youtube"); In the above code the root is the username of the mysql and the database name is "youtube".You can replace your database name in this portion.Now we will select data from database using select sql.        $query="select * from registration"; Here the table name is registration,the structure of the table is as follows:- Column Name Type rid int(11) name varchar(100) fathersname varchar(100) mothersname varchar(100) address varchar(200) email varchar(200) uname varchar(200),Primary Key password varchar(200) In the next step we will execute the query ,after execution we will get a result set.Now we will supply that result set to also mysqli_fetch_row(),which will fetch the rows fr...

Login Using Android

Image
In this tutorial you will learn to do login using Android studio.In this tutorial back end is developed using PHP and database is Mysql.In this tutorial volley is used as library. Lets check the code step by step. First Lets check the .XML code ,which we also discussed in the tutorial of " Simple Login App Design Using Android Studio ". The code is very simple ,here we are using Constrain layout and Relative layout . The code is as follows:- <?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout 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"    tools:context=".MainActivity">     <ImageView      android:id="@+id/i...

Random password Generator In PHP

Image
In this tutorial you will learn how to create a random password using PHP. This program can be helpful to suggest the users an auto generated random password.In this program we are using substr() method which will use str_shuffle() to create a password of the length which is supplied to the function pass1($len).The password length will be decided by the number which is supplied to the function.The code of the program is as below- <?php function pass1($len) { error_reporting(0); $charset="!@iloveindia%^&"; $password=substr(str_shuffle($charset),0,$len); return $password; } $newpassword=pass1(8); ?> <table> <tr> <td>Password</td> <td><?php echo $newpassword;?></td> <td><input type="button" name="b1" id="b1" value="New Password" onClick="window.location.reload()"/></td> </tr> </table> Copy this code and paste in your .php file...

Simple Login App Design Using Android Studio

Image
In this tutorial i am discussing regarding a simple login App design in Android.This is simple design for login page,so java coding is not included.Also you need some images which you can download easily from the internet. The code is very simple ,here we are using Constrain layout and Relative layout . The code is as follows:- <?xml version="1.0" encoding="utf-8"?> <androidx.constraintlayout.widget.ConstraintLayout 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"    tools:context=".MainActivity">     <ImageView      android:id="@+id/imageView"    android:layout_width="200dp"        android:layout_height="219dp"        android:layout_...

Insert data into database using Android,php & Mysql

Image
In this tutorial i will explain a simple way to insert  data into mysql database using Android,Php & Mysql.in this tutorial i use Volley library. Copy paste the below code in your XML file.Here i am using Linear layout,you can use any layout. <?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=".MainActivity"> <EditText android:id="@+id/editText" android:layout_width="match_parent" android:layout_height="wrap_content" android:ems="10" android:hint="Name" android:inputType...