Quick Autocomplete App With PHP and JQUERY MOBILE

In this simple project, we will create a simple web app that searches data from a MYSQL database using PHP and Jquery Mobile listview widget.

Watch Video:
what is jQuery Mobile?

jQuery Mobile is a HTML5-based user interface system designed to make responsive web sites and apps that are accessible on all smartphone, tablet and desktop devices.

How is jQuery Mobile and Php used in this project?

With the help of jQuery Mobile, we make use of a listview widget which is coded as a simple unordered list (ul) or ordered list (ol) with a data-role="listview" attribute.

Then php is used to connect and fetch data from a database with the help of structed query language(SQL).

How the folder structure looks like.

The folder you will download below contains the following files and sub-folders.

  • config(sub-folder)
    • db_con.php
  • autocomplete.sql(import this to your database)
  • index.php
Sneek preview of how the db_con.php file looks like.
copy

<?php 

//change to your server name
$Server_Name = "localhost";

//change to your server user name
$Server_User ="root";

//change to your server password if there is any.
$Server_Pass = "";

//change to your database name
$Db_name ="autocomplete";

//This is dynamic - it will connect basing on the information provided above
$con = mysqli_connect($Server_Name,$Server_User,$Server_Pass,$Db_name);

if(!$con){
	//This will be displayed incase of connection failure.
	echo "Failed to connect to server";
	exit();
}

?>

To download the source code: Click here description

Related Post(s)

» Learn PHP Complete Guide - Introduction

» How to create smart Urls using PHP

» Quick Autocomplete App With PHP and JQUERY MOBILE

» Learn PHP Complete Guide - Environment Setup

» How to convert A Timestamp in Date Format

collections_bookmark Category :: Php
date_range Published :: 2 years ago At: 05:57 PM
event_note Detailed Date :: May 08th, 2019
person Writer :: Code
  • RECENT POSTS
3 months ago

A JavaScript library for formatting and manipulating numbers - Numeral.js

Check out this lightweight JavaScript library used for formatting and manipulating numbers.


4 months ago

All Countries Drop Down List | HTML Select Country Name

This simple country dropdown list is freely available for you to copy and use in your project forms.


4 months ago

HTML Entities Code Alphabet Discovery Using JavaScript

In this post I will show how writing just a few lines in JavaScript will allow you to render, browse and discover the alphabetical letters using a set of HTML entity codes.


4 months ago

YTS YIFY MOVIES API - PROJECT PREVIEW

Download YTS YIFY movies using this simple project I created using their API.


4 months ago

Display Random Advice On Your Website or Web App Using Advice Slip JSON API

Here is a short project to display the use of APIs. I decided to work with an advice API because it seemed like a fun one that I haven't worked on before.


6 months ago

How do I get a YouTube video thumbnail from YouTube using PHP

Have you ever been on youtube and admired a thumbnail of a video?


8 months ago

How to recreate Facebook's console warning

When I was inspecting some code on Facebook. I came across this interesting feature. A simple styled console warning message from Facebook to its dear users(products).


11 months ago

How To Create A Stacked Gallery Using HTML And CSS Source Code

In this post I provide you with the source code for the youtube tutorial I made on how to create a Stacked image gallery Using HTML and CSS.


Subscribe
  • ADVERTISEMENT

YOU MAY LIKE THESE POSTS

share