Saturday, August 31, 2013

EMBEDDING PHP

Example: 1

<?php

echo "Alex";

?>

Example: 2


<?php

echo "<b>Alex</b>";

?>


Example: 3

<html>

<b>
<?php

echo "Alex";

?>
</b>
</html>


Example: 4

<html>

<u>
<?php

echo "Alex";

?>
</u>
</html>


Example: 5

<html>

<input type='text' name='name' value='Alex' >

</html>


Example: 6

<html>

<input type='text' name='name' value='Alex'>

</html>


Example: 7

<html>

<input type='text' name='name' value='<?php echo"Alex"; ?>'>

</html>

Example:8

<html>

<input type='text' name='name' value='<?php echo $_GET['name']; ?>'>

</html>


Example:9

<html>

<input type='text' name='name' value='<?php echo phpinfo(); ?>'>

</html>

Friday, August 30, 2013

POST VARIABLE

Example: 1

<html>

<form action='GET_Variable_1.php' method='POST'>
<input type='text' name='myname' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$name =$_POST['myname'];
if ($name)
echo "Hellow, $name."
?>

</html>

Example: 2

<html>

<form action='POST_Variable_1.php' method='POST'>
<input type='text' name='myname' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$name =$_POST['myname'];
if ($name)
echo "Hellow, $name."
?>

</html>


Example: 3

<html>

<form action='POST_Variable_3.php' method='POST'>
<input type='password' name='password' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$name =$_POST['password'];
if ($name)
echo "Thanks for your password."
?>

</html>


Example: 4

<html>

<form action='POST_Variable_4.php' method='POST'>
<input type='password' name='password' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$password =$_POST['password'];
if ($name)
echo "Thanks for your password. $password"
?>

</html>


Example: 5

<html>

<form action='POST_Variable_5.php' method='POST'>
<input type='password' name='password' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$password =$_POST['password'];
if ($password)
echo "Thanks for your password. $password"
?>

</html>

Thursday, August 29, 2013

FUNCTION (ADVANCED)

Example: 1

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
break;

case "-";
$total = $num1 - $num2;
break;

case "*";
$total = $num1 * $num2;
break;


case "/";
$total = $num1 / $num2;
break;

default:
echo "Unknown operator.";

}
}

?>


Example: 2

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
break;

case "-";
$total = $num1 - $num2;
break;

case "*";
$total = $num1 * $num2;
break;


case "/";
$total = $num1 / $num2;
break;

default:
echo "Unknown operator.";

}

calc(10,10,"+");

}

?>


Example: 3

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
break;

case "-";
$total = $num1 - $num2;
break;

case "*";
$total = $num1 * $num2;
break;


case "/";
$total = $num1 / $num2;
break;

default:
echo "Unknown operator.";

}

echo calc(10,10,"+");

}

?>

Example: 4

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
return $total;
break;

case "-";
$total = $num1 - $num2;
return $total;
break;

case "*";
$total = $num1 * $num2;
return $total;
break;


case "/";
$total = $num1 / $num2;
return $total;
break;

default:
echo "Unknown operator.";

}

echo calc(10,10,"+");

}

?>

Example: 5

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
return $total;
break;

case "-";
$total = $num1 - $num2;
return $total;
break;

case "*";
$total = $num1 * $num2;
return $total;
break;


case "/";
$total = $num1 / $num2;
return $total;
break;

default:
echo "Unknown operator.";

}


}
echo calc(10,10,"+");

?>


Example: 6

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
return $total;
break;

case "-";
$total = $num1 - $num2;
return $total;
break;

case "*";
$total = $num1 * $num2;
return $total;
break;


case "/";
$total = $num1 / $num2;
return $total;
break;

default:
echo "Unknown operator.";

}


}
echo calc(13,7,"/");

?>


Example:7

<?php

function calc($num1, $num2, $op)
{
switch ($op)
{
case "+";
$total = $num1 + $num2;
return $total;
break;

case "-";
$total = $num1 - $num2;
return $total;
break;

case "*";
$total = $num1 * $num2;
return $total;
break;


case "/";
$total = $num1 / $num2;
return $total;
break;

default:
echo "Unknown operator.";

}

}
echo calc(13,7,"a");

?>

GET VARIABLE

Example: 1

<?php

echo $_GET['myname'];

?>


Example: 2

<html>

<form action='get.php' method='GET'>
<input type='text' name='myname' ><br />
</form>

</html>


Example: 3

<html>

<form action='GET_Variable_3.php' method='GET'>
<input type='text' name='myname' ><br />
<input type='submit' value='Click here' />
</form>

</html>


Example: 4

<html>

<form action='GET_Variable_4.php' method='GET'>
<input type='text' name='myname' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$name =$_GET['myname'];
echo "Hellow, $name."
?>

</html>


Example: 5

<html>

<form action='GET_Variable_4.php' method='GET'>
<input type='text' name='myname' ><br />
<input type='submit' value='Click here' />
</form>

<?php
$name =$_GET['myname'];
if ($name)
echo "Hellow, $name."
?>

</html>

Wednesday, August 28, 2013

FUNCTIONS (BASICS)


Example: 1

<?php

function myname()
{
echo "Alex";

?>


Example: 2

<?php

function myname()
{
echo "Alex";
myname();

?>


Example: 3

<?php

function myname()
{
echo "Alex";
echo "<br>";
echo "New line";
myname();

?>

Example: 4

<?php


function myname()
{
echo "Alex";

echo "My name is".myname();

?>


Example: 5

<?php

function myname()
{
echo "Alex";

echo "My name is myname();";

?>

Example: 6

<?php

function myname()
{
echo "Alex";

echo "My name is ";
myname();

?>


Example:7

<?php

echo "My name is ";
myname();

function myname()
{
echo "Alex";

?>


Example:8

<?php

function yourname($name)
{
echo "Your name is".$name;

yourname("Alex");

?>


Example:9

<?php

function yourname($name)
{
echo "Your name is".$name;

yourname("Billy");

?>


Example:10

<?php

function yourname($name, $age)
{
echo "Your name is ".$name." and you are ".$age." years old ";

yourname("Billy", 14);

?>


Example:11

<?php

function yourname($name, $age)
{
echo "Your name is ".$name." and you are ".$age." years old ";

yourname("Alex", 19);

?>

Monday, August 26, 2013

FOR STATEMENT

Example: 1

<?php

$num =1;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=10)
$name = "Billy";
}
while ($name=="Alex")


?>


Example: 2


<?php

$num =0;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=11)
$name = "Billy";
}
while ($name=="Alex")


?>


Example: 3

<?php

$num =1;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=11)
$name = "Billy";
}
while ($name=="Alex")


?>

FOREACH STATEMENT

Example: 1

<?php

$numbers = array(1,2,3,4,5,6,7,8,9,10);

foreach($numbers as $value)
{
echo $value."<br>";
}
?>


Example: 2

<?php

$numbers = array(1,2,3,4,5,6,7,8,9,10);
$multiple =2;

foreach($numbers as $value)
{
echo "$value times 2 is".($value * $multiple)."<br>";
}
?>


Example: 3

<?php

$numbers = array(1,2,3,4,5,6,7,8,9,10);
$multiple =10;

foreach($numbers as $value)
{
echo "$value times 2 is".($value * $multiple)."<br>";
}
?>


Example: 4

<?php

$numbers = array(1,2,3,4,5,6,7,8,9,10);
$multiple =10;

foreach($numbers as $value)
{
echo "$value times $multiple is ".($value * $multiple)."<br>";
}
?>

Example: 5

<?php

$numbers = array(1,2,3,4,5,6,7,8,9,10);
$multiple =12;

foreach($numbers as $value)
{
echo "$value times $multiple is ".($value * $multiple)."<br>";
}
?>

Sunday, August 25, 2013

DO WHILE LOOP

Example: 1

<?php

$num =1;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=10)
$name = "Billy";
}
while ($name=="Alex")


?>


Example: 2


<?php

$num =0;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=11)
$name = "Billy";
}
while ($name=="Alex")


?>


Example: 3

<?php

$num =1;
$name = "Alex";

do
{
echo $num."<br>";
$num++;

if ($num >=11)
$name = "Billy";
}
while ($name=="Alex")


?>

Saturday, August 24, 2013

WHILE STATEMENT

Example: 1

<?php

while(1==1);
{
  echo "Loop<br>";
}

?>


Example: 2


<?php

$num =1;
while($num<=10);
{
  echo "Loop<br>";
  $num = $num+1;
}

?>


Example: 3

<?php

$num =1;
while($num<=10);
{
 echo "Loop $num <br>";
  $num = $num+1;
}

?>


Example: 4

<?php

$num =1;
while($num<=100);
{
  echo "Loop $num <br>";
  $num = $num+1;
}

?>


Example: 5

<?php

$num =1;
while($num<=6000);
{
  echo "Loop $num <br>";
  $num = $num+1;
}

?>


Example: 6

<?php

$num =1;
max =10;

while($num<=$max);
{
 echo "Loop $num <br>";
  $num = $num+1;
}

?>


MULTI DIMENSION ARRAYS

Example: 1

<?php

$alpha = array

(

"ABC"=>array("A","B","C","D"),
"123"=>array("1","2","3","4")

);

echo $alpha['ABC'][0];

?>


Example: 2

<?php

$pos = 0;
$alpha = array

(

"ABC"=>array("A","B","C","D"),
"123"=>array("1","2","3","4")

);

echo "Letter ". $alpha['ABC'][$pos]."is in position ".$alpha['123'][$pos];

?>


Example: 3

<?php

$pos = 1;
$alpha = array

(

"ABC"=>array("A","B","C","D"),
"123"=>array("1","2","3","4")

);

echo "Letter ". $alpha['ABC'][$pos]."is in position ".$alpha['123'][$pos];

?>


Example: 4

<?php

$pos = (1)-1;
$alpha = array

(

"ABC"=>array("A","B","C","D"),
"123"=>array("1","2","3","4")

);

echo "Letter ". $alpha['ABC'][$pos]."is in position ".$alpha['123'][$pos];

?>


Example: 5

<?php

$pos = (0)-1;
$alpha = array

(

"ABC"=>array("A","B","C","D"),
"123"=>array("1","2","3","4")

);

echo "Letter ". $alpha['ABC'][$pos]."is in position ".$alpha['123'][$pos];

?>

Friday, August 23, 2013


ARRAYS

Example: 1

<?php
$days = array("Monday","Tuesday","Wednesday","Thursday","Friday");
echo $days;
?>

Example: 2

<?php
$days = array("Monday","Tuesday","Wednesday","Thursday","Friday");
echo $days[0];
?>


Example: 3

<?php
$days = array("Monday","Tuesday","Wednesday","Thursday","Friday");
echo $days[4];
?>

Example: 4

<?php
$days = array
(
"Monday",
"Tuesday",
"Wednesday",
"Thursday",
"Friday"
);
?>

Example: 5

<?php
$days = array("Monday","Tuesday","Wednesday","Thursday","Friday");
echo "Today is $days[0]";
?>


Example: 6

<?php
$ages = array("Alex"=>19,"BIlly"=>14,"Kyle"=>18);
echo $ages['Alex'];
?>


Example: 7

<?php
$ages = array("Alex"=>19,"Billy"=>14,"Kyle"=>18);
echo $ages['Billy'];
?>

Example: 8

<?php
$ages = array(1=>"Alex", 2=>"BIlly");
echo $ages[1];
?>

Thursday, August 22, 2013

How To Delete Data Into Database

How to Fetching Data From Database

Create a file Fetch with the coding:


<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("table", $con);

$result = mysql_query("SELECT * FROM student");

echo "<table border='1'>
<tr>
<th>name</th>
<th>class</th>
<th>rollno</th>

</tr>";

while($row = mysql_fetch_array($result))
  {
  echo "<tr>";
  echo "<td>" . $row['name'] . "</td>";
  echo "<td>" . $row['class'] . "</td>";
  echo "<td>" . $row['rollno'] . "</td>";
  echo "</tr>";
  }
echo "</table>";

mysql_close($con);
?>
</body>
</html>


How To Update Data into Database








1.Make a File config.php
<?php
error_reporting(0);
$con = mysql_connect("localhost","root","");
mysql_select_db("table");
?>

2.Create a file fetchdata.php


<?php
include("config.php");
$select = mysql_query("select * from student");
?>
<table border="2">
<tr>
<td>name</td>
<td>class</td>
<td>rollno</td>
<td colspan="2">Operation</td>
</tr>
<?php
while($row=mysql_fetch_array($select))
{
?>
<tr> <td> <?php echo $row['name']."<br>"; ?> </td>
<td> <?php echo $row['class']."<br>"; ?> </td>
<td> <?php echo $row['rollno']."<br>"; ?> </td>

<td> <a href="edit.php?id=<?php echo $row['id']?>&name=<?php echo $row['name']?>&class=<?php echo $row['class']?>&rollno=<?php echo $row['rollno']?>">Edit </a> </td>
</tr>
<?php
}
?>

3.Create a File edit.php


<?php
$id=$_REQUEST['id'];
$name=$_REQUEST['name'];
$class=$_REQUEST['class'];
$rollno=$_REQUEST['rollno'];
?>

<form action="update.php" method="get">
<table border="2">
<tr><td>name</td>
<td>class</td>
<td>rollno</td>

</tr>

<tr>
<input type="hidden" name="id" value="<?php echo $id; ?>" >
<td><input type="text" name="name" value="<?php echo $name; ?>" ></td>
<td><input type="text" name="class" value="<?php echo $class; ?>" ></td>
<td><input type="text" name="rollno" value="<?php echo $rollno; ?>" ></td>
</tr>

<tr>
<td colspan="3" align="center"><input type="submit" ></td>
</tr>

</table>
</form>

4. Create a File update.php
<?php
include("config.php");

$id=$_GET['id'];
$name=$_GET['name'];
$class=$_GET['class'];
$rollno=$_GET['rollno'];

if(!empty($name))
{
$update=mysql_query("update student set name='$name' where id='$id'");
}

if(!empty($class))
{
$update=mysql_query("update student set class='$class' where id='$id'");
}

if(!empty($rollno))
{
$update=mysql_query("update student set rollno='$rollno' where id='$id'");
}

header("location:fetchdata.php");

?>

5. Create Database in Server:


Database name: table
table name : student
column name:id,name,class,rollno






How To Insert Data into Database

1.Make a File header.php with the Code

<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("college", $con);

$sql="INSERT INTO student (name, rollno, class)
VALUES
('$_POST[name]','$_POST[rollno]','$_POST[class]')";

if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";

mysql_close($con);
?>
</body>
</html>

2. Create a File table.php with the code:

<html>
<head>
<title>Untitled Document</title>
</head>
<body>
<form action="header.php" method="post">
name: <input type="text" name="name" />
class: <input type="text" name="class" />
rollno: <input type="text" name="rollno" />
<input type="submit" />
</form>
</body>
</html>




3.Create Database in Server:

Database name: table
table name : student
column name:name,class,rollno

How To Create Database In PhpMyadmin








Example: 1

In this tutorial fully explained about Mysql Database Connection, so for that i have
created the connection.php file for connecting the databse.


connection.php

<?php

error_reporting(0);
$connect = mysql_connect("localhost", "root", "") or die(mysql_error());


mysql_select_db("phpacademy") or die(mysql_error());

echo "Connected Succesfully!.<br><br>";


?>


Example: 2


member.php


<?php

session_start();

if($_SESSION['username'])
echo "Welcome, " .$_SESSION['username']."!<br><a href='logout.php'>Logout</a><br> ";
else
die ("You must be logged in!");

?>

How to create the Database and Table






Example: 1


connection.php


Example: 2


member.php


<?php

session_start();

if($_SESSION['username'])
echo "Welcome, " .$_SESSION['username']."!<br><a href='logout.php'>Logout</a><br> ";
else
die ("You must be logged in!");

?>


LOGICAL OPERATOR

Example: 1

<?php

if(1 > 1)
{
echo "True";
}

else
{
echo "False";
}

?>


Example: 2


<?php

if( 1 > 1 || 1==1 )
{
echo "True";
}

else
{
echo "False";
}

?>



Example: 3


<?php

if( 1 > 1 && 1==1 )
{
echo "True";
}

else
{
echo "False";
}

?>


Example: 4


<?php

if( 1 >= 1 && 1==1 )
{
echo "True";
}

else
{
echo "False";
}

?>



Example: 5


<?php

$username = "alex";
$password = "abc";
if( $username && $password )
{
echo "Ok.";
}

else
{
echo "You forgot to fill out a Field.";
}

?>



Example: 6


<?php

$username = "alex";
$password = "";

if( $username && $password )
{
echo "Ok.";
}

else
{
echo "You forgot to fill out a Field.";
}

?>


Example: 7

<?php

$username = "alex";
$password = "";

if( $username )
{
echo "Ok.";
}

else
{
echo "You forgot to fill out a Field.";
}

?>


Example: 8

<?php

$username = "alex";
$password = "";

if( $username || $password )
{
echo "Ok.";
}

else
{
echo "You forgot to fill out a Field.";
}

?>



Example: 9


<?php

$username = "";
$password = "";

if( $username || $password )
{
echo "Ok.";
}

else
{
echo "Nothing.";
}

?>

Wednesday, August 21, 2013

COMPARISON OPERATOR

Example: 1

<?php

if(1==1)
echo "True";
else
echo "False";

?>


Example: 2


<?php

if(1>1)
echo "True";
else
echo "False";

?>


Example: 3

<?php

if(1>=1)
echo "True";
else
echo "False";

?>



Example: 4

<?php

if(1<1)
echo "True";
else
echo "False";

?>



Example: 5

<?php

if(1<=1)
echo "True";
else
echo "False";

?>


Example: 6

<?php

if(1!=1)
echo "True";
else
echo "False";

?>


Example: 7

<?php

if(1!=2)
echo "True";
else
echo "False";

?>


Example: 8

<?php

$num1=1;
$num2=2;

if(num1 != num2)
echo "True";
else
echo "False";

?>

Example: 9

<?php

$num1=1;
$num2=1;

if(num1 != num2)
echo "True";
else
echo "False";

?>

Tuesday, August 20, 2013

AIRTHMETIC OPERATORS

Example: 1

<?php
$num1 = 10;
$num2 = 2;

echo $num1 + $num2;
?>

Example: 2

<?php
$num1 = 10;
$num2 = 2;
echo $num1 - $num2;
?>

Example: 3

<?php
$num1 = 10;
$num2 = 2;
echo $num1 / $num2;
?>

Example: 4

<?php
$num1 = 10;
$num2 = 2;
echo $num1 + $num2 / $num2;
?>

Example: 5

<?php
$num1 = 10;
$num2 = 2;
echo ($num1 + $num2) / $num2;
?>