This article will you detail understanding on what is primary and foreign key in SQL database and how to use them to manage relationship between two or multiple tables and also details the key difference between primary and foreign key
MySql
Change User Password by Validating Current Password in PHP MySQL
The perfect user of PHP password_hash and password_verify inbuilt functions, Learn how you can develop change login password feature along with all required validations.
3 Steps to Build efficient PHP MySQL Shopping Cart Application
Introduction Let’s learn how to develop shopping cart using PHP and MySQL, in this tutorial I am going to provide details steps along with source code on how we can build simple and best shopping cart in 10 minutes. We all know shopping cart is used to collect items at one place to submit the […]
MySQL Database Backup and Restore from Terminal
Learn how to take MySQL database backup using terminal from server and Restore or migrate the database using terminal with mysqldump command
User Account activation by email verification using PHP
User Account activation, email verification using PHP, MySQL and Swiftmailer Introduction: I have posted tutorials on login registration system, which has simple account registration process to just enter the details to create new account and you can login to the account, but we always needs to verify account email under live application to make sure […]
PHP PDO CRUD Operations Using Bootstrap
I have been getting requested to post crud tutorial with PDO connection, so finally it’s here. Live Demo Tutorial Features: Create, Read, Update and Delete Records Bootstrap – for design and modal popup jQuery – Used to handle ajax request Tutorial Focus: At the end of this tutorial you should be able to learn how to use […]