<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">×</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>