1. PHP
  2. Online Guest House

Online Guest House

Submitted by sanbunna9 on Wednesday, April 24, 2013 - 15:07.
Language
PHP
Dear, I am Bunna San live in Phnom Penh, Cambodia. I would like to share you about Online Guest House Project in PHP & Mysql. In this project you will know about how booking process from client register and manage number and type of rooms in the guest house or hotel . I have included code for connect to database, insert record, select, delete and i have beauty slide and gallery demo with lightbox etc... So i hope that this sample project will help all students and developer that want to take some of code to develop other website is up to you as possible. Please kindly anybody download Database Script and see demo from below link: http://bunna.info/index.php/23-php-project/122-online-guest-house-in-php Here is my facebook account: https://www.facebook.com/bunna.info Skype account: san_bunna9 Best regard! Bunna San

Note: Due to the size or complexity of this submission, the author has submitted it as a .zip file to shorten your download time. After downloading it, you will need a program like Winzip to decompress it.

Virus note: All files are scanned once-a-day by SourceCodester.com for viruses, but new viruses come out every day, so no prevention program can catch 100% of them.

FOR YOUR OWN SAFETY, PLEASE:

1. Re-scan downloaded files using your personal virus checker before using it.
2. NEVER, EVER run compiled files (.exe's, .ocx's, .dll's etc.)--only run source code.

Tags
Online_guest_house
PHP & Mysql

Comments

Submitted by Anonymous (not verified) on Wed, 04/24/2013 - 19:13

Hi San,I think in the attached zip file,Database is missing.!could you mail me the database at [email protected] Thanks and regards Moinu

Submitted by Anonymous (not verified) on Wed, 04/24/2013 - 20:05

where is the database

Submitted by Anonymous (not verified) on Wed, 04/24/2013 - 22:41

Hi San, Where is the database? Could you mail me the database at [email protected] Thankyou

Submitted by Anonymous (not verified) on Thu, 04/25/2013 - 11:27

where is the database ... please send the database to me [email protected] ..thanks

Submitted by Anonymous (not verified) on Sun, 04/28/2013 - 20:01

please send me the database to [email protected]

Submitted by Anonymous (not verified) on Sat, 05/04/2013 - 06:14

hello dear how are u?i fine and i saw u'r project and please would help me how can i implement it with all steps? my mail is [email protected]

Submitted by Anonymous (not verified) on Fri, 05/10/2013 - 09:12

Hi San, Where is the database?
Could you mail me the database at [email protected]
Thankyou

Submitted by Anonymous (not verified) on Sat, 07/13/2013 - 23:30

Your ZIP can not open please check that, and upload again for us

Submitted by Anonymous (not verified) on Wed, 07/17/2013 - 21:54

Please may you sent the sarana.sql file to [email protected] to see how this your wonderful project goes....

Database you can create by yourself .....................;) I already done /* SQLyog Ultimate - MySQL GUI v8.21 MySQL - 5.5.16 : Database - sarana ********************************************************************* */ /*!40101 SET NAMES utf8 */; /*!40101 SET SQL_MODE=''*/; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; CREATE DATABASE /*!32312 IF NOT EXISTS*/`sarana` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `sarana`; /*Table structure for table `admin` */ DROP TABLE IF EXISTS `admin`; CREATE TABLE `admin` ( `username` tinytext, `password` tinytext ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `admin` */ insert into `admin`(`username`,`password`) values ('admin','admin'); /*Table structure for table `booking` */ DROP TABLE IF EXISTS `booking`; CREATE TABLE `booking` ( `id` int(100) unsigned DEFAULT NULL, `title` tinytext, `firstname` tinytext, `lastname` tinytext, `sex` char(10) DEFAULT NULL, `dob` date DEFAULT NULL, `guestnumber` int(100) DEFAULT NULL, `datein` date DEFAULT NULL, `dateout` date DEFAULT NULL, `roomtype` tinytext, `email` tinytext, `telephone` tinytext, `address` tinytext, `other` tinytext ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `booking` */ /*Table structure for table `bookings` */ DROP TABLE IF EXISTS `bookings`; CREATE TABLE `bookings` ( `ID` int(100) unsigned DEFAULT NULL, `clientID` int(100) unsigned DEFAULT NULL, `startDate` date DEFAULT NULL, `endDate` date DEFAULT NULL, `adults` tinytext, `children` tinytext, `roomType` tinytext, `roomOptions` tinytext, `networkConnection` tinytext, `PC` tinytext, `requirements` tinytext, `datebooking` date DEFAULT NULL, `clause` tinytext, `noteother` tinytext ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `bookings` */ /*Table structure for table `clients` */ DROP TABLE IF EXISTS `clients`; CREATE TABLE `clients` ( `id` int(100) unsigned DEFAULT NULL COMMENT ', , , , , , , , , , ', `title` tinytext, `firstName` tinytext, `lastName` tinytext, `address1` tinytext, `address2` tinytext, `town` tinytext, `province` tinytext, `country` tinytext, `postCode` tinytext, `email` tinytext, `telephone` tinytext ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `clients` */ insert into `clients`(`id`,`title`,`firstName`,`lastName`,`address1`,`address2`,`town`,`province`,`country`,`postCode`,`email`,`telephone`) values (NULL,'Mr','Phearum','Kem','Khmer','sd','a','d','ad','1111111','[email protected]','012121212'); /*Table structure for table `feedback` */ DROP TABLE IF EXISTS `feedback`; CREATE TABLE `feedback` ( `id` int(100) unsigned DEFAULT NULL, `title` tinytext, `Name` tinytext, `position` tinytext, `company` tinytext, `email` tinytext, `telephone` tinytext, `address` tinytext, `comment` text ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `feedback` */ insert into `feedback`(`id`,`title`,`Name`,`position`,`company`,`email`,`telephone`,`address`,`comment`) values (NULL,'Mr. ','
Notice: Undefined variable: name in D:localhost hmordafeedback.php on line 94
','','','
Notice: Undefined variable: email in D:localhost hmordafeedback.php on line 99
','','',''); /*Table structure for table `room` */ DROP TABLE IF EXISTS `room`; CREATE TABLE `room` ( `roomnumber` int(100) DEFAULT NULL COMMENT ',,,, , ', `type` tinytext, `guest` tinytext, `checkin` date DEFAULT NULL, `checkout` date DEFAULT NULL, `status` int(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `room` */ /*Table structure for table `rooms` */ DROP TABLE IF EXISTS `rooms`; CREATE TABLE `rooms` ( `roomid` int(100) unsigned DEFAULT NULL, `type` tinytext, `guest` tinytext, `checkin` date DEFAULT NULL, `checkout` date DEFAULT NULL, `status` int(100) DEFAULT NULL, `noteother` tinytext ) ENGINE=InnoDB DEFAULT CHARSET=latin1; /*Data for the table `rooms` */ insert into `rooms`(`roomid`,`type`,`guest`,`checkin`,`checkout`,`status`,`noteother`) values (12,'Single (FAN) - $6 / Night','b','2013-08-26','2013-08-27',0,'Well'),(12,'Double (AC) - $16 / Night','d','2013-08-28','2013-08-29',0,'Well'); /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Submitted by disan bisula (not verified) on Thu, 10/24/2013 - 17:14

thanks for the code. am loading room-manage.php in the admin section, but am experiencing an error. "Notice:Use of undefined constant myusername- assumed 'myusername' in C:\wamp\www\thmorda\admin\room-manage.php omn line 4

Submitted by kena (not verified) on Wed, 10/30/2013 - 04:39

it gives me an error when i try to book for a house and here is the error: Notice: Undefined index: page in C:\xampp\htdocs\guest\book_room.php on line 50 please help me!

Submitted by sanbunna9 on Tue, 07/22/2014 - 22:54

Dear Guys, I am San bunna, very sorry for reply so late because i busy with my mission for a long time. Thanks for interest my project about online guest house using php language. Please kindly anybody download Database Script and see demo from below link: http://bunna.info/index.php/23-php-project/122-online-guest-house-in-php Here is my facebook account: https://www.facebook.com/bunna.info Skype account: san_bunna9

Submitted by hillarity daud (not verified) on Wed, 08/13/2014 - 22:48

its good but dg is micn can you send to me [email protected]

Submitted by Hans on Tue, 09/02/2014 - 11:40

Hello, I've find the database on this link, so kindly copy and past on your brownser on : http://bunna.info/index.php/23-php-project/122-online-guest-house-in-php

Submitted by devsi07 on Thu, 09/24/2015 - 22:06

/*
SQLyog Ultimate - MySQL GUI v8.21
MySQL - 5.5.16 : Database - sarana
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`sarana` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `sarana`;

/*Table structure for table `admin` */

DROP TABLE IF EXISTS `admin`;

CREATE TABLE `admin` (
`username` tinytext,
`password` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `admin` */

insert into `admin`(`username`,`password`) values ('admin','admin');

/*Table structure for table `booking` */

DROP TABLE IF EXISTS `booking`;

CREATE TABLE `booking` (
`id` int(100) unsigned DEFAULT NULL,
`title` tinytext,
`firstname` tinytext,
`lastname` tinytext,
`sex` char(10) DEFAULT NULL,
`dob` date DEFAULT NULL,
`guestnumber` int(100) DEFAULT NULL,
`datein` date DEFAULT NULL,
`dateout` date DEFAULT NULL,
`roomtype` tinytext,
`email` tinytext,
`telephone` tinytext,
`address` tinytext,
`other` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `booking` */

/*Table structure for table `bookings` */

DROP TABLE IF EXISTS `bookings`;

CREATE TABLE `bookings` (
`ID` int(100) unsigned DEFAULT NULL,
`clientID` int(100) unsigned DEFAULT NULL,
`startDate` date DEFAULT NULL,
`endDate` date DEFAULT NULL,
`adults` tinytext,
`children` tinytext,
`roomType` tinytext,
`roomOptions` tinytext,
`networkConnection` tinytext,
`PC` tinytext,
`requirements` tinytext,
`datebooking` date DEFAULT NULL,
`clause` tinytext,
`noteother` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `bookings` */

/*Table structure for table `clients` */

DROP TABLE IF EXISTS `clients`;

CREATE TABLE `clients` (
`id` int(100) unsigned DEFAULT NULL COMMENT ', , , , , , , , , , ',
`title` tinytext,
`firstName` tinytext,
`lastName` tinytext,
`address1` tinytext,
`address2` tinytext,
`town` tinytext,
`province` tinytext,
`country` tinytext,
`postCode` tinytext,
`email` tinytext,
`telephone` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `clients` */

insert into `clients`(`id`,`title`,`firstName`,`lastName`,`address1`,`address2`,`town`,`province`,`country`,`postCode`,`email`,`telephone`) values (NULL,'Mr','Phearum','Kem','Khmer','sd','a','d','ad','1111111','[email protected]','012121212');

/*Table structure for table `feedback` */

DROP TABLE IF EXISTS `feedback`;

CREATE TABLE `feedback` (
`id` int(100) unsigned DEFAULT NULL,
`title` tinytext,
`Name` tinytext,
`position` tinytext,
`company` tinytext,
`email` tinytext,
`telephone` tinytext,
`address` tinytext,
`comment` text
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `feedback` */

insert into `feedback`(`id`,`title`,`Name`,`position`,`company`,`email`,`telephone`,`address`,`comment`) values (NULL,'Mr. ','
Notice: Undefined variable: name in D:localhost hmordafeedback.php on line 94
','','','
Notice: Undefined variable: email in D:localhost hmordafeedback.php on line 99
','','','');

/*Table structure for table `room` */

DROP TABLE IF EXISTS `room`;

CREATE TABLE `room` (
`roomnumber` int(100) DEFAULT NULL COMMENT ',,,, , ',
`type` tinytext,
`guest` tinytext,
`checkin` date DEFAULT NULL,
`checkout` date DEFAULT NULL,
`status` int(100) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `room` */

/*Table structure for table `rooms` */

DROP TABLE IF EXISTS `rooms`;

CREATE TABLE `rooms` (
`roomid` int(100) unsigned DEFAULT NULL,
`type` tinytext,
`guest` tinytext,
`checkin` date DEFAULT NULL,
`checkout` date DEFAULT NULL,
`status` int(100) DEFAULT NULL,
`noteother` tinytext
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `rooms` */

insert into `rooms`(`roomid`,`type`,`guest`,`checkin`,`checkout`,`status`,`noteother`) values (12,'Single (FAN) - $6 / Night','b','2013-08-26','2013-08-27',0,'Well'),(12,'Double (AC) - $16 / Night','d','2013-08-28','2013-08-29',0,'Well');

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Add new comment

About text formats