• code snippets
  • all code snippets/
  • popular code snippets/
  • your code snippets
• extras
• blog
• about snipplr

• Big /
• Small

Top Users

•  chrisaiv (266)
•  jerryvig (223)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  1man (166)
•  adrianparr (164)
•  Scooter (158)
•  krisdb (156)

Popular Tags

Popular Snippets Tagged 'mysql'

• All time
•  / week
•  / month
•  / year

• All / 
• JavaScript / 
• HTML / 
• PHP / 
• CSS / 
• Ruby / 
• Objective C

1. Anti-SQL Injection Function

   PHP mysql php textmate security sql-injection saved by 158 people
   posted on May 27, 2007 by llbbl

2. MySQL Dump

   PHP mysql backup saved by 154 people
   posted on July 1, 2006 by neogeek

3. Simple MySQL Search Function

   PHP mysql search saved by 127 people
   posted on July 1, 2006 by neogeek

4. clean user input data ( GET, POST, COOKIE )

   PHP get mysql sql php post input cookie injection clean saved by 56 people
   posted on November 21, 2007 by peteypablonz

5. MYSQL Database Class

   PHP mysql database class php saved by 48 people
   posted on May 27, 2007 by emuen

6. Export MySQL query results to CSV

   PHP mysql php csv export saved by 30 people
   posted on March 1, 2007 by johnself

7. Backup your MySQL database

   PHP mysql php backup saved by 28 people
   posted on August 18, 2008 by iTony

8. MySQL search

   SQL mysql search saved by 20 people
   posted on January 13, 2008 by j_junyent

9. MySQL List Database Tables

   PHP mysql database tables saved by 20 people
   posted on July 1, 2006 by neogeek

10. MySQL List Databases

    PHP mysql database saved by 20 people
    posted on July 1, 2006 by neogeek

11. MySQL Commands I wish I could remember

    SQL mysql sql saved by 18 people
    posted on March 23, 2008 by chrisaiv

12. Optimize all tables in MySQL database

    PHP mysql php table optimize saved by 15 people
    posted on October 23, 2008 by brent-man

13. Load CSV into MySQL

    SQL mysql sql csv saved by 13 people
    posted on August 12, 2006 by brentroady

14. Simple Database Class

    PHP mysql database class oop security connection saved by 12 people
    posted on March 1, 2009 by lajevardi

15. Backup a remote MySQL database to your local hard disk

    Bash mysql saved by 12 people
    posted on October 9, 2007 by hyperwhat

16. Database Class

    PHP mysql database class php saved by 12 people
    posted on July 19, 2006 by Corhol

17. mysql_safe_query to prevent SQL injection

    PHP mysql sql injection query safe saved by 11 people
    posted on November 1, 2009 by jmiller

18. PHP MySQL Starting Point

    PHP mysql php saved by 11 people
    posted on November 8, 2007 by jrphelps

19. MySQL Database Wrapper

    PHP mysql database wrapper saved by 11 people
    posted on November 30, -0001 by tylerhall

20. OOP MySQL Database Class

    PHP mysql database class php object saved by 10 people
    posted on September 16, 2008 by MMDeveloper

21. MySQL Find and Replace

    MySQL mysql path replace find saved by 9 people
    posted on February 25, 2010 by Jamie

22. Print last query | CodeIgniter

    PHP mysql view textmate print query last codeigniter saved by 9 people
    posted on August 29, 2009 by nkm

23. Export MySQL Data as CSV

    PHP mysql php csv excel spreadsheet saved by 9 people
    posted on January 15, 2009 by mikegreen

24. MySQL Fetch Results

    PHP mysql results saved by 9 people
    posted on July 1, 2006 by neogeek

25. PHP Class: MySQL DB Class

    PHP mysql database class php db Handling saved by 8 people
    posted on May 22, 2008 by mattkenefick

26. PHP/MySQL - Database Class

    PHP mysql database php connection saved by 7 people
    posted on May 12, 2010 by LuckyShot

27. Backup Your MySQL Database Using PHP

    PHP mysql php backup saved by 7 people
    posted on March 4, 2009 by fackz

28. Create CSV from MySQL

    MySQL mysql saved by 6 people
    posted on September 17, 2010 by matula

29. Find duplicate records

    MySQL mysql deduplication saved by 6 people
    posted on May 5, 2010 by fugue

30. Escape String For Like Query

    PHP mysql php search saved by 6 people
    posted on March 24, 2009 by robv

31. Correcting wrong character encoding in MySQL data

    MySQL mysql character utf8 convert encoding latin1 saved by 6 people
    posted on March 6, 2009 by jdbartlett

32. SSH tunnel to local port

    Bash mysql ssh tunnel saved by 6 people
    posted on January 13, 2009 by zachwood

33. PHP - Lightweight Database and Rowset class, ActiveRecord style functions

    PHP mysql database php rails ruby activerecord on saved by 6 people
    posted on July 23, 2008 by dom111

34. MySQL Table - ISO Country List with Abbreviations

    SQL mysql table list country Abbreviation saved by 6 people
    posted on June 10, 2008 by cbrant

35. A-Z Index

    PHP mysql saved by 6 people
    posted on January 20, 2008 by coggla

36. MySQL Mass Text/String Replace

    SQL mysql replace String text mass saved by 6 people
    posted on October 19, 2007 by andyhartleeds

37. mysqldump2mail

    Bash mysql Bash saved by 6 people
    posted on March 18, 2007 by miziomon

38. Smart MySQL Escape Function

    PHP escape mysql function checks automatically prepares saved by 6 people
    posted on October 9, 2006 by sorehead

39. PHP script to make a backup copy of a MySQL table

    PHP mysql table backup copy saved by 5 people
    posted on October 26, 2010 by fackz

40. Load CSV back into mySQL

    MySQL mysql saved by 5 people
    posted on September 17, 2010 by matula