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 737 posted 15 years ago by robv

PHP Query into Array

mysql

1 832 posted 15 years ago by apro2000

PHP MySQL Schema XML Export

Export entire database schema to local xml file.

mysql

1 850 posted 15 years ago by jonniespratley

PHP Backup MySQL Databas with PHP

mysql

2 901 posted 15 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 1076 posted 15 years ago by fackz

PHP REST MySQL Service

mysql

0 749 posted 15 years ago by jonniespratley

PHP Full REST JSON MySQL Management Class

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

mysql

1 921 posted 15 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 711 posted 15 years ago by cori

PHP alter table (float)

mysql

0 737 posted 15 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 1013 posted 15 years ago by mikegreen

PHP Optimixe MySQL database with php

mysql

1 821 posted 15 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 617 posted 15 years ago by iridium

PHP Retrieve valid entries for a MySQL ENUM/SET column

mysql

0 818 posted 15 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 1022 posted 15 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 647 posted 15 years ago by fostersolutions

PHP Quick MySQL Connection Test

mysql

2 748 posted 15 years ago by czapata

PHP loading a fetch query

mysql

0 708 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 882 posted 16 years ago by assaado

PHP Joining two tables

mysql

1 647 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 591 posted 16 years ago by ginoplusio

PHP execute scalar for php

retrieve only one value from the query

mysql

0 713 posted 16 years ago by ginoplusio

PHP Connexion Php Ã un serveur MySQL

mysql

0 780 posted 16 years ago by sebus

PHP PureMVC Database Class

mysql

1 979 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 1043 posted 16 years ago by stancell

PHP MySQL connection with PHP

mysql

3 844 posted 16 years ago by antpaw

PHP dataList - Listar dados

Simplified form to extract data through MySQL

mysql

0 647 posted 16 years ago by LondonWeb

PHP MySQL Connection

mysql

1 611 posted 16 years ago by LondonWeb

PHP Backup your MySQL database

mysql

14 1152 posted 16 years ago by iTony

PHP Loop email reading MySQL

mysql

3 908 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 1582 posted 16 years ago by dom111