How insert multiple values into MySQL from multiple select option

welcome back to shortlearner.com, in the previous post we see how to create a dynamic pie chart with the help of PHP and MySQL. In this post, we will see how to insert data into the MySQL database from multiple select lists using PHP.

 

Below are the steps to do this :
Firstly we have created a test database and after creating a database created a table state inside it and in the state table, we have stored all the states name in it.

multiselect drop down with checkbox

make a dynamic pi-chart with the help of PHP

make a dynamic pi-chart with the help of dynamic pi chart

welcome back to shortlearner.com, in this post we will see how to make a dynamic pi-chart with the help of PHP , MySQL and google charts. most of the time we need to show all reports in a graphical format, so we use pi-chart or other graphical charts.

In this tutorial we will write a PHP script which is helped to show programming language ratings on the pi -chart.
in the very first step we create a database with the name of pi, and also create a database table with the name of programming_languages, in this database we add 4 column (id, name,rating,staus).

How to store the data in unicode in hindi language.

welcome back to shortlearner.com, in the previous post we learn how to track active users location on google map with the help of PHP and google map API.
Today we will see how to insert Hindi font into MySQL database.
we will complete us this task into three steps.
in the very first step we will create a database with the name of “hindi_fonts“, and also create a database table “user_details” which have to column the first one is id and another one is user_name.
in the second step, we will insert the user’s name (Hindi font) into the database.
in the final step, we will fetch all the inserted record and shows in HTML table format.

Create Database

index.php

Fetch.php

 

Change password using javascript, php and mysqli.

Welcome back to shortlearner.com , today we will see how to change password using JavaScript, PHP and MySQL.
first of all we should discuss about overall scenario which we used to reset password.
In first step we make a form (which have three input fields) with the help of HTML, CSS and Bootstrap.

change password in php
In the second step we match the new password and confirm password with the help of JavaScript.
in case if new password and confirm password are not matched than we will disable the submit button with the help of JQuery.