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 624 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 542 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 548 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 1021 posted 13 years ago by dom111

PHP full php mysql connection script

mysql

0 643 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 795 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 488 posted 13 years ago by jackkeller

PHP PDO Connect - MySQL

mysql

1 470 posted 13 years ago by kaartz

PHP Simple Class Connection

mysql

1 640 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 533 posted 13 years ago by Knarf

PHP PHP MYSQL CONNECT

mysql

0 679 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 784 posted 13 years ago by beneberle

PHP Push your git logs to MySQL with PHP

mysql

1 851 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 822 posted 13 years ago by koko

PHP IP Poll Restriction

Restricts the vote to one vote per ip per day

mysql

0 497 posted 13 years ago by jretamal

PHP PHP MySql Class

mysql

0 768 posted 13 years ago by Myrddin

PHP MySQL date to PHP timestamp

mysql

0 786 posted 13 years ago by rifat

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

mysql

1 656 posted 13 years ago by yisreldov

PHP PHP MySql Login

mysql

1 692 posted 13 years ago by Myrddin

PHP Authentication class using cookies or sessions

Here is an old Auth class that i made :)

mysql

0 829 posted 13 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 736 posted 14 years ago by djstaz0ne

PHP Function to convert dates to and from Mysql

mysql

1 893 posted 14 years ago by fackz

PHP LoneDatabaseClass

mysql

0 564 posted 14 years ago by coevolve

PHP Super Database Access/Service

mysql

0 632 posted 14 years ago by jonniespratley

PHP PDO multiple inserts

mysql

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