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 osx download simple c code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background

Welcome To Snipplr

Everyone's Recent Snippets Tagged mysql

« Prev 1 2 3 4 5 6 ... 19 Next »

SQL Where clause to select multiple rows of unique values

Where clause to select multiple rows of unique values

mysql

0 828 posted 13 years ago by the_construct

PHP Display default image if not in database

If the image source is not in the database a default image is displayed.

mysql

0 1472 posted 13 years ago by blantonious

PHP PHP Create pitchfx Table Structure

Creates table structure for pitchfx data that is provided by mlb.com. Open PHP file and enter username and password for localhost. Feel free to customize to suit your preference.

mysql

0 917 posted 13 years ago by wa-rufio

PHP Extract PitchFX from MLB.com

Open PHP file and enter User Credentials for localhost. The default dates are set to negotiate the 2011 season, but change the date variables to match your desired season data. The start date should be the day before opening day, and the end date t...

mysql

0 951 posted 13 years ago by wa-rufio

MySQL Languages table

Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.

mysql

0 1428 posted 13 years ago by Synnoid

Bash Create Linux User with Geneated Password and MySQL User

**Usage** > newuser.bash [username] **What it does** - Generates a random password with `makepasswd` - Encrypts it with `mkpasswd` for use with useradd - Adds the user - Adds a MySQL Database for user - Adds a MySQL User for user -...

mysql

1 1123 posted 13 years ago by jiewmeng

MySQL MYSQL search and replace

mysql

0 880 posted 13 years ago by irishsk

MySQL MySQL Data Pull to Localhost

<h1>What it does</h1> <p>This snippet is used to pull data from one server to another. I primarily use it to get the latest data from our production to our development environments. The first part of the command is where the data is pulling from a...

mysql

1 1037 posted 13 years ago by nedf23

MySQL US & CANADA Cities Database

mysql

3 2688 posted 13 years ago by frederichoule

MySQL Average discount in magento 1.4.1

mysql

0 784 posted 13 years ago by simsevu

MySQL wordpress - MYSQL - Assign all articles from one author to another

mysql

0 1046 posted 13 years ago by krembo99

PHP Convert Twitter API Datetime to MySQL Datetime Format

This is a very rudimentary function used to convert a Datetime delivered by the Twitter API to a format you can store in MySQL's datetime field.

mysql

0 1552 posted 13 years ago by aristoworks

PHP Convert all HTML entities in database to actual characters

Sometimes a legacy database will have HTML entities stored in it. This function converts them. Note that this function assumes you have a database abstraction layer, and may need to be modified to connect to YOUR database.

mysql

0 2335 posted 13 years ago by f6design

MySQL Change MySQL user password

mysql

0 856 posted 13 years ago by athome

MySQL Create user & grant privilege

mysql

0 962 posted 13 years ago by athome

MySQL CMS Made Simple Query for Pages Containing \'#\'

Get all page names and ids from the DB of pages with content containing '#'

mysql

0 816 posted 13 years ago by nielsenrc

SQL if mysql_query is not empty

mysql

0 968 posted 13 years ago by cesarkohl

PHP Class database mysql

mysql

1 1133 posted 13 years ago by jose_506

PHP SessCacher: Class for caching data through php session

This is a custom class for caching results through php's session. The class can be used to cache anything, but i use it to cache mysql results so i don't have to get all the time the results by querying MySQL (wich may take a long time, especialy if...

mysql

0 1264 posted 13 years ago by TimoZachi

PHP Simple MySQL to CSV

Just a short little script that takes a mysql query and turns it into a csv file that downloads automatically. If your interested in the details you can hit up the link.