Image format

How to restrict image format upload in php and mysql

Source code


									// DB credentials.
									// Establish database connection.
										$dbh = new PDO("mysql:host=".DB_HOST.";dbname=".DB_NAME,DB_USER, DB_PASS,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8'"));
									catch (PDOException $e)
										exit("Error: " . $e->getMessage());


									include "config.php";
									// Uploads files
									if(isset($_POST['save'])) { // if save button on the form is clicked
									  // name of the uploaded file
									  $filename = $_FILES['myfile']['name'];
									  // destination of the file on the server
									  $destination = 'media/' . $filename;
									  // get the file extension
									  $extension = pathinfo($filename, PATHINFO_EXTENSION);
									  // the physical file on a temporary uploads directory on the server
									  $file = $_FILES['myfile']['tmp_name'];
									  if (!in_array($extension, [ 'jpg']))
									    echo "<script>alert('You file extension must be .jpg');</script>";
									  else {
									    // move the uploaded (temporary) file to the specified destination
									    if (move_uploaded_file($file, $destination)) {
									      $sql = "INSERT INTO imageformat (filename) VALUES ('$filename')";
									      if (mysqli_query($conn, $sql)) 
									        echo "<script>alert('Image uploaded successfully');</script>";
									      } else {
									        echo "<script>alert('Failed to upload file.');</script>";

									<!DOCTYPE HTML>
									<html lang="en">
									 <meta charset="utf-8">
									 <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
									 <title>How to restrict image format upload in php</title>
									 <!--Bootstrap -->
									 <link rel="stylesheet" href="css/bootstrap.css" type="text/css">
									  <div class="container">
									    <p style="font-size: 23px;">How to restrict image format upload in php</p>
									    <form class="form-horizontal row-fluid" name="insertimage" method="post" enctype="multipart/form-data">
									      <div class="control-group"> 
									        <label class="control-label" for="basicinput">Upload Image(<span style="color: red;">Format is restricted to jpg only</span> )</label>
									        <div> </div>
									        <div class="controls">
									          <input type="file" name="myfile" id="myfile" value="" class="span8 tip" required>
									      <div class="form-group row">
									        <div class="col-12">
									          <button type="submit" class="btn btn-success" name="save">
									            <i class="fa fa-plus "></i> Upload

									    <table id="" class="table table-bordered">
									          <th>Image Name</th>


									        $sql = "SELECT * from imageformat  order by id desc";
									        $query = $dbh -> prepare($sql);
									        if($query->rowCount() > 0)
									          foreach($results as $result)
									              <td><?php echo $cnt;?></td>
									              <td><img class="" src="media/<?php  echo $result->filename;?>" alt="Image" width="100" height="80"></td>
									              <td><?php echo ($result->filename) ?></td>
									        } ?>


Mary Khosh

Just tell me how can I donate.

Beauty Shallon

Am sure you are the best, thank you for every thing.

Polly Giz

awesome code thank you 100 times.

Leave a Comment:

You Might Also Like

hostel booking

Hostel booking management system
Learn More

car rental

Car rental management system in Php
Learn More

student details

Student details management system
Learn More


Tourism management system in Php and Mysql
Learn More

Latest Tutorial

sweet alerts

How to delete table row using sweet alert2
Learn More


How to create piechart with Mysql data
Learn More

register and login

How to register and login in php
Learn More

edit data

How to edit Mysql data in modal using php
Learn More