Welcome To Snipplr
Everyone's Recent Snippets Tagged mysql
- All /
- JavaScript /
- HTML /
- PHP /
- CSS /
- Ruby /
- Objective C
To convert files, especially prior to mysql insert. use file filename to find out encoding
1
860
posted 14 years ago by bionic
Every MySQL class for PHP I've seen so far has been an epic disappointment. This will not lead you to feel the same way. Enjoy!
0
596
posted 14 years ago by jrgp
I wrote this really quick and dirty script to paginate a very large chunk of text. A client site was setup with the understanding their about page would consist of 5-6 paragraphs but their biography ended up being 60 paragraphs. At the end of the d...
0
734
posted 14 years ago by aristoworks
Some code I found for calculating and determining a persons age
1
668
posted 14 years ago by mpcircuitry
used to find content that uses the PHP input filter....useful for upgrading core!
0
852
posted 14 years ago by ReeceMarsland
Using SQL you can have your database return the distance between 2 sets of Lat and Long points, and using some math functions also take into account the curvature of the earth.
3
1172
posted 14 years ago by zingo
Just updated for WP 3 (added wp_postmeta table for menus)! Test out the new installation thoroughly but everything should be fine, and your CMS should be running live on the new server!
0
767
posted 15 years ago by beneberle
A very simple class that quickly gets you interacting with a database, as long as you know sql :P.
1
1331
posted 15 years ago by r3morse
requires Rails libraries. could be rewritten to just use core Ruby libs, but I'm too lazy right now and I use this entirely in my Rails apps.
0
892
posted 15 years ago by mepatterson
- fields on db with utf8_general_ci collation
- make this query after any connection
- put meta charset utf8
- read and write strings without problems
0
747
posted 15 years ago by ginoplusio