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

browse by tag: mysql

sort by

newest, oldest, most popular


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

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

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

Simple PHP/MySQL Pagination

in PHP added by goodphptutorials, on 3/2/2007 databases mysql pagination

Learn how to implement pagination for results from a MySQL database. Full code for a php pagination class is presented.

comment save report
category icon

Creating a simple login script with php and mysql

in PHP added by ineedtutorials, on 31/12/2007 beginner tutorials content management mysql security

Learn to create a simple login system with php and mysql in 7 simple steps

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

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

Complete advanced login member system

in PHP added by ineedtutorials, on 17/1/2008 advanced tutorials content management database login mysql security

This tutorial will show you how to create an advanced member login system with PHP, users can register, change password, email activation is included.

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

The PHP Anthology Volume 1, Chapter 2 - Object Oriented PHP

in PHP added by goodphptutorials, on 12/12/2005 beginner database mysql objects oo programming

The object oriented paradigm is an approach to programming that?s intended to encourage the development of maintainable and well structured applications

comment save report
category icon

LAMP performance for dummies

in PHP added by goodphptutorials, on 15/1/2008 advanced tutorials blog caching database mysql performance

I've spent the last six months combing Google for 'slow mysql' results. It was enlightening. Now in the spirit of giving back to the community I give you:

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

Using prototype.js to add record into database with ajax

in PHP added by woork, on 14/2/2008 AJAX Prototype database mysql

This tutorial explains how to use prototype.js framework to enable a simple ajax request which add a new record (an user name) into a database table using PHP like server side language.

comment save report
category icon

Slider in PHP, Ajax And Javascript

in PHP added by phphungry, on 23/2/2008 AJAX JavaScript beginner tutorials mysql slider

cool nice slider which is implemented using javascript , Ajax and PHP

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
category icon

Export Database Schema as XML

in PHP added by Nolte, on 14/2/2007 databases mysql php schema xml

Sometimes it can be useful to have a dump of the current database schema. This script reads the schema from a MySQL database and outputs XML that describes the schema.

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

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

An Introduction to Database Normalization

in PHP added by goodphptutorials, on 3/12/2006 database databases mysql normalization

This article will take a practical look at database normalization, focusing on the first three of seven generally recognized normal forms. Additional resources that look at the theory of database normalization and the additional normal forms can be found in the Resources section at the end of this article.

comment save report
category icon

Using Stored Procedures & MySQLI in PHP 5

in PHP added by rvdavid, on 11/12/2007 beginner tutorials database mysql oo programming php5

For the occasions that you want to use a stored procedure you've written in MySQL 5 through PHP , the semantic tool to use is PHP's built in mysqli objects/package.

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

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

Three-Tier Development with PHP 5

in PHP added by goodphptutorials, on 21/3/2006 advanced tutorials mysql php5 smarty tier

This article will demonstrate the power of three-tier development in PHP 5, using PEAR::DB_DataObject for the business logic and Smarty for display logic. I assume that you have some familiarity with HTML, Smarty, PEAR::DB_DataObject, MySQL, and PHP 5

comment save report