Home Tutorial Php Phpdatabase PHP Database

 
 

Share on Google+Share on Google+
PHP Database
Posted on: October 31, 2009 at 12:00 AM
Advertisement
PHP Database: In this tutorial you will get to know about databases, tables, query and other related things like how to access databases using PHP etc. This is the first index page of this tutorial

PHP Database Creation

A simple website is made of the following technologies:

i)    HTML/CSS: HTML & CSS is used to get the user interfaces, and a pretty look for the web site.

ii)    PHP: PHP processes the forms and other dynamic wizardry.

iii)    Database: We need to store several data e.g.- user list, product information etc. There are different databases are available in market, we need to choose any specific database according to our need.

Many more technologies could be used in web site development like: JavaScript etc. for validation checking.

Now in this tutorial you will get to know about databases, tables, query and other related things like how to access  databases using PHP etc.

Database: In general a database is a collection of  logically related files or records. A database could be a pile of structured information, a program (e.g. MySQL, or Oracle) which manages those structured information, or the computer on which the program runs.

Table: Table is a collection of rows and columns. Columns keep only one specific (e.g. First-Name, Last-Name, Age etc. ) data where rows are the collection of columns (e.g. Sachin, Tendulkar, 37 etc.). Tables store data in a grid like pattern of columns and rows.

Query: In database a query is a set of specific words which are collectively used to retrieve the desired information.

In the following PHP Database tutorial we will study various things of PHP Database, like:

A)   MySQL

    i)    Downloading and installing MySQL server.

    ii)    Creating Database

    iii)    Creating Table

    iv)    Inserting Information

    v)    Retrieving Values

 

PHP Create Database
PHP Create Database: In this tutorial you will get to know about how to create database in PHP, using WAMP server, and MySQL console.
 
PHP How to Create Table
PHP How to Create Table: In this PHP tutorial you will get to know about how to create table using WAMP server and MySQL console.
 
PHP Insert Value
PHP Insert Value: In this tutorial you will get to know about how to insert values into a table, using both mysql console and phpmyadmin user interface. Images will guide you through necessary steps to insert values into a table.
 
Check PHP MySQL Connectivity
Check PHP MySQL Connectivity: In this tutorial you will get to know about the connectivity of PHP and MySQL server. It also describes about the predefined objects which helps us to connect with the server.
 
PHP MySQL Login Form
PHP MySQL Login Form: In this tutorial you will know that how to create a login form in html coding and how to connect with mysql server using PHP coding. This is a fundamental example of PHP n MySQL connectivity and it is used in almost every website for login purpose.
 
PHP MySQLI Prep Statement
In the current tutorial we will study how to create prepared statement in mysql and how to retrieve values using mysqli::prepare, mysqli::prepare - Prepares a SQL query and returns a statement handle to be used for further operations on the statement. The query should consist of a single sql query.
 
Advertisement

Related Tags for PHP Database:


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: October 31, 2009

Recommend the tutorial

Advertisements Advertisements
 

 

 

DMCA.com