All posts in MySQL

Use PHP, MySql and Google Map API v3 for displaying data on map

Displaying multiple=Displaying data on maps can be useful in many situations.

By integrating tools like PHP, MySQL and Google Maps, you can relatively easy build customized maps for your website or blog.

In this post we’ll take a closer look on the possibilities, and build a  interactive map based on PHP, MySql and Google Map API v3.

To see what we’re building, see live example here

Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Ajax autocomplete with jquery and php

Jquery autocomplete script with ajax and phpWith a autocomplete script you can make it easier for your users to provide valid input for a from, by providing suggestions as soon as the users starts to type in the first data.

In this post we’ll implement a autocomplete script, that uses jquery, ajax, PHP and MySQL for a smooth and easy to configure autocomplete solution.

Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Measure PHP page loading time

Measure page loading times with PHPA important part of the users experience, when visiting a website, is the page loading time.

However loading times has been even more important to focus on after the latest updates of the Google ranging algorithm, where slow loading sites will get a penalty, and fast loading sites will get a bonus.

In this post we’ll create a PHP script that can be used to measure the loading time of  a PHP page.

Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Create your own RSS feed with PHP and Mysql

Create a RSS feed with MySQL and PHPA RSS feed is a great way of distributing your content to new and existing users. RSS feeds are a fine alternative to email newsletters, since users can read the feeds when they want, and modern feed readers givers the users great overview over many feed sources.

In this post you can learn how easy it is to create a RSS feed with PHP and MySQL

Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Tagcloud with PHP and MySQL

Create a tagcloud with mysql and phpA tagcloud is a great way to illustrate what content on your site is the most popular.

In this post we’ll build a tagcloud script based on PHP and MySQL.

The script uses very basic HTML and CSS that you can easily customize to reflect the look and feel of your site. Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Protect your PHP script from SQL injections in 5 min

Prevent your site from SQL InjectionWith SQL injection, people with bad intentions can delete or change content in your MySQL database.

The good news is that there is a simple solution to prevent SQL injections, so there is no excuses not implementing this technique to your PHP scripts asap.

In this post you’ll learn about SQL injections, and how they can be prevented in your PHP scripts.
Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS

Output MySQL data in columns

If you’re going to display a huge number of data from MySQL, a one column list might not be the optimal solution. In some cases,  a 2 or 3 column list makes it easier for the user to navigate in the result, and makes the page shorter.

In this guide you will learn how to make a simple php script that can output data into nicely formatted columns.

Read more…

Share and Enjoy

  • Facebook
  • Twitter
  • Delicious
  • LinkedIn
  • StumbleUpon
  • Add to favorites
  • Email
  • RSS