Category Archives: MySql

MySQL is an open-source relational database management system (RDBMS) that is widely used for web applications and other software projects. It is a free software under the GNU General Public License, which means it can be used, modified, and distributed freely.

MySQL is known for its reliability, scalability, and performance, making it a popular choice for large-scale web applications. It supports a range of features, including data indexing, transaction processing, and support for multiple storage engines.

MySQL is also highly customizable, with a range of configuration options that can be adjusted to meet the needs of specific applications. It can be integrated with a range of programming languages, including PHP, Python, and Java, making it a versatile option for developers.

One of the main benefits of MySQL is its community support, which provides a wealth of resources, including forums, documentation, and tutorials. It is also frequently updated and maintained, with regular security patches and bug fixes.

Overall, MySQL is a powerful and flexible RDBMS that is ideal for web applications and other software projects. Its open-source nature, scalability, and customization options make it a popular choice among developers and businesses alike.

Building a Calorie and Nutrient Counter Using FoodData Central API

In this tutorial, I’ll walk you through the process of creating a calorie and nutrient counter using the FoodData Central API. This guide will help you build a web application that allows users to enter a food item and receive detailed nutritional information. Video Here https://youtu.be/t2WidqU06n4 Prerequisites Before we start, ensure you have the following: Read More

Delete Images Off Server In Summernote with php, mysql, jquery, and ajax

In this article, I will explain how to delete images from the server using Summernote, a WYSIWYG editor, with the help of PHP, MySQL, jQuery, and Ajax. Summernote is a popular open-source WYSIWYG editor that allows users to create rich text content, including images. Sometimes, users may want to delete the images they have uploaded Read More

Summernote How To Delete Images Uploaded To A Folder

In Summernote you want to be able to delete your images in your directory or folder at times. As far as I can see, this is the only tutorial out there on this, so I decided to do it. I made a tutorial in the past that shows you how to upload images to a Read More

Self Destruct Letter Script

This self destruct letter script is fun, fast and mobile friendly. All you have to do is download it and upload it to your server. I created this script a while ago but I made some updates to it. You can see the self destruct letter script in action here. Feel free to use it. Read More

Summernote How To Store Images and Entries in MySQL Without Base 64

In this tutorial, we will show you how to store images and entries in MySQL without base 64 encoding. Base 64 encoding will bloat your database. The way I show you how to do it here will not bloat your database. You can download summernote here, however you do not need to download it for Read More

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

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

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

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

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

INTERMEDIATE WEB DEVELOPMENT SET UP A SERVER

Now, you have to set up a server. 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 Read More

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. People frequently lose their passwords. Password reset scripts are almost mandatory, with people expecting software to do everything for them. Writing scripts that let 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

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

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

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