Login / Register

Share Snipplr

Follow @Snipplr

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 611 posted 12 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 1210 posted 12 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 709 posted 12 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 722 posted 12 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 1204 posted 12 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 884 posted 12 years ago by jiewmeng

MySQL MYSQL search and replace

mysql

0 671 posted 12 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 772 posted 12 years ago by nedf23

MySQL US & CANADA Cities Database

mysql

3 2302 posted 12 years ago by frederichoule

MySQL Average discount in magento 1.4.1

mysql

0 528 posted 12 years ago by simsevu

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

mysql

0 792 posted 12 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 1280 posted 12 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 1910 posted 12 years ago by f6design

MySQL Change MySQL user password

mysql

0 638 posted 12 years ago by athome

MySQL Create user & grant privilege

mysql

0 708 posted 12 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 602 posted 12 years ago by nielsenrc

SQL if mysql_query is not empty

mysql

0 715 posted 12 years ago by cesarkohl

PHP Class database mysql

mysql

1 877 posted 12 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 930 posted 12 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.