Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix download simple code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background validation directory

Welcome To Snipplr

Everyone's Recent PHP Snippets Tagged mysql

« Prev 1 2 3 4 5 6 7 Next »

PHP Escape String For Like Query

Simple way to escape string for LIKE statements, useful for searches.

mysql

3 835 posted 16 years ago by robv

PHP Query into Array

mysql

1 946 posted 16 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 962 posted 16 years ago by jonniespratley

PHP Backup MySQL Databas with PHP

mysql

2 1034 posted 16 years ago by iTony

PHP Backup Your MySQL Database Using PHP

Database backup function that you can call whenever you want â€” including nightly CRONs.

mysql

6 1215 posted 16 years ago by fackz

PHP REST MySQL Service

mysql

0 860 posted 16 years ago by jonniespratley

PHP Full REST JSON MySQL Management Class

I am currently still working on this, and will make changes.

mysql

1 1068 posted 16 years ago by jonniespratley

PHP list->mysql query iteration for cron job

I needed to have a cron job that did some MySQL work iterating through a long list of items based on the content of a table in MySQL. I wanted each item in the table to be iterated over roughly once every 5 minutes, but building up the in-memory lis...

mysql

0 800 posted 16 years ago by cori

PHP alter table (float)

mysql

0 839 posted 16 years ago by stavelin

PHP Export MySQL Data as CSV

# Export MySQL Data as CSV This code takes a `mysql_query()` resource and outputs its rows into CSV spreadsheet format. Edit the `header('Content-Disposition...` declaration to tell the user's browser to either display the data as plain text or do...

mysql

6 1152 posted 16 years ago by mikegreen

PHP Optimixe MySQL database with php

mysql

1 912 posted 16 years ago by iTony

PHP Single MySQL Result

Simple but useful function for getting a single piece of data from a database and placing it straight into a variable. Example: $variable = one_result("SELECT columnOne FROM table WHERE columnTwo=whatever"); This would insert the value of colu...

mysql

1 710 posted 16 years ago by iridium

PHP Retrieve valid entries for a MySQL ENUM/SET column

mysql

0 916 posted 16 years ago by Wardy

PHP Change ordering position of MYSQL field with PHP

Quick little snippet for changing the ordering of a field in a MYSQL database.

mysql

1 1132 posted 16 years ago by Zync

PHP Nested list from grouped sql

This will create a list grouped by the sorted field, which is an inner join on a category field.

mysql

0 727 posted 16 years ago by fostersolutions

PHP Quick MySQL Connection Test

mysql

2 849 posted 16 years ago by czapata

PHP loading a fetch query

mysql

0 816 posted 16 years ago by iTony

PHP Sorting MySQL data in a GRID

Here is a working example on how to sort data in a grid.

mysql

1 987 posted 16 years ago by assaado

PHP Joining two tables

mysql

1 739 posted 16 years ago by assaado

PHP execute row (retrieve one row)

make a query and retrieve the first record, if error occurs show it and the query.

mysql

0 671 posted 16 years ago by ginoplusio

PHP execute scalar for php

retrieve only one value from the query

mysql

0 832 posted 16 years ago by ginoplusio

PHP Connexion Php Ã un serveur MySQL

mysql

0 871 posted 16 years ago by sebus

PHP PureMVC Database Class

mysql

1 1087 posted 16 years ago by ghwilson4456

PHP Show mysql query log with firebug

Replace all mysql_query() calls in your project to debug_mysql_query() to see all mysql queries in Firebug console.

mysql

1 1155 posted 16 years ago by stancell

PHP MySQL connection with PHP

mysql

3 946 posted 16 years ago by antpaw

PHP dataList - Listar dados

Simplified form to extract data through MySQL

mysql

0 718 posted 16 years ago by LondonWeb

PHP MySQL Connection

mysql

1 734 posted 16 years ago by LondonWeb

PHP Backup your MySQL database

mysql

14 1329 posted 16 years ago by iTony

PHP Loop email reading MySQL

mysql

3 1027 posted 16 years ago by benphelps

PHP PHP - Lightweight Database and Rowset class, ActiveRecord style functions

Been wanting to made one of these for a while and finally I got round to it. For some examples please visit the post: http://www.dom111.co.uk/blog/coding/db/8 Any comments suggestions appreciated. CreativeCommons ShareAlike

mysql

3 1810 posted 16 years ago by dom111