Untitled

<?php
$servername = "data";
$username = "data";
$password = "data";
$database = "data";
$successAdd="";
$errorAdd="";
$connect = mysql_connect($servername, $username, $password) or die("Not   Connected");
mysql_select_db($database) or die("not selected");
 if (isset($_POST['Add'])) {

$venueName = $_POST['cname'];
$file = $_FILES['file'];
$file_name = $file['name'];
$file_tmp = $file['tmp_name'];
$file_size = $file['size'];
$file_error = $file['error'];
$file_ext = explode('.', $file_name);
$file_ext = strtolower(end($file_ext));
$allowed = array('png');
if (in_array($file_ext, $allowed)) {
    if ($file_error == 0) {
        $file_name_new = $venueName . '.' . $file_ext;
        $file_destination = 'images/category/' . $file_name_new;
        if (move_uploaded_file($file_tmp, $file_destination)) {
            $sql = "INSERT INTO `categorytable`(`category`) VALUES ('$venueName')";
            $result = mysql_query($sql, $connect);
            if ($result != 0) {
                $successAdd = "Success fully done";
            } else {
                $errorAdd = "Not done ";
            }
        }
    } else {
        $errorAdd = "Something is wrong";
    }
} else {
    $errorAdd = "Only png file allowed";
}
}


if (isset($_POST['Update'])) {
    $venueName = $_POST['cname'];
    $file = $_FILES['file'];
    $file_name = $file['name'];
    $file_tmp = $file['tmp_name'];
    $file_size = $file['size'];
    $file_error = $file['error'];
    $file_ext = explode('.', $file_name);
     $file_ext = strtolower(end($file_ext));
    $allowed = array('png');
    if (in_array($file_ext, $allowed)) {
       if ($file_error == 0) {
            $file_name_new = $venueName . '.' . $file_ext;
             $file_destination = 'images/category/' . $file_name_new;
             if (move_uploaded_file($file_tmp, $file_destination)) {
            $successAdd = "Success fully done";
            }else{
             $errorAdd = "Not Updated";
            }
        } else {
            $errorAdd = "Something is wrong";
        }
    } else {
        $errorAdd = "Only png file allowed";
        }
    }
?>

<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Test</title>


    </head>
    <body>
    <h3 style="color: red"><?php echo $errorAdd; ?></h3>
    <h3 style="color: green"><?php echo $successAdd; ?></h3>
    <!--<div style="float: left;width: 50%">-->
    <h1>Add Category</h1>
    <form action="" method="POST" enctype="multipart/form-data" id="add-category" >
        Category Name <input type="text" name="cname" value="" /><br/>
        Category Image <input type="file" name="file"  accept="image/x-png"/><br/>
        <input type="submit" value="Add" name="Add"/>
    </form>
    <!--</div>-->

    <!--<div style="float: left;width: 50%">-->
    <h1>Update Category</h1>
    <form action="addCategory.php" method="POST" enctype="multipart/form-data" >
        Select Category<select name="cname">
            <?php
            $sql = "SELECT * FROM `categorytable`";
            $result = mysql_query($sql);
            while ($row = mysql_fetch_array($result)) {
                ?>
                <option value="<?php echo $row[1]; ?>"><?php echo    $row[1]; ?></option>
            <?php } ?>
        </select><br/>
        Category Image <input type="file" name="file"  accept="image/x-png"/><br/>
        <input type="submit" value="Update" name="Update"/>
    </form>
    <!--</div>-->

    <div style="width: 25%;margin: 20px auto;float: left">
        <table border="1">
            <tr>
                <th>Category Name</th>
                <th>Category Image</th>
            </tr>
            <?php
            $sql = "SELECT * FROM `categorytable`";
            $result = mysql_query($sql);
            while ($row = mysql_fetch_array($result)) {
                ?>
                <tr>
                    <td><?php echo $row[1]; ?></td>
                    <td>
                        <img src="images/category/<?php echo $row[1]; ?>.png" height="50"/>
                    </td>
                </tr>

                <?php
            }
            ?>
        </table>

    </div>


</body>