July 14, 2019

Dynamic Blog with PHP and MySQL – Dashboard

Dynamic blog dashboard for admin functionality, for managing the articles like create, edit, update and delete the post also user creation and deletion. You have a total count option for posts, categories, and profiles to see in the main dashboard. In the dashboard, you have all access to list the posted articles and if you like to edit or delete the article you can easily manage with the dashboard. Categories also you can add or delete there is an option to do that as same for users. Once you create or update your article you can view the website by clicking the view website in the dashboard.

To see the Dynamic Blog Front View Click here

Preview & Download

login.php

Based on the session here you going to see the login page. For managing articles you need a dashboard but the main thing is security. For that only here, you going to see user login.

<?php
//include config
require_once('../includes/config.php');
//check if already logged in
if( $user->is_logged_in() ){ header('Location: index.php'); } 
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">
    
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" sizes="16x16" href="images/favicon.png">
    <title>Login ~ SoftAOX</title>
    <!-- Bootstrap Core CSS -->
    <link href="css/lib/bootstrap/bootstrap.min.css" rel="stylesheet">
    <!-- Custom CSS -->
    <link href="css/helper.css" rel="stylesheet">
    <link href="css/style.css" rel="stylesheet">
    <!-- HTML5 Shim and Respond.js IE8 support of HTML5 elements and media queries -->
    <!-- WARNING: Respond.js doesn't work if you view the page via file:** -->
    <!--[if lt IE 9]>
    <script src="https:**oss.maxcdn.com/libs/html5shiv/3.7.0/html5shiv.js"></script>
    <script src="https:**oss.maxcdn.com/libs/respond.js/1.4.2/respond.min.js"></script>
<![endif]-->
</head>

<body class="fix-header fix-sidebar">
    <!-- Preloader - style you can find in spinners.css -->
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
			<circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" /> </svg>
    </div>
    <!-- Main wrapper  -->
    <div id="main-wrapper">
          <div class="unix-login">
            <div class="container-fluid">
                <div class="row justify-content-center">
                    <div class="col-lg-4">
                        <div class="login-content card">
                            <div class="login-form" id="login">
                                <h4>Login</h4>
                                  <form action="" method="post">
                                    <div class="form-group">
                                        <label>Email address</label>
                                        <input type="email" class="form-control" name="username" placeholder="Enter your Email ID" value="demo@softaox.com">
                                    </div>
                                    <div class="form-group">
                                        <label>Password</label>
                                        <input type="password" class="form-control" name="password" placeholder="Password" value="12345">
                                    </div>
                                    <!--<div class="checkbox">
                                        <label>
        										<input type="checkbox"> Remember Me
        									</label>
                                        <label class="pull-right">
        										<a href="#">Forgotten Password?</a>
        									</label>

                                    </div> -->
                                    <button type="submit" class="btn btn-primary btn-flat m-b-30 m-t-30" name="submit">Sign in</button>
                                    <div class="register-link m-t-15 text-center">
                                        <!-- <p>Don't have account ? <a href="#"> Sign Up Here</a></p> -->
                                    </div>
                                </form>
                                
                                <?php
									//process login form if submitted
									if(isset($_POST['submit'])){
								
										$username = trim($_POST['username']);
										$password = trim($_POST['password']);
										
										if($user->login($username,$password)){ 
								
											//logged in return to index page
											header('Location: index.php');
											exit;
										
								
										} else {
											$message = '<p class="error" style="color:red; text-align:center;">Incorrect email or password</p>';
										}
								
									}//end if submit
								
									if(isset($message)){ echo $message; }
									?>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </div>
    <!-- End Wrapper -->
    <!-- All Jquery -->
    <script src="js/lib/jquery/jquery.min.js"></script>
    <!-- Bootstrap tether Core JavaScript -->
    <script src="js/lib/bootstrap/js/popper.min.js"></script>
    <script src="js/lib/bootstrap/js/bootstrap.min.js"></script>
    <!-- slimscrollbar scrollbar JavaScript -->
    <script src="js/jquery.slimscroll.js"></script>
    <!--Menu sidebar -->
    <script src="js/sidebarmenu.js"></script>
    <!--stickey kit -->
    <script src="js/lib/sticky-kit-master/dist/sticky-kit.min.js"></script>
    <!--Custom JavaScript -->
    <script src="js/custom.min.js"></script>

</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

<?php

//include config

require_once('../includes/config.php');

//check if already logged in

if( $user->is_logged_in() ){ header('Location: index.php'); }

<!DOCTYPE html>

<head>

<title>Login ~ SoftAOX</title>

<!--[if lt IE 9]>

<![endif]-->

</head>

</div>

<h4>Login</h4>

<label>Email address</label>

</div>

<label>Password</label>

</div>

<!--<div class="checkbox">

<label>

<input type="checkbox"> Remember Me

</label>

<a href="#">Forgotten Password?</a>

</label>

</div> -->

</div>

</form>

<?php

//process login form if submitted

if(isset($_POST['submit'])){

$username = trim($_POST['username']);

$password = trim($_POST['password']);

if($user->login($username,$password)){

//logged in return to index page

header('Location: index.php');

exit;

} else {

$message = '<p class="error" style="color:red; text-align:center;">Incorrect email or password</p>';

}

}//end if submit

if(isset($message)){ echo $message; }

</div>

</body>

</html>

logout.php

The below code will help you to logout from the dashboard. Once you completed all the works in the dashboard, there is an option to logout option once you click the logout it will automatically redirect you to the home page.

<?php
//include config
require_once('../includes/config.php');

//log user out
$user->logout();
header('Location: index.php'); 

?>

<?php

//include config

require_once('../includes/config.php');

//log user out

$user->logout();

header('Location: index.php');

index.php

Here the below code for the dashboard and there is all option for the new post, new category, and new user options from there you can handle the article post easily. You have the advantage to see a total number of posts, profiles, and categories.

<?php
//include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page
if(isset($_GET['delpost'])){ 

	$stmt = $db->prepare('DELETE FROM sa_posts WHERE postID = :postID') ;
	$stmt->execute(array(':postID' => $_GET['delpost']));

	//delete post categories. 
	$stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');
	$stmt->execute(array(':postID' => $_GET['delpost']));

	header('Location: index.php?action=deleted');
	exit;
} 

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Dashboard ~ SoftAOX</title>
  
    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->

<script language="JavaScript" type="text/javascript">
  function delpost(id, title)
  {
	  if (confirm("Are you sure you want to delete '" + title + "'"))
	  {
	  	window.location.href = 'index.php?delpost=' + id;
	  }
  }
  </script>

</head>

<body class="fix-header fix-sidebar">
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">

        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">

            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Dashboard</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Dashboard</li>
                    </ol>
                </div>
            </div>
  
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->

                <div class="row">
                    <div class="col-md-3">
                        <div class="card p-30">
                            <div class="media">
                                <div class="media-left meida media-middle">
                                    <span><i class="fa fa-sticky-note f-s-40 color-primary"></i></span>
                                </div>
                                <div class="media-body media-text-right">
                                    <h2>
                                        <?php    
                                          $nRows = $db->query('select count(*) from sa_posts')->fetchColumn(); 
                                         echo $nRows;
                                        ?>
                                    </h2>
                                    <p class="m-b-0">Total Posts</p>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card p-30">
                            <div class="media">
                                <div class="media-left meida media-middle">
                                    <span><i class="fa fa-list-ul f-s-40 color-success"></i></span>
                                </div>
                                <div class="media-body media-text-right">
                                    <h2><?php    
                                          $nRows = $db->query('select count(*) from sa_categories')->fetchColumn(); 
                                         echo $nRows;
                                        ?>
                                    </h2>
                                    <p class="m-b-0">Total Categories</p>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card p-30">
                            <div class="media">
                                <div class="media-left meida media-middle">
                                    <span><i class="fa fa-users f-s-40 color-warning"></i></span>
                                </div>
                                <div class="media-body media-text-right">
                                    <h2><?php    
                                          $nRows = $db->query('select count(*) from sa_users')->fetchColumn(); 
                                         echo $nRows;
                                        ?></h2>
                                    <p class="m-b-0">Profiles</p>
                                </div>
                            </div>
                        </div>
                    </div>
                    <div class="col-md-3">
                        <div class="card p-30">
                            <div class="media">
                                <div class="media-left meida media-middle">
                                    <span><i class="fa fa-eye f-s-40 color-danger"></i></span>
                                </div>
                                <div class="media-body media-text-right">
                                    <h2><a href="../" target="_blank" class="btn btn-dark btn-xs m-b-10 m-l-5" rel="noopener noreferrer">View Now</a></h2>
                                    <p class="m-b-0">Website</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

                <a href='new-post.php'> <button type="button" class="btn btn-dark m-b-10 m-l-5"><i class="fa fa-sticky-note"></i>  Add Post</button></a>

                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">


                            <div class="card-title">
                                <h4>Recent Post </h4>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">


					                <?php 
									//show message from add / edit page
									if(isset($_GET['action'])){ 
										echo '<h3>Post '.$_GET['action'].'.</h3>'; 
									} 
									?>

                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Title</th>
                                                <th>Categories</th>
                                                <th>Date</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

									  <tbody>
                                          
                                          
                                    
                                    <?php
										try {

											$stmt = $db->query('SELECT * FROM sa_posts ORDER BY postID DESC');
											while($row = $stmt->fetch()){

                                            echo '<tr>';

                                          echo '<td>'.$row['postID'].'</td>';
                                          echo '<td>'.$row['postTitle'].'</td>';
                                          echo '<td>';
                                          $stmt1 = $db->query('SELECT * FROM sa_categories where catID in (select catID from sa_post_categories where postID='. $row['postID'].')');
										  while($row1 = $stmt1->fetch()){

                                          echo $row1['catTitle'];

                                            }
                                            echo '</td>';
                                          echo '<td>'.date('jS M Y', strtotime($row['postDate'])).'</td>';
                                          ?>
                                                <td><a href="edit-post.php?id=<?php echo $row['postID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <a href="javascript:delpost('<?php echo $row['postID'];?>','<?php echo $row['postTitle'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a></td>
                                            
                                            <?php 
												echo '</tr>';

											}

										} catch(PDOException $e) {
										    echo $e->getMessage();
										}
									?>
                                            
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


         </div>


                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
    
    <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->
    
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

<?php

//include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page

if(isset($_GET['delpost'])){

$stmt = $db->prepare('DELETE FROM sa_posts WHERE postID = :postID') ;

$stmt->execute(array(':postID' => $_GET['delpost']));

//delete post categories.

$stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');

$stmt->execute(array(':postID' => $_GET['delpost']));

header('Location: index.php?action=deleted');

exit;

}

<!DOCTYPE html>

<head>

<title>Dashboard ~ SoftAOX</title>

<?php include('includes/css.php');?>

function delpost(id, title)

{

if (confirm("Are you sure you want to delete '" + title + "'"))

{

window.location.href = 'index.php?delpost=' + id;

}

</script>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

<h3 class="text-primary">Dashboard</h3> </div>

<li class="breadcrumb-item active">Dashboard</li>

</ol>

</div>

</div>

<h2>

<?php

$nRows = $db->query('select count(*) from sa_posts')->fetchColumn();

echo $nRows;

</h2>

<p class="m-b-0">Total Posts</p>

</div>

</div>

<h2><?php

$nRows = $db->query('select count(*) from sa_categories')->fetchColumn();

echo $nRows;

</h2>

<p class="m-b-0">Total Categories</p>

</div>

</div>

<h2><?php

$nRows = $db->query('select count(*) from sa_users')->fetchColumn();

echo $nRows;

?></h2>

<p class="m-b-0">Profiles</p>

</div>

</div>

<p class="m-b-0">Website</p>

</div>

<h4>Recent Post </h4>

</div>

<?php

//show message from add / edit page

if(isset($_GET['action'])){

echo '<h3>Post '.$_GET['action'].'.</h3>';

}

<thead>

<tr>

<th>Title</th>

<th>Categories</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

try {

$stmt = $db->query('SELECT * FROM sa_posts ORDER BY postID DESC');

while($row = $stmt->fetch()){

echo '<tr>';

echo '<td>'.$row['postID'].'</td>';

echo '<td>'.$row['postTitle'].'</td>';

echo '<td>';

$stmt1 = $db->query('SELECT * FROM sa_categories where catID in (select catID from sa_post_categories where postID='. $row['postID'].')');

while($row1 = $stmt1->fetch()){

echo $row1['catTitle'];

}

echo '</td>';

echo '<td>'.date('jS M Y', strtotime($row['postDate'])).'</td>';

<td><a href="edit-post.php?id=<?php echo $row['postID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <a href="javascript:delpost('<?php echo $row['postID'];?>','<?php echo $row['postTitle'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a></td>

<?php

echo '</tr>';

}

} catch(PDOException $e) {

echo $e->getMessage();

}

</tbody>

</table>

</div>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

posts.php

You can see the list of articles in the posts page, From here you have an option to edit and delete for every single article.

<?php
//include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page
if(isset($_GET['delpost'])){ 

	$stmt = $db->prepare('DELETE FROM sa_posts WHERE postID = :postID') ;
	$stmt->execute(array(':postID' => $_GET['delpost']));

	//delete post categories. 
	$stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');
	$stmt->execute(array(':postID' => $_GET['delpost']));

	header('Location: index.php?action=deleted');
	exit;
} 

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Posts ~ SoftAOX</title>
    
    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->

<script language="JavaScript" type="text/javascript">
  function delpost(id, title)
  {
	  if (confirm("Are you sure you want to delete '" + title + "'"))
	  {
	  	window.location.href = 'index.php?delpost=' + id;
	  }
  }
  </script>

</head>

<body class="fix-header fix-sidebar">
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
        
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">
	
		
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Posts</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Posts</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->


                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">


                            <div class="card-title">
                                <h4>Recent Post </h4> <a href='new-post.php'> <button type="button" class="btn btn-dark btn-xs m-b-10 m-l-5"><i class="fa fa-sticky-note"></i>  Add Post</button></a>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">


					                <?php 
									//show message from add / edit page
									if(isset($_GET['action'])){ 
										echo '<h3>Post '.$_GET['action'].'.</h3>'; 
									} 
									?>

                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Title</th>
                                                <th>Categories</th>
                                                <th>Date</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

									  <tbody>
                                    
                                    <?php
										try {

											$stmt = $db->query('SELECT * FROM sa_posts ORDER BY postID DESC');
											while($row = $stmt->fetch()){

                                            echo '<tr>';

                                          echo '<td>'.$row['postID'].'</td>';
                                          echo '<td>'.$row['postTitle'].'</td>';
                                          echo '<td>';
                                          $stmt1 = $db->query('SELECT * FROM sa_categories where catID in (select catID from sa_post_categories where postID='. $row['postID'].')');
										  while($row1 = $stmt1->fetch()){

                                          echo $row1['catTitle'];

                                            }
                                            echo '</td>';
                                          echo '<td>'.date('jS M Y', strtotime($row['postDate'])).'</td>';
                                          ?>
                                                <td><a href="edit-post.php?id=<?php echo $row['postID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <a href="javascript:delpost('<?php echo $row['postID'];?>','<?php echo $row['postTitle'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a></td>
                                            
                                            <?php 
												echo '</tr>';

											}

										} catch(PDOException $e) {
										    echo $e->getMessage();
										}
									?>
                                            
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>


              </div>


                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
  
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

<?php

//include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page

if(isset($_GET['delpost'])){

$stmt = $db->prepare('DELETE FROM sa_posts WHERE postID = :postID') ;

$stmt->execute(array(':postID' => $_GET['delpost']));

//delete post categories.

$stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');

$stmt->execute(array(':postID' => $_GET['delpost']));

header('Location: index.php?action=deleted');

exit;

}

<!DOCTYPE html>

<head>

<title>Posts ~ SoftAOX</title>

<?php include('includes/css.php');?>

function delpost(id, title)

{

if (confirm("Are you sure you want to delete '" + title + "'"))

{

window.location.href = 'index.php?delpost=' + id;

}

</script>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

<h3 class="text-primary">Posts</h3> </div>

<li class="breadcrumb-item active">Posts</li>

</ol>

</div>

<h4>Recent Post </h4> <a href='new-post.php'> <button type="button" class="btn btn-dark btn-xs m-b-10 m-l-5"><i class="fa fa-sticky-note"></i> Add Post</button></a>

</div>

<?php

//show message from add / edit page

if(isset($_GET['action'])){

echo '<h3>Post '.$_GET['action'].'.</h3>';

}

<thead>

<tr>

<th>Title</th>

<th>Categories</th>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

try {

$stmt = $db->query('SELECT * FROM sa_posts ORDER BY postID DESC');

while($row = $stmt->fetch()){

echo '<tr>';

echo '<td>'.$row['postID'].'</td>';

echo '<td>'.$row['postTitle'].'</td>';

echo '<td>';

$stmt1 = $db->query('SELECT * FROM sa_categories where catID in (select catID from sa_post_categories where postID='. $row['postID'].')');

while($row1 = $stmt1->fetch()){

echo $row1['catTitle'];

}

echo '</td>';

echo '<td>'.date('jS M Y', strtotime($row['postDate'])).'</td>';

<?php

echo '</tr>';

}

} catch(PDOException $e) {

echo $e->getMessage();

}

</tbody>

</table>

</div>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

new-post.php

If you like to create a new article using the below code you can create with the article title, description, category name, Image upload, etc.,

<?php //include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Add New Post ~ softAOX</title>
    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->
    <script src="//tinymce.cachefly.net/4.0/tinymce.min.js"></script>
     <script>
         tinymce.init({
              selector: "textarea",
              plugins: [
                  "advlist autolink lists link image charmap print preview anchor",
                  "searchreplace visualblocks code fullscreen",
                  "insertdatetime media table contextmenu paste"
              ],
              toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image"
          });
</script>
<style>
/* Custom CSS */
.mce-tinymce {
margin: 0;
padding: 0;
display: block;
border: 1px solid #e3e3e3 !important;
border-top-left-radius: 3px !important;
border-top-right-radius: 3px !important;
border-bottom: 0px !important;
}
</style>
</head>

<body class="fix-header fix-sidebar">
      <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Add Post</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Add Post</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
 
            
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->
                 
                <?php

                    //if form has been submitted process it
                    if(isset($_POST['submit'])){

                        //collect form data
                        extract($_POST);

                        //very basic validation
                        if($postTitle ==''){
                            $error[] = 'Please enter the title.';
                        }

                        if($postDesc ==''){
                            $error[] = 'Please enter the description.';
                        }

                        if($postCont ==''){
                            $error[] = 'Please enter the content.';
                        }
                        
                        if(!isset($error)){

                            try {

                                $postSlug = slug($postTitle);
                                
                                $folder ="uploads/"; 

                                $image = $_FILES['image']['name']; 

                                $path = $folder . $image ; 

                                $target_file=$folder.basename($_FILES["image"]["name"]);


                                 $imageFileType=pathinfo($target_file,PATHINFO_EXTENSION);


                                $allowed=array('jpeg','png' ,'jpg'); $filename=$_FILES['image']['name']; 

                                $ext=pathinfo($filename, PATHINFO_EXTENSION); if(!in_array($ext,$allowed) ) 

                                { 

                                 echo "Sorry, only JPG, JPEG, PNG & GIF  files are allowed.";

                                }

                                else{ 

                                move_uploaded_file( $_FILES['image'] ['tmp_name'], $path); 
                                
                                //insert into database
                                $stmt = $db->prepare('INSERT INTO sa_posts (postTitle,postSlug,postDesc,postCont,postDate,image) VALUES (:postTitle, :postSlug, :postDesc, :postCont, :postDate, :image)') ;
                                $stmt->execute(array(
                                    ':postTitle' => $postTitle,
                                    ':postSlug' => $postSlug,
                                    ':postDesc' => $postDesc,
                                    ':postCont' => $postCont,
                                    ':postDate' => date('Y-m-d H:i:s'),
                                    ':image' => $image
                                ));
                                $postID = $db->lastInsertId();

                                //add categories
                                if(is_array($catID)){
                                    foreach($_POST['catID'] as $catID){
                                        $stmt = $db->prepare('INSERT INTO sa_post_categories (postID,catID)VALUES(:postID,:catID)');
                                        $stmt->execute(array(
                                            ':postID' => $postID,
                                            ':catID' => $catID
                                        ));
                                    }
                                }
                                

                              //  $sth=$db->prepare("insert into sa_posts(image)values(:image) "); 

                              //  $sth->bindParam(':image',$image); 

                                //$sth->execute(); 

                                } 
                                
 
                                //redirect to index page
                                header('Location: index.php?action=added');
                                exit;

                            } catch(PDOException $e) {
                                echo $e->getMessage();
                            }

                        }

                    }

                    //check for any errors
                    if(isset($error)){
                        foreach($error as $error){
                            echo '<p class="error">'.$error.'</p>';
                        }
                    }
                    ?>
                
                <!-- /# row -->
                 <form class="form-horizontal form-material" action='' method='post' enctype="multipart/form-data">  
                <div class="row">
                 
                    <div class="col-lg-9">
                     <div class="card">
                        <div class="card-title">
                            <h4>Add New Post</h4>
                        </div>
                        <div class="card-body">
                    
                        <div class="form-group">
                            <div class="col-md-12">
                                 <h4 class="card-title">Name</h4>
                                <input type="text" placeholder="Enter post title" class="form-control form-control-line" name='postTitle' value='<?php if(isset($error)){ echo $_POST['postTitle'];}?>'>
                            </div>
                        </div>
                        
                      <div class="form-group">
                        <div class="col-md-12">
                        <h4 class="card-title">Description</h4>
                        <textarea name='postDesc' cols='60' rows='4'><?php if(isset($error)){ echo $_POST['postDesc'];}?></textarea>
                        </div>
                     </div>
                            
                      <div class="form-group">
                        <div class="col-md-12">
                          <h4 class="card-title">Content</h4>
                         <textarea name='postCont' cols='60' rows='10'><?php if(isset($error)){ echo $_POST['postCont'];}?></textarea>
                         </div>
                     </div> 
                            
                      <div class="form-group">
                        <div class="col-md-12">
                          <h4 class="card-title">Images</h4>
                                <input type="file" name="image" accept=".jpg,.jpeg,.png"/> 
                           </div>
                      </div>      
 
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                    
                    <div class="col-lg-3">
                        
                       <div class="col-lg-12"> 
                        <div class="card">
                            
                            <div class="card-title">
                                <h4>Publish Post</h4>
                            </div>
                            <div class="card-body">
                                
                             <div class="form-group">
                                    <div class="col-sm-12">
                                        <button type="submit" name='submit' value='Submit' class="btn btn-danger">Publish</button>
                                    </div>
                                </div>

                            </div>
                             
                        </div>
                    </div>
                        
                        
                    <div class="col-lg-12"> 
                        <div class="card">
                            
                             <div class="card-title">
                                <h4>Categories</h4>
                            </div>
                            <div class="card-body">
                                
                                
                            <?php	

								$stmt2 = $db->query('SELECT catID, catTitle FROM sa_categories ORDER BY catTitle');
								while($row2 = $stmt2->fetch()){
					
									if(isset($_POST['catID'])){
					
										if(in_array($row2['catID'], $_POST['catID'])){
										   $checked="checked='checked'";
										}else{
										   $checked = null;
										}
									}
                                    echo "<label><input type='checkbox' name='catID[]' value='".$row2['catID']."' $checked> ".$row2['catTitle']."</label><br />";
								}
					
								?>

                                
                        </div>
                        </div>
                    </div>    
                    
                        
                 </div>
                    
                    
                </div>
                <!-- /# row -->
                </form>
                <!-- End PAge Content -->
            </div>
            
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

<?php //include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

<!DOCTYPE html>

<head>

<title>Add New Post ~ softAOX</title>

<?php include('includes/css.php');?>

tinymce.init({

selector: "textarea",

plugins: [

"advlist autolink lists link image charmap print preview anchor",

"searchreplace visualblocks code fullscreen",

"insertdatetime media table contextmenu paste"

});

</script>

<style>

/* Custom CSS */

.mce-tinymce {

margin: 0;

padding: 0;

display: block;

border: 1px solid #e3e3e3 !important;

border-top-left-radius: 3px !important;

border-top-right-radius: 3px !important;

border-bottom: 0px !important;

}

</style>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

</ol>

</div>

<?php

//if form has been submitted process it

if(isset($_POST['submit'])){

//collect form data

extract($_POST);

//very basic validation

if($postTitle ==''){

$error[] = 'Please enter the title.';

}

if($postDesc ==''){

$error[] = 'Please enter the description.';

}

if($postCont ==''){

$error[] = 'Please enter the content.';

}

if(!isset($error)){

try {

$postSlug = slug($postTitle);

$folder ="uploads/";

$image = $_FILES['image']['name'];

$path = $folder . $image ;

$target_file=$folder.basename($_FILES["image"]["name"]);

$imageFileType=pathinfo($target_file,PATHINFO_EXTENSION);

$allowed=array('jpeg','png' ,'jpg'); $filename=$_FILES['image']['name'];

$ext=pathinfo($filename, PATHINFO_EXTENSION); if(!in_array($ext,$allowed) )

{

echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";

}

else{

move_uploaded_file( $_FILES['image'] ['tmp_name'], $path);

//insert into database

$stmt = $db->prepare('INSERT INTO sa_posts (postTitle,postSlug,postDesc,postCont,postDate,image) VALUES (:postTitle, :postSlug, :postDesc, :postCont, :postDate, :image)') ;

$stmt->execute(array(

':postTitle' => $postTitle,

':postSlug' => $postSlug,

':postDesc' => $postDesc,

':postCont' => $postCont,

':postDate' => date('Y-m-d H:i:s'),

':image' => $image

));

$postID = $db->lastInsertId();

//add categories

if(is_array($catID)){

foreach($_POST['catID'] as $catID){

$stmt = $db->prepare('INSERT INTO sa_post_categories (postID,catID)VALUES(:postID,:catID)');

$stmt->execute(array(

':postID' => $postID,

':catID' => $catID

));

}

// $sth=$db->prepare("insert into sa_posts(image)values(:image) ");

// $sth->bindParam(':image',$image);

//$sth->execute();

}

//redirect to index page

header('Location: index.php?action=added');

exit;

} catch(PDOException $e) {

echo $e->getMessage();

}

//check for any errors

if(isset($error)){

foreach($error as $error){

echo '<p class="error">'.$error.'</p>';

}

</div>

</div>

<h4 class="card-title">Description</h4>

</div>

<h4 class="card-title">Content</h4>

</div>

<h4 class="card-title">Images</h4>

</div>

<h4>Publish Post</h4>

</div>

<button type="submit" name='submit' value='Submit' class="btn btn-danger">Publish</button>

</div>

<h4>Categories</h4>

</div>

<?php

$stmt2 = $db->query('SELECT catID, catTitle FROM sa_categories ORDER BY catTitle');

while($row2 = $stmt2->fetch()){

if(isset($_POST['catID'])){

if(in_array($row2['catID'], $_POST['catID'])){

$checked="checked='checked'";

}else{

$checked = null;

}

echo "<label><input type='checkbox' name='catID[]' value='".$row2['catID']."' $checked> ".$row2['catTitle']."</label><br />";

}

</div>

</form>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

edit-post.php

You can edit your article using the below code.

<?php //include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }
?>
<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

   <title>Edit Post ~ softAOX</title>
   
     <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->
    <script src="//tinymce.cachefly.net/4.0/tinymce.min.js"></script>
    <script>
        tinymce.init({
              selector: "textarea",
              plugins: [
                  "advlist autolink lists link image charmap print preview anchor",
                  "searchreplace visualblocks code fullscreen",
                  "insertdatetime media table contextmenu paste"
              ],
              toolbar: "insertfile undo redo | styleselect | bold italic | alignleft aligncenter alignright alignjustify | bullist numlist outdent indent | link image"
          });

  </script>
    
</head>
<style>
/* Custom CSS */
.mce-tinymce {
margin: 0;
padding: 0;
display: block;
border: 1px solid #e3e3e3 !important;
border-top-left-radius: 3px !important;
border-top-right-radius: 3px !important;
border-bottom: 0px !important;
}
</style>
<body class="fix-header fix-sidebar">
     <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Edit Post</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Edit Post</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->
                 
                <?php

                    //if form has been submitted process it
                    if(isset($_POST['submit'])){

                        //collect form data
                        extract($_POST);

                        //very basic validation
                        if($postID ==''){
                            $error[] = 'This post is missing a valid id!.';
                        }

                        if($postTitle ==''){
                            $error[] = 'Please enter the title.';
                        }

                        if($postDesc ==''){
                            $error[] = 'Please enter the description.';
                        }

                        if($postCont ==''){
                            $error[] = 'Please enter the content.';
                        }

                        if(!isset($error)){

                            try {

                                $postSlug = slug($postTitle);
                                
                                $folder ="uploads/"; 

                                $image = $_FILES['image']['name']; 

                                $path = $folder . $image ; 

                                $target_file=$folder.basename($_FILES["image"]["name"]);


                                 $imageFileType=pathinfo($target_file,PATHINFO_EXTENSION);


                                $allowed=array('jpeg','png' ,'jpg'); $filename=$_FILES['image']['name']; 

                                $ext=pathinfo($filename, PATHINFO_EXTENSION); if(!in_array($ext,$allowed) ) 

                                { 

                                 echo "<span style='color:red; padding:10px;'>Please re-upload the image</span>";

                                }

                                else{ 

                                move_uploaded_file( $_FILES['image'] ['tmp_name'], $path);

                                //insert into database
                                $stmt = $db->prepare('UPDATE sa_posts SET postTitle = :postTitle, postSlug = :postSlug, postDesc = :postDesc, postCont = :postCont, image = :image WHERE postID = :postID') ;
                                $stmt->execute(array(
                                    ':postTitle' => $postTitle,
                                    ':postSlug' => $postSlug,
                                    ':postDesc' => $postDesc,
                                    ':postCont' => $postCont,
                                    ':postID' => $postID,
                                    ':image' => $image
                                ));

                                //delete all items with the current postID
                                $stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');
                                $stmt->execute(array(':postID' => $postID));

                                if(is_array($catID)){
                                    foreach($_POST['catID'] as $catID){
                                        $stmt = $db->prepare('INSERT INTO sa_post_categories (postID,catID)VALUES(:postID,:catID)');
                                        $stmt->execute(array(
                                            ':postID' => $postID,
                                            ':catID' => $catID
                                        ));
                                    }
                                }
                                }

                      
            

                            } catch(PDOException $e) {
                                echo $e->getMessage();
                            }
                        }

                    }

                    ?>


                    <?php
                    //check for any errors
                    if(isset($error)){
                        foreach($error as $error){
                            echo $error.'<br />';
                        }
                    }

                        try {

                            $stmt = $db->prepare('SELECT postID, postTitle, postDesc, postCont, image FROM sa_posts WHERE postID = :postID') ;
                            $stmt->execute(array(':postID' => $_GET['id']));
                            $row = $stmt->fetch(); 

                        } catch(PDOException $e) {
                            echo $e->getMessage();
                        }

                    ?>
                
                <!-- /# row -->
                 <form class="form-horizontal form-material"  enctype="multipart/form-data" action='' method='post'>  
                <div class="row"> 
                 
                    <div class="col-lg-9">
                     <div class="card">
                        <div class="card-title">
                            <h4>Edit Post</h4>
                        </div>
                        <div class="card-body">
                            
                            
                            <input type='hidden' name='postID' value='<?php echo $row['postID'];?>'>

	                
                        <div class="form-group">
                            <div class="col-md-12">
                                <h4 class="card-title">Name</h4>
                                <input type="text" placeholder="Enter post title" class="form-control form-control-line" name='postTitle' value='<?php echo $row['postTitle'];?>'>
                            </div>
                        </div>
                        
                     <div class="form-group">
                        <div class="col-md-12">
                        <h4 class="card-title">Description</h4>
                        <textarea name='postDesc' cols='60' rows='10'><?php echo $row['postDesc'];?></textarea>
                         </div>
                     </div> 
                    
                    <div class="form-group">
                        <div class="col-md-12">
                        <h4 class="card-title">Content</h4>
                        <textarea name='postCont' cols='60' rows='10'><?php echo $row['postCont'];?></textarea>
                        </div>
                     </div> 
                            
                            
                    <div class="form-group">
                        <div class="col-md-12">
                        <div class="preview_img">
                         <img src="<?php echo 'uploads/'.$row['image']; ?>" width="150px">
                         </div>
                          <h4 class="card-title">Images</h4>
                                <input type="file" name="image" accept=".jpg,.jpeg,.png"/> 
                           </div>
                   </div>    
                            
                            </div>
                        </div>
                    </div>
                    <!-- /# column -->
                    
                    <div class="col-lg-3 custom-my-side">
                    <div class="col-lg-12">
                        <div class="card">
                            
                            <div class="card-title">
                                <h4>Update Post</h4>
                            </div>
                            <div class="card-body">
                                
                             <div class="form-group">
                                    <div class="col-sm-12">
                                        <button type="submit" name='submit' value='Submit' class="btn btn-danger">Update</button>
                                    </div>
                                </div>

                            </div>
                           
                        </div>
                    </div>
                    
                    <div class="col-lg-12">
                        <div class="card">
                         
                            <div class="card-title">
                                <h4>Categories</h4>
                            </div>
                            <div class="card-body">
                           
                                <?php

                                $stmt2 = $db->query('SELECT catID, catTitle FROM sa_categories ORDER BY catTitle');
                                while($row2 = $stmt2->fetch()){

                                    $stmt3 = $db->prepare('SELECT catID FROM sa_post_categories WHERE catID = :catID AND postID = :postID') ;
                                    $stmt3->execute(array(':catID' => $row2['catID'], ':postID' => $row['postID']));
                                    $row3 = $stmt3->fetch(); 

                                    if($row3['catID'] == $row2['catID']){
                                        $checked = 'checked=checked';
                                    } else {
                                        $checked = null;
                                    }


                                    echo "<label><input type='checkbox' name='catID[]' value='".$row2['catID']."' $checked> ".$row2['catTitle']."</label><br />";
                                }

                                ?>

                                   
                        </div>
                        </div>
                    </div>
                    
                     </div>
                    
                    
                </div>
                <!-- /# row -->
                </form>
                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

176

177

178

179

180

181

182

183

184

185

186

187

188

189

190

191

192

193

194

195

196

197

198

199

200

201

202

203

204

205

206

207

208

209

210

211

212

213

214

215

216

217

218

219

220

221

222

223

224

225

226

227

228

229

230

231

232

233

234

235

236

237

238

239

240

241

242

243

244

245

246

247

248

249

250

251

252

253

254

255

256

257

258

259

260

261

262

263

264

265

266

267

268

269

270

271

272

273

274

275

276

277

278

279

280

281

282

283

284

285

286

287

288

289

290

291

292

293

294

295

296

297

298

299

300

301

302

303

304

305

306

307

308

309

310

311

312

313

314

315

316

317

318

319

320

321

322

323

324

<?php //include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

<!DOCTYPE html>

<head>

<title>Edit Post ~ softAOX</title>

<?php include('includes/css.php');?>

tinymce.init({

selector: "textarea",

plugins: [

"advlist autolink lists link image charmap print preview anchor",

"searchreplace visualblocks code fullscreen",

"insertdatetime media table contextmenu paste"

});

</script>

</head>

<style>

/* Custom CSS */

.mce-tinymce {

margin: 0;

padding: 0;

display: block;

border: 1px solid #e3e3e3 !important;

border-top-left-radius: 3px !important;

border-top-right-radius: 3px !important;

border-bottom: 0px !important;

}

</style>

</svg>

</div>

<?php include('includes/menu.php');?>

</ol>

</div>

<?php

//if form has been submitted process it

if(isset($_POST['submit'])){

//collect form data

extract($_POST);

//very basic validation

if($postID ==''){

$error[] = 'This post is missing a valid id!.';

}

if($postTitle ==''){

$error[] = 'Please enter the title.';

}

if($postDesc ==''){

$error[] = 'Please enter the description.';

}

if($postCont ==''){

$error[] = 'Please enter the content.';

}

if(!isset($error)){

try {

$postSlug = slug($postTitle);

$folder ="uploads/";

$image = $_FILES['image']['name'];

$path = $folder . $image ;

$target_file=$folder.basename($_FILES["image"]["name"]);

$imageFileType=pathinfo($target_file,PATHINFO_EXTENSION);

$allowed=array('jpeg','png' ,'jpg'); $filename=$_FILES['image']['name'];

$ext=pathinfo($filename, PATHINFO_EXTENSION); if(!in_array($ext,$allowed) )

{

echo "<span style='color:red; padding:10px;'>Please re-upload the image</span>";

}

else{

move_uploaded_file( $_FILES['image'] ['tmp_name'], $path);

//insert into database

$stmt = $db->prepare('UPDATE sa_posts SET postTitle = :postTitle, postSlug = :postSlug, postDesc = :postDesc, postCont = :postCont, image = :image WHERE postID = :postID') ;

$stmt->execute(array(

':postTitle' => $postTitle,

':postSlug' => $postSlug,

':postDesc' => $postDesc,

':postCont' => $postCont,

':postID' => $postID,

':image' => $image

));

//delete all items with the current postID

$stmt = $db->prepare('DELETE FROM sa_post_categories WHERE postID = :postID');

$stmt->execute(array(':postID' => $postID));

if(is_array($catID)){

foreach($_POST['catID'] as $catID){

$stmt = $db->prepare('INSERT INTO sa_post_categories (postID,catID)VALUES(:postID,:catID)');

$stmt->execute(array(

':postID' => $postID,

':catID' => $catID

));

}

} catch(PDOException $e) {

echo $e->getMessage();

}

<?php

//check for any errors

if(isset($error)){

foreach($error as $error){

echo $error.'<br />';

}

try {

$stmt = $db->prepare('SELECT postID, postTitle, postDesc, postCont, image FROM sa_posts WHERE postID = :postID') ;

$stmt->execute(array(':postID' => $_GET['id']));

$row = $stmt->fetch();

} catch(PDOException $e) {

echo $e->getMessage();

}

</div>

</div>

<h4 class="card-title">Description</h4>

</div>

<h4 class="card-title">Content</h4>

</div>

<img src="<?php echo 'uploads/'.$row['image']; ?>" width="150px">

</div>

<h4 class="card-title">Images</h4>

</div>

<h4>Update Post</h4>

</div>

<button type="submit" name='submit' value='Submit' class="btn btn-danger">Update</button>

</div>

<h4>Categories</h4>

</div>

<?php

$stmt2 = $db->query('SELECT catID, catTitle FROM sa_categories ORDER BY catTitle');

while($row2 = $stmt2->fetch()){

$stmt3 = $db->prepare('SELECT catID FROM sa_post_categories WHERE catID = :catID AND postID = :postID') ;

$stmt3->execute(array(':catID' => $row2['catID'], ':postID' => $row['postID']));

$row3 = $stmt3->fetch();

if($row3['catID'] == $row2['catID']){

$checked = 'checked=checked';

} else {

$checked = null;

}

echo "<label><input type='checkbox' name='catID[]' value='".$row2['catID']."' $checked> ".$row2['catTitle']."</label><br />";

}

</div>

</form>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

categories.php

The below code help you to list all the categories which you created.

<?php
//include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page
if(isset($_GET['delcat'])){ 

	$stmt = $db->prepare('DELETE FROM sa_categories WHERE catID = :catID') ;
	$stmt->execute(array(':catID' => $_GET['delcat']));

	header('Location: categories.php?action=deleted');
	exit;
} 

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Categories ~ SoftAOX</title>
   
    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->

  <script language="JavaScript" type="text/javascript">
  function delcat(id, title)
  {
	  if (confirm("Are you sure you want to delete '" + title + "'"))
	  {
	  	window.location.href = 'categories.php?delcat=' + id;
	  }
  }
  </script>

</head>

<body class="fix-header fix-sidebar">
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">
	
		
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Categories</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Categories</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->

                
                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">


                            <div class="card-title">
                                <h4>Categories</h4> <a href='add-category.php'> <button type="button" class="btn btn-dark btn-sm m-b-10 m-l-5"><i class="fa fa-plus"></i> Add New Category</button></a>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">

                                    <?php 
                                    //show message from add / edit page
                                    if(isset($_GET['action'])){ 
                                        echo '<h3>Category '.$_GET['action'].'.</h3>'; 
                                    } 
                                    ?>

                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Name</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

									  <tbody>
                                    
                                          
                                        <?php
                                            try {

                                                $stmt = $db->query('SELECT catID, catTitle, catSlug FROM sa_categories ORDER BY catTitle DESC');
                                                while($row = $stmt->fetch()){

                                                echo '<td>'.$row['catID'].'</td>';
                                                echo '<td>'.$row['catTitle'].'</td>';
                                                ?>
                                                
                                                <td><a href="edit-category.php?id=<?php echo $row['catID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <a href="javascript:delcat('<?php echo $row['catID'];?>','<?php echo $row['catSlug'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a></td>
                                            
                                            <?php 
												echo '</tr>';

											}

										} catch(PDOException $e) {
										    echo $e->getMessage();
										}
									?>
                                            
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>



                </div>


                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

<?php

//include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page

if(isset($_GET['delcat'])){

$stmt = $db->prepare('DELETE FROM sa_categories WHERE catID = :catID') ;

$stmt->execute(array(':catID' => $_GET['delcat']));

header('Location: categories.php?action=deleted');

exit;

}

<!DOCTYPE html>

<head>

<title>Categories ~ SoftAOX</title>

<?php include('includes/css.php');?>

function delcat(id, title)

{

if (confirm("Are you sure you want to delete '" + title + "'"))

{

window.location.href = 'categories.php?delcat=' + id;

}

</script>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

<h3 class="text-primary">Categories</h3> </div>

<li class="breadcrumb-item active">Categories</li>

</ol>

</div>

<h4>Categories</h4> <a href='add-category.php'> <button type="button" class="btn btn-dark btn-sm m-b-10 m-l-5"><i class="fa fa-plus"></i> Add New Category</button></a>

</div>

<?php

//show message from add / edit page

if(isset($_GET['action'])){

echo '<h3>Category '.$_GET['action'].'.</h3>';

}

<thead>

<tr>

<th>Action</th>

</tr>

</thead>

<tbody>

<?php

try {

$stmt = $db->query('SELECT catID, catTitle, catSlug FROM sa_categories ORDER BY catTitle DESC');

while($row = $stmt->fetch()){

echo '<td>'.$row['catID'].'</td>';

echo '<td>'.$row['catTitle'].'</td>';

<td><a href="edit-category.php?id=<?php echo $row['catID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <a href="javascript:delcat('<?php echo $row['catID'];?>','<?php echo $row['catSlug'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a></td>

<?php

echo '</tr>';

}

} catch(PDOException $e) {

echo $e->getMessage();

}

</tbody>

</table>

</div>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

add-categories.php

Below code will help you to add new categories in your list.

<?php //include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Add Category ~ SoftAOX</title>

    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->

</head>

<body class="fix-header fix-sidebar">
   <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
        
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">
	
		
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Add Category</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Add Category</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->

                
                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">

                            <?php

                            //if form has been submitted process it
                            if(isset($_POST['submit'])){

                                //collect form data
                                extract($_POST);

                                //very basic validation
                                if($catTitle ==''){
                                    $error[] = 'Please enter the Category.';
                                }

                                if(!isset($error)){

                                    try {

                                        $catSlug = slug($catTitle);

                                        //insert into database
                                        $stmt = $db->prepare('INSERT INTO sa_categories (catTitle,catSlug) VALUES (:catTitle, :catSlug)') ;
                                        $stmt->execute(array(
                                            ':catTitle' => $catTitle,
                                            ':catSlug' => $catSlug
                                        ));

                                        //redirect to categories page
                                        header('Location: categories.php?action=added');
                                        exit;

                                    } catch(PDOException $e) {
                                        echo $e->getMessage();
                                    }

                                }

                            }

                            //check for any errors
                            if(isset($error)){
                                foreach($error as $error){
                                    echo '<p class="error">'.$error.'</p>';
                                }
                            }
                            ?>

                            
                          
                            
                                            <div class="card-body">

                                                 <form class="form-horizontal form-material" method='post'>
                                                    <div class="form-group">
                                                        <label class="col-md-12">Name</label>
                                                        <div class="col-md-12">
                                                            <input type="text" name='catTitle' value='<?php if(isset($error)){ echo $_POST['catTitle'];}?>' placeholder="Enter Category Name" class="form-control form-control-line">
                                                        </div>
                                                    </div>
                                                    <div class="form-group">
                                                        <div class="col-sm-12">
                                                            <button type="submit" name='submit' value='Add User' class="btn btn-success">Add New Category</button>
                                                        </div>
                                                    </div>
                                                </form>

                                            </div>
                         
                        </div>
                    </div>
                </div>



                </div>


                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

<?php //include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

<!DOCTYPE html>

<head>

<title>Add Category ~ SoftAOX</title>

<?php include('includes/css.php');?>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

<h3 class="text-primary">Add Category</h3> </div>

<li class="breadcrumb-item active">Add Category</li>

</ol>

</div>

<?php

//if form has been submitted process it

if(isset($_POST['submit'])){

//collect form data

extract($_POST);

//very basic validation

if($catTitle ==''){

$error[] = 'Please enter the Category.';

}

if(!isset($error)){

try {

$catSlug = slug($catTitle);

//insert into database

$stmt = $db->prepare('INSERT INTO sa_categories (catTitle,catSlug) VALUES (:catTitle, :catSlug)') ;

$stmt->execute(array(

':catTitle' => $catTitle,

':catSlug' => $catSlug

));

//redirect to categories page

header('Location: categories.php?action=added');

exit;

} catch(PDOException $e) {

echo $e->getMessage();

}

//check for any errors

if(isset($error)){

foreach($error as $error){

echo '<p class="error">'.$error.'</p>';

}

<input type="text" name='catTitle' value='<?php if(isset($error)){ echo $_POST['catTitle'];}?>' placeholder="Enter Category Name" class="form-control form-control-line">

</div>

<button type="submit" name='submit' value='Add User' class="btn btn-success">Add New Category</button>

</div>

</form>

</div>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

edit-categories.php

If you like to change or delete category name here the below code helps you to do that.

<?php //include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }
?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Edit Category ~ SoftAOX</title>
    <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- Style Sheet -->

</head>

<body class="fix-header fix-sidebar">
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
          
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
        <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">
	
		
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Edit Category</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Edit Category</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->

                
                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">

                            <?php

                            //if form has been submitted process it
                            if(isset($_POST['submit'])){

                                //collect form data
                                extract($_POST);

                                //very basic validation
                                if($catID ==''){
                                    $error[] = 'This post is missing a valid id!.';
                                }

                                if($catTitle ==''){
                                    $error[] = 'Please enter the title.';
                                }

                                if(!isset($error)){

                                    try {

                                        $catSlug = slug($catTitle);

                                        //insert into database
                                        $stmt = $db->prepare('UPDATE sa_categories SET catTitle = :catTitle, catSlug = :catSlug WHERE catID = :catID') ;
                                        $stmt->execute(array(
                                            ':catTitle' => $catTitle,
                                            ':catSlug' => $catSlug,
                                            ':catID' => $catID
                                        ));

                                        //redirect to index page
                                        header('Location: categories.php?action=updated');
                                        exit;

                                    } catch(PDOException $e) {
                                        echo $e->getMessage();
                                    }

                                }

                            }

                            ?>


                            <?php
                            //check for any errors
                            if(isset($error)){
                                foreach($error as $error){
                                    echo $error.'<br />';
                                }
                            }

                                try {

                                    $stmt = $db->prepare('SELECT catID, catTitle FROM sa_categories WHERE catID = :catID') ;
                                    $stmt->execute(array(':catID' => $_GET['id']));
                                    $row = $stmt->fetch(); 

                                } catch(PDOException $e) {
                                    echo $e->getMessage();
                                }

                            ?>

		        
                                            <div class="card-body">

                                                 <form class="form-horizontal form-material" method='post'>
                                                     
                                                     <input type='hidden' name='catID' value='<?php echo $row['catID'];?>'>
                                                     
                                                    <div class="form-group">
                                                        <label class="col-md-12">Name</label>
                                                        <div class="col-md-12">
                                                            <input type="text" name='catTitle' value='<?php echo $row['catTitle'];?>' placeholder="Enter Category Name" class="form-control form-control-line">
                                                        </div>
                                                    </div>
                                                    <div class="form-group">
                                                        <div class="col-sm-12">
                                                            <button type="submit" name='submit' value='Update' class="btn btn-danger">Update</button>
                                                        </div>
                                                    </div>
                                                </form>

                                            </div>
                         
                        </div>
                    </div>
                </div>

                </div>

                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

170

171

172

173

174

175

<?php //include config

require_once('../includes/config.php');

//if not logged in redirect to login page

if(!$user->is_logged_in()){ header('Location: login.php'); }

<!DOCTYPE html>

<head>

<title>Edit Category ~ SoftAOX</title>

<?php include('includes/css.php');?>

</head>

</svg>

</div>

<?php include('includes/menu.php');?>

<h3 class="text-primary">Edit Category</h3> </div>

<li class="breadcrumb-item active">Edit Category</li>

</ol>

</div>

<?php

//if form has been submitted process it

if(isset($_POST['submit'])){

//collect form data

extract($_POST);

//very basic validation

if($catID ==''){

$error[] = 'This post is missing a valid id!.';

}

if($catTitle ==''){

$error[] = 'Please enter the title.';

}

if(!isset($error)){

try {

$catSlug = slug($catTitle);

//insert into database

$stmt = $db->prepare('UPDATE sa_categories SET catTitle = :catTitle, catSlug = :catSlug WHERE catID = :catID') ;

$stmt->execute(array(

':catTitle' => $catTitle,

':catSlug' => $catSlug,

':catID' => $catID

));

//redirect to index page

header('Location: categories.php?action=updated');

exit;

} catch(PDOException $e) {

echo $e->getMessage();

}

<?php

//check for any errors

if(isset($error)){

foreach($error as $error){

echo $error.'<br />';

}

try {

$stmt = $db->prepare('SELECT catID, catTitle FROM sa_categories WHERE catID = :catID') ;

$stmt->execute(array(':catID' => $_GET['id']));

$row = $stmt->fetch();

} catch(PDOException $e) {

echo $e->getMessage();

}

<input type="text" name='catTitle' value='<?php echo $row['catTitle'];?>' placeholder="Enter Category Name" class="form-control form-control-line">

</div>

<button type="submit" name='submit' value='Update' class="btn btn-danger">Update</button>

</div>

</form>

</div>

</div>

</div>

</div>

<?php include('includes/js.php');?>

</body>

</html>

users.php

This will display all the user’s list created by you.

<?php
//include config
require_once('../includes/config.php');

//if not logged in redirect to login page
if(!$user->is_logged_in()){ header('Location: login.php'); }

//show message from add / edit page
if(isset($_GET['deluser'])){ 

	//if user id is 1 ignore
	if($_GET['deluser'] !='1'){

		$stmt = $db->prepare('DELETE FROM sa_users WHERE memberID = :memberID') ;
		$stmt->execute(array(':memberID' => $_GET['deluser']));

		header('Location: users.php?action=deleted');
		exit;

	}
} 

?>
<!DOCTYPE html>
<html lang="en">

<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <!-- Tell the browser to be responsive to screen width -->
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <meta name="robots" content="noindex, nofollow">

    <title>Users ~ SoftAOX</title>
   
     <!-- Style Sheet -->
           <?php include('includes/css.php');?> 
     <!-- End Style Sheet -->
   
<script language="JavaScript" type="text/javascript">
  function deluser(id, title)
  {
	  if (confirm("Are you sure you want to delete '" + title + "'"))
	  {
	  	window.location.href = 'users.php?deluser=' + id;
	  }
  }
  </script>

</head>

<body class="fix-header fix-sidebar">
    <div class="preloader">
        <svg class="circular" viewBox="25 25 50 50">
            <circle class="path" cx="50" cy="50" r="20" fill="none" stroke-width="2" stroke-miterlimit="10" />
        </svg>
    </div>
        <!-- Main wrapper  -->
      <div id="main-wrapper">
           
        <!-- Menu -->
           <?php include('includes/menu.php');?> 
        <!-- End Menu -->
    
       <!-- Page wrapper  -->
        <div class="page-wrapper">
            <!-- Bread crumb -->

            <div id="wrapper">
	
		
            <div class="row page-titles">
                <div class="col-md-5 align-self-center">
                    <h3 class="text-primary">Users</h3> </div>
                <div class="col-md-7 align-self-center">
                    <ol class="breadcrumb">
                        <li class="breadcrumb-item"><a href="./">Home</a></li>
                        <li class="breadcrumb-item active">Users</li>
                    </ol>
                </div>
            </div>
            <!-- End Bread crumb -->
            <!-- Container fluid  -->
            <div class="container-fluid">
                <!-- Start Page Content -->

                
                <div class="row">
				    <div class="col-lg-12">
                        <div class="card">


                            <div class="card-title">
                                <h4>Users</h4> <a href='new-user.php'> <button type="button" class="btn btn-dark btn-sm m-b-10 m-l-5"><i class="fa fa-plus"></i>  Add New User</button></a>
                            </div>
                            <div class="card-body">
                                <div class="table-responsive">


					                <?php 
                                    //show message from add / edit page
                                    if(isset($_GET['action'])){ 
                                        echo '<h3>User '.$_GET['action'].'.</h3>'; 
                                    } 
                                    ?>

                                    <table class="table">
                                        <thead>
                                            <tr>
                                                <th>#</th>
                                                <th>Username</th>
                                                <th>Email</th>
                                                <th>Action</th>
                                            </tr>
                                        </thead>

									  <tbody>
                                    
                                    <?php
                                        try {

                                            $stmt = $db->query('SELECT memberID, username, email FROM sa_users ORDER BY username');
                                            while($row = $stmt->fetch()){

                                          echo '<td>'.$row['memberID'].'</td>';
                                          echo '<td>'.$row['username'].'</td>';
                                          echo '<td>'.$row['email'].'</td>';
                                          ?>
                                                <!-- <td><a href="profile.php?id=<?php echo $row['memberID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a> | <?php if($row['memberID'] != 1){?><a href="javascript:deluser('<?php echo $row['memberID'];?>','<?php echo $row['username'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a><?php } ?></td> -->
                                                <td><?php if($row['memberID'] != 1){?><a href="profile.php?id=<?php echo $row['memberID'];?>"><button type="button" class="btn btn-primary btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-edit"></i> Edit</button></a><?php } ?> | <?php if($row['memberID'] != 1){?><a href="javascript:deluser('<?php echo $row['memberID'];?>','<?php echo $row['username'];?>')"><button type="button" class="btn btn-danger btn-xs btn-addon s-b-10 s-l-5"><i class="fa fa-trash"></i> Delete</button></a><?php } ?></td>
                                            <?php 
												echo '</tr>';

											}

										} catch(PDOException $e) {
										    echo $e->getMessage();
										}
									?>
                                            
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>



                </div>


                <!-- End PAge Content -->
            </div>
            <!-- End Container fluid  -->
            <!-- footer -->
            <footer class="footer"> Copyrights &copy; <?php echo date("Y"); ?> <a href="http://softaox.info/" target="_blank" rel="noopener noreferrer">softAOX.info</a>. All Rights Reserved.</footer>
            <!-- End footer -->
        </div>
        <!-- End Page wrapper  -->
    </div>
    <!-- End Wrapper -->
    
     <!-- Java Scripts -->
           <?php include('includes/js.php');?> 
     <!-- End Java Scripts -->

</body>

</html>

Dynamic Blog with PHP and MySQL – Dashboard

Share:

Preview & Download

login.php

logout.php

index.php

posts.php

new-post.php

edit-post.php

categories.php

add-categories.php

edit-categories.php

users.php