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;
?>