Archive

Category Archives for "Databases"

How to export a database using PHPMyAdmin

How to export a database using PHPMyAdmin, If you are using PHPMyAdmin and want to export a database then navigate to PHPMyAdmin in hosting control panel or in localhost. Login to PHPMyAdmin and select the database which you want to export from left side column, after selecting database then it will show all the tables. […]

Continue reading
1

Creating Multistep form processing using PHP

Here we are Creating Multistep form processing using PHP. We are Creating Multistep form processing using PHP by using the sessions, in each step we are storing the data in sessions. We are generating sql query directly from data that is stored in sessions. Incoming search terms:php multi step form tutorialCreate Multi-step from phpcreate multiple step […]

Continue reading

SQL INSERT

The SQL INSERT statement allows you to insert a single record or multiple records into a table. This SQL statement can be used on any database either it is MySQL or MsSQL. The syntax for the SQL INSERT statement is:

Continue reading

SQL SELECT

The SQL SELECT statement allows you to retrieve records from one or more tables in your SQL database. For SQL SELECT statements can be used with WHERE clauses and also using relationship by joining tables. The result is stored in a result table, called the result-set.

Continue reading

SQL DELETE

SQL DELETE statement allows you to delete a single record or multiple records from a table or an entire records in a table. The syntax for the SQL DELETE statement is:

Continue reading

SQL UPDATE

The SQL UPDATE Query is used to modify the existing records in a table. You can use WHERE clause with UPDATE query to update selected rows otherwise all the rows would be effected.

Continue reading