<!-- Step-1 : fetch data in drop down box in add-post.php file Make Connection and Fetch Data -->
<!-- Step-* : manually add some data in catagory table and fetch it form DB,f12 show catagory_id and catagory_name in the source -->
<!-- Step-2 : on submit , processes the data on save-post.php -->
<?php include "header.php"; ?>
<div id="admin-content">
<div class="container">
<div class="row">
<div class="col-md-12">
<h1 class="admin-heading">Add New Post</h1>
</div>
<div class="col-md-offset-3 col-md-6">
<!-- Form -->
<!-- Step-2 : on submit , processes the data on save-post.php -->
<form action="save-post.php" method="POST" enctype="multipart/form-data">
<div class="form-group">
<label for="post_title">Title</label>
<input type="text" name="post_title" class="form-control" autocomplete="off" required>
</div>
<div class="form-group">
<label for="exampleInputPassword1"> Description</label>
<textarea name="postdesc" class="form-control" rows="5" required></textarea>
</div>
<div class="form-group">
<label for="exampleInputPassword1">Category</label>
<select name="category" class="form-control">
<option disabled> Select Category</option>
<!-- Step-1 : fetch data in drop down box in add-post.php file Make Connection and Fetch Data -->
<?php
/* include "config.php"; // alreay add via header file */
$sql = "SELECT * FROM category";
$result = mysqli_query($conn, $sql) or die("Query Failed.");
if(mysqli_num_rows($result) > 0){
while($row = mysqli_fetch_assoc($result)){
echo "<option value='{$row['category_id']}'>{$row['category_name']}</option>";
}
}
?>
</select>
</div>
<div class="form-group">
<label for="exampleInputPassword1">Post image</label>
<input type="file" name="fileToUpload" required>
</div>
<input type="submit" name="submit" class="btn btn-primary" value="Save" required />
</form>
<!--/Form -->
</div>
</div>
</div>
</div>
<?php include "footer.php"; ?>