Wednesday, September 16, 2020

Part 8-[B]-Admin Panel(Login-B): Login System with Session and Security in php

Part 8 (A & B): Login System with Session and Security.

As per the video, we have already downloaded the files and linked the CSS and JS.

Do not forget to Copy Step 4: if you are following from previous parts. because in this security.php we are checking loggedIN or not.

Step 1: Create a login.php page and paste the below:

<?php

session_start();

<h1 class="h4 text-gray-900 mb-4">Login Here!</h1>

<?php

if(isset($_SESSION['status']) && $_SESSION['status'] !='')

{

echo '<h2 class="bg-danger text-white"> '.$_SESSION['status'].' </h2>';

unset($_SESSION['status']);

}

</div>

</div>

</div>

<button type="submit" name="login_btn" class="btn btn-primary btn-user btn-block"> Login </button>

<hr>

</form>

</div>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$email_login = $_POST['emaill'];

$password_login = $_POST['passwordd'];

$query = "SELECT * FROM register WHERE email='$email_login' AND password='$password_login' LIMIT 1";

$query_run = mysqli_query($connection, $query);

if(mysqli_fetch_array($query_run))

{

$_SESSION['username'] = $email_login;

header('Location: index.php');

}

else

{

$_SESSION['status'] = "Email / Password is Invalid";

header('Location: login.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

if(!$_SESSION['username'])

{

header('Location: login.php');

}

Part 8-[A]-Admin Panel(Login-A): Login System with Session and Security in php

Part 8 (A & B): Login System with Session and Security.

As per the video, we have already downloaded the files and linked the CSS and JS.

Do not forget to Copy Step 4: if you are following from previous parts. because in this security.php we are checking loggedIN or not.

Step 1: Create a login.php page and paste the below:

<?php

session_start();

<h1 class="h4 text-gray-900 mb-4">Login Here!</h1>

<?php

if(isset($_SESSION['status']) && $_SESSION['status'] !='')

{

echo '<h2 class="bg-danger text-white"> '.$_SESSION['status'].' </h2>';

unset($_SESSION['status']);

}

</div>

</div>

</div>

<button type="submit" name="login_btn" class="btn btn-primary btn-user btn-block"> Login </button>

<hr>

</form>

</div>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$email_login = $_POST['emaill'];

$password_login = $_POST['passwordd'];

$query = "SELECT * FROM register WHERE email='$email_login' AND password='$password_login' LIMIT 1";

$query_run = mysqli_query($connection, $query);

if(mysqli_fetch_array($query_run))

{

$_SESSION['username'] = $email_login;

header('Location: index.php');

}

else

{

$_SESSION['status'] = "Email / Password is Invalid";

header('Location: login.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

if(!$_SESSION['username'])

{

header('Location: login.php');

}

Part 7-Admin Panel(Registration): Total Number of Data (Row Count) in Database in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a index.php page and paste the below:

<?php

include('security.php');

<div class="text-xs font-weight-bold text-primary text-uppercase mb-1">Total Registered Admin</div>

<?php

$query = "SELECT id FROM register ORDER BY id";

$query_run = mysqli_query($connection, $query);

$row = mysqli_num_rows($query_run);

echo '<h4> Total Admin: '.$row.'</h4>';

</div>

</div>

Step 2: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 3: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Part 6-Admin Panel(Registration): Delete Data from Database in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: as you have created a register.php page and inside the table we have delete option, table structure given below:

<?php

include('security.php');

<?php

$query = "SELECT * FROM register";

$query_run = mysqli_query($connection, $query);

<thead>

<tr>

<th> Username </th>

<th>Email </th>

<th>Password</th>

<th>UserType</th>

<th>DELETE</th>

</tr>

</thead>

<tbody>

<?php

if(mysqli_num_rows($query_run) > 0)

{

while($row = mysqli_fetch_assoc($query_run))

{

<tr>

<td>

</form>

</td>

<td>

<button type="submit" name="delete_btn" class="btn btn-danger"> DELETE</button>

</form>

</td>

</tr>

<?php

}

else {

echo "No Record Found";

}

</tbody>

</table>

</div>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$id = $_POST['delete_id'];

$query = "DELETE FROM register WHERE id='$id' ";

$query_run = mysqli_query($connection, $query);

if($query_run)

{

$_SESSION['status'] = "Your Data is Deleted";

$_SESSION['status_code'] = "success";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Your Data is NOT DELETED";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Part 5-Admin Panel(Registration): Edit and Update Data into Database in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code.

<?php

include('security.php');

<h6 class="m-0 font-weight-bold text-primary"> EDIT Admin Profile </h6>

</div>

<?php

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

{

$id = $_POST['edit_id'];

$query = "SELECT * FROM register WHERE id='$id' ";

$query_run = mysqli_query($connection, $query);

foreach($query_run as $row)

{

<label> Username </label>

<input type="text" name="edit_username" value="<?php echo $row['username'] ?>" class="form-control" placeholder="Enter Username">

</div>

<label>Email</label>

<input type="email" name="edit_email" value="<?php echo $row['email'] ?>" class="form-control" placeholder="Enter Email">

</div>

<label>Password</label>

<input type="password" name="edit_password" value="<?php echo $row['password'] ?>" class="form-control" placeholder="Enter Password">

</div>

<a href="register.php" class="btn btn-danger" > CANCEL </a>

<button type="submit" name="updatebtn" class="btn btn-primary"> Update </button>

</form>

<?php

}

</div>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$id = $_POST['edit_id'];

$username = $_POST['edit_username'];

$email = $_POST['edit_email'];

$password = $_POST['edit_password'];

$query = "UPDATE register SET username='$username', email='$email', password='$password' WHERE id='$id' ";

$query_run = mysqli_query($connection, $query);

if($query_run)

{

$_SESSION['status'] = "Your Data is Updated";

$_SESSION['status_code'] = "success";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Your Data is NOT Updated";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Part 4-Admin Panel-Registration-Retrieve/Edit data from Database into into Textbox in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code.

<?php

include('security.php');

<h6 class="m-0 font-weight-bold text-primary"> EDIT Admin Profile </h6>

</div>

<?php

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

{

$id = $_POST['edit_id'];

$query = "SELECT * FROM register WHERE id='$id' ";

$query_run = mysqli_query($connection, $query);

foreach($query_run as $row)

{

<label> Username </label>

<input type="text" name="edit_username" value="<?php echo $row['username'] ?>" class="form-control" placeholder="Enter Username">

</div>

<label>Email</label>

<input type="email" name="edit_email" value="<?php echo $row['email'] ?>" class="form-control" placeholder="Enter Email">

</div>

<label>Password</label>

<input type="password" name="edit_password" value="<?php echo $row['password'] ?>" class="form-control" placeholder="Enter Password">

</div>

<a href="register.php" class="btn btn-danger" > CANCEL </a>

<button type="submit" name="updatebtn" class="btn btn-primary"> Update </button>

</form>

<?php

}

</div>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$id = $_POST['edit_id'];

$username = $_POST['edit_username'];

$email = $_POST['edit_email'];

$password = $_POST['edit_password'];

$query = "UPDATE register SET username='$username', email='$email', password='$password' WHERE id='$id' ";

$query_run = mysqli_query($connection, $query);

if($query_run)

{

$_SESSION['status'] = "Your Data is Updated";

$_SESSION['status_code'] = "success";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Your Data is NOT Updated";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Part 1-Admin Panel: How to Setup (Arrange Files) and make a Admin Panel

Code for : Structure and Set-Up of Admin Panel in PHP

Downlooad the File from given drive: https://drive.google.com/file/d/1Xz-ei5uWr-ZgBzBdHBUt0-0R3z3WsOW0/view?usp=sharing

Here.. in this video, i am doing how to make a admin panel for a simple Website. so, i have downloaded a admin template from free Bootstrap admin template. and i have set up all the things, like, navbar.php, header.php, footer.php, etc..

Saturday, September 12, 2020

How to install Microsoft Visual Studio 2012 in Windows XP, 7, 8, 10 - Source File Provided.

How to install Microsoft Visual Studio 2012.

Step 1: Download the Source File from here :
https://www.filehorse.com/download-visual-studio-express/18144/

Step 2: After downloading the Source File of Visual Studio 2012, Open the Folder and Double Click on the dot exe (.exe) File.

Step 3: Your Installation process will start.

To watch a tutorial on how to install and Setup Visual Studio 2012, Check the above Video.

Or Click below Link:

https://www.youtube.com/watch?v=mX-D-S7rkgo

Tuesday, September 8, 2020

Part 3-Admin Panel(Registration): How to Fetch Data from Database in php

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code

<?php

include('security.php');

<h6 class="m-0 font-weight-bold text-primary">Admin Profile</h6>

</div>

<?php

$query = "SELECT * FROM register";

$query_run = mysqli_query($connection, $query);

<thead>

<tr>

<th> Username </th>

<th>Email </th>

<th>Password</th>

<th>UserType</th>

<th>DELETE</th>

</tr>

</thead>

<tbody>

<?php

if(mysqli_num_rows($query_run) > 0)

{

while($row = mysqli_fetch_assoc($query_run))

{

<tr>

<td>

</form>

</td>

<td>

<button type="submit" name="delete_btn" class="btn btn-danger"> DELETE</button>

</form>

</td>

</tr>

<?php

}

else {

echo "No Record Found";

}

</tbody>

</table>

</div>

Step 2: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 3: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Part 2-Admin Panel(Registration): How to make a Registration form in php with Session Msg

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code

<?php

include('security.php');

<h5 class="modal-title" id="exampleModalLabel">Add Admin Data</h5>

</button>

</div>

<label> Username </label>

</div>

<label>Email</label>

</div>

<label>Password</label>

</div>

<label>Confirm Password</label>

</div>

<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>

</div>

</form>

</div>

Add Admin Profile

</button>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$username = $_POST['username'];

$email = $_POST['email'];

$password = $_POST['password'];

$cpassword = $_POST['confirmpassword'];

$email_query = "SELECT * FROM register WHERE email='$email' ";

$email_query_run = mysqli_query($connection, $email_query);

if(mysqli_num_rows($email_query_run) > 0)

{

$_SESSION['status'] = "Email Already Taken. Please Try Another one.";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

else

{

if($password === $cpassword)

{

$query = "INSERT INTO register (username,email,password) VALUES ('$username','$email','$password')";

$query_run = mysqli_query($connection, $query);

if($query_run)

{

// echo "Saved";

$_SESSION['status'] = "Admin Profile Added";

$_SESSION['status_code'] = "success";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Admin Profile Not Added";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Password and Confirm Password Does Not Match";

$_SESSION['status_code'] = "warning";

header('Location: register.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Saturday, March 30, 2019

Part 2-Admin Panel(Registration): How to make a Registration form in php with Session Msg

Source Code:

https://fundaofwebit.blogspot.com/2020/09/part-2-admin-panelregistration-how-to.html

As per the video, we have already downloaded the files and linked the CSS and JS.

Step 1: Create a page register.php and paste the below code

<?php

include('security.php');

<h5 class="modal-title" id="exampleModalLabel">Add Admin Data</h5>

</button>

</div>

<label> Username </label>

</div>

<label>Email</label>

</div>

<label>Password</label>

</div>

<label>Confirm Password</label>

</div>

<button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>

</div>

</form>

</div>

Add Admin Profile

</button>

Step 2: Create a page with the name code.php and paste the below code.

<?php

include('security.php');

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

{

$username = $_POST['username'];

$email = $_POST['email'];

$password = $_POST['password'];

$cpassword = $_POST['confirmpassword'];

$email_query = "SELECT * FROM register WHERE email='$email' ";

$email_query_run = mysqli_query($connection, $email_query);

if(mysqli_num_rows($email_query_run) > 0)

{

$_SESSION['status'] = "Email Already Taken. Please Try Another one.";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

else

{

if($password === $cpassword)

{

$query = "INSERT INTO register (username,email,password) VALUES ('$username','$email','$password')";

$query_run = mysqli_query($connection, $query);

if($query_run)

{

// echo "Saved";

$_SESSION['status'] = "Admin Profile Added";

$_SESSION['status_code'] = "success";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Admin Profile Not Added";

$_SESSION['status_code'] = "error";

header('Location: register.php');

}

else

{

$_SESSION['status'] = "Password and Confirm Password Does Not Match";

$_SESSION['status_code'] = "warning";

header('Location: register.php');

}

Step 3: Create a folder called database and then create a file named dbconfig.php and paste the below code.

<?php

$server_name = "localhost";

$db_username = "root";

$db_password = "";

$db_name = "adminpanel";

$connection = mysqli_connect($server_name,$db_username,$db_password,$db_name);

if(!$connection)

{

die("Connection failed: " . mysqli_connect_error());

echo '

<h1 class="card-title bg-danger text-white"> Database Connection Failed </h1>

<h2 class="card-title"> Database Failure</h2>

<p class="card-text"> Please Check Your Database Connection.</p>

</div>

}

Step 4: Create a page security.php and paste the below code.

<?php

session_start();

include('database/dbconfig.php');

if($connection)

{

// echo "Database Connected";

}

else

{

header("Location: database/dbconfig.php");

}

Navbar

My Blog List

Wednesday, September 16, 2020

Part 8-[B]-Admin Panel(Login-B): Login System with Session and Security in php

Part 8 (A & B): Login System with Session and Security.

Part 8-[A]-Admin Panel(Login-A): Login System with Session and Security in php

Part 8 (A & B): Login System with Session and Security.

Part 7-Admin Panel(Registration): Total Number of Data (Row Count) in Database in php

Part 6-Admin Panel(Registration): Delete Data from Database in php

Part 5-Admin Panel(Registration): Edit and Update Data into Database in php

Part 4-Admin Panel-Registration-Retrieve/Edit data from Database into into Textbox in php

Part 1-Admin Panel: How to Setup (Arrange Files) and make a Admin Panel

Saturday, September 12, 2020

How to install Microsoft Visual Studio 2012 in Windows XP, 7, 8, 10 - Source File Provided.

Tuesday, September 8, 2020

Part 3-Admin Panel(Registration): How to Fetch Data from Database in php

Part 2-Admin Panel(Registration): How to make a Registration form in php with Session Msg

Saturday, March 30, 2019

Part 2-Admin Panel(Registration): How to make a Registration form in php with Session Msg

Saturday, February 23, 2019

How to Install WordPress and Setup Database