Monthly Archives: May 2016

Secure Login page using PHP and MYSQL based on user role

Hi Guys,
Here I explain how to develope secure login page based on user role like different types of user using PHP. First you create the registration form. After register your name into database then we can develope login page with PHP and MYSQL.

You have created your registration.php page successfully then its time to move ahead and learn how to create login page in PHP. For performing this operation using fordemo database and finforex_users table in login page.

This login script will take username and password entered by user through login.php page. The encryption password (MD5) is used here. Then it will match that username and password combination in database and when it finds then it check the role of the corresponding user and that combination exists in table it will allow user to login to corresponding page else it will show appropriate error message.

SQL query for finforex_users table:

CREATE TABLE IF NOT EXISTS `finforex_users` ( `userid` int(15) NOT NULL AUTO_INCREMENT, `username` varchar(50) NOT NULL, `password` varchar(60) NOT NULL, `role` varchar(20) NOT NULL, `emailid` varchar(25) NOT NULL, `phonenumber` varchar(15) NOT NULL, PRIMARY KEY (`userid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Database Connection: db.php

Code for login.php



 




Login



UserName  :


Password  :

From the above code, first check the entered username and password correct or wrong. If the username and password is correct then set user role and userid as session further operations.
If the user role is administrator then redirect the page to admin_page.php or if the user role is user then redirect the page to user_page.php.

Code for admin_page.php



    
		 

    
    
		
 


Set Margins- Administrator 
Logout

Code for user_page.php



Welcome User 
Logout

If you have any query or any doubt then please feel free to ask.

Ajax Upload and Resize an Image with PHP

Hi Guys,
Today I am presenting the most important social networking feature called ajax upload and resize an image without refreshing the page using PHP and jquery.

This article contains three folders called js,includes and uploads with PHP files.

includes
— getExtension.php
— compressImage.php
js
— jquery.min.js
— jquery.form.js
uploads
index.php
ajaximageupload.php

We can upload the image through PHP page. And resize the uploaded image using Ajax in php page.

Javascript Code

index.php

Contains simple PHP and HTML code. Here $session_id=1 means user id session value.

ajaximage.php

Contains PHP code. This script helps you to upload images into uploads folder. Image file name rename into timestamp+session_id.extention

";
}

//Original Image
if(move_uploaded_file($uploadedfile, $path.$actual_image_name))
{
//Insert upload image files names into user_uploads table
mysqli_query($db,"UPDATE users SET profile_image='$actual_image_name' WHERE uid='$session_id';");
echo "";
}
else
echo "failed";
}
else
echo "Image file size max 1 MB"; 
}
else
echo "Invalid file format.."; 
}
else
echo "Please select image..!";
exit;
}
?>

compressImage.php

Re-sizing image into different pixel dimensions.

getExtension.php

This extracts file extension.

function getExtension($str)
{
$i = strrpos($str,".");
if (!$i)
{
return "";
}
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Facebook Style Background Image Upload and Position Adjustment

Hi all,
I share somany article related to web development. Many people use my article for their professional growth. I got many tutorial requests from my readers related to web development using php, wordpress, mysql, ajax, jquery, javascript etc. From their request, one of my readers asked to me “ how to design facebook style background image upload and position adjustment using web development technology.” After along study, I using Ajax and jQuerymethod for developing this application. I have been published many tutorials related ajax image upload. This one is something different and very interesting.

Table of Content

MySQL table
HTML or PHP
JavaScript
Ajax
CSS

MySQL table

The MySQL table used for storing user details to database. Here I use user table for this operation. It contains all the registered user details.

	CREATE TABLE users(
		user_id INT auto_increment primary key, 
		username VARCHAR(30), 
		email VARCHAR(100), 
		name VARCHAR(100), 
		passcode VARCHAR(100), 
		profile_background VARCHAR(300),
		profile_background_position VARCHAR(10)
	);

User database store like this.

	INSERT INTO users('username','email','name','passcode','profile_background','profile_background_position')
	VALUES('pritty','prittytimes@gmail.com','Pritty Times','e10adc3949ba59abbe56e057f20f883e','14643223151.jpg',' -413px');

Database connection in php code

db.php

HTML Code















Pritty  Times

JavaScript Code

Contains JavaScript code and drag option works with Jquery UI plugin. $(‘body’).on(‘change’,’#bgphotoimg’, function()- bgphotoimg is the ID name of INPUT FILE tag and $(‘#bgimageform’).ajaxForm() – imageform is the ID name of FORM. While changing INPUT it calls FORM submit without refreshing page using ajaxForm() method.

CSS Code

*{margin:0px;padding:0px}
body{font-family: Arial, Helvetica, sans-serif;background-color: #e9eaed;color: #333333;}
#container{margin:0 auto;width:900px}
#timelineContainer{width:100%;position:relative}
#timelineBackground {
height: 315px;
position: relative;
border-left: 1px solid #333333;
border-right: 1px solid #333333;
margin-top: -20px;
overflow: hidden;
background-color:#ffffff;
}
#timelineProfilePic {
width: 170px;
height: 170px;
border: 1px solid #666666;
background-color: #ffffff;
position: absolute;
margin-top: -145px;
margin-left: 20px;
z-index: 1000;
overflow: hidden;
}
#timelineTitle {
color: #ffffff;
font-size: 24px;
margin-top: -45px;
position: absolute;
margin-left: 206px;
font-weight: bold;
text-rendering: optimizelegibility;
text-shadow: 0 0 3px rgba(0,0,0,.8);
z-index: 999;
text-transform: capitalize;
}
#timelineShade {
min-height: 95px;
position: absolute;
margin-top: -95px;
width: 100%;
background:url(images/timeline_shade.png);
}
.timelineUploadBG {
position: absolute;
margin-top: 50px;
margin-left: 813px;
height: 32px;
width: 32px;
}
#timelineNav {
border: 1px solid #d6d7da;
background-color: #ffffff;
min-height: 43px;
margin-bottom: 10px;
position: relative;
}

Styling an input type="file" browse button

Default input type file works with browse button, replaced choose/browse button with camera icon.

CSS

Here actual input type="file" in hidden more, applied background image for DIV.

.uploadFile {
background: url('images_bg/whitecam.png') no-repeat;
height: 32px;
width: 32px;
overflow: hidden;
cursor: pointer;
}
.uploadFile input {
filter: alpha(opacity=0);
opacity: 0;
margin-left: -110px;
}
.custom-file-input {
height: 25px;
cursor: pointer;
}

PHP Code

Simple PHP class contains three functions called userDetails, userBackgroundUpdate and userBackgourndPositionUpdate.

userUpdates.php

db = $db;
}
public function userDetails($user_id)
{
$query=mysqli_query($this->db,"SELECT username,email,name,profile_background,profile_background_position  FROM users WHERE user_id='$user_id' ") or die(mysqli_error($this->db));
$data=mysqli_fetch_array($query,MYSQLI_ASSOC);
return $data;
}
public function userBackgroundUpdate($user_id,$actual_image_name)
{
$query=mysqli_query($this->db,"UPDATE users SET profile_background='$actual_image_name' WHERE user_id='$user_id'") or die(mysqli_error($this->db));
return $query;
}
public function userBackgroundPositionUpdate($user_id,$position)
{ 
$position=mysqli_real_escape_string($this->db,$position);
$query=mysqli_query($this->db,"UPDATE users SET profile_background_position='$position' WHERE user_id='$user_id'")or die(mysqli_error($this->db));
return $query;
}
}
?>

image_upload_ajax.php

Save Cover

'; if(move_uploaded_file($tmp, $path.$actual_image_name)) { $data=$userUpdates->userBackgroundUpdate($session_uid,$actual_image_name); if($data) echo $bgSave.'

'; } else echo "Fail upload folder with read access."; } else echo "Image file size max 1 MB"; } else echo "Invalid file format."; } else echo "Please select image..!"; exit; } ?>

image_saveBG_ajax.php

userBackgroundPositionUpdate($session_uid,$position);
if($data)
echo $position;
}
?>

index.php

userDetails($session_uid);
$username=$userData['username'];
$name=$userData['name'];
$profile_background=$userData['profile_background'];
$profile_background_position=$userData['profile_background_position'];
?>













Pritty Times

Happy Coding

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

How to Manually Reset Your WordPress Admin Password

Hi all,
If you are unable to reset your WordPress admin password using the “Forgot My Password” link, follow these steps in order to manually reset your password. More Details

I’m going to divide WordPress password recovery into two parts:

recovering it using phpMyAdmin (if you’re on localhost using WAMP/XAMPP/MAMP)
recovering the password using MySQL (if phpMyAdmin isn’t installed on your server. Part (b) will be present in the next post in this series.

Step 1: Login to your cPanel account and Select PHPMyAdmin

Click on the PHPMyAdmin Icon in your cPanel.

Step 2: Select the Database

Select Databases at the top of the screen and then click on your WordPress database.

Step 3: Select the wp_users table.

Click on the wp_users table.

Step 4: Edit the admin user.

Click edit next to your WordPress admin username.

Step 5: Set the new password

In the user_pass column, select MD5 and type in the new admin password. Finally click on Go.

Step 6: You’re Done!

Your wordpress admin password has been reset.

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Rename Uncategorized Category in WordPress

When you install a fresh copy of WordPress in your local computer or hosting space, it comes with 1 default category, 1 default comment, and 1 default post. This category is named as un-categorized. The name uncategorized can sometimes give an amateurish or unprofessional vibe to your WordPress blog.

WordPress automatically selects Uncategorized category for that article before it is published. Consider running a professional site or blog and have an uncategorized category occur due to a small human error.
In our opinion, this causes a slight taint in reputation of the editor of the blog. Some people take it as the editor was careless, so the error will occur at running our sites.

This also occurs if an editor saved the post without choosing a category. WordPress will then automatically select uncategorized category and later if the editor did not unselect this category, the post is published in two categories resulting your uncategorized category to show up.

How to Rename the Category

Here are the steps you will need to take to rename the uncategorized category in WordPress:

To rename the wordpress category first login the wordpress dashboard using username and password.
To rename the uncategorized category, login WordPress Admin Panel. Click on the tab Posts >Categories. Here you can see the the option to add a new category to the left and a list of the categories you have already set up on the right.

In the list of categories you have created, hover over the “Uncategorized” category

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

Nested or Sub-queries Practice Questions with Answers

Hi Guys,
Today we discuss mysql sub-queries questions with answers. Sql queries are useful and used in web application development connected with database tables. We can fetch the data from database, insert the data to database, update the existing data in a database table and also delete the data or table in a database based on conditions or other functionality.

In below there are five tables are available with datas. Based on these five table we perform some sql queries like sub-queries or nested queryy operations.
There are five table are available. They are:

employee
empdept
empsalary
empproject
project

Table 1:employee

EmpId	EmpName	Department	ContactNo	EmailId	EmpHeadid
101	Isha	E-101	1234567890	abc@gmail.com	105
102	Priya	E-104	1234567890	abc@gmail.com	103
103	Neha	E-101	1234567890	abc@gmail.com	101
104	Rahul	E-102	1234567890	abc@gmail.com	105
105	abhishek	E-101	1234567890	abc@gmail.com	102

table 2: empdept

DeptId	DeptName	DeptHead
E-101	HR	105
E-102	Development	101
E-103	House Keeping
E-104	Sales	104
E-105	Purchase	104

Table 3: empproject

EmpId	ProjectId
101	p-1
102	p-2
103	p-1
104	p-4
105	p-4

Table 4: empsalary

EmpId	Salary	Ispermanent
101	2000	Yes
102	10000	Yes
103	5000	No
104	1900	Yes
105	2300	Yes

Table 5: project

ProjectId	Duration
p-1	23
p-2	15
p-3	45
p-4	2
p-5	30

Question 1: Select departmentid and department name of the company which is assigned to the employee whose employee id is greater than 103

Answer:

Select DeptId,DeptName from empdept INNER JOIN employee ON empdept.DeptId=employee.Department WHERE employee.EmpId>103

Output as follows:

DeptId	DeptName
E-101	HR
E-102	Development

Question 2: Select salary of the employee who is currently working on the project p-2

Answer:

Select Salary from empsalary INNER JOIN empproject ON empsalary.EmpId=empproject.EmpId WHERE empproject.ProjectId='p-2'

Output as follows:

Salary
10000

Question 3: Select name of the employee who is department head is HR

Answer:

Select Empname from employee INNER JOIN empdept ON employee.Department=empdept.DeptId WHERE empdept.Deptname='HR'

Output as follows:

Empname
Isha
Neha
abhishek

Question 4: Select name of the employee who is department head is Sales

Answer:

Select Empname from employee INNER JOIN empdept ON employee.Department=empdept.DeptId WHERE empdept.Deptname='Sales';

Output as follows:

Empname
Isha
Neha
abhishek
Priya

Question 5: Select name of the employee who is department head is Sales or department head is HR

Answer:

Select Empname from employee INNER JOIN empdept ON employee.Department=empdept.DeptId WHERE empdept.Deptname='Sales' OR empdept.DeptName='HR';

Output as follows:

Empname
Priya

Question 6: Select all the details from employee

Answer:

select * from employee;

Output as follows:

EmpId	EmpName	Department	ContactNo	EmailId	EmpHeadid
101	Isha	E-101	1234567890	abc@gmail.com	105
102	Priya	E-104	1234567890	abc@gmail.com	103
103	Neha	E-101	1234567890	abc@gmail.com	101
104	Rahul	E-102	1234567890	abc@gmail.com	105
105	abhishek	E-101	1234567890	abc@gmail.com	102

Question 7: Select the project id which duration is greater than 30 months.

Answer:

select ProjectId from project where Duration >30

Output as follows:

ProjectId
p-3

Question 8: Duration of the project which didn’t assigned to any candidates

Answer:

select Duration from project where ProjectId not in (select ProjectId from empproject)

Output as follows:

Duration
30
45

Question 9: Select the name of the candidate who is working in HR department and they are working as permanent.

Answer:

select EmpName from employee where Department in (select deptId from empdept where Deptname='HR') and EmpId in (select EmpId from empsalary where Ispermanent='Yes');

Output as follows:

EmpName
Isha	abhishek

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

How to use Loops in Javascript

Hi Guys,
If you want to run the same code over and over again, each time with a different value. Loops can execute a block of code a number of times.

There are mainly four types of loops in JavaScript.

for : loops through a block of code a number of times
while : loops through a block of code while a specified condition is true
do/while : also loops through a block of code while a specified condition is true

Loops are useful when we have to execute the same lines of code repeatedly. For a specific number of times or as long as a specific condition is true

for loop

Syntax

	for(statement1; statement2; statment3)
	{
		lines of code to be executed
	}

Detail Description

statement1: It is executed first even before executing the looping code. So, this statement is normally used to assign values to variables that will be used inside the loop.

statement2: It is the condition to execute the loop.
statement3:It is executed every time after the looping code is executed.

	
	

	 Javascript Loop!!!

while loop

The “while loop” is executed as long as the specified condition is true.

Syntax

	while(condition)
	{
		lines of code to be executed
	}

do…while loop

The do…while loop is very similar to while loop.

Syntax

	do
	{
		block of code to be executed
	}
	while (condition)

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

JavaScript Arrays

Hi all,
Today we discuss one useful topic related to Javascript Array. An array is an object. This is mainly used to store a collection of items. Arrays become really very useful, you need to store large amounts of data of the same type.

You can access the items in an array by referring to its indexnumber and the index of the first element of any array is zero.

Creating an Array

You can create an array in JavaScript as given below.

var employee = ["Jose", "Varghese", "Thomas"];

Here, you are initializing your array as and when it is created with values “Jose”, “Varghese” and “Thomas”. The index of “Jose”, “Varghese” and “Thomas” is 0, 1 and 2 respectively. If you want to add more elements to the students array, you can do it like this:

employee[3] = "Mary";
employee[]4] = "Lilly";

You can also create an array using Array constructor like this:

var employee = ["Jose", "Varghese", "Thomas"];

var employee = new Array();

employee[0] = "Jose";
 
employee[1] = "Varghese";
 
employee[2] = "Thomas";

Properties and Methods

The Array object has many methods and properties which help developers to handle arrays easily and efficiently.
You can get the value of a property by specifying arrayname.property and the output of a method by specifying arrayname.method().

length property: to know the number of elements in an array, you can use the length property.
prototype property: to add new properties and methods, you can use the prototype property.
reverse method : reverse the order of items in an array using reverse method.
sort method : sort the items in an array using sort method.

pop method : remove the last item of an array using pop method.
shift method : remove the first item of an array using shift method.


	

	 Javascript Arrays!!!

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

How to access database like MySQL using PHP

In this article shows PHP functions are available to connect to a MySQL database PHP Data Object (PDO) and odbc_connect function. PHP has a rich collection of built in functions for manipulating MySQL databases.

The mysqli_connect function is used to connect to a MySQL database server.

Code Details:

$database_handle: is the database connection resource variable.
mysqli_connect(…): is the function for connecting to the database

$database_server_name: is the name or IP address of the server hosting MySQL server.
$database_user_name: is a valid user name in MySQL server.
$database_password: is a valid password associated with a user name in MySQL server.

The mysql_select_db function is used to select a database. It has the following syntax.

mysql_select_db(…): is the database selection function that returns either true or false
$database_name: is the name of the database

$link_identifier: is optional, it is used to pass in the server connection link.

The mysql_query function is used to execute SQL queries. The function can be used to execute the following query types:

Insert
Select
Update
delete

mysql_query(…):is the function that executes the SQL queries.
$query :is the SQL query to be executed
$link_identifier: is optional, it can be used to pass in the server connection link

If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.