want to join us? register, it's easy | help

browse by tag: mysql

sort by

newest, oldest, most popular


category icon

Alternatives to MySQL

in PHP added by lornajane, on 8/6/2012 advanced tutorials drizzle mariadb mysql percona

Post covering the origins, intentions, features and possible pitfalls with replacing MySQL in your application with drizzle, mariadb or percona server. A very thorough overview of the options, by someone who has used them for real.

comment save report
category icon

CSV Export with Symfony 2

in PHP added by charliepage, on 8/6/2012 csv framework mysql php

A short tutorial on creating a CSV Export feature with the Symfony 2 framework. Included is some sample code for the controller action, the routing for the action and html twig template file.

comment save report
category icon

Preventing MySQL Injection

in PHP added by rosstanner, on 30/4/2012 MySQL injection database databases mysql php php5 security

In this tutorial I am going to explain what MySQL injection is and how important it is to prevent this attack on your database(s). It is vital that all security measures are in place before you make your website live because the effects can be devastating especially if you store sensitive data.

comment save report
category icon

Tutorial: How to Create a Zip File with PHP / MySQL

in PHP added by anthonydamasco, on 3/4/2011 CMS export mysql zip

Recently I added a function to a CMS that I have been evolving to meet the needs of ereads.com. I needed to allow users to select items (in this case ebooks) from the system and then export files that are attached to the books. So lets get started!

comment save report
category icon

The EAV data model

in PHP added by lornajane, on 23/11/2010 advanced tutorials architecture databases modelling mysql

Clear and approachable post showing the use of the entity-attribute-value model to represent data. Includes great examples, tips on when this model is a good choice and when to use alternatives, and a real-world example examining how magento e-commerce uses this pattern.

comment save report
category icon

Migrating a Legacy Forum to vBulletin 4.0.3

in PHP added by prodevtips, on 22/7/2010 advanced tutorials content management mysql php5

How to switch from a legacy forum to vBulletin, and customizing vBulletin.

comment save report
category icon

Creating a secure PHP contact form

in PHP added by sneakybox, on 6/10/2009 contact form mysql php5 secure

An in-depth tutorial explaining how to create a spammer-stopping PHP contact form for your website.

comment save report
category icon

Survive heavy traffic with your webserver

in PHP added by goodphptutorials, on 2/10/2009 PEAR apache caching disk IO linux mysql performance

There are many things you can do to speed up your website. This article focuses on practical things that I used, without any spending money on additional hardware or commercial software.

comment save report
category icon

Search without refreshing page using jQuery, Ajax and PHP.

in PHP added by foxscan, on 8/8/2009 AJAX advanced tutorials database jquery mysql

This tutorial about how to display twitter like search results with jQuery and Ajax. When you click the search button the results will display on the same page. This is very interesting and simple.

comment save report
category icon

Using PHP, AJAX to display Google Maps data

in PHP added by kombattom, on 4/8/2009 AJAX google api jquery map api mysql

A pretty much step by step guide on how I created MarylandLawyerSearch.net. Data is pulled using PHP, put into JavaScript and Google's Map API. Source code for all files are listed with step by step instructions.

comment save report
category icon

Adding Ajax with jQuery to Joomla 1.5

in PHP added by prodevtips, on 3/8/2009 advanced tutorials content management mysql oo programming php5

How to quickly add Ajax anywhere in Joomla 1.5 using jQuery.

comment save report
category icon

Getting Started with Drizzle and PHP

in PHP added by goodphptutorials, on 10/7/2009 database drizzle mysql

Unless you've been completely out of touch with the open source world, you'll have heard of Drizzle, a new database server that's derived from MySQL. The Drizzle project aims to build a "smaller, lighter, faster" version of MySQL that offers similar stability and ease of use, but strips out certain features from the core system in order to improve performance and scalability.

comment save report
category icon

Creating a MySQL Database Class Using the Singleton Design Pattern

in PHP added by thatspoppycock, on 24/3/2009 design patterns mysql oo programming php5 singleton

Using the Singleton Pattern is a simple way to limit the number of instances of an object to just one, helps keep database connections organized, and saves memory. This tutorial will help you create a MySQL database class using this popular design pattern.

comment save report
category icon

Table and Database Operations [pdf]

in PHP added by nirajam, on 7/3/2009 database mysql

The tutorial explains the operations that can be performed on whole tables or databases. It also explains table maintenance operations for table repair and optimization, changing various table attributes, table movements, including renaming and moving to another database, and multi-table operations.

comment save report
category icon

PHP and AJAX - Make a Password Strength Bar that Updates in Real-time

in PHP added by scott25, on 2/2/2009 beginner tutorials databases general mysql security

This tutorial will show you how to make a very simple feature which will help your users make more secure passwords, in registration forms. After the user types their password, this script will make a request to a PHP page, which will check the password for lowercase letters, uppercase letters, numbers and symbols. Without reloading the page, a bar displaying the strength of the password will be shown to the user.

comment save report
category icon

Creating a short url service in php and mysql

in PHP added by adulion, on 10/1/2009 mod_rewrite mysql

Using mod rewrite, some string manipulation and a bit of mysql the tutorial shows you how to create a short url service

comment save report
category icon

Introduction to SQL Injection

in PHP added by iDemonix, on 8/12/2008 beginner tutorials database injection mysql security sql

In this tutorial we look at the issue of SQL injection, how the attackers use it, the problems that can arise and methods of prevention using PHP.

comment save report
category icon

Building semantic Web CRUD operations using PHP

in PHP added by goodphptutorials, on 30/11/2008 crud mysql semantic sparql

Create, Read, Update, and Delete (CRUD) operations are the most basic database operations, but they are also the most crucial. CRUD operations are typically done using the Structured Query Language (SQL) on relational database systems. As the Web is becoming more and more data-oriented, there is a need to shift from SQL-based CRUD operations to semantic Web-based CRUD operations. Learn how to use PHP to perform CRUD operations over the semantic Web.

comment save report
category icon

Access Control [PDF]

in PHP added by nirajam, on 19/10/2008 content management mysql php5

This tutorial gives the outline of a highly flexible role-based access control system. The tutorial helps in establishing principles using standard notions of RBAC. It also teaches you the code for administering RBAC and explains how questions about access can be answered.

comment save report
category icon

Mini Message Board

in PHP added by Dale, on 8/8/2008 board discussion forum mysql

Want to learn how to make your own PHP and MySQL message board? This tutorial will show you pretty much some of the basics of a bog-standard message board.

comment save report
category icon

PHP: Be Notified When Google Crawls Your Site

in PHP added by adzeds, on 3/6/2008 beginner tutorials crawl general google mysql php5

Have you ever wanted to know when Google crawls your website? Well now you can using a simple PHP script which emails you everytime GoogleBot crawls your site.

comment save report
category icon

Installing MySQL on Windows

in PHP added by ducani, on 2/5/2008 installation mysql setup windows

As Web sites and Web-based applications become more important to commercial firms and other organizations, so too does the methods used for storing data online, such as customer contact information, system login details, product data, and much more. Rewritable flat files may be sufficient for extremely limited data for which security is not an issue. But for most Web sites and applications, a robust database is called for.

comment save report
category icon

PHP components: Autosuggest

in PHP added by woork, on 25/3/2008 AJAX beginner tutorials databases mysql

A simple "PHP component" (8Kb), ready to use, to implement a search form with an autosuggest feature using PHP and MySQL just modifying some parameters.

comment save report
category icon

Deleting record with Ajax using prototype.js and PHP

in PHP added by woork, on 12/3/2008 AJAX beginner tutorials database mysql

This tutorial explains how to use prototype.js framework an PHP to delete a record from a database with Ajax. This is a simple overview with basic features you can use and improve in your web projects.

comment save report
category icon

How to Create an RSS Feed for Your Site in PHP

in PHP added by Walkere, on 1/3/2008 advanced tutorials feed file handling mysql php5 xml

An RSS feed is a great way to serve up your content to users. However, if you're not using a standard CMS or blogging platform you may not have an RSS feed generated for you automatically. This tutorial will show you how to create an RSS feed in a few simple steps. If you can query your database to get information about your articles, you can complete this tutorial and build a custom feed.

comment save report