Welcome To Snipplr


Everyone's Recent PHP Snippets Tagged mysql



To use: $update_sql = querys($sql); or $select_sql = getresult($sql); Used simplify selecting rows from a database. You'll need to pass in the SQL statement.
0 593 posted 13 years ago by shawntysco
Used to delete rows from the database. \r\nTo use:\r\n$del = delete(\"quick_links\", $_GET[\'id\']) ;
0 503 posted 13 years ago by shawntysco
Makes basic insert statements a breeze to type while doing basic PHP inserts.\r\n*The function for \\\'querys\\\' on line 44 can be found here: http://snipplr.com/view/40911/query-the-database-php/ *
0 514 posted 13 years ago by shawntysco
I’ve recently had to quickly parse an Apache log file, to get basic usage statistics for a site over a month and wanted the ability to quickly process any general logs and store them in a MySQL table, so I’ve made a small package class.log. In...
2 977 posted 13 years ago by dom111
0 617 posted 13 years ago by paschim
In a Project i had to save serialized arrays in a MYSQL Database, when i used that i got a Error Message for no reason (Error at offset XX of XX bytes in...). I wrote this little functions to fix that issue. (I dont recommend to save serialized Arra...
0 768 posted 13 years ago by FreaKzero
Here's a little trick I started using when working with XAMPP for localhost and keeping things in tune with the live configuration variables such as username and passwords to mysql (or whatever you're writing for). The example below figures your w...
1 470 posted 13 years ago by jackkeller
1 446 posted 13 years ago by kaartz
1 615 posted 13 years ago by yeremiloli
A simple wrapper class for MySql around PDO. Also an example on how to use this wrapper for SQLite.
1 512 posted 13 years ago by Knarf
0 655 posted 13 years ago by DesignByWilliam
Substitute new_ placeholder in the second line with your new prefix. Run it: http://www.yoursite.com/rename.php and wait until it responds with an OK, usually after a couple of seconds. Delete the rename.php script. Edit the configuration.php file...
0 747 posted 13 years ago by beneberle
The current time, converted from UNIX timestamp to use in MySQL DATETIME
0 793 posted 13 years ago by koko
Restricts the vote to one vote per ip per day
0 477 posted 13 years ago by jretamal
0 736 posted 13 years ago by Myrddin
0 745 posted 13 years ago by rifat
1 663 posted 13 years ago by Myrddin
Here is an old Auth class that i made :)
0 809 posted 13 years ago by cigraphics
A simple PHP object which connects to a mysql database, selects fields, creates users and more..
0 715 posted 13 years ago by djstaz0ne
0 547 posted 14 years ago by coevolve
0 607 posted 14 years ago by jonniespratley
1 535 posted 14 years ago by atma
Function to fix char set and collation on mysql tables, see [this link](http://www.barattalo.it/2010/02/11/php-function-to-fix-collation-on-database-fields-of-mysql/ "Fix encoding on db") for examples and more infos.
1 896 posted 14 years ago by ginoplusio
This is useful for escaping multiple values in a POST array.
0 627 posted 14 years ago by bradless
0 571 posted 14 years ago by chrismendis