Download Code – the Best Free PHP-Based Online News Portal Project
Online News Portal Project in PHP
Introduction
An online news portal is a website that provides news and information to the public. It allows users to share news stories, opinion pieces, and other types of content. PHP is a great platform for building an online news portal because it offers flexibility and ease of management.
Why Use PHP for a News Portal?
Using a PHP-based Content Management System (CMS) makes it easy to manage and update website content. It also allows customization without requiring advanced technical skills or a big budget. Many free PHP-based news portal codes are available, making it convenient to set up and personalize the website.
Benefits of an Online News Portal in PHP
- User-Friendly Interface – Easy to navigate and manage content.
- Scalability – Can handle a growing audience and content.
- Security Features – Protects data and ensures safe content management.
- Cost-Effective – Free and open-source PHP software helps save costs.
- Customization – The website can be modified to meet specific needs.
Resources for Building a News Portal
Creating an online news portal can be challenging, but various free tools can help. Some useful resources include:
- Content Management Systems (CMS) – Help organize and publish content easily.
- Open-Source Projects – Provide templates and features for quick setup.
- Additional Tools – Plugins and extensions to enhance functionality.
Optimizing Your News Portal
To make your PHP-based news portal successful, focus on:
- Good Design and Layout – Ensure an engaging user experience.
- SEO Optimization – Improve visibility on search engines.
- Social Media Integration – Share content easily on different platforms.
Business Applications of a News Portal
Businesses can use online news portals to:
- Share updates about products and services.
- Increase brand visibility and audience reach.
- Improve engagement through social media sharing.
- Customize the website using free PHP news portal code.
How to Set Up the News Portal Project
Requirements
- Install a local web server like XAMPP.
- Download the provided source code.
Installation Steps
- Open XAMPP Control Panel and start Apache and MySQL.
- Extract the downloaded source code and copy it into the htdocs folder in XAMPP.
- Open PHPMyAdmin in a browser (http://localhost/phpmyadmin).
- Create a new database named newsportal.
- Import the provided newsportal.sql file.
- Open the project in a browser (http://localhost/101news).
index PHP
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 |
<?php session_start(); include('includes/config.php'); ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no"> <meta name="description" content=""> <meta name="author" content=""> <title>101+ News | Home Page</title> <!-- Bootstrap core CSS --> <link href="vendor/bootstrap/css/bootstrap.min.css" rel="stylesheet"> <!-- Custom styles for this template --> <link href="css/modern-business.css" rel="stylesheet"> <link rel="stylesheet" href="css/icons.css"> <link rel="stylesheet" href="css/owl.carousel.min.css"> <link rel="stylesheet" href="css/owl.theme.default.min.css"> <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/animate.css/4.1.1/animate.min.css"> </head> <body> <!-- Navigation --> <?php include('includes/header.php');?> <!-- Page Content --> <div class="container-fluid"> <div class="row" style="margin-top: 4%"> <!-- Blog Entries Column --> <div class="col-md-2 mt-4"> <!-- Categories Widget --> <div class="card my-4 border-0" > <h5 class="card-header bg-white border-0">Categories</h5> <div class="card-body"> <div class="row"> <div class="col-lg-12"> <ul class="list-unstyled mb-0"> <?php $query=mysqli_query($con,"select id,CategoryName from tblcategory"); while($row=mysqli_fetch_array($query)) { ?> <li class=" mb-2"> <a href="category.php?catid=<?php echo htmlentities($row['id'])?>" class="text-secondary"><?php echo htmlentities($row['CategoryName']);?></a> </li> <?php } ?> </ul> </div> </div> </div> </div> </div> <div class="col-md-7"> <h4 class="widget-title mb-4">Today <span>Highlight</span></h4> <!-- Blog Post --> <div class="row"> <div class="owl-carousel owl-theme" id="slider"> <div class="card mb-4 border-0"> <img class="card-img-top" src="admin/postimages/8bc5c30be91dca9d07c1db858c60e39f.jpg" alt="" width="100%"> <div class="card-body"> <p class="m-0"> <!--category--> <a class="badge bg-success text-decoration-none link-light" href="#" style="color:#fff">Sports</a> <!--Subcategory---> <a class="badge bg-warning text-decoration-none link-light" style="color:#fff">Sports</a> </p> <p class="m-0"><small> Posted on 2022-11-11 00:20:09</small></p> <a href="#" class="card-title text-decoration-none text-dark"> <h5 class="card-title">T20 World Cup 2022: Semi-final 1, England vs New Zealand Who Said What</h5> </a> <!-- <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="">Read More →</a> --> </div> </div> <div class="card mb-4 border-0"> <img class="card-img-top" src="admin/postimages/8bc5c30be91dca9d07c1db858c60e39f.jpg" alt="" width="100%"> <div class="card-body"> <p class="m-0"> <!--category--> <a class="badge bg-success text-decoration-none link-light" href="#" style="color:#fff">Sports</a> <!--Subcategory---> <a class="badge bg-warning text-decoration-none link-light" style="color:#fff">Sports</a> </p> <p class="m-0"><small> Posted on 2022-11-11 00:20:09</small></p> <a href="#" class="card-title text-decoration-none text-dark"> <h5 class="card-title">T20 World Cup 2022: Semi-final 1, England vs New Zealand Who Said What</h5> </a> <!-- <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="">Read More →</a> --> </div> </div> <div class="card mb-4 border-0"> <img class="card-img-top" src="admin/postimages/8bc5c30be91dca9d07c1db858c60e39f.jpg" alt="" width="100%"> <div class="card-body"> <p class="m-0"> <!--category--> <a class="badge bg-success text-decoration-none link-light" href="#" style="color:#fff">Sports</a> <!--Subcategory---> <a class="badge bg-warning text-decoration-none link-light" style="color:#fff">Sports</a> </p> <p class="m-0"><small> Posted on 2022-11-11 00:20:09</small></p> <a href="#" class="card-title text-decoration-none text-dark"> <h5 class="card-title">T20 World Cup 2022: Semi-final 1, England vs New Zealand Who Said What</h5> </a> <!-- <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="">Read More →</a> --> </div> </div> </div> <?php if (isset($_GET['pageno'])) { $pageno = $_GET['pageno']; } else { $pageno = 1; } $no_of_records_per_page = 8; $offset = ($pageno-1) * $no_of_records_per_page; $total_pages_sql = "SELECT COUNT(*) FROM tblposts"; $result = mysqli_query($con,$total_pages_sql); $total_rows = mysqli_fetch_array($result)[0]; $total_pages = ceil($total_rows / $no_of_records_per_page); $query=mysqli_query($con,"select tblposts.id as pid,tblposts.PostTitle as posttitle,tblposts.PostImage,tblcategory.CategoryName as category,tblcategory.id as cid,tblsubcategory.Subcategory as subcategory,tblposts.PostDetails as postdetails,tblposts.PostingDate as postingdate,tblposts.PostUrl as url from tblposts left join tblcategory on tblcategory.id=tblposts.CategoryId left join tblsubcategory on tblsubcategory.SubCategoryId=tblposts.SubCategoryId where tblposts.Is_Active=1 order by tblposts.id desc LIMIT $offset, $no_of_records_per_page"); while ($row=mysqli_fetch_array($query)) { ?> <div class="col-md-6"> <div class="card mb-4 border-0"> <img class="card-img-top" src="admin/postimages/<?php echo htmlentities($row['PostImage']);?>" alt="<?php echo htmlentities($row['posttitle']);?>" height="200px"> <div class="card-body"> <p class="m-0"> <!--category--> <a class="badge bg-success text-decoration-none link-light" href="category.php?catid=<?php echo htmlentities($row['cid'])?>" style="color:#fff"><?php echo htmlentities($row['category']);?></a> <!--Subcategory---> <a class="badge bg-warning text-decoration-none link-light" style="color:#fff"><?php echo htmlentities($row['subcategory']);?></a> </p> <p class="m-0"><small> Posted on <?php echo htmlentities($row['postingdate']);?></small></p> <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="card-title text-decoration-none text-dark"> <h5 class="card-title"><?php echo htmlentities($row['posttitle']);?></h5> </a> <!-- <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="">Read More →</a> --> </div> </div> </div> <?php } ?> <div class="col-md-12"><a href = "mailto: mayuri.infospace@gmail.com"> <img src="images/ads.jpg" class="img-fluid"></a> <!-- Pagination --> <!-- <ul class="pagination justify-content-center mb-4"> <li class="page-item"><a href="?pageno=1" class="page-link border-0">First</a></li> <li class="<?php if($pageno <= 1){ echo 'disabled'; } ?> page-item"> <a href="<?php if($pageno <= 1){ echo '#'; } else { echo "?pageno=".($pageno - 1); } ?>" class="page-link border-0">Prev</a> </li> <li class="<?php if($pageno >= $total_pages){ echo 'disabled'; } ?> page-item"> <a href="<?php if($pageno >= $total_pages){ echo '#'; } else { echo "?pageno=".($pageno + 1); } ?> " class="page-link border-0">Next</a> </li> <li class="page-item"><a href="?pageno=<?php echo $total_pages; ?>" class="page-link border-0">Last</a></li> </ul> --> </div> <!-- Static --> <div class="col-md-12"> <div class="card mb-4 mt-5 border-0"> <img class="card-img-top" src="admin/postimages/8bc5c30be91dca9d07c1db858c60e39f.jpg" alt="" width="100%"> <div class="card-body"> <p class="m-0"> <!--category--> <a class="badge bg-success text-decoration-none link-light" href="#" style="color:#fff">Sports</a> <!--Subcategory---> <a class="badge bg-warning text-decoration-none link-light" style="color:#fff">Sports</a> </p> <p class="m-0"><small> Posted on 2022-11-11 00:20:09</small></p> <a href="#" class="card-title text-decoration-none text-dark"> <h5 class="card-title">T20 World Cup 2022: Semi-final 1, England vs New Zealand Who Said What</h5> </a> <!-- <a href="news-details.php?nid=<?php echo htmlentities($row['pid'])?>" class="">Read More →</a> --> </div> </div> </div> </div><a href = "mailto: mayuri.infospace@gmail.com"> <img src="images/ads.jpg" class="img-fluid"></a> </div> <!-- Sidebar Widgets Column --> <?php include('includes/sidebar.php');?> </div> </div> <!-- /.row --> </div> <!-- /.container --> <!-- Footer --> <?php include('includes/footer.php');?> <!-- Author Name: Mayuri K. for any PHP, Codeignitor, Laravel OR Python work contact me at mayuri.infospace@gmail.com Visit website : www.mayurik.com --> <script src="js/foot.js"></script> <!-- Bootstrap core JavaScript --> <script src="vendor/jquery/jquery.min.js"></script> <script src="vendor/bootstrap/js/bootstrap.bundle.min.js"></script> <script src="js/owl.carousel.min.js"></script> <script> $('#slider').owlCarousel({ loop:true, margin:10, nav:false, dots:false, autoplay:true, animateOut: 'fadeOut', responsive:{ 0:{ items:1 }, 600:{ items:1 }, 1000:{ items:1 } } }); $('#slider2').owlCarousel({ loop:true, margin:10, nav:false, dots:false, autoplay:true, animateOut: 'fadeOut', responsive:{ 0:{ items:1 }, 600:{ items:1 }, 1000:{ items:4 } } }); </script> </body> </html> |
logout PHP
|
1 2 3 4 5 6 7 8 9 10 11 |
<?php session_start(); include("includes/config.php"); $_SESSION['login']==""; session_unset(); session_destroy(); ?> <script language="javascript"> document.location="index.php"; </script> |
newsportal SQL
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 |
-- phpMyAdmin SQL Dump -- version 5.1.3 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: Jan 25, 2023 at 07:35 PM -- Server version: 10.4.22-MariaDB -- PHP Version: 7.4.28 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- Database: `newsportal` -- -- -------------------------------------------------------- -- -- Table structure for table `tbladmin` -- CREATE TABLE `tbladmin` ( `id` int(11) NOT NULL, `AdminUserName` varchar(255) DEFAULT NULL, `AdminPassword` varchar(255) DEFAULT NULL, `AdminEmailId` varchar(255) DEFAULT NULL, `userType` int(11) DEFAULT NULL, `CreationDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tbladmin` -- INSERT INTO `tbladmin` (`id`, `AdminUserName`, `AdminPassword`, `AdminEmailId`, `userType`, `CreationDate`, `UpdationDate`) VALUES (1, 'admin', '88a49c3695747772777310af4038d420', 'mayuri.infospace@gmail.com', 1, '2022-12-12 18:30:00', '2022-12-16 11:30:33'), (2, 'Sarabh', 'e10adc3949ba59abbe56e057f20f883e', 'saurabha@gmail.com', 0, '2022-12-16 11:32:06', NULL); -- -------------------------------------------------------- -- -- Table structure for table `tblcategory` -- CREATE TABLE `tblcategory` ( `id` int(11) NOT NULL, `CategoryName` varchar(200) DEFAULT NULL, `Description` mediumtext DEFAULT NULL, `PostingDate` timestamp NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `Is_Active` int(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblcategory` -- INSERT INTO `tblcategory` (`id`, `CategoryName`, `Description`, `PostingDate`, `UpdationDate`, `Is_Active`) VALUES (1, 'ENTERTAINMENT', 'ENTERTAINMENT', '2022-12-13 17:26:13', '2022-12-13 17:41:07', 1), (2, 'TECHNOLOGY', 'TECHNOLOGY', '2022-12-13 17:36:33', NULL, 1), (3, 'LIFESTYLE', 'LIFESTYLE', '2022-12-13 17:36:50', NULL, 1), (4, 'POLITICAL', 'POLITICAL', '2022-12-13 17:37:23', NULL, 1), (5, 'SPORTS', 'SPORTS', '2022-12-13 17:37:48', NULL, 1), (6, 'SPIRITUAL', 'SPIRITUAL', '2022-12-16 11:32:39', NULL, 1); -- -------------------------------------------------------- -- -- Table structure for table `tblcomments` -- CREATE TABLE `tblcomments` ( `id` int(11) NOT NULL, `postId` int(11) DEFAULT NULL, `name` varchar(120) DEFAULT NULL, `email` varchar(150) DEFAULT NULL, `comment` mediumtext DEFAULT NULL, `postingDate` timestamp NULL DEFAULT current_timestamp(), `status` int(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblcomments` -- INSERT INTO `tblcomments` (`id`, `postId`, `name`, `email`, `comment`, `postingDate`, `status`) VALUES (1, 4, 'Mayuri K', 'mauyu@gmail.com', 'hi', '2022-12-16 11:20:07', 1); -- -------------------------------------------------------- -- -- Table structure for table `tblpages` -- CREATE TABLE `tblpages` ( `id` int(11) NOT NULL, `PageName` varchar(200) DEFAULT NULL, `PageTitle` mediumtext DEFAULT NULL, `Description` longtext DEFAULT NULL, `PostingDate` timestamp NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblpages` -- INSERT INTO `tblpages` (`id`, `PageName`, `PageTitle`, `Description`, `PostingDate`, `UpdationDate`) VALUES (1, 'aboutus', 'About News Portal', '<p style=\"text-align: justify; \">Mayuri K. is an experienced freelance web developer who specializes in technologies like PHP, Laravel, and Python. She has been working with these technologies for over 6 years and has a proven track record of delivering successful projects. Mayuri is well-versed in the latest advancements in web development and can handle any project from simple static websites to complex web applications. She has a passion for creating high-quality products that are tailored to her clients needs. With her expertise, she can help you create a website or application that is both secure and user-friendly.\r\n</p><p style=\"text-align: justify;\"><b>\r\nFor students or anyone else who needs program or source code for thesis writing or any Professional Software Development, Website Development, Academic Project Development at affordable cost contact me at <a href=\"http://mayuri.infospace@gmail.com\">mayuri.infospace@gmail.com</a>\r\n</b></p><p style=\"text-align: justify;\"><br></p><p style=\"text-align: justify;\"><b>\r\nNote: </b>Source Code is only available for educational purposes, plz dont use it for commercial purposes without the permission of the original author.</p>', '2021-06-29 18:30:00', '2023-01-25 18:00:11'), (2, 'contactus', 'Contact Details', '<p><br></p><p><b>Address : </b>Maharashtra</p><p><b>Phone Number : </b>+91 -9090909090</p><p><b>Email -id : </b>mayuri.infospace@gmail.com</p>', '2021-06-29 18:30:00', '2022-12-13 16:50:24'); -- -------------------------------------------------------- -- -- Table structure for table `tblposts` -- CREATE TABLE `tblposts` ( `id` int(11) NOT NULL, `PostTitle` longtext DEFAULT NULL, `CategoryId` int(11) DEFAULT NULL, `SubCategoryId` int(11) DEFAULT NULL, `PostDetails` longtext CHARACTER SET utf8 DEFAULT NULL, `PostingDate` timestamp NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `Is_Active` int(1) DEFAULT NULL, `PostUrl` mediumtext DEFAULT NULL, `PostImage` varchar(255) DEFAULT NULL, `viewCounter` int(11) DEFAULT NULL, `postedBy` varchar(255) DEFAULT NULL, `lastUpdatedBy` varchar(255) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblposts` -- INSERT INTO `tblposts` (`id`, `PostTitle`, `CategoryId`, `SubCategoryId`, `PostDetails`, `PostingDate`, `UpdationDate`, `Is_Active`, `PostUrl`, `PostImage`, `viewCounter`, `postedBy`, `lastUpdatedBy`) VALUES (1, 'Team India on top as Bangladesh two wickets away from getting bowled out', 5, 4, '<p>Team India were humbled 2-1 by a resurgent Bangladesh team in the three-match ODI series which the visitors managed to end on a high thanks to Ishan Kishan’s record double century. The Indian cricket team will now want to switch gears to prepare themselves for red-ball cricket as the first Test against Bangladesh gets underway in Chattogram on Wednesday (December 14). India will resume on 278/6 on Day 2 of the first Test on Thursday (December 15).</p><p>The Indian side will be led by KL Rahul with regular skipper Rohit Sharma ruled out after dislocating his thumb in the second ODI against Bangladesh last week. Shubman Gill is expected to take Rohit’s place at the top of the order alongside stand-in skipper Rahul.<br></p><p>Bangladesh, on the other hand, will be led by veteran all-rounder Shakib al Hasan with Tamim Iqbal missing both the ODI and the Test series with injury. The home side will have their task cut out against the world No. 2-ranked Test side India as they eye first-ever Test match win over them.</p><p>India have promised to play aggressive cricket, much like England’s ‘Bazball’ model which has powered them to a Test series win over Babar Azam’s Pakistan. India need win at least 5 of the next 6 upcoming Tests, which includes the next two Test matches against Bangladesh to assure them of a qualification spot in the World Test Championships final next year.</p><p>The Indian side is injury-hit with the likes of Mohammed Shami and Ravindra Jadeja also ruled out with injury apart from skipper Rohit. It will be interesting to see if Jaydev Unadkat will make a return to Test cricket after a gap of 12 years. Mohammed Siraj and Umesh Yadav will be expected the carry the pace-bowling load while Ravichandran Ashwin and Kuldeep Yadav will team up in the spin bowling department.</p><p>Check all the LIVE Scores and Updates from Day 1 of 1st Test between India and Bangladesh here.</p>', '2022-12-15 18:08:34', NULL, 1, 'Team-India-on-top-as-Bangladesh-two-wickets-away-from-getting-bowled-out', '1167610aa17b0813233fe82d99403e41.jpg', NULL, 'admin', NULL), (2, 'Creative Christmas gift ideas for kids', 3, 8, '<p>With Christmas, a few weeks from now, planning a gift for your kids can be a task quite challenging. Worry not! We have a few ideas for all the parents who are looking for those creative gifts to make their kids Xmas merry.<br></p><div><br></div><p>Being unprepared for Christmas is the very last thing you want. Start looking for presents now, or at the very least start thinking about ideas, rather than waiting until the last minute and this guide is your saviour.<br></p>', '2022-12-15 18:14:00', NULL, 1, 'Creative-Christmas-gift-ideas-for-kids', '646c8915fc1096c12b679108e7022df9.jpg', NULL, 'admin', NULL), (3, 'Petrol prices still high in your city? Centre blames THESE for costly fuel', 4, 9, '<p>The minister said, currently the petrol price in India is one of the lowest. He said the oil marketing companies together suffered losses of Rs 27,276 crore due to high prices of crude in international markets.</p><p><br></p><p>Six states - West Bengal, Tamil Nadu, Andhra Pradesh, Telengana, Kerala, and Jharkhand - have not reduced the VAT, he said amidst vocal protests by the opposition members. The minister said, currently the petrol price in India is one of the lowest. </p>', '2022-12-15 18:16:46', '2022-12-15 18:29:46', 1, 'Petrol-prices-still-high-in-your-city?-Centre-blames-THESE-for-costly-fuel', 'c1ae896415041d9173d4935145243c14.jpg', 1, 'admin', NULL), (4, 'Lionel Messi to Kylian Mbappe: Race to FIFA World Cup 2022 Golden Boot, in PICS', 5, 5, '<p>The FIFA World Cup 2022 final are set with Lionel Messis Argentina set to take on Kylian Mbappe France at the Lusail Stadium on Sunday (December 18). Messi and Mbappe, teammates at PSG, are also in the race to win the FIFA World Cup 2022 Golden Boot award as well. In these collection of pictures, we take a look at players in race to win Golden Boot award this year.</p><p>The FIFA World Cup 2022 final are set with Lionel Messis Argentina set to take on Kylian Mbappe France at the Lusail Stadium on Sunday (December 18). Messi and Mbappe, teammates at PSG, are also in the race to win the FIFA World Cup 2022 Golden Boot award as well. In these collection of pictures, we take a look at players in race to win Golden Boot award this year.</p><p>The FIFA World Cup 2022 final are set with Lionel Messis Argentina set to take on Kylian Mbappe France at the Lusail Stadium on Sunday (December 18). Messi and Mbappe, teammates at PSG, are also in the race to win the FIFA World Cup 2022 Golden Boot award as well. In these collection of pictures, we take a look at players in race to win Golden Boot award this year.</p><p>The FIFA World Cup 2022 final are set with Lionel Messis Argentina set to take on Kylian Mbappe France at the Lusail Stadium on Sunday (December 18). Messi and Mbappe, teammates at PSG, are also in the race to win the FIFA World Cup 2022 Golden Boot award as well. In these collection of pictures, we take a look at players in race to win Golden Boot award this year.</p><p><br></p>', '2022-12-15 18:22:51', '2022-12-16 11:20:07', 1, 'Lionel-Messi-to-Kylian-Mbappe:-Race-to-FIFA-World-Cup-2022-Golden-Boot,-in-PICS', 'cefb64713b6ae016047d3bcd8a38e1cc.jpg', 2, 'admin', NULL), (5, 'Twitter suspends journalists from NYT, Washington Post and others covering Elon Musk: Report', 2, 11, 'The Washington Posts Drew Harwell, alongside other banned reporters, was able to participate in a Twitter Spaces audio session while under suspension, exposing a loophole in Twitter’s enforcement.\r\n\r\n\r\nTwitter Inc. suspended the accounts of upstart rival service Mastodon and several prominent journalists covering the social network’s billionaire owner Elon Musk.\r\n\r\nLate Thursday, reporters from publications including the Washington Post, the New York Times, Mashable and CNN were listed as blocked and their tweets were no longer visible, with the companys standard notice saying it suspends accounts that violate the Twitter rules.\r\n\r\nAlso affected was sports and political commentator Keith Olbermann. Musk said Olbermann will be subject to a 7-day suspension for doxxing. In a separate tweet, he alleged the suspended journalists had posted his exact real-time location, describing the information as basically assassination coordinates.', '2022-12-16 11:34:26', '2022-12-16 11:34:47', 1, 'Twitter-suspends-journalists-from-NYT,-Washington-Post-and-others-covering-Elon-Musk:-Report', 'd7c9faa1953eebd19b2ae47f7f201858.jpg', NULL, 'admin', 'admin'); -- -------------------------------------------------------- -- -- Table structure for table `tblsubcategory` -- CREATE TABLE `tblsubcategory` ( `SubCategoryId` int(11) NOT NULL, `CategoryId` int(11) DEFAULT NULL, `Subcategory` varchar(255) DEFAULT NULL, `SubCatDescription` mediumtext DEFAULT NULL, `PostingDate` timestamp NOT NULL DEFAULT current_timestamp(), `UpdationDate` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(), `Is_Active` int(1) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `tblsubcategory` -- INSERT INTO `tblsubcategory` (`SubCategoryId`, `CategoryId`, `Subcategory`, `SubCatDescription`, `PostingDate`, `UpdationDate`, `Is_Active`) VALUES (1, 1, 'BOLLYWOOD', 'BOLLYWOOD', '2022-12-13 17:26:52', '2022-12-13 17:42:55', 1), (2, 1, 'HOLLYWOOD', 'HOLLYWOOD', '2022-12-13 17:27:09', NULL, 1), (3, 1, 'TELEVISION', 'TELEVISION', '2022-12-13 17:27:35', NULL, 1), (4, 5, 'CRICKET', 'CRICKET', '2022-12-13 17:39:12', NULL, 1), (5, 5, 'FOOTBALL', 'FOOTBALL', '2022-12-13 17:39:33', NULL, 1), (6, 5, 'TENNIS', 'TENNIS', '2022-12-13 17:39:53', NULL, 1), (7, 5, 'WWE', 'WWE', '2022-12-13 17:40:17', NULL, 1), (8, 3, 'Culture', 'Culture', '2022-12-15 18:10:39', NULL, 1), (9, 4, 'Economy', 'Economy', '2022-12-15 18:15:11', NULL, 1), (10, 6, 'HINDUISM', 'HINDUISM', '2022-12-16 11:32:56', NULL, 1), (11, 2, 'SOCIAL MEDIA', 'SOCIAL MEDIA', '2022-12-16 11:33:27', NULL, 1); -- -- Indexes for dumped tables -- -- -- Indexes for table `tbladmin` -- ALTER TABLE `tbladmin` ADD PRIMARY KEY (`id`), ADD KEY `AdminUserName` (`AdminUserName`); -- -- Indexes for table `tblcategory` -- ALTER TABLE `tblcategory` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblcomments` -- ALTER TABLE `tblcomments` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`), ADD KEY `postId` (`postId`); -- -- Indexes for table `tblpages` -- ALTER TABLE `tblpages` ADD PRIMARY KEY (`id`); -- -- Indexes for table `tblposts` -- ALTER TABLE `tblposts` ADD PRIMARY KEY (`id`), ADD KEY `id` (`id`), ADD KEY `postcatid` (`CategoryId`), ADD KEY `postsucatid` (`SubCategoryId`), ADD KEY `subadmin` (`postedBy`); -- -- Indexes for table `tblsubcategory` -- ALTER TABLE `tblsubcategory` ADD PRIMARY KEY (`SubCategoryId`), ADD KEY `catid` (`CategoryId`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `tbladmin` -- ALTER TABLE `tbladmin` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tblcategory` -- ALTER TABLE `tblcategory` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7; -- -- AUTO_INCREMENT for table `tblcomments` -- ALTER TABLE `tblcomments` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2; -- -- AUTO_INCREMENT for table `tblpages` -- ALTER TABLE `tblpages` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3; -- -- AUTO_INCREMENT for table `tblposts` -- ALTER TABLE `tblposts` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6; -- -- AUTO_INCREMENT for table `tblsubcategory` -- ALTER TABLE `tblsubcategory` MODIFY `SubCategoryId` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12; -- -- Constraints for dumped tables -- -- -- Constraints for table `tblcomments` -- ALTER TABLE `tblcomments` ADD CONSTRAINT `pid` FOREIGN KEY (`postId`) REFERENCES `tblposts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `tblposts` -- ALTER TABLE `tblposts` ADD CONSTRAINT `postcatid` FOREIGN KEY (`CategoryId`) REFERENCES `tblcategory` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `postsucatid` FOREIGN KEY (`SubCategoryId`) REFERENCES `tblsubcategory` (`SubCategoryId`) ON DELETE NO ACTION ON UPDATE NO ACTION, ADD CONSTRAINT `subadmin` FOREIGN KEY (`postedBy`) REFERENCES `tbladmin` (`AdminUserName`) ON DELETE NO ACTION ON UPDATE NO ACTION; -- -- Constraints for table `tblsubcategory` -- ALTER TABLE `tblsubcategory` ADD CONSTRAINT `catid` FOREIGN KEY (`CategoryId`) REFERENCES `tblcategory` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; COMMIT; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; |