Welcome To Snipplr


Everyone's Recent Snippets Tagged mysql



1 2 3 4 5 6 ... 19
Where clause to select multiple rows of unique values
0 781 posted 12 years ago by the_construct
If the image source is not in the database a default image is displayed.
0 1407 posted 12 years ago by blantonious
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.
0 872 posted 12 years ago by wa-rufio
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...
0 898 posted 12 years ago by wa-rufio
Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.
0 1370 posted 12 years ago by Synnoid
**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 -...
1 1069 posted 12 years ago by jiewmeng
0 837 posted 13 years ago by irishsk
<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...
1 976 posted 13 years ago by nedf23
3 2607 posted 13 years ago by frederichoule
0 695 posted 13 years ago by simsevu
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.
0 1489 posted 13 years ago by aristoworks
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.
0 2241 posted 13 years ago by f6design
0 809 posted 13 years ago by athome
0 914 posted 13 years ago by athome
Get all page names and ids from the DB of pages with content containing '#'
0 772 posted 13 years ago by nielsenrc
0 909 posted 13 years ago by cesarkohl
1 1078 posted 13 years ago by jose_506
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...
0 1177 posted 13 years ago by TimoZachi
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.
0 918 posted 13 years ago by FatFolderDesigner
0 706 posted 13 years ago by georgemathewkunnathoor
Simple example of how you can output a query as
0 856 posted 13 years ago by Jamie
0 725 posted 13 years ago by karmacode
0 714 posted 13 years ago by sridhar
This is a skeleton mock up for showing a database table in a basic datagrid with sorting and pagination.
0 1097 posted 13 years ago by brownrl
run these in the SQL tab
0 762 posted 13 years ago by xcsteve99
Con estas instrucciones se pueden corregir los caracteres latinos que hayan sido almacenados erróneamente en una base de datos MySQL
1 1882 posted 13 years ago by n19ht
"Escapa caracteres especiales en la cadena no escapada, teniendo en cuenta el conjunto de caracteres actual de la conexión para que sea seguro usarla en mysql_query(). Si se van a insertar datos binarios, esta función debe ser usada. mysql_real_...
0 1281 posted 13 years ago by skozz
Here you see a example to make your table background color fdifferent at last
0 957 posted 13 years ago by Darksider3
[Query related to PHP code to save tweets from the twitter search API to a MySQL database](http://snipplr.com/view/56994/save-tweets-using-php-from-the-twitter-search-api-to-a-mysql-database/ "PHP code to save tweets from the twitter search API to a...
0 1415 posted 13 years ago by eddequincey
1 2 3 4 5 6 ... 19