Hướng dẫn crud image php mysqli

In this tutorial, we will learn how to create CRDU operation with image using PHP and MySQLi.

Files includes in this tutorials

phpcrud.sql: Contain the database table structure.
dbconnection.php: Used for database connection.
index.php: Used to fetch the record from the database.
insert.php: Used to insert the new record.
read.php: Used to fetch the record of the particular user.
edit.php: Used to edit the record.
change-image.php: Used to change the profile pic.

Step 1– Create a database

Open browser type http://localhost/phpmyadmin, create a database named ‘phpcrud’. After creating the database run the SQL script or import the SQL file.

MySQL Table tblusers structure

CREATE TABLE`tblusers`(

`ID`int(10)NOTNULL,

`FirstName` varchar(200)DEFAULTNULL,

`LastName`varchar(200)DEFAULTNULL,

`MobileNumber` bigint(10)DEFAULTNULL,

`Email`varchar(200)DEFAULTNULL,

`Address`mediumtext DEFAULTNULL,

`ProfilePic`varchar(200)DEFAULTNULL,

`CreationDate`timestamp NOTNULL DEFAULTcurrent_timestamp()ON UPDATE current_timestamp()

)ENGINE=InnoDB DEFAULTCHARSET=utf8mb4;

Step 2– Create a database connection file(dbconnection.php)

$con=mysqli_connect("localhost","root","","phpcrud");

if(mysqli_connect_errno())

{

echo"Connection Fail".mysqli_connect_error();

}

Step 3– Create an HTML form for data insertion. (insert.php)

<pclass="hint-text">Fill below form.</p>

</div>

</div>

</div>

</div>

<span style="color:red; font-size:12px;">Only jpg/jpeg/ png/gif format allowed.</span>

</div>

<button type="submit"class="btn btn-success btn-lg btn-block"name="submit">Submit</button>

</div>

</form>

Step 4– Now write PHP Code for data insertion and put this code at the top of the insert.php file.

//Databse Connection file

include('dbconnection.php');

if(isset($_POST['submit']))

{

//getting the post values

$fname=$_POST['fname'];

$lname=$_POST['lname'];

$contno=$_POST['contactno'];

$email=$_POST['email'];

$add=$_POST['address'];

$ppic=$_FILES["profilepic"]["name"];

// get the image extension

$extension= substr($ppic,strlen($ppic)-4,strlen($ppic));

// allowed extensions

$allowed_extensions= array(".jpg","jpeg",".png",".gif");

// Validation for allowed extensions .in_array() function searches an array for a specific value.

if(!in_array($extension,$allowed_extensions))

{

echo"";

}

else

{

//rename the image file

$imgnewfile=md5($imgfile).time().$extension;

// Code for move image into directory

move_uploaded_file($_FILES["profilepic"]["tmp_name"],"profilepics/".$imgnewfile);

// Query for data insertion

$query=mysqli_query($con, "insert into tblusers(FirstName,LastName, MobileNumber, Email, Address,ProfilePic) value('$fname','$lname', '$contno', '$email', '$add','$imgnewfile' )");

if($query){

echo"";

echo "";

}else{

echo"";

}}

}

Step 5– Read / Fetch the record from the database(index.php)

In this step, we will read/fetch all data from the database including images.

<thead>

<tr>

<th>#

<th>Profile Pic</th>

<th>Email</th>

<th>Mobile Number</th>

<th>CreatedDate</th>

<th>Action</th>

</tr>

</thead>

<tbody>

$ret=mysqli_query($con,"select * from tblusers");

$cnt=1;

$row=mysqli_num_rows($ret);

if($row>0){

while($row=mysqli_fetch_array($ret)){

<tr>

<td><img src="profilepics/ echo $row['ProfilePic'];?>"width="80"height="80"></td>

<td> echo $row['FirstName'];?> echo$row['LastName'];?></td>

<td> echo $row['Email'];?></td>

<td> echo $row['MobileNumber'];?></td>

<td> echo$row['CreationDate'];?></td>

<td>

<ahref="read.php?viewid=echohtmlentities($row['ID']);?>"class="view"title="View" data-toggle="tooltip"><iclass="material-icons">

<ahref="edit.php?editid=echohtmlentities ($row['ID']);?>"class="edit"title="Edit"data-toggle="tooltip"><iclass="material-icons">

<ahref="index.php?delid=echo($row['ID']);?>&&ppic=echo$row['ProfilePic'];?>" class="delete"title="Delete"data-toggle="tooltip"onclick="return confirm('Do you really want to Delete ?');"><iclass="material-icons">

</td>

</tr>

$cnt=$cnt+1;

}}else{?>

<tr>

<th style="text-align:center; color:red;"colspan="6">NoRecordFound</th>

</tr>

}?>

</tbody>

</table>

Step 6–Read / Fetch the particular record (read.php)

create read.php file. For fetching a record we have to get the row id of that record and store it in $vid. We access the $_GET[‘viewid’] variable to do it.
Code for gets a record based on the given id.

<h2>User<b>Details</b></h2>

</div>

$vid=$_GET['viewid'];

$ret=mysqli_query($con,"select * from tblusers where ID =$vid");

$cnt=1;

while($row=mysqli_fetch_array($ret)){

<ahref="edit.php?editid=echohtmlentities($row['ID']);?>"class="btn btn-primary"><span>Edit User Details</span></a>

</div>

<tbody>

<tr>

<th width="200">Profile Pic</th>

<td><img src="profilepics/ echo$row['ProfilePic'];?>" width="80"height="80"></td>

<th width="200">CreationDate</th>

<td> echo $row['CreationDate'];?></td>

</tr>

<tr>

<th>FirstName</th>

<td> echo$row['FirstName'];?></td>

<th>LastName</th>

<td> echo$row['LastName'];?></td>

</tr>

<tr>

<th>Email</th>

<td> echo$row['Email'];?></td>

<th>MobileNumber</th>

<td> echo$row['MobileNumber'];?></td>

</tr>

<tr>

<th>Address</th>

<td> echo $row['Address'];?></td>

</tr>

$cnt=$cnt+1;

}?>

</tbody>

</table>

Step 7 –Edit/ Update the particular record (edit.php)

Step 7.1 Fetch the data in the HTML Form.

create edit.php file. For updating a record we have to get the row id of that record and store in $eid. We access the $_GET[‘editid’] variable to do it.
Code for gets a record based on the given id. In this way, we can get data autofill-data in HTML Form.

$eid=$_GET['editid'];

$ret=mysqli_query($con,"select * from tblusers where ID='$eid'");

while($row=mysqli_fetch_array($ret)){

<h2>Update</h2>

<p class="hint-text">Update your info.</p>

<img src="profilepics/ echo $row['ProfilePic'];?>"width="120"height="120">

<ahref="change-image.php?userid=echo $row['ID'];?>">Change Image</a>

</div>

<div class="col"><input type="text"class="form-control"name="fname"value=" echo $row['FirstName'];?>"required="true"></div>

<div class="col"><input type="text" class="form-control"name="lname"value=" echo$row['LastName'];?>"required="true"></div>

</div>

<input type="text"class="form-control" name="contactno"value=" echo$row['MobileNumber'];?>"required="true"maxlength="10" pattern="[0-9]+">

</div>

<input type="email"class="form-control" name="email"value=" echo$row['Email'];?>"required="true">

</div>

<textarea class="form-control"name="address"required="true"> echo$row['Address'];?></textarea>

</div>

}?>

<button type="submit"class="btn btn-success btn-lg btn-block" name="submit">Update</button>

</div>

</form>

Step 7.1 Code for update the particular record. Put this code on the top of the edit.php

//Database Connection

include('dbconnection.php');

if(isset($_POST['submit']))

{

$eid=$_GET['editid'];

//Getting Post Values

$fname=$_POST['fname'];

$lname=$_POST['lname'];

$contno=$_POST['contactno'];

$email=$_POST['email'];

$add=$_POST['address'];

//Query for data updation

$query=mysqli_query($con, "update tblusers set FirstName='$fname',LastName='$lname', MobileNumber='$contno', Email='$email', Address='$add' where ID='$eid'");

if($query){

echo"";

}

else

{

echo"";

}

Step 7.3 create a page for image updation. (change-image.php)

create change-image.php file. For updating a profile pic we have to get the row id of that record and store it in $eid. We access the $_GET['userid'] variable to do it.

$eid=$_GET['userid'];

$ret=mysqli_query($con,"select * from tblusers where ID='$eid'");

while($row=mysqli_fetch_array($ret)){

<h2>Update</h2>

<p class="hint-text">Update your profile pic.</p>

<img src="profilepics/ echo$row['ProfilePic'];?>" width="120"height="120">

</div>

<span style="color:red; font-size:12px;">Only jpg/jpeg/png/gif format allowed.</span>

</div>

<button type="submit"class="btn btn-success btn-lg btn-block" name="submit">Update</button>

</div>

}?>

</form>

Step 7.4 Code for update the particular user profile pic. Put this code on the top of the change-image.php

//Database Connection

include('dbconnection.php');

if(isset($_POST['submit']))

{

$uid=$_GET['userid'];

//getting the post values

$ppic=$_FILES["profilepic"]["name"];

$oldppic=$_POST['oldpic'];

$oldprofilepic="profilepics"."/".$oldppic;

// get the image extension

$extension=substr($ppic,strlen($ppic)-4,strlen($ppic));

// allowed extensions

$allowed_extensions= array(".jpg","jpeg",".png",".gif");

// Validation for allowed extensions .in_array() function searches an array for a specific value.

if(!in_array($extension,$allowed_extensions))

{

echo"";

}else{

//rename the image file

$imgnewfile=md5($imgfile).time().$extension;

// Code for move image into directory

move_uploaded_file($_FILES["profilepic"]["tmp_name"],"profilepics/".$imgnewfile);

// Query for data insertion

$query=mysqli_query($con,"update tblusers set ProfilePic='$imgnewfile' where id='$uid' ");

if($query){

//Old pic deletion

unlink($oldprofilepic);

echo"";

echo "";

}else{

echo"";

}

Step 8 – Code for data deletion a record from the database

//database conection file

include('dbconnection.php');

//Code for deletion

if(isset($_GET['delid']))

{

$rid=intval($_GET['delid']);

$profilepic=$_GET['ppic'];

$ppicpath="profilepics"."/".$profilepic;

$sql=mysqli_query($con,"delete from tblusers where ID=$rid");

unlink($ppicpath);

echo"";

}

Download Source Code (php-mysqli-crud-with-image)

Size: 201 KB

Version: V 1.0

Anuj Kumar

Hi! I am Anuj Kumar, a professional web developer with 5+ years of experience in this sector. I found PHPGurukul in September 2015. My keen interest in technology and sharing knowledge with others became the main reason for starting PHPGurukul. My basic aim is to offer all web development tutorials like PHP, PDO, jQuery, PHP oops, MySQL, etc. Apart from the tutorials, we also offer you PHP Projects, and we have around 100+ PHP Projects for you.

Hướng dẫn crud image php mysqli

Step 1– Create a database

Step 7 –Edit/ Update the particular record (edit.php)

Bài Viết Liên Quan

Quảng Cáo

Có thể bạn quan tâm

Toplist được quan tâm

Quảng cáo

Xem Nhiều

Quảng cáo

Chúng tôi

Điều khoản

Trợ giúp

Mạng xã hội