How to Connect to Mysql Database

To access the database tables from mysql you need to make connection with database. To complete this task you can use mysql_connect() function.

To do this in php language through. Choose your favorite Editor (Note Pad, Dreamweaver etc) then create a php file called connect.php. Now Inside connect.php file you apply below written codes.

Example :

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Not Successful Connected to Database ' . mysql_error());
  }

// Here is your codes Like Display Information from Database or Edit information etc.

?>

Now you saw the codes where $con is a connection variable which hold the all connection information. In mysql_connection() a localhost is server name that show above script run on local server and next two places are username and password where root is default username of mysql and password is by default null. If condition check the if variable $con hold not hold right information about connection then display message “Not Successful Connected to Database”. Next part is where you write your own script codes for data manipulation.

Read More

Insert Data Using Php Mysql

For this, you are going to need to login to a MySQL server administration, such as ‘phpmyadmin‘. Contact your server host for more details. Copy and paste the follow MySQL code into your query panel. This show generate a database table called ‘my_table‘.

CREATE TABLE `my_table` (
`id` int(6) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default ”,
`email` varchar(255) NOT NULL default ”,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Build an HTML form to collect data

This takes us a little away from PHP and MySQL and back to simple HTML. Copy and paste the following into a document and label it as ‘add.php‘.

<form id=”FormName” action=”added.php” method=”post” name=”FormName”>
<table width=”448″ border=”0″ cellspacing=”2″ cellpadding=”0″>
<tr>
<td width = “150″ align=”right”><label for=”name”>Name</label></td>
<td><input id=”name” name=”name” type=”text” size=”25″ value=”" maxlength=”255″></td>
</tr><tr>
<td width = “150″ align=”right”><label for=”email”>E-mail</label></td>
<td><input id=”email” name=”email” type=”text” size=”25″ value=”" maxlength=”255″></td>
</tr><tr>
<td width=”150″></td>
<td>
<input type=”submit” name=”submitButtonName” value=”Add”></td>
</tr></table>
</form>

Capturing the form data with PHP

Now we need to capture the data sent via the form into a new page called ‘added.php‘ as specified within the top of our form. Add the following to ‘added.php‘. This page will now capture the to form item values of ‘name’ and ‘email’, as inputted by your visitor.

<?php
$name = $_POST['name']; /// Retrieve the value of ‘name’ from form
$email = $_POST['email'];/// Retrieve the value of ‘email’ from form
?>

Connecting to your MySQL database

Modify the following code in order to connect to your MySQL database and database tables with PHP. Many servers use ‘local_host’ as the host connector. If you are unsure, ask your server host. Replace the above with the following (added.php)
 

<?php
// Connection to MySQL database table
$my_db = mysql_connect(’local_host’, ‘my_username’, ‘my_password’);
$sel3Q = mysql_select_db(’my_database_name’, $my_db);
//

$name = $_POST['name']; /// Retrieve the value of ‘name’ from form
$email = $_POST['email'];/// Retrieve the value of ‘email’ from form
?> 

Now you have opened a connection to your MySQL database ‘my_database_name‘.

Add the data to the MySQL database with PHP

We will now need to tell the PHP to add this data to our MySQL database table. We will modify the above code with the following (added.php).

<?php
// Connection to MySQL database table
$my_db = mysql_connect(’local_host’, ‘my_username’, ‘my_password’);
$sel3Q = mysql_select_db(’my_database_name’, $my_db);
//

$name = $_POST['name']; /// Retrieve the value of ‘name’ from form
$email = $_POST['email'];/// Retrieve the value of ‘email’ from form

/// Add it to the database
$query = “INSERT INTO my_table (id, name, email)
VALUES (”, ‘$name’, ‘$email’ )”; /// the value of ‘id’ is left blank as it is set to ‘auto_increment’
$results = mysql_query($query); /// Process the above
///

if ($results) /// If it worked echo statement
{
echo “Details added.”;
}
else /// If it didn’t worked echo statement
{
echo “Didn’t work!!!”;
}

mysql_close(); /// Close connection with MySQL database – recommended!
?> 

As you can see from the above, the communication with the MySQL is sent via a string ‘$query’. The string is then passed through mysql_query tosend the contents of that string to the MySQL for processing.

Read More

Display Mysql data using Php Tutorial

Our First tutorial based on Display data from mysql table. Using PHP you can run a MySQL SELECT query to fetch the data out of the database. You have several options in fetching information from MySQL. PHP provide several functions for this. The first one is mysql_fetch_array()which fetch a result row as an associative array, a numeric array, or both.

Below codes is to using display record from table. Paste above codes in your editors.

>".mysql_error());

//count how many records found
$num=mysql_num_rows($rs);

if($num>0){ //check if more than 0 record found

echo "";
//start table             
//creating our table heading         
echo " ";             
echo "";             
echo "";             
echo "";         
echo "";                 
//retrieve our table contents         while($row=mysql_fetch_array($rs)){             //extract row             
//this will make $row['firstname'] to             
//just $firstname only             
extract($row);                         
//creating new table row per record             
echo "";                 
echo "";                 
echo "";                 
echo "";             
echo "";         }     
echo "
Firstname
Lastname
Username
{$firstname}
{$lastname}
{$username}
";//end table
   
}else{ //if no records found
    echo "No records found.";
}
?>

Our output will look like:

Now That's we have done!

Read More