• Create a table for Member at phpMyAdmin.
• Create a member registration and login page with not duplicate email and password.

Member Dashboard :

• Create a dashboard for members include function view and edit.
• Create another page for members which are used to store homestay details. In this page, members are able to view, edit, delete and view each of the homestay details.
• How to upload multiple image in one time to my homestay.

• Create member registration and login page for MyHomestay.
• Create a member dashboard.

This is the member homepage. The sign up form is a pop up function and the user in order to do a reservation must sign up as a member first. Other than that, user must key in their real email and the mobile number start with 6 due to our system will send out message if the member done any reservation or cancellation.


The picture above is showing Myhomestay reservation member dashboard. It has 6 features that we focus which is reservation, myhomestay lisy, transaction history, member profile, homestay list and log out button.


This is the member dashboard with add homestay information. Once the member become an owner he or she has the authority to add homestay with key in the homestay name, category, address, description of homestay, price and upload less than 5 photo of the homestay.

• Create a button and pagination at administration list for print the PDF report.

Last found out Working PHP Pagination Function
also here how to modify the limit the pagination


This is all the Reservation that reserved by members. The admin are able to keep tracking the homestay reservation details which have been made by members and who are the homestay owners.

FPDF is a PHP class which allows to generate PDF files with pure PHP.

Design and generate PDF. Reservation statement


Sample code : 

<?php 

require('fpdf.php');
include("../connection.php");

$reservation_id = $_REQUEST['reservation_id'];
$member_id = $_REQUEST['member_id'];

$sql = "select member_name from member where member_id = $member_id";
$result_member = mysql_query($sql);
$row_member = mysql_fetch_assoc($result_member);
$member_name = $row_member['member_name'];

$sql = "select * from reservation join homestay on reservation.homestay_id = homestay.homestay_id ".
        "join member on homestay.member_id = member.member_id where reservation.reservation_id = $reservation_id";
$result = mysql_query($sql);
$row = mysql_fetch_assoc($result);

$start = $row['checkIn_date'];
$end = $row['checkOut_date'];
$reservation_date = $row['reservation_date'];
$night = (strtotime($end)- strtotime($start))/24/3600; 

class PDF extends FPDF
{
// Page header
function Header()
{
    // Logo
    $this->Image('../images/homestay-logo.png',10,10,50);   
    // Move to the right
    $this->Cell(100);
    // Arial bold 15
    $this->SetFont('Arial','B',20);
    // Title
    $this->Cell(0,20,'Statement of Reservation','C');
    // Line break
    $this->Ln(20);
}

// Page footer
function Footer()
{
    // Position at 1.5 cm from bottom
    $this->SetY(-15);
    // Arial italic 8
    $this->SetFont('Arial','I',8);
    // Page number
    $this->Cell(0,10,'Page '.$this->PageNo().'/{nb}',0,0,'C');
}
}


// Instanciation of inherited class
$pdf = new PDF();
$pdf->AddPage();

$pdf->SetFont('Times','B',18);
$pdf->Cell(80,10,'MyHomestay');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'1234 ST.');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,7.5,'Denver, CO 80202');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'Phone:(60)123-4567');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,7.5,'myhomestaymmu@gmail.com');
$pdf->Ln();
$pdf->SetFont('Times','',11);
$pdf->Cell(80,0,'www.homestay.com');
$pdf->Ln();
$pdf->Cell(130);
$pdf->SetFont('Arial','',12);
$reservation_date = date("Y-m-d",strtotime($reservation_date));
$pdf->Cell(0,-40,'Reservation Date :  '.$reservation_date,'C');
$pdf->Cell(0,-40,'','C');

$date = date("Y-m-d");
$pdf->Cell(-53.5,-25,'Generate Date :  '.$date,0,1,'C');

$pdf->Cell(0,40,'',0,1,'R');



$word = "To,".
        "\n$member_name".
        "\nDear Sir/Madam,".
        "\nThank you for your reservation. We confirm with pleasure your accommodation.".
        "\nPlease note the information below for accuracy".
        "\nPlease review it and report any discrepancies.";
$pdf->Multicell(160,6,$word);

$pdf->Cell(0,10,'',0,1,'R');

$pdf->SetFillColor(169, 169, 169);
$pdf->SetTextColor(0);
$pdf->SetDrawColor(255, 255, 255);
$pdf->Cell(18,7,'Res.Id',0,0,'L',true);
$pdf->Cell(35,7,'Guest Name',0,0,'L',true);
$pdf->Cell(35,7,'Homestay Name',0,0,'L',true);
$pdf->Cell(28,7,'Check In',0,0,'C',true);
$pdf->Cell(28,7,'Check Out',0,0,'C',true);
$pdf->Cell(18,7,'Nights',0,0,'C',true);
$pdf->Cell(26,7,'Amount',0,1,'C',true);

$pdf->Cell(0,0,'',0,1,'R');
$pdf->Cell(15,7,$row['reservation_id'],1,0,'C',0);
$pdf->Cell(28,7,$member_name,1,0,'C',0);
$pdf->Cell(44,7,$row['homestay_name'],1,0,'C',0);
$pdf->Cell(28,7,$row['checkIn_date'],1,0,'C',0);
$pdf->Cell(30,7,$row['checkOut_date'],1,0,'C',0);
$pdf->Cell(17,7,$night,1,0,'C',0);
$pdf->Cell(25,7,$row['reservation_total_price'],1,0,'C',0);

// Linienfarbe auf Blau einstellen 
$pdf->SetDrawColor(0, 0, 0);

// Linienbreite einstellen, 0.5 mm
$pdf->SetLineWidth(0.5);

// Linie zeichnen
$pdf->Line(10,132,198,132);

$pdf->SetFont('Arial','B',12);

$reservation_total_price = $row['reservation_total_price'];

$pdf->Cell(0,18,'',0,1,'R');
$pdf->Cell(182,3,'Total:  RM'.$reservation_total_price,0,1,'R');
$pdf->Cell(0,3,'',0,1,'R');


$pdf->Output();

?>

• Create admin table.
• Generate login page for administration page
• Generate admin page and edit profile page with JQuery

• Add one attribute at admin table to track when the last is updated.
• Create the login page with validation. The error message should show with red color.
• Add on Admin_Image at admin table and while upload the image it will directly save into folder not database.

This is the admin that add normal admin in the system. The add normal admin will only display if the admin level is master admin in MyHomestay.
sample using JQuery validation

<pre style="background:#0c1021;color:#f8f8f8"><span style="color:#aeaeae">//validate functions</span>
    <span style="color:#fbde2d">function</span> <span style="color:#ff6400">validateName</span>()
    {
        <span style="color:#aeaeae">//if it's NOT valid</span>
        <span style="color:#fbde2d">if</span>(admin_name<span style="color:#8da6ce">.val</span>()<span style="color:#8da6ce">.length</span> <span style="color:#fbde2d">&lt;</span> <span style="color:#d8fa3c">4</span>)
        {
            admin_name<span style="color:#8da6ce">.addClass</span>(<span style="color:#61ce3c">"boxred"</span>);
            nameInfo<span style="color:#8da6ce">.html</span>(<span style="color:#61ce3c">"&lt;div class='alert alert-warning span4'>"</span><span style="color:#fbde2d">+</span>
                                <span style="color:#61ce3c">"&lt;strong>Wrong!&lt;/strong> The names must with more than 3 letters!"</span><span style="color:#fbde2d">+</span>
                            <span style="color:#61ce3c">"&lt;/div>"</span>);
            <span style="color:#8da6ce">$</span>('<span style="color:#ff6400">#update_name</span>')<span style="color:#8da6ce">.attr</span>(<span style="color:#61ce3c">"disabled"</span>, <span style="color:#d8fa3c">true</span>);
            <span style="color:#8da6ce">$</span>('<span style="color:#ff6400">#update_name</span>')<span style="color:#8da6ce">.fadeTo</span>(<span style="color:#d8fa3c">10</span>,<span style="color:#d8fa3c">0.5</span>);          
        }
        <span style="color:#aeaeae">//if it's valid</span>
        <span style="color:#fbde2d">else</span>
        {
            admin_name<span style="color:#8da6ce">.removeClass</span>(<span style="color:#61ce3c">"boxred"</span>);
            nameInfo<span style="color:#8da6ce">.html</span>(<span style="color:#61ce3c">"&lt;div class='alert alert-success span4'>"</span><span style="color:#fbde2d">+</span>
                                <span style="color:#61ce3c">"&lt;strong>Correct!&lt;/strong> Now can click the save button"</span><span style="color:#fbde2d">+</span>
                            <span style="color:#61ce3c">"&lt;/div>"</span>);     
            <span style="color:#8da6ce">$</span>('<span style="color:#ff6400">#update_name</span>')<span style="color:#8da6ce">.removeAttr</span>(<span style="color:#61ce3c">"disabled"</span>);
            <span style="color:#8da6ce">$</span>('<span style="color:#ff6400">#update_name</span>')<span style="color:#8da6ce">.fadeTo</span>(<span style="color:#d8fa3c">10</span>,<span style="color:#d8fa3c">1.0</span>);          
        }
    }
</pre>

• Find out how to send SMS from PHP code.

last I found out Malaysia iSMS offers international SMS service covering more than 700 mobile Operators worldwide for Peer to Peer SMS, streaming content services (like factory alerts, news alerts, stock updates) and bulk SMS communications based on high quality as well as reliable connectivity.

Picture above showing the user received an e-mail and SMS after he done the sign up step. The e-mail will mentioned that you just create a new account at MyHomestay reservation system and it will release your login email and password also.
Task of the week :

• Create Admin table at phpMyAdmin.
• One of the attributes from admin is admin_level. While login it can determine you are master or a normal member.
• Create a login page for administration page.
• Create an admin profile page.
• Create admin page with edit function and validation.