A Simple PHP, MySQL and JQuery List— A Step By Step Guide.

What we’re gonna do

We’re going to create a HTML u/o list, which contents are dynamically loaded with AJAX from a MySQL table. We will also cover the issue of adding new entries to our list. Simple! Or is it?

Requirements

What you need to have to understand this guide is ultra basic knowledge of the syntax of PHP and MySQL statements, plus a little more of JQuery. All in all, the task might seem complicated at first (I know—I’ve been there) but it will get clear as soon as you try it out for yourself.

The HTML—index.html

Let’s first lay out a basic structure of our HTML document.

1
2
3
4
5
6
7
8
9
10
11
12

<!doctype HTML>
<html>
<head>
   <link rel="stylesheet" href="style.css" />
</head>
<body>
   <ul>
 
   </ul>
   <script type="text/javascript" src="script.js"></script>
</body>
</html>

Pretty self-explanatory—loading in our styles and JS script and creating the <ul> element for our list.

To be continued…

Earn money ’til you puke.

I’ve been thinking the other day (wow! he can think).

Since childhood we are under constant pressure of the society that wants us to strive for getting more and be more. Now, there would be nothing wrong with that as self-improvement should play a huge role in life, but in this sense the direction of this improvement seems a little misguided.

To be continued…