Web application programming tutorials

Symfony: Rebuild from Schema.yml Without Loss of Data

contributed by David Kirk on June 27, 2008 under Symfony

As my test database became more complex, I hated entering data again after doing a propel-build-all. Following these commands, you can save your database content after rebuilding your database from your schema file.

 

Symfony: Delete an Application

contributed by qmchenry on April 6, 2008 under Symfony

The command line provisioning utility in symfony provides mechanisms to create an application, but doesn’t have the means to delete one. If you’ve unintentionally created an application or no longer need an app and want to do housecleaning, this Tech-Recipe describes how to get it gone.

 

Symfony: Fix propel-insert-sql error: Can’t connect to local MySQL server

contributed by qmchenry on April 4, 2008 under Symfony

After building your model and the SQL code to represent it, symfony offers a mechanism to insert the SQL code directly into your configured database. If you are running MySQL locally, this should work for you with no additional configuration. If you are running MySQL on another server, as is common in shared web hosting and other environments, you’ll get an error. In the past, I’ve just grunted and sent the SQL code to the database manually, but there is an easy fix to make things work as they should.

 

PHP: Print the current year for copyright notices

contributed by qmchenry on March 8, 2008 under PHP programming

Hardcoding the year in a copyright notice is an easy way to get a blog or other website started, just placing the starting and ending years next to the copyright symbol. We have the very best of intentions to change this number right after the big ball drops in Times Square each year. We’re also human and, all too often, I see websites with copyright notices that are years behind. If your website is PHP-powered, this quick bit of code will put the current year in your copyright notice and off of your mind.

 

Dreamweaver CS3: Change How Text is Pasted into Design View

contributed by Rob Rogers on March 6, 2008 under Web application programming

Pasting the text from another application into Dreamweaver’s design view can be rather messy. This is due to the default settings, as they keep the original structure and basic formatting of the originating application. Fortunately, the defaults can be changed to better meet your main needs and using Paste Special can be used for situations that require different settings.

 

Fix for ASP Pages That Will Not Display an ADO Recordset based on a #Temp Table

contributed by Rob Rogers on January 22, 2008 under Web application programming

Here’s the problem: your asp page is designed to display the data contained in an SQL generated #temp table. When you run the page, you get an error that states that the operation is not allowed when the object is closed. If you execute the SQL command in a query window though, the data is displayed as expected.

 

Symfony: Add log message manually

contributed by qmchenry on September 17, 2007 under Symfony

When troubleshooting a complex web application (or a simple one), there are times that sending a message to a log file will help. Two command syntaxes are required depending on if you are in an action or a template. When using the development environment of an application in Symfony, the log message will show up in the development toolbar which will make your life even easier.

 

Symfony: Troubleshooting file uploads

contributed by qmchenry on August 6, 2007 under Symfony

The Symfony framework is an amazing project which brings many best practices to the hands of mortal coders. It’s also a dauntingly vast system with many subdirectories and classes. While trekking your way up the learning curve, you may run into hurdles which seem daunting. One possible gotcha involves adding file uploading to an existing Symfony form.