php




Put CalDav Events to Calendar in PHP

Toying around with php and pushing events at first seems a bit advanced. However after some digging around it turns out to be quite simple concept. First you must create a string containing an iCalendar format. Then push the contents of that file to the server with fsockopen or curl …



Making Sense of Stored Procedures with PHP, PDO, and Sqlsrv

Stored Procedures seem to be a rare bird in web development. But one thing is for sure, when you need them, its likely critical. With the last few versions of PHP we have some new arrivals: Sqlsrv data base extension for SQL Server, and PDO. While they don't still have …



PHP MSSQL Charset Issues, Resolved

Recently I had an annoying little bug. Of course against the golden rule of php I was developing with SQL Server and using php's mssql functions. All was working well except there were a few records which had special characters within the returned result which php complained about: Some character …



ColdFusion Style Dumps in PHP

Just wondering around the internet and one site led to another when I tripped over a nice debugging utility that creates ColdFusion style dumps. Its called dBug. The syntax is pretty darn simple. Of course make sure the dBug class file is included, then just create an instance of the …



Make Big Queries More Readable In PHP With Heredoc

I always hated writing big queries in php by concatenating strings. Its very ugly and can get hard to follow with quotes and double quotes. Heredoc to the rescue. If you're unfamiliar with heredoc, its basically a syntax with php (and some other perl based languages) to type blocks of …



RETS Retrieval with PHP and VieleRETS: Part 5

Through the previous 4 parts of this tutorial we've created everything we need to download our MLS feed with RETS. Now we need to make one small change to our batch file, and execute it. We need to use an Advanced Query to retrieve only Active listings from our RETS …



RETS Retrieval with PHP and VieleRETS: Part 4

Now we're ready to create an Extract to link our Source to our Target. From the main menu go ahead and click Create from the Extract menu. Creating an Extract Step one asks for the name, Source and Target. It would be a good idea to name it the same …



RETS Retrieval with PHP and VieleRETS: Part 3

Now we're back out at the main menu where we can create, edit rename our Sources, Targets and Extracts. The next thing we need to do is create a Target(a local storage location). For this example we will set up a database(mysql to be specific, but any database …



RETS Retrieval with PHP and VieleRETS: Part 2

Before starting I would like to be clear that we will be retrieving only entries with an Active status. The entire feed would be huge and frankly its just not needed. First off be sure you have downloaded and installed vieleRETS. The entire installation page boils down to just download …



RETS Retrieval with PHP and VieleRETS: Part 1

Over the last few weeks I have stuggled with a realestate website. All went well except for that one thing we all try to put off until last on any realestate based website, MLS. Well it turns out its not so bad with RETS after all thanks to VieleRETS. What …