steps to create first php web page

Steps to Create first PHP Document

PHP Tags

<?php

echo "hello this is pakistan";

?>

save following file as Connction.php
connecting to mysql server and database

<?php
$servername="localhost";

$userName="root";

$Password="root";

$dbName="myDatabase";

// First connect to localhost on your computer
mysql_connect($serverName, $userName,$Password);

// second select your database
mysql_select_database($dbName);

Entering Values in Database

oK, you have saved previous code as "Connection.php"
now here is the code to Data Entry in PHP

Inserting data in mysql table

<? include ("Connection.php");
$query="insert into info(name,age,sex) values ('imran zafar','45','Male')";
if(mysql_query($query))
{
echo " Congratulations ! Query has been successfully executed";
}
else
   {
   echo " Sorry ! there has been some error in executing the query";
   }

?>

Retrieving Values from mysql Table in PHP

Retrieving mysql table

<? include ("Connection.php");
$query="select * from info";
$result=mysql_query($query);
while($rs=mysql_fetch_array($result))
{
echo "Name= ". $rs['name']."<br>";
echo "Age= " . $rs['age']."<br>";
echo "Sex= ". $rs['sex'];"<br>"
}


That's it, it will print all the values from info table