Welcome To Snipplr


Everyone's Recent PHP Snippets Tagged mysql



« Prev 1 2 3 4 5 6 7
example of php code I worked on
0 782 posted 8 years ago by johnschneider
In SQL I can get this by adding AND to the join LEFT JOIN installations i ON a.id = i.app AND i.page = :page This way I get the installation info for an app that has an installation on the page, but I get null values on the columns for app's that...
0 2182 posted 8 years ago by satie83
This is the basic code that you need to know to connect and list data with PDO. Don't use de old method (mysql_connect and mysqli_connect) to connect and interact with databases.
0 855 posted 9 years ago by snstro
The code below can be used to lookup IP address in bulk in return of geolocation information using PHP programming languages and MySQL database. In this tutorial, we use the IP2Location LITE database to lookup country of origin from the visitor's IP...
1 1050 posted 9 years ago by Hexahow
WE-Objekte ohne Umwege direkt aus php erstellen. Das ist vor allem dann sinnvoll, denn die Eingaben vorher geprüft und verarbeitet werden sollen oder wenn ein Eingabeformular über mehrere Seiten geht.
0 694 posted 9 years ago by ulfinger
Format a mysql datetime into a PHP date
0 745 posted 9 years ago by flatearthcomms
In this tutorial I will go over implementing Full-Text search in Laravel 4 . Those who have used Laravel 3 in the past may remember that there used to be support for FULLTEXT indexes. This functionality has been removed in Laravel 4 but can still ea...
0 609 posted 10 years ago by CreativePunch
While the Pinnacle Cart API can handle some of this, I found it easier to query the database directly. This PCProduct class was developed for integrating Pinnacle Cart with WordPress with the following methods: - get_product($id) - get_product_by...
1 820 posted 10 years ago by crypticsoft
This is a public jsonp api. I use it with jQuery Like This: $.getJSON("http://yourdomain/yourpath/jsonp_api.php?method=getSchema&params=your_db_name&jsoncallback=?", function(data){ //DO SOMETHING WITH THE DATA HERE }...
1 881 posted 11 years ago by halk
Simple method to insert data to sql
0 480 posted 11 years ago by BergBenji
Update current field data.
0 614 posted 11 years ago by tucq88
PDO-format insert array function
0 919 posted 11 years ago by rickygri
Allows you to connect to different datasources. Very common to use something like this for development,staging and production deployments.
0 634 posted 11 years ago by evinweissenberg
Takes your table name and key=>value array of values and returns the text for inserting into a MySQL database. Automatically surrounds strings with single quotes.
1 843 posted 11 years ago by lemcoe9
1 758 posted 11 years ago by paul0078
0 675 posted 11 years ago by paul0078
0 724 posted 11 years ago by paul0078
Author: J. van Hemert Fixes encoding when utf-8-encoded data is stored in tables with other (e.g. latin_swedish_ci) encoding. Will convert all columns in all tables to utf8_general_ci.
0 784 posted 11 years ago by sjasliek
Write less and do more mysql in php.
4 904 posted 12 years ago by iceman
0 411 posted 12 years ago by pruntrut
If the image source is not in the database a default image is displayed.
0 1167 posted 12 years ago by blantonious
Creates table structure for pitchfx data that is provided by mlb.com. Open PHP file and enter username and password for localhost. Feel free to customize to suit your preference.
0 685 posted 12 years ago by wa-rufio
Open PHP file and enter User Credentials for localhost. The default dates are set to negotiate the 2011 season, but change the date variables to match your desired season data. The start date should be the day before opening day, and the end date t...
0 704 posted 12 years ago by wa-rufio
This is a very rudimentary function used to convert a Datetime delivered by the Twitter API to a format you can store in MySQL's datetime field.
0 1241 posted 12 years ago by aristoworks
Sometimes a legacy database will have HTML entities stored in it. This function converts them. Note that this function assumes you have a database abstraction layer, and may need to be modified to connect to YOUR database.
0 1861 posted 12 years ago by f6design
1 848 posted 12 years ago by jose_506
This is a custom class for caching results through php's session. The class can be used to cache anything, but i use it to cache mysql results so i don't have to get all the time the results by querying MySQL (wich may take a long time, especialy if...
0 905 posted 12 years ago by TimoZachi
Just a short little script that takes a mysql query and turns it into a csv file that downloads automatically. If your interested in the details you can hit up the link.
0 699 posted 12 years ago by FatFolderDesigner
0 556 posted 12 years ago by karmacode
« Prev 1 2 3 4 5 6 7