Login / Register

Share Snipplr

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.

mysql

0 631 posted 13 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 549 posted 13 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 556 posted 13 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 1036 posted 13 years ago by dom111

PHP full php mysql connection script

mysql

0 650 posted 13 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 803 posted 13 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 492 posted 13 years ago by jackkeller

PHP PDO Connect - MySQL

mysql

1 474 posted 13 years ago by kaartz

PHP Simple Class Connection

mysql

1 649 posted 13 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 540 posted 13 years ago by Knarf

PHP PHP MYSQL CONNECT

mysql

0 685 posted 13 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 794 posted 13 years ago by beneberle

PHP Push your git logs to MySQL with PHP

mysql

1 856 posted 13 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 829 posted 13 years ago by koko

PHP IP Poll Restriction

Restricts the vote to one vote per ip per day

mysql

0 504 posted 13 years ago by jretamal

PHP PHP MySql Class

mysql

0 777 posted 13 years ago by Myrddin

PHP MySQL date to PHP timestamp

mysql

0 794 posted 13 years ago by rifat

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

mysql

1 662 posted 13 years ago by yisreldov

PHP PHP MySql Login

mysql

1 697 posted 14 years ago by Myrddin

PHP Authentication class using cookies or sessions

Here is an old Auth class that i made :)

mysql

0 841 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 744 posted 14 years ago by djstaz0ne

PHP Function to convert dates to and from Mysql

mysql

1 899 posted 14 years ago by fackz

PHP LoneDatabaseClass

mysql

0 575 posted 14 years ago by coevolve

PHP Super Database Access/Service

mysql

0 640 posted 14 years ago by jonniespratley

PHP PDO multiple inserts

mysql

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