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] => 2343942 [Title] => Visita Iglesia in UK: St. Paul’s Cathedral [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/28/st-paul-cover_2024-03-28_10-07-06447_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/28/st-paul-cover_2024-03-28_10-07-06447.jpg [Tiny] => https://media.philstar.com/photos/2024/03/28/st-paul-cover_2024-03-28_10-07-06447_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/travel-and-tourism/2024/03/28/2343942/visita-iglesia-uk-st-pauls-cathedral ) [1] => Array ( [ArticleID] => 2343938 [Title] => Visita Iglesia in UK: Canterbury Cathedral [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/28/canterbury-cover_2024-03-28_09-01-03573_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/28/canterbury-cover_2024-03-28_09-01-03573.jpg [Tiny] => https://media.philstar.com/photos/2024/03/28/canterbury-cover_2024-03-28_09-01-03573_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/travel-and-tourism/2024/03/28/2343938/visita-iglesia-uk-canterbury-cathedral ) [2] => Array ( [ArticleID] => 2343941 [Title] => Visita Iglesia in UK: The Friars, birthplace of the Brown Scapular [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/28/friars-cover_2024-03-28_09-35-36282_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/28/friars-cover_2024-03-28_09-35-36282.jpg [Tiny] => https://media.philstar.com/photos/2024/03/28/friars-cover_2024-03-28_09-35-36282_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/travel-and-tourism/2024/03/28/2343941/visita-iglesia-uk-friars-birthplace-brown-scapular ) [3] => Array ( [ArticleID] => 2343735 [Title] => The future of food [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/27/2_2024-03-27_16-20-03373_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/27/2_2024-03-27_16-20-03373.jpg [Tiny] => https://media.philstar.com/photos/2024/03/27/2_2024-03-27_16-20-03373_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/2024/03/28/2343735/future-food ) )
Beautycon 2024: Highlights, spotted celebs, top brands from the beauty event of the year
For the first time ever, SM Beauty, Watsons and LOOK At Me got together to power Beautycon 2024, a free-entrance beauty and lifestyle event held from March 20 to 23 at SMX Manila Halls 1 and 2.
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-03-28') 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,2343736,2343942,2343938,2343941,2343735) 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] => 2343451 [Title] => From model to cultural professional: Deniece Cornejo represents the Filipina brand to the world [DatePublished] => 2024-03-26 15:24:00 [SectionUrl] => arts-and-culture [Alt] => [URL] => https://media.philstar.com/photos/2024/03/26/deniece_2024-03-26_11-19-42636_thumbnail.jpg [PostType] => Exclusive ) [1] => Array ( [Position] => 3 [ArticleID] => 2342486 [Title] => Explainer: What is Pertussis or Whooping Cough? [DatePublished] => 2024-03-22 15:22:00 [SectionUrl] => health-and-family [Alt] => [URL] => https://media.philstar.com/photos/2024/03/22/coughing_2024-03-22_14-47-26673_thumbnail.jpg [PostType] => Standard ) [2] => Array ( [Position] => 22 [ArticleID] => 2343706 [Title] => Andi Eigenmann brings some of Jaclyn Jose's ashes to Siargao [DatePublished] => 2024-03-27 13:57:00 [SectionUrl] => entertainment [Alt] => [URL] => http://media.philstar.com/images/pang-masa/pang-movies/20161209/jacklyn.jpg [PostType] => Standard ) [3] => Array ( [Position] => 25 [ArticleID] => 2343710 [Title] => 'Conflicted, heartbreaking': Sarah Geronimo on animal cruelty, being Pescatarian [DatePublished] => 2024-03-27 15:07:00 [SectionUrl] => entertainment [Alt] => [URL] => https://media.philstar.com/photos/2024/03/24/111_2024-03-24_21-55-53863_thumbnail.jpg [PostType] => Standard ) ) )
trend_index_new
Array ( [0] => Array ( [ArticleID] => 2343451 [Title] => From model to cultural professional: Deniece Cornejo represents the Filipina brand to the world [PostType] => Exclusive [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/26/deniece_2024-03-26_11-19-42636_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/26/deniece_2024-03-26_11-19-42636.jpg [Tiny] => https://media.philstar.com/photos/2024/03/26/deniece_2024-03-26_11-19-42636_tn.jpg [Alt] => [Link] => https://www.philstar.com/lifestyle/arts-and-culture/2024/03/26/2343451/model-cultural-professional-deniece-cornejo-represents-filipina-brand-world ) [1] => Array ( [ArticleID] => 2342486 [Title] => Explainer: What is Pertussis or Whooping Cough? [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/03/22/2342486/explainer-what-pertussis-or-whooping-cough ) [2] => Array ( [ArticleID] => 2343706 [Title] => Andi Eigenmann brings some of Jaclyn Jose's ashes to Siargao [PostType] => Standard [Summary] => [Thumbnail] => http://media.philstar.com/images/pang-masa/pang-movies/20161209/jacklyn.jpg [Orig] => http://media.philstar.com/images/pang-masa/pang-movies/20161209/jacklyn.jpg [Tiny] => http://media.philstar.com/images/pang-masa/pang-movies/20161209/jacklyn.jpg [Alt] => [Link] => https://www.philstar.com/entertainment/2024/03/27/2343706/andi-eigenmann-brings-some-jaclyn-joses-ashes-siargao ) [3] => Array ( [ArticleID] => 2343710 [Title] => 'Conflicted, heartbreaking': Sarah Geronimo on animal cruelty, being Pescatarian [PostType] => Standard [Summary] => [Thumbnail] => https://media.philstar.com/photos/2024/03/24/111_2024-03-24_21-55-53863_thumbnail.jpg [Orig] => https://media.philstar.com/photos/2024/03/24/111_2024-03-24_21-55-53863.jpg [Tiny] => https://media.philstar.com/photos/2024/03/24/111_2024-03-24_21-55-53863_tn.jpg [Alt] => [Link] => https://www.philstar.com/entertainment/2024/03/27/2343710/conflicted-heartbreaking-sarah-geronimo-animal-cruelty-being-pescatarian ) )