Lifestyle | Philstar.com
A portal of daily newspapers covering Philippine news headlines, business, lifestyle, advertisement, sports and entertainment. Also delivers Manila and Cebu news.
- Philstar.com
- The Philippine Star
- Pilipino Star Ngayon
- The Freeman
- Pang-Masa
- Banat
- Interaksyon
SUPPORT PHILSTAR
About Us |
Contact Us |
Advertise |
Privacy Policy |
Member Agreement |
Copyright Notice
Copyright © 2024. Philstar Global Corp. All Rights Reserved
-
nav
lifestyle==
HOME - HEADLINES
- OPINION
- NATION
- WORLD
- BUSINESS
- SPORTS
- ENTERTAINMENT
- LIFESTYLE
- OTHER SECTIONS
X
Array ( [0] => Array ( [id] => 360 [tag] => MISS UNIVERSE 2023 [url] => https://www.philstar.com/tags/miss-universe-2023 ) [1] => Array ( [id] => 350 [tag] => EVENTS AND HAPPENINGS [url] => https://www.philstar.com/tags/events-and-happenings ) [2] => Array ( [id] => 343 [tag] => CORONATION [url] => https://www.philstar.com/tags/coronation ) [3] => Array ( [id] => 336 [tag] => MISS UNIVERSE 2022 [url] => https://www.philstar.com/tags/miss-universe-2022 ) [4] => Array ( [id] => 57 [tag] => ARTS AND CULTURE [url] => /lifestyle/arts-and-culture ) [5] => Array ( [id] => 270 [tag] => THE BUDGETARIAN [url] => /lifestyle/the-budgetarian ) [6] => Array ( [id] => 58 [tag] => BUSINESS LIFE [url] => /lifestyle/business-life ) [7] => Array ( [id] => 60 [tag] => FASHION AND BEAUTY [url] => /lifestyle/fashion-and-beauty ) [8] => Array ( [id] => 46 [tag] => FOOD [url] => /lifestyle/food-and-leisure ) [9] => Array ( [id] => 59 [tag] => HEALTH AND FAMILY [url] => /lifestyle/health-and-family ) [10] => Array ( [id] => 64 [tag] => ON THE RADAR [url] => /lifestyle/on-the-radar ) [11] => Array ( [id] => 67 [tag] => PETS [url] => /lifestyle/pet-life ) [12] => Array ( [id] => 47 [tag] => TRAVEL [url] => /lifestyle/travel-and-tourism ) [13] => Array ( [id] => 66 [tag] => SHOPPING [url] => /lifestyle/shopping-guide ) [14] => Array ( [id] => 61 [tag] => MODERN LIVING [url] => /lifestyle/modern-living ) [15] => Array ( [id] => 63 [tag] => GADGETS [url] => /lifestyle/gadgets ) )
Array ( [total] => 12 [items] => Array ( [0] => Array ( [SectionID] => 3 [SectionName] => Arts and Culture [SectionUrl] => arts-and-culture ) [1] => Array ( [SectionID] => 110001 [SectionName] => The Budgetarian [SectionUrl] => the-budgetarian ) [2] => Array ( [SectionID] => 6 [SectionName] => Lifestyle Business [SectionUrl] => business-life ) [3] => Array ( [SectionID] => 7 [SectionName] => Fashion and Beauty [SectionUrl] => fashion-and-beauty ) [4] => Array ( [SectionID] => 5 [SectionName] => Food and Leisure [SectionUrl] => food-and-leisure ) [5] => Array ( [SectionID] => 4 [SectionName] => Health And Family [SectionUrl] => health-and-family ) [6] => Array ( [SectionID] => 19 [SectionName] => On the Radar [SectionUrl] => on-the-radar ) [7] => Array ( [SectionID] => 13 [SectionName] => Pet Life [SectionUrl] => pet-life ) [8] => Array ( [SectionID] => 11 [SectionName] => Travel and Tourism [SectionUrl] => travel-and-tourism ) [9] => Array ( [SectionID] => 18 [SectionName] => Shopping Guide [SectionUrl] => shopping-guide ) [10] => Array ( [SectionID] => 9 [SectionName] => Modern Living [SectionUrl] => modern-living ) [11] => Array ( [SectionID] => 15 [SectionName] => Gadgets [SectionUrl] => gadgets ) ) )
top_news
Array ( [0] => Array ( [ArticleID] => 2348658 [Title] => Pertussis outbreaks: Doctor consultations, medicine delivery [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/22/coughing_2024-03-22_14-47-26673_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/22/coughing_2024-03-22_14-47-26673.jpg [Tiny] => https://media.philstar.com/photos/2024/03/22/coughing_2024-03-22_14-47-26673_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/health-and-family/2024/04/19/2348658/pertussis-outbreaks-doctor-consultations-medicine-delivery ) [1] => Array ( [ArticleID] => 2348887 [Title] => Issa Pressman sizzles at Kenzo event, bares summer must-haves [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/19/issa-summer_2024-04-19_09-57-57252_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/19/issa-summer_2024-04-19_09-57-57252.jpg [Tiny] => https://media.philstar.com/photos/2024/04/19/issa-summer_2024-04-19_09-57-57252_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/fashion-and-beauty/2024/04/19/2348887/issa-pressman-sizzles-kenzo-event-bares-summer-must-haves ) [2] => Array ( [ArticleID] => 2348885 [Title] => Issa Pressman shares 'bonding experience' with James Reid [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/19/isssa-james-bonding_2024-04-19_09-44-16494_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/19/isssa-james-bonding_2024-04-19_09-44-16494.jpg [Tiny] => https://media.philstar.com/photos/2024/04/19/isssa-james-bonding_2024-04-19_09-44-16494_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/fashion-and-beauty/2024/04/19/2348885/issa-pressman-shares-bonding-experience-james-reid ) [3] => Array ( [ArticleID] => 2348883 [Title] => Issa Pressman shares styling advice [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/19/issa-kenzo_2024-04-19_09-28-12264_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/19/issa-kenzo_2024-04-19_09-28-12264.jpg [Tiny] => https://media.philstar.com/photos/2024/04/19/issa-kenzo_2024-04-19_09-28-12264_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/fashion-and-beauty/2024/04/19/2348883/issa-pressman-shares-styling-advice ) )
UK-based chefs create Filipino-inspired dishes
Negros-based rum Don Papa tapped two award-winning chefs based in the United Kingdom to create a dinner menu inspired by Filipino flavors.
q1 - SELECT ar.ArticleID, ar.Title, ar.DatePublished, se.SectionUrl, im.Alt, im.URL, ar.PostType, (Views + Comments + Shares) as pop FROM ArticlesRevised AS ar LEFT JOIN Images AS im ON ( ar.ArticleID = im.ArticleID AND im.ImageType = 'Thumbnail' ) LEFT JOIN ArticleStats as st on (ar.ArticleID = st.ArticleID) LEFT JOIN Articles_to_Sections as asec on (ar.ArticleID = asec.ArticleID) LEFT JOIN Sections as se on (asec.SectionID = se.SectionID) LEFT JOIN PriorityBypass as pb on (pb.ArticleID = ar.ArticleID AND pb.Section = 'Trending' AND pb.DateEnd > '2024-04-19') WHERE pb.Section is not null AND ar.Status = 'Approved' AND ar.PublicationID = :pid AND (asec.SectionID in (select SectionID from Sections where SectionID = 16 or Parent = 16)) AND pb.Weight is not null AND asec.Position = 1 ORDER BY pb.Weight DESC, pop DESC LIMIT 0, 4
Array ( [:pid] => 1 )
bakit wala
q2 - SELECT tr.Position, ar.ArticleID, ar.Title, ar.DatePublished, se.SectionUrl, im.Alt, im.URL, ar.PostType FROM ArticlesRevised AS ar LEFT JOIN Images AS im ON ( ar.ArticleID = im.ArticleID AND im.ImageType = 'Thumbnail' ) LEFT JOIN Trending as tr on (ar.ArticleID = tr.ArticleID) LEFT JOIN Articles_to_Sections as asec on (ar.ArticleID = asec.ArticleID) LEFT JOIN Sections as se on (asec.SectionID = se.SectionID) WHERE ar.PublicationID = :pid AND (tr.SectionID in (2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,22,43,136,110001)) AND ar.ArticleID not in (0,2348662,2348658,2348887,2348885,2348883) AND asec.Position = 1 ORDER BY tr.Position LIMIT 0, 4
Array ( [:pid] => 1 )
data_lifestyle_trend
Array ( [total] => 4 [items] => Array ( [0] => Array ( [Position] => 2 [ArticleID] => 2348512 [Title] => Kathryn Bernardo, family's new home has elevator, slide, arcade [DatePublished] => 2024-04-18 08:42:00 [SectionUrl] => entertainment [Alt] => [URL] => https://media.philstar.com/photos/2024/04/17/kathryn-bernardo-new-house_2024-04-17_22-49-10713_thumbnail.jpg [PostType] => Standard ) [1] => Array ( [Position] => 4 [ArticleID] => 2348705 [Title] => 'Crazy Rich Asians' director to helm Broadway adaptation for stage debut [DatePublished] => 2024-04-18 20:08:00 [SectionUrl] => arts-and-culture [Alt] => [URL] => http://media.philstar.com/images/articles/wu-golding_2018-08-28_13-48-07176_thumbnail.jpg [PostType] => Standard ) [2] => Array ( [Position] => 11 [ArticleID] => 2348362 [Title] => ‘It’s magical!’: Where Kathryn Bernardo found healing from breakup with Daniel Padilla [DatePublished] => 2024-04-17 13:56:00 [SectionUrl] => health-and-family [Alt] => [URL] => https://media.philstar.com/photos/2024/04/17/kath-cover_2024-04-17_13-57-1175_thumbnail.jpg [PostType] => Exclusive ) [3] => Array ( [Position] => 13 [ArticleID] => 2348637 [Title] => James Reid bares sandos collection; gives tips to girls shopping for boys [DatePublished] => 2024-04-18 12:59:00 [SectionUrl] => entertainment [Alt] => [URL] => https://media.philstar.com/photos/2024/04/18/james-sando_2024-04-18_13-00-1332_thumbnail.jpg [PostType] => Exclusive ) ) )
trend_index_new
Array ( [0] => Array ( [ArticleID] => 2348512 [Title] => Kathryn Bernardo, family's new home has elevator, slide, arcade [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/17/kathryn-bernardo-new-house_2024-04-17_22-49-10713_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/17/kathryn-bernardo-new-house_2024-04-17_22-49-10713.jpg [Tiny] => https://media.philstar.com/photos/2024/04/17/kathryn-bernardo-new-house_2024-04-17_22-49-10713_tn.jpg [Alt] => [Link] => https://www.philstar.com/entertainment/2024/04/18/2348512/kathryn-bernardo-familys-new-home-has-elevator-slide-arcade ) [1] => Array ( [ArticleID] => 2348705 [Title] => 'Crazy Rich Asians' director to helm Broadway adaptation for stage debut [PostType] => Standard [Summary] => [Thumbnail] => http://media.philstar.com/images/articles/wu-golding_2018-08-28_13-48-07176_thumbnail.jpg [Orig] => http://media.philstar.com/images/articles/wu-golding_2018-08-28_13-48-07176.jpg [Tiny] => http://media.philstar.com/images/articles/wu-golding_2018-08-28_13-48-07176_thumbnail.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/arts-and-culture/2024/04/18/2348705/crazy-rich-asians-director-helm-broadway-adaptation-stage-debut ) [2] => Array ( [ArticleID] => 2348362 [Title] => ‘It’s magical!’: Where Kathryn Bernardo found healing from breakup with Daniel Padilla [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/17/kath-cover_2024-04-17_13-57-1175_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/17/kath-cover_2024-04-17_13-57-1175.jpg [Tiny] => https://media.philstar.com/photos/2024/04/17/kath-cover_2024-04-17_13-57-1175_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/health-and-family/2024/04/17/2348362/its-magical-where-kathryn-bernardo-found-healing-breakup-daniel-padilla ) [3] => Array ( [ArticleID] => 2348637 [Title] => James Reid bares sandos collection; gives tips to girls shopping for boys [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/04/18/james-sando_2024-04-18_13-00-1332_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/04/18/james-sando_2024-04-18_13-00-1332.jpg [Tiny] => https://media.philstar.com/photos/2024/04/18/james-sando_2024-04-18_13-00-1332_tn.jpg [Alt] => [Link] => https://www.philstar.com/entertainment/2024/04/18/2348637/james-reid-bares-sandos-collection-gives-tips-girls-shopping-boys ) )