(WEB Dev Beginner) I am having trouble with PHP. Everytime I want to insert a new post using my admin panel, the data I entered won't insert on my database table that I use. Also, no errors are shown when I visit my insert new post page so I don't know how fix the problem. This is my insert post page:
<?php
session_start();
if(!isset($_SESSION['user_name'])){
header("location: login.php");
}
else {
?>
<!DOCTYPE html>
<html lang="en">
<?php include("admin-includes/admin-head.php"); ?>
<title>Insert Post - Water District Android Meter Reader</title>
<body>
<div id="wrapper">
<!-- Navigation -->
<nav class="navbar navbar-inverse navbar-fixed-top" role="navigation">
<!-- Brand and toggle get grouped for better mobile display -->
<div class="navbar-header">
<button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="index.php">Admin Panel - Water District Android Meter Reader</a>
</div>
<?php include("admin-includes/admin-header-dropdown.php"); ?>
<?php include("admin-includes/admin-sidebar.php"); ?>
<div id="page-wrapper">
<div class="container-fluid">
<div class="row">
<div class="col-lg-12">
<h1 class="page-header">
Welcome
<small>Admin!</small>
</h1>
<ol class="breadcrumb">
<li><a href="#" style="text-decoration:none;">Insert Post</a></li>
<li><a href="view_posts.php" style="text-decoration:none;">View Post</a></li>
</ol>
<form class="sms-demo" method="post" action="insert_post.php" enctype="multipart/form-data">
<table style="width:100%;" bgcolor="white" align="center" class="sms-demo" >
<tr>
<td align="center" bgcolor="#3399cc" colspan="6"><h1>Insert New Post</h1></td>
</tr>
<tr>
<td align="right">Post Title:</td>
<td><input type="text" name="title" size="30" style="width:90%;"></td>
</tr>
<tr>
<td align="right">Post Keywords:</td>
<td><input type="text" name="keywords" size="30" style="width:90%;"></td>
</tr>
<tr>
<td align="right">Post Image:</td>
<td><input type="file" name="image" style="width:100%;"></td>
</tr>
<tr>
<td align="right">Post Content:</td>
<td><textarea name="content" rows="15" style="width:100%;"></textarea></td>
</tr>
<tr>
<td align="center" colspan="6"><input type="submit" name="submit" style="width:100%;" value="Publish Now"></td>
</tr>
</table>
</form>
</div>
</div>
</div>
<!-- /.container-fluid -->
</div>
<!-- /#page-wrapper -->
</div>
<!-- /#wrapper -->
<?php include("admin-includes/admin-scripts.php"); ?>
</body>
</html>
<?php
include("admin-includes/connect.php");
include("admin/connect.php");
if(isset($_POST['submit'])){
$post_title = $_POST['title'];
$post_keywords = $_POST['keywords'];
$post_content = $_POST['content'];
$post_image = $_FILES['image']['name'];
$image_tmp = $_FILES['image']['tmp_name'];
if($post_title=='' or $post_keywords=='' or $post_content=='' ){
?><script> alert('Any of the fields is empty')</script>
<?php
exit();
}
else {
move_uploaded_file($image_tmp,"../images/$post_image");
$insert_query = "INSERT INTO posts (post_title,post_image,post_keywords,post_content) VALUES ('$post_title','$post_image','$post_keywords','$post_content')";
if($conn->mysql_query($insert_query)===TRUE){
?>
<script>alert('post published successfuly')</script>
<script>window.open('view_posts.php',)</script>
<?php
}
}
}
?>
<?php } ?>
That situation is the same with my other pages that has data entry required. Please help me. I need the solution immediately. Thanks!
Aucun commentaire:
Enregistrer un commentaire