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

• Big /
• Small

Top Users

•  chrisaiv (269)
•  jerryvig (252)
•  girliegeek (213)
•  scott2b (208)
•  noah (207)
•  narkisr (188)
•  adrianparr (170)
•  1man (166)
•  ljayz (161)
•  Scooter (158)

Popular Tags

Popular Snippets Tagged 'sql'

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

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

1. Prevent SQL Injection

   PHP sql function injection prevent saved by 70 people
   posted on November 28, 2007 by engel

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

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

3. The Sterilizer

   PHP sql php5 injection xss prevention saved by 29 people
   posted on December 7, 2006 by Vanish

4. MySQL Commands I wish I could remember

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

5. Load CSV into MySQL

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

6. Universal clean function - Protects against SQL, XSS, and JS injections

   PHP js sql php function injection clean sanitize xss saved by 12 people
   posted on March 19, 2009 by pgmr

7. mysql_safe_query to prevent SQL injection

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

8. Utility PHP function to paginate SQL queries

   PHP sql php textmate saved by 10 people
   posted on March 20, 2008 by cburyta

9. Prepared Statements: Read

   PHP sql php statements prepared saved by 9 people
   posted on June 25, 2010 by Nettuts

10. Prevent SQL Injection

    ASP sql injection ASP saved by 8 people
    posted on September 2, 2008 by elightbo

11. Update from select

    SQL select sql update saved by 7 people
    posted on February 21, 2008 by wolfie

12. Clean variables from SQL injections

    PHP get sql post array String request security injections saved by 6 people
    posted on March 6, 2009 by naz

13. Build Nested Array From SQL

    PHP sql array nested saved by 6 people
    posted on December 19, 2007 by tylerhall

14. JSON To SQL Generator (JQUERY)

    PHP sql php textmate generator json saved by 5 people
    posted on February 26, 2009 by jonniespratley

15. SQL Injection

    PHP sql injection prevent saved by 5 people
    posted on February 7, 2009 by sarfraznawaz2005

16. Python - Get id3 from MP3 File

    Python database sql start python open repeat music audio mp3 record series60 hello sound id3 sms phonebook app saved by 5 people
    posted on November 9, 2006 by whitetiger

17. US & CANADA Cities Database

    MySQL mysql database states sql list usa city United canada cities saved by 4 people
    posted on October 22, 2011 by frederichoule

18. secure input (xss, sql injection)

    PHP sql php injection xss saved by 4 people
    posted on January 8, 2011 by takel

19. SQL - Find and Replace

    SQL sql replace find and saved by 4 people
    posted on October 8, 2010 by jamiebrwr

20. Find string anywhere in Sql Database

    SQL sql String all find columns saved by 4 people
    posted on August 2, 2010 by emregulcan

21. Timezone database

    SQL sql timezone saved by 4 people
    posted on July 23, 2010 by emregulcan

22. Calculating distance in Kilometres and Miles from Latitude and Longitude

    SQL mysql sql math longitude distance latitude postcode saved by 4 people
    posted on December 1, 2009 by zingo

23. Sanitize a PHP string for input into a Database

    PHP database sql php String security sanitize saved by 4 people
    posted on October 6, 2009 by adamcoulombe

24. Basic script for prevert SQL inj and XSS

    PHP sql php injection sanitize xss saved by 4 people
    posted on August 6, 2009 by kirik

25. PHP isUnique

    PHP sql php is name unique user saved by 4 people
    posted on July 30, 2009 by brownrl

26. Method to prevent SQL Injection attacks.

    PHP database sql oop injection security saved by 4 people
    posted on February 28, 2009 by lajevardi

27. CI CRUD Model - JOIN Example

    PHP sql php5 example model MVC join ci crud codeigniter saved by 4 people
    posted on January 10, 2009 by jtkendall

28. PHP escape for SQL

    PHP escape sql php injection safe xss saved by 4 people
    posted on March 9, 2008 by wbowers

29. asp replace characters for sql statements

    ASP sql ASP saved by 4 people
    posted on February 20, 2007 by elightbo

30. Drop all connections to a sql 2005 database

    SQL sql sql2005 saved by 3 people
    posted on September 22, 2010 by samwa

31. only select date part from datetime

    SQL sql date simple part saved by 3 people
    posted on August 31, 2010 by g8rpal

32. Find Stored Procedures with specified name or contains specified text

    SQL sql search saved by 3 people
    posted on August 5, 2010 by lance

33. MySQL - Most relevant weighted results based (MATCH AGAINST)

    MySQL mysql sql saved by 3 people
    posted on April 27, 2010 by LuckyShot

34. Finding duplicates with SQL

    SQL sql count find duplicates saved by 3 people
    posted on February 25, 2010 by jmiller

35. Search Database for string

    SQL sql search mssql tsql String for Microsoft saved by 3 people
    posted on December 31, 2009 by CDIDevs

36. Grant MySQL Privileges

    SQL mysql sql textmate privileges grant saved by 3 people
    posted on April 4, 2008 by cbrant

37. ASP.Net Page to Return an Image from an SQL Blob Query

    C# sql image c aspnet blob saved by 3 people
    posted on March 24, 2008 by rengber

38. Differences between two Tables

    SQL mysql sql diff saved by 3 people
    posted on February 1, 2008 by zingo

39. Load CSV file to SQL DB

    SQL sql csv saved by 3 people
    posted on January 11, 2008 by Abe

40. MySQL error reporting

    SQL mysql database sql php error code report saved by 3 people
    posted on November 24, 2006 by Shpigford