Login / Register

Share Snipplr

Follow @Snipplr

Popular Tags

form regex email curl url http login css mysql database ajax javascript js sql class php header redirect table ie data dropdown sort list object date phone number format svn command resize image file textmate plugin path math actionscript event mail link window debug template Bash java search html post mac error xhtml page google wordpress server rails browser python script replace style array forms backup flash video ruby DOM xml category unix download simple code windows navigation jquery cakephp regexp text function button links filter ie6 linux images htaccess apache free files copy log module query background validation directory

Welcome To Snipplr

Everyone's Recent PHP Snippets Tagged mysql

« Prev 1 2 3 4 5 6 7 Next »

PHP Query the database PHP

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.

mysql

0 781 posted 14 years ago by shawntysco

PHP PHP, Build a basic dynamic DELETE string

Used to delete rows from the database. \r\nTo use:\r\n$del = delete(\"quick_links\", $_GET[\'id\']) ;

mysql

0 668 posted 14 years ago by shawntysco

PHP PHP, Build a basic dynamic INSERT string

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/ *

mysql

0 671 posted 14 years ago by shawntysco

PHP php-log - Process log files with PHP

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...

mysql

2 1251 posted 14 years ago by dom111

PHP full php mysql connection script

mysql

0 795 posted 14 years ago by paschim

PHP serialize and unserialize functions for MYSQL Storage

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...

mysql

0 973 posted 14 years ago by FreaKzero

PHP PHP Smart Config File

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...

mysql

1 628 posted 14 years ago by jackkeller

PHP PDO Connect - MySQL

mysql

1 597 posted 14 years ago by kaartz

PHP Simple Class Connection

mysql

1 778 posted 14 years ago by yeremiloli

PHP Simple MySQL wrapper around PDO

A simple wrapper class for MySql around PDO. Also an example on how to use this wrapper for SQLite.

mysql

1 667 posted 14 years ago by Knarf

PHP PHP MYSQL CONNECT

mysql

0 805 posted 14 years ago by DesignByWilliam

PHP Change Default Joomla Database Table Prefix

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...

mysql

0 937 posted 14 years ago by beneberle

PHP Push your git logs to MySQL with PHP

mysql

1 1007 posted 14 years ago by jaspertandy

PHP Convert UNIX timestamp to MySQL DATETIME

The current time, converted from UNIX timestamp to use in MySQL DATETIME

mysql

0 992 posted 14 years ago by koko

PHP IP Poll Restriction

Restricts the vote to one vote per ip per day

mysql

0 614 posted 14 years ago by jretamal

PHP PHP MySql Class

mysql

0 904 posted 14 years ago by Myrddin

PHP MySQL date to PHP timestamp

mysql

0 950 posted 14 years ago by rifat

PHP Get UTF-8 hebrew date from date stamp ( mysql )

mysql

1 805 posted 14 years ago by yisreldov

PHP PHP MySql Login

mysql

1 832 posted 14 years ago by Myrddin

PHP Authentication class using cookies or sessions

Here is an old Auth class that i made :)

mysql

0 969 posted 14 years ago by cigraphics

PHP PHP Mysql Connection Object

A simple PHP object which connects to a mysql database, selects fields, creates users and more..

mysql

0 892 posted 14 years ago by djstaz0ne

PHP Function to convert dates to and from Mysql

mysql

1 1064 posted 14 years ago by fackz

PHP LoneDatabaseClass

mysql

0 692 posted 14 years ago by coevolve

PHP Super Database Access/Service

mysql

0 793 posted 14 years ago by jonniespratley

PHP PDO multiple inserts

mysql

1 676 posted 14 years ago by atma

PHP PHP function to change collation on MySQL db

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.