Online Guest House

Submitted by sanbunna9 on Wednesday, April 24, 2013 - 15:07.

Language

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

Comments

Submitted byAnonymous (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 byAnonymous (not verified)on Wed, 04/24/2013 - 20:05

where is the database
Submitted byAnonymous (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 byAnonymous (not verified)on Thu, 04/25/2013 - 11:27

where is the database ... please send the database to me [email protected] ..thanks
Submitted byAnonymous (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 byAnonymous (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 byAnonymous (not verified)on Sat, 07/13/2013 - 23:30

Your ZIP can not open please check that, and upload again for us
Submitted byAnonymous (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 bydisan 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 bykena (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 bysanbunna9on 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 byHanson 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 bydevsi07on 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