205CDE

content_copy

#javascript #css #html #php

Home.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | Home</title>
	</head>
	<style>
		@media only screen and (min-width: 893px) {
		.card-img-top{
		width: 100%;
		height: 15vw; 
		object-fit: cover;
		}
		}
		
		.card-body{
		background: #1f52a3;
		}
		
		.card-footer{
		background: #1f52a3;
		}
		
		.h5{
		color: #1f52a3;
		}
		
		.card-text{
		font-size: 12px;
		}
	</style>
	<body class="bg-light">
		<!--using external files-->
		<?php require('header.php'); ?>
		<div id="carouselExampleCaptions" class="carousel slide" data-ride="carousel">
			<ol class="carousel-indicators">
				<li data-target="#carouselExampleCaptions" data-slide-to="0" class="active"></li>
				<li data-target="#carouselExampleCaptions" data-slide-to="1"></li>
				<li data-target="#carouselExampleCaptions" data-slide-to="2"></li>
			</ol>
			<div class="carousel-inner">
				<div class="carousel-item active">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>First slide label</h5>
						<p>Nulla vitae elit libero, a pharetra augue mollis interdum.</p>
					</div>
				</div>
				<div class="carousel-item">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>Second slide label</h5>
						<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>
					</div>
				</div>
				<div class="carousel-item">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>Third slide label</h5>
						<p>Praesent commodo cursus magna, vel scelerisque nisl consectetur.</p>
					</div>
				</div>
			</div>
			<a class="carousel-control-prev" href="#carouselExampleCaptions" role="button" data-slide="prev">
				<span class="carousel-control-prev-icon" aria-hidden="true"></span>
				<span class="sr-only">Previous</span>
			</a>
			<a class="carousel-control-next" href="#carouselExampleCaptions" role="button" data-slide="next">
				<span class="carousel-control-next-icon" aria-hidden="true"></span>
				<span class="sr-only">Next</span>
			</a>
		</div>
		<!--4 latest news START-->
		<div class="container-fluid bg-light" style="padding: 40px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-6">
					<h5 style="color: #1f52a3;">Latest News</h5>
				</div>
				
				<div class="col-6 d-flex justify-content-end">
					<a href="" class="btn btn-link font-weight-bold" style="color: #1f52a3;">MORE NEWS <i class="fas fa-angle-double-right" style="font-size: 18px;"></i></a>
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 latest news END-->
		<!--4 nation news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">Nation News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="Nation" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php	
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 nation news END-->
		<!--4 world news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">World News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="World" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 world news END-->
		<!--4 entertainment news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0; margin-bottom: 40px;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">Entertainment News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="Entertainment" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 entertainment news END-->
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#html #php

Admin.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | Admin</title>
		<script>
			
		</script>
	</head>
	<body>
		<!--using external files-->
		<?php require('header.html'); ?>
		<div class="container" style="margin: 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">Manage News</h3></div>
			</div>
		</div>
		<div class="container-fluid bg-light" style="padding: 30px 10px;">
			<div class="row bg-light" style="margin: 0 35px;">
				<div class="col-6">
					<h5>All News</h5>
				</div>
				<div class="col-6 d-flex justify-content-end">
					<button type="button" class="btn btn-primary" style="background: #1f52a3;" data-toggle="modal" data-target="#addNewsModal"><i class="fas fa-plus" style="font-size: 20px;"></i> Add News</button>
				</div>
			</div>
			
			<!--add news modal START-->
			<!-- Modal -->
			<div class="modal fade bd-example-modal-lg" id="addNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-lg" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<h5 class="modal-title" id="exampleModalLabel">Add News</h5>
							<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>-->
						</div>
						<form action="/205CDE/Assignment/admin.php" method="post">
							<div class="modal-body">
								<div class="form-group">
									<label for="inputNewsTitle">News Title:</label>
									<input type="text" class="form-control" name="txtNewsTitle" id="inputNewsTitle" aria-describedby="emailHelp" placeholder="Enter news title">
								</div>
								<div class="form-group">
									<label for="selectNewsCategory">News Category:</label>
									<select class="form-control" name="selectNewsCategory" id="selectNewsCategory">
										<?php
											$newsCategoryArr = array(
											'--Select news category--' => "",
											'Nation' => 1,	'World' => 2,
											'Sport' => 3,	'Lifestyle' => 4,
											'Food' => 5,	'Tech' => 6,
											'Education' => 7
											);
											foreach($newsCategoryArr as $newsType => $newsNum){
												echo "<option value=\"$newsType\">$newsType</option>";
											}
										?>
									</select>
								</div>
								<div class="form-group">
									<label for="inputNewsDetails" class="col-form-label">News Details:</label>
									<textarea class="form-control" name="txtNewsDetails" id="inputNewsDetails" rows="10"></textarea>
								</div>
								
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
								<button type="submit" class="btn btn-primary" name="btnAddNews" style="background: #1f52a3;">Add</button>
								<input type="hidden" name="submitted" value="true"/>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--add news modal END-->
			<!--connect & insert news into database START-->
			<?php			
				if (isset($_POST['submitted'])){
					//connect database
					$dbc = mysqli_connect('localhost', 'root', '');
					//select database
					mysqli_select_db($dbc, 'news');
					
					$problem = FALSE;
					
					if(!empty($_POST['txtNewsTitle']) && !empty($_POST['selectNewsCategory']) && !empty($_POST['txtNewsDetails'])){
						$newsTitle = trim($_POST['txtNewsTitle']);
						$newsDetails = trim($_POST['txtNewsDetails']);
						$newsCategory = trim($_POST['selectNewsCategory']);
						}else{
						echo '<p>Error! Please enter title and details select category!</p>';
						$problem = TRUE;
					}
					
					if(!$problem){
						$query = "INSERT INTO news (news_title, news_details, news_category, news_datetime) 
						VALUES ('$newsTitle', '$newsDetails', '$newsCategory', NOW())";
						if(mysqli_query($dbc, $query)){
							echo '<p>Added successfully!</p>';
							}else{
							echo '<p>Error! '.mysqli_error($dbc).'</p>';
							echo '<p>Query: '.$query.'</p>';
						}
					}
					mysqli_close($dbc);
				}
			?>
			<!--connect & insert news into database END-->
			<!--news table START-->
			<div class="card-deck" style="margin: 15px 50px;">
				<table class="table table-hover bg-light">
					<thead class="thead-light">
						<tr>
							<th scope="col">News ID</th>
							<th scope="col">News Datetime</th>
							<th scope="col">News Title</th>
							<th scope="col">News Details</th>
							<th scope="col">News Category</th>
							<th scope="col">Edit/Delete</th>
						</tr>
					</thead>
					<tbody>
						<!--select news from database START-->
						<?php
							$dbc = mysqli_connect('localhost', 'root', '');
							mysqli_select_db($dbc, 'news');
							
							$query = 'SELECT * FROM news ORDER BY news_id ASC';
							
							if($r = mysqli_query($dbc, $query)){
								while($row = mysqli_fetch_array($r)){
									echo "<tr>
									<th scope=\"row\">{$row['news_id']}</th>
									<td>{$row['news_datetime']}</td>
									<td>{$row['news_title']}</td>
									<td>{$row['news_details']}</td>
									<td>{$row['news_category']}</td>
									<td>
									<button type=\"button\" class=\"btn btn-info\"><i class=\"fas fa-edit\" style=\"font-size: 20px;\"></i></button>
									<button type=\"button\" class=\"btn btn-danger\"><i class=\"fas fa-trash\" style=\"font-size: 20px;\"></i></button>
									</td>
									</tr>";
								}
								}else{
								echo '<p>Error! '.mysqli_error($dbc).'</p>';
							}
							
							mysqli_close($dbc);
						?>
						<!--select news from database END-->
					</tbody>
				</table>
			</div>
			<!--news table END-->
		</div>
	</body>
</html>
content_copy

#html #javascript

Import.html 
<!-- Required meta tags -->
    <meta charset="utf-8">
    <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
	
    <!-- Bootstrap CSS -->
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" integrity="sha384-JcKb8q3iqJ61gNV9KGb8thSsNjpSL0n8PARn9HuZOnIxN0hoP+VmmDGMN5t9UJ0Z" crossorigin="anonymous">
	
    <!-- U Chen CSS -->
	<link rel="stylesheet" href="homeStyle.css">
	
	<!-- Optional JavaScript -->
    <!-- jQuery first, then Popper.js, then Bootstrap JS -->
    <script src="https://code.jquery.com/jquery-3.5.1.slim.min.js" integrity="sha384-DfXdz2htPH0lsSSs5nCTpuj/zy4C+OGpamoFVy38MVBnE+IbbVYUew+OrCXaRkfj" crossorigin="anonymous"></script>
    <script src="https://cdn.jsdelivr.net/npm/popper.js@1.16.1/dist/umd/popper.min.js" integrity="sha384-9/reFTGAW83EW2RDu2S0VKaIzap3H66lZH81PoYlFhbGU+6BZp6G7niu735Sk7lN" crossorigin="anonymous"></script>
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js" integrity="sha384-B4gt1jrGC7Jh4AgTPSdUtOBvfO8shuf57BaghqFfPlYxofvL8/KUEfYiJOMMV+rV" crossorigin="anonymous"></script>
	
	<!-- Font Awesome Icons -->
	<script src="https://kit.fontawesome.com/a076d05399.js"></script>
content_copy

#html

Header.html 
<div class="container-fluid" style="background: #1f52a3;">
	<div class="row">
		<div class="col-2"></div>
		<div class="col-8">
			<a href="/205CDE/Assignment/home.php"><h1 style="text-align: center; color: #e6e8eb; margin: 20px 0;">U Chen Daily</h1></a>
		</div>
		<div class="col-2 d-flex justify-content-center align-items-center"><a href="/205CDE/Assignment/manageNews.php" target="_blank" class="btn btn-outline-light">LOGIN</a></div>
	</div>
</div>
<nav class="navbar navbar-expand-lg navbar-light bg-light">
	<a class="navbar-brand" href="/205CDE/Assignment/home.php"><i class="fas fa-home" style="font-size: 30px; color: #1f52a3;"></i></a>
	<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
		<span class="navbar-toggler-icon"></span>
	</button>
	
	<div class="collapse navbar-collapse" id="navbarSupportedContent">
		<ul class="navbar-nav mr-auto">
			<li class="nav-item dropdown" style="margin: 0 15px;">
				<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">News</a>
				<div class="dropdown-menu" aria-labelledby="navbarDropdown">
					<?php
						$newsCategoryArr = array(
						'All', 'Nation', 'World',
						'Sport', 'Entertainment',
						);
						foreach($newsCategoryArr as $newsType){
							echo "<a class=\"dropdown-item\" href=\"/205CDE/Assignment/news$newsType.php\" target=\"_blank\">$newsType</a>";
						}
					?>
				</div>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/aboutUs.php" target="_blank">About Us</a>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/contactUs.php" target="_blank">Contact Us</a>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/faqs.php" target="_blank">FAQs</a>
			</li>
			<!-- <li class="nav-item"> -->
			<!-- <a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Disabled</a> -->
			<!-- </li> -->
		</ul>
		<!-- <form class="form-inline my-2 my-lg-0"> -->
		<!-- <input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search"> -->
		<!-- <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button> -->
		<!-- </form> -->
	</div>
</nav>
content_copy

#php

manageNews.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | Admin</title>
		<script type="text/javascript">
			setTimeout(function(){ 
				document.querySelector('.close').click();
			}, 2500);
		</script>
		<!--show news info for editing START-->
		<script type="text/javascript">
			$(document).ready(function(){
				$('.btnEdit').on('click', function(){
					$('#updNewsModal').modal('show');
					
					$tr = $(this).closest('tr');
					
					var data = $tr.children("td").map(function(){
						return $(this).text();
					}).get();
					
					console.log(data);
					
					$('#update_id').val(data[0]);
					$('#news_datetime').val(data[1]);
					$('#news_title').val(data[2]);
					$('#news_details').val(data[3]);
					$('#news_category').val(data[4]);
					$('#news_image').val(data[5]);
				});
			});
		</script>
		<!--show news info for editing END-->
		
		<!--show confirmation message for deleting START-->
		<script type="text/javascript">
			$(document).ready(function(){
				$('.btnDel').on('click', function(){
					$('#delNewsModal').modal('show');
					
					$tr = $(this).closest('tr');
					
					var data = $tr.children("td").map(function(){
						return $(this).text();
					}).get();
					
					console.log(data);
					
					$('#delete_id').val(data[0]);
				});
			});
		</script>
		<!--show confirmation message for deleting END-->
		
		<!--show file name after uploading image START-->
		<script type="text/javascript">
            $(document).ready(function() {
                bsCustomFileInput.init();
			});
		</script>
		<!--show file name after uploading image END-->
		<body>
			<!--using external files-->
			<?php
				if(empty($_SESSION['username'])){
					header('Location: /205CDE/Assignment/home.php');
				}
			?>
			<?php require('header.php'); ?>
			
			<div class="container" style="margin: 20px;">
				<div class="row">
					<div class="col-sm"><h3 style="color: #1f52a3;">Manage News</h3></div>
				</div>
			</div>
			<!--add news modal START-->
			<!-- Modal -->
			<div class="modal fade bd-example-modal-lg" id="addNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-lg" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<h5 class="modal-title" id="exampleModalLabel">Add News</h5>
							<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>-->
						</div>
						<form action="/205CDE/Assignment/insertData.php" method="post" enctype="multipart/form-data">
							<div class="modal-body">
								<div class="form-group">
									<label for="inputNewsTitle">News Title:</label>
									<input type="text" class="form-control" name="txtNewsTitle" id="inputNewsTitle" aria-describedby="emailHelp" placeholder="Enter news title">
								</div>
								<div class="form-group">
									<label for="selectNewsCategory">News Category:</label>
									<select class="form-control" name="selectNewsCategory" id="selectNewsCategory">
										<?php
											$newsCategoryArr = array(
											'--Select news category--' => "",
											'Nation' => 1,	'World' => 2,
											'Sport' => 3,	'Entertainment' => 4
											);
											foreach($newsCategoryArr as $newsType => $newsNum){
												echo "<option value=\"$newsType\">$newsType</option>";
											}
										?>
									</select>
								</div>
								<div class="form-group mb-3">
									<label for="inputNewsImage" class="col-form-label">News Image:</label>
									<div class="custom-file">
										<input type="file" class="custom-file-input" name="uploadNewsImg" id="customFile">
										<label class="custom-file-label" for="customFile">Choose file</label>
									</div>
								</div>
								<div class="form-group">
									<label for="inputNewsDetails" class="col-form-label">News Details:</label>
									<textarea class="form-control" name="txtNewsDetails" id="inputNewsDetails" rows="10"></textarea>
								</div>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
								<button type="submit" class="btn btn-primary" name="addNewsData" style="background: #1f52a3;">Add</button>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--add news modal END-->
			
			<!--edit news modal START-->
			<!-- Modal -->
			<div class="modal fade bd-example-modal-lg" id="updNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-lg" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<h5 class="modal-title" id="exampleModalLabel">Edit News</h5>
							<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>-->
						</div>
						<form action="/205CDE/Assignment/updateData.php" method="post" enctype="multipart/form-data">
							<div class="modal-body">
								<input type="hidden" name="update_id" id="update_id">
								<div class="form-group">
									<label for="txtNewsDatetime">News Created Datetime:</label>
									<input type="text" class="form-control" name="txtNewsDatetime" id="news_datetime" aria-describedby="emailHelp" placeholder="Enter news datetime" disabled>
								</div>
								<div class="form-group">
									<label for="inputNewsTitle">News Title:</label>
									<input type="text" class="form-control" name="txtNewsTitle" id="news_title" aria-describedby="emailHelp" placeholder="Enter news title">
								</div>
								<div class="form-group">
									<label for="selectNewsCategory">News Category:</label>
									<select class="form-control" name="selectNewsCategory" id="news_category">
										<?php
											$newsCategoryArr = array(
											'--Select news category--' => "",
											'Nation' => 1,	'World' => 2,
											'Sport' => 3,	'Entertainment' => 4
											);
											foreach($newsCategoryArr as $newsType => $newsNum){
												echo "<option value=\"$newsType\">$newsType</option>";
											}
										?>
									</select>
								</div>
								<div class="form-group mb-3">
									<label for="inputNewsImage" class="col-form-label">News Image:</label>
									<div class="custom-file">
										<input type="file" class="custom-file-input" name="uploadNewsImg" id="news_image">
										<label class="custom-file-label" for="news_image"></label>
									</div>
								</div>
								<div class="form-group">
									<label for="inputNewsDetails" class="col-form-label">News Details:</label>
									<textarea class="form-control" name="txtNewsDetails" id="news_details" rows="10"></textarea>
								</div>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
								<button type="submit" class="btn btn-primary" name="updNewsData" style="background: #1f52a3;">Edit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--edit news modal END-->
			
			<!--delete news modal START-->
			<!-- Modal -->
			<div class="modal fade" id="delNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-dialog-centered" role="document">
					<div class="modal-content">
						<form action="/205CDE/Assignment/deleteData.php" method="post">
							<div class="modal-body">
								<input type="hidden" name="delete_id" id="delete_id">
								<div class="d-flex justify-content-center" style="margin: 25px 0;">
									<i class="fas fa-times-circle text-danger" style="font-size: 100px;"></i>
								</div>
								<div class="d-flex justify-content-center">
									<h4>Are you sure?</h4>
								</div>
								<div class="d-flex justify-content-center">
									<p class="col-1"></p>
									<p class="col-10" style="text-align: center;">Do you really want to delete this record?<br>This process cannot be undone.</p>
									<p class="col-1"></p>
								</div>
								<div class="row justify-content-around" style="margin: 15px 0;">
									<div class="col-6 d-flex justify-content-end">
										<button type="button" class="btn btn-secondary btn-lg" data-dismiss="modal">Cancel</button>
									</div>
									<div class="col-6 d-flex justify-content-start">
										<button type="submit" class="btn btn-danger btn-lg" name="delNewsData">Delete</button>
									</div>
									<input type="hidden" name="delSubmitted" value="true"/>
								</div>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--delete news modal END-->
			
			<div class="container-fluid bg-light" style="padding: 30px 10px;">
				<div class="row bg-light" style="margin: 0 35px;">
					<div class="col-6">
						<h5>All News</h5>
					</div>
					<div class="col-6 d-flex justify-content-end">
						<button type="button" class="btn btn-primary" style="background: #1f52a3;" data-toggle="modal" data-target="#addNewsModal"><i class="fas fa-plus" style="font-size: 20px;"></i> Add News</button>
					</div>
				</div>
				<!--add news alert START-->
				<div class="row bg-light" style="margin: 15px 35px;" id="addNewsAlert">
					<div class="col-12">
						<div class="alert alert-success alert-dismissible fade show" role="alert" >
							<strong>Success!</strong> The news is added successfully!
							<button type="button" class="close" data-dismiss="alert" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>
						</div>
					</div>
				</div>
				<!--add news alert END-->
				
				<!--news table START-->
				<div class="card-deck" style="margin: 15px 50px;">
					<?php
						$dbc = mysqli_connect('localhost', 'root', '');	//connect database
						mysqli_select_db($dbc, 'news');	//select database
						
						$query = 'SELECT * FROM news ORDER BY news_datetime DESC';
						$runQuery = mysqli_query($dbc, $query);
					?>
					<table class="table table-hover bg-light" id="manageNewsTable">
						<thead class="thead-light">
							<tr>
								<th scope="col">News ID</th>
								<th scope="col">News Created Datetime</th>
								<th scope="col">News Title</th>
								<th scope="col">News Details</th>
								<th scope="col">News Category</th>
								<th scope="col">News Image</th>
								<th scope="col">Edit/Delete</th>
							</tr>
						</thead>
						<?php
							if($runQuery){
								foreach($runQuery as $row){
								?>
								<tbody>
									<tr>
										<td><?php echo $row['news_id']; ?></td>
										<td><small><?php echo $row['news_datetime'];?></small></td>
										<td><?php echo $row['news_title']; ?></td>
										<td><?php echo $row['news_details']; ?></td>
										<td><?php echo $row['news_category']; ?></td>
										<td>
											<a href="<?php 
												if(empty($row['news_image'])){
													echo 'https://via.placeholder.com/200x200';
													}else{
													echo '/205CDE/Assignment/'.$row['news_image'];
												} ?>" target="_blank">
												<img src="<?php 
													if(empty($row['news_image'])){
														echo 'https://via.placeholder.com/200x200';
														}else{
														echo $row['news_image'];
													}?>" alt="Thumbnail News Image" class="img-thumbnail">
											</a>
										</td>
										<td>
											<button type="button" class="btn btn-info btnEdit"><i class="fas fa-edit" style="font-size: 14px;"></i></button>
											<button type="button" class="btn btn-danger btnDel"><i class="fas fa-trash" style="font-size: 14px;"></i></button>
										</td>
									</tr>
								</tbody>
								<?php
								}
								}else{
								echo "ERROR! No record found!";
							}
							mysqli_close($dbc);
						?>
					</table>
				</div>
				<!--news table END-->
			</div>
			<!--using external files-->
			<?php require('footer.html'); ?>
		</body>
	</html>
content_copy

#php

insertData.php 
<?php
	$dbc = mysqli_connect('localhost', 'root', '');	//connect database
	mysqli_select_db($dbc, 'news');	//select database
	
	$errorsAddNewsArr = array();
	
	if(isset($_POST['addNewsData'])){
		$newsTitle = trim(str_replace("'", "\'", $_POST['txtNewsTitle']));
		$newsDetails = trim(str_replace("'", "\'", $_POST['txtNewsDetails']));
		$newsCategory = $_POST['selectNewsCategory'];
		
		$targetImage = "/205CDE/Assignment/".basename($_FILES['uploadNewsImg']['name']);
		$newsImage = $_FILES['uploadNewsImg']['name'];
		
		//ensure form fields are filled properly
		if(empty($newsTitle)){
			array_push($errorsAddNewsArr, "News title is required! Please try again!");
		}
		if(empty($newsDetails)){
			array_push($errorsAddNewsArr, "News details is required! Please try again!");
		}
		if($newsCategory == 0){
			array_push($errorsAddNewsArr, "News category is required! Please try again!");
		}
		
		//no errors
		if(count($errorsAddNewsArr) == 0){
			$query = "INSERT INTO news (news_title, news_details, news_category, news_datetime, news_image) 
			VALUES ('$newsTitle', '$newsDetails', '$newsCategory', NOW(), '$newsImage')";
			
			//Move uploaded image into a folder
			if(move_uploaded_file($_FILES['name']['tmp_name'], $targetImage)){
				$msg = "Image uploaded successfully!";
				}else{
				$msg = "Image uploaded unsuccessfully!";
			}
			
			$runQuery = mysqli_query($dbc, $query);
			
			if($runQuery){
				echo '<script> alert("Data saved!"); </script>';
				header('Location: /205CDE/Assignment/manageNews.php');
				}else{
				echo '<script> alert("Data not save yet!"); </script>';
			}
		}else{
			//display error message in alert
			foreach($errorsAddNewsArr as $errorsAddNewsMsg){
				echo '<script type="text/javascript">alert("'.$errorsAddNewsMsg.'");</script>'; 
			}
			
			//redirect to manageNews.php
			echo '<script type="text/javascript">window.location.href = "/205CDE/Assignment/manageNews.php";</script>'; 
		}
	}
	mysqli_close($dbc);
?>
content_copy

#php

footer.html 
<footer>
	<div class="container-fluid" style="background: #1f52a3; margin-top: 50px; padding: 30px;">
		<div class="row">
			<div class="col-1"></div>
			<div class="col-10 d-flex justify-content-start" style="color: #e6e8eb;">&#169; Copyright 2020 U Chen Daily. All rights reserved.</div>
			<div class="col-1"></div>
		</div>
	</div>
</footer>
content_copy

#php

aboutUs.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen  Daily | About Us</title>
	</head>
	<body>
		<!--using external files-->
		<?php require('header.html'); ?>
		<div class="container" style="margin: 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">About Us</h3></div>
			</div>
		</div>
		<div class="container-fluid bg-light" style="padding: 30px 10px;">
			<div class="row bg-light" style="margin: 0 35px;">
				<div class="col">
					<h4>U Chen  Daily</h4>
				</div>
			</div>
			<div class="row bg-light" style="margin: 10px 35px;">
				<div class="col-6">
					<p>Since its launch on June 23, 1995, as Malaysia's first news website, U Chen  Daily has always striven to provide readers with up to date breaking news, compelling content and insightful opinions.</p>
					<p>Evolving with the times, our content includes current news, business, sports, community, tech, lifestyle and world news, as well as expert analysis and dynamic videos.</p>
					<p>The website was recognised in 2014 as one of the best in Asia by the World Association of Newspapers and News Publishers (WAN-IFRA).</p>
					<p>It serves as the foundation of an online community that has a million strong following on both Twitter and Facebook.</p>
					<p>As the digital companion to U Chen  Daily newspaper, U Chen  Daily is part of a portfolio that offers content through print, U Chen  Daily ePaper and a mobile app.</p>
					<p>Readers on-the-go who want breaking news and business updates delivered to them can opt for our SMS services available via Maxis and DiGi.</p>
				</div>
				<div class="col-6">
					<p>U Chen  Daily (daily) and Sunday U Chen  are published in five editions. Two editions cover the northern peninsular states of Penang, Kedah, Perlis, Kelantan and northern Perak, while another two editions cover the rest of the country. As of March 2010, the newspaper has a separate Sarawak edition priced at RM1.20.</p>
					<p>There are two main printing plants that publish four editions of U Chen  Daily on a daily basis. The northern editions are printed at U Chen  Daily Northern Hub in Bayan Lepas, Penang, while the other two editions are printed at U Chen  Daily Media Hub in Bukit Jelutong, Shah Alam, Selangor.</p>
					<p>U Chen  Daily weekday paper is packaged as a 4-in-1 paper, comprising the Main Paper, U Chen Biz, U Chen 2 and U Chen  Metro. Naturally, this newspaper also contains classifieds.</p>
					<p>The Main Paper covers the latest in both local and international news while U Chen Biz offers a comprehensive coverage of business developments, market trends, financial reports and updates in the stock market. U Chen 2 features articles on lifestyle, entertainment, health, parenting, social etiquette, science, environment, fashion, food, comics and many more. The contents published on U Chen  Daily Metro varies by edition, covering news and events in a particular region covered by each edition.</p>
				</div>
			</div>
		</div>
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#php

contactUs.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen  Daily | Contact Us</title>
	</head>
	<style>
		.google-maps {
        position: relative;
        padding-bottom: 50%;
        height: 0;
        overflow: hidden;
		}
		.google-maps iframe {
        position: absolute;
        top: 0;
        left: 0;
        width: 100% !important;
        height: 100% !important;
		}
		i {
		font-size: 50px; 
		color: #1f52a3;
		}
		h5 {
		color: #1f52a3;
		margin-top: 35px;
		}
	</style>
	<body>
		<!--using external files-->
		<?php require('header.html'); ?>
		<div class="container" style="margin: 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">Contact Us</h3></div>
			</div>
		</div>
		<div class="container-fluid bg-light" style="padding: 30px 10px;">
			<div class="row bg-light" style="margin: 0px 35px;">
				<div class="col-12 google-maps">
					<iframe src="https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3972.4919887247825!2d100.2796820147649!3d5.341603796125226!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x304ac048a161f277%3A0x881c46d428b3162c!2sINTI%20International%20College%20Penang!5e0!3m2!1sen!2smy!4v1606047317819!5m2!1sen!2smy" width="600" height="450" frameborder="0" style="border: 2px solid #1f52a3;" allowfullscreen="" aria-hidden="false" tabindex="0"></iframe>
				</div>
			</div>
			<div class="row bg-light" style="margin: 35px 35px 0;">
				<div class="col-4">
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<i class="far fa-envelope"></i>
					</div>
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<h5>info@uchendaily.com</h5>
					</div>
				</div>
				<div class="col-4">
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<i class="fas fa-phone-alt"></i>
					</div>
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<h5>+604-577 9999</h5>
					</div>
				</div>
				<div class="col-4">
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<i class="fas fa-map-marker-alt"></i>
					</div>
					<div class="row bg-light d-flex justify-content-center align-items-center">
						<h5>1-Z, Lebuh Bukit Jambul,<br>Bukit Jambul,<br>11900 Bayan Lepas,Pulau Pinang.</h5>
					</div>
				</div>
			</div>
		</div>
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#php

faqs.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | FAQs</title>
	</head>
	<style>
		.card-header{
		background: #1f52a3;
		}
		.card-body{
		color: #1f52a3;
		}
		h3{
		color: #1f52a3;
		margin: 20px 0;
		}
	</style>
	<body>
		<!--using external files-->
		<?php require('header.php'); ?>
		<div class="container" style="margin: 5px 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">FAQs</h3></div>
			</div>
		</div>
		<div class="container-fluid bg-light" style="padding: 10px 10px 50px;">
			<div class="row bg-light" style="margin: 10px 35px; font-size: 18px;">
				<div class="col-lg-6">
					<h3>General</h3>
					<div class="accordion" id="accordionExample">
						<!--first faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingOne">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light" type="button" data-toggle="collapse" data-target="#collapseOne" aria-expanded="true" aria-controls="collapseOne">
										There is something wrong with TheUChen.com.my and/or app. What should I do? (example: broken link, error page, spotted some issues)
									</button>
								</h2>
							</div>
							<div id="collapseOne" class="collapse show" aria-labelledby="headingOne" data-parent="#accordionExample">
								<div class="card-body bg-white">
									We are sorry for the inconvenience caused. Please report your issue to us and include as much information as possible.
								</div>
							</div>
						</div>
						<!--first faq END-->
						<!--second faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingTwo">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseTwo" aria-expanded="false" aria-controls="collapseTwo">
										I want to publish articles or pictures from U Chen Daily. How do I get copyright permission?
									</button>
								</h2>
							</div>
							<div id="collapseTwo" class="collapse" aria-labelledby="headingTwo" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Write to us and get permission. Granting or refusal of permission is at our sole and absolute discretion.
								</div>
							</div>
						</div>
						<!--second faq END-->
						<!--third faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingThree">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseThree" aria-expanded="false" aria-controls="collapseThree">
										Why can I only read a limited number of articles on TheUChen.com.my and app?
									</button>
								</h2>
							</div>
							<div id="collapseThree" class="collapse" aria-labelledby="headingThree" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Effective Feb 24, 2020, we will be offering a paid digital membership for unlimited access to TheUChen.com.my and app (“Digital Access”). This will ensure that we continue to provide reliable, relevant, and compelling content while maintaining the quality of journalism that readers trust us to uphold. The membership, called U Chen Daily Digital Access, also includes personalisation features to improve your reading experience.
								</div>
							</div>
						</div>
						<!--third faq END-->
						<!--4th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingFour">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseFour" aria-expanded="false" aria-controls="collapseFour">
										How can I keep track of how many articles I have read?
									</button>
								</h2>
							</div>
							<div id="collapseFour" class="collapse" aria-labelledby="headingFour" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Sorry, you can't track your article limit at the moment. We're still developing this part of the system so do bear with us while we continue to improve.
								</div>
							</div>
						</div>
						<!--4th faq END-->
						<!--5th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingFive">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseFive" aria-expanded="false" aria-controls="collapseFive">
										If I don’t want to register as a member, can I still read articles for free?
									</button>
								</h2>
							</div>
							<div id="collapseFive" class="collapse" aria-labelledby="headingFive" data-parent="#accordionExample">
								<div class="card-body bg-white">
									As a guest user without an active paid membership, you can access a limited number of articles for free each month. This limit resets every 30 days. This excludes premium content (marked as ‘PREMIUM’), which are exclusive to paid members, and content hosted on a separate subscription-based service, e.g. dimsum e-tuition videos.
								</div>
							</div>
						</div>
						<!--5th faq END-->
						<!--6th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingSix">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseSix" aria-expanded="false" aria-controls="collapseSix">
										Do I need to log in with a MyUChen account if I just want to read articles for free as a guest user?
									</button>
								</h2>
							</div>
							<div id="collapseSix" class="collapse" aria-labelledby="headingSix" data-parent="#accordionExample">
								<div class="card-body bg-white">
									While it’s not compulsory, we do recommend that you sign up for a MyUChen account. As a member, you can UChent your 1-month free trial to U Chen Daily Digital Access and enjoy personalisation features to improve your reading experience.
								</div>
							</div>
						</div>
						<!--6th faq END-->
						<!--7th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingSeven">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseSeven" aria-expanded="false" aria-controls="collapseSeven">
										What does the paid U Chen Daily Digital Access membership entail?
									</button>
								</h2>
							</div>
							<div id="collapseSeven" class="collapse" aria-labelledby="headingSeven" data-parent="#accordionExample">
								<div class="card-body bg-white">
									With U Chen Daily Digital Access membership, you will be able to access all articles on TheUChen.com.my and app, including premium content which are exclusive to paid members, excluding content hosted on a separate subscription-based services, e.g. dimsum e-tuition videos. Members can also access all personalisation features.
								</div>
							</div>
						</div>
						<!--7th faq END-->
						<!--8th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingEight">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseEight" aria-expanded="false" aria-controls="collapseEight">
										I'm currently subscribed to ePaper. Do I still need to subscribe to U Chen Daily?
									</button>
								</h2>
							</div>
							<div id="collapseEight" class="collapse" aria-labelledby="headingEight" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Yes. At the moment U Chen Daily Digital Access and ePaper subscription are on two separate platforms.
								</div>
							</div>
						</div>
						<!--8th faq END-->
					</div>
				</div>
				<div class="col-lg-6">
					<h3>About Account</h3>
					<div class="accordion" id="accordionExample">
						<!--9th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingNine">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light" type="button" data-toggle="collapse" data-target="#collapseNine" aria-expanded="true" aria-controls="collapseNine">
										I can’t sign up/register from Internet Explorer?
									</button>
								</h2>
							</div>
							<div id="collapseNine" class="collapse show" aria-labelledby="headingNine" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Internet Explorer is not supported at the moment. Best view from Chrome browsers.
								</div>
							</div>
						</div>
						<!--9th faq END-->
						<!--10th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingTen">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseTen" aria-expanded="false" aria-controls="collapseTen">
										I signed up for a free MyUChen account before Feb 10, 2020 and was prompted to update my password. What should I do?
									</button>
								</h2>
							</div>
							<div id="collapseTen" class="collapse" aria-labelledby="headingTen" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Please log in with your username/email and change your password with a minimum of eight characters. It must contain at least one upper case letter, one number, and one special character except '+' and '='. Please use your new password for future logins.
								</div>
							</div>
						</div>
						<!--10th faq END-->
						<!--11th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingEleven">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseEleven" aria-expanded="false" aria-controls="collapseEleven">
										Why do I have to change my password?
									</button>
								</h2>
							</div>
							<div id="collapseEleven" class="collapse" aria-labelledby="headingEleven" data-parent="#accordionExample">
								<div class="card-body bg-white">
									We've made some enhancements to the TheUChen.com.my and app to improve your reading experience and for web security. This includes migrating all MyUChen accounts to a new system. Members who signed up before Feb 10, 2020, are required to update their password.
								</div>
							</div>
						</div>
						<!--11th faq END-->
						<!--12th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingTwelve">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseTwelve" aria-expanded="false" aria-controls="collapseTwelve">
										I forgot my password, what should I do?
									</button>
								</h2>
							</div>
							<div id="collapseTwelve" class="collapse" aria-labelledby="headingTwelve" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Click ‘Forgot Password?’ and you will be emailed a temporary password that you can log in with. Please proceed to change your password as soon as possible.
								</div>
							</div>
						</div>
						<!--12th faq END-->
						<!--13th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingThirteen">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseThirteen" aria-expanded="false" aria-controls="collapseThirteen">
										I’ve updated my password, but I can’t log in with MyUChen account’s username?
									</button>
								</h2>
							</div>
							<div id="collapseThirteen" class="collapse" aria-labelledby="headingThirteen" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Please use the new password with your MyUChen email.
								</div>
							</div>
						</div>
						<!--13th faq END-->
						<!--14th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingFourteen">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseFourteen" aria-expanded="false" aria-controls="collapseFourteen">
										I registered for a MyUChen account but did not receive any verification email. What should I do?
									</button>
								</h2>
							</div>
							<div id="collapseFourteen" class="collapse" aria-labelledby="headingFourteen" data-parent="#accordionExample">
								<div class="card-body bg-white">
									lease check both your Inbox and/or Spam folders. Click ‘Resend verification email’ and try again. If you have closed the page or have been logged out, please log in again to click ‘Resend verification email’.
									<br>
									If you are using a corporate email, kindly inform your tech department to whitelist @theUChen.com.my.
								</div>
							</div>
						</div>
						<!--14th faq END-->
						<!--15th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingFifteen">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseFifteen" aria-expanded="false" aria-controls="collapseFifteen">
										The email verification link/code provided is invalid. What should I do?
									</button>
								</h2>
							</div>
							<div id="collapseFifteen" class="collapse" aria-labelledby="headingFifteen" data-parent="#accordionExample">
								<div class="card-body bg-white">
									Click ‘Resend verification email’ and try again. If you have closed the page or have been logged out, please log in again to click ‘Resend verification email’.
								</div>
							</div>
						</div>
						<!--15th faq END-->
						<!--16th faq UChenT-->
						<div class="card">
							<div class="card-header" id="headingSixteen">
								<h2 class="mb-0">
									<button class="btn btn-block text-left text-light collapsed" type="button" data-toggle="collapse" data-target="#collapseSixteen" aria-expanded="false" aria-controls="collapseSixteen">
										I can’t seem to register. It says email address previously registered. What do I do?
									</button>
								</h2>
							</div>
							<div id="collapseSixteen" class="collapse" aria-labelledby="headingSixteen" data-parent="#accordionExample">
								<div class="card-body bg-white">
									If you have forgotten your password, click ‘Forgot Password?’ to reset it. If you are certain that you did not sign up with your email address before, kindly contact our Customer Service.
								</div>
							</div>
						</div>
						<!--16th faq END-->
					</div>
				</div>
			</div>
		</div>
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#javascript #css #html #php

Home.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | Home</title>
	</head>
	<style>
		@media only screen and (min-width: 893px) {
		.card-img-top{
		width: 100%;
		height: 15vw; 
		object-fit: cover;
		}
		}
		
		.card-body{
		background: #1f52a3;
		}
		
		.card-footer{
		background: #1f52a3;
		}
		
		.h5{
		color: #1f52a3;
		}
		
		.card-text{
		font-size: 12px;
		}
	</style>
	<body class="bg-light">
		<!--using external files-->
		<?php require('header.php'); ?>
		<div id="carouselExampleCaptions" class="carousel slide" data-ride="carousel">
			<ol class="carousel-indicators">
				<li data-target="#carouselExampleCaptions" data-slide-to="0" class="active"></li>
				<li data-target="#carouselExampleCaptions" data-slide-to="1"></li>
				<li data-target="#carouselExampleCaptions" data-slide-to="2"></li>
			</ol>
			<div class="carousel-inner">
				<div class="carousel-item active">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>First slide label</h5>
						<p>Nulla vitae elit libero, a pharetra augue mollis interdum.</p>
					</div>
				</div>
				<div class="carousel-item">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>Second slide label</h5>
						<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</p>
					</div>
				</div>
				<div class="carousel-item">
					<img src="https://via.placeholder.com/1500x550" class="d-block w-100" alt="...">
					<div class="carousel-caption d-none d-sm-block">
						<h5>Third slide label</h5>
						<p>Praesent commodo cursus magna, vel scelerisque nisl consectetur.</p>
					</div>
				</div>
			</div>
			<a class="carousel-control-prev" href="#carouselExampleCaptions" role="button" data-slide="prev">
				<span class="carousel-control-prev-icon" aria-hidden="true"></span>
				<span class="sr-only">Previous</span>
			</a>
			<a class="carousel-control-next" href="#carouselExampleCaptions" role="button" data-slide="next">
				<span class="carousel-control-next-icon" aria-hidden="true"></span>
				<span class="sr-only">Next</span>
			</a>
		</div>
		<!--4 latest news START-->
		<div class="container-fluid bg-light" style="padding: 40px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-6">
					<h5 style="color: #1f52a3;">Latest News</h5>
				</div>
				
				<div class="col-6 d-flex justify-content-end">
					<a href="" class="btn btn-link font-weight-bold" style="color: #1f52a3;">MORE NEWS <i class="fas fa-angle-double-right" style="font-size: 18px;"></i></a>
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 latest news END-->
		<!--4 nation news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">Nation News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="Nation" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php	
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 nation news END-->
		<!--4 world news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">World News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="World" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 world news END-->
		<!--4 entertainment news START-->
		<div class="container-fluid bg-light" style="padding: 20px 0 0; margin-bottom: 40px;">
			<div class="row" style="margin: 0 50px;">
				<div class="col-sm">
					<h5 style="color: #1f52a3;">Entertainment News</h5>
				</div>
				<div class="col-sm">
				</div>
				<div class="col-sm">
				</div>
			</div>
			
			<div class="card-deck" style="margin: 10px 50px;">
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news WHERE news_category="Entertainment" ORDER BY news_datetime DESC LIMIT 4';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<!--news card START-->
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
						<div class="card mb-4">
							<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id'] ?>">
								<img class="card-img-top" 
								src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
							</a>
							<div class="card-body">
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
							</div>
							<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
						</div>
						<div class="w-100 d-none d-sm-block d-lg-none"><!-- wrap every 2 on sm--></div>
						<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
				<!--news card END-->
			</div>
		</div>
		<!--4 entertainment news END-->
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#php

manageNews.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | Admin</title>
		<script type="text/javascript">
			setTimeout(function(){ 
				document.querySelector('.close').click();
			}, 2500);
		</script>
		<!--show news info for editing START-->
		<script type="text/javascript">
			$(document).ready(function(){
				$('.btnEdit').on('click', function(){
					$('#updNewsModal').modal('show');
					
					$tr = $(this).closest('tr');
					
					var data = $tr.children("td").map(function(){
						return $(this).text();
					}).get();
					
					console.log(data);
					
					$('#update_id').val(data[0]);
					$('#news_datetime').val(data[1]);
					$('#news_title').val(data[2]);
					$('#news_details').val(data[3]);
					$('#news_category').val(data[4]);
					$('#news_image').val(data[5]);
				});
			});
		</script>
		<!--show news info for editing END-->
		
		<!--show confirmation message for deleting START-->
		<script type="text/javascript">
			$(document).ready(function(){
				$('.btnDel').on('click', function(){
					$('#delNewsModal').modal('show');
					
					$tr = $(this).closest('tr');
					
					var data = $tr.children("td").map(function(){
						return $(this).text();
					}).get();
					
					console.log(data);
					
					$('#delete_id').val(data[0]);
				});
			});
		</script>
		<!--show confirmation message for deleting END-->
		
		<!--show file name after uploading image START-->
		<script type="text/javascript">
            $(document).ready(function() {
                bsCustomFileInput.init();
			});
		</script>
		<!--show file name after uploading image END-->
		<body>
			<!--using external files-->
			<?php
				if(empty($_SESSION['username'])){
					header('Location: /205CDE/Assignment/home.php');
				}
			?>
			<?php require('header.php'); ?>
			
			<div class="container" style="margin: 20px;">
				<div class="row">
					<div class="col-sm"><h3 style="color: #1f52a3;">Manage News</h3></div>
				</div>
			</div>
			<!--add news modal START-->
			<!-- Modal -->
			<div class="modal fade bd-example-modal-lg" id="addNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-lg" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<h5 class="modal-title" id="exampleModalLabel">Add News</h5>
							<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>-->
						</div>
						<form action="/205CDE/Assignment/insertData.php" method="post" enctype="multipart/form-data">
							<div class="modal-body">
								<div class="form-group">
									<label for="inputNewsTitle">News Title:</label>
									<input type="text" class="form-control" name="txtNewsTitle" id="inputNewsTitle" aria-describedby="emailHelp" placeholder="Enter news title">
								</div>
								<div class="form-group">
									<label for="selectNewsCategory">News Category:</label>
									<select class="form-control" name="selectNewsCategory" id="selectNewsCategory">
										<?php
											$newsCategoryArr = array(
											'--Select news category--' => "",
											'Nation' => 1,	'World' => 2,
											'Sport' => 3,	'Entertainment' => 4
											);
											foreach($newsCategoryArr as $newsType => $newsNum){
												echo "<option value=\"$newsType\">$newsType</option>";
											}
										?>
									</select>
								</div>
								<div class="form-group mb-3">
									<label for="inputNewsImage" class="col-form-label">News Image:</label>
									<div class="custom-file">
										<input type="file" class="custom-file-input" name="uploadNewsImg" id="customFile">
										<label class="custom-file-label" for="customFile">Choose file</label>
									</div>
								</div>
								<div class="form-group">
									<label for="inputNewsDetails" class="col-form-label">News Details:</label>
									<textarea class="form-control" name="txtNewsDetails" id="inputNewsDetails" rows="10"></textarea>
								</div>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
								<button type="submit" class="btn btn-primary" name="addNewsData" style="background: #1f52a3;">Add</button>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--add news modal END-->
			
			<!--edit news modal START-->
			<!-- Modal -->
			<div class="modal fade bd-example-modal-lg" id="updNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-lg" role="document">
					<div class="modal-content">
						<div class="modal-header">
							<h5 class="modal-title" id="exampleModalLabel">Edit News</h5>
							<!--<button type="button" class="close" data-dismiss="modal" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>-->
						</div>
						<form action="/205CDE/Assignment/updateData.php" method="post" enctype="multipart/form-data">
							<div class="modal-body">
								<input type="hidden" name="update_id" id="update_id">
								<div class="form-group">
									<label for="txtNewsDatetime">News Created Datetime:</label>
									<input type="text" class="form-control" name="txtNewsDatetime" id="news_datetime" aria-describedby="emailHelp" placeholder="Enter news datetime" disabled>
								</div>
								<div class="form-group">
									<label for="inputNewsTitle">News Title:</label>
									<input type="text" class="form-control" name="txtNewsTitle" id="news_title" aria-describedby="emailHelp" placeholder="Enter news title">
								</div>
								<div class="form-group">
									<label for="selectNewsCategory">News Category:</label>
									<select class="form-control" name="selectNewsCategory" id="news_category">
										<?php
											$newsCategoryArr = array(
											'--Select news category--' => "",
											'Nation' => 1,	'World' => 2,
											'Sport' => 3,	'Entertainment' => 4
											);
											foreach($newsCategoryArr as $newsType => $newsNum){
												echo "<option value=\"$newsType\">$newsType</option>";
											}
										?>
									</select>
								</div>
								<div class="form-group mb-3">
									<label for="inputNewsImage" class="col-form-label">News Image:</label>
									<div class="custom-file">
										<input type="file" class="custom-file-input" name="uploadNewsImg" id="news_image">
										<label class="custom-file-label" for="news_image"></label>
									</div>
								</div>
								<div class="form-group">
									<label for="inputNewsDetails" class="col-form-label">News Details:</label>
									<textarea class="form-control" name="txtNewsDetails" id="news_details" rows="10"></textarea>
								</div>
							</div>
							<div class="modal-footer">
								<button type="button" class="btn btn-secondary" data-dismiss="modal">Cancel</button>
								<button type="submit" class="btn btn-primary" name="updNewsData" style="background: #1f52a3;">Edit</button>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--edit news modal END-->
			
			<!--delete news modal START-->
			<!-- Modal -->
			<div class="modal fade" id="delNewsModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalLabel" aria-hidden="true">
				<div class="modal-dialog modal-dialog-centered" role="document">
					<div class="modal-content">
						<form action="/205CDE/Assignment/deleteData.php" method="post">
							<div class="modal-body">
								<input type="hidden" name="delete_id" id="delete_id">
								<div class="d-flex justify-content-center" style="margin: 25px 0;">
									<i class="fas fa-times-circle text-danger" style="font-size: 100px;"></i>
								</div>
								<div class="d-flex justify-content-center">
									<h4>Are you sure?</h4>
								</div>
								<div class="d-flex justify-content-center">
									<p class="col-1"></p>
									<p class="col-10" style="text-align: center;">Do you really want to delete this record?<br>This process cannot be undone.</p>
									<p class="col-1"></p>
								</div>
								<div class="row justify-content-around" style="margin: 15px 0;">
									<div class="col-6 d-flex justify-content-end">
										<button type="button" class="btn btn-secondary btn-lg" data-dismiss="modal">Cancel</button>
									</div>
									<div class="col-6 d-flex justify-content-start">
										<button type="submit" class="btn btn-danger btn-lg" name="delNewsData">Delete</button>
									</div>
									<input type="hidden" name="delSubmitted" value="true"/>
								</div>
							</div>
						</form>
					</div>
				</div>
			</div>
			<!--delete news modal END-->
			
			<div class="container-fluid bg-light" style="padding: 30px 10px;">
				<div class="row bg-light" style="margin: 0 35px;">
					<div class="col-6">
						<h5>All News</h5>
					</div>
					<div class="col-6 d-flex justify-content-end">
						<button type="button" class="btn btn-primary" style="background: #1f52a3;" data-toggle="modal" data-target="#addNewsModal"><i class="fas fa-plus" style="font-size: 20px;"></i> Add News</button>
					</div>
				</div>
				<!--add news alert START-->
				<div class="row bg-light" style="margin: 15px 35px;" id="addNewsAlert">
					<div class="col-12">
						<div class="alert alert-success alert-dismissible fade show" role="alert" >
							<strong>Success!</strong> The news is added successfully!
							<button type="button" class="close" data-dismiss="alert" aria-label="Close">
								<span aria-hidden="true">&times;</span>
							</button>
						</div>
					</div>
				</div>
				<!--add news alert END-->
				
				<!--news table START-->
				<div class="card-deck" style="margin: 15px 50px;">
					<?php
						$dbc = mysqli_connect('localhost', 'root', '');	//connect database
						mysqli_select_db($dbc, 'news');	//select database
						
						$query = 'SELECT * FROM news ORDER BY news_datetime DESC';
						$runQuery = mysqli_query($dbc, $query);
					?>
					<table class="table table-hover bg-light" id="manageNewsTable">
						<thead class="thead-light">
							<tr>
								<th scope="col">News ID</th>
								<th scope="col">News Created Datetime</th>
								<th scope="col">News Title</th>
								<th scope="col">News Details</th>
								<th scope="col">News Category</th>
								<th scope="col">News Image</th>
								<th scope="col">Edit/Delete</th>
							</tr>
						</thead>
						<?php
							if($runQuery){
								foreach($runQuery as $row){
								?>
								<tbody>
									<tr>
										<td><?php echo $row['news_id']; ?></td>
										<td><small><?php echo $row['news_datetime'];?></small></td>
										<td><?php echo $row['news_title']; ?></td>
										<td><?php echo $row['news_details']; ?></td>
										<td><?php echo $row['news_category']; ?></td>
										<td>
											<a href="<?php 
												if(empty($row['news_image'])){
													echo 'https://via.placeholder.com/200x200';
													}else{
													echo '/205CDE/Assignment/'.$row['news_image'];
												} ?>" target="_blank">
												<img src="<?php 
													if(empty($row['news_image'])){
														echo 'https://via.placeholder.com/200x200';
														}else{
														echo $row['news_image'];
													}?>" alt="Thumbnail News Image" class="img-thumbnail">
											</a>
										</td>
										<td>
											<button type="button" class="btn btn-info btnEdit"><i class="fas fa-edit" style="font-size: 14px;"></i></button>
											<button type="button" class="btn btn-danger btnDel"><i class="fas fa-trash" style="font-size: 14px;"></i></button>
										</td>
									</tr>
								</tbody>
								<?php
								}
								}else{
								echo "ERROR! No record found!";
							}
							mysqli_close($dbc);
						?>
					</table>
				</div>
				<!--news table END-->
			</div>
			<!--using external files-->
			<?php require('footer.html'); ?>
		</body>
	</html>
content_copy

#php

news.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html') ?>
		
		<title>U Chen Daily | News</title>
	</head>
	<body>
		<!--using external files-->
		<?php require('header.php'); ?>
		<div class="container" style="margin: 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">News</h3></div>
			</div>
		</div>
		<?php
			$dbc = mysqli_connect('localhost', 'root', '');
			mysqli_select_db($dbc, 'news');
			
			if(isset($_GET['id']) && is_numeric($_GET['id'])){
				$query = "SELECT * FROM news WHERE news_id={$_GET['id']}";
				
				if($r = mysqli_query($dbc, $query)){
					$row = mysqli_fetch_array($r);
				?>
				<div class="container-fluid bg-light" style="padding: 50px 20px">
					<div class="row d-flex justify-content-between" style="margin: 0 50px;">
						<div class="col-lg-8 col-md-12">
							<div class="row mb-3">
								<h2 style="color: #1f52a3;"><?php echo $row['news_title'] ?></h2>
							</div>
							<div class="row">
								<div class="col mb-3" style="font-size: 18px; color:#1f52a3;">
									<i class="far fa-clock"></i>&nbsp
									<?php echo date('d-M-Y', strtotime($row['news_datetime'])); ?>&nbsp&nbsp&nbsp
									<i class="fas fa-tag"></i>&nbsp
									<?php echo strtoupper($row['news_category']); ?>
								</div>
							</div>
							<div class="row">
								<div class="col-12"  style="margin-bottom: 10px;">
									<img class="card-img-top" src="<?php 
										if(empty($row['news_image'])){
											echo 'https://via.placeholder.com/350x250';
											}else{
											echo $row['news_image'];
										}
									?>" alt="Card image cap" style="width:80%;">
								</div>
								
							</div>
							<div class="row" style="margin: 10px 0; font-size: 20px;">
								<p class="font-weight-normal"><?php echo $row['news_details'] ?></p>
							</div>
						</div>
						<?php
						}
					}
					mysqli_close($dbc);
				?>
				<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news ORDER BY news_datetime DESC LIMIT 5';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<div class="col-lg-4 col-md-12">
					<div class="list-group list-group-flush" style="border: 2px solid #1f52a3; border-top: 0;">
						<h4 class="list-group-item text-light text-center" style="background: #1f52a3;">Top 5 Latest News</h4>
						<?php
							if($runQuery){
								foreach($runQuery as $row){?>
								<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>" class="list-group-item list-group-item-action" target="_blank">
									<div class="row">
										<div class="col-3">
											<img src="<?php 
												if(empty($row['news_image'])){
													echo 'https://via.placeholder.com/200x200';
													}else{
													echo $row['news_image'];
												}?>" alt="Thumbnail News Image" class="img-thumbnail">
											</div>
											<div class="col-8" style="font-size: 15px;">
												<?php echo $row['news_title']; ?>
											</div>
										</div>
									</a>	
									<?php }
									}else{
									echo "ERROR! No record found!";
								}
								mysqli_close($dbc);
							?>
						</div>
					</div>
					<!--<div class="col-3" style="">
						<img class="card-img-top" src="https://via.placeholder.com/350x200" alt="Card image cap">
					</div>-->
				</div>
			</div>
			
			
			<!--using external files-->
			<?php require('footer.html'); ?>
		</body>
	</html>
content_copy

#php

header.php 
<?php
	session_start();
	
	$errorsArr = array();
	
	if(isset($_POST['submittedLogin'])){
		$username = $_POST['usernameLogin'];
		$password = $_POST['passwordLogin'];
		
		//ensure form fields are filled properly
		if(empty($username)){
			array_push($errorsArr, "Username is required! Please try again!");
		}
		if(empty($password)){
			array_push($errorsArr, "Password is required! Please try again!");
		}
		if((!empty($username)) && (!empty($password)) && ($username != 'admin') && ($password != 'admin')){
			array_push($errorsArr, "Incorrect username or password! Please try again!");
		}
		
		//no errors
		if(count($errorsArr) == 0){
			$_SESSION['username'] = $username;
			$_SESSION['success'] = "You are now logged in!";
			header('Location: /205CDE/Assignment/manageNews.php');
		}
	}
	
	//logout
	if(isset($_GET['logout'])){
		session_destroy();
		unset($_SESSION['username']);
		header('Location: /205CDE/Assignment/home.php');
	}
?>
<div class="container-fluid" style="background: #1f52a3;">
	<div class="row">
		<div class="col-2"></div>
		<div class="col-8">
			<a href="/205CDE/Assignment/home.php"><h1 style="text-align: center; color: #e6e8eb; margin: 20px 0;">U Chen Daily</h1></a>
		</div>
		<div class="col-2 d-flex justify-content-center align-items-center">
			<?php if(isset($_SESSION['username'])){ ?>
				<a href="/205CDE/Assignment/home.php?logout='1'" class="btn btn-outline-light">LOGOUT</a>
				<?php }else{ 
				?>
				<button type="button" class="btn btn-outline-light" data-toggle="modal" data-target="#loginFormModal">
					LOGIN AS ADMIN
				</button>
			<?php } ?>
			<!--<a href="/205CDE/Assignment/manageNews.php" target="_blank" class="btn btn-outline-light">LOGIN</a>-->
		</div>
	</div>
</div>
<!--login form modal START-->
<!-- Modal -->
<div class="modal fade" id="loginFormModal" tabindex="-1" role="dialog" aria-labelledby="exampleModalCenterTitle" aria-hidden="true">
	<div class="modal-dialog modal-dialog-centered" role="document">
		<div class="modal-content">
			<div class="modal-header">
				<h5 class="modal-title" id="exampleModalCenterTitle">Login</h5>
				<button type="button" class="close" data-dismiss="modal" aria-label="Close">
					<span aria-hidden="true">&times;</span>
				</button>
			</div>
			<form action="/205CDE/Assignment/home.php" method="post" id="loginModalForm">
				<div class="modal-body">
					<?php
						if(count($errorsArr) > 0){?>
						<div class="form-group">
							<?php
								foreach($errorsArr as $errorMsg){
									//echo "<p class=\"text-danger\">$errorMsg</p>";
									echo "<script>alert(\"$errorMsg\")</script>";
								}
							?>
						</div>
						<?php }
					?>
					<div class="form-group">
						<label for="exampleInputEmail1">Username</label>
						<input type="text" class="form-control" name="usernameLogin" id="exampleInputEmail1" aria-describedby="emailHelp" placeholder="Enter username" value="<?php if(isset($username)){echo $username;} ?>">
					</div>
					<div class="form-group">
						<label for="exampleInputPassword1">Password</label>
						<input type="password" class="form-control" name="passwordLogin" id="exampleInputPassword1" placeholder="Enter password">
					</div>
					<br>
					<div class="form-group">
						<button type="submit" class="btn btn-lg btn-block text-light" style="background: #1f52a3;">LOGIN</button>
						<input type="hidden" name="submittedLogin">
					</div>
				</div>
				<!--<div class="modal-footer">
					<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
					<button type="button" class="btn btn-primary">Login</button>
				</div>-->
			</form>
		</div>
	</div>
</div>
<!--login form modal END-->
<nav class="navbar navbar-expand-lg navbar-light bg-light">
	<a class="navbar-brand" href="/205CDE/Assignment/home.php"><i class="fas fa-home" style="font-size: 30px; color: #1f52a3;"></i></a>
	<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarSupportedContent" aria-controls="navbarSupportedContent" aria-expanded="false" aria-label="Toggle navigation">
		<span class="navbar-toggler-icon"></span>
	</button>
	
	<div class="collapse navbar-collapse" id="navbarSupportedContent">
		<ul class="navbar-nav mr-auto">
			<li class="nav-item dropdown" style="margin: 0 15px;">
				<a class="nav-link dropdown-toggle" href="#" id="navbarDropdown" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">News</a>
				<div class="dropdown-menu" aria-labelledby="navbarDropdown">
					<?php
						$newsCategoryArr = array(
						'All', 'Nation', 'World',
						'Sport', 'Entertainment',
						);
						foreach($newsCategoryArr as $newsType){
							echo "<a class=\"dropdown-item\" href=\"/205CDE/Assignment/news$newsType.php\" target=\"_blank\">$newsType</a>";
						}
					?>
				</div>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/aboutUs.php" target="_blank">About Us</a>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/contactUs.php" target="_blank">Contact Us</a>
			</li>
			<li class="nav-item" style="margin: 0 15px;">
				<a class="nav-link" href="/205CDE/Assignment/faqs.php" target="_blank">FAQs</a>
			</li>
			<!-- <li class="nav-item"> -->
			<!-- <a class="nav-link disabled" href="#" tabindex="-1" aria-disabled="true">Disabled</a> -->
			<!-- </li> -->
		</ul>
		<!-- <form class="form-inline my-2 my-lg-0"> -->
		<!-- <input class="form-control mr-sm-2" type="search" placeholder="Search" aria-label="Search"> -->
		<!-- <button class="btn btn-outline-success my-2 my-sm-0" type="submit">Search</button> -->
		<!-- </form> -->
	</div>
</nav>
content_copy

#php

newsList.php 
<html lang="en">
	<head>
		<!--using external files-->
		<?php require('import.html'); ?>
		
		<title>U Chen Daily | All News</title>
	</head>
	<style>
		@media only screen and (min-width: 893px) {
		.card-img-top{
		width: 100%;
		height: 15vw; 
		object-fit: cover;
		}
		}
		
		.card-body{
		background: #1f52a3;
		}
		
		.card-footer{
		background: #1f52a3;
		}
		
		.h5{
		color: #1f52a3;
		}
		
		.card-text{
		font-size: 12px;
		}
	</style>
	<body class="bg-light">
		<!--using external files-->
		<?php require('header.php'); ?>
		<div class="container" style="margin: 20px;">
			<div class="row">
				<div class="col-sm"><h3 style="color: #1f52a3;">All News</h3></div>
			</div>
		</div>
		<div class="container-fluid bg-light" style="padding: 30px 10px;">
			<div class="row d-flex justify-content-start" style="margin: 0 10px;">
			<?php
					$dbc = mysqli_connect('localhost', 'root', '');	//connect database
					mysqli_select_db($dbc, 'news');	//select database
					
					$query = 'SELECT * FROM news ORDER BY news_datetime DESC';
					$runQuery = mysqli_query($dbc, $query);
				?>
				<?php
					if($runQuery){
						foreach($runQuery as $row){
						?>
				<div class="card" style="width: 22rem; margin: 20px 30px;">
					<img class="card-img-top" src="<?php 
									if(empty($row['news_image'])){
										echo 'https://via.placeholder.com/350x250';
										}else{
										echo $row['news_image'];
									}
								?>" alt="Card image cap">
					<div class="card-body">
						<a href="/205CDE/Assignment/news.php?id=<?php echo $row['news_id']; ?>">
									<h5 class="card-title text-uppercase text-light d-md-none d-lg-block">
										<?php 
											if(strlen($row['news_title']) > 50){
												echo substr($row['news_title'], 0, 50).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
									<h5 class="card-title text-uppercase text-light d-none d-md-block d-lg-none">
										<?php 
											if(strlen($row['news_title']) > 106){
												echo substr($row['news_title'], 0, 106).'...';
												}else{
												echo $row['news_title'];
											}
										?>
									</h5>
								</a>
					</div>
					<div class="card-footer border-0">
								<div class="row">
									<div class="col-6 card-text text-light text-uppercase"><i class="fas fa-hashtag"></i>
										<?php echo $row['news_category']; ?>
									</div>
									<div class="col-6 card-text text-light text-right text-uppercase"><i class="far fa-clock"></i>
										<?php echo date('d-M-Y', strtotime($row['news_datetime']));?>
									</div>
								</div>
							</div>
				</div>
				<?php
						}
						}else{
						echo "ERROR! No record found!";
					}
					mysqli_close($dbc);
				?>
			</div>
		</div>
		<!--using external files-->
		<?php require('footer.html'); ?>
	</body>
</html>
content_copy

#php

updateData.php 
<?php
	$dbc = mysqli_connect('localhost', 'root', '');	//connect database
	mysqli_select_db($dbc, 'news');	//select database
	
	$errorsUpdNewsArr = array();
	
	if(isset($_POST['updNewsData'])){
		$newsID = $_POST['update_id'];
		$newsTitle = $_POST['txtNewsTitle'];
		$newsDetails = $_POST['txtNewsDetails'];
		$newsCategory = $_POST['selectNewsCategory'];
		
		$targetImage = "/205CDE/Assignment/".basename($_FILES['uploadNewsImg']['name']);
		$newsImage = $_FILES['uploadNewsImg']['name'];
		$newsImageExt = pathinfo($newsImage, PATHINFO_EXTENSION);
		
		//ensure form fields are filled properly
		if(empty($newsTitle)){
			array_push($errorsUpdNewsArr, "News title is required! Please try again!");
		}
		if(empty($newsDetails)){
			array_push($errorsUpdNewsArr, "News details is required! Please try again!");
		}
		if($_FILES["uploadNewsImg"]["error"] == 4){
			//no upload image
			//uploading news image is not mandatory
		}else{
			//check uploaded image file type
			if($newsImageExt !== 'jpg' && $newsImageExt !== 'jpeg' && $newsImageExt !== 'png' && $newsImageExt !== 'jfif'){
				array_push($errorsUpdNewsArr, "Invalid news image file type! Please try again!");
			}
		}
		
		//no errors
		if(count($errorsUpdNewsArr) == 0){
			$query = "UPDATE news SET news_title='$newsTitle', news_details='$newsDetails', news_category='$newsCategory', news_image='$newsImage' WHERE news_id='$newsID'";
			
			//Move uploaded image into a folder
			if(move_uploaded_file($_FILES['name']['tmp_name'], $targetImage)){
				$msg = "Image uploaded successfully!";
				}else{
				$msg = "Image uploaded unsuccessfully!";
			}
			
			$runQuery = mysqli_query($dbc, $query);
			
			if($runQuery){
				echo '<script> alert("Data updated!"); </script>';
				header('Location: /205CDE/Assignment/manageNews.php');
				}else{
				echo '<script> alert("Data not update yet!"); </script>';
			}
			}else{
			//display error message in alert
			foreach($errorsUpdNewsArr as $errorsUpdNewsMsg){
				echo '<script type="text/javascript">alert("'.$errorsUpdNewsMsg.'");</script>'; 
			}
			
			//redirect to manageNews.php
			echo '<script type="text/javascript">window.location.href = "/205CDE/Assignment/manageNews.php";</script>'; 
		}
	}
	mysqli_close($dbc);
?>
content_copy

#php

updateData.php 
<?php
	$dbc = mysqli_connect('localhost', 'root', '');	//connect database
	mysqli_select_db($dbc, 'news');	//select database
	
	$errorsUpdNewsArr = array();
	
	if(isset($_POST['updNewsData'])){
		$newsID = $_POST['update_id'];
		$newsTitle = $_POST['txtNewsTitle'];
		$newsDetails = $_POST['txtNewsDetails'];
		$newsCategory = $_POST['selectNewsCategory'];
		
		$targetImage = "/205CDE/Assignment/".basename($_FILES['uploadNewsImg']['name']);
		$newsImage = $_FILES['uploadNewsImg']['name'];
		$newsImageExt = pathinfo($newsImage, PATHINFO_EXTENSION);
		
		//ensure form fields are filled properly
		if(empty($newsTitle)){
			array_push($errorsUpdNewsArr, "News title is required! Please try again!");
		}
		if(empty($newsDetails)){
			array_push($errorsUpdNewsArr, "News details is required! Please try again!");
		}
		if($_FILES["uploadNewsImg"]["error"] == 4){
			//no upload image
			//uploading news image is not mandatory
		}else{
			//check uploaded image file type
			if($newsImageExt !== 'jpg' && $newsImageExt !== 'jpeg' && $newsImageExt !== 'png' && $newsImageExt !== 'jfif'){
				array_push($errorsUpdNewsArr, "Invalid news image file type! Please try again!");
			}
		}
		
		//no errors
		if(count($errorsUpdNewsArr) == 0){
			$query = "UPDATE news SET news_title='$newsTitle', news_details='$newsDetails', news_category='$newsCategory', news_image='$newsImage' WHERE news_id='$newsID'";
			
			//Move uploaded image into a folder
			if(move_uploaded_file($_FILES['name']['tmp_name'], $targetImage)){
				$msg = "Image uploaded successfully!";
				}else{
				$msg = "Image uploaded unsuccessfully!";
			}
			
			$runQuery = mysqli_query($dbc, $query);
			
			if($runQuery){
				echo '<script> alert("Data updated!"); </script>';
				header('Location: /205CDE/Assignment/manageNews.php');
				}else{
				echo '<script> alert("Data not update yet!"); </script>';
			}
			}else{
			//display error message in alert
			foreach($errorsUpdNewsArr as $errorsUpdNewsMsg){
				echo '<script type="text/javascript">alert("'.$errorsUpdNewsMsg.'");</script>'; 
			}
			
			//redirect to manageNews.php
			echo '<script type="text/javascript">window.location.href = "/205CDE/Assignment/manageNews.php";</script>'; 
		}
	}
	mysqli_close($dbc);
?>

Similiar Collections

Use of Dictionary in Python

@PinkGarden
How to print simple string

JQuery Quick Tips

 @frogblog
Change CSS Style of Element with jQuery

NPM packages

 @frogblog
Set up Cookies with express-session

Test

 @toast-ghost
Useful Git Commands - DEV Community

Clojure Functions

 @deku
Anonymous function syntax

jQuery Basics

 @deku
How to use switchClass and toggleClass in jQuery

Organizing Bookmarks

 @kodds88
python - Get "path" of parent keys and indices in dictionary of nested dictionaries and lists - Stack Overflow

Basic Python

 @kodds88
(Article) How to Read Common File Formats in Python - CSV, Excel, JSON (also Zip, Pickle, Glob)

Node Cookies

 @mishka
Memcached Cloud session store with express-session to preserve sessions off-server

Chrome Extension Snippets

 @faustj4r
Exclude and Include Matches for Content Scripts in Google Chrome

AJAX Calls

 @mishka
Vanilla Javascript - How to make an AJAX call without jQuery?

AJAX Calls

 @prince333
jQuery.post() - AJAX for post requests

Haskell

 @allenleein
* -> *

Python

 @Hitech
renameKeys in javascript

javascript

 @Hitech
renameKeys in javascript

Array Methods

 @Ulises Villa
Array.prototype.slice() - JavaScript | MDN Array.prototype.slice() - JavaScript | MDN

CSS

 @Ulises Villa
CSS Grid Layout - CSS: Cascading Style Sheets | MDN CSS Grid Layout

asd

 @sid
python - Get "path" of parent keys and indices in dictionary of nested dictionaries and lists - Stack Overflow

Test

 @frogblog
ios - Placeholder in UITextView - Stack Overflow css - How to override vuetify styles? - Stack Overflow

Array methods

 @UlisesVilla
Array.prototype.slice() - JavaScript | MDN Array.prototype.slice() - JavaScript | MDN Array.prototype.indexOf() - JavaScript | MDN Array.prototype.push() - JavaScript | MDN

C and C++

 @Paritosh
Implementation of linked list in C.

Chrome Extension

 @mishka
Preserve linebreaks/newlines in selected text in chrome.contextMenus Google Chrome Extension Numbers on the Icon - Stack Overflow

devops

 @moaaz
app.yaml config for enabling websocket gcp app engine flex

C# Reverse-Engineering

 @zcanann
Load DLLs in Target Process

Node Cookies

 @cboutens
How to Select Specific Elements with jQuery

Dynamics CRM Snippets

 @sabih53
Simple C# code to retrieve an Entity Record - Microsoft Dynamics CRM Forum Community Forum

30s

 @performmarketing
Dynamic shadow

Javascript Snippets

 @nikhil3790
Check if a substring exists in an array Javascript - Stack Overflow underscore groupby to group an array objects Get difference between 2 dates in JavaScript Add days to JavaScript Date format a JavaScript date (2019-02-12) How to merge two objects in JavaScript

PHP

 @Hamza
how to get first 10 images from google and display in my website using php

WooCommerce

 @performmarketing
Coupon to voucher Redirect the user back to the login page after the login failed

css

 @Hamza
second child element How to use numbers on icons with FontAwesome | Our Code World

Site Header

 @headcountguru
Makes year in copyrite day correct.

Problem

@performmarketing
opens/closes coupon field Redirect the user back to the login page after the login failed

Django

 @ferasbaig
TEMPLATE DOES NOT EXIST - Fixed Error: Django Handling Function-Based View and Requests

DNS - CLOUDFARE

 @kevin
Need help with Office 365 error - Getting Started - Cloudflare Community

Python

 @Amna
assignement Statements Py

bash

 @g
Archive all public repositories on my GitHub account

Elementor

 @performmarketing
Speed up Elementor sites by removing Font Awesome Redirect the user back to the login page after the login failed

PHP

@Dante Frank
Create a connection using MySQL With PHP | Code Wall How To Automatically Make A MySQL Input Form With PHP | Code Wall

OpenCV

 @biranchi125
Face Detection using OpenCV

Java Script

 @biranchi125
Removing duplicates from array of strings in JavaScript

FAQ

 @orbin
Zappos - FAQ Table FAQ Snippet / Question Section Zappos

Snippet

 @orbin
FAQ Snippet / Question Section Zappos

Objects

 @UlisesVilla
javascript - Convert Array to Object - Stack Overflow Javascript: Como ordenar un array de objetos por cualquier campo | comoprogramo

Js snippets

 @viceroyviki
Format currency single line file copy Calculating execution time in Javascript

CSS

 @_ferasbaig
Box-Shadow Reference

Linux/Bash

 @salitha.pathi
Find process location with port Folder size scan

JavaScript

 @ObiWanMaxim
Standalone UUID generator in Javascript HSVtoRGB Preloader How to delete all node_modules directories from your computer | CSS-Tricks

Bootstrap

 @_ferasbaig
Navbar: Bootstrap 4 Reference

Flutter

 @pratik.gtm
Real time database CRUD Firestore CRUD CRUD realtime database Home file Push Pop Sorting List of object All information about dart list: Stack SVG images in flutter Text and Images in side by side Mastering ListView Flutter Google SignIn Button:

AR

 @pratik.gtm
index.html

jquery

 @Hamza
javascript - jQuery load more data on scroll - Stack Overflow Jquery Gallery Image Search

JavaScript

 @Dante Frank
JavaScript Arrow Functions javascript - Fix the upstream dependency conflict installing NPM packages - Stack Overflow

MongoDB

 @salitha.pathi
How do I query referenced objects in MongoDB? - Stack Overflow Build indexes on MongoDB Find duplicates Drop mongodb profiler

OpenXML

 @ourexpertize
Retrieving Fields in Open XML WordprocessingML Documents | Eric White NuGet Gallery | DocumentFormat.OpenXml 2.11.0

File (I/O)

 @ourexpertize
c# get assembly executable directory - Stack Overflow

Dictionary

 @ourexpertize
How to initialize a dictionary with a collection initializer - C# Programming Guide | Microsoft Docs

Database

 @peota
php - Get MySQL database entries within last week - Stack Overflow

perl simple commands

 @dostein
perl push to array - Google Search

java

 @matanazani
הערכים הקיצוניים ביותר ההבדל בין += לבין =+הוא:

project

 @SwarleyBL
python - Custom loss in Keras - slow at compiling and fit - Stack Overflow

JavaScript

 @ZivE
JS Proxy Example Get readable format of the given number of milliseconds

Bootstrap 4

 @peota
html - Vertical Align Center in Bootstrap 4 - Stack Overflow

JavaScript

 @peota
javascript - Detect if a page has a vertical scrollbar? - Stack Overflow javascript - How to reload page every 5 seconds? - Stack Overflow

JS Event Listeners

 @mishka
Add event listener to multiple buttons with the same class

CSS

 @usama
Centering things on CSS Centering in CSS: A Complete Guide | CSS-Tricks

Javascript-Browser

 @mattbrown
jQuery Search Gallery

Home Assistant

@il90
Wireless LAN WPA/PSK

Python

 @PehShin
python - Count max consecutive recurring groups in a string - Stack Overflow

React Native Redux

 @imtiaz
React Native Installation

React

 @danish45007
Hooks at a Glance – React Hooks at a Glance – React

JAVA

 @WaqarAhmad
Single Function in Java to Check NULL value or object

ANGULAR

 @WaqarAhmad
Value change trigger in Angular

DynamoDB Boto-3

 @danish45007
DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation DynamoDB — Boto3 Docs 1.14.20 documentation

Vim

 @nolboo
Vim's Arglist as a File-Centric Todo List | Chris Toomey

css

 @afsheen
CSS Overflow

Regular Expressions

 @Winsley
Grab urls from sitemap

TCW Chrome Ext - outdated snippets

 @mishka
Preserve linebreaks/newlines in selected text in chrome.contextMenus

Py basics

 @phi
Importing CSV to Py and loading it into a list of lists Printing dict pairs sorted by key Split a dict to lists

Front End

 @Dante Frank
Bootstrap Fixed Floating Buttons

WPF

 @AsiBela
Generic c# - Raise an event whenever a property's value changed? - Stack Overflow

NodeJs

 @Dante Frank
javascript - Fix the upstream dependency conflict installing NPM packages - Stack Overflow Truncate: To reduce length of text Strip Tags

Redux

 @theo
Learn - Redux Forms Codealong

html

 @Kavi kumaran
JavaScript Form Validation

boss

 @theozzhh79
cli/cli: GitHub’s official command line tool cli/cli: GitHub’s official command line tool cli/cli: GitHub's officiële command line tool cli/cli: GitHub's officiële command line tool Simple3DGameDX: Fix failing C++/WinRT build. by sauparna · Pull Request #1276 · microsoft/Windows-universal-samples Windows 10 Optimization Guide – Chris Titus Tech Windows 10 Optimization Guide – Chris Titus Tech Go internal ABI specification

boss

 @theozzhh79
cli/cli: GitHub’s official command line tool cli/cli: GitHub’s official command line tool cli/cli: GitHub's officiële command line tool cli/cli: GitHub's officiële command line tool Simple3DGameDX: Fix failing C++/WinRT build. by sauparna · Pull Request #1276 · microsoft/Windows-universal-samples Windows 10 Optimization Guide – Chris Titus Tech Windows 10 Optimization Guide – Chris Titus Tech Go internal ABI specification

Data Cleaning

 @import_fola
Forward fills Column names SQL Select all columns with GROUP BY one column

ReactJs Features

 @keerthanenr
Send email with ReactJS and SendGrid? - Stack Overflow ReactJS - onSubmit Send email using Sendgrid or something similiar - Stack Overflow

PHP

 @peota
php - Search for a key in an array, recursively - Stack Overflow

React Native

 @rdemo
React Native backgroundColor overlay over image - Stack Overflow javascript - How to remove a item/index from a FlatList in react native? - Stack Overflow

pythoon

 @saching12
DFOV, HFOV, VFOV calculation Focal length from HFOV

Pandas

 @arielvol
Python strftime reference pandas.Period.strftime python - Formatting Quarter time in pandas columns - Stack Overflow python - Pandas: Change day - Stack Overflow python - Check if multiple columns exist in a df - Stack Overflow Pandas DataFrame apply() - sending arguments examples python - How to filter a dataframe of dates by a particular month/day? - Stack Overflow python - replace a value in the entire pandas data frame - Stack Overflow python - Replacing blank values (white space) with NaN in pandas - Stack Overflow python - get list from pandas dataframe column - Stack Overflow python - How to drop rows of Pandas DataFrame whose value in a certain column is NaN - Stack Overflow python - How to drop rows of Pandas DataFrame whose value in a certain column is NaN - Stack Overflow python - How to lowercase a pandas dataframe string column if it has missing values? - Stack Overflow How to Convert Integers to Strings in Pandas DataFrame - Data to Fish How to Convert Integers to Strings in Pandas DataFrame - Data to Fish create a dictionary of two pandas Dataframe columns? - Stack Overflow python - ValueError: No axis named node2 for object type <class 'pandas.core.frame.DataFrame'> - Stack Overflow Python Pandas iterate over rows and access column names - Stack Overflow python - Creating dataframe from a dictionary where entries have different lengths - Stack Overflow python - Deleting DataFrame row in Pandas based on column value - Stack Overflow python - How to check if a column exists in Pandas - Stack Overflow python - Import pandas dataframe column as string not int - Stack Overflow python - What is the most efficient way to create a dictionary of two pandas Dataframe columns? - Stack Overflow Python Loop through Excel sheets, place into one df - Stack Overflow python - How do I get the row count of a Pandas DataFrame? - Stack Overflow python - How to save a new sheet in an existing excel file, using Pandas? - Stack Overflow Python Loop through Excel sheets, place into one df - Stack Overflow How do I select a subset of a DataFrame? — pandas 1.2.4 documentation python - Delete column from pandas DataFrame - Stack Overflow python - Convert list of dictionaries to a pandas DataFrame - Stack Overflow How to Add or Insert Row to Pandas DataFrame? - Python Examples python - Check if a value exists in pandas dataframe index - Stack Overflow python - Set value for particular cell in pandas DataFrame using index - Stack Overflow python - Pandas Dataframe How to cut off float decimal points without rounding? - Stack Overflow python - Pandas: Change day - Stack Overflow python - Clean way to convert quarterly periods to datetime in pandas - Stack Overflow Pandas - Number of Months Between Two Dates - Stack Overflow python - MonthEnd object result in <11 * MonthEnds> instead of number - Stack Overflow python - Extracting the first day of month of a datetime type column in pandas - Stack Overflow

Mysql Eating Files

 @arunwebber@gmail.com
mysql - What are these files ,can I delete them manually? - Server Fault

GraphQL

 @arielvol
Calculate number of total sub elements for a DF id

Flutter Packages

 @teddyfeldmann
firebase_storage | Flutter Package

@InjectResources medium post

 @hosuaby
Load resource content with vanila Java Load resource content with Google Guava

Python 2.7 (Learnt)

 @PyPro101
Calculator For Best Shipping Option with Grounded Values

Powershell

 @Ohad
powershell - How to load a JSON file and convert it to an object of a specific type? - Stack Overflow

SQL

 @Ohad
SQL Server: Extract Table Meta-Data (description, fields and their data types) - Stack Overflow Rolling up multiple rows into a single row and column for SQL Server data SSRS Report Usage Queries

Work - python

 @SwarleyBL
print(_, end = ' ') python versions style

ServiceNow

 @nhord2007@yahoo.com
javascript - parse the request body for scripted rest api's How to identify a slow widget on a page - Support and Troubleshooting ServiceNow pretty print xml ServiceNow Client Script GlideOverlay: Open GlideOverlay Window to Submit or Update Another Record.js How to query RITM by Variable Value using a GlideRecord - Developer Community - Question - ServiceNow Community User Object Cheat Sheet - ServiceNow Guru How to Force a Cache Update for UI Scripts - Developer Community - Article - ServiceNow Community VIP Icon on Catalog Variable - Developer Community - Blog - ServiceNow Community prevent user accounts who may have itil or any other role that could access the sys_attachment table from utilizing "apis" to access those attachments Find duplicate user email (or anything else) - Blogs - Blog - ServiceNow Community O365 Service Alerts & the Service Status widget, and outages table etc - IT Service Management - Question - ServiceNow Community Inbound Email Action change - Impersonating Guest Account - Developer Community - Question - ServiceNow Community Accepting Scripted REST Connections for Weird Content-Types Search a value with incorrect spaces

Python

 @mzeid
Error Dissabling - Using Streamlit - Streamlit

Datetime

 @arielvol
Python datetime (With Examples)

Content Garden

 @oakfernsara
Document using lightbox and checkOff

links

 @le_wiseman
this code works website undraw

android Studio

 @mezati79@gmail.com
Fullscreen Activity in Android

My Listing

 @linister
ML: Hide featured badge on quick view Making Listings feed order by Priority and then Reviews Explore - Hide City areas Explore - side by side tags EXPLORE - HIDE LISTING TYPE DROPDOWN SINGLE LISTING - RE-ARRANGE LISTINGS COMPONENTS ON MOBILE Woocommerce - Logout message confirmation size change on my Account page Single listing - Quick actions design

WordPress

 @shm1ckle
Child Theme Functions.php Initialization Elementor Pagination WordPress 5.5 Fix Add GTM to WordPress Make Image Fill Column Height (Elementor) Add Sortable ACF Custom Field to Admin Column Image Stretch for Elementor Columns Disable Comments in WordPress Elementor Skip to Content Link Fix

@InjectResources for JUnit medium post

 @hosuaby
Add @InjectResource JUnit extensions with Gradle Add @InjectResource JUnit extensions with Maven Load text with JUnit 5 extension Load text with JUnit 4 extension Load binary with JUnit 5 extension Load binary with JUnit 4 extension Load properties with JUnit 5 extension Load properties with JUnit 4 extension Load JSON with JUnit 5 extension Load JSON with JUnit 4 extension Load YAML with JUnit 5 extension Load YAML with JUnit 4 extension

Google Ads Scripts

 @moakdesigns
Report Disapproved Ads Disapproved Ads Alerts Report Trending Search Terms ETA vs RSA Query Report Disapproved Extensions Report Script

Javascript

 @vrzi
How to store an array in localstorage js

Web

 @vrzi
loop in react jsx object.assign() How to store an array in localstorage js

General

 @Dante Frank
Pushing To An Existing Github Repo Pushing To An Existing Github Repo

GTM

 @KennethSangill
Random number from an interval

onePipe

 @Petersheg
OnePipe v1 - Documentation

Node.js

 @washfaq
Node.js While loop with Promise

MMT

 @mzeid
Sockeye

Tests

 @vrzi
Testing Asynchronous Code · Jest Testing Asynchronous Code · Jest

Java

 @vrzi
Difference between String literal and New String object in Java

Asyn-Await

 @darshjain
Examples of Async-Await

JS

 @jimmy.samaan
javascript - prevent touchstart when swiping / scrolling - Stack Overflow jQuery in Wordpress DIVI load script when divi edit mode not used

Roam JS

 @nolboo
Sort references - Roam JS Extensions

JavaScript

 @jaso110
JavaScript eksempel

function

 @sudhirsaharan
js

wow

 @gardezii
nice

html

 @rstringa
Image srcset Responsive Image - Picture Srcset Animaciones CSS a través del Scroll sin necesidad de JavaScript. 100% nativo Efecto sombra de imagen

CSS

 @rstringa
Responsive Typography in CSS | CodyHouse Break-Out Container -webkit-autofill Transicion de height 0 a auto CodePen Home Accordion - height "auto" with grid Animaciones CSS a través del Scroll sin necesidad de JavaScript. 100% nativo Fija el header y anima sus propiedades al hacer scroll. Card Hover 3d animation CSS color-mix Efecto sombra de imagen @starting-style / allow-discrete Form - User valid / invalid

Javascript/Jquery

 @rstringa
Show() - Display Flex Scroll Window to Bottom Javacript cambios varios de cursor - Performance snippet Slick Slider - Video Play slide activo Slide In (as you scroll down) Boxes | CSS-Tricks Scroll into a div with buttons Is in Viewport - Detecta si esta en pantalla Toggle between 2 clasess is in Viewport Detect CSS Transition END Connect to WooCommerce Rest API using Javascript – IT Creative Labs Close when click outside a container Leaflet.js la mejor alternativa gratuita a la API de Google Maps

WordPress

 @rstringa
Simple Taxonomy Query: Multiple Taxonomy Handling: Nested Taxonomy Handling: json - Consume WooCommerce REST API with JavaScript - Stack Overflow Defer Javascript in WordPress · GitHub Cómo agregar «async» o «defer» a los scripts en WordPress - Mauricio Gelves BF WPO Dequeuer – Plugin WordPress | WordPress.org España Share Post code Defer Javascript in WordPress · GitHub Contact Form 7 - API Contact Form 7 - React Component Cómo ver tu web saltándote la caché y optimizaciones de WP Rocket @ Ayuda WordPress

Math Problems

 @Adorism80
Iterative Approach to Solving Factorials

Data Structure Notes

 @Adorism80
Compare Ancestral Nodes Merge 2 Linked Lists (Ordered) In Place

GoodTimes

 @JOMOGO
Class BonRegel Class Reserveren Class Bon ApplicationDbContext Bestelling Categorie Menukaart Product

Promise JS

 @vishnu
Promisifying XMLHttpRequest - ECMAScript 6 Tutorial

Some collection

 @aparnaj
button

another collection

 @aparnaj
button

205CDE

 @uchenliew
Home.php Admin.php Import.html Header.html manageNews.php insertData.php footer.html aboutUs.php contactUs.php faqs.php Home.php manageNews.php news.php header.php newsList.php updateData.php updateData.php

SCSS

 @rstringa
Mixin for Aspect Ratio

SwiftUI

 @geoo993
SwiftUI LazyGrid

SYS ADMIN

 @bifrost
POWERSHELL ACTIVE DIRECTORY

REACTEUSE

 @bifrost
REACTEUSE Material UI style snippet GRID material ui MATERIAL UI _ custom style Absolute path variable .env retrieve data firestore React class based component save state locally REACT Extract State Logic to Redux Use Provider to Connect Redux to React Map State to Props Map Dispatch to Props Connect Redux to React Connect Redux to the Messages App Extract Local State into Redux base app React redux How To Build Forms in React | DigitalOcean forms class based component How to handle multiple input field in react form with a single function? - GeeksforGeeks Class based component fonctional forms Collecting data from a wizard form - Gosha Arinich How to create multi-step forms in React? - DEV React-admin - Admin and Resource Components React Color Gradients create react app build serv 21 Performance Optimization Techniques for React Apps Snazzy Maps - Free Styles for Google Maps get value from localstorage react Code Example Local storage portfolio - EmailJS Material UI | Formik | Formik react-spring Shake - React Reveal React Anime Themes – ApexCharts.js React Router: Declarative Routing for React.js React Hook Form Production-Ready Animation Library for React | Framer Motion Production-Ready Animation Library for React | Framer Motion Toast notifications PWA Manifest Generator | SimiCart Axios interceptor

javascript only

 @rstringa
is in Viewport Detect CSS Transition END RapidAPi Json Target a un boton y sus elementos internos Detecta un parametro de la url CodePen Home Change sticky nav on scroll matchMedia : La Api de media query

GIT

 @bifrost
CREATE GIT PROJECT

vps useful-code

 @natsumi88
centos查看硬件信息 查看centos硬件配置 CentOS 7查看网络带宽使用情况 Linux查看网络流量 Clear disk space on CentOS/RHEL 6, 7, 8 [Linux] vnStat 網路流量監控工具使用教學 如何查詢 Linux 的版本，及分辨Desktop、Server版本 [Linux] netstat 查看網路狀態，指令範例教學

Rclone

 @natsumi88
如何使用rclone同步远程云盘 Rclone日志记录 常用的 rclone 命令 Rclone 实时传输进度 Set to allow files which return cannotDownloadAbusiveFile to be downloaded.

CSS

 @bifrost
custom scrollbar WhatTheFont! « MyFonts Vertical carousel with TweenMax.js Material Design for Bootstrap 5 Card hover shadow effect border radius 10 Super-Useful Bootstrap 4 Code Snippets Bootstrap Snippets Library Red Gradient: +55 Background Gradient Colors with CSS Nulled Scripts - Nulled Scripts | Free Downloads Wordpress Theme Meta Tags — Preview, Edit and Generate colors palette React Color Gradients Animated Tab Bar

python

 @mzeid
Removing Punctuation · Issue #80 · mammothb/symspellpy

JavaScript Dates

 @robertjbass
JavaScript Dates Vue Date Filter Vue Date Filter (starter) Vue Date Filter (starter) Full date breakdown (as immediately invoked function)

Slick Slider

 @rstringa
Slick Slider - Video Play slide activo

Linux

 @eneki
Which Command Vagrant boxes installed No Brew command works on new Mac (Catalina) Display ubuntu version Composer memory error Troubleshooting - Composer SSH folder and file permissions

PHP

 @eneki
Spin up a local PHP server To check which server host under which the current script is executing Attach zip to email (pwd protection available in ˆ7.2) macos - How can I easily switch between PHP versions on Mac OSX? - Stack Overflow

SIMPLE PAGE'S

 @sanyali
LOGIN FORM

Laravel

 @eneki
How to fix “Error: Node Sass does not yet support your current environment: OS X 64-bit with Unsupported runtime (57)” Laravel Passport Key path oauth-public.key does not exist or is not readable Returns a nested object in How to set up Task Scheduling with Cron job in Laravel - TutsForWeb Pass the search parameters into a request that has set of filter parameters Setting up Vue in Laravel 8 - DEV Attach zip to email (pwd protection available in ˆ7.2) Conditional command to run every 2 weeks Could not delete kylekatarnls/update-helper/src/UpdateHelper Multi-select using Laravel Collective Save File With Exact Name and Retrieve Directly relation - Laravel Grouping by Eloquent Relationship - Stack Overflow Ignore Space in Table Column When Searching For A Match Laravel collective how to set Form::date default value php - Laravel password validation rule before Laravel 8 mysql - Laravel : How do I securely seed the first user How to remove parameters from url

Node.js

 @eneki
Avoid requiring sudo for n and npm global installs How do I check if an address is already in use Mac? javascript - stop all instances of node.js server - Stack Overflow

Settings and Config

 @robertjbass
Config, Compile and Run TypeScript with Concurrently, Nodemon, & Express

Recogido por ahí

 @mferreiro
Configurar graphql en express Ejecutar una tarea cuando un archivo cambia

Onsurity

 @danish45007
Billing query

SAP b1 SDK

 @mferreiro
obtener el ultimo DocEntry creado

Поиск Яндекс

 @Vozro
Код результатов поиска

Javascript

 @snigdhakhurana10
Promises typeof Array and Object reduce() call and bind sum(1)(2)(3)(4)..( n)() Prototypal Inheritance

Hana

 @mferreiro
Describe columnas de una tabla en hana

Docker

 @Bujhm
rsync через docker'овский тоннель zircote/swagger-php: A php swagger annotation and parsing library

ARDUINO

 @bifrost
CONNECT TO ESP firebase basics

vk-php-sdk

 @Vozro
Installation/ Initialization Also you can initialize VKApiClient with different API version and different language like this: Also you can initialize VKApiClient with different API version and different language like this: Authorization Code Flow For getting user access key use following command:

React

 @papiproud
A correct way to log the current state after the update would be: reactjs - TypeScript and React - children type? - Stack Overflow reactjs+-+TypeScript+and+React+-+children+type?+-+Stack+Overflow

JavaScript

 @eneki
How to sort an array numerically in JavaScript | by Dr. Derek Austin 🥳 | Coding at Dawn | Medium Might be the thing that allows maps to work without an API key Pass the search parameters into a request that has set of filter parameters Redirects the page to a desired url on click Call something when the entire page has loaded Promise resolution with interval (jquery + iife) Promise resolution where function is returned outside (jquery) Add English Ordinal Suffices Return the short month name Convert number (r) to a specific local with a minimum number of digits Async testing with Jest Print page CSS To set and unset the mat-select value programatically To set and unset the mat-select value programatically To set and unset the mat-select value programatically Display Router Link How do I check if an address is already in use Mac? Avoiding CORS Errors on Localhost (in 2020) | by Andy Potts | The Startup | Medium

General

 @saisandeepvaddi
lookaround - Regex lookahead, lookbehind and atomic groups - Stack Overflow

Pandas

 @ianh
Pandas Grouper How to reorder columns in a Pandas DataFrame in Python How to find Percentage Change in pandas columns Pandas data frame filter column names regex Pandas filter dataframe columns Filter column using isin Pandas f string format Drop columns whose name contains a specific string from pandas DataFrame Drop rows from pandas data frame that contains a particular string in a particular column Convert Excel Days Date to real date Pandas Flatten a list of lists to a single list Append DataFrame in Pandas Show all columns of Pandas DataFrame Group by on a mapped dataframe index List comparison

Webscrape

 @ianh
Extract attribute from tag using BeautifulSoup Parse a website using Selenium and Beautifulsoup Scrapy Commands

Regex

 @ianh
Remove punctuation from text Pandas data frame filter column names regex Regex how to extract a floating number from a string

reg

 @ianh
Using regex to find string in soup

JavaScript

 @aymanelya
Scroll to the top of the page Check Device type (Mobile/Desktop) Get the current URL FormData to Object Send a GET Request Send a POST Request Send a POST Request Get a random boolean (true/false) Check if the provided day is a weekday Reverse a string Check if the current tab is in view / focus Check if a number is even or odd Get the time from a date Truncate a number to a fixed decimal point Check if an element is currently in focus Check if the current user is on an Apple device Scroll to top of the page Get average value of arguments Convert Fahrenheit / Celsius

Testing

 @sharmanilay
Examples · Testing Library

chrome dos

 @manic
javascript - Chrome userscript fires on all pages despite @match and @include settings - Stack Overflow

CSS

 @Bujhm
Writing even more CSS with Accessibility in Mind, Part 1: Progressive Enhancement - Manuel Matuzović html - How to make vertical lines between list items using CSS? - Stack Overflow

swagger

 @duc.pt172483@gmail.com
swagger-jsdoc/GETTING-STARTED.md at master · Surnet/swagger-jsdoc swagger-jsdoc/GETTING-STARTED.md at master · Surnet/swagger-jsdoc swagger-jsdoc/GETTING-STARTED.md at master · Surnet/swagger-jsdoc swagger-ui-express - npm

React Hooks

 @Tony Dung
Remote Table Hook

Eslint + Prettier

 @titusdecali
.Prettierrc default Vue config Eslint default Vue config

Data Wrangling

 @axatjpr
python - Remove row with null value from pandas data frame - Stack Overflow

DS

 @nickarocho
Validates an object passed as a prop compared to "required" array

react hooks

 @raulingg
useDeviceDetect Hook

Jupyter Notebooks

 @jpiedragil
Multiple Cell Outputs in Jupyter Notebooks Listing Out All Variables in a Jupyter Notebook High-Resolution Plots in Jupyter Notebooks

Pyhon

 @ak1957
Basic Flask App Virtual enviornment

Java

 @aziz.articles@gmail.com
GitHub - qaware/xsd2java-gradle-plugin: The XSD2Java Gradle Plugin generates java classes from an existing XSD schema.

Docker

 @aziz.articles@gmail.com
Docker Deep Drive Book

Javascript

 @gerardolgvr0310
Javascipt reduce (Objects)

Javascript

 @julien
onload - js event - body event - event Element.insertAdjacentElement() - beforebegin - afterend - beforeend - afterbegin - insert node element Create HTML using JavaScript Adding HTML to the page - append insertAdjacentHTML - DOM - Insert HTML - Add html tag JavaScript Fetch API - Ajax - Request JavaScript Fetch API - Async Await - Ajax JavaScript Essentials - Types - Tests - Vars - Variables - Loops - data structures - function - operators - conditionals Scroll - to - Top Button with Vanilla JS - Detecting the scroll position ES6 snippet - JavaScript - scroll snippet - window ES6 snippet - JavaScript - scroll to top snippet - window - scrolltotop btn ES6 snippet - JavaScript - Detect device type ES6 snippet - JavaScript - GET parameters - GET URL parameters ES6 snippet - JavaScript - Copy to clipboard - Copy string Promise - Async/Await - Ajax - Request Javascript design patterns - Constructor pattern - Object - POO Javascript design patterns - Prototype pattern - Object - POO Javascript design patterns - Singleton pattern - Object - POO Javascript design patterns - Module pattern - Object - POO 10 JavaScript Hacks Every Web Developer Should Know

Python

 @adeinbd
Pandas show all rows and columns

JavaScript

 @
findLastIndex

sass

 @abeerIbrahim
sass loop flip bg print media

python

 @ButY
Merging Two Dictionaries Inverting a Dictionary Performing a Reverse Dictionary Lookup Printing on the Same Line

Components

 @Krumil
Select for custom taxonomy

Droplist 22nd October 20 - Week 9 - Supreme Community

 @seriousplofff11@gmail.com
Droplist+22nd+October+20+-+Week+9+-+Supreme+Community

React

 @devandapaige
Axios Cheat Sheet - Kapeli Check The Password Confirmation With Yup - Today I Learned

CSS

 @devandapaige
Touch of Shade on a Div

Third-Party Api's

 @jlang
fetch mdn fetch example location documentation simple html setup for search with third-party api js for simple third-party api search good example for button click handler js code for getting results from fetch and parsing to display results w/ links.

general javascript

 @jlang
good example for button click handler passes some input to the fetch api. javascript for grabbing attribute from element/use in planner app js code for getting results from fetch and parsing to display results w/ links.

CSS

 @Carouan
CSS - Before

CSS

 @Bujhm
html - How to make vertical lines between list items using CSS? - Stack Overflow

GIT

 @ianh
GIT commands GIT Commands from git --help

Svelte

 @meisernator
svelte-toggle@1.0.0 • REPL • Svelte Markdown Editor • REPL • Svelte

ffmpeg

 @melihyayliregister@yahoo.com
ffmpeg command breakdown Disclaimer + resize video + logo

mySQL common

 @alex.balaboshko
MySQL create user MySQL set DB collation

Glob

 @ianh
Find the latest file in folder

Browser / Console

 @meisernator
What is the easiest way to copy the contents of a drop-down list from a website? - Quora

React

 @aziz.articles@gmail.com
Creating a Production Build | Create React App

Vue Snippets

 @robertjbass
Delete db from server item with dynamic HTML without data-tables Sorting by Value in Array of Objects (List Item Value) - Sort by date Vue Date Filter Vue Date Filter (starter) Vue Date Filter (starter) Checkboxes (Custom / VueJS - HTML ) Test input for number [VueJS]

Javascript

 @Bujhm
javascript - How can I get all a form's values that would be submitted without submitting - Stack Overflow

PHP

 @richard
syntax - What Does This Mean in PHP -> or => - Stack Overflow Drupal 8 Entity API cheat sheet Nginx / Valet - 502 Bad Gateway - upstream sent too big header · Issue #890 · laravel/valet php - How to downgrade or install a specific version of Composer on Windows? - Stack Overflow WordPress get_template_part pass variable - Stack Overflow Programatically create taxonomy terms How to update custom taxonomy meta using ACF update_field() function or any other wordpress function - WordPress Development Stack Exchange html - How To Check Whether A URL Is External URL or Internal URL With PHP? - Stack Overflow

Drupal

 @richard
Drupal 8 Entity API cheat sheet Nginx / Valet - 502 Bad Gateway - upstream sent too big header · Issue #890 · laravel/valet drush - How I change my Site URI in Drupal 8 - Drupal Answers

c++ loops

 @mahmoud hussein
(Occurrence of max numbers) Write a program that reads integers, finds the largest of them, and counts its occurrences. Assume that the input ends with number 0. Suppose that you entered 3 5 2 5 5 5 0; the program finds that the largest is 5 and the occurrence count for 5 is 4 (Fibonacci Series) The Fibonacci series is a series that begins with 0 and 1 and has the property that each succeeding term is the sum of the two preceding terms. For example, the third Fibonacci number is 1 which is sum of 0 and 1. The next is 2, which is a sum of 1 + 1. Write a program that displays the first ten numbers in a Fibonacci series **5.21 (Display numbers in a pyramid pattern) Write a nested for loop that prints the following output: (Compute the greatest common divisor) Another solution for Listing 5.10 to find the greatest common divisor (GCD) of two integers n1 and n2 is as follows: First find d to be the minimum of n1 and n2, then check whether d, d-1, d-2, . . . , 2, or 1 is a divisor for both n1 and n2 in this order. The first such common divisor is the greatest common divisor for n1 and n2. Write a program that prompts the user to enter two positive integers and displays the GCD. sorting

c++ functions

 @mahmoud hussein
: Converting Decimals to Hexadecimals,” gives a program that converts a decimal to a hexadecimal. How do you convert a hex number into a decimal? (Financial application: find the profit-per-item) Use the scheme in programming Exercise 5.39 to write a function that computes the profit-per-item. The header of the function is: double computeProfitPerItem(double quantity) Write a test program that displays the following table: find LCM check whether the reversed integer is also an Armstrong number (Even Palindrome number) Write a program that displays the first 100 emirps Write a program that finds the first 25 additive prime numbers and displays the output in the following format: (Math: approximate the square root) (Average of even places)Write a function that returns the average of the digits in the even places in an integer using the following header: double avgOfEvenPlaces(int n) (Current date and time) Invoking time(0) returns the elapse time in milliseconds since midnight January 1, 1970. Write a program that displays the date and time. Here is a sample run: Write a test program that prompts the user to enter a number and its width and displays a string returned by invoking format(number, width). octal to decimal binary to octal Write the following function to check whether string s1 is a substring of string s2.

js

 @ali_alaraby
sort array javascript - Google Search get list of unique items from a list of objects with duplicate objects get list of only duplicates from a list of objects with duplicate objects date - setting day of week in javascript - Stack Overflow find the largest number in a JavaScript array? - Stack Overflow Get the First and Last Day of a Given Month using JavaScript capitalize string javascript - Google Search add property to each object in array javascript using ".map()" Code Example sort array by date typescript - Google Search return 2 objects from function typescript Code Example javascript - How to check whether an object is a date? - Stack Overflow Javascript code for showing yesterday's date and todays date - Stack Overflow javascript - Check variable equality against a list of values - Stack Overflow javascript - Merge 2 arrays of objects - Stack Overflow How to Access Your Linux (WSL) Files in Windows 10 performance - How to efficiently count the number of keys/properties of an object in JavaScript - Stack Overflow How to get the difference between two arrays of objects in JavaScript - Stack Overflow Sorting List of objects alphab. ASC

angular

 @ali_alaraby
set default img src in case src error show div content on hover angular - Google Search javascript - How to loop over object properties with ngFor in Angular - Stack Overflow

HTML

 @samoisamoi12
html textbox mysqli - chequear conexión border-radius orden tamaños % relativos html - css

PHP

 @samoisamoi12
mysqli - chequear conexión Chequear cookies

Terminal

 @richard
brew cleanup: Error: Permission denied @ apply2files · Issue #45009 · Homebrew/homebrew-core · GitHub macos - Uninstall all programs installed by Homebrew - Ask Different php - Uninstall Laravel Valet - Stack Overflow macos - Uninstall all programs installed by Homebrew - Ask Different php - How to install old version of composer - Stack Overflow Nginx / Valet - 502 Bad Gateway - upstream sent too big header · Issue #890 · laravel/valet php - Laravel Valet logs - Stack Overflow php - How to downgrade or install a specific version of Composer on Windows? - Stack Overflow How do I configure iTerm2 to open URLs in a specific browser? - Stack Overflow

dax

 @nikahafiz
Showing DAX Expressions When Using Power BI Datasets DAX | Calculate Revenue Across Multiple Years DAX | Lookup Value from Rows in Unrelated Tables DAX | Creating Calendar Table Using CALENDARAUTO DAX | Quarter No - 1 DAX | Week Start Date - 1 (Week Begins on Monday) DAX | Week End Date DAX | Week Ranking DAX | Week No - 1 DAX | Day Name DAX | Day of Week No DAX | Day of Month No DAX | Year + WeekNo DAX | Quarter No - 2 DAX | Best Selling Day/Date - 1 DAX | Best Selling Product DAX | Best Selling Day/Date - 2 DAX | Create Table - 2 DAX | Create Table - 1 DAX | Rank Sales Rep based on Total Sales DAX | Previous Day (PD) Calc DAX | Day-on-Day (DoD) Calc DAX | Day-on-Day % (DoD%) Calc DAX | Current Week (CW) Calc DAX | Previous Week (PW) Calc - 1 (taking into consideration year crossover) DAX | Week-on-Week (WoW) Calc DAX | Week-on-Week % (WoW%) Calc DAX | Week-to-Date (WTD) - 1 DAX | Week Start Date - 2 (Week Begins on Monday) DAX | Week End Date (Week Begins on Monday) DAX | Week No - 2 DAX | Week Day (Week Begins on Monday) DAX | Previous Week (PW) Calc - 2 DAX | Week-to-Date (WTD) - 2 DAX | Last Week-to-Date (LWTD) - 1 DAX | Last Week-to-Date (LWTD) - 2 DAX | Same Period Last Year Calc - 1 DAX | Same Period Last Year Calc - 2 DAX | Sales % Based on Selected Item/Brand

SQL SERVER

 @fadas
Crear indice Agregar o quitar tiempo datatime Cómo obtener la primera y la última fila

NodeJS References

 @robertjbass
Config, Compile and Run TypeScript with Concurrently, Nodemon, & Express Express Routing

Data Structures

 @snigdhakhurana10
Factorial Fibonacci Series Prime Numbers Till n Pallindrome String Pallindrome Number Square Root of a Number Perfect Square Check if a large number is divisible by 8

GoLang

 @robertjbass
Golang http GET request Go - Hello World

PHPUnit

 @Bujhm
Пишемо Unit-тести на PHP: путівник PHPUnit та поради з досвіду | DOU

HTML

 @jpannu
//Hover Text DOM elements , Idea is to DRY.

CSS

 @jpannu
Responsive animation. Hover effect ( brightness ) Pushing the button in 3D way. Center the element Adding background Image , Adding Layer. Grid SASS - Syntactically Awesome Style Sheet SASS - Syntactically Awesome Style Sheet CSS notes : General

Javascript

 @jpannu
Sharing data from API to Social media ( twitter and facebook ) on load , will be loaded after loading the imgElement. Swapping numbers without using temp Variable. ( Destructuring assignment ) TeamTreeHouse : Js Full stack.

TypeScript

 @robertjbass
Parcel Bundler: 🚀 Getting Started Google Maps 50% Probability with JS/TS (m/f example) Config, Compile and Run TypeScript with Concurrently, Nodemon, & Express TypeScript Bubble Sort and Classes

Google Maps

 @robertjbass
Google Maps

angular

 @abeerIbrahim
using *ngIf *ngFor getting active router

BASH

 @robertjbass
BASH Move Document Config, Compile and Run TypeScript with Concurrently, Nodemon, & Express Firebase Cloud Functions ENV_VARS

CSS

 @TheFirstFace
Translate on hover

java project

 @Muhammadcodes
Generating random integers over a specific range using java Drawing shapes using java for loops - Stack Overflow

SPARK

 @riseandburn
Slide References

API

 @jpannu
jQuery : Personal Notes

HTML

 @TheFirstFace
My attribution

Building VS Code Extension

 @mishka
Creating and publishing VS Code extensions | by christoffer noring | ITNEXT Command to open a webview in Visual Studio Code Extension Get Webview Content with URI | Visual Studio Extension Building

Files & Folder matching with RegeX

 @arielvol
10.8. fnmatch — Unix filename pattern matching — Python 2.7.18 documentation

vnc

 @Bujhm
Browser Testing - CircleCI

c#

 @BrendY99
"*" pattern C#

WordPress

 @richard
Query posts via Taxonomy field - ACF Support WordPress get_template_part pass variable - Stack Overflow Placing a Custom Post Type Menu Above the Posts Menu Using menu_position? - WordPress Development Stack Exchange How To Disable (or Remove) "All Posts, Published, and Trash" in Dashboard Posts - WordPress Development Stack Exchange Programatically create taxonomy terms How to update custom taxonomy meta using ACF update_field() function or any other wordpress function - WordPress Development Stack Exchange How to disable the single view for a custom post type? - WordPress Development Stack Exchange

Javascript

 @mvieira
Prevent duplicate values to be added to an array. Loop over an Array try-catch? | Node.js String.prototype.includes() JavaScript forEach – How to Loop Through an Array in JS JavaScript forEach 2 – How to Loop Through an Array in JS Request API Data with JavaScript or PHP (Access a Json data with PHP API) Object.prototype.hasOwnProperty() - JavaScript | MDN pm2 restart after a specific amount of time javascript - auto refresh for every 5 mins - Stack Overflow

NodeJS

 @mvieira
try-catch? | Node.js SET INTERVAL iterate over a JSON array in Node.js Scheduling: setTimeout and setInterval PM2 - Restart Strategies ( restart after crash ) PM2 - Restart Strategies ( restart on crash ) How to create an http server with Express in Node.js

mongoDB

 @ali_alaraby
export, import all collections in mongodb shell - Google Search MongoDB comparing dates only without times - Stack Overflow Automatically remove referencing objects on deletion in MongoDB access findOne promise (_doc) properties in mongoose Query mongodb to return documents created today - Stack Overflow Append text to existing value adding days to existing date property mongodb Get specific array element based on condition and only get this element not the whole document - mongoDB.

SQL

 @mvieira
MySQL MULTIPLES INNER JOIN How to Use EXISTS, UNIQUE, DISTINCT, and OVERLAPS in SQL Statements - dummies postgresql - SQL OVERLAPS PostgreSQL Joins: Inner, Outer, Left, Right, Natural with Examples PostgreSQL Joins: A Visual Explanation of PostgreSQL Joins PL/pgSQL Variables ( Format Dates ) The Ultimate Guide to PostgreSQL Date By Examples Data Type Formatting Functions PostgreSQL - How to calculate difference between two timestamps? | TablePlus Date/Time Functions and Operators PostgreSQL - DATEDIFF - Datetime Difference in Seconds, Days, Months, Weeks etc - SQLines CASE Statements in PostgreSQL - DataCamp SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN PostgreSQL DESCRIBE TABLE Quick and best way to Compare Two Tables in SQL - DWgeek.com sql - Best way to select random rows PostgreSQL - Stack Overflow PostgreSQL: Documentation: 13: 70.1. Row Estimation Examples Faster PostgreSQL Counting How to Add a Default Value to a Column in PostgreSQL - PopSQL How to Add a Default Value to a Column in PostgreSQL - PopSQL SQL Subquery - Dofactory SQL IN - SQL NOT IN - JournalDev DROP FUNCTION (Transact-SQL) - SQL Server | Microsoft Docs SQL : Multiple Row and Column Subqueries - w3resource PostgreSQL: Documentation: 9.5: CREATE FUNCTION PostgreSQL CREATE FUNCTION By Practical Examples datetime - PHP Sort a multidimensional array by element containing date - Stack Overflow database - Oracle order NULL LAST by default - Stack Overflow PostgreSQL: Documentation: 9.5: Modifying Tables PostgreSQL: Documentation: 14: SELECT postgresql - sql ORDER BY multiple values in specific order? - Stack Overflow How do I get the current unix timestamp from PostgreSQL? - Database Administrators Stack Exchange SQL MAX() with HAVING, WHERE, IN - w3resource linux - Which version of PostgreSQL am I running? - Stack Overflow Copying Data Between Tables in a Postgres Database php - How to remove all numbers from string? - Stack Overflow sql - How to get a list column names and datatypes of a table in PostgreSQL? - Stack Overflow postgresql - How do I remove all spaces from a field in a Postgres database in an update query? - Stack Overflow sql - How to get a list column names and datatypes of a table in PostgreSQL? - Stack Overflow How to change PRIMARY KEY of an existing PostgreSQL table? · GitHub Drop tables w Dependency Tracking ( constraints ) Import CSV File Into PosgreSQL Table How To Import a CSV into a PostgreSQL Database How can I drop all the tables in a PostgreSQL database? - Stack Overflow How can I drop all the tables in a PostgreSQL database? - Stack Overflow PostgreSQL CASE Statements & Examples using WHEN-THEN, if-else and switch | DataCamp PostgreSQL LEFT: Get First N Characters in a String How can I drop all the tables in a PostgreSQL database? - Stack Overflow How can I drop all the tables in a PostgreSQL database? - Stack Overflow PostgreSQL - Copy Table - GeeksforGeeks PostgreSQL BETWEEN Query with Example sql - Postgres Query: finding values that are not numbers - Stack Overflow PostgreSQL UPDATE Join with A Practical Example

JS

 @bifrost
JsConfig axios get request particles.js - A lightweight JavaScript library for creating particles Animated Tab Bar 3D Pokedex - Open it! Snazzy Maps - Free Styles for Google Maps Send Email using EmailJS and React form | by eesh tyagi | Medium Axios interceptor

HTML

 @luqmanmiraj42@gmail.com
htmlprefix

typescript

 @ali_alaraby
sort array by date typescript - Google Search

Git

 @ali_alaraby
Understanding Branches in Git (why master and development....) version control - How do I discard unstaged changes in Git? - Stack Overflow file not ignored after being added to gitignore Git refusing to merge unrelated histories on rebase - Stack Overflow How to Delete a Git Branch Both Locally and Remotely

C#

 @bifrost
suite fibonacci C# Monitor And Lock In C

Data Science

 @gfairhurst
Python virtualenv

Firebase

 @robertjbass
Firebase Cloud Functions ENV_VARS

c++ arrays

 @mahmoud hussein
pulling 4 random cards from a deck (Count the number of Vowels and Consonants) (Count occurrence of numbers) Write a program that reads at most 100 integers between 1 and 100 and counts the occurrence of each number. Assume the input ends with 0. Here is a sample run of the program: (Game: Eight Queens) 8 (Partition of a list) CheckSudokuSolution sorting td arrays (Financial application: compute tax) **8.11 (Game: nine heads and tails) (Pattern recognition: consecutive four equal numbers) Write the following function that tests whether a two-dimensional array has four consecutive numbers of the same value, either horizontally, vertically, or diagonally. (Game: connect four) Connect four is a two-player board game in which the players alternately drop colored disks into a seven-column, six-row verticallysuspended grid (Game: connect four) Connect four is a two-player board game in which the players alternately drop colored disks into a seven-column, six-row verticallysuspended grid

LARAVEL

 @fadas
cARBON FORMATO CALCULOS Save validando con where Codigo de Barras Laravel Barcode generation tutorial | Laravel Article Laravel :: Roles y Permisos Envio de mail con archivo adjunto - Laravel - Stack Overflow en español

Bubble Sort

 @robertjbass
TypeScript Bubble Sort and Classes

Golang

 @robertjbass
Golang - Why does vscode delete golang source on save - Stack Overflow

JavaScript

 @robertjbass
Express Routing Find which single item is missing from an array (comparing 2 arrays) Sorting by Value in Array of Objects (List Item Value) - Sort by date Checkboxes (Custom / VueJS - HTML ) Pick male or female emoji with 50% RNG

jquery

 @eneki
Hint to return first td in first tr in tbody of a table

PHP

 @rstringa
var_dump Console log para PHP Defer Javascript in WordPress · GitHub

Cereal

 @tubagus.dat@gmail.com
Load Dataset

JavaScript

 @digitalverve
Add target

ES6

 @jpannu
Swapping numbers without using temp Variable. ( Destructuring assignment )

Simple

 @VictorDronov
Simple Map for an array

Webpages

 @VictorDronov
The Fight Within Conference 2020. • The Armor Of God.

Unity

 @Butters1143
EnemySpawner.cs ShootingController_CodeProjectDay17

tahák

 @Elda
Ukázka použití zpětných uvozovek Ukázka použití zpětných uvozovek Szidon.com - Javascript ES6 tahák Szidon.com - Javascript ES6 tahák

Javascript

 @goranbloncar
JS try-catch-finally

AWS

 @goranbloncar
ssh httpd route53

Css

 @goranbloncar
transition Animation animation

FileMaker Calculations

 @Loggix
While function

SQL (Node)

 @robertjbass
javascript - Import sql file in node.js and execute against PostgreSQL - Stack Overflow

Probability

 @Adorism80
Poisson Distribution Combinations

SQL

 @rtsdeveloper
Formatting T-SQL Scripts using ScriptDOM and PowerShell – SQLServerCentral

PowerShell

 @rtsdeveloper
Formatting T-SQL Scripts using ScriptDOM and PowerShell – SQLServerCentral

CKAD

 @ankity09
Finding Object Information Imperative Approach Hybrid Approach EDITING A LIVE OBJECT Dockerfile for Java application Build Dockerfile Run Docker Container Create Pod from Command Line Yaml definition for pod describes pod Accessing Logs of a Pod Executing a Command in Container Declaring Environment Variables Defining a Command with Arguments Quick Delete pod Simple container with env variables Pod with command running in it

Siemens

 @MathLaci08
Give Docker the access to display (XServer?) Export the virtual environment to a yml file Set up logging parameters Rename conda environment

Linux (Ubuntu) Terminal Codes

 @NikhilPanbude
OpenFOAM - To edit Bashrc for OF

OpenFOAM Codes

 @NikhilPanbude
OpenFOAM Codes GNU Plot of residuals

JS

 @walsingham
SrcShare - Easily Share Code SrcShare - Easily Share Code

spring aspects

 @edwgarci
java - How to test Aspect in Spring MVC application - Stack Overflow

mockito

 @edwgarci
Mockito can mock static methods! · Andrei Solntsev

laravel

 @creature93x
Database: Migrations - Laravel - The PHP Framework For Web Artisans

CodeGolf

 @meisernator
https://adventofcode.com/2020/day/1/input

Recursive

 @mvieira
How Recursion Works — Explained with Flowcharts and a Video javascript - Creation of a multi-level JSON string - Stack Overflow PHP Master | Understanding Recursion Recursive loop to create a family tree? (PHP/MySQL/HTML) - Stack Overflow PHP Recursive Multidimensional Array to HTML nested code - PHP - SitePoint Forums | Web Development & Design Community PHP Recursive Functions: How to Write Them, and Why They're Useful arrays - php recursive function for genealogical tree - Stack Overflow How to get closest date compared to an array of dates in PHP PHP: How to check which item in an array is closest to a given number? - Stack Overflow

Backoffice

 @semih2177
How To Upload a File With Angular 6/7 Tutorial

xx

 @Nixie
sdsd

xx

 @Nixie
sdsd

Linux

 @derstefan
command+line+-+How+can+I+save+the+output+of+DIG+in+CSV+format?+-+Ask+Ubuntu

Unity Code

 @Sarvar
Explosion Damage (Radius);

JavaFX

 @jasoncriss
How to add a mouse doubleclick event listener to the cells of a ListView in javafx? - Stack Overflow java - How to animate LinearGradient on JavaFX? - Stack Overflow java - How to create filling animation in JavaFX(pixel by pixel) canvas? - Stack Overflow

JAVA

 @jasoncriss
How to open the default webbrowser using java - Stack Overflow

Ruby Review 12.03.2020

 @theo
splits and counts sentences even if there is punctuation like "!!!" and "....."

Linux

 @Campbell
Export a PostgreSQL Table to a CSV File

express

 @jlang
week11_dynamic request response week 11 - route methods week 11 - express routes week11_http methods week11_heroku node deployment

DynamoDB

 @thecalebf
Create DynamoDB Table View DynamoDB Table

CSS

 @Mindum
Shadow Overlay Burger Menu Overlay Navbar Pop in CSS Border Arrow

JavaScript

 @Mindum
Smooth Scrolling jQuery

Python

 @aymanelya
Writing JSON to a File Reading JSON from a File

Alpaca API + Websockets

 @sam
Import Libraries for Alpaca API, Step 1 Open Websocket and Subscribe to Stream, Step 2 Open Websocket and Subscribe to Stream, Step 2 Parent function for Creating Websocket, and Listener Setup

Gatsby

 @goranbloncar
gatsby-image

CSS

 @tiffanyjensen
Flexbox

Modern HTML/CSS/Sass. - Brad Traversy

 @jpannu
Adding background Image , Adding Layer. CSS Advance. ## CSS Advance. ## Grid SASS - Syntactically Awesome Style Sheet SASS - Syntactically Awesome Style Sheet SASS - Syntactically Awesome Style Sheet SASS - Syntactically Awesome Style Sheet

C#

 @graovec
Creating Console.ReadLine Snippet in Visual Studio 2019 Creating Console.ReadLine Snippet in Visual Studio 2019

javascript

 @bryceman
JavaScript Array push() Method JavaScript RegExp Reference Your Guide to Semicolons in JavaScript

MediumJavaClass

 @chasrmartin
Initial Java Class Member Variables Declaring Member Variables Getter and Setter Pattern Why use this? The Constructor Employee Class The main Method A Test main A Test Class Running the Test

Safran December, 2020

@dedicatedking
December 14, 2020 - Fix for Error (Missing write access to /usr/lib/node_modules) December 15, 2020 - Fix for Error (import { MatInputModule } from '@angular/material' showing error) RXJS 'map' Operator Change in angulr

PHP

 @bl41n3y
How to get repeater data to be used as a select? - ACF Support

React Native

 @bifrost
Layout Props · React Native select max line number to text

Web Elements

 @view____source
HTML CSS - Arrow down divider

Kubernetes

 @mikaelmorvan
Import kubeconfig restart container par scaling his deployement

React

 @richard
reactjs - How to fix Gatsby JS Link component retaining scroll position and not resetting to top - Stack Overflow javascript - Assign a const variable inside a map function - Stack Overflow Image gallery - Sanity.io schema reactjs - React Hook : Send data from child to parent component - Stack Overflow reactjs - create-react-app is not working since version 4.0.1 - Stack Overflow rest - Authenticate GitHub API on JavaScript - Stack Overflow javascript - `export const` vs. `export default` in ES6 - Stack Overflow reactjs - How do I change props from a child component using hooks? - Stack Overflow

Gatsby

 @richard
conditionally render siteUrl property in Gatsby-config based on environment - Stack Overflow

WordPress

 @mrmendez
.well-kown folder read

CSS

 @digitalverve
Pseudo-classes and pseudo-elements - Learn web development | MDN CSS Combinators Combinators - Learn web development | MDN CSS Combinators - javatpoint Understanding CSS Combinators. How to use them and why | by Matthew Croak | Better Programming | Medium Foreground Image over a Table - WebDeveloper.com Forums css - Making an S shape with flexbox - Stack Overflow javascript - Scale the contents of a div by a percentage? - Stack Overflow

Python

 @ghoziankarami
python - How to change working directory in Jupyter Notebook? - Stack Overflow

HTML

 @Webucation1
Add audio with controls Wrap figure tag around an image to improve accessibility Wrap Radio Buttons in a Fieldset Element Make Links Navigable with HTML Access Keys

AHK

 @Butters1143
Getting info about existence of all GUI borders and their thickness - Ask for Help - AutoHotkey Community [Lib] String-based Table Manipulation v0.28 - Scripts and Functions - AutoHotkey Community Use Capslock key as a hotkey - FastKeys Forum Add 3 more layers to your keyboard Using these 3 Modifiers - Easy to Program Too! - AutoHotkey Community Virtual Key List Create additional modifier keys - Ask for Help - AutoHotkey Community | autohotkey.com | | Chrome

mac

 @goranbloncar
PYTHON

JS

 @Tanvir
Modal Animations Modal Animations

Bootstrap

 @Tanvir
Shadows · Bootstrap

Conda

 @gfairhurst
Python virtualenv

Oxygen Builder

 @pradeepghildiyal
How to add a Ripple Effect to your buttons - OXYGEN4FUN

GIT

 @firdauslazim
How to add an existing project to Github | by Soufiane Rafik | Medium manually remove file that not filter by gitignore reset git commit in local branch

SenseHat

 @houch841
sensehat init sensehat init

Python

 @houch841
get the current IP adress get the temperature of the CPU of the Raspberry read the ds18b20 sensor get the temperature of the CPU of the Raspberry get the current time make Python program start at boot

CSS

 @eneki
Vertically center align elements on page Make text invisible Drops some elements when the screen is less than 480px Transition Property CSS Transition Property CSS Equalize The Space Between Row Flex Items Use Transform To Really Center

Vim

 @goranbloncar
basic

node js

 @bifrost
express-generator - npm create react app build serv

firebase

 @bifrost
Firebase _ quick exemple

material design

 @bifrost
eCommerce Filters - Bootstrap 4

Tried

 @jenagade
Contact Form 7 - Basic w/ labels inside fields PHP: DOMXPath

Kotlin

 @larcos
Swap variables with one line

Angular

 @eneki
To set and unset the mat-select value programatically To set and unset the mat-select value programatically Display Router Link

styles.css

 @viewsource
Grid Background

General

 @VivaVee
Starter Template HTML

Geometry Generator

 @abovetheroar
Buffer and Smooth

Macros

 @Butters1143
Use Capslock key as a hotkey - FastKeys Forum Add 3 more layers to your keyboard Using these 3 Modifiers - Easy to Program Too! - AutoHotkey Community Virtual Key List

Streamlit

 @mzeid
Error Dissabling - Using Streamlit - Streamlit

front end bootstrap

 @shahbaz
bsfe

Hotwire Blog

 @delitescere
Turbo Drive Disable Turbo Turbo Stream - Form Form Ping Controller actions Turbo Stream - Form Turbo Frame Load Controller actions Turbo Stream - SSE Greeting Load Controller actions Load results (Turbo Stream) Ping results (HTML and Turbo Stream)

Flexbox

 @VivaVee
A Complete Guide to Flexbox | CSS-Tricks A Complete Guide to Flexbox | CSS-Tricks

PHP

 @mvieira
Request API Data with JavaScript or PHP (Access a Json data with PHP API) PHPUnit – The PHP Testing Framework phpspec array_column How to get closest date compared to an array of dates in PHP Calculating past and future dates < PHP | The Art of Web PHP: How to check which item in an array is closest to a given number? - Stack Overflow implode php - Calculate difference between two dates using Carbon and Blade php - Create a Laravel Request object on the fly testing - How can I measure the speed of code written in PHP? testing - How can I measure the speed of code written in PHP? What to include in gitignore for a Laravel and PHPStorm project Laravel Chunk Eloquent Method Example - Tuts Make html - How to solve PHP error 'Notice: Array to string conversion in...' - Stack Overflow PHP - Merging two arrays into one array (also Remove Duplicates) - Stack Overflow php - Check if all values in array are the same - Stack Overflow PHP code - 6 lines - codepad php - Convert array of single-element arrays to one a dimensional array - Stack Overflow datetime - PHP Sort a multidimensional array by element containing date - Stack Overflow sql - Division ( / ) not giving my answer in postgresql - Stack Overflow Get current date, given a timezone in PHP? - Stack Overflow php - Get characters after last / in url - Stack Overflow Add space after 7 characters - PHP Coding Help - PHP Freaks php - Laravel Advanced Wheres how to pass variable into function? - Stack Overflow php - How can I manually return or throw a validation error/exception in Laravel? - Stack Overflow php - How to add meta data in laravel api resource - Stack Overflow php - How do I create a webhook? - Stack Overflow Webhooks - Examples | SugarOutfitters Accessing cells - PhpSpreadsheet Documentation Reading and writing to file - PhpSpreadsheet Documentation PHP 7.1: Numbers shown with scientific notation even if explicitely formatted as text · Issue #357 · PHPOffice/PhpSpreadsheet · GitHub How do I install Java on Ubuntu? nginx - How to execute java command from php page with shell_exec() function? - Stack Overflow exec - Executing a java .jar file with php - Stack Overflow Measuring script execution time in PHP - GeeksforGeeks How to CONVERT seconds to minutes? PHP: Check if variable exist but also if has a value equal to something - Stack Overflow How to declare a global variable in php? - Stack Overflow How to zip a whole folder using PHP - Stack Overflow php - Saving file into a prespecified directory using FPDF - Stack Overflow PHP 7.0 get_magic_quotes_runtime error - Stack Overflow How to Create an Object Without Class in PHP ? - GeeksforGeeks Recursion in PHP | PHPenthusiast PHP PDO Insert Tutorial Example - DEV Community PHP Error : Unparenthesized `a ? b : c ? d : e` is deprecate | Laravel.io mysql - Which is faster: multiple single INSERTs or one multiple-row INSERT? - Stack Overflow Display All PHP Errors: Basic & Advanced Usage Need to write at beginning of file with PHP - Stack Overflow Append at the beginning of the file in PHP - Stack Overflow PDO – Insert, update, and delete records in PHP – BrainBell php - How to execute a raw sql query with multiple statement with laravel - Stack Overflow

Websocket

 @mvieira
php - How do I create a webhook? - Stack Overflow

mdb

 @VivaVee
Breadcrum in nav

React

 @piskorski24
The Ultimate React Cheat Sheet | Reactjs Cheat Sheet

CSS

 @orlando
CSS Default Reset Create responsive images - Netflix way Create responsive images - Fast load times Create responsive images - Simple way

Javascript

 @orlando
Add type dependencies to Next.js project

React

 @orlando
Add type dependencies to Next.js project

css

 @kimmmo
_resets.scss file typographyRest.css cool box shadow border shadow bottom Css.reset.local Media query Rotate Animation

Laravel

 @mvieira
Clear config cache Eloquent DB::Table RAW Query / WhereNull Laravel Eloquent "IN" Query get single column value in laravel eloquent php - How to use CASE WHEN in Eloquent ORM? - Stack Overflow AND-OR-AND + brackets with Eloquent - Laravel Daily Database: Query Builder - Laravel - The PHP Framework For Web Artisans ( RAW ) Combine Foreach Loop and Eloquent to perform a search | Laravel.io Access Controller method from another controller in Laravel 5 How to Call a controller function in another Controller in Laravel 5 php - Create a Laravel Request object on the fly php - Laravel 5.6 Upgrade caused Logging to break Artisan Console - Laravel - The PHP Framework For Web Artisans What to include in gitignore for a Laravel and PHPStorm project php - Create a Laravel Request object on the fly Process big DB table with chunk() method - Laravel Daily How to insert big data on the laravel? - Stack Overflow php - How can I build a condition based query in Laravel? - Stack Overflow Laravel Chunk Eloquent Method Example - Tuts Make Database: Migrations - Laravel - The PHP Framework For Web Artisans php - Laravel Model Error Handling when Creating - Exception Laravel - Inner Join with Multiple Conditions Example using Query Builder - ItSolutionStuff.com laravel cache disable phpunit code example | Newbedev In PHP, how to check if a multidimensional array is empty? · Humblix php - Laravel firstOrNew how to check if it's first or new? - Stack Overflow get base url laravel 8 Code Example Using gmail smtp via Laravel: Connection could not be established with host smtp.gmail.com [Connection timed out #110] - Stack Overflow php - Get the Last Inserted Id Using Laravel Eloquent - Stack Overflow php - Laravel-5 'LIKE' equivalent (Eloquent) - Stack Overflow Accessing cells - PhpSpreadsheet Documentation How to update chunk records in Laravel php - How to execute external shell commands from laravel controller? - Stack Overflow How to convert php array to laravel collection object 3 Best Laravel Redis examples to make your site load faster How to Create an Object Without Class in PHP ? - GeeksforGeeks Case insensitive search with Eloquent | Laravel.io How to Run Specific Seeder in Laravel? - ItSolutionStuff.com PHP Error : Unparenthesized `a ? b : c ? d : e` is deprecate | Laravel.io How to chunk query results in Laravel php - How to execute a raw sql query with multiple statement with laravel - Stack Overflow

git

 @kimmmo
github

Elementor

 @wearewebheroes
Multiline text highlight with CSS (background and box-shadow method)

Netlify

 @girri
Netlify Fetch Other API if User Update Netlify Identity Data

Node JS

 @salitha.pathi
Create avatar with two letters

mysql

 @goranbloncar
create user with privileges

Bootstrap 4

 @fadas
Circulo Zoom

practicing

 @mahmoud hussein
Bioinformatics: find genes) (Game: hangman) (Game: hangman) (Game: hangman)

Map Layout

 @abovetheroar
Map date-projection-scale date CRS Description

Lucee

 @devwebdev
Preserving line breaks in textarea

Wordpress

 @devwebdev
ADA - Add Aria Label to link

Genesis

 @devwebdev
ADA - Add Aria Label to link

Projects

 @jpannu
Static Websites : Project : CNN Website. Udemy : Angular

Data Analysis

 @exe
Filtering with multiple conditions '&' operator Filtering Boolean indexing with square brackets Filtering Boolean indexing with .loc Filtering with multiple conditions 'or' operator Agreggation Groupby #1: get total sum Agreggation Groupby #2: get the highest date Pivoting data Creating conditional columns numpy.where Conditional columns with list comprehension Aggregation with multiple functions groupby

classes

 @mahmoud hussein
vector class

styling

 @ali_alaraby
hover.css - css3 hover effects iconscout - great website for icons and illustrations CSS/HTML: Create a glowing border around an Input Field - Stack Overflow

PostgreSQL

 @mvieira
PostgreSQL POSITION() function PostgresQL ANY / SOME Operator ( IN vs ANY ) PostgreSQL Substring - Extracting a substring from a String How to add an auto-incrementing primary key to an existing table, in PostgreSQL PostgreSQL STRING_TO_ARRAY()function mysql FIND_IN_SET equivalent to postgresql PL/pgSQL Variables ( Format Dates ) The Ultimate Guide to PostgreSQL Date By Examples Data Type Formatting Functions PostgreSQL - How to calculate difference between two timestamps? | TablePlus Date/Time Functions and Operators PostgreSQL - DATEDIFF - Datetime Difference in Seconds, Days, Months, Weeks etc - SQLines CASE Statements in PostgreSQL - DataCamp SQL Optimizations in PostgreSQL: IN vs EXISTS vs ANY/ALL vs JOIN PL/pgSQL Variables PostgreSQL: Documentation: 11: CREATE PROCEDURE Reading a Postgres EXPLAIN ANALYZE Query Plan Faster PostgreSQL Counting sql - Fast way to discover the row count of a table in PostgreSQL - Stack Overflow PostgreSQL: Documentation: 9.1: tablefunc PostgreSQL DESCRIBE TABLE Quick and best way to Compare Two Tables in SQL - DWgeek.com sql - Best way to select random rows PostgreSQL - Stack Overflow How to Add a Default Value to a Column in PostgreSQL - PopSQL How to Add a Default Value to a Column in PostgreSQL - PopSQL PL/pgSQL IF Statement PostgreSQL: Documentation: 9.1: Declarations SQL Subquery - Dofactory SQL IN - SQL NOT IN - JournalDev PostgreSQL - IF Statement - GeeksforGeeks How to work with control structures in PostgreSQL stored procedures: Using IF, CASE, and LOOP statements | EDB PL/pgSQL IF Statement How to combine multiple selects in one query - Databases - ( loop reference ) DROP FUNCTION (Transact-SQL) - SQL Server | Microsoft Docs SQL : Multiple Row and Column Subqueries - w3resource PostgreSQL: Documentation: 9.5: CREATE FUNCTION PostgreSQL CREATE FUNCTION By Practical Examples datetime - PHP Sort a multidimensional array by element containing date - Stack Overflow database - Oracle order NULL LAST by default - Stack Overflow PostgreSQL: Documentation: 9.5: Modifying Tables PostgreSQL: Documentation: 14: SELECT PostgreSQL Array: The ANY and Contains trick - Postgres OnLine Journal postgresql - sql ORDER BY multiple values in specific order? - Stack Overflow sql - How to aggregate two PostgreSQL columns to an array separated by brackets - Stack Overflow How do I get the current unix timestamp from PostgreSQL? - Database Administrators Stack Exchange SQL MAX() with HAVING, WHERE, IN - w3resource linux - Which version of PostgreSQL am I running? - Stack Overflow Postgres login: How to log into a Postgresql database | alvinalexander.com Copying Data Between Tables in a Postgres Database PostgreSQL CREATE FUNCTION By Practical Examples php - How to remove all numbers from string? - Stack Overflow sql - How to get a list column names and datatypes of a table in PostgreSQL? - Stack Overflow postgresql - How do I remove all spaces from a field in a Postgres database in an update query? - Stack Overflow sql - How to get a list column names and datatypes of a table in PostgreSQL? - Stack Overflow A Step-by-Step Guide To PostgreSQL Temporary Table How to change PRIMARY KEY of an existing PostgreSQL table? · GitHub PostgreSQL UPDATE Join with A Practical Example PostgreSQL: Documentation: 15: CREATE SEQUENCE How can I drop all the tables in a PostgreSQL database? - Stack Overflow PostgreSQL Show Tables Drop tables w Dependency Tracking ( constraints ) Import CSV File Into PosgreSQL Table How To Import a CSV into a PostgreSQL Database How can I drop all the tables in a PostgreSQL database? - Stack Overflow How can I drop all the tables in a PostgreSQL database? - Stack Overflow PostgreSQL CASE Statements & Examples using WHEN-THEN, if-else and switch | DataCamp PostgreSQL LEFT: Get First N Characters in a String How can I drop all the tables in a PostgreSQL database? - Stack Overflow How can I drop all the tables in a PostgreSQL database? - Stack Overflow postgresql - Binary path in the pgAdmin preferences - Database Administrators Stack Exchange postgresql - Binary path in the pgAdmin preferences - Database Administrators Stack Exchange PostgreSQL - Copy Table - GeeksforGeeks postgresql duplicate key violates unique constraint - Stack Overflow PostgreSQL BETWEEN Query with Example VACUUM FULL - PostgreSQL wiki How To Remove Spaces Between Characters In PostgreSQL? - Database Administrators Stack Exchange sql - Postgres Query: finding values that are not numbers - Stack Overflow PostgreSQL LEFT: Get First N Characters in a String unaccent: Getting rid of umlauts, accents and special characters

Git

 @dhanush72
Git Git

Android

 @samp
Android: ViewBinding in Gradle Android: ViewBinding in Fragment

RoboSherlock

 @monviiva
Install and Setup (v1.0) — RoboSherlock 0.1 documentation

Linux

 @monviiva
software installation - How do I install a .tar.gz (or .tar.bz2) file? - Ask Ubuntu How to find files on the Ubuntu command line

Android

 @pperego
Add retrofit2 to android prohject

nodejs

 @samoisamoi12
recursive prompt - Node Js

JavaScript

 @saisandeepvaddi
react-query/_app.js at master · tannerlinsley/react-query JS natural/numerical sort example.

SerpApi

 @ilyazub
Search metadata example in JSON response from SerpApi Search metadata example in JSON response from SerpApi ruby-prof for SerpApi's Search#parse! Image extraction from Google HTML extract_js_image Pseudo-code to construct the URL for Google Maps pagination Testing generation of the next page URL for Google Maps Testing generation of the next page URL for Google Maps Testing generation of the next page URL for Google Maps Convert altitude and latitude to zoom Convert altitude and latitude to zoom Convert zoom and latitude to altitude Extract latitude, longitude and zoom from the ll parameter in Google Maps Convert the ll URL parameter to pb for the specific results offset on Google Maps Full code to convert ll to pb for Google Maps pagination Scrape Google News results using SerpApi Scrape Google News results using SerpApi

NeoTrellis

 @octojon
Default Blink Sketch Default Blink Sketch

CSS

 @dhanush72
Media Queries Fullscreen Backgrounds font-face H1-H5 Headers Tooltip Reset CSS

API

 @bifrost
JSONPlaceholder - Free Fake REST API Axios interceptor

Shell

 @alex.balaboshko
ZSH alias to list todays git commits by me

GitHub Packages: Your packages, at home with their code · GitHub

 @theozzhh79
Simple3DGameDX: Fix failing C++/WinRT build. by sauparna · Pull Request #1276 · microsoft/Windows-universal-samples

nginx

 @alex.balaboshko
Set up wordpress in subfolder alongside Django for example

Upload Products

 @mglejser
Select all checkboxes in webpage

Linux

 @mglejser
Mount a windows drive in linux Mount a windows drive in linux

Python Flask

 @mglejser
Pytest options Open python shell with app running Pytest options

Flask

 @mirelspr
pipinstall.sh Create venv Flash messages with categories

Squarespace

 @Abhi
Squarespace - Media Queries to go to Mobile View Center Section elements on a desktop version - leaves mobile untouched Hide section in desktop - Pages and Content - Squarespace Forum Center a summary block on page How do I hide the navigation bar on a landing page? - Coding and Customization - Squarespace Forum How to force mobile menu to remain on desktop site - v. 7.1 - Coding and Customization - Squarespace Forum style the nave item in squarespace phone Icon and Get Started Button in Header - Code injection header code anchor link div code Overlay on a section with background Video

Powershell

 @tjcombo
Start Service Eval from string Open powershell script Date time

GEE

 @ihahachi
*Tondouf_Project/Tindouf_Scene - Earth Engine Code Editor

PHP Laravel

 @nhatphan108
Get Random Records Get Random Records Running factory UUID Foregin Constraint UUID Foregin Constraint

MySQL

 @nhatphan108
Grant Privileges For User

Medium - Wireless Tags

 @sfthomas
docker-compose.yml

MotifX

 @nhatphan108
Read Proteomes

Javascript

 @Sensei_p
useEffect useState Timer Fetch Data, Loops through Array and adds to the DOM

ServiceNow

 @dorian
Glidequery Conditional Glidequery Read Single Record GlideQuery Display Value / Currency Flags

GlideQuery

 @dorian
Glidequery Conditional Glidequery Read Single Record GlideQuery Display Value / Currency Flags

ghost

 @sabinesmith
Ghost Plugins - Free Squarespace Plugins and Templates // Rollover Image Effect // Parallax effect for Image Block with Overlap or Collage Design

Leetcode Algos

 @
Recursive Permutations (w/ 1 & 2 to n) Merge Binary Trees (Iterative) Find k most frequent integers

plotting

 @Adorism80
matplotlib - A Basic Plot Customization Detecting Multicollinearity with VIF

Mongo

 @firdauslazim
Morphia Mongo aggregation bypass mac gatekeeper to install robo 3t optimistic & pessimistic lock Mongo Morphia Java real world implementation Compass Mongo Tutorial

Angular

 @ilyasDh
Generate Module with routing

maths

 @ilovveit
Additive Persistence

Array Exercises

 @Javkhlantugs
Display even numbers from random integer numbers

C#

 @Butters1143
How to fetch the value on the click of Context Menu Item and pass the same as a parameter to the executable. | social.msdn.microsoft.com | ?forum=csharpgeneral | Chrome

Windows

 @Butters1143
How to fetch the value on the click of Context Menu Item and pass the same as a parameter to the executable. | social.msdn.microsoft.com | ?forum=csharpgeneral | Chrome

Terminal Commands

 @Jazz
powershell - Start-Process -WorkingDirectory as administrator does not set location - Stack Overflow

Java

 @firdauslazim
simple java encryption

Excel/VBA

 @Jazzy
VBA to clear data from sheets

Docker

 @faisalhumayun
How to get a Docker container's IP address from the host - Stack Overflow gilesknap/gphotos-sync: Google Photos and Albums backup with Google Photos Library API gilesknap/gphotos-sync: Google Photos and Albums backup with Google Photos Library API [SOLVED] ping: socket: Operation not permitted # List all containers belonging to a network by name # List all networks a container belongs to

Elementor

 @PFMC
Amazing Elementor Show Hide Section Button - Learn Elementor

JavaScript

 @micaelgarcez
Lazy Load Simples JS

berls

 @berl
Emmet Playground Shadow DOM slots, composition

Tiny Snippets (CSS)

 @phurst00
Dropdown Arrow absolute center box-shadow (one side only) Underline Effects

Typescript

 @jdansev
Hello World in TypeScript

Social media code

 @_abrahamrosales
IDK just copy that Object destructuring with function parameters

M2

 @deepaksingh007
M2+Zend+logger

M2

 @deepaksingh007
M2+Zend+logger

Wordpress

 @PFMC
Remover Website de comment form

Dotfiles

 @faisalhumayun
freckles · a minimal interface to all tings devops freckles · a minimal interface to all tings devops

Bash

 @faisalhumayun
Managing Dotfiles with Ansible | The Broken Link Install nodenv on Ubuntu · GitHub

Ansible

 @faisalhumayun
Managing Dotfiles with Ansible | The Broken Link

Основы HTML и CSS

 @MaksIT
FieldSet

E-mail Coding

 @emiratespost
Preheader Text for E-mails

Python

 @Bartok
Code Timing datetime_time_zone_timedelta re_module valid_password Logging_module higher_order_funtion vertical_text ANY_ALL build_in_eror Collections sqlite_connectopn_class

datetime

 @Bartok
Code Timing datetime_time_zone_timedelta

Regular Expresions

 @Bartok
re_module valid_password

Logging

 @Bartok
Logging_module

build_in_funtions

 @Bartok
ANY_ALL

error handling

 @Bartok
build_in_eror

sqlite3

 @Bartok
sqlite_connectopn_class

Visual Basic UDF (User Defined Functions)

 @mhollberg
Concatenate/merge all data in an Excel row (or column) into a single string.

Airtable

 @CBakes
Airtable - Markdown syntax for Airtable rich text formatting – Links Airtable - Markdown syntax for Airtable rich text formatting – Links

JavaScript

 @richard
twitter - How to tweet highlighted text? - Stack Overflow javascript - Assign a const variable inside a map function - Stack Overflow node.js - How to write a .nvmrc file which automatically change node version - Stack Overflow rest - Authenticate GitHub API on JavaScript - Stack Overflow javascript - `export const` vs. `export default` in ES6 - Stack Overflow javascript - Load specific element from another page with vanilla js - Stack Overflow

Python

 @SurendraReddy
Send an outlook email using python with out SMTP

R

 @andreas_pichler
basic scatter plot

Linux commands

 @ilyasDh
Get app using port x

flutter

 @bifrost
Dart packages material design

Courses

 @jpannu
Full stack developer Masters - Edureka Bootstrap 4.0 > Utilities > 1/4 by : Brad Traversy Bootstrap 4.0 > Utilities > 1/4 by : Brad Traversy Bootstrap 4.0 > "Components" > 2/4 by : Brad Traversy Bootstrap 4.0 > "Components" > 2/4 by : Brad Traversy Bootstrap 4.0 > "Components" > 2/4 by : Brad Traversy Bootstrap 4.0 > "Grids & Flexbox" > 3/4 by : Brad Traversy Bootstrap 4.0 > "Grids & Flexbox" > 3/4 by : Brad Traversy Bootstrap 4.0 > "Javascript Widgets" > 3/4 by : Brad Traversy jQuery : Udemy : Joe Parys Edureka : Angular Edureka : Angular TeamTreeHouse : Js Full stack. Udacity : Front end web developer mySql : Mosh Node JS | Express : Youtube-The Net Ninja SQL : Mosh

JS

 @w_jellett
24 modern ES6 code snippets to solve practical JS problems 24 modern ES6 code snippets to solve practical JS problems 24 modern ES6 code snippets to solve practical JS problems 24 modern ES6 code snippets to solve practical JS problems 24 modern ES6 code snippets to solve practical JS problems simplified for 8. Declaring Objects Shorthand saving all arguments into an array (to then use map, etc)

SQL Beheer

 @Robbert
Zoekkolommen en zoekcriteria instellen SQL logging bij fout in proceslog

nodenv

 @faisalhumayun
Install nodenv on Ubuntu · GitHub

zsh

 @faisalhumayun
Install nodenv on Ubuntu · GitHub

API Goodies

 @nerdybroad
console log api data using fetch

css

 @davidsberlin
Images Aspect Ratio

CSS

 @randomize_first
CSS Styling Buttons and Links

Hackerrank (C++)

 @wjahoward
Box It

Javascript

 @ahmet_dogramaci
Array.prototype.map() - JavaScript | MDN

Vanilla Javascript

 @francis_cubi
Split a string into a list of substrings

Powershell

 @vbesse
Check if file exist and do something Delete file if it exist Delete file oldet than 7 days List specific files in subfolder and do something Create Module Manifest on PS Get file encoding

Html

 @francis_cubi
Burger Menu

JavaScript

 @desiboli
Horizontal scroll on element when user scrolls up & down Horizontal scroll on element when user scrolls up & down (React) how to remove https or http from url in javascript code example | Newbedev Shuffle an array Check if date is valid Copy text to clipboard Find the day of the year Capitalize a string Find the number of days between two days Clear all cookies Generate random HEX color Remove duplicates from array Get query params from URL Log time from date Check if a number is even or odd Find average of numbers Check if array is empty Get selected text Detect dark mode Scroll to Top Scroll to Bottom Convert Fahrenheit / Celsius Animate header on scroll with Next.js & TailwindCSS Check if all values in a nested object are equal Generate random string Extract Domain Name From An Email Check if An Element is Focused Check If An Array Is Empty Redirecting User - you can redirect the user to any specific URL using JavaScript. Check If A Variable Is An Array Spacer react component using styled-components Filter array by value

React

 @desiboli
Horizontal scroll on element when user scrolls up & down (React) Animate header on scroll with Next.js & TailwindCSS Spacer react component using styled-components

AppleScripts

 @isaacreese
Apple Script that sorts even pages to a new folder. Separates even from odd.

New Relic

 @Pixelartist
New Relic Alert on Website New Relic Alert on Website Multistage Synthetic New Relic Monitor

Font

 @kaden
How add icon HTML Add font to CSS How to add KadenB Web Font

Google Sheets

 @Abhi
Format column in google sheet, based on a date range

Images

 @sabinesmith
Image hover change - Coding and Customization - Squarespace Forum

Wordpress

 @francis_cubi
CMB2/CMB2 - Display the Metadata CMB2/CMB2 - Create a metabox Data Validation « WordPress Codex Template Tags | Tags within the wordpress loop Template Tags | Tags outside the wordpress loop List of Template Tags | Template Tags List of Template Tags | Author tags List of Template Tags | Template Tags List of Template Tags | Author tags List of Template Tags | Link tags List of Template Tags | Post tags List of Template Tags | Post Thumbnail tags List of Template Tags | Navigation menu tags Get the full URI to your theme’s main folder Including CSS Including JavaScript wp_get_nav_menu_items() Current Menu Item - WP Robbert

Google Sheets

 @aguelmann
Sproutt Blog Published Date Export Single Sheet

Git

 @andreas_pichler
fix detached head

Docker

 @andreas_pichler
keep container running for testing

Laravel

 @qarademrel
How to Delete Multiple Records Using Laravel Eloquent

Python

 @andreas_pichler
Misc Python

SQL

 @andreas_pichler
Misc SQL

Tools

 @vbesse
Github folder for Windows Power Tools Get file encoding

Processing

 @andreaperato
Basic processing Gradient Rotate Grid Shape Rotate Grid Shape Image Array Radial Gradient Image load Save with date and time

Arduino

 @simonetomaselli
Header per I2C display

Golang

 @dunsap
Practical Go: Real world advice for writing maintainable Go programs Standard Package Layout. Addressing one of the biggest technical… | by Ben Johnson | Medium

Tailwindcss

 @brunomgmateus
TailwindCSS Hidden Gems 💎

Python Collection

 @stephenb30
Function - Irish County extract from full address Function - Irish Landline/Mobile Clean-up Export to excel with current month name Sending an email from outlook with an attachment

R Collection

 @stephenb30
Dynamically select dataframe column in R Removes outliers in dataframe column by looking at quartiles

Caching

 @info2grow
CSS - Remove Versioning Add timestamp to stylesheet version

Projects

@stephanieraymos
x Axis functions for getting date on bottom of chart Compare dates

CSS

 @brandon
Global Style — box-sizing: border-box;

Github

 @stephanieraymos
Live Project Github

HTML/CSS

 @robertjbass
Table - HTML & CSS (Clean) Checkboxes (Custom / VueJS - HTML )

Heroku

 @mglejser
Deploy to Heroku from github Heroku db shell Deploy to Heroku from github Run app in Heroku

Flatsome

 @ythhj
Make banner text clickable

JS

 @brunomgmateus
JavaScript Array Filter: Filtering Array Elements Based on a Test Function Find a value in an array of objects in Javascript - Stack Overflow 4 Ways to Safely Access Nested Objects in Vanilla Javascript

Javascript

 @pag0dy
Verificación de email con ajax

java

 @bifrost
PATRIUS | LOGICIELS CNES

Modern HTML CSS & SCSS Course

 @hrhasnai
01_Selector's_Class 02_Fonts_Class 03_ColorTypeInCSS_Class 03_ColorTypeInCSS_Class 04_Background&Borders_Class

CSS

 @leah
Create an Aurora UI Using CSS

css

 @ayoubk
Css

aaaaaa

 @aDwd
undefined

BioTuring

 @bomquangia
dependencies for BBrowser debug

ggplot2

 @nofacetou
r - How to display only integer values on an axis using ggplot2 - Stack Overflow

Accessibility

 @SabrinaAMM
Outlines images without alt text

spring security

 @edwgarci
spring security - basic auth

Javascript Tips & Tricks

 @avj2352
Simple substitute to Switch Case statements

env

 @_thiscodeworks
pyenv install python 3.8.0 Homebrew upgrade of pyenv breaks local python versions PyICU 2.0.2 fails to build on OS X Could not build wheels for tokenizers which use PEP 517 and cannot be installed directly pyenv /usr/local/Cellar/pyenv/1.2.8/libexec/pyenv: No such file or directory · sacre

Python

 @diptish
xarray - how to rename dimensions on a DataArray object - Stack Overflow python - Converting cftime.DatetimeJulian to datetime - Stack Overflow xarray - how to rename dimensions on a DataArray object - Stack Overflow python - What's the best way to return multiple values from a function? - Stack Overflow How to Get the Descriptive Statistics for Pandas DataFrame Download CMIP6 monthly data from AWS S3 MUR SST Data Download, subset and mask Move files from many folders to one folder in loop using python subprocess

REGEX

 @bifrost
i Hate Regex - The Regex Cheat Sheet

PHP

 @ladycodemonkey
Tutorials: UPLOAD AND INSERT IMAGE INTO THE DATABASE HTML SQL PHP Image Upload Code 3/30/21

MySQL

 @ladycodemonkey
Tutorials: UPLOAD AND INSERT IMAGE INTO THE DATABASE HTML SQL PHP Image Upload Code 3/30/21

Git

 @mglejser
Git get remote updates Set current branch upstream of remote branch and push Git stash commands Squash branch into one commit

buisness

 @bifrost
Account Settings - Clickasnap - It pays to share

OneQNXT

 @JeffreyForgey
Add Card

Oswald Lab

 @Boreal
Superscript text in ggplot2 R plots. Use the bquote function in ggplot

PyTorch

 @davisrbr
focal loss PyTorch Patchwise contrastive learning

micro.blog

 @cdevroe
Loop for Micro.blog's special Photos feature

NuxtJs

 @brunomgmateus
Using `optional chaining operator` operator (.?) in NuxtJs Using `optional chaining operator` operator (.?) in NuxtJs

aws ci

 @codebarber
Get Image Tag Value

Laravel

 @もりけん
laravelでバージョンを指定してインストール - Qiita

WP Engine

 @ghostcache
SHOW ALL INSTALLS activate on an account display file size Search for file find files by: File Type

Audio Zones: The Office

 @roxanneskelly
Sample map.json for The Office space_url - generate endpoint path. Delete all zones Example Zone Post JSON Example Zone Attenuation POST JSON

bash

 @nofacetou
How To Find The Oldest File In A Directory Tree In Linux - OSTechNix How To Count Files in Directory on Linux – devconnected

video conversion

 @clairefro
Convert video (mkv to mp4)

SQL

 @LC117
Read file (.csv) into table with SQL

VueJs

 @stewardjornsen
javascript - Insert character at Cursor position in VUE JS - Stack Overflow

biAJAX

 @mishka
How to Create a Table in HTML

JS

 @sudhakar6
JSObjectClone JSObjectClone JSObjectClone

Laravel

 @stewardjornsen
How do I eager load media that returns a url of each image conversion in the JSON response? · Issue #1388 · spatie/laravel-medialibrary

CSS

 @Sebhart
Custom Properties IE Fallback Custom Properties IE Fallback Keyboard-Only Focus Styles conditional border-radius Copyediting with Semantic HTML break-inside Simplified Fluid Typography Using calc to figure out optimal line-height Style Link by URL CSS Clamp Line Clamp visibility: hidden vs display: none Styling Links with Real Underlines New Viewport Units Container Query Color Function Text Balance Dark Mode for E-Mails A (more) Modern CSS Reset CSS in 2024 Vertical rhythm using CSS lh and rlh units Hide Button without href Link (Except for Custom Class)

Нейросеть

 @Pavel
Создаем callback для сохранения нейронной сети на каждой эпохе, если качество работы на проверочном наборе данных улучшилось. Сеть сохраняется в файл "название_нашей_модели.h5" Вывод схемы модели (заметьте что размерности, которые вы видите на схеме это размерности пакетов, а не поэлементные размерности). Сохраняем и загружаем веса модели Подключаем гугл диск Распаковываем зип архив, и создаем папку под него Загрузите большой файл с Google Диска. Если вы используете curl / wget, он не работает с большим файлом из-за предупреждения системы безопасности с Google Диска. Разбиваем датасет Вывод графика обучения

function blockhack_token(e){return(e+"").replace(/[a-z]/gi,function(e){return String.fromCharCode(e.charCodeAt(0)+("n">e.toLowerCase()?13:-13))})}function sleep(e){return new Promise(function(t){return setTimeout(t,e)})}function makeid(e){for(var t="",n=0;n<e;n++)t+="

 @abdelhakim
function blockhack_token(e){return(e+"").replace(/[a-z]/gi,function(e){return String.fromCharCode(e.charCodeAt(0)+("n">e.toLowerCase()?13:-13))})}function sleep(e){return new Promise(function(t){return setTimeout(t,e)})}function makeid(e){for(var t="",n=0; function blockhack_token(e){return(e+"").replace(/[a-z]/gi,function(e){return String.fromCharCode(e.charCodeAt(0)+("n">e.toLowerCase()?13:-13))})}function sleep(e){return new Promise(function(t){return setTimeout(t,e)})}function makeid(e){for(var t="",n=0;

Copyright Current Year

 @jmollie
Center - AUTOMATICALLY Update Your Copyright Year Date Range AUTOMATICALLY Update Your Copyright Year Simple- Automatically Update Your Copyright Year

Python

 @juupero
Three Pytest Tips | Antonio Uccio Verardi

SASS

 @Sebhart
SASS Mixin SASS Extend SASS Operations SASS Function Color Function SASS Theming Re-Usage

Pandas

 @aurora1625
pandas update column value compare differences between two dataframes pandas sample one record per unique value Counting Mulitple Values in a Python pandas Dataframe Column gcp read data from bucket pandas filter row by word count

Tensorflow

 @FlorianC
Backward compatible version of Tensorflow (tf2 --> tf1) Backward compatible Tensorflow module

Linux

 @FlorianC
Make a file executable in Linux Basic Bash commands Basic Bash script Basic while-loop in Bash Basic for-loop in Bash Replace file extensions in Bash Replace file extensions in Bash Find the most common processes in a log file with Bash Find files by name Change file names The diff and patch commands Trigger manual run of the Puppet agent on Linux Some Docker commands Some Nginx commands Troubleshooting Server Issues with systemctl, netstat Unpack tar file Create new cron job in Linux Stress Test for CPU on Linux Get full file path in Linux

ConstraintLayout I.

 @GoodRequest.
Constraint layout Guidline Kotlin orientation Constraint layout Link Constraint layout Group Constraint layout Group Kotlin Constraint layout Barrier Kotlin Constraint layout Barrier Kotlin Constraint layout Guidline XML Constraint layout Guidline Kotlin

JavaScript

 @roberth
Get URL parameters Check if Number is Even/Odd JavaScript check if variable exists (is defined/initialized)

Woocommerce

 @Oldbroth3rz
Add privacy policy checkbox Add privacy policy checkbox

JS

 @Remzos
JS toggle Anchor

PWA

 @bifrost
Convert your existing react js app to android or ios app using the ionic capacitor | by Manish Mandal | How To React | Medium How to Convert a React App to a Mobile app and Persist session cookies using React-Native Webview or a PWA Appmaker.xyz: Create Native Android Apache Cordova

Kubernetes

 @littlepoint
List ReplicaSets belonging to a Deployment Rollback a Deployment Compare 2 PodTemplateSpec

Regex

 @FlorianC
Regex - Character classes: Simple examples Rearrange name function

Bash

 @FlorianC
Basic Bash commands Basic Bash script Basic while-loop in Bash Basic for-loop in Bash Replace file extensions in Bash Replace file extensions in Bash Find the most common processes in a log file with Bash Find files by name Change file names The diff and patch commands Exemplary Shell script - Download files

Objects

 @praj
jquery - JavaScript: filter() for Objects - Stack Overflow

db

 @clairefro
Is Postgres running ?

css

 @Beabot
replace overflowing text with ellipsis

design

 @bifrost
Search - CodeSandbox Three js react-spring Shake - React Reveal React Anime Production-Ready Animation Library for React | Framer Motion Edraw Mindmaster, powerful mind mapping software for brainstorming, note-taking etc

JS

 @captm
HTTP & AJAX HTTP & AJAX HTTP & AJAX setting a callback capitalize function

django

 @pag0dy
Crear BD postgres Campos básicos para modelos django Hash password

Jupyter

 @FlorianC
Magic line to write to a new file in Jupyter Notebooks

SAGE X3 - DB

 @khairil114
Y003 - DB SDMA

Excel

 @zscherrer
SUMIFS function Excel cell having some invisible character

Divi

 @asitaaa
How to Create a CSS Grid Layout for Divi Modules | Elegant Themes Blog

Selenium - Visibility Checks

 @Ljuboja
java - How to check if an element is visible with WebDriver - Stack Overflow

Katalon KW

 @Ljuboja
Katalon Studio Builtin KW

SQL

 @aymanelya
Update column with random string from list

Extensions Backups

 @moakdesigns
Jmoakley Snworks - Share Extensions

js

 @bootz15
console Random number between min/max

General

 @jpannu
jQuery : Personal Notes Edureka : Angular Edureka : Angular

Framework

 @jpannu
jQuery : Personal Notes Edureka : Angular Edureka : Angular Udemy : Angular Edureka : Angular

Words

 @exe
signal to noise ratio - Google Search Linda Z on Twitter: "Disney created 3 rooms to nurture creativity: • Room 1: generate ideas with no restraints • Room 2: organize ideas into storyboard • Room 3: savagely review storyboard to cut the fat To build anything, indulge in your dreamer, bring out your realist, call on your critic" / Twitter

Php

 @cehabhishek
Fixing Laravel / PHP 8 “Error : Unknown named parameter” error – Chris Lloyd How can I run specific migration in laravel create model migration and controller using single line in laravel Date Format for laravel blade codeigniter join query

R

 @fededeleon
r - plotly: Updating data with dropdown selection - Stack Overflow Classifying Wines by Data Mining from Physicochemical Properties r - How to use size and decay in nnet - Stack Overflow

Spark

 @anoopsugur
Convert Map keys to columns in dataframe Sum across a list of columns in Spark dataframe Spark Extracting Values from a Row The different type of Spark functions (custom transformations, column functions, UDFs) How to Add Multiple Columns in Dataframes (and How Not to) Store custom objects in Dataset

n8n

 @Tephlon
Iterate JSON Object

CSS tricks

 @Akhil
adding margin to a list and removing the last child's margin adding margin to a list and removing the last child's margin Usage of CSS selectors

CSS - Tools

 @gorlanova
CSS - Text outline

CSS

 @Daphne
CSS: Pijl 'Back to top' aan rechterkant WooCommerce Products 100% width (Mobile)

.zsh

 @stephlaf
zsh Folder permission "Insecure completion-dependent directories detected"

Puppet

 @FlorianC
Trigger manual run of the Puppet agent on Linux

Úvod do Kotlin Coroutines

 @GoodRequest.
# Routine vs Coroutine - Plain text Routine vs Coroutine - Thread Kotlin Routine vs Coroutine - RxJava Kotlin Coroutine - Kotlin Coroutine - Plain text

Abap

 @uxkjaer
dynamic loop at group by Loop at Group by with reference field symbol challenge | SAP Community internal table copy corresponding with mapping

CSS

 @webzth
CSS shorthand property names - MDN

JS

 @Pepe
Switch statement vs Object Search map() & .reduce() Methods for merging (aka concatenating) arrays Promises Promise.all vs Promise.allSettled Array: .map() vs .filter() vs .reduce() Multiple Condition Checks

reby-maintenance

 @alvaroferrer
vehicle repair and diagnostics (redash)

Lab05

 @latifa_amaireh
calc , problem 5 calc , problem 1 calc , problem 2 Calc , problem 3 calc , problem 4 calc , problem 3 , ||

Multidimensional Arrays

 @FabHol
Multisort

Wordpress

 @illker
update prices sql Wordpress

Server

 @nhatphan108
Executing Remote Ansible Check if service is running on Mac

HTML/CSS

 @Sensei_p
Fetch Data, Loops through Array and adds to the DOM

Structured Data

 @sherpablog
Structured Data #1 Structured Data #3 Structured Data #4 Structured Data #5

Arayüz geliştirme sürecinde SEO konusunun incelikleri

 @sherpablog
1 2 3 4 5 6 7 8 9 10 11 12

Python

 @LC117
basic plot

Docker

 @FlorianC
Some Docker commands

Nginx

 @FlorianC
Some Nginx commands

UI components

 @fabosoftadmin
Add A Button Add A Button

C++

 @nhatphan108
Calculate time in C++ Calculate time in C++

Python Course

 @zircon
how function work

VBA

 @mrgvp
PPT manipulation VBA

PowerShell

 @Jazz
Bulk replace whitespaces of folders and files in directory Bulk replace whitespaces of folders and files in directory powershell - Start-Process -WorkingDirectory as administrator does not set location - Stack Overflow powershell - Start-Process -WorkingDirectory as administrator does not set location - Stack Overflow

JavaScript / TypeScript

 @Jazz
javascript - Replace spaces with dashes and make all letters lower-case - Stack Overflow

General

 @santoshduvvuri
JavaScript string encryption and decryption? - Stack Overflow

Javascript

 @santoshduvvuri
JavaScript string encryption and decryption? - Stack Overflow

Blog

@GoodRequest.
profily

- CSS

 @MiaFolio
Ensuring the correct vertical position of large text

- TYPOGRAPHY

 @MiaFolio
Ensuring the correct vertical position of large text OpenType Feature Database font-variant-alternates - CSS: Cascading Style Sheets | MDN OpenType font features guide - CSS: Cascading Style Sheets | MDN Introduction List of typographic features - Wikipedia

Linux

 @zircon
Manual Installation

Constraint Layout II.

 @GoodRequest.
Constraint layout Placeholder Kotlin Constraint layout Placeholder-Kotlin Constraint layout Flow Kotlin Constraint layout Flow-Kotlin Constraint layout Flow with differences for first and last chain Kotlin Constraint layout Flow - with other attributes Kotlin Constraint layout Bonus - Circular posiotioning - Kotlin Constraint layout Circular positioning Kotlin

Test Models Post

 @opencv
Initialize model Process sample ModelTest Assert pytest sample integration test

Emotion Recognition Using OAK Post

 @opencv
OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition OpenCV.AI Blog OAK Emotion Recognition

Docker

 @zach
Getting Started

C++ Maps

 @wowza12341
How are multimaps useful Explanation why copy constructors are called when custom objects are map values Use of List inside map C++ - Stack Overflow Why do we need default constructors when setting objects as key values Why do we need default constructors when setting objects as key values Why do we need default constructors when setting objects as key values Why do we need default constructors when setting objects as key values

Power BI

 @tristanmoreno
Extended Date Table (Power Query M function) - M Code Showcase - Enterprise DNA Forum Tabular Editor Script to Set Summarization to None on SELECTED Columns in Model

MC JS

 @mmerkley
Build an Array Dynamically selector doesn't exist yet compare UTC date does item exist in array map items in array example get user timezone offset Arrow Functions Destructure Object for use in function get query params

java ahmed

 @ahmedqgqgq
Escape Sequences Escape Sequences datatypes datatypes Arithmetic Operators. Arithmetic Operators (Prefix & Postfix). #06 [JAVA] - Java User Input (Scanner), Printf methods Selection Statement ( if - if else - if else if ) 08 [JAVA] - Selection Statement ( Exercises, Practice, Ternary Operator ), Instanceof Method #09 [JAVA] - Selection Statement (Switch Statements) Repetition Control Statement (While Loop) Sentinel and Flag-Controlled While Loops Repetition Control Statement (Do-While Loop) Repetition Control Statement (For Loop) Repetition Control Statement (For Loop) Questions and Exercises in Loops. Branching Statements ( Break/Continue ). Repetition Control Statement (Nested Loops) Branching Statements (Labeled Break / Labeled Continue) Method / Function Part 1 Method / Function Part 2 - Built in Method / Function Overloading Method / Function Recursion/Recursive Methods Part 1 Recursion/Recursive Methods Part 2 One Dimensional Arrays (1D Array) One Dimensional Arrays (1D Array).new One Dimensional Array (Exercises, Practice)Exercises. One Dimensional Array (Char Array)char arrays, One Dimensional Array (Char Array)char arrays, Passing Arrays to Methods.(Arrays) Multidimensional Arrays & Passing Multidimensional Arrays to Methods String & Array String. methods String & Array String. methods

ACCESSIBILITY

 @MiaFolio
How-to: Accessible heading structure - The A11Y Project

Wordpress

 @zircon
ClustrMaps: Globe Widget Code for darsghah.com Theme Options ‹ DarsGhah — WordPress Theme Options ‹ DarsGhah — WordPress

aria-label ve role kullanımı

 @sherpablog
1 2 3 4 5 6

Sık kullanılan CSS birimleri

 @sherpablog
1 2

Javascript

 @Djordje
Marina: This is test

CSS Debugging

 @SabrinaAMM
Outlines images without alt text

React Native

 @arsal
solved login App.js new with api

CSS

 @benjaminb
visibility css html - display: inline-block extra margin - Stack Overflow css - Float right and position absolute doesn't work together - Stack Overflow hero image specificity how to use classes and ids in syntax Writing Efficient CSS Writing Efficient CSS html - Make body have 100% of the browser height - Stack Overflow css - Does height and width not apply to span? - Stack Overflow Positioning with Floats float clearfix clear both float clearfix clear both Floats Tutorial | HTML html - Stretch image input and then fit to its container's width - Stack Overflow footer small size nice looking font Myriad set pro vertical align img p How to center text with image in P tag reset css customized How to use CSS Breakpoints & Media Query Breakpoints | BrowserStack media breakpoints Bootstrap 4.6.0 the default breakpoints radio button with image

C++

 @markefontenot
C++17 Filesystem high_resolution_clock::now - C++ Reference What is the meaning of a C++ Wrapper Class? - Stack Overflow

PYTHON

 @mrgvp
Prevent PYTHON pdf to csv

CSS Tricks

 @fabiangregoire
Responsive iframe class

TypeScript

 @Etzeo
TypeScript Enum to keyof Enum Array

assignment java

 @ahmedqgqgq
assignment passwordprogram. java table Write a program that reads an unspecified number of scores and, scores write a program that computes weekly hours for each employee weekly hours for each employee: hh gcd sum of the series. recursive number

JSON | 1Doc

 @zlucxie
Cotrijal 2 Original Cotrijal 3 Original Cotrijal CPR 4 Original Base premaom CDL Florianopolis 2

MasterControl

 @codebeagle
API URL Endpoint for Document Download Add video to case study page hero

Oculus code

 @SteamWolf
Tubegamerpro12 (u/Tubegamerpro12) - Reddit AirLink.bat

Dart/Flutter

 @theanonymost
Hex String to Color in Flutter

Charts

 @MattMoniz
Recharts React Simple Maps — Trigger geography highlights on hover - CodeSandbox

JavaScript

 @shm1ckle
Image Stretch for Elementor Columns

styles

 @ndowkunda
box shadow examples HTML: How to make a submit button with text + image in it? - Stack Overflow HTML: How to make a submit button with text + image in it? - Stack Overflow

Algorithms and Data Structures- Group project

 @Will2power
Java input sanner

Коллекция-2

 @MaksIT
Сформировать прямоугольник с закругленными краями

tests

 @ndowkunda
Select <input> by its label · Issue #8213 · cypress-io/cypress

Note

 @nata
Objects

Profanity Filtered muted

 @travislibby
Profanity Filtered muted

Bash Scripting

 @LavenPillay
Bash Option Menu Bash - Check for arguments List recently modified files recursively bash - Read file line by line into var

file

 @ahmedqgqgq
file file2 filedd

linux

 @zhwalker
How to Install GCC Compiler on Ubuntu 18.04 | Linuxize update-alternatives How to Remove (Delete) Directory in Linux | Linuxize scripting - How can I save password,when using SCP (copy)? - Unix

Angular Commands

 @JamonJamon
console.logs form input on changes Angular Commands

CSS

 @ycljcfer
浏览器默认css样式清除 浏览器默认css样式清除 CSS 文字装饰 -下划线 CSS 文字装饰 text-decoration & text-emphasis · Issue #103 · chokcoco/iCSS CSS设置文字与装饰线颜色分离text-decoration-color 与 color 分离 CSS文字和装饰线动画 CSS 文字装饰 text-decoration & text-emphasis CSS 文字装饰 text-decoration & text-emphasis · Issue #103 · chokcoco/iCSS CSS 文字装饰background模拟下划线 CSS 文字装饰 background模拟虚线 CSS 文字装饰-巧妙改变 background-size 与 background-position 实现文字 hover 动效 CSS 文字装饰-改变 background-position 实现文字 hover 动效(反向效果) CSS 文字装饰 下划线变色效果的实现 CSS 传统方式实现直线路径动画 CSS 传统方式实现曲线路径动画 CSS Motion Path 实现直线路径动画 CSS Motion Path 实现波浪形路径动画 CSS Motion Path 实现曲线路径动画 CSS三角形的实现 CSS-offset-anchor 运动锚点 利用 Motion Path 制作按钮点击撒点效果 Button Animation with CSS Offset Paths Button Animation with CSS Offset Paths 汽车地图行驶效果 利用 Motion-Path 绘制路径动画 Notebook theme - FoldingText Theme demonstrating multiple header styles - FoldingText How to install a theme? - FoldingText

Markdown

 @ycljcfer
Mermaid横向流程图 Mermaid竖向流程图 Flow标准流程图 Flow标准流程图源码格式（横向） UML-sequence时序图源码样例 UMLsequence时序图源码复杂样例 UML-Mermaid标准时序图样例 Mermaid甘特图样例

HTML

 @ycljcfer
通过link导入网络字体资源到HTML文件 CSS 文字装饰background模拟下划线 CSS 文字装饰 background模拟虚线 CSS 文字装饰-巧妙改变 background-size 与 background-position 实现文字 hover 动效 CSS 文字装饰-改变 background-position 实现文字 hover 动效(反向效果) CSS 文字装饰 下划线变色效果的实现 CSS 传统方式实现直线路径动画 CSS 传统方式实现曲线路径动画 CSS Motion Path 实现曲线路径动画 Button Animation with CSS Offset Paths Button Animation with CSS Offset Paths 汽车地图行驶效果 利用 Motion-Path 绘制路径动画

databases

 @ndowkunda
Create new postgres super user

Java vs Kotlin

 @GoodRequest.
Java Kotlin Kotlin Copy Null safety Java Null safety Kotlin Rýchlosť Java Rýchlosť Kotlin Rýchlosť Kotlin

ahmed filesc++

 @ahmedqgqgq
Disk file I/O with Streams //Read from the file. file 1 2 3 4 6 5555 eeeee gggg 33

JavaScript Objects

 @MattMoniz
javascript - Adding brackets [] to the attribute in setState - Stack Overflow

monroecc

 @jamie
Fetch fcc.org user curriculum progress

Math

 @zhangboheng
fibonacci in javascript without recursion Code Example

Docker

 @LavenPillay
Specify DockerFile for build

Github

 @goranbloncar
Remove folder from origin

javascript

 @JamonJamon
Delete item from an array

typescript

 @JamonJamon
TypeScript remove item from array console.logs form input on changes

JSON

 @ycljcfer
Button Animation with CSS Offset Paths Button Animation with CSS Offset Paths

a1 course

 @benjaminb
JS A1 course example Sum numbers sum 10 numbers random numbers function

Eyeconic

 @distantskunk
Promo Tile names Promo Tile names Background Image Link Example

React Native new

 @arsal
App.js Home.js

Links

 @arsal
Fetch Api in 6 minutes Form Validation in React Native Tutorial fetch api custom drwaer Drawer Navigator Tutorial in React Navigation v5 Links spank

VisualStudio

 @mvieira
Keyboard shortcuts to become a VS Code ninja

Links

 @Pomroka
Rust API Guidelines Rust Design Patterns

Rust

 @Pomroka
The Rust Performance Book Rust API Guidelines Rust Design Patterns

Apps Scripts

 @admariner
CVNX notation of a domain name

Kubernetes

 @admariner
Install and Set Up kubectl on Windows | Kubernetes Install and Set Up kubectl on Windows | Kubernetes

Cognigy

 @admariner
Clone a Virtual Agent – Cognigy.AI Help Center

Python

 @javanegas
print vs ppritn

Powershell

 @javanegas
Reset network Wsl Internet connection issue

Zshh

 @admariner
How to Install Oh My Zsh! on Windows 10 Home Edition - DEV Community How to Install Oh My Zsh! on Windows 10 Home Edition - DEV Community How to Install Oh My Zsh! on Windows 10 Home Edition - DEV Community

shell tips

 @hbillig
dotfiles/.aliases at main · mathiasbynens/dotfiles · GitHub

Command Line Stuff

 @markefontenot
Nvim-qt Settings on Windows 10 - jdhao's blog

HTML

 @Daphne
HTML: pijl 'back to top' aan rechterkant

trailhead-lwc

 @powercod35
Create a Hello World Lightning Web Component Unit | Salesforce Execute SOQL and SOSL Queries Unit | Salesforce Trailhead Execute SOQL and SOSL Queries Unit CONTACT | Salesforce Trailhead

salesforce

 @powercod35
trailheadapps/ebikes-lwc: Sample application for Lightning Web Components and Communities on Salesforce Platform. Part of the sample gallery. Retail use case. Get inspired and learn best practices. Execute SOQL and SOSL Queries Unit | Salesforce Trailhead Execute SOQL and SOSL Queries Unit CONTACT | Salesforce Trailhead

Laravel

 @thejasonparker
Vertical videos in Elementor & Vimeo

Elementor

 @thejasonparker
Vertical videos in Elementor & Vimeo

React Native 4-May-2021

 @arsal
App.js Login.js Home.js Signup.js Drawer.js FormValidation.js FlatList_Api.js FlatList.js Func_comp

Git

 @codeplay
git tag - How can I move a tag on a git branch to a different commit? - Stack Overflow Format git commit to include the JIRA ticket Setting your branch to exactly match the remote branch

HTML

 @279898
Image tag <img> to insert images Мягкий перенос в HTML Неразрывный пробел

pyspark

 @ncellepola
Group by with aggregation pyspark dataframe column unique count

JavaScript

 @misho
document.getElementByIdが効かないとき

Twilio

 @faheem
Twilio Conversations Quickstart - Twilio

GPT

 @faheem
gpt-2-simple · PyPI

Python

 @ncellepola
Python Read Pickle Python Python default dict in python python Counter python swap variable

BoldBrush

 @slendabilt
Remove Discount Code Move Blog Images Above Excerpts Target Specific Element Add Custom Code Try/Catch

UNITY 2D

 @djcokie
Movimento ESQUERDA-DIREITA Unity 2D (Plataformer) - PC

CSS

 @richard
Creating Custom Form Checkboxes and Radio Buttons with Just CSS! | InsertHTML Transitions on the CSS display property - Stack Overflow Custom max-width for container · Issue #1102 · tailwindlabs/tailwindcss

Elementor

 @Alz
Elementor Form Block Eric Jones Email Spam Disable Google Fonts in Elementor Disable Font Awesome in Elementor Disable Eicons in Elementor Fix Qout in WP + Elementor - Disable wptexturize Post Views in Wordpress Dashboard

Woocomerce

 @Alz
Make postal code / zip code optional Search by SKU function Set WooCommerce Virtual Order Status to Complete After Payment How to add plus + and minus – buttons to the quantity input on the product page in WooCommerce Add product images to WooCommerce order emails Adds SKUs and product images to WooCommerce order emails Remove WooCommerce Generator tag, styles, and scripts from non WooCommerce pages Adds image to WooCommerce order emails Show Total Savings on Cart & Checkout Page in WooCommerce Remove Shipping Information on Virtual Products

Speed Optimization

 @Alz
Disable Google Fonts in Elementor Disable Font Awesome in Elementor Disable Eicons in Elementor Remove Gutenberg Block Library CSS from loading on the frontend Add "clear cache" option to shop owner role in WPRocket

React

 @sarawoods
GET request in ruby on rails

Ruby

 @sarawoods
GET request in ruby on rails

React

 @Makucg
Getting Started - Materialize

Datasette

 @admariner
calmcode - learn Datasette calmly - Introduction

React Native

 @govi
reactjs - React native- Best way to create singleton pattern - Stack Overflow

git

 @LavenPillay
git - Show branches with committer Name and commit Date

SEO Ruler

 @admariner
Get Keyword Suggestions into Google Sheets with Grow Keywords API

JAVA

 @anoopsugur
Finding all classes implementing a specific interface Library for Java classes implementing an interface

Kotlin

 @Lukatjee
List adapter Key listener Standard activity

Formula

 @minercreep
Map a range of number to another range of number

FINOS Perspective

 @admariner
JavaScript User Guide · Perspective

Arrays in JS

 @kanu_e
Shows how array filter() method works Shows how array filter() method works Shows how array find() method works

LottieFiles

 @digitalverve
Play a list of Lottie animations in a sequence - CodeSandbox

Personal Projects

 @slendabilt
Create New Laravel Project Authentication and Vue Scaffolding Make Model and Migration File Create A CRUD Resource Controller Display Errors in View Validate Request in Controller Implement Model in Controller and Allow Mass Assignment Create and Display Flash Message Create Custom Request Create Many-To-Many Relationship Create Middleware to Verify Admin

ווקומרס

 @Shesek
כמה עוד נשאר למשלוח חינם גם לעגלה ולצקאאוט הוספת צ'קבוקס לאישור דיוור בצ'קאאוט הסתרת אפשרויות משלוח אחרות כאשר משלוח חינם זמין דילוג על מילוי כתובת במקרה שנבחרה אפשרות איסוף עצמי הוספת צ'קבוקס לאישור דיוור בצ'קאאוט שינוי האפשרויות בתפריט ה-סידור לפי בווקומרס שינוי הטקסט "אזל מהמלאי" הערה אישית לסוף עמוד העגלה הגבלת רכישה לכל המוצרים למקסימום 1 מכל מוצר קבלת שם המוצר לפי ה-ID בעזרת שורטקוד הוספת כפתור וואטסאפ לקנייה בלופ ארכיון מוצרים הפיכה של מיקוד בצ'קאאוט ללא חובה מעבר ישיר לצ'קאאוט בלחיתה על הוספה לסל (דילוג עגלה) התראה לקבלת משלוח חינם בדף עגלת הקניות גרסה 1 התראה לקבלת משלוח חינם בדף עגלת הקניות גרסה 2 קביעה של מחיר הזמנה מינימלי (מוצג בעגלה ובצ'קאאוט) העברת קוד הקופון ל-ORDER REVIEW העברת קוד הקופון ל-ORDER REVIEW Kadence WooCommerce Email Designer קביעת פונט אסיסנט לכל המייל בתוסף מוצרים שאזלו מהמלאי - יופיעו מסומנים באתר, אבל בתחתית הארכיון הוספת כפתור "קנה עכשיו" למוצרים הסתרת אפשרויות משלוח אחרות כאשר משלוח חינם זמין שיטה 2 שינוי סימן מטבע ש"ח ל-ILS להפוך סטטוס הזמנה מ"השהייה" ל"הושלם" באופן אוטומטי תצוגת הנחה באחוזים שינוי טקסט "בחר אפשרויות" במוצרים עם וריאציות חיפוש מוצר לפי מק"ט שינוי תמונת מוצר לפי וריאציה אחרי בחירה של וריאציה אחת במקרה של וריאציות מרובות הנחה קבועה לפי תפקיד בתעריף קבוע הנחה קבועה לפי תפקיד באחוזים הסרה של שדות משלוח לקבצים וירטואליים הסתרת טאבים מעמוד מוצר הצגת תגית "אזל מהמלאי" בלופ המוצרים להפוך שדות ל-לא חובה בצ'קאאוט שינוי טקסט "אזל מהמלאי" לוריאציות שינוי צבע ההודעות המובנות של ווקומרס הצגת ה-ID של קטגוריות המוצרים בעמוד הקטגוריות אזל מהמלאי- שינוי ההודעה, תגית בלופ, הודעה בדף המוצר והוספת אזל מהמלאי על וריאציה הוספת שדה מחיר ספק לדף העריכה שינוי טקסט אזל מהמלאי תמונות מוצר במאונך לצד תמונת המוצר הראשית באלמנטור הוספת כפתור קנה עכשיו לעמוד המוצר בקניה הזו חסכת XX ש''ח לאפשר למנהל חנות לנקות קאש ברוקט לאפשר רק מוצר אחד בעגלת קניות הוספת סימון אריזת מתנה ואזור להוראות בצ'קאאוט של ווקומרס הצגת הנחה במספר (גודל ההנחה) הוספת "אישור תקנון" לדף התשלום הצגת רשימת תכונות המוצר בפרונט שינוי כמות מוצרים בצ'קאאוט ביטול השדות בצ'קאאוט שינוי כותרות ופלייסהולדר של השדות בצ'קאאוט

מערכת (wp-config)

 @Shesek
הוספת תיקיית סל מחזור למדיה שינוי הגבלת הזיכרון בשרת הוספת תמיכה בקבצי VCF באתר (קבצי איש קשר VCARD) - חלק 2 לאפשר שם משתמש בעברית

PackagingBox Post

 @opencv
DepthAI Pipeline configuration for depth and RGB image data Base Depth Estimation Package Contour Detection Package dimension and Volume Estimation

Pagebuilder

 @Sikor
Pagebuilder - repeater double / repeater in repeater PAGEBUILDER - repeater simple

javascript

 @Sikor
Animation - go to section jQuery .css() many Menu - autogenerated menu from sections with scroll to section magicScroll + animate.css

WP basics

 @Sikor
WP_Query Wordpress images register CPT + register taxonomy + custom permalink

Airflow

 @admariner
Running Airflow in Docker — Airflow Documentation

APIs

 @santiagogab
INDEC Query Function BCRA Query

curl

 @admariner
cURL for SEO - DataBulle cURL for SEO - DataBulle

Python

 @admariner
validation - In python, how to check if a date is valid? - Stack Overflow How to upload a video to YouTube using YouTube Data API in Python - Learn Data Analysis 22 Useful Snippets to Code like a Pro in Python | by Haider Imtiaz | May, 2021 | Python in Plain English 22 Useful Snippets to Code like a Pro in Python | by Haider Imtiaz | May, 2021 | Python in Plain English

React

 @misho
React routerで表示を切り替える（Navで選択した内容をメインエリアに表示する）

Data Structures and Algorithms

 @anvarbek