Penulis: littleflow3r

Case Study : Create simple guest book with PHP Mysql
Requirements : Webserver Packages, already installed.

Ok, lets just practices.

Step 1 : Prepare the Database

1. Create database named db_tutorial
2. Prepare tabel named tb_guestbook, with structure like below.
   
3. Done!

Step 2 : Prepare the Work Folder

1. Create folder named tutorphp in your document root
2. Save all the files in this tutorial in this folder.

Step 3 : Create script to connect to DB

1. Type the following script,
   [sourcecode language=”php”]<br />
   &lt;?php<br />
   $host = &quot;localhost&quot;;<br />
   $user = &quot;root&quot;;//adjust according to your mysql setting<br />
   $pass = &quot;&quot;; //adjust according to your mysql setting, i use no password here<br />
   $dbName = &quot;db_tutorial&quot;;<br />
   mysql_connect($host, $user, $pass);<br />
   mysql_select_db($dbName)<br />
   or die (&quot;Connect Failed !! : &quot;.mysql_error());<br />
   ?&gt;<br />
   [/sourcecode]
2. Save with the name connect.php

Step 4 : Create the GuestBook Form

1. Type the following script,
   [sourcecode language=”php”]<br />
   &lt;h1&gt;Guestbook&lt;/h1&gt;<br />
   &lt;form method=&quot;post&quot; action=&quot;savegb.php&quot;&gt;<br />
   &lt;table&gt;<br />
   &lt;tr&gt;&lt;td&gt;Your Name&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br />
   &lt;tr&gt;&lt;td&gt;Your Email&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br />
   &lt;tr&gt;&lt;td&gt;Your Comment&lt;/td&gt;&lt;td&gt;&lt;textarea name=&quot;comment&quot;&gt;&lt;/textarea&gt;&lt;/td&gt;&lt;/tr&gt;<br />
   &lt;tr&gt;&lt;td&gt;&lt;/td&gt;&lt;td&gt;&lt;/td&gt;&lt;/tr&gt;<br />
   &lt;/table&gt;<br />
   &lt;/form&gt;</p>
   <p>[/sourcecode]
2. save with the name formguestbook.php

Step 5 : Create a Processing Script

1. Type the following script,
   [sourcecode language=”php”]<br />
   &lt;?php<br />
   include ‘connect.php’;</p>
   <p>$name = $_POST[‘name’]; //get the name value from form<br />
   $email = $_POST[‘email’]; //get the email value from form<br />
   $comment = $_POST[‘comment’]; //get the comment value from form</p>
   <p>//query to save to database<br />
   $q1 = &quot;INSERT into tb_guestbook value (”,’$name’,’$email’,’$comment’)&quot;;<br />
   $result1 = mysql_query($q1);</p>
   <p>//query to get data from database<br />
   $q2 = ‘SELECT * FROM tb_guestbook order by id desc’;<br />
   $result2 = mysql_query($q2);</p>
   <p>//show the data from database<br />
   while ($record = mysql_fetch_array($result2)) {<br />
   echo &quot;&lt;table&gt;&quot;;<br />
   echo &quot;&lt;tr&gt;&lt;td&gt;Name&lt;/td&gt;&lt;td&gt;:&lt;/td&gt;&lt;td&gt;&quot;.$record[‘name’].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;<br />
   echo &quot;&lt;tr&gt;&lt;td&gt;Email&lt;/td&gt;&lt;td&gt;:&lt;/td&gt;&lt;td&gt;&quot;.$record[‘email’].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;<br />
   echo &quot;&lt;tr&gt;&lt;td&gt;Comment&lt;/td&gt;&lt;td&gt;:&lt;/td&gt;&lt;td&gt;&quot;.$record[‘comment’].&quot;&lt;/td&gt;&lt;/tr&gt;&quot;;<br />
   echo &quot;&lt;/table&gt;&quot;;<br />
   echo &quot;&lt;br/&gt;&quot;;<br />
   }<br />
   ?&gt;<br />
   [/sourcecode]
2. Save with the name savegb.php
3. For the explanation, see script’s comment 😀

Step 6 : Testing Code

1. Go to http://localhost/tutorphp/formguestbook.php. You will see the form like below. Fill the form (the example is like the picture below).
   
2. Click save and you will see the result.
   

OK. Haaaaaaaapppy Coding! 😀

Case Study : Get the other’s site feed with RSS Reader SimplePie, show it, and save it to database.
Requirements : SimplePie library, download here. Webserver Packages, already installed.

RSS (Really Simple Syndication) is a xml based format that used to sharing and delivering web content that usually updated regularly. While the term “output” refers to the outputs of RSS which can be read with RSS Feed Reader. SimplePie is a RSS Feed Reader/Parser that quite famous (and my favorite of course), the way RSS Feed Parser working is to read a XML format contained in the RSS Feed which we set ourselves.

Okay, lets give it a try.

Step 1 : Prepare the Database

1. Create a new database named db_tutorial
2. Create table tb_rss, with structure like the picture below.
   
3. Done with the database!

Step 2 : Prepare Working Folder

1. Create a new folder named rss in your document root
2. Create new folder named cache in the folder rss (…/rss/cache)
3. Copy file SimplePie.inc (on simplepie zip file) in to folder rss.

Step 3 : Create a Connection to Database

1. Create a script to connect to database, type the following script,
   <?php
//file name : connect.php
//author : littleflow3r
$host = "localhost";
$user = "root"; //sesuaikan dengan setting mysql
$pass = ""; //sesuaikan dengan setting mysql
$dbName = "db_tutorial";
mysql_connect($host, $user, $pass);
mysql_select_db($dbName)
or die ("Connect Failed !! : ".mysql_error());
?>
2. Save in the folder rss with name connect.php

Step 4 : Inisialisasi SimplePie

1. Type the following script,
   <?php
//file name : initRSS.php
//author : littleflow3r
require_once 'simplepie.inc';
//initialize simplePie
$feed = new SimplePie('http://localhost/websmsmasking/feed/rss');
$feed->set_cache_location('../rss/cache/');
$feed->set_feed_url('http://localhost/websmsmasking/feed/rss');
$feed->init();
$feed->handle_content_type();
?>
2. save in the folder rss and named it initRSS.php
3. Explanation : The way of SimplePie RSS Parser working is to read the XML format contained adalah dengan membaca format XML contained in the RSS Feed. The Code above is used to initializes SimplePie, by entering the address of our rss [baris 06 dan baris 08]. For example, i use the sample rss address is localhost/websmsmasking/feed/rss –> feed from my local application. You can change this to address that you want, but remember that to gets the rss feed from online sites, you have to be connected to internet, too (this is because simplepie will directly access to that sites.)
   

Step 5 : Show the Feed

1. Type the following script,
   <?php
//file name : rss.php
//author : littleflow3r
include 'initRSS.php';
include 'connect.php';
//get the feed and show it
echo "<h1> RSS News Update </h1>";
foreach ($feed->get_items(0,4) as $item):
$permalink = $item->get_permalink();
$title = $item->get_title();
$desc = $item->get_description();
echo '<a href="'.$permalink.' ">'; echo $title; echo '</a>';
echo "<br>";
echo $desc;
echo "<br>"; echo "<br>";
//insert to database
$q = "INSERT into tb_rss (link, title, description) VALUES('$permalink','$title','$desc')";
$result = mysql_query($q);
endforeach;
?>
2. Save in the folder rss, named it rss.php
3. Explanation: Baris 08 show looping with foreach according to the number of feed obtained from the address of the set RSS’s address, by the get_items(0,4)function, the intention is to take 4 feed items starting from the 0 record.
   Baris 09 save the permalink from each itemsin to variabel $permalink
   Baris 10 get the feed title by the get_title function and save it to $title.
   Baris 11 get the feed description with the get_desc function and save it to $desc.

Step 6 : Testing Code

1. Go to brwoser, run http://localhost/rss/rss.php
2. You will see the feed from your rss’s address like image below.
   
3. Check the database, see that tb_rss already filled with rss content from your rss’s address.
   

Okay, Done. Happy Trying! Happy Coding 🙂

Case Study : Create a script to image uploading, save image location to database, and show them.
Requirements : Webserver Packages, already installed.

Follow all this step,

Step 1 : Prepare the Database

1. Create database named db_tutorial
2. Prepare table named tb_image, see the table’s structure below.
   
3. Done with the database!

Step 2 : Prepare the wcorking folder

1. Create folder named helloMobile in your document root
2. Create folder again named image inside helloMobile folder created before. This Folder required for saving the image that have been uploaded.
3. Save all file in this tutorial in the helloMobile folder.

Step 3 : Create script connect to DB

1. Type the following script,
   [sourcecode language=”php”]
   <?php
   $host = "localhost";
   $user = "root";
   $pass = "";
   $dbName = "db_tutorial";
   mysql_connect($host, $user, $pass);
   mysql_select_db($dbName)
   or die ("Connect Failed !! : ".mysql_error());
   ?>
   [/sourcecode]
2. Save with the name connect.php, and save in the helloMobile folder

Step 4 : Create the upload image form

1. Type the following script,
   [sourcecode language=”php”]
   <form name="form" method="post" enctype="multipart/form-data" action="proses.php">
   Image : <input name="picture" type="file" />
   <input type="submit" name="upload" value="Upload" />
   </form>
   [/sourcecode]
2. Save with the name formupload.php, save in the helloMobile folder

Step 5 : Create processing script

1. Ketikkan script berikut,
   [sourcecode language=”php”]
   <?php
   include "connect.php";
   $fileName = $_FILES[‘picture’][‘name’]; //get the file name
   $fileSize = $_FILES[‘picture’][‘size’]; //get the size
   $fileError = $_FILES[‘picture’][‘error’]; //get the error when upload
   if($fileSize > 0 || $fileError == 0){ //check if the file is corrupt or error
   $move = move_uploaded_file($_FILES[‘picture’][‘tmp_name’], ‘E:/DocumentRootYuni/helloMobile/image/’.$fileName); //save image to the folder
   if($move){
   echo "<h3>Success! </h3>";
   $q = "INSERT into tb_image VALUES(”,’$fileName’,’image/$fileName’)"; //insert image property to database
   $result = mysql_query($q);

   $q1 = "SELECT location from tb_image where filename = ‘$fileName’ limit 1 "; //get the image that have been uploaded
   $result = mysql_query($q1);
   while ($data = mysql_fetch_array($result)) {
   $loc = $data[‘location’]; ?>
   <br/>
   <h2> This is the Image : </h2>
   <img src="<?php echo $loc; ?>" /> <!– show the image using img src –>
   <?php
   }
   } else{
   echo "<h3>Failed! </h3>";
   }
   } else {
   echo "Failed to Upload : ".$fileError;
   }
   ?>
   [/sourcecode]

2. Save with the name prosesupload.php
3. See the script’s comment for the explanation 😀

Step 6 : Testing Code

1. Go to http://localhost/helloMobile/formupload.php. And you will see the form below,
   
2. Try to upload image. Choose a image file with click browse button
3. Save. So the image will be shown to you 😀