Dynamic Drop down Menu Using PHP and MySQL

In this tutorial, I will show you how to create a dynamic drop down list using PHP and MySql.

Users have the ability to add any number of Main menus as well as sub menu for each of them. All the data are pulled from the database as well as all the link which are embedded in the drop down menu is also pulled from the database itself.

Overview

To continue in this you will need to look into following files.

Copy the codes and save them in files with their respective name in the same folder.

  • Index.php
  • Add_menu.php
  • Style.css

(more…)

Create a dropdown list using MySQL, PHP & JavaScript

Want to create a select the destination or address feature with the custom country, state and city selection drop down list? You are at the right place.

In this tutorial, I will show you how to create a dropdown list using MySQL, PHP, and JavaScript.

Also, we will be using AJAX to make the drop down list auto-populate the data without page refresh.

Overview

Further, You will need to save the following file and keep them in the same folder.

  • Dbconfig.php
  • findCity.php
  • findState.php
  • index.php

(more…)

How to fetch data from MySQL database in Php

In this tutorial, I will show you how to extract data from multiple tables using PHP.
Let us start this by First creating a database “tutorialdb”,
Then add tables to the database. I am using MySQL to create two tables “categoriestbl” & “producttbl”. After that, I will be using PHP to issue a SQL Join command to get data from both tables at once.

Overview

To continue in this tutorial we will be needing files mentioned below

  • Index.php

(more…)

Know Your Age through AJAX and PHP [Free Source code]

In this tutorial, I will guide you how to develop a small web application that shows users age when he enters his year of birth. The calculation happens in real time without page refresh using Ajax.
The application takes Date of Birth as an input, processes it and displays the age to the user.

Overview

Further, You will need to save the following file and keep them in the same folder.

  • Getage.php
  • Index.html
  • Getage.php

(more…)

Submit PHP Form without Page Refresh Using JQuery, Ajax

In this tutorial, we will look into how to submit a PHP Form without Page Refresh Using JQuery, Ajax. For that, let us create a small form, that asks for First name and Last name and then displays the information in a formatted way in the page itself without refreshing the page.

Overview

We will be creating 2 PHP files and using a jQuery file for the tutorial. They are;

  • Index.php
  • Submit.php
  • jquery-1.11.3-jquery.min.js

(more…)