text:
Paya Bay Resort
No prices found through our partners. Please contact the business directly or check some of our recommended alternatives.
How has this resort rated in the past?
- Adjoining Rooms
- Suites
- Room service
- Swimming pool
- Outdoor pool
- Restaurant
Travelers also looked at:
Historical Traveler Reviews Paya Bay Resort Roatan
Excellent dive operation on unspoiled, quiet reefs
Paya Bay resort is on the VERY quiet East end of the Island. If you're coming to dive then this is without doubt the place to stay. If you want gourmet food and nightlife stay somewhere else (West end)
Justin runs the dive operation and it is outstanding. Ven is one of the divemasters who is also excellent; very knowledgeable about the area. Richard does a fabulous job of manning the boat and taking care of your equipment and cameras etc.
This is the only dive operation that runs out of the East end. We never saw another dive boat the whole time we were there. We saw a whale shark - 24' long (as big as the boat!).
The reefs are young and topographically they are really interesting given that they are of volcanic origin. Tons of parrotfish and squirrelfish; take your camera as there's a huge blue parrotfish that lives at one of the sites (ask Ven; he'll know).
The coral is worth lingering over for some great pictures. There was virtually no current so it's easy stress-free diving; a great place to go if you want to learn too! (also great for novice underwater photography)
The resort:
The room we stayed in (#5) was lovely. Very provate small balcony that gets the sun in the morning and overlooks the sea. Great through breeze so you really don't need the (very noisy) air conditioning or (very noisy) ceiling fan. The bathroom is OK; just a shower, no bath. Bed's really quite comfy.
Food: Breakfast is the best meal of the day. Justin tends to get lunch orders placed ahead of time so you don't have to wait (for ages!) for your food once you've ordered it. Dinner is OK if you like lobster & other seafood. Wine is OK. Not much of a selection & they didn't have red when we first arrived but at $25US a bottle it's OK (mostly Chilean & Californian).
Service is SLOW and unless you really specify they don't seem to get the concept of a starter 'followed by' a main course; they tend to bring it all at once.
Having said this, there is a fridge in your room if you are so inclined to bring some snacks with you.
There are NO loungers at Paya Bay; not ONE comfortable chair so if you're looking to lounge around in the sun your option is one of the 2 beaches where you'll probably get bitten all over by sand-flies.
Having said all this we would definitely recommend the resort for divers.
Personal service in paradise
Paya Bay is a beautiful, secluded resort on the East side of Roatan. Although Paya Bay does not have a 48' dive boat or a collection of dolphins all penned up.....they do offer PERSONAL SERVICE!!!! At Paya Bay there are only about 8 rooms, so you will not be lost in the crowd. The food at Paya Bay is great...but chef Charlie is always willing to accomodate to your needs or tastes and Tom will make drinks guaranteed to make you relax. If you want to get away from it all (including tv)...and enjoy world class diving...then Paya Bay is the best.
A wonderful young lady named Gretchen handles the reservations at Paya Bay and is extremely prompt and friendly at answering all your questions.
We also must mention Gina. She has the biggest, friendliest smile and is an A+ tour guide if you want to spend a day seeing the island.
Although I have dove in Hawaii, Bahamas and the Florida Keys...there is no comparison!!! I decided to get "re-certified" on this trip while my friend Sheri was getting certified . Sheri had never dove before and had a bit of anxiety about the whole process. When I made arrangements to do this, Justin (the dive instructor) said he would be working individually with us all week. I didn't believe him...but still went ahead with my plans. Well, Justin literally spent the week with just us....it was amazing!!!! Diving lessons in the morning....course work in the afternoon. Justin was an extremely good teacher...very patient...but with just enough prodding. On Sheri's first day of diving she had a huge eagle ray pass right next to us. Over the week we experienced beautiful corals, tropical fish and so much more! Although this was my first attempt at underwater photography...I am sending along a photo.
Steve & Sheri
Fantastic retreat and service
Felt like being with close friends and family all week.warm and inviting. best location on Roatan. remote and peaceful. 2 private beaches. excellent diving w/their own dive masters. rooms with ocean balconies, classy and comfortable.delicious meals. only 15 other guests. Will be back!
Like staying with family & Diving secluded pristine reefs!
If you're looking for an intimate, off the beaten path resort where you are treated like family and dive undisturbed by other dive boats, book your trip now for Paya Bay which sits on the East end of Roatan. We just returned from a one week all-inclusive stay in a cottage-like room at Paya Bay and thoroughly enjoyed the varied and wonderful meals cooked to order - no buffet lines here! The dive crew is friendly and knowledgeable of the area and follow the 'look don't touch' mantra. Unfortunately, we hear that dive resorts on the West end of Roatan regularly feed and harass for the entertainment of visiting divers. Our gear was rinsed and hung nightly for us - all we had to do was show up and enjoy all that the reefs have to offer. Be ready for sensory overload on some dives where there's so much to see you don't know where to look. Lovely people, great diving, good food and beautiful views.
Paya Bay is Awesome
My wife and I just returned from an NCL cruise which stopped at the island of Roatan. We heard reviews of Paya Bay but never imagined it would be this good. We had spent the days at our other ports near town, site seeing and decided to do an excursion on Roatan since we had never been to that island before. It is a long drive to get out to the resort but made for a good tour of the island. The location of the resort is sweet: sitting atop a bluff with two basically private beaches. We were the only people there from the cruise but they had 4 guests at the resort spending a week, whom we had lunch with.
Food and service were excellent. The waitress and chefs talked to us for awhile and made us feel very welcome. We felt Roatan had the friendlist people of all the spots we stopped at. However the poverty in certain areas around town is quite apparent.
I guess the best part at Paya Bay was the snorkeling. Justin and his crew at the dive shop took us to a nearby site and we got in about 2 hours of snorkeling. They were overly accomodating leading us around, helping with snorkeling techniques and pointing stuff out. The people we had lunch with were able to dive at the same place and spent some time snorkeling with us after their dive.
We are planning on returing next year to spend a week now that we know about Paya Bay. So I highly recommend this wonderful secret oasis in Roatan.
Our trip to Paya Bay....
We were on the Island of Roatan, a few months ago. I must say our stay at Paya Bay Beach Resort was one of the best we've ever had. Its a familly owned and operated resort. The food was autentic Island , or quite an elaborate selection of latin and American cuizine.
The owners, Mervin & Lurlene, well theres no one word for their excelent services. They went beyound and above our expectations, to make sure our stay with them was a vacation we would never ever forget, and guess what? We won't. Thank you and your wonderful staff for showing my family and me,what a true vacation in Paridise is all about.
Diving on the east end of the island is incredible!! Much to see, the coral is vibrant with coler, fish, in abondance, and we even saw a turtle!!
We most definately recomend, this small but well staffed and operated resort.
And we plan to return next summer.
Dona & Family,
Houston, TX.
My trip to Paya Bay was fantastic! I went there last year, and have already made reservations to go next year. The service and sincere kindness of the owners and employees was wonderfully refreshing. The laid back atmosphere, fresh air, beautiful scenery, scuba diving/snorkeling, boat tour to neighboring cays, culture, bright sunshine, and so much more was everything I (or anyone) could want in a vacation. Truly an amazing place; you must go there!
Paya Bay Resort, The Ultimate Escape
Paya Bay Resort would have to ranked as our best weeks vacation yet in the Caribbean for the following reasons:
1. The resort is small and intimate. They have 10 rooms on the East end of the island away from most development.
2. The views from everywhere on the resort are spectacular.
3. The resort has two beaches and one is a secluded private beach.
4. The owners are two of the nicest people on this earth..
5. The construction of this resort was truly a labor of love. The restaurant is truly unique with large patio areas and a deck area over looking the ocean.
6. The rooms are so unique you must see them on the web site.
7. The food was excellent. Lobster, shrimp, steaks and smoked pork chops from menu.
8. The diving on the East end is on reefs that are undisturbed and pristine. These reefs still have a lot of fish life unlike some other areas of West Roatan where some my dives in pevious years were almost fishless. Due to some storms, I was not able to dive all the new locations Justin has discovered. If the quality of the dives is more important than the quantity then you will like the East end diving as much as I did.
This is resort for people who want to de-stress and love the beauty of nature or want private romantic times. If you want continuous activity and marble bathrooms, this is not for you. This is an old style intimate Caribbean getaway.
This is a tropical setting so bring your bug spray and I recommend an itch zapper in case of a bug bites. Search google for "itch zapper".
I learned a lot about the history of Roatan from the owners. English is the first language of Roatan unlike the rest of Honduras and most of the schools on the East end are bilingual.
I flew Continental Airlines direct to the island of Roatan from Houston. They fly only on Saturday but his is a lot easier than connecting from the mainland of Honduras.
TripAdvisor Reviews Paya Bay Resort Roatan
Travel Blogs from Roatan
First two weeks/Getting settled in Roatan
Dec 5-19
We arrived in Roatan two weeks ago. The first week it rained for a few days, then the sun came out. After a couple days of unpacking and housekeeping we borrowed a car and drove to French Harbour for groceries shopping at "Eldon's" and the fish market. On our way home, after spending around $300 we did the math on home cooking vs …
Utila, partying paradise
... or change in dollars, potentially a problem. We were finger printed, all digits and thumbs, photographed, and stamps were administered. The whole thing took an hour and we got a combination of change in lempiras and dollars. At least there were no forms to fill in, and no customs searches. It turned out that we were charged 4 dollars (or equivalent) rather than what we were supposed to be charged to enter Honduras because the office "had ...
Roatan; great budget Caribbean diving, snorkelling
... 27C water. There was a lot of life around the wreck, for me the highlight was a hand full of big groupers and snappers, these massive fish swam up to greet us while we were descending towards the wreck. We only did a few dives because the snorkelling from the shore at West End Beach was fantastic, it was about a 5km walk on the sand from Moonlight Bay. Brilliant coral reef starts close to the beach and makes a steep drop that was great for freediving, we were ...
Scuba Scuba Scuba
... like a wreck dive where we swam through the cabin and buoyancy checks where we had a race on the ocean floor and swam through hoops. Although Utila is the area to see whale sharks unfortunately the elusive whale shark remains elusive, no other sharks or whales were spotted :( Had a great time with my dive team too (Chaf the Londoner and my dive buddy who never follows instructions, Lee from Beds ...
Ro-Ro- Roatan!
... t have to mess with it this morning.
The tour meets at the end of the pier so we meet up with our group and are delighted to discover that a mother/son duo (Ann and Brian) we've interacted with several times are amongst them. Either I knew and forgot or never knew that today's tour includes free drinks (alcohol only after snorkeling) and lunch on board the catamaran. Soon we're off.
The water is choppy and rough...definitely not ...


text:
Welcome to debase
Creating brilliant new comedies
Working in Brisbane and Melbourne, touring nationally and internationally, debase has been creating new shows since 1998.
debase produces a wide range of work for a wide range of audiences; from children's theatre to cabaret and everything in-between.
For debase, the relationship with our audience is paramount. This is reflected in the way we create and program work with and for specific audiences.
debase in 2016
Concerto for Harmony and Presto
Commissioned by Queensland Performing Arts Centre, Out of the Box.
A compelling story combining musical ingenuity and playful performances. Created for 3-8 year olds and their families, a theatrical and enchanting exploration of music as a communication tool for overcoming difference.
Find out more about Concerto for Harmony and Presto and bookings …
Lily Can't Sleep
A charming comedy for children created by comedy duo Liz Skitch and Bridget Boyle for the Out of the Box Festival and Queensland Theatre Company. Lily Can't Sleep returns for a short season at the Redlands Performing Arts Centre in April 2016.
Find out more about Lily Can't Sleep …
The Warmwaters
Comedy folk duo Warmwaters sing songs that are sweet, sour and saucy. Lena and Luke Warmwater have been described as "… the southern hemisphere's most inspirational nu-folk duo." Never heard of them? What's going on in your life!?
The Warmwaters will be hitting the stage at the Brisbane Powerhouse's Brisbane Cabaret Festival and the Redland Performing Arts Centre in June 2016.
Find out more about about The Warmwaters …
The Moulin Beige
Paris is home to the Moulin Rouge but Melbourne prefers her cheeky little sister, The Moulin Beige. Blending stand up comedy, cabaret and variety this old school vaudeville night will leave you feeling delightfully entertained.
Find out more about The Moulin Beige …
Keep an eye out for …
The Furze Family Variety Hour
Meet Red and Ginger Furze. They're the only remaining members of a once-great traveling vaudeville family. Sadly, all the other members have left, got real jobs, died … or moved to the Gold Coast.

subset: commoncrawl


text:
"Government has laid its hand on health, housing, farming, industry, commerce, education, and to an ever-increasing degree interferes with the people's right to know. Government tends to grow, government programs take on weight and momentum as public servants say, always with the best of intentions. But the truth is that outside of its legitimate function, government does nothing as well or economically as the private sector of the economy."
Related quotes
"Perfect freedom is as necessary to the health and vigor of commerce as it is to the health and vigor of citizenship."
"The progress of freedom depends more upon the maintenance of peace, the spread of commerce, and the diffusion of education, than upon the labors of cabinets and foreign offices."
"Sixty percent of our general budget goes to education. It would be ironic if electronic commerce erodes the science and math education that the visionary leaders of tomorrow need to keep this industry going."
"We are in touch with Commerce almost every day on a variety of issues. Anything the government is doing to keep piracy in check, we support. Obviously, only time will tell if it's enough."
"Politics without principles,Education without character,Science without humanity,and Commerce without morality are not only useless, but also positively dangerous."
"I think there is a bit of a concern out there regarding the health of their advertising and e-commerce revenues and some concern regarding the backlog. I think it's possible that they could miss the (ad and e-commerce) number."


text:
muted item in
Cobb County is a suburban county located in the U.S. state of Georgia. As of the 2015, the population was 741,334, making it the fourth-most populous county in Georgia. Its county seat and largest city is Marietta.
Cobb, along with several adjoining counties, was created on December 3, 1832, by the Georgia General Assembly from the huge Cherokee "county" territory—land northwest of the Chattahoochee River which the state confiscated from the Cherokee Nation and redistributed to settlers via lottery, following the passage of the federal Indian Removal Act. The county was named for Thomas Willis Cobb, a United States representative and senator from Georgia. It is believed that Marietta was named for his wife, Mary.
Cobb County is included in the Atlanta-Sandy Springs-Roswell, GA Metropolitan Statistical Area. It is situated immediately to the northwest of the city limits of Atlanta.
Its Cumberland District, an edge city, encompasses over 24,000,000 square feet (2,200,000 m2) of office space.
The U.S. Census Bureau ranks Cobb County as the most-educated in the state of Georgia and 12th among all counties in the United States. It has ranked among the top 100 wealthiest counties in the United States.


text:
ProteCol™ HPLC Columns Turn Imagination Into ResultsA premium inert HPLC column range delivering optimal peak shape.The ProteCol™ HPLC column range features proprietary column designs, incorporating inert materials throughout the flow path and the highest quality stationary phases. The combination of these factors delivers unparalleled separation performance. ProteCol™-P features a PEEK™ lining while ProteCol™-G uses a glass lining.ProteCol PBenefits of an inert flow path are:• Optimized analyte recovery.• Superior peak shape and reproducibility.• Less artifacts due to reduced carry over.
Long-term reproducibilityAll columns in the ProteCol™ range show a remarkable reproducibility of thousands of injections (subject to sample purity and mobile phase conditions).
Stability at pH 1:All columns in the ProteCol™ range show no deterioration when exposed to pH 1.0 buffers.
SGE Analytical Science Pty Ltd
7 Argent Place
Victoria 3134
Tel: +61 (0) 3 9837 4200
Fax: +61 (0) 3 9874 5672
Email: firstname.lastname@example.com
About Us | Advertise On This Site | Cookies | Contact Us | Home | Support | Terms & Conditions


text:
Get an overview of this hotelFamily-friendly resort with free breakfast and restaurant
This family-friendly Gili Trawangan resort is located by the sea, within 1 mi (2 km) of Gili Trawangan Market, Gili Trawangan Night Market, and Gili Trawangan Harbor. Pura Meru and Mayura Temple and Park are also within 32 mi (52 km).
Resort Features
Along with a restaurant, this resort has a fitness center and an outdoor tennis court. Free continental breakfast and free WiFi in public areas are also provided. Additionally, dry cleaning, multilingual staff, and wedding services are onsite.
Room Amenities
All 17 rooms boast private pools and offer free WiFi and patios. DVD players and refrigerators are standard, as are TVs with satellite channels.Information missing or incorrect? Tell us!Opens in a new window
Kelapa Luxury VillasJalan Kelapa Gili Trawangan Gili Trawangan 83355
Hotel Amenities
Hotel Amenities
Kelapa Luxury Villas features an outdoor tennis court and a fitness center. The resort offers a restaurant. A complimentary breakfast is offered. High-speed wireless Internet access is complimentary.
This family-friendly resort also offers barbecue grills, multilingual staff, and a garden. For a surcharge, the property provides a roundtrip airport shuttle (available on request) and a ferry terminal shuttle.
- Luggage storage
- Babysitting or childcare (surcharge)
- Ferry terminal shuttle (surcharge)
- Outdoor tennis court
- Year Built 2006
- Tennis on site
- Barbecue grill(s)
- Front desk (limited hours)
- Multilingual staff
- Free use of nearby fitness center
- Garden
- Total number of rooms - 17
- Number of buildings/towers - 17
- Airport transportation (surcharge)
- Babysitting or childcare
- Free breakfast
- Dry cleaning/laundry service
- Fitness facilities
- Free WiFi
- Restaurant
- Wedding services
Family Friendly Amenities
- Family Hotel
- Free Wi-Fi
- Outdoor tennis court
- Babysitting or childcare (surcharge)
- In-room childcare (surcharge)
- Refrigerator
- Microwave (on request)
- Cribs/infant beds (complimentary)
- DVD player
Available in all rooms: Free WiFi
Available in some public areas: Free WiFi
Room Amenities
- Shower only
- Free bottled water
- DVD player
- Satellite TV service
- Private pool
- Room service (limited hours)
- Television
- Refrigerator
- Minibar
- Coffee/tea maker
- Daily housekeeping
- Private bathroom
- Free toiletries
- Hair dryer
- In-room safe
- Air conditioning
- Ceiling fan
- Desk
- Patio
- Microwave (on request)
- Phone
- In-room massage available
- In-room childcare (surcharge)
- Free WiFi
- Free cribs/infant beds
- Rollaway/extra beds (surcharge)
Where to Eat
Guests are offered a complimentary continental breakfast.
Kelapa Luxury Villas has a restaurant on site.
Room service (during limited hours) is available.
Nearby Things to Do
Recreational amenities at the resort include an outdoor tennis court and a fitness center.
The recreational activities listed below are available either on site or nearby; fees may apply.
- Golfing nearby
- Snorkeling nearby
- Surfing/boogie boarding nearby
- Kayaking nearby
- Scuba diving nearby
- Hiking/biking trails on site
- Boat tours nearby
Spa Services
- Massages
Hotel Policies
Check-in time starts at 3 PM
Check-in time ends at midnight
Special check-in instructions:
Check-out time is 11 AM
Payment types
- No pets or service animals allowed
You need to know
Extra-person charges may apply and vary depending on hotel policy.
Government-issued photo identification and a credit card or cash deposit are required at check-in for incidental charges.
Special requests are subject to availability upon check-in and may incur additional charges. Special requests cannot be guaranteed.
No pets or service animals allowed
Optional extras
- Airport shuttle fee: IDR 1000000 per person (one way)
- Rollaway bed fee: IDR 500000 per night
Hotel Name
- Kelapa Luxury
- Kelapa Luxury Villas
- Kelapa Luxury Villas Gili Trawangan
- Kelapa Luxury Villas Hotel
- Kelapa Luxury Villas Hotel Gili Trawangan
- Kelapa Villas
- Kelapa Luxury Villas Gili Islands/Gili Trawangan
We should mention
This property offers transfers from the ferry terminal and airport (surcharges may apply). Guests must contact the property with arrival details before travel, using the contact information on the booking confirmation. Reservations are required for massage services. Reservations can be made by contacting the resort prior to arrival, using the contact information on the booking confirmation. One child 2 years old or younger stays free when occupying the parent or guardian's room, using existing bedding. Children may not be eligible for complimentary breakfast. No pets and no service animals are allowed at this property.


text:
Confident Tremlett ready to shine
Chris Tremlett has insisted he is a better bowler now than when he last played for England after he was recalled to the Test squad for this winter's tour to Australia.
Tremlett was rewarded for an impressive first season at Surrey when he was today named in a 16-man party charged with retaining the Ashes Down Under.
The giant pace bowler won the last of his three Test caps against India in 2007 but is confident he can make a big impact on his return to the international arena.
Tremlett told ecb.co.uk/video: "My confidence is as high as it's ever been and I feel I'm a much better bowler than I was a couple of years ago, even when I did play for England.
"Mentally I've got tougher with experience. I've learned a lot over the years.
"I'm also in form and hopefully I can take that form over to Australia and go from there."
"I'm bowling pretty sharply at the moment. My action feels strong and I'm definitely more consistent as a bowler. I've got a lot to offer."
Tremlett is excited by the prospect of claiming victory in Australia, having been 12th man for much of the series when England regained the Ashes on home soil in 2005 under Michael Vaughan.
The former Hampshire man also expects the conditions to suit his style of bowling and is keen to take advantage.
He added: "I was involved in 2005 and it was great to be around that, but to go over to Australia and try and beat them on their own patch - as tours go, this is the trip you want to be on.
"I've played a bit of club cricket in Australia and a couple of one-day internationals out there and generally the wickets are more suited to the taller guys.
"I know what to expect and I think the wickets will suit me."
Watch the full video interview with Chris Tremlett on ecb.co.uk/video


text:
Zardetto Brut Private Cuvee
Sku: 1654858*
Fabio Zardetto has created his own personal Cuvee-a blend of Glera (the new name for the Prosecco grape), for long-lasting, expressive citrus notes; Chardonnay, for rich body and creamy texture; and Muscat, for fresh floral and grapey aromas. This fine Cuvee manages to be both playful and refined at the same time-sure to please even the most discerning palates.
Item added to your cart


text:
NEMO Lighting is one of the global leaders in lighting striving to constantly create innovative cutting edge design. The collection of contemporary design includes models conceived by Carlo Forcolini, Jehs + Laub, Javier Mariscal, Karim Rashid, Ilaria Marelli, Foster+Partners, Hannes Wettstein and Roberto Paoli. Contemporary and simultaneously timeless, NEMO fixtures add a touch of luxury to modern spaces.
Rated 5 out of 5 by David O. from This pendant is perfect in every way! I think I looked at just about every pendant available and settled on this one. I don't regret it. It's simple shape whispers "elegant" without screaming for attention. I have it hanging in a small room above a Saarinen tulip table, they look like they were made to go together. It was very easy to install and gives off a beautiful soft light. The globe and hardware are well made. This light should also be made in a larger size, it might look a little small over a large table. This is one purchase I pat myself on the back for making every time I pass by.
Date published: 2011-11-07
Rated 4 out of 5 by Anonymous from Very Cool! I was looking for a cool ceiling lamp for my laundry room, which has 8ft ceilings. I am hanging this about 3" below the ceiling. Because of the 100 watt bulb, it is plenty of light and much cooler than any of the surface mount lights that I found. It is a bit smaller than I expected, but it still looks great.
Date published: 2013-11-15
Rated 4 out of 5 by Anonymous from Cut short it makes a nice alternative to a surface mounted ceiling fixture While it took a little bit longer to install than I had hoped, the fixture worked great as a solution for a surface mount ceiling fixture. Having trouble finding something that would work here, I cut the cord down to just 4" and hung it in the hallway. I am back on the site buying more for other hallways and the laundry room. I was able to put a very short 13 watt compact fluorescent inside without having too much of a hot spot on the bottom. The glass is nice and the mechanism for re-lamping is fast and easy to use.
Date published: 2013-01-09
Rated 4 out of 5 by Catherine J S. from SImple, timeless design, inviting glow The light is inviting -- one works wonderfully over a kitchen sink and in the adjoining cafe table. The right accent for a mid-century home.
Date published: 2009-10-12
Rated 3 out of 5 by Anonymous from Nice, but... I have 2 comments, first one is that the canopy seems to screw in with one screw not two as most canopys do. The canopy doesn't sit flush to ceiling as a result. The clear clips that hold the globe are more visable than I'd like.
Date published: 2012-06-11
Rated 3 out of 5 by Andrea S. from Love it! It's simple, timeless and elegant. Looks great in a hallway. I bought one, had it hung, and then hours later, the globe came crashing to the ground, even though it was hung properly. I called YLighting Customer Service and they promptly spoke to the vendor and the next day I received a new globe. We noticed that the new one was thicker and had a smaller opening- so there was some defect in the globe. If there hadn't been such great customer service, I don't think I would have bought the second one for the other hallway!
Date published: 2011-04-11
Rated 2 out of 5 by CHBD from Yes and NO I love the globe, but the ceiling adapter is terribly cheap and gaudy. The housing has the look of a Chinese-made product. They just don't match. It was also unusually difficult to install.
Date published: 2011-05-02
Maga Pendant is rated out of 5 by 7.


text:
Using What We've Learned
Over the last year, we have looked at ways to create sophisticated web sites using little more than CGI programs written in Perl. Among other things, we have explored HTML/Perl templates (for separating design from programs), HTTP cookies (to identify returning users) and relational databases (to store information in a readily retrievable format while gaining robustness and security).
This month, we will see how we can use all of these techniques together. Such a combination of techniques is used on many commercial sites and is the basic idea behind several web server projects, including Microsoft's Active Server Pages (ASPs), Vignette's StoryServer, AOL's freely distributed AOLServer and the freely distributable PHP/FI.
Note that many of the examples in this month's installment refer to techniques and ideas that were discussed in previous issues of Linux Journal. If you are new to the magazine or to the ideas, please see the "Resources" sidebar, which should give you some good starting points for learning about these subjects.
Our example site will revolve around a single table tracking users' birthdays. Once we have created the table for the birthdays, we will write a CGI program that allows users to enter their birthdays into the table. Finally, we will combine the use of cookies and Perl/HTML templates to create personalized home pages drawing upon the information stored in the database.
Assuming that MySQL is our relational database server and that our table will be in the "test" database, at the prompt type the command:
mysql test
This starts the MySQL client, allowing us to enter SQL queries interactively. The "test" database used in these examples comes with MySQL and is completely insecure—it cuts down on the space required to explain how to secure new databases created with MySQL. As a result, you should seriously consider creating separate databases and users for each of your web applications, so as to reduce the risk of unauthorized users modifying or viewing data on your system.
First, we must create a table with information about our users and their birthdays. Here are some simple SQL commands that create such a table:
mysql> create table birthdays (person_id int unsigned auto_increment, -> firstname varchar(15) not null, -> lastname varchar(15) not null, -> email varchar(50) not null primary key, -> birthdate date not null, -> key id (person_id));
This creates the "birthdays" table in the "test" database. The table has five columns (person_id, firstname, lastname, email and birthdate), none of which may be blank. Each row in the table represents a distinct user whose birth date we wish to track; we ensure that no user is entered twice by setting the "email" column to be a primary key, which is a fancy way of saying that no value of "email" may be repeated. Since users may have multiple e-mail addresses, we cannot ensure that a user will not enter his or her birthday twice. However, this is likely to reduce such repetition, and is better than using the person's name, which is rarely unique.
The first column, person_id, will be set automatically by MySQL each time we add a user to the database. The first entry in the system will have person_id set to 1, the second entry will have it set to 2 and so forth. Because person_id is of type int unsigned, our system can accept no more than 4,294,967,295 unique entries—smaller than your particular database might need, but large enough for most of my purposes.
We can get a good picture of our database using the "describe" command at the "mysql" prompt, as follows:
mysql> describe birthdays; Field Type Null Key Default Extra person_id int(10) unsigned MUL 0 auto-increment firstname varchar(15) lastname varchar(15) email varchar(50) PRI birthdate date 0000-00-00
Now that we have created the infrastructure, we need applications that will allow people to enter their birthdays. The easiest way to do this is to create an HTML form whose contents are submitted to a CGI program that takes information from the form and saves it to the database. One such form is shown in Listing 1.
The form is relatively straightforward, although it might seem a bit daunting because of the long selection lists defined using the "select" and "option" tags. Using such lists, rather than allowing the user to enter a birthday into a text field, reduces the number of errors that a user might enter. It is certainly possible, though, that someone could create an HTML form with identical field names, using text fields instead of selection lists, and thus circumvent our system. The moral, then, is that you should always try to reduce the number of errors that users might enter, but always check to be certain that data were entered correctly.
As you can see from looking at Listing 1, our form gathers six pieces of information: first name, last name, e-mail address and user's birth month, day and year. The latter three pieces of information are separated so that we can simplify the user interface; as we will soon see, combining these to create an valid MySQL "date" type is fairly simple.
Our form's "form" tag indicates that data should be submitted using the POST method to a CGI program named "enter-birthday-info.pl".
We take the user's input and create a SQL query that creates a new entry in the table:
# Now that we have the basic information, create # an SQL query my $command = "insert into birthdays "; $command .= "(firstname, lastname, email, birthdate) "; $command .= "values "; $command .= "(\"$firstname\", \"$lastname\", \"$email\", \"$birthdate\")";
Of course, you do not need to store the command in the variable $command. Indeed, you can create the command directly when using $dbh->query, rather than putting it together and then passing $command as an argument to $dbh->query. Putting the query together in this fashion makes it easier to read when programming and easier to send the SQL query to the screen if bugs appear.
After we send our query to the database server, the row is probably added. However, we do not want to just assume it was added because something serious might have happened, and we wish to give a correct indication of the outcome to the user.
First, we check to see if $dbh->errno--the value of an error returned by MySQL—was set to 2000. This is the specific error code returned when trying to insert a row that conflicts with another row. Since we have defined "email" to be a primary key, the odds are rather high that if errno is set to 2000, then we have tried to enter a duplicate e-mail address:
if ($dbh->errno == 2000) { &log_and_die( "There is already an entry in\ the database for \" $email\". Try another\ e-mail address!"); }
If this was not the case, then we should check for any other error. The easiest way to detect errors is to see if $sth is undefined; if it has not been given any value, then an error occurred, which we identify for the user and in the error log. Note that our general error-catching mechanism needs to come after the mechanism for catching error 2000.
elseif (!defined $sth) { &log_and_die("MySQL error " . $dbh->errno . "\ on command \"$command\"
" . $dbh->errmsg) unless (defined $sth); }Finally, if no errors occurred, then we can print a message indicating success:
else { # Return something to the user print "
Done!
\n"; }
Trending Topics
|Epiq Solutions' Sidekiq M.2
|Sep 26, 2016
|Nativ Disc
|Sep 23, 2016
|Android Browser Security--What You Haven't Been Told
|Sep 22, 2016
|The Many Paths to a Solution
|Sep 21, 2016
|Synopsys' Coverity
|Sep 20, 2016
|Naztech's Roadstar 5 Car Charger
|Sep 16, 2016
- Android Browser Security--What You Haven't Been Told
- Epiq Solutions' Sidekiq M.2
- Readers' Choice Awards 2013
- The Many Paths to a Solution
- Nativ Disc
- Download "Linux Management with Red Hat Satellite: Measuring Business Impact and ROI"
- Synopsys' Coverity
- Securing the Programmer
- RPi-Powered pi-topCEED Makes the Case as a Low-Cost Modular Learning Desktop
- Returning Values from Bash Functions
Geek Guides
With all the industry talk about the benefits of Linux on Power and all the performance advantages offered by its open architecture, you may be considering a move in that direction. If you are thinking about analytics, big data and cloud computing, you would be right to evaluate Power. The idea of using commodity x86 hardware and replacing it every three years is an outdated cost model. It doesn't consider the total cost of ownership, and it doesn't consider the advantage of real processing power, high-availability and multithreading like a demon.
This ebook takes a look at some of the practical applications of the Linux on Power platform and ways you might bring all the performance power of this open architecture to bear for your organization. There are no smoke and mirrors here—just hard, cold, empirical evidence provided by independent sources. I also consider some innovative ways Linux on Power will be used in the future.Get the Guide


text:
Hotel Novotel Rotterdam-Schiedam
Hargalaan 2
3118 JA Schiedam
Hargalaan 2
3118 JA Schiedam
Novotel Rotterdam Schiedam is a 4-star hotel on the edge of Schiedam. It is located on Rotterdam's ring road, close to Europoort. Downtown Rotterdam and the airport are both easily accessible by car, tram or train. Enjoy a day of shopping in Schiedam or visit Delft's historic center, only 15 minutes' drive away. Whether you are visiting for a city break, meeting or business trip, you will quickly feel at home at Novotel.
Near the hotel, the beautiful wild gardens of the Prinses Beatrixpark are ideal for romantic walks. There are also plenty of cultural attractions, including the Stedelijk Museum Schiedam. Boijmans Van Beuningen Museum or the Chabot Museum. The Nieuwemarkt and Pannekoekstraat - aka the Soho of Rotterdam - are perfect for a spot of shopping. And don't forget to enjoy Rotterdam's lit up skyline at night.
This hotel participates to Planet 21 and is acting in favour of Positive Hospitality.
Online check-in: Your arrival will be carefully prepared by our team
Fast check-out: Simply return your key
Online check-in: Your arrival will be carefully prepared by our team
Fast check-out: Simply return your key
Hargalaan 2
Tel: (+31)104713322
Fax: (+31)104700656
The spacious rooms at the Novotel are furnished in a contemporary style with a flexible layout. They are enjoyable to stay in and will meet all your requirements.We treat your children as our VIP guests. Accommodation and breakfast are free of charge for one child up to 16 years when sharing a room with their parents or grandparents.
All the benefits of a Superior Room with added products and services: double bed, bathrobe, slippers, luxury toiletries, Nespresso. Free ADSL and Wi-Fi Internet and bottle of water. Up to 2 adults and 2 children.
Enjoy staying in a modern and spacious room with double bed, sofa bed, air conditioning, minibar, tea and coffee making facilities, safe, flat-screen TV, radio, telephone and Internet: Wi-Fi (free) or ADSL (paying). Up to 2 adults and 2 child.
When making a booking at this hotel:


text:
Toyota of Fort Worth Auto Parts - Serving Dallas with Toyota Car Parts
Toyota of Fort Worth is proud to serve the Dallas, TX region with OEM Certified Toyota auto parts and accessories. Are you thinking about repairing your used car or upgrading your new Toyota car, truck or SUV on your own? Then we highly suggest using genuine Toyota auto parts for the job. Not only will there be a much lower risk of you affecting your vehicle's warranty but you will also have the peace of mind that you've used the same high quality auto parts that your vehicle was built with at the Toyota factory.
Do you know your car needs a new part but not quite sure which part exactly that it needs? We encourage you to have a chat with one of our auto parts specialists. They are highly knowledgeable when it comes to parts, and even more so when it comes to Toyota parts. Let them know what the issue is or what job you want to get done and they will point you in the direction of the exact part or accessory you need.
From oil filters and batteries to A/C compressors, starters, and water pumps, the Toyota of Fort Worth parts store is stocked from wall to wall and has you covered. If you already know what part you need you can order it from the comfort of your home by using our online parts order form.
Here at Toyota of Fort Worth we are huge advocates of Do-It-Yourself jobs. However if your vehicle is in need of a major job, such as your brakes, exhaust system or other big jobs we highly recommend considering having the expert technicians of our Toyota auto service and repair center do it for you. We say this not only to make sure you get the highest quality of work done and to help keep your warranty in tact, but also for your safety. There are some jobs that you just don't want to risk even the slightest error, and with our service department you don't have to worry about that.
Any questions? Feel free to contact an associate in our Toyota parts store during normal business hours. You can reach us by phone at 866-295-8384 or in person at 9001 Camp Bowie West.


text:
Cinema scene: Upcoming film events around town
'Trouble with the Curve'
Director: Robert Lorenz
Starring: Clint Eastwood, Amy Adams, John Goodman
Rating: PG-13
Run time: 111 minutes
Genre: Drama
What it's about: As his health declines, aging baseball scout Gus (Eastwood) takes his daughter (Adams) along for one last trip to check out a player.
Highlights/lowpoints: Despite the interesting and sometimes charming moments of this film, the plot meanders a bit. While Eastwood takes on another grumpy guy role, Adams and Justin Timberlake add unexpected shine to the story.
Details: Saturday, Nov. 10, at 8 p.m., and Tuesday, Nov. 13, at 7:30 p.m. at the Fredonia Opera House, 9 Church St., in Fredonia, N.Y. Cost: $7; $6.50, members and senior citizens; $5, children and students.
'Dislecksia: The Movie'
Director: Harvey Hubbell V
Starring: Billy Blanks, Sarah Brown, Stephen J. Cannell
Rating: Not rated
Run time: 86 minutes
Genre: Documentary
What it's about: The film follows the director's own experiences with dyslexia, and features talk with others about the disability.
Details: Friday, Nov. 9, at 2:15 and 7:15 p.m., at the Taylor Little Theatre, Mercyhurst University. A Q-and-A with director Harvey Hubbell V will follow the 2:15 p.m. show and a panel discussion will follow the 7:15 p.m. show. Cost: $6; $5, seniors and students; $4 for President's cardholders. Part of the On Screen/In Person Film Series.
'Attack of the Block'
Director: Joe Cornish
Starring: John Boyega, Jodie Whittaker, Alex Esmail
Rating: R
Run time: 88 minutes
Genre: Action/Comedy/Sci-Fi
What it's about: A group of South London teens band together to defend their neighborhood against an alien invasion.
Highlights/lowpoints: From the producers of "Shaun of the Dead" and "Hot Fuzz," this film has a fun mix of chills and laughs. Though it might be fast-paced and slightly amateurish, it's a charming little flick.
Details: Thursday, Nov. 15, 8:30 p.m., at the Frank G. Pogue Student Center Multi-Purpose Room, Edinboro University of Pennsylvania. Cost: $2; free for students and faculty ID.
'The Mayor'
Director: Jared Scheib
Starring: Sam Berger, Cordy Frieze, Dorothy June Wyll
Rating: Not rated
Run time: 68 minutes
Genre: Documentary/Comedy/Drama
What it's about: Based on the true story of a flirtatious 88-year-old man, a widow and a gossiper living it up at a Texas retirement home.
Details: Wednesday, Nov. 14, 8 p.m. (doors open at 7 p.m.) at the Erie Art Museum. Cost: $5. Part of the FILM at the Erie Art Museum series.
-- from staff and wire reports