Create a foreign key in phpmyadmin and relate to primary key

Create a foreign key in phpmyadmin and relate to primary key



Primary keys and foreign keys and how they relate together is the crux of how relational databases work. in this video I add a foreign key to the students table named course_fk. I index field and then through the relation view I relate this field to the primary key field course_id in the courses table.
Through the video I highlight how relationships work and how the constraints that are part of relationships in a relational database force the integrity of data by ensuring values in the foreign key must relate to valid IDs in the primary key it is related to.

source

How to Make a WordPress Website 2016 – EASY!

How to Make a WordPress Website 2016 – EASY!



Click HERE to Open Resource Page:

Learn how to make a beautiful, custom WordPress website EASY! This is a STEP by STEP walkthrough, with no steps skipped.

I’ll walk you through getting your own domain URL, to purchasing and setting up web hosting, to installing WordPress, and finally, how to use the WordPress platform to customize your website to your liking.

*If you have ANY questions or need help, leave a comment below and I’ll do my best to help you out*

ALSO, if you enjoyed this tutorial, please drop a THUMBS UP and a COMMENT letting me know!

Useful Links and Videos You May Like:
►Web Hosting Coupons:
►Best WordPress Web Hosting:
►How to Start a Blog in 3 Minutes:
►How to Create a Business Website:
►Difference between WordPress.COM vs WordPress.ORG?:

source

Free WordPress Website Hosting on GitHub

Free WordPress Website Hosting on GitHub



Host a WordPress Static Page on GitHub on your own without any bandwidth restrictions or storage limit.

Hywel Article –

Wamp Installation Guide –

My Old WordPress Website on GitHub –

My Tech –

Shop amazing handpicked and trusted tech products from Flipkart and Amazon at our Tech Store –

Music Credits –

Last Summer by Ikson:
Music promoted by Audio Library

Follow Us On –

FaceBook –
Twitter –
Telegram –
Google+ Community –

OUR WEBSITE –

SUBSCRIBE FOR MORE :))

source

Create files and folders in cPanel File Manager

Create files and folders in cPanel File Manager



1) Click on New File.
Leave the public_html path as it is because we always need to upload files in this folder. You will learn how to upload files in subfolders a little later.
2) Type the file name here.
3) Then click Create New File. Your file has been created successfully.
4) Let’s create a new folder now. Click on New Folder.
5) Type the folder name here.
6) Click Create New Folder to continue.
7) Please type the path where you want to create this new folder.In this case, we will keep it as it is.

Your folder was created successfully. You can also see it in the left margin.
8) Now let’s create a file in a subfolder. Click on New File again.
9) Type the filename.
10) Now keep the existing path as it is, in this case, it’s “public_html”. After that, add “/” and then type the folder name in which you want to create this new file.
11) Now again click on Create New file.
12) You will not be redirected to the folder after you create the file, so we need to go there to check. Double click the “test” folder to check it.
Congratulations, the file has been created successfully in the “test” subfolder.

source

How to use Softaculous to install WordPress

How to use Softaculous to install WordPress



Using Softaculous to install WordPress is advantageous because it is quick, much easier, and gives you a few additional options that you wouldn’t have if you installed WordPress manually. These options include the ability to clone the site, make backups and update from a single location. If you are making multiple installations of WordPress, Softaculous helps you to track the different installations that you create.

How to install WordPress using Softaculous

First, log in to the cPanel for your Account

Scroll down to the icon labeled Softaculous. If you don’t see an option, you may see a section in the cPanel labeled Softaculous Apps Installer. You can click on the bar labeled note at the top of the window under the section labeled Softaculous Apps Installer.

This will bring you to a list of previous installations. Here you can click on the left hand menu to search for WordPress Installation option. You can also click on the Search field and then type in “WordPress”. Click on “WordPress” to open the WordPress installation page.

When you get to the WordPress install pages, click on the INSTALL tab

Here you will need to fill in fields:

Software setup

Choose Protocol – select HTTP or HTTPS

Choose Domain – select the domain that you will use for your WordPress installation. This domain must be part of the account or added an add-on or subdomain in order to be selected

In Directory – this is the folder where your folders will be placed; the folder should not exist. If you are wanting to place the files in the default primary domain location, then leave this section blank

Site Settings

Site Name – name of the blog
Site Description – Description of the blog

Enable Multisite (WPMU) – check to enable multisite

Admin Account

Admin Username – type in the name of the admin username

Admin Password – type in the password for your administrator user

Admin Email – type in an email address that you can access for your administrator user
Choose Language

Select Language – English is set as the default

Select Plugins

Limit Login Attempts – click on the box to enable the Limit Login Attempts plugin; as the name implies, activating this plugin will limit the number of login attempts for your WordPress installation

Advanced Options – advanced options allow you set

Database Name – this will be the name of the database
Disable Update Notifications
Auto Upgrade
Auto Upgrade WordPress Plugins
Auto Upgrade WordPress Themes
Automated backups
Backup rotation

When the fields are complete, click on the SUBMIT button to complete the installation.

InMotion Hosting was founded in 2001 and provides personal and business web hosting for everyone! For more information about InMotion Hosting and the services we provide see here:

source