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

PHP Query into Array

mysql

1 1443 posted 16 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 1457 posted 16 years ago by jonniespratley

PHP Backup MySQL Databas with PHP

mysql

2 1952 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 2861 posted 16 years ago by fackz

PHP REST MySQL Service

mysql

0 1348 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 1601 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 1276 posted 16 years ago by cori

PHP alter table (float)

mysql

0 1354 posted 17 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 2115 posted 17 years ago by mikegreen

PHP Optimixe MySQL database with php

mysql

1 1470 posted 17 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 1172 posted 17 years ago by iridium

PHP Retrieve valid entries for a MySQL ENUM/SET column

mysql

0 1434 posted 17 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 1637 posted 17 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 1156 posted 17 years ago by fostersolutions

PHP Quick MySQL Connection Test

mysql

2 1368 posted 17 years ago by czapata

PHP loading a fetch query

mysql

0 1304 posted 17 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 1472 posted 17 years ago by assaado

PHP Joining two tables

mysql

1 1254 posted 17 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 1066 posted 17 years ago by ginoplusio

PHP execute scalar for php

retrieve only one value from the query

mysql

0 1228 posted 17 years ago by ginoplusio

PHP Connexion Php Ã un serveur MySQL

mysql

0 1387 posted 17 years ago by sebus

PHP PureMVC Database Class

mysql

1 2674 posted 17 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 1652 posted 17 years ago by stancell

PHP MySQL connection with PHP

mysql

3 1480 posted 17 years ago by antpaw

PHP dataList - Listar dados

Simplified form to extract data through MySQL

mysql

0 1114 posted 17 years ago by LondonWeb

PHP MySQL Connection

mysql

1 1111 posted 17 years ago by LondonWeb

PHP Backup your MySQL database

mysql

14 2878 posted 17 years ago by iTony

PHP Loop email reading MySQL

mysql

3 1793 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 2872 posted 17 years ago by dom111