PHP

Global Array:-

<h1> Predefine PHP Array </h1>

<?php
session_start();
# all these are global array
echo "<pre>";
print_r($_SESSION);
echo "<pre>";
 
    echo "<br>";
    echo "********COOKIE INFO********";
echo "<pre>";
print_r($_COOKIE);
echo "<pre>";

    echo "<br>";
    echo "********SERVER INFO********";

echo "<pre>";
print_r($_SERVER); // ask interview questions
echo "<pre>";

?>

************************************************************************
How to Insert the Data:-

<?php
$name = $_POST['fname'];
$mobile = $_POST['mobile'];
$msg = $_POST ['message'];
$pin = $_POST ['pincode'];
    $item = $_POST['item'];
    $myitem = implode(",",$item);

$conn = mysqli_connect("localhost", "root", "", "myphp");

# 1. server name, 2. username, 3. password, 4. database name

$mysql = "insert into mycontact(name,mobile,message,pincode,item)
values('$name','$mobile','$msg','$pin','$myitem')";

$status = mysqli_query($conn, $mysql);

if($status == true){
//echo "success";
header("Location:contactlist.php"); # this function redirect the saved data

}else{
//echo "fail";
header("Location:contact.php");
}

/**$at = $_POST;
echo "<br>";
print_r($at);
echo "</br>";**/
?>

***********************************************************************
How to Fetch Array Object:-

<?php
     
$conn = mysqli_connect("localhost", "root", "", "myphp");
$mysql = "select * from mycontact";
$res = mysqli_query($conn, $mysql); # holding the reference of data, object

while($row = mysqli_fetch_object($res)){

/**echo "<pre>";
print_r($row);
echo"</pre>";**/

echo "<tr>";

        echo "<td> $row->name </td>";
        echo "<td> $row->mobile </td>";
        echo "<td> $row->message </td>";
        echo "<td> $row->pincode </td>";
        echo "<td>";
            $item = explode(",",$row->item);
            for($i=0; $i<count($item); $i++){
                echo $item[$i]. "<br>";
            }
        echo "</td>";
echo "</tr>";

}
# this one is BEST
/**echo "<pre>";
print_r($row);
echo"</pre>";
**/



?>

************************************************************************
How to Delete the Data:-

echo "<td>
        <a href='delete.php?id=$row->id'> Delete </a>

        </td>";

<?php
$userid = $_REQUEST['id'];

include("dbconfig.php");

$sql = "delete from user where id='$userid'";

mysqli_query($conn, $sql);

header("Location:contactlist.php");


?>

**************************************************************************
How to Edit the Data:-

<?php
include("header.php");

include("dbconfig.php");

$userid = $_REQUEST['id'];

$sql = "select * from user where id = '$userid'";
$res = mysqli_query($conn, $sql);
$row = mysqli_fetch_object($res);


?>

<form method="POST" action="updateuser.php">
<table class="table table-bordered">
<caption> Edit User </caption>
<tr>
<th> Full Name </th>
<td>
<input type="text" name="fname" value="<?php echo $row->name; ?>">
</td>

</tr>

<tr>
<th> Mobile No. </th>
<td>
<input type="text" name="mobile" value="<?php echo $row->mobile; ?>">
</td>

</tr>

<tr>
<th> Email </th>
<td>
<input type="text" name="email" value="<?php echo $row->email; ?>">
</td>

</tr>

<tr>
<th> Password </th>
<td>
<input type="text" name="pass" value="<?php echo $row->password; ?>">
</td>

</tr>

<input type="hidden" name="userid" value="<?php echo $row->id; ?>">

<tr>
<th colspan="2" align="center">
<button class="btn btn-primary">Update </button>

</th>


</tr>

</table>

</form>





<?php
include("footer.php");

?>
====================================================================
Update:-
<?php

include ("dbconfig.php");
$userid = $_POST['userid'];

$name = $_POST['fname'];
$mobile = $_POST['mobile'];
$email = $_POST['email'];
$password = $_POST['pass'];


$sql = "update user set name ='$name',
mobile= '$mobile',
email = '$email',
password = '$password'
where id = '$userid' ";

$res = mysqli_query($conn, $sql);

if ($res=true){
header("Location:contactlist.php");
}else{

echo "Update fails";
}


?>
***************************************************************************
SESSION:
<?php
session_start();
if(!isset($_SESSION['id'])){
$_SESSION['msg'] = "Invalid User! ";
header("Location:index.php");
}

echo $_SESSION['name'];


?>

**************************************************************************

COOKIE:-

<?php
session_start();
if(!isset($_COOKIE['id'])){
$_SESSION['msg'] = "your session is expired! Please login ";
header("Location:index.php");
}

setcookie("name", $_COOKIE['name'], time()+60); // 60 seconds
setcookie("id", $_COOKIE['id'], time()+40);

echo $_SESSION['name'];



?>

***************************************************************************
How to Upload File:-
<html>
 <body>
<form action="upload.php" method="POST" enctype="multipart/form-data">
<center>
Select Any Image :
<input type="file" name="myfile"/>
<br>
<br>
<button type="submit"> Upload </button>
</center>
</form>
 </body>

 </html>
==================================================================
<?php

$filename = $_FILES['myfile']['name'];

$filesize = $_FILES['myfile']['size'];

$filetype = $_FILES['myfile']['type'];

$filetmpname = $_FILES['myfile']['tmp_name'];

echo $filename . "<br>";
echo $filesize . "<br>";
echo $filetype . "<br>";
echo $filetmpname . "<br>";

move_uploaded_file($filetmpname, "myfile/$filename");


include("dbconfig.php");

$sql = "insert into photo (photoname) values ('$filename')";

mysqli_query($conn,$sql);

header("Location:photolist.php");

?>
========================================================================
<html>
<head>
<link href="assets/css/bootstrap.css" rel="stylesheet">
<style>
.margin10{margin:10px;}
</style>

<head>
<body>
<br>
<div class="container">
<div class="row">
<div class="col-sm-12 text-center">
<a href="mydata.php" class="btn btn-primary "> New Photo </a>
</div>
</div>
<br>

<div class="row">
<?php

include("dbconfig.php");
$sql = "select * from photo order by id desc";
$res = mysqli_query($conn, $sql);

while($row = mysqli_fetch_object($res)){

echo "<div class='col-sm-3'>";
echo "<img src = 'myfile/$row->photoname' class='img-responsive img-rounded margin10'>";

echo "<center> <a href='deletephoto.php?id=$row->id'> Delete </a> </center>";

echo "</div>";
}

?>

</div>

</div>
</body>
</html>
========================================================================

<?php
include("dbconfig.php");
$photoid = $_REQUEST['id']; // id is variable comming through URL

$sql1 = mysqli_query($conn,"select * from photo where id = '$photoid'");
$row = mysqli_fetch_object($sql1);

$photoname = $row->photoname;


unlink("myfile/$photoname"); // to delete a fiel from folder

$sql = "delete from photo where id='$photoid'";

mysqli_query($conn, $sql);

header("Location:photolist.php");



?>


**************************************************************************
Login Body(cookies):

<body> <br>
<div class="container">
<div class="row">

<div class="col-sm-4"> </div>
<div class="col-sm-4">
<?php
session_start();
if(isset($_SESSION['msg'])){
echo $_SESSION['msg'];
unset($_SESSION['msg']);
}
?>
<form method="POST" action="loginchek.php">
<div class="panel panel-primary">
<div class="panel-heading"> Login </div>
<div class="panel-body">
<div class="form-group">
<label> Email </label>
<input type="text" name="email" class="form-control">

</div>

<div class="form-group">
<label> Password </label>
<input type="text" name="password" class="form-control">

</div>

<div class="form-group text-center">
<button class="btn btn-primary "> Login </button>
<hr>
<a href="signup.php"> I am new user </a>

</div>

</div> <!-- panel body end-->
</div> <!-- panel end-->

</form>
</div>
<div class="col-sm-4"> </div>

</div>

</div>


</body>
===================================================================
<?php
session_start();
include("dbconfig.php");
$email = $_POST['email'];
$password = $_POST['password'];

//echo $email;
//echo $password;



$sql = "select * from user where email='$email' and password='$password'";
$res = mysqli_query($conn, $sql);
$totaluser = mysqli_num_rows($res);

//echo $totaluser;

if($totaluser>0){
$row = mysqli_fetch_object($res);

$_SESSION['name']= $row->name; // 1440 seceonds 24 hours
$_SESSION['id']= $row->id;

setcookie("name", $row->name, time()+40); // 40 seconds
setcookie("id", $row->id, time()+40);

header("Location:home.php");
}else{
$_SESSION['msg'] = 'Sorry Invalid user';
header("Location:index.php");
}
?>

***************************************************************************

FILE MANAGEMENT

How create and delete a Folder/Directory:

<h1> Directry management </h1>
<?php

/*
if( file_exists("test"))
{
echo "Already one folder is available with same name";
}else{
mkdir("test");
echo "Folder created Successfully";
}
*/

 //how to delete a folder ?

  if( file_exists("test"))
  {
 rmdir("test");
 echo"Folder deleted successfully";
  }else{

 echo "Sorry, the are no any folder to delete";
  }
?>
=======================================================================
How to delete a variable:

<h1>Directory Management </h1>

<?php 
 $a = 100;
 echo "<hr>";

 unset($a);

 echo $a;


?>
========================================================================
How to create a New File:
<h1> Create a  New File using PHP </h1>

<?php 

$obj = fopen("abc.txt", "w");
fclose($obj);

echo "file created successfully!";


?>

========================================================================

How to write in a File:

<h1> Create a  New File using PHP </h1>

<?php

$obj = fopen("abc.txt", "w");

$data = "Hello My Test";

fwrite($obj, $data);

fclose($obj);

echo "file created successfully!";
echo "<br>";

?>

========================================================================

How to read a File:

<h1> Using 2 methods we can read data from a file </h1>

<?php

$obj = fopen("abc.txt", "r");

$data1 = fread($obj, 5000);

fclose($obj);

echo "<hr>";

echo $data1;

$data2 = file_get_contents("abc.txt");
// read all contents of a file at one time and store as a string

echo "<hr>";
echo "this is 2nd method";
echo "<br>";
echo $data2;
?>

========================================================================

How to delete a File:

h1> PHP unlink() used to delete a file </h1>

<?php
if(file_exists("abc.txt")){

unlink("abc.txt");
echo "File deleted successfully";
}else{

echo "There is no any file exists under current folder";
}
?>
========================================================================
DataBase to XML:

<?php
$conn = mysqli_connect("localhost", "root", "", "myproject");
$sql = "select * from user ";

$res = mysqli_query($conn, $sql);

$userdata = "";

while($row=mysqli_fetch_object($res)){

$userdata = $userdata . "<user>";

$userdata = $userdata . "<name> $row->name </name>";
$userdata = $userdata . "<mobile> $row->mobile </mobile>";
$userdata = $userdata . "<email> $row->email </email>";
$userdata = $userdata . "<password> $row->password </password>";

$userdata = $userdata . "</user>";
}
 $xml = "<?xml version='1.0' ?>";
 $xml = $xml . "<userlist>" . $userdata. "</userlist>";

 $filename = time() . ".xml";
 $obj = fopen("$filename", "w");

 fwrite($obj ,$xml);

 fclose($obj);

 echo "New XML file created!";
 echo "<a href='$filename'> Click here to open </a>";


?>
========================================================================
XML to DataBase:

<?php
$conn = mysqli_connect("localhost", "root", "", "myproject");
$xml = simplexml_load_file("1503568755.xml");

for($i=0; $i<count($xml); $i++){

$name = $xml->user[$i]->name;
$mobile = $xml->user[$i]->mobile;
$email = $xml->user[$i]->email;
$password = $xml->user[$i]->password;

$sql = "insert into user(name,mobile,email,password) 
        values('$name','$mobile','$email','$password')";

mysqli_query($conn, $sql);

}

echo "Data Uploaded From XML file to DataBase";


?>
========================================================================
XML to JSON:

<?php
$conn = mysqli_connect("localhost", "root", "", "myproject");
$xml = simplexml_load_file("1503568755.xml");

$json = json_encode($xml);

echo $json;


?>
=======================================================================
DataBase to JSON:

<?php 
$conn = mysqli_connect("localhost", "root", "", "myproject");
$sql = "select * from user ";
$res = mysqli_query($conn, $sql);

$user = array();

while($row=mysqli_fetch_object($res)){

array_push($user, $row);
}
  echo "<pre>";
  print_r($user);
  echo "</pre>";
  
 echo "<hr color='red'>";

 $json = json_encode($user); 
 echo $json;

?>
*********************************************************************************