Gecko [ rhythmmedical.in ]

Name	Size	Permission
includes	[ DIR ]	drwxrwxrwx
blogs.php	6.32 KB	-rw-rw-rw-
blogs_add.php	1.38 KB	-rw-rw-rw-
blogs_delete.php	474 B	-rw-rw-rw-
blogs_edit.php	882 B	-rw-rw-rw-
blogs_photo.php	898 B	-rw-rw-rw-
blogs_row.php	287 B	-rw-rw-rw-
conn.php	838 B	-rw-rw-rw-
contactForm.php	3.04 KB	-rw-rw-rw-
error_log	477 B	-rw-rw-rw-
home.php	7.21 KB	-rw-rw-rw-
profile_update.php	1.53 KB	-rw-rw-rw-
sales_print.php	3.07 KB	-rw-rw-rw-
transact.php	925 B	-rw-rw-rw-
users.php	5.69 KB	-rw-rw-rw-
users_activate.php	530 B	-rw-rw-rw-
users_add.php	1.48 KB	-rw-rw-rw-
users_delete.php	500 B	-rw-rw-rw-
users_edit.php	1.19 KB	-rw-rw-rw-
users_photo.php	692 B	-rw-rw-rw-
users_row.php	303 B	-rw-rw-rw-

Code Editor : blogs_add.php

<?php
	include 'includes/session.php';
	include 'includes/slugify.php';

if(isset($_POST['add'])){
		$name = $_POST['name'];
		$slug = slugify($name);
		$author_name = $_POST['author_name'];
		$post_date = $_POST['post_date'];
		$filename = $_FILES['photo']['name'];
		$description = $_POST['description'];

$conn = $pdo->open();

$stmt = $conn->prepare("SELECT *, COUNT(*) AS numrows FROM blogs WHERE slug=:slug");
		$stmt->execute(['slug'=>$slug]);
		$row = $stmt->fetch();

if($row['numrows'] > 0){
			$_SESSION['error'] = 'Blog already exist';
		}
		else{
			if(!empty($filename)){
				$ext = pathinfo($filename, PATHINFO_EXTENSION);
				$new_filename = $slug.'.'.$ext;
				move_uploaded_file($_FILES['photo']['tmp_name'], '../images/'.$new_filename);	
			}
			else{
				$new_filename = '';
			}

try{
				$stmt = $conn->prepare("INSERT INTO blogs (title, slug, author_name, post_date, blog_img, description) VALUES (:name, :slug, :author_name, :post_date, :photo, :description)");
				$stmt->execute(['name'=>$name, 'slug'=>$slug, 'author_name'=>$author_name, 'post_date'=>$post_date, 'photo'=>$new_filename, 'description'=>$description]);
				$_SESSION['success'] = 'Blog added successfully';

}
			catch(PDOException $e){
				$_SESSION['error'] = $e->getMessage();
			}
		}

$pdo->close();
	}
	else{
		$_SESSION['error'] = 'Fill up product form first';
	}

header('location: blogs.php');

${this.title}

Code Editor : blogs_add.php