PHP Classes

File: admin/edit.php

Recommend this page to a friend!
  Classes of Adeleye Ayodeji   Simple PHP Blog Script   admin/edit.php   Download  
File: admin/edit.php
Role: Auxiliary script
Content type: text/plain
Description: Auxiliary script
Class: Simple PHP Blog Script
Manage blog articles stored in a MySQL database
Author: By
Last change:
Date: 2 years ago
Size: 4,311 bytes
 

Contents

Class file image Download
<?php
include 'include/header.php';
if (isset(
$_SESSION["admin"])) {
   
           
$id = $_GET['id'];
           
$query = mysqli_query($con, "SELECT * FROM post WHERE id='$id' ");
           
$row = mysqli_fetch_assoc($query);


           
// Upadte post
           
if (isset($_POST['update'])) {
                   
                   
$id = $_GET['id'];
                   
$title = $_POST['title'];
                   
$category = $_POST['category'];
                   
$text = $_POST['text'];

                   
$query = mysqli_query($con, "UPDATE post SET title='$title', category='$category' text='$text' WHERE id='$id' ") or die();
                    if (
$query) {
                   
$posted = "<p style='color:white;background:green;padding:5px;border-radius:5px;text-align:center;'>Updated successfully <br><span>Refresh the page to see result!</span></p>";
                }else{
                   
$posted = "<p style='color:white;background:red;padding:5px;border-radius:5px;text-align:center;'>Post Error!!!</p>";
                }
            }

                    if (isset(
$_POST['updatelogo'])) {
               
               
$target = "../image/".basename($_FILES['image']['name']);

       
$image = $_FILES['image']['name'];
       
$id = $_GET['id'];
       
$query = mysqli_query($con, "UPDATE post SET image='$image' WHERE id='$id' ") or die();
        if (
move_uploaded_file($_FILES['image']['tmp_name'], $target)) {
       
$posted = "<p style='color:white;background:green;padding:5px;border-radius:5px;text-align:center;'>Image change Successfully<br><span>Refresh the page to see result!</span></p>";
    }else{
       
$posted = "<p style='color:white;background:red;padding:5px;border-radius:5px;text-align:center;'>Image change error Error!!!</p>";
    }
            }

}else{
   
header("location: login.php");
}

?>

<style type="text/css">
    form{
        margin-right: auto;
        margin-left: auto;
        width: 50%;
        margin-top: 10px;
        margin-bottom: 10px;
    }
    h2{
        text-align: center;
    }
    input{
        height: 30px;
        background: transparent;
        outline: none;
        border:none;
        border-bottom: 1px solid blueviolet;
    }
    textarea{
         height: 100px;
            width: 110%;
        background: transparent;
        outline: none;
        border:none;
        border-bottom: 1px solid blueviolet;
    }
</style>
       
    <form method="post" action="" enctype="multipart/form-data">
        <p><?php if (isset($_POST["updatelogo"])) {
                        echo
$posted;
                    }
?></p>
                        <input type="hidden" value="999999999999999">
                    <label>
                           <input style="display: none;" id="file" type="file" name="image" onchange="proccess(window.lastFile=this.files[0])">
                           <div style="margin: 0px;padding: 0px;">
                             <!--Sample image uploaded begins HERE -->
                             <p>Change post Image:</p>
                            <img id="image" style="width: 100%;height: auto;cursor: pointer;margin-left:0px;" class="ui centered large image" src="../image/<?php echo $row["image"] ?>"/>
                             <!--Sample image uploaded ends HERE -->
                          </div>
                              
                        </label>
                        <input type="submit" name="updatelogo" value="Update Image">
     </form>
    <form method="post" action="">
        <p><?php if (isset($_POST["update"])) {
                        echo
$posted;
                    }
?></p>
                    <p>Post Title:</p>
                    <input type="text" name="title" placeholder="Enter your title" value="<?php echo $row["title"] ?>">
                     <p>Post Category:</p>
                        <select name="category" style="padding: 5px;background: blueviolet;color: white;margin-bottom: 5px;">
                            <option><?php echo $row["category"]; ?></option>
                            <option value="Technology">Technology</option>
                            <option value="Programming">Programming</option>
                            <option value="Lifestyle">Lifestyle</option>
                            <option value="Sport">Sport</option>
                        </select>
                        <p>Post Contents:</p>
                        <textarea name="text" style="font-family: calibri;"><?php echo $row["text"] ?></textarea>
            <input type="submit" name="update" value="Update Post">
            <center style="margin-top: 5px;">
                <a style="font-family: calibri; background: blueviolet;padding: 5px;color: white;text-decoration: none;" href="javascript:history.go(-1)">&larr; Go Back</a>
            </center>
        </p>
    </form>
<?php include 'include/footer.php'; ?>