Posts

Showing posts from November, 2021
-
Display record from database in table form using PHP To display record we are going to use select query to fetch record from database. It will show record in table form. Syntax :     "SELECT * FROM Table_name" Below is code to display record. It is retrive.php <!--Display record from database --> <! DOCTYPE html > < html > < head >     < title > retrive data from database </ title > </ head > < body > <?php $conn = new mysqli ( 'localhost' , 'root' , '' , 'vibha' );         $data = " SELECT * FROM registration " ;     $result = mysqli_query ( $conn , $data ); ? > < table border = "1" width = "600" >     < tr >         < th > id </ th >         < th > FirstName </ th >         < th > LastName </ th >         < th > Email </ th > ...
Post a Comment
Read more
-
Update and Save data in database using PHP To update record in database initially we need to add edit button in html form. Edit button helps you to edit record in database. Here we need  html form which provide field to edit data. We have first select particular record from database and fetch in html form after that only we can edit record. Database query to get record in html form is as follow: Syntax is here:     "SELECT * FROM Table_name WHERE Clause Condition"   Below we have code to edit data in html form in edit.php file: <!--php form execution--> <?php     $conn = new mysqli ( 'localhost' , 'root' , '' , 'vibha' );     if ( isset ( $_GET [ 'id' ]))     {         $id = $_GET [ 'id' ];         $query = " SELECT * FROM registration WHERE id = ' $id ' " ;         $result = mysqli_query ( $conn , $query );                 ...
Post a Comment
Read more
-
Delete data from database in PHP Initially we need to add delete button in our form by adding HTML code in form as follows:     <input type="submit" name="submit" value="detele"> Lets learn how to delete record from  database using delete button in html form. In this section we are going use DELETE query to delete data from mysql database.  Syntax for deleting data from database:     "DELETE FROM table_name"  above query is used to delete table from database. Incase you want to delete particular record or row from database, we need to use WHERE clause usually primary key column. Syntax :     "DELETE FROM table_name WHERE Column_name(primary key)"   Below we have code for deleting record from database. delete.php file code as follow: <?php $conn = new mysqli ( 'localhost' , 'root' , '' , 'vibha' ); if ( isset ( $_GET [ 'del' ])) {     $id = $_GET [ 'del' ];     $query = "...
Post a Comment
Read more
-
 SignUp form code in PHP     Here we are going to learn how to design and code for signup . We are going to code in a simple way to get achieve our final result. In signup form we are going to learn and implement how to use "INSERT " query in mysql database. This query is used to insert data in database. Syntax for INSERT query in database is as follows:    " INSERT INTO table_name (column_name1, column_name2........) VALUES(value1,value2,.......) " In below mentioned code table_name is "login" . It contain column with name as show in our html form. They are UserId, Password, Name, Address, MobileNo . We have 5 field in our mysql database.    Welcome to SignUp Form UserId Password Name Address MobileNo First we are going to design signup form . It is signup.html  <! DOCTYPE html > < html > < head >     < title > Signup form </ title > </ head > < body >     < h1 > Welc...
Post a Comment
Read more
-
 PHP Programming PHP is open source programming language. It is server-side scripting language. It is used to handle back-end issues in website. It is used in many website for establishing client - server relationship. It is used for handling database query. Lets learn how to create login form  and its functionality. In login form application we are going to learn how to validate form using database query. Here we are going to use SELECT query with WHERE condition to check valid user. Welocme to login form UserId Password   New User SignUp Here...  HTML code for login form. lofin.html file contain following code: <!DOCTYPE html> <html> <head><title>Login Form</title></head> <body> <h1>Welcome to login form</h1> <form action="login.php"  method="POST"> <h1>Welcome to login form</h1> UserId<input type ="text" name="UserId"><br><br> password<input type=...
Post a Comment
Read more