MySQL Database

MySQL Database Tutorial-php class for mysql database manipulation

Here, this is a php class for manipulating mysql database and executing queries. For beginners this very useful. Include this file in your project and call this class by creating object. Here is class : <?php class Db { protected ...



READ MORE...


MySQL Database Tutorial-php mysql_fetch_row

In php mysql_fetch_row() function returns result in a numerical array corresponding to the fetched rows.Offset 0,1 and 2 etc. are used for first column,2nd column and 3rd column etc. respectively.If there are no rows it returns FALSE.As in example w ...



READ MORE...


MySQL Database Tutorial-php mysql fetch array

In php mysql_fetch_array() function returns result in array corresponding to the fetched rows,if there are no rows it returns FALSE.As in example we have table employees in mysql database. id first_name ...



READ MORE...


MySQL Database Tutorial-Php form for inserting records in mysql table

For inserting records with php in mysql table, we need html form, at least one table in mysql. So according to our need, make table with name employees which has three fields id,first_name and lastname as: Create Table employees ( id int NOT NUL ...



READ MORE...


MySQL Database Tutorial-Create table in mysql with php

Before doing anything with mysql database we need at least one table in our database.Here we are going to make table with name employees.For making table decide about the fields of table. Here for table employees four fields are decided and for that ...



READ MORE...


MySQL Database Tutorial-My sql connection in php

Untitled Document Making connection with mysql database in php is a very easy job.In php mysql_connect() function opens connection , It takes at least three arguments host (here localhost ), username and password.First argument is h ...



READ MORE...