How to install Django python framework in windows 10

We know Django is the python framework ,so it only work with python installed system,before starting Django we should install python.So lets see how to install python in windows 10. Fortunately installing python is so easy

Step 1)

Install python in windows 10

First you need to get the python installer,as of now latest python version that support Django is Python 3.6.7. Go to https://www.python.org/downloads/ and Download Python 3.6.7 and install don’t forget to tick add python 3.6 tp PATH,it will assign PATH variable

python-Django-step1

Step 2)

Check python installed successfully

open CMD in windows

c:/users>python
will respond like below
Python 3.6.7 (v3.6.7:6ec5cf24b7, Oct 20 2018, 13:35:33) [MSC v.1900 64 bit (AMD64)] on win32
Type "help", "copyright", "credits" or "license" for more information.

python-Django-step2

Step 3)

install pip if not installed in your system

D:\my_project >

Step 4)

Create a project directory, you can create project directory anywhere in your system,here i created in my D drive with name my_project
then move current directory to project directory in CMD

D:\my_project >

Step 5)

Install virtual environment using pip
D:\my_project>pip install virtualenv Create a virtual environment with name env_mysite you can rename anything as per your reference D:\my_project>virtualenv env_mysite

Step 6)

Activate virtualenv
D:\my_project>env_mysite\scripts\activate

env_mysitePS D:\my_project>

Step 7)

Install django

env_mysitePS D:\my_project>pip install "django>=2.1,<2.2"

Step 8)

Open http://127.0.0.1:8000/ in any browsers

Congratulation you installed Python django framework

How to make a cookie secure and httponly in PHP ?

As we know Cookie is often used for identifying user data, when user opening a website, cookie stores information about the user in the browser, Each time the same system requests a page with in a same browser, it will send the cookie too.So when we are considering about the security it is a programmer duty to make it more secure when it exchanging between browser and server,nowadays it is easy to access other website cookie and get the flow of the website using that cookie information.So here am going explain you how to make a cookie secure and httponly in PHP .we have lot of method to accomplish this task,lets have a look on it.

Method 1

Make cookie secure using PHP.ini 

if you have the permission to access php.ini you can open and add below code at the end of php.ini to make your cookie secure and httponly

session.cookie_httponly=On
session.cookie_secure=On

Method 2

if you don't have the permission to access php.ini file,fortunately we have another method to accomplish this, which can be done by one of the most common function ini_set();


Make cookie secure using ini_set() function

add below ini_set() functions in the top of your home page

ini_set('session.cookie_httponly',1);
ini_set('session.use_only_cookies',1);
ini_set('session.cookie_secure', 1);

Method 3

if you don't have the permission to access php.ini file,fortunately we have another method to accomplish this,which can be done by one of the most common function header() in php


Make cookie secure using header() function

add below header() functions in the top of your home page

header("Set-Cookie: key=value; path=/; domain=www.tutorialshore.com; HttpOnly; Secure; SameSite=Strict");

See how we can check a cookie is secure and httponly, we can do with the help of chrome browser as we know almost every browser have the inspect element option, within inspect element tab we have the application section to check cookie see below image.
Click F12 function button go for application => cookies

make a cookie secure and httponly in PHP

Redirect any subdirectory to another subdirectory using htaccess in wordpress

In our blog sometimes for SEO purpose we need to rename the folder name from one directory to another directory suppose we need to rename my folder name style to trends.we need to redirect all url related to http://www.tutorialshore.com/style/***** to http://www.tutorialshore.com/trends/*****.This can be done by using htaccess redirection .here am going to do in wordpress

RewriteRule ^style/(.*)$ /trends/$1 [R=301,NC,L]
#Here all style folder redirect to trends

Full .htaccess files in wordpress


RewriteEngine On
RewriteRule ^style/(.*)$ /trends/$1 [R=301,NC,L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ index.php/$1 [L]  


how to create new database user in mysql python

Step1

Set Mysql variable path

set path=%PATH%;C:\xampp\mysql\bin;

Step 2
Using command prompt login to databse

mysql -u root -p

Password NULL
create a database python

Step 3
Create new username and password
jack username
jackpassword is the password

c:\python>mysql -u root -p
Enter password: *
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 18
Server version: 10.1.34-MariaDB mariadb.org binary distribution

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'jack'@'localhost' IDENTIFIED BY 'jackpassword';
Query OK, 0 rows affected (0.00 sec)

MariaDB [(none)]>

Step 4
create new database using Python mysql connection

import mysql.connector

mydb = mysql.connector.connect(
  host="localhost",
  user="jack",
  passwd="jackpassword"
)

mycursor = mydb.cursor()

mycursor.execute("CREATE DATABASE myschool")