mysql

How To Move A Large WordPress Website To A New Server

How To Move A Large WordPress Website To A New Server

In this how to tutorial I will show you how to move a large WordPress website from one server to another. In this tutorial I assume that you already know how to SSH into your server. You must already know these following things, if you do not, click the link and learn them and then Read More

How To Search PHP Encrypted Database

How To Search PHP Encrypted Database

This post will show you how to search a PHP encrypted database. This is a follow up on the PHP encryption and decryption tutorials. Many have made the argument that once all the data is encrypted and stored that there is no way to query the database. However, you can query the database and I Read More

BEST PHP ENCRYPTION DECRYPTION MYSQL TUTORIAL | PROACTIVE METHODS

BEST PHP ENCRYPTION DECRYPTION MYSQL TUTORIAL

Encryption, Decryption and MySQL in PHP is very important these days with hacker after hacker out there always ready to find new crafty ways to steal your customer’s information. Do not be a victim here because you do not have to be! Be proactive in your efforts to make your customers’ websites be a fortress Read More

CREATE EXPIRE DOWNLOAD LINK IN PHP MYSQL | BEST TUTORIAL

CREATE EXPIRE DOWNLOAD LINK IN PHP MYSQ

Ever wonder how to create a download link in PHP and then make it expire? Would you like to know how to expire a download link after a set number of times they download it? Do you want to know how to protect your files from people trying to steal your downloads? We are going Read More

PHP DATA ENCRYPTION INSERT RETRIEVE MYSQL DATABASE

PHP DATA ENCRYPTION INSERT RETRIEVE MYSQL DATABASE

PHP Data Encryption is important to safety and privacy. In this lesson, I am going to show you how to insert and retrieve encrypted data in PHP using a MySQL database. Using these methods will make your websites and applications more secure. After completing this tutorial then you will want to go over How To Read More

Data Encryption Php MySql Methods Implementation Open SSL Encrypt

Data Encryption Php MySql Methods Implementation Open SSL Encrypt

Data Encryption with Php and MySql is very important. Some programmers wonder about the methods and implementation of different processes for data encryption. In this article we are going to discuss a sure way to encrypt your data with Open SSL before storing it in MySql. UPDATE: I posted a newer version of this tutorial Read More

GDPR Compliance What You NEED To Do

GDPR Compliance What You Need To Do

This article will discuss GDPR Compliance, and What You NEED To Do before the deadline on May 25th. This will include the need to edit your Privacy Policies, Terms of Service and any other Data Policies that you may have to fully inform website users of their rights along with acquiring their consent to use Read More

Lost Password Script AJAX jQuery Bootstrap PHP and MySql

Lost Password Script AJAX jQuery Bootstrap PHP and MySql

This is a lost password script tutorial. I write it in AJAX, JQuery, Bootstrap, PHP and MySQL. Frequently people lose their passwords. Password reset scripts are almost mandatory with people expecting software to do everything for them. Writing scripts that lets people reset their passwords do pose some risks. Are they using a secure email Read More

Contact Form with AJAX jQuery Bootstrap PHP and MySql

Contact Form with AJAX jQuery Bootstrap PHP and MySql

In this tutorial we create a contact form that enters contact information into a database. It will then send an email to you from your website. We do this with AJAX, jQuery, Bootstrap, PHP and MySql. https://youtu.be/y4M_u–t5YA AJAX jQuery Functions Used ready() function to check the readiness of the DOM {Document Object Model} click() function Read More

Login Script with AJAX jQuery PHP and MySql

Login Script with AJAX jQuery PHP and MySql

Let’s create a login script with AJAX JQuery, PHP and MySQL in this tutorial. We will create a form to login to the system and use AJAX with JQuery for the process. Next we will use PHP to process the form and return data to the webpage without reloading. Then we will set session variables Read More

SANITIZE STRINGS BEFORE INSERTING INTO DATABASE PHP MYSQL AJAX JQUERY

SANITIZE STRINGS BEFORE INSERTING INTO DATABASE PHP MYSQL AJAX JQUERY

You need to sanitize your string before you insert them into your databases. We show you how to do that in this lesson with “FILTER_SANITIZE_STRING”, “FILTER_SANITIZE_EMAIL” and “FILTER_FLAG_STRIP_HIGH”. We use jQuery and AJAX to pass the variables to the processor. This lesson is a continuation of the last lesson Create Secure Password Sign Up Script With Read More

Create Secure Password Sign Up Script With PHP jQuery and AJAX

Create Secure Password Sign Up Script With PHP jQuery and AJAX

Create a secure password sign up script with PHP, jQuery and AJAX with this easy to follow tutorial. Preliminary steps for this tutorial is to go over the last post Create A Database and Table At The Same Time With PHP. If you are already familiar with creating database tables this is the structure for the database Read More

How To Make A Free Website Backup PHP & MySql

How To Make A Free Website Backup PHP & MySql

This post covers how to make a free website backup. Once finished you will be able to download a complete website backup zip file. This will also include your database. This task is very easy but I am going to explain the process in detail. Update: Backed by popular demand I was asked to do Read More

Custom Column Output Names Terminal MySql

Custom Column Output Names Terminal MySql

Custom column output names in terminal. SELECT [column] AS [custom-column] FROM [table]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408

Update Records In MySql Terminal

Update Records In MySql Terminal

To update a record you can use this command. UPDATE [table] SET [column] = ‘[updated-value]’ WHERE [column] = [value]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408