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
After you have installed XAMPP then you will want to test that everything is working. In this tutorial we are going to make sure that we have everything working properly before we dive into the programming. You will also want to come back here in future tutorials to repeat these steps. TURN EVERYTHING ON IN Read More
We have completed the Absolute Beginner Web Development Courses. It has help a lot of people with the basics of HTML, CSS and JavaScript. However when it comes to web development there are a couple more things that you need to know in order to grow your knowledge. It is called “Programming Languages”. There are Read More
This is a lost password script tutorial. It is written in AJAX, jQuery, Boostrap, 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
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
Lets 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
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 a database and a table at the same time with php in mysql. All you will need is the connection information to your database. This is what you will need. Preliminary Information Needed Connection to the host. For most of you this will be localhost. Mysql username. Mysql password. Applies To PHP5 + Mysql You can Read More
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. Backup Website PHP & MySql Step #1 When you first Read More
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
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
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
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
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
To find something that starts with a certain string use this code. SELECT * FROM [table] WHERE [column] LIKE ‘[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 Read More
