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 440 posted 10 years ago by the_construct
If the image source is not in the database a default image is displayed.
0 884 posted 10 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 507 posted 10 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 522 posted 10 years ago by wa-rufio
Most popular languages on the web table (in order of popularity). Handy for auto complete fields and such.
0 841 posted 10 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 631 posted 11 years ago by jiewmeng
0 466 posted 11 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 544 posted 11 years ago by nedf23
3 1653 posted 11 years ago by frederichoule
0 380 posted 11 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 965 posted 11 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 1346 posted 11 years ago by f6design
0 463 posted 11 years ago by athome
0 494 posted 11 years ago by athome
Get all page names and ids from the DB of pages with content containing '#'
0 427 posted 11 years ago by nielsenrc
0 496 posted 11 years ago by cesarkohl
1 603 posted 11 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 659 posted 11 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 529 posted 11 years ago by FatFolderDesigner
0 403 posted 11 years ago by georgemathewkunnathoor
Simple example of how you can output a query as
0 523 posted 11 years ago by Jamie
0 409 posted 11 years ago by karmacode
0 413 posted 11 years ago by sridhar
This is a skeleton mock up for showing a database table in a basic datagrid with sorting and pagination.
0 652 posted 11 years ago by brownrl
run these in the SQL tab
0 428 posted 11 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 1047 posted 11 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 764 posted 11 years ago by skozz
Here you see a example to make your table background color fdifferent at last
0 562 posted 11 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 822 posted 11 years ago by eddequincey
1 2 3 4 5 6 ... 19