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 598 posted 7 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 1593 posted 7 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 655 posted 7 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 778 posted 7 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 516 posted 8 years ago by ulfinger
Format a mysql datetime into a PHP date
0 546 posted 8 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 483 posted 8 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 617 posted 9 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 649 posted 10 years ago by halk
Simple method to insert data to sql
0 364 posted 10 years ago by BergBenji
Update current field data.
0 472 posted 10 years ago by tucq88
PDO-format insert array function
0 730 posted 10 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 468 posted 10 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 528 posted 10 years ago by lemcoe9
1 563 posted 10 years ago by paul0078
0 499 posted 10 years ago by paul0078
0 524 posted 10 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 546 posted 10 years ago by sjasliek
Write less and do more mysql in php.
4 679 posted 10 years ago by iceman
0 305 posted 10 years ago by pruntrut
If the image source is not in the database a default image is displayed.
0 891 posted 10 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 516 posted 10 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 528 posted 10 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 973 posted 11 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 1362 posted 11 years ago by f6design
1 611 posted 11 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 667 posted 11 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 537 posted 11 years ago by FatFolderDesigner
0 414 posted 11 years ago by karmacode
« Prev 1 2 3 4 5 6 7