Simple Programming

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 >         < th > MobileNo </ th >         < th > De

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 );                 $row = mysqli_fetch_array ( $result );     } ? > <!--edit form-->

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 = "

 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 > Welcome to SignUp Form </ h1 >     &l

 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="

About Computer Programming “ Computer programming  is an art, because it applies  accumulated knowledge  to the world, because it  requires skill and ingenuity,  and especially because  it produces objects of  beauty. A programmer who  subconsciously views himself  as an artist will enjoy what he  does and will do it better. ”            – Donald Knuth Wh at is programming language in computer science? programming programming is a way to express your ideas to computer in user understandable form. When these ideas where converted into some useful product, they need tool to deploy ideas. programming language programming language is a tool which help user to create things that need to implement their ideas. There are different programming language which are used to create project. They are as follows: 1) C  2) C++ 3) Java 4) . Net C# 5) PHP 6) Python  In present time python is most popular programming language. It is easy to learn and implement. So we are going  to learn and solve problem