How to Import and Export CSV Files Using PHP and MySQL

In this article we show you how to import data from CSV files and paste them into MySQL database tables using PHP Script. In this post, you will learn how to extract data from uploaded CSVs and then insert data into MySQL tables. If you want to enter a large amount of data stored under a CSV file and put it in a MySQL database, you can use this type of concept at this time. To retrieve data from CSV data files, we use the simple function fgetcsv () to extract all data from CSV files, and then run an insert query to enter data into the table.

Continue ReadingHow to Import and Export CSV Files Using PHP and MySQL
PHP Login Script with Remember Me using Cookies

In this post we will learn how to create PHP login script with remember me using Cookies like email and password .If user enters again on the same login page, this data will be entered in the current registration form. This type of login function helps users to reduce user experience and stop entering logins again and again.

Continue ReadingPHP Login Script with Remember Me using Cookies
PHP Login Registration Script by using Password_hash() & Password verify() method for Secure login

If you are looking for ways to use the password_hash() method to log in and register in a PHP script. In this tutorial we will discuss how to use the PHP password hash method to secure logins and registrations. This PHP password_hash() method creates a new password hash using an efficient one-way hashing algorithm. This method was first introduced in PHP 5.5 and creates a new password hash with a length of 60 characters.

Continue ReadingPHP Login Registration Script by using Password_hash() & Password verify() method for Secure login
How to Upload Image in database using jQuery AJAX in PHP Mysql

I use jQuery AJAX to implement image uploads. There is a form with file input fields and a upload buttons. When a form with the selected image file is sent, the AJAX script is run. In this code, a PHP upload request is sent with the uploaded image. The PHP code moves the uploaded image to the uploads folder and insert the image name in database and returns the HTML image to display the preview in AJAX response.

Continue ReadingHow to Upload Image in database using jQuery AJAX in PHP Mysql
Sign Up and Login using jQuery AJAX in PHP Mysql

In this article we will learn How to create Sign up and login functionality using jQuery AJAX in PHP MySQL. There are a large number of online applications and the registration system must be the most common function among all. The registration form is intended to allow users to purchase a membership to obtain special permissions that vary depending on the application. The importance of the registration system for application registration is to make the visitor a registered member of the application and to allow visitors to enter the system to verify its authenticity. Based on the authenticity of the registered user, application users are given access to web pages, utilities, and permissions.

Continue ReadingSign Up and Login using jQuery AJAX in PHP Mysql
How to Check username & email already exists using jquery ajax in php mysql

In this post you will learn how to check username & email is already exists in database using jquery AJAX in PHP mysql.So, when you enter your username or email, at this time the Ajax function, called the server, is the username or email that is entered unique or not. The database is checked on the server side and determined whether the username or email entered is available or not. Then it will return to the Ajax request for the username and email or not and the results will be displayed immediately without refreshing the page.

Continue ReadingHow to Check username & email already exists using jquery ajax in php mysql
How to Create show hide password using jQuery or Javascript

In this post you will learn how to create show hide password functionality using jQuery and you will also lean how to create show hide password functionality in javascript. In the most of the website’s login and register page reducing type of error while entering password in textbox we can show password after entering password. If we show password then we can reduce type of error. For showing password, I have used jquery. With the help of jquery we can show entering password and hide entering password on eye icon click event. I have used jquery attr() method for show and hide password. This functionality is very useful for any website login or registration page.

Continue ReadingHow to Create show hide password using jQuery or Javascript