mysql

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

Cool People Share:

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

Cool People Share:

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. PHP DATA ENCRYPTION INSERT RETRIEVE MYSQL DATABASE In an earlier PHP Data Encryption Read More

Cool People Share:

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

Cool People Share:

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

Cool People Share:

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

Cool People Share:

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. AJAX jQuery Functions Used ready() function to check the readiness of the DOM {Document Object Model} click() function to Read More

Cool People Share:

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

Cool People Share:

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

Cool People Share:

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

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more tips $5 Tip $5.00 USD $10 Tip Read More

Cool People Share:

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 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Tip more Read More

Cool People Share:

Select With Custom Order Limit Terminal MySql

Select With Custom Order Limit Terminal MySql

To select with a customer order and limit the results use this command. SELECT * FROM [table] WHERE [column] ORDER BY [column] ASC LIMIT [value]; You can order by ascending. ASC Or you can order by descending. DESC Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the Read More

Cool People Share:

Select A Range MySql Terminal

Select A Range MySql Terminal

To select a range use this code. Take out the brackets and replace the values. SELECT * FROM [table] WHERE [column] BETWEEN [value1] and [value2]; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the Read More

Cool People Share:

Select Records Starting & Ending With Value MySql Terminal

Select Records Starting & Ending With Value MySql Terminal

To find records that start and end with a certain value use this command. SELECT * FROM [table] WHERE [column] LIKE ‘[val_ue]’; Complete Cheat Sheet https://gist.github.com/hofmannsven/9164408 Please like, share and subscribe. Advanced Programming Made EasyI hope you enjoyed the article. If I was able to help you please consider a tip for the content. One Time Read More

Cool People Share: