Ele57885fddfg872llll82ddfgdfgdfgdfgdfgfgfggffggfgfgfghgقفغفغفقhfg555434536

kohjhjhصثقص5572lllllllldfgddfgصثقffgggfffgfgfgdfgdg Ele57885fddfg872llll82ddfgdfgdfgdfgdfgfgfggffggfgfgfghgقفغفغفقhfg555434536

<?php
include 'header.php';
include 'config.php';
?>
<link rel="stylesheet" type="text/css" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">

<div class="pagetitle">
        <h1>Photo Gallery</h1>
        <nav>
            <ol class="breadcrumb">
                <li class="breadcrumb-item"><a href="index">Home</a></li>
                <li class="breadcrumb-item">Photo Gallery</li>

</ol>
        </nav>
    </div>
    <section class="section">
        <div class="row">

<div class="card">
                    <div class="card-body">
                        <h5 class="card-title">Photo Gallery</h5>
                        <?php
                        if(isset($_POST['submit'])) {

if(count($_FILES['image']['name']) > 0){
                                //Loop through each file

for($i=0; $i<count($_FILES['image']['name']); $i++) {
                                    //Get the temp file path
                                    $tmpFilePath = $_FILES['image']['tmp_name'][$i];

//Make sure we have a filepath
                                    if($tmpFilePath != ""){

//save the filename
                                        $shortname = $_FILES['image']['name'][$i];

$imageFileType = strtolower(pathinfo($shortname,PATHINFO_EXTENSION));

if(($imageFileType =='jpg') || ($imageFileType =='jpeg') || ($imageFileType =='png') || ($imageFileType =='jfif'))

{

$temp = explode(".", $shortname);
                                            $filePath = "images/gallery/" .substr(time(), -5).$i.".".end($temp);

//Upload the file into the temp dir
                                            if(move_uploaded_file($tmpFilePath, $filePath)) {

$files[] = $shortname;
                                                $filespaths[] = $filePath;
                                                //insert into db
                                                //use $shortname for the filename
                                                //use $filePath for the relative url to the file

}
                                        }
                                    }
                                }
                            }
                            //show success message
                            if(is_array($filespaths)){

$count = 0;
                                foreach($filespaths as $filespat){
                                    $qry = "INSERT INTO gal(image) VALUES ('$filespat')";

$ins = mysqli_query($connect, $qry);
                                    if ($ins) {
                                        $count++;
                                    }
                                }
                            }
                            if ($count) {

?>
                                <script>alert('<?php echo $count; ?> Files Inserted Successfully');
                                    window.location.replace("gal");
                                </script>

<?php
                            } else
                            {
                            ?>
                                <script>alert('Something Went Wrong! Please try Again..');
                                    window.location.replace("gal");
                                </script>

<?php
                            }
                        }
                        ?>
                        
                        <form class="row g-3" method="post" enctype="multipart/form-data">
                            <div class="col-12">
                                <label for="inputNanme4" class="form-label">Images</label>

</div>

<div class="text-left">
                                <button type="submit" name="submit" class="btn btn-primary">Submit</button>

</div>
                        </form>

</div>
                </div>

</div>
        </div>

<div class="card">
                    <div class="card-body">
                        <h5 class="card-title">Photo Gallery</h5>

<table class="table datatable">
                            <thead>
                            <tr>
                                <th scope="col">#</th>
                                <th scope="col">Image</th>

<th scope="col">Edit</th>
                                <th scope="col">Delete</th>
                            </tr>
                            </thead>
                            <tbody>
                            <?php

$query = "SELECT * from gal ";
                            $res_data = mysqli_query($connect,$query);
                            if(mysqli_num_rows($res_data) > 0 ){
                                $num= $offset+1;
                                while($row=mysqli_fetch_array($res_data))
                                { $id = $row['id'];
                                    ?>
                                    <tr>
                                        <th scope="row"><?php echo $num; ?></th>
                                        <td><img src="<?php echo $row['image']; ?>" height="100" width="100" style="background:black;"
                                                 onerror="this.onerror=null;this.src='assets/img/noimage.jpg';"/>
                                        </td>
                                        <td><a href="edit_gal?id=<?php echo $row['id'];?>">
                                                <button data-toggle="tooltip" title="Edit"
                                                        class="btn btn-green btn-xs"><i class="fa fa-edit"></i></button></a>
                                        </td>
                                        <td><a href="delete_gal?id=<?php echo $row['id'];?>">
                                                <button data-toggle="tooltip" title="Delete" Onclick="return ConfirmDelete()"
                                                        class="btn btn-danger btn-xs"><i class="fa fa-trash"></i></button></a>
                                        </td>

</tr>
                                    <?php  $num++;

}}

else{
                                ?>
                                <tr><td align="center" colspan="12"><?php echo "No Data Available" ?></td></tr>
                                <?php
                            }?>
                            </tbody>
                        </table>

</div>
                </div>

</div>
        </div>

</section>

</main>

<a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
<script src="//cdn.ckeditor.com/4.9.2/standard/ckeditor.js"></script>
<script type="text/javascript">
    CKEDITOR.replace('descp');

</script>

<script>
    function ConfirmDelete()
    {
        return confirm("Are you sure you want to delete?");
    }
</script>
<script>
    function fileValidation(file){
        var fileInput = file.value;
        var allowedExtensions = /(\.jpg|\.jpeg|\.png|\.jfif)$/i;
        if(!allowedExtensions.exec(fileInput)){
            alert('Please upload file having extensions .jpeg/.jpg/.png/.jfif only.');
            file.value = '';
            file.focus();
            return false;
        }else{
            return true;
        }
    }

</script>

<script src="assets/js/main.js"></script>

</body>

</html>