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 1034 posted 16 years ago by robv

PHP Query into Array

mysql

1 1154 posted 16 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 1157 posted 16 years ago by jonniespratley

PHP Backup MySQL Databas with PHP

mysql

2 1314 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 1636 posted 16 years ago by fackz

PHP REST MySQL Service

mysql

0 1047 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 1236 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 991 posted 16 years ago by cori

PHP alter table (float)

mysql

0 1031 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 1403 posted 16 years ago by mikegreen

PHP Optimixe MySQL database with php

mysql

1 1109 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 873 posted 16 years ago by iridium

PHP Retrieve valid entries for a MySQL ENUM/SET column

mysql

0 1103 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 1337 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 888 posted 16 years ago by fostersolutions

PHP Quick MySQL Connection Test

mysql

2 1020 posted 16 years ago by czapata

PHP loading a fetch query

mysql

0 999 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 1185 posted 16 years ago by assaado

PHP Joining two tables

mysql

1 932 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 822 posted 16 years ago by ginoplusio

PHP execute scalar for php

retrieve only one value from the query

mysql

0 984 posted 16 years ago by ginoplusio

PHP Connexion Php Ã un serveur MySQL

mysql

0 1052 posted 16 years ago by sebus

PHP PureMVC Database Class

mysql

1 1479 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 1352 posted 17 years ago by stancell

PHP MySQL connection with PHP

mysql

3 1157 posted 17 years ago by antpaw

PHP dataList - Listar dados

Simplified form to extract data through MySQL

mysql

0 873 posted 17 years ago by LondonWeb

PHP MySQL Connection

mysql

1 866 posted 17 years ago by LondonWeb

PHP Backup your MySQL database

mysql

14 1718 posted 17 years ago by iTony

PHP Loop email reading MySQL

mysql

3 1231 posted 17 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 2140 posted 17 years ago by dom111