i trying simple save of data database. have form in modal.
when try save data database, not save. if place form out of modal save data database.
i have googled solution found none. submit button in form, thats not causing issue.
php code:
<?php ini_set('display_errors', 'on'); error_reporting(e_all | e_strict); session_start(); include 'config.php'; if(!isset($_session['user_id'])) { header("location: login.php"); } //read out data db $query_string = "select * tbl_category"; $query = mysqli_query($con, $query_string); //save data db if(isset($_post['savecategory'])){ $category = mysqli_real_escape_string($con, $_post['category']); $query = "insert tbl_category(category) values('$category')"; $result = mysqli_query($con, $query); if(!$result){ echo mysqli_error(); } else{ $category = ''; echo "yes"; } } ?>
my config.php file:
<?php $con = mysqli_connect("localhost", "root", "root", "challenger") or die("error " . mysqli_error($con)); // if($con){ // echo"there connection"; // } ?>
part of html code:
<!-- page content --> <div id="page-wrapper"> <div class="container-fluid"> <div class="row bg-title"> <div class="col-lg-3 col-md-4 col-sm-4 col-xs-12"> <h4 class="page-title">category</h4> </div> <div class="col-lg-9 col-sm-8 col-md-8 col-xs-12"> <ol class="breadcrumb"> <li><a href="#">category</a></li> <li><a href="#" class="active">category</a></li> </ol> </div> <!-- /.col-lg-12 --> </div> <!-- /row --> <div class="row"> <div class="col-sm-12"> <div class="white-box"> <h3 class="box-title m-b-0">overview category</h3> <button class="btn btn-danger btn-outline pull-right" data-toggle="modal" data-target="#addcategory">add category</button> <br><br><br> <table id="mytable" class="table table-striped"> <thead> <tr> <th>number</th> <th>category</th> </tr> </thead> <tbody> <?php while($row = mysqli_fetch_assoc($query)){ echo "<tr>"; echo "<td>".$row['category_id']."</td>"; echo "<td>".$row['category']."</td>"; echo "</tr>"; } ?> </tbody> </table> </div> </div> <!-- modal window --> <div class="modal fade" id="addcategory" tabindex="-1" role="dialog" aria-labelledby="examplemodallabel1"> <div class="modal-dialog" role="document"> <div class="modal-content"> <div class="modal-header"> <button type="button" class="close" data-dismiss="modal" aria-label="close"><span aria-hidden="true">×</span></button> <h4 class="modal-title" id="examplemodallabel1">add new category</h4> </div> <div class="modal-body"> <form action="<?php echo $_server['php_self']; ?>" method="post"> <div class="form-group"> <label for="recipient-name" class="control-label">category name:</label> <input type="text" class="form-control" id="recipient-name1" name="category"> </div> <div class="modal-footer"> <button type="button" class="btn btn-default" data-dismiss="modal">close</button> <button type="submit" class="btn btn-primary" name="savecategory" data-dismiss="modal">create category</button> </div> </form> </div><!-- end modal body --> </div> </div> </div> <!-- end modal window --> </div> <!-- /.row --> </div> <!-- /.container-fluid --> </div> <!-- /end page content -->
change
$query = "insert tbl_category(category) values('$category')";
to this
$query = "insert tbl_category(`category`) values('$category')";
Comments
Post a Comment