PHP – Web Design

PHP

MYSQL PHP WEB DEVELOPMENT

How to Create PHP login with Remember me Function

Remember me function is used to save the username and password in login form entered by the user. In this tutorial we are using COOKIES for saving preserving username and user password in the login from. Step 1 : Create a simple html form

<div align="center">
<form action="" method="post" id="login">
<div class="error-message"><?php if(isset($message)) { echo $message; } ?></div>
<h4> PHP login with remember me function</h4>
<div class="field-group">
<div><label for="login">Username</label></div>
<div>
<input name="username" type="text" value="<?php if(isset($_COOKIE["user_login"])) { echo $_COOKIE["user_login"]; } ?>" class="input-field">
</div>
<div class="field-group">
		<div><label for="password">Password</label></div>
		<div><input name="password" type="password" value="<?php if(isset($_COOKIE["userpassword"])) { echo $_COOKIE["userpassword"]; } ?>" class="input-field">
	</div>
	<div class="field-group">
		<div><input type="checkbox" name="remember" id="remember" <?php if(isset($_COOKIE["user_login"])) { ?> checked <?php } ?> />
		<label for="remember-me">Remember me</label>
	</div>
	<div class="field-group">
		<div><input type="submit" name="login" value="Login" class="form-submit-button"></span></div>
	</div>
</form>
</div>

<h4> PHP login with remember me function</h4>

<div><label for="login">Username</label></div>

<div>

<input name="username" type="text" value="<?php if(isset($_COOKIE["user_login"])) { echo $_COOKIE["user_login"]; } ?>" class="input-field">

</div>

<div><label for="password">Password</label></div>

<div><input name="password" type="password" value="<?php if(isset($_COOKIE["userpassword"])) { echo $_COOKIE["userpassword"]; } ?>" class="input-field">

</div>

<div><input type="checkbox" name="remember" id="remember" <?php if(isset($_COOKIE["user_login"])) { ?> checked <?php } ?> />

<label for="remember-me">Remember me</label>

</div>

</div>

</form>

</div>

Step 2 : Create a SQL table tbluser

CREATE TABLE `tbluser` (
  `id` int(11) NOT NULL,
  `userName` varchar(200) DEFAULT NULL,
  `userPassword` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `tbluser`
  ADD PRIMARY KEY (`id`);

CREATE TABLE `tbluser` (

`id` int(11) NOT NULL,

`userName` varchar(200) DEFAULT NULL,

`userPassword` varchar(255) DEFAULT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tbluser`

ADD PRIMARY KEY (`id`);

Step 3 : Create database configuration […]

PHP

How to delete multiple records in PHP

SQl Table Structure for this tutorial

CREATE TABLE `tblusers` (
  `id` int(11) NOT NULL,
  `FullName` varchar(140) DEFAULT NULL,
  `Education` varchar(120) DEFAULT NULL,
  `postingDate` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `tblusers`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `tblusers`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

CREATE TABLE `tblusers` (

`id` int(11) NOT NULL,

`FullName` varchar(140) DEFAULT NULL,

`Education` varchar(120) DEFAULT NULL,

`postingDate` int(11) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tblusers`

ADD PRIMARY KEY (`id`);

ALTER TABLE `tblusers`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1;

Fetch the data from database and create checkbox . Checkbox name attribute is an array.

<form name="multipledeletion" method="post">
  
<div class="container">
    <div class="row col-md-6 col-md-offset-2 custyle">
 
<h2>How to delete Multiple Record in PHP</h2>
 
        <!-- Message -->
        <p style="color:red; font-size:16px;">
        <?php if($errmsg){ echo $errmsg; } ?>  </p>
    <table class="table table-striped custab">
        <!-- Deletion Button -->
        <tr>
           <td colspan="4">  <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> 
        </tr>
 <tr>
    <th>
<!-- For Selecting All -->
     <li><input type="checkbox" id="select_all" /> Select all</li></th>
    <th>Name</th>
    <th>Education   </th>
    <th>Date</th> 
 </tr>   
<?php
$query=mysqli_query($con,"select * from tblusers");
$totalcnt = mysqli_num_rows($query);
if ($totalcnt > 0) {
while ($row=mysqli_fetch_array($query)) {
?>
 
<tr>
<td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td>
<td><?php echo htmlentities($row['FullName']);?></td> 
<td><?php echo htmlentities($row['Education']);?></td>
<td><?php echo htmlentities($row['postingDate']);?></td>
</tr>
<?php } } else { ?> 
<tr>
<td  colspan="4"> No Record Found</td>
</tr>   
<?php } ?>
</table>
</div>
</div>
</form>

<h2>How to delete Multiple Record in PHP</h2>

<?php if($errmsg){ echo $errmsg; } ?> </p>

<tr>

</tr>

<tr>

<th>

<li><input type="checkbox" id="select_all" /> Select all</li></th>

<th>Education </th>

</tr>

<?php

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

$totalcnt = mysqli_num_rows($query);

if ($totalcnt > 0) {

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

<tr>

</tr>

<?php } } else { ?>

<tr>

<td colspan="4"> No Record Found</td>

</tr>

<?php } ?>

</table>

</div>

</form>

On Submitting the from collect all checkbox ids and implode their ids

if (isset($_POST["submit"])) {
    if (count($_POST["ids"]) > 0 ) {
        // Imploding checkbox ids
        $all = implode(",", $_POST["ids"]);
        $sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)");
        if ($sql) {
            $errmsg ="Data has been deleted successfully";
        } else {
            $errmsg ="Error while deleting. Please Try again."; 
        }
    } else {
        $errmsg = "You need to select atleast one checkbox to delete!";
    }
    
}

if (isset($_POST["submit"])) {

if (count($_POST["ids"]) > 0 ) {

// Imploding checkbox ids

$all = implode(",", $_POST["ids"]);

$sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)");

if ($sql) {

$errmsg ="Data has been deleted successfully";

} else {

$errmsg ="Error while deleting. Please Try again.";

}

} else {

$errmsg = "You need to select atleast one checkbox to delete!";

}

HERE IS THE FULL CODE WRITTEN DURING THIS TUTORIAL :

<?php
include('dbconfig.php');
error_reporting(0);
if (isset($_POST["submit"])) {
    if (count($_POST["ids"]) > 0 ) {
        // Imploding checkbox ids
        $all = implode(",", $_POST["ids"]);
        $sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)");
        if ($sql) {
            $errmsg ="Data has been deleted successfully";
        } else {
            $errmsg ="Error while deleting. Please Try again."; 
        }
    } else {
        $errmsg = "You need to select atleast one checkbox to delete!";
    }  
}
?>
<!DOCTYPE html>
<html>
<head>
<meta name="description" content="How to delete multiple record in PHP">
<meta name="keywords" content="How to delete multiple record in PHP">
<meta name="author" content="Anuj Kumar">
<title>How to delete Multiple Data in PHP</title>
<link href="//netdna.bootstrapcdn.com/bootstrap/3.0.0/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//netdna.bootstrapcdn.com/bootstrap/3.0.0/js/bootstrap.min.js"></script>
<script src="//code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.11.2/jquery.min.js"></script>
<style type="text/css">
.custab{
    border: 1px solid #ccc;
    padding: 5px;
    margin: 5% 0;
    box-shadow: 3px 3px 2px #ccc;
    transition: 0.5s;
    }
.custab:hover{
    box-shadow: 3px 3px 0px transparent;
    transition: 0.5s;
    }
    li {
  list-style-type: none;
}
    </style>
</head>
<body>     
<form name="multipledeletion" method="post">
<div class="container">
<div class="row col-md-6 col-md-offset-2 custyle">
<h2>How to delete Multiple Record in PHP</h2>
 
        <!-- Message -->
        <p style="color:red; font-size:16px;">
        <?php if($errmsg){ echo $errmsg; } ?>  </p>
    <table class="table table-striped custab">
        <!-- Deletion Button -->
        <tr>
           <td colspan="4">  <input type="submit" name="submit" value="Delete" class="btn btn-primary btn-md pull-left" onClick="return confirm('Are you sure you want to delete?');" ></td> 
        </tr>
 <tr>
    <th>
<!-- For Selecting All -->
     <li><input type="checkbox" id="select_all" /> Select all</li></th>
    <th>Name</th>
    <th>Education   </th>
    <th>Date</th> 
 </tr>   
<?php
$query=mysqli_query($con,"select * from tblusers");
$totalcnt = mysqli_num_rows($query);
if ($totalcnt > 0) {
while ($row=mysqli_fetch_array($query)) {
?>
 
<tr>
<td><input type="checkbox" class="checkbox" name="ids[]" value="<?php echo htmlentities($row['id']);?>"/></td>
<td><?php echo htmlentities($row['FullName']);?></td> 
<td><?php echo htmlentities($row['Education']);?></td>
<td><?php echo htmlentities($row['postingDate']);?></td>
</tr>
<?php } } else { ?> 
<tr>
<td  colspan="4"> No Record Found</td>
</tr>   
<?php } ?>
</table>
</div>
</div>
</form>
 
<script type="text/javascript">
$(document).ready(function(){
    $('#select_all').on('click',function(){
        if(this.checked){
            $('.checkbox').each(function(){
                this.checked = true;
            });
        }else{
             $('.checkbox').each(function(){
                this.checked = false;
            });
        }
    });
    $('.checkbox').on('click',function(){
        if($('.checkbox:checked').length == $('.checkbox').length){
            $('#select_all').prop('checked',true);
        }else{
            $('#select_all').prop('checked',false);
        }
    });
});
</script>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

<?php

include('dbconfig.php');

error_reporting(0);

if (isset($_POST["submit"])) {

if (count($_POST["ids"]) > 0 ) {

// Imploding checkbox ids

$all = implode(",", $_POST["ids"]);

$sql =mysqli_query($con,"DELETE FROM tblusers WHERE id in ($all)");

if ($sql) {

$errmsg ="Data has been deleted successfully";

} else {

$errmsg ="Error while deleting. Please Try again.";

}

} else {

$errmsg = "You need to select atleast one checkbox to delete!";

}

<!DOCTYPE html>

<html>

<head>

<title>How to delete Multiple Data in PHP</title>

.custab{

border: 1px solid #ccc;

padding: 5px;

margin: 5% 0;

box-shadow: 3px 3px 2px #ccc;

transition: 0.5s;

}

.custab:hover{

box-shadow: 3px 3px 0px transparent;

transition: 0.5s;

}

li {

list-style-type: none;

}

</style>

</head>

<body>

<h2>How to delete Multiple Record in PHP</h2>

<?php if($errmsg){ echo $errmsg; } ?> </p>

<tr>

</tr>

<tr>

<th>

<li><input type="checkbox" id="select_all" /> Select all</li></th>

<th>Education </th>

</tr>

<?php

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

$totalcnt = mysqli_num_rows($query);

if ($totalcnt > 0) {

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

<tr>

</tr>

<?php } } else { ?>

<tr>

<td colspan="4"> No Record Found</td>

</tr>

<?php } ?>

</table>

</div>

</form>

$(document).ready(function(){

$('#select_all').on('click',function(){

if(this.checked){

$('.checkbox').each(function(){

this.checked = true;

});

}else{

$('.checkbox').each(function(){

this.checked = false;

});

}

});

$('.checkbox').on('click',function(){

if($('.checkbox:checked').length == $('.checkbox').length){

$('#select_all').prop('checked',true);

}else{

$('#select_all').prop('checked',false);

}

});

</script>

</body>

</html>

PHP

How to Create a Simple Registration with PHP Email Verification Script

In this tutorail I will explain how to verify a registered email id using PHP. This tutorial include following files 1.Registration file(index.php) 2.Email Verification file(email_verification.php) 3.Login file(login.php) 4. Welcome file(welcome.php) 5. Logout file(logout.php) 6.Database Connection(config.php) Database include one table(userregistration) Structure of userregistration table

CREATE TABLE IF NOT EXISTS `userregistration` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `activationcode` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  `postingdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;<input id="5390.7165924824451" class="cdbx-try-code-web cdbx-btn-main" style="background-color: #ffffff; margin-bottom: 0; color: #008b8b; border: 1px solid rgba(231, 231, 230, 1); border-radius: 10px; font-size: 13px; height: 30px; min-width: 110px; max-width: 220px; padding: 4px; font-weight: normal; outline: none; display: none; float: right;" type="button" value="Run HTML" data-lang="html" data-code="1544284295617.0935" />

CREATE TABLE IF NOT EXISTS `userregistration` (

`id` int(11) NOT NULL,

`name` varchar(255) NOT NULL,

`email` varchar(255) NOT NULL,

`password` varchar(255) NOT NULL,

`activationcode` varchar(255) NOT NULL,

`status` int(11) NOT NULL,

`postingdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP

) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;<input id="5390.7165924824451" class="cdbx-try-code-web cdbx-btn-main" style="background-color: #ffffff; margin-bottom: 0; color: #008b8b; border: 1px solid rgba(231, 231, 230, 1); border-radius: 10px; font-size: 13px; height: 30px; min-width: 110px; max-width: 220px; padding: 4px; font-weight: normal; outline: none; display: none; float: right;" type="button" value="Run HTML" data-lang="html" data-code="1544284295617.0935" />

User Registration form(index.php)

&lt;form name="insert" action="" method="post"&gt;
&lt;table width="100%"  border="0"&gt;
&lt;tr&gt;
&lt;th height="62" scope="row"&gt;Name &lt;/th&gt;
&lt;td width="71%"&gt;&lt;input type="text" name="name" id="name" value=""  class="form-control" required /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;th height="62" scope="row"&gt;Email id &lt;/th&gt;
&lt;td width="71%"&gt;&lt;input type="email" name="email" id="email" value=""  class="form-control" required /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;th height="62" scope="row"&gt;Password &lt;/th&gt;
&lt;td width="71%"&gt;&lt;input type="password" name="password" id="password" value=""  class="form-control" required /&gt;&lt;/td&gt;
&lt;/tr&gt;
&lt;tr&gt;
&lt;th height="62" scope="row"&gt;&lt;/th&gt;
&lt;td width="71%"&gt;&lt;input type="submit" name="submit" value="Submit" class="btn-group-sm" /&gt; &lt;/td&gt;
&lt;/tr&gt;
&lt;/table&gt;
&lt;/form&gt;<input id="664.9785144824451" class="cdbx-try-code-web cdbx-btn-main" style="background-color: #ffffff; margin-bottom: 0; color: #008b8b; border: 1px solid rgba(231, 231, 230, 1); border-radius: 10px; font-size: 13px; height: 30px; min-width: 110px; max-width: 220px; padding: 4px; font-weight: normal; outline: none; display: none; float: right;" type="button" value="Run HTML" data-lang="html" data-code="1544284415879.466" />

<tr>

</tr>

<tr>

<th height="62" scope="row">Email id </th>

</tr>

<tr>

<th height="62" scope="row">Password </th>

</tr>

<tr>

</tr>

</table>

</form><input id="664.9785144824451" class="cdbx-try-code-web cdbx-btn-main" style="background-color: #ffffff; margin-bottom: 0; color: #008b8b; border: 1px solid rgba(231, 231, 230, 1); border-radius: 10px; font-size: 13px; height: 30px; min-width: 110px; max-width: 220px; padding: 4px; font-weight: normal; outline: none; display: none; float: right;" type="button" value="Run HTML" data-lang="html" data-code="1544284415879.466" />

Php code for data insertion or sending […]

jQuery-Ajax Tutorials MYSQL PHP

How to Create Who Is Online” Widget With PHP, MySQL & jQuery

Step 1 – XHTML As usual, we start off with the XHTML part. The code presented here might not look like much, but it is all that we need to show off all the work that has been done by the backend. The widget features a slick slide-out panel with all the geolocation data, shown […]

PHP

How to Create PHP Login (Full Script)

Learn to create a simple login system with php + mysql script, this tutorial is easy to follow, teach you step by step. Overview In this tutorial, we create 3 php files for testing our code. 1. main_login.php 2. checklogin.php 3. login_success.php Steps 1. Create table “members” in database “test”. 2. Create file main_login.php. 3. […]

PHP

How to Create PHP Multiple Files Upload

You can upload multiple files with one time submit. Array is a big role in this tutorial, let’s see the scripts. Project Structure: In this tutorial, create 2 files 1. multiple_upload.php 2. multiple_upload_ac.php Steps 1. Create file multiple_upload.php 2. Create file multiple_upload_ac.php 3. Create folder “upload” for store uploaded files. .4. CHMOD your upload folder […]

PHP PHP OOPs

Abstract classes and methods (PHP OOPs)

We use abstract classes and methods when we need to commit the child classes to certain methods that they inherit from the parent class but we cannot commit about the code that should be written inside the methods. An abstract class is a class that has at least one abstract method. Abstract methods can only […]

PHP WEB DEVELOPMENT

PHP CRUD Operation using PDO Extension

In the previous tutorial we learned about PDO Extension . In this tutorial we will learn CRUD operation using PDO Extension. CRUD Stands for create, read, update and delete record in the database. File Structure for CRUD Operation dbconfig.php- used for database connection tblusers.sql– Contain the structure of the database table insert.php- used for add a record in the database index.php– Used […]

PHP PHP PROJECT WEB DEVELOPMENT

How to Create Password Hashing in PHP

Functions for hashing password password_hash() password_verify() password_hash() – Syntax:

string password_hash(string $password , integer $algo [, array $options ] )

1	string password_hash(string $password , integer $algo [, array $options ] )

string $password – Password provide by user integer $algo – Password algorithm constant(PASSWORD_DEFAULT and PASSWORD_BCRYPT) PASSWORD_DEFAULT – uses the BCrypt algorithm to create the hash PASSWORD_BCRYPT – uses the CRYPT_BLOWFISH algorithm and will return a 60 character string $options – $options have two indexes.One is cost and another one is salt. Cost- Cost […]

CSS DEMOS HTML MYSQL PHP PHP PROJECT

How to Fetch Data in Excel or Generate Excel file in PHP

File structure for this tutorial : config.php (database connection file) index.php (For fetching data ) genrate-excel.php (For genrating excel file) Create a sql table tblemployee. Structure of sql table employe .

CREATE TABLE `tblemploye` (
  `id` int(11) NOT NULL,
  `fullName` varchar(120) NOT NULL,
  `emailId` varchar(150) NOT NULL,
  `phoneNumber` int(11) NOT NULL,
  `department` varchar(100) NOT NULL,
  `joiningDate` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
ALTER TABLE `tblemploye`
  ADD PRIMARY KEY (`id`);
ALTER TABLE `tblemploye`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
COMMIT;

CREATE TABLE `tblemploye` (

`id` int(11) NOT NULL,

`fullName` varchar(120) NOT NULL,

`emailId` varchar(150) NOT NULL,

`phoneNumber` int(11) NOT NULL,

`department` varchar(100) NOT NULL,

`joiningDate` varchar(100) NOT NULL

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `tblemploye`

ADD PRIMARY KEY (`id`);

ALTER TABLE `tblemploye`

MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

COMMIT;

Now insert some data into this table.

INSERT INTO `tblemploye` (`id`, `fullName`, `emailId`, `phoneNumber`, `department`, `joiningDate`) VALUES
(1, 'Ogbugbu Ejiroghene, 'ogbugbu14@gmail.com', 08154761214, 'IT', '2018-05-01'),
(2, 'Ejiro', 'john@test.com', 45455454, 'HR', '2017-08-12'),
(3, 'Kefe', 'demo@test.com', 23423423, 'Account', '2016-10-01'),
(4, 'Test', 'test@test.com', 834856384, 'IT', '2017-12-01');

INSERT INTO `tblemploye` (`id`, `fullName`, `emailId`, `phoneNumber`, `department`, `joiningDate`) VALUES

(1, 'Ogbugbu Ejiroghene, 'ogbugbu14@gmail.com', 08154761214, 'IT', '2018-05-01'),

(2, 'Ejiro', 'john@test.com', 45455454, 'HR', '2017-08-12'),

(3, 'Kefe', 'demo@test.com', 23423423, 'Account', '2016-10-01'),

(4, 'Test', 'test@test.com', 834856384, 'IT', '2017-12-01');

Index.php in this file we will read the data from database.

?php
$query=mysqli_query($con,"select * from tblemploye");
$cnt=1;
while ($row=mysqli_fetch_array($query)) {
 
?>
  <tr>
                <td><?php echo $cnt;  ?></td>
                <td><?php echo $row['fullName']?></td>
                <td><?php echo $row['emailId']?></td>
                <td><?php echo $row['phoneNumber']?></td>
                <td><?php echo $row['department']?></td>
                <td><?php echo $row['joiningDate']?></td>
            </tr>
<?php 
$cnt++;
} ?>       
</table>

?php

$query=mysqli_query($con,"select * from tblemploye");

$cnt=1;

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

<tr>

</tr>

<?php

$cnt++;

} ?>

</table>

genrate-excel.php in this […]

CSS HTML MYSQL PHP

Upload and Preview sing PHP and MySQL Database

User experience can be greatly improved on an image upload feature if we enable the user to preview the image they have selected before actually uploading it to the server by clicking the upload button. In this tutorial, we will create a form that takes two inputs: the user’s profile picture (image), and their bio […]

CSS DEMOS HTML MYSQL PHP PHP PROJECT WEB DEVELOPMENT

Creating a web chat with PHP and MySQL

In this Tutorial, I’ll show you how you can write your very own web-based Chat App using HTML, CSS, JavaScript/jQuery, PHP and MySQL. For a full functioning Web-Chat we’ll need three basic components: A Client-Side HTML Document that sends the Chat Text and receives Data from the database A PHP file which writes user input […]