PHP Note: December 2016

Friday, 23 December 2016

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

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

XmlDomLoop.php

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

<?php

$xmlDoc = new DOMDocument();

$xmlDoc->load("note.xml");

$x = $xmlDoc->documentElement;

foreach ($x->childNodes AS $item) {

print $item->nodeName . " = " . $item->nodeValue . "<br>";

}

?>

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

OUTPUT

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

#text =
to = Tove
#text =
from = Jani
#text =
heading = Reminder
#text =
body = Don't forget me this weekend!
#text =

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

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

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

XmlDom.php

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

<?php

$xmlDoc = new DOMDocument();

$xmlDoc->load("note.xml");

print $xmlDoc->saveXML();

?>

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

OUTPUT

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

Tove Jani Reminder Don't forget me this weekend!

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

XMP - EXPAT PARSER

NOTE.XML

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

<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>

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

XmlExpatParser.php

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

<?php
// Initialize the XML parser
$parser=xml_parser_create();
// Function to use at the start of an element
function start($parser,$element_name,$element_attrs) {
switch($element_name) {
case "NOTE":
echo "-- Note --<br>";
break;
case "TO":
echo "To: ";
break;
case "FROM":
echo "From: ";
break;
case "HEADING":
echo "Heading: ";
break;
case "BODY":
echo "Message: ";
}
}
// Function to use at the end of an element
function stop($parser,$element_name) {
echo "<br>";
}
// Function to use when finding character data
function char($parser,$data) {
echo $data;
}
// Specify element handler
xml_set_element_handler($parser,"start","stop");
// Specify data handler
xml_set_character_data_handler($parser,"char");
// Open XML file
$fp=fopen("note.xml","r");
// Read data
while ($data=fread($fp,4096)) {
xml_parse($parser,$data,feof($fp)) or
die (sprintf("XML Error: %s at line %d",
xml_error_string(xml_get_error_code($parser)),
xml_get_current_line_number($parser)));
}
// Free the XML parser
xml_parser_free($parser);
?>

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

OUTPUT
*******************************************************************************
-- Note --
To: Tove
From: Jani
Heading: Reminder
Message: Don't forget me this weekend!
*******************************************************************************

XML - GET ATTRIBUTE VALUE

books.xml

<?xml version="1.0" encoding="utf-8"?>
<bookstore>
<book category="COOKING">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="WEB">
<title lang="en-us">XQuery Kick Start</title>
<author>James McGovern</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="WEB">
<title lang="en-us">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>

XmlGetAttributeValueLoop.php

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

foreach($xml->children() as $books) {

echo $books->title['lang'];

echo "<br>";

}

?>

************************************
OUTPUT
*
en
enen-usen-us
*************************************

XML - GET ATTRIBUTE VALUE

books.xml

<?xml version="1.0" encoding="utf-8"?>
<bookstore>
<book category="COOKING">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="WEB">
<title lang="en-us">XQuery Kick Start</title>
<author>James McGovern</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="WEB">
<title lang="en-us">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>

XmlGetAttributeValue.php

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

echo $xml->book[0]['category'] . "<br>";

echo $xml->book[1]->title['lang'];

?>

OUTPUT
*
COOKING

en
*************************************************************************

XML - GET NODE VALUE LOOP

books.xml

<?xml version="1.0" encoding="utf-8"?>
<bookstore>
<book category="COOKING">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="WEB">
<title lang="en-us">XQuery Kick Start</title>
<author>James McGovern</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="WEB">
<title lang="en-us">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>

XmlGetNodevalueLoop.php

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

foreach($xml->children() as $books) {

echo $books->title . ", ";

echo $books->author . ", ";

echo $books->year . ", ";

echo $books->price . "<br>";

}

?>

OUTPUT
*

Everyday Italian, Giada De Laurentiis, 2005, 30.00Harry Potter, J K. Rowling, 2005, 29.99XQuery Kick Start, James McGovern, 2003, 49.99Learning XML, Erik T. Ray, 2003, 39.95

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

XML - GET SPECIFIC ELEMENT NODE VALUE

books.xml
************************************
<?xml version="1.0" encoding="utf-8"?>
<bookstore>
<book category="COOKING">
<title lang="en">Everyday Italian</title>
<author>Giada De Laurentiis</author>
<year>2005</year>
<price>30.00</price>
</book>
<book category="CHILDREN">
<title lang="en">Harry Potter</title>
<author>J K. Rowling</author>
<year>2005</year>
<price>29.99</price>
</book>
<book category="WEB">
<title lang="en-us">XQuery Kick Start</title>
<author>James McGovern</author>
<year>2003</year>
<price>49.99</price>
</book>
<book category="WEB">
<title lang="en-us">Learning XML</title>
<author>Erik T. Ray</author>
<year>2003</year>
<price>39.95</price>
</book>
</bookstore>

XmlGetSpecificNodevalue.php

<?php
$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");
echo $xml->book[0]->title . "<br>";
echo $xml->book[1]->title;
?>
OUTPUT
*
Everyday Italian
Harry Potter
*************************************

XML - GET NODE VALUE

NOTE.XML*****************************************<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>*XMLGetNodeValue.php<?php
$xml=simplexml_load_file("note.xml") or die("Error: Cannot create object");
echo $xml->to . "<br>";
echo $xml->from . "<br>";
echo $xml->heading . "<br>";
echo $xml->body;
?>OUTPUTToveJaniReminderDon't forget me this weekend!***********************************

XML - SIMPLE DOCUMENT WITH ERROR

<?phplibxml_use_internal_errors(true);$myXMLData ="<?xml version='1.0' encoding='UTF-8'?> <document>
<user>John Doe</wronguser>
<email>john@example.com</wrongemail> </document>";
$xml = simplexml_load_string($myXMLData);if ($xml === false) { echo "Failed loading XML: "; foreach(libxml_get_errors() as $error) { echo "<br>", $error->message; }} else { print_r($xml);}?>

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

OUTPUT

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

Failed loading XML:
Opening and ending tag mismatch: user line 3 and wronguser
Opening and ending tag mismatch: email line 4 and wrongemail

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

Thursday, 22 December 2016

XML - SIMPLE DOCUMENT READER

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

$xml=simplexml_load_string($myXMLData) or die("Error: Cannot create object");
print_r($xml);
?>

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

OUTPUT

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

SimpleXMLElement Object ( [to] => Tove [from] => Jani [heading] => Reminder [body] => Don't forget me this weekend! )

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

FILE HANDLING - UPLOAD ALL TYPE FILE WITH SIZE LIMIT

<!DOCTYPE html>
<html>
<body>

<?php
$target_dir = "d:\upload/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
// Check if image file is a actual image or fake image
// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}

// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
?>

<form action="<?php echo $_SERVER["PHP_SELF"];?>" method="post" enctype="multipart/form-data">
    Select image to upload:
    <input type="file" name="fileToUpload" id="fileToUpload">
    <input type="submit" value="Upload Image" name="submit">
</form>

</body>
</html>

FILE HANDLING - UPLOAD SPECIFIC TYPE FILE

<!DOCTYPE html>
<html>
<body>

<?php
$target_dir = "d:\upload/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = pathinfo($target_file,PATHINFO_EXTENSION);
// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}
// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}
// Check file size
if ($_FILES["fileToUpload"]["size"] > 500000) {
    echo "Sorry, your file is too large.";
    $uploadOk = 0;
}
// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}
// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
?>

<form action="<?php echo $_SERVER["PHP_SELF"];?>" method="post" enctype="multipart/form-data">
    Select image to upload:
    <input type="file" name="fileToUpload" id="fileToUpload">
    <input type="submit" value="Upload Image" name="submit">
</form>

</body>
</html>

FILE HANDLING READ SINGLE CHARACTER

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 : Again open notepad and save below code with name of

'FileHandlingReadSingleCharacter.PHP'/-

Wednesday, 21 December 2016

FILE HANDLING CHECK END-OF-FILE

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 : Again open notepad and save below code with name of

'FileHandlingCheckEndOfFile.PHP'

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

<?php
$myfile = fopen("d:\hello.txt", "r") or die("Unable to open file!");
// Output one line until end-of-file
while(!feof($myfile)) {
echo fgets($myfile) . "<br>";
}
fclose($myfile);
?>

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

FILE HANDLING READ SINGLE LINE

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 :

Again open notepad and save below code with name of

'FILE HANDLINGREADSINGLELING.PHP'

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

<?php
$myfile = fopen("D:\hello.txt", "r") or die("Unable to open file!");
echo fgets($myfile);
fclose($myfile);
?>

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

FILE HANDLING OPEN/READ

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 : Again open notepad and save below code with name of

'FILE HANDLINGOPENREAD.PHP'

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

<?php
$myfile = fopen("D:\hello.txt", "r") or die("Unable to open file!");
echo fread($myfile,filesize("D:\hello.txt"));
fclose($myfile);
?>

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

Tuesday, 20 December 2016

MySQL UPDATE STATEMENT

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

// Create connection

$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "UPDATE MyGuests SET lastname='Doe' WHERE id=2";

if ($conn->query($sql) === TRUE) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . $conn->error;
}

$conn->close();
?>

MySQL DELETE STATEMENT

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// sql to delete a record
$sql = "DELETE FROM MyGuests WHERE id=3";

if ($conn->query($sql) === TRUE) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . $conn->error;
}

$conn->close();
?>

MySQL SELECT STATEMENT

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT id, firstname, lastname FROM MyGuests";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>

MySQL PREPARED STATEMENT

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

// prepare and bind
$stmt = $conn->prepare("INSERT INTO MyGuests (firstname, lastname, email) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $firstname, $lastname, $email);

// set parameters and execute
$firstname = "John";
$lastname = "Doe";
$email = "john@example.com";
$stmt->execute();

$firstname = "Mary";
$lastname = "Moe";
$email = "mary@example.com";
$stmt->execute();

$firstname = "Julie";
$lastname = "Dooley";
$email = "julie@example.com";
$stmt->execute();

echo "New records created successfully";

$stmt->close();
$conn->close();
?>

MySQL INSERT MULTIPLE RECORD

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Mary', 'Moe', 'mary@example.com');";
$sql .= "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Julie', 'Dooley', 'julie@example.com')";

if ($conn->multi_query($sql) === TRUE) {
    echo "New records created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

MySQL LAST INSERTED RECORD

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('John', 'Doe', 'john@example.com')";

if ($conn->query($sql) === TRUE) {
    $last_id = $conn->insert_id;
    echo "New record created successfully. Last inserted ID is: " . $last_id;
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

MySQL INSERT STATEMENT

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "INSERT INTO MyGuests (firstname, lastname, email)
VALUES ('Divakar', 'Singh', 'singh.divakar@example.com')";

if ($conn->query($sql) === TRUE) {
    echo "New record created successfully";
} else {
    echo "Error: " . $sql . "<br>" . $conn->error;
}

$conn->close();
?>

MySQL CREATE TABLE

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "myDB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// sql to create table
$sql = "CREATE TABLE MyGuests (
id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
firstname VARCHAR(30) NOT NULL,
lastname VARCHAR(30) NOT NULL,
email VARCHAR(50),
reg_date TIMESTAMP
)";

if ($conn->query($sql) === TRUE) {
    echo "Table MyGuests created successfully";
} else {
    echo "Error creating table: " . $conn->error;
}

$conn->close();
?>

MySQL CREATE DATABASE

<?php

$servername = "localhost";

$username = "root";

$password = "";

// Create connection

$conn = new mysqli($servername, $username, $password);

// Check connection

if ($conn->connect_error) {

die("Connection failed: " . $conn->connect_error);

}

// Create database

$sql = "CREATE DATABASE myDB";

if ($conn->query($sql) === TRUE) {

echo "Database created successfully";

} else {

echo "Error creating database: " . $conn->error;

}

$conn->close();

?>

MySQL DATABASE CONNECTION

Summary

1. Creating Database and table with data

2. Create connection with database

3. Install & configure wamp/xamp server to to run php script

4. Showing api

Note : Install wamp/xampp to run mysql database and localhost( to run php pages and place all php file in 'c:\wamp\www\' (in case of wamp) , c:\xampp\htdocs ( in case of xampp).

STEP - 1 : CREATE DATABASE IN MYSQL - Run the wamp/xampp.

Now, Open your browser and place this line - 'http://localhost/phpmyadmin/' (default password 'root').

Go to New --> click on New --> In ' create database' enter your database name' --> click on create.

Now Click on SQL tab in mysql database and place below code.

DATABASE NAME : country_list

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

CREATE TABLE `country_list` (

`id` int(11) NOT NULL,

`countrys` varchar(50) NOT NULL,

`capitals` varchar(50) NOT NULL,

`languages` varchar(50) NOT NULL

)

INSERT INTO `country_list` (`id`, `countrys`, `capitals`, `languages`) VALUES

(1, 'india', 'delhi', 'hindi'),

(2, 'america', 'new york', 'english'),

(3, 'russia', 'moscow', 'russian');

ALTER TABLE `country_list`

ADD PRIMARY KEY (`id`);

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

Connection.php

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

<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "php topic";

// Create connection
$conn = new mysqli($servername, $username, $password, $database);

// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";
?>

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

Monday, 19 December 2016

JSON WITH DATABASE

Summary

1. Creating Database and table with data

2. Create connection with database

3. Install & configure wamp/xamp server to to run php script

4. Showing api

Note : Install wamp/xampp to run mysql database and localhost( to run php pages and place all php file in 'c:\wamp\www\' (in case of wamp) , c:\xampp\htdocs ( in case of xampp).

STEP - 1 : CREATE DATABASE IN MYSQL - Run the wamp/xampp.

Now, Open your browser and place this line - 'http://localhost/phpmyadmin/' (default password 'root').

Go to New --> click on New --> In ' create database' enter your database name' --> click on create.

Now Click on SQL tab in mysql database and place below code.

DATABASE NAME : country_list

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

CREATE TABLE `country_list` (

`id` int(11) NOT NULL,

`countrys` varchar(50) NOT NULL,

`capitals` varchar(50) NOT NULL,

`languages` varchar(50) NOT NULL

) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `country_list` (`id`, `countrys`, `capitals`, `languages`) VALUES

(1, 'india', 'delhi', 'hindi'),

(2, 'america', 'new york', 'english'),

(3, 'russia', 'moscow', 'russian');

ALTER TABLE `country_list`

ADD PRIMARY KEY (`id`);

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

Now, click GO button to complete operation.

Step - 2 : Database Connection - To perform INSERT, DELETE, UPDATE operation, you need to create a connection.

Open notepad and place below code

Connection.php

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

<?php

$con=mysqli_connect("localhost","root","","php topic");

if($con->connect_error)

{

echo"connection fail".$con->connect_error;

}

?>

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

and save it in proper folder ( discussed above).

Step - 3 : Now, create another file in same folder where you place connection.php file, named it ' simple_json_with_db' and place below code-

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

<?php

include('include/connection.php');

$sql="select * from country_list";

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

if($num=mysqli_num_rows($res)>0)

{

while($row=mysqli_fetch_assoc($res))

{

$json[]=$row;

}

echo json_encode(array('record'=>$json));

}

else

{

$json[]=array('msg'=>"no records found..!",'status'=>0);

echo json_encode(array('message'=>$json));

}

?>

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

Step - 4 : Get Json - Open your browser and place this is addressbar 'localhost/country_list.php'.

OUTPUT :

{"record":[{"id":"1","countrys":"india","capitals":"delhi","languages":"hindi"},{"id":"2","countrys":"america","capitals":"new york","languages":"english"},{"id":"3","countrys":"russia","capitals":"moscow","languages":"russian"}]}

Sunday, 18 December 2016

JSON WITHOUT DATABASE

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

<?php

$json[] = array("name"=>"divakar","country"=>"MCA","age"=>26);

echo json_encode (array('record'=>$json));

?>

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

Friday, 23 December 2016

<?php$myXMLData ="<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>";************************************************

XmlDomLoop.php

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

<?php

$xmlDoc = new DOMDocument();

$xmlDoc->load("note.xml");

$x = $xmlDoc->documentElement;

foreach ($x->childNodes AS $item) {

print $item->nodeName . " = " . $item->nodeValue . "<br>";

}

?>

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

#text = to = Tove#text = from = Jani#text = heading = Reminder#text = body = Don't forget me this weekend!#text =

<?php$myXMLData ="<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>";************************************************

XmlDom.php

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

<?php

$xmlDoc = new DOMDocument();

$xmlDoc->load("note.xml");

print $xmlDoc->saveXML();

?>

Tove Jani Reminder Don't forget me this weekend!

<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

foreach($xml->children() as $books) {

echo $books->title['lang'];

echo "<br>";

}

?>

************************************************************************OUTPUT*************************************************************************en enen-usen-us *************************************************************************

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

echo $xml->book[0]['category'] . "<br>";

echo $xml->book[1]->title['lang'];

?>

************************************************************************OUTPUT*************************************************************************COOKING

en*************************************************************************

<?php

$xml=simplexml_load_file("books.xml") or die("Error: Cannot create object");

foreach($xml->children() as $books) {

echo $books->title . ", ";

echo $books->author . ", ";

echo $books->year . ", ";

echo $books->price . "<br>";

}

?>

************************************************************************OUTPUT*************************************************************************

Everyday Italian, Giada De Laurentiis, 2005, 30.00Harry Potter, J K. Rowling, 2005, 29.99XQuery Kick Start, James McGovern, 2003, 49.99Learning XML, Erik T. Ray, 2003, 39.95

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

Thursday, 22 December 2016

<?php$myXMLData ="<?xml version='1.0' encoding='UTF-8'?><note><to>Tove</to><from>Jani</from><heading>Reminder</heading><body>Don't forget me this weekend!</body></note>";$xml=simplexml_load_string($myXMLData) or die("Error: Cannot create object");print_r($xml);?>

SimpleXMLElement Object ( [to] => Tove [from] => Jani [heading] => Reminder [body] => Don't forget me this weekend! )

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 : Again open notepad and save below code with name of

'FileHandlingReadSingleCharacter.PHP'/-

Wednesday, 21 December 2016

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

Thanks PHP for acknowledge me.</br>

Total no. of character

------------------------------------------------------------------------------------------

STEP-2 : Again open notepad and save below code with name of

'FileHandlingCheckEndOfFile.PHP'

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

<?php$myfile = fopen("d:\hello.txt", "r") or die("Unable to open file!");// Output one line until end-of-filewhile(!feof($myfile)) { echo fgets($myfile) . "<br>";}fclose($myfile);?>

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

STEP-1 : Open notepad and paste data.

Hello.Txt

------------------------------------------------------------------------------------------

Hello, I am <b> HELLO.TXT </b> n present in d drive of window computer.</br>

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

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

#text =
to = Tove
#text =
from = Jani
#text =
heading = Reminder
#text =
body = Don't forget me this weekend!
#text =

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

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

<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>

************************************
OUTPUT
*
en
enen-usen-us
*************************************

OUTPUT
*
COOKING

en
*************************************************************************

OUTPUT
*

<?php
$myXMLData =
"<?xml version='1.0' encoding='UTF-8'?>
<note>
<to>Tove</to>
<from>Jani</from>
<heading>Reminder</heading>
<body>Don't forget me this weekend!</body>
</note>";

$xml=simplexml_load_string($myXMLData) or die("Error: Cannot create object");
print_r($xml);
?>

<?php
$myfile = fopen("d:\hello.txt", "r") or die("Unable to open file!");
// Output one line until end-of-file
while(!feof($myfile)) {
echo fgets($myfile) . "<br>";
}
fclose($myfile);
?>

<?php
$myfile = fopen("D:\hello.txt", "r") or die("Unable to open file!");
echo fgets($myfile);
fclose($myfile);
?>

<?php
$myfile = fopen("D:\hello.txt", "r") or die("Unable to open file!");
echo fread($myfile,filesize("D:\hello.txt"));
fclose($myfile);
?>