Posts Tagged ‘php’

Exporting data from SQL Server Express 2005 to CSV using PHP

By David Pratt / Tags: , / 5 Comments » / Published: 10-06-11

A tutorial that explains how to connect to a SQL Server 2005 Express database from a PHP script, and then output a CSV file of a table within that database.

Create photo albums and upload photos using the Facebook Graph API

By David Pratt / Tags: , / 71 Comments » / Published: 11-09-10

An example using the Facebook Graph API that shows how to create a photo album and insert photos into it. The example uses PHP.

Best way to store IP addresses in MySQL

By David Pratt / Tags: , / 26 Comments » / Published: 10-08-10

It’s tempting to store IP addresses in a database as a varchar of length 15 in the absence of a dedicated IPv4 field type in mysql, but that isn’t the most efficient way of doing so…

Non-standard page size’s in TCPDF

By David Pratt / Tags: , / 17 Comments » / Published: 23-06-10

If you need to create a PDF using TCPDF that isn’t a standard size (A4, A5, B1, LETTER etc.) then this snippet might help you out: $resolution= array(100, 100); $pdf->AddPage(‘P’, $resolution);

Using Crontab with Plesk to call PHP files

By David Pratt / Tags: , , / 36 Comments » / Published: 06-05-10

How to set up a scheduled job on Plesk that calls a PHP file at an interval of your choosing.