<?php include 'header.php'; ?>
    
<main id="main-container">              
    <div class="content content-narrow">
        <div class="row">
            <div class="col-lg-12">
                            <!-- Bootstrap Forms Validation -->
                <h2 class="content-heading">Add Details</h2>
					<?php  
                        $curDate = date('Y-m-d H:i:s', strtotime('+5 hour +30 minutes'));
                        if(isset($_REQUEST['submit'])){
                            $exam_name = $_REQUEST['exam_name'];
                            $category = $_REQUEST['category'];
                            $title = $_REQUEST['title'];
                            $keywords = $_REQUEST['keywords'];
                            $meta_key = $_REQUEST['meta_key'];
                            $meta_desc= $_REQUEST['meta_desc'];

                         $query="insert into sp_pages_seo set exam_id='$exam_name', category_id='$category', title='$title', keywords='$keywords', meta_description='$meta_desc', meta_keywords='$meta_key', status='1', added_date='$curDate'";
                        $sql=$db->prepare($query);
                        if($sql->execute()){
                        echo '<h3 style="color:#000000;">Data submit successfully</h3>';
                            }
                        } ?>

                <div class="block">
                    <div class="block-header">
                        <ul class="block-options">
                            <li>
                                <button type="button"><i class="si si-settings"></i></button>
                            </li>
                        </ul>
                      <h3 class="block-title"></h3>
                    </div>

                    <div class="block-content block-content-narrow">
                        <form class="js-validation-bootstrap form-horizontal" action="add_seo_content" method="post" id="form">
                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-username">Exam Name<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <select class="js-select2 form-control" name="exam_name" style="width: 100%;">
                                            <?php 
                                            $sql = $db->prepare("SELECT exam_id,exam_name FROM sp_exam");
                                            $sql->execute();
                                            ?>
                                        <option selected="selected">--Select exam--</option>
                                            <?php  while($row=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
                                        <option value="<?php echo $row['exam_id']; ?>"><?php echo $row['exam_name']; ?></option>
                                            <?php  } ?>
                                    </select>
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-email">Exam Category<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <select class="js-select2 form-control" name="category" style="width: 100%;">
                                        <?php 
                                            $sql = $db->prepare("SELECT cat_id,name FROM sp_exam_category");
                                            $sql->execute(); 
                                        ?>
                                        <option selected="selected">--Select category--</option>
                                            <?php while($row=$sql->fetch(PDO::FETCH_ASSOC)) { ?>
                                        <option value="<?php echo $row['cat_id']; ?>"><?php echo $row['name']; ?></option>
                                            <?php } ?>
                                    </select>
                                </div>
                            </div>

							<div class="form-group">
                                <label class="col-md-2 control-label" for="val-email">Title<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="title" placeholder="Exam title">
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-email">Keywords<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="keywords" placeholder="exam keywords">
                                </div>
                            </div>

                            <div class="form-group">
                                <label class="col-md-2 control-label" for="val-email">Meta Keywords<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                    <input class="form-control" type="text" name="meta_key" placeholder="exam meta keywords">
                                </div>
                            </div>

                           <div class="form-group">
                                <label class="col-md-2 control-label" for="val-confirm-password">Meta Description<span class="text-danger">*</span></label>
                                <div class="col-md-10">
                                   <textarea class="ckeditor" name="meta_desc" id="editor3"></textarea>
                                </div>
                            </div>
										
							<div class="form-group">
                                <div class="col-md-8 col-md-offset-2">
                                    <button class="btn btn-sm btn-primary" type="submit" name="submit">Submit</button>
                                </div>
                            </div>
                        </form>
                    </div>
                </div>
            </div>
        </div>
    </div>
</main>
	
<?php  include 'footer.php';	?>