Skip to content

Instantly share code, notes, and snippets.

@biplab3

biplab3/uploadimageintophpmysql.php

Last active September 14, 2022 18:36
Show Gist options
  • Save biplab3/e6bf036b7101665cfd2772d65b5caf44 to your computer and use it in GitHub Desktop.
Save biplab3/e6bf036b7101665cfd2772d65b5caf44 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
uploadimageintophpmysql.php
<?php
include('connect.php');
//insert data into database
if(isset($_POST['save'])){
$name=$_POST['name'];
$age=$_POST['age'];
$target="images/".basename($_FILES['image']['name']);
$sql="INSERT INTO image(name,age,image)VALUES('$name','$age','$target')";
$stmt=$con->prepare($sql);
$stmt->execute();
move_uploaded_file($_FILES['image']['tmp_name'],$target);
echo "<div class='alert alert-success' role='alert'>Submitted Successfully</div>";
}
//fetch the data from table
$stmt2 = $con->prepare("select * from image order by id DESC");
$stmt2->execute();
$details = $stmt2->fetchAll(PDO::FETCH_ASSOC);
?>
<html>
<head>
<title>image example</title>
<link rel="stylesheet" href="bootstrap.css" crossorigin="anonymous">
<!-- Optional theme -->
<link rel="stylesheet" href="bootstrap-theme.css" crossorigin="anonymous">
<style>
.container{
width:50%;
height:30%;
padding:20px;
}
</style>
</head>
<body>
<div class="container">
<h3><u>Upload image and insert into database in PHP</u></h3>
<br/>
<form action="" method="post" enctype="multipart/form-data">
<div class="row">
<div class="col-sm-8">
<div class="form-group">
<label for="name">Name:</label>
<input type="text" class="form-control" name="name">
</div>
</div>
</div>
<div class="row">
<div class="col-sm-8">
<div class="form-group">
<label for="name">Age*:</label>
<input type="number" class="form-control" name="age">
</div>
</div>
</div>
<div class="row">
<div class="col-sm-8">
<div class="form-group">
<label for="name">Image*:</label>
<input type="file" class="form-control" name="image">
</div>
</div>
</div>
<br/><br/>
<button type="submit" class="btn btn-primary" name="save">Submit</button>
</form>
<br/><br/>
<h3>View Details</h3><br/>
<table class="table table-bordered">
<thead>
<tr>
<th>Name</th>
<th>Age</th>
<th>Image</th>
</tr>
</thead>
<tbody>
<?php
foreach($details as $detail){
if($detail){
?>
<tr>
<td><?php echo $detail['name'];?></td>
<td><?php echo $detail['age'];?></td>
<td><img src="<?php echo $detail['image']?>" width="200" height="150" alt="photo"></img></td>
</tr>
<?php
}
else{
?>
<tr>
<td colspan="3" style="text-align: center">Not available</td>
</tr>
<?php
}
}
?>
</tbody>
</table>
</div>
<script src="jquery-3.2.1.min.js"></script>
<script src="bootstrap.min.js"></script>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment