Symfony | Tech-Recipes

Symfony tutorials

Symfony / Propel: How to Left Join

Contributed by davak on July 4, 2008 under Symfony

A JOIN is a way to connect related database tables by the common values between them. A left join contains all of the rows from the primary table plus related members of the second database if they exist. Using joins can significantly reduce the number of database queries required to render a web page. This Tech-Recipe describes how to do a left join in Symfony using Propel.

Symfony: Rebuild from Schema.yml Without Loss of Data

Contributed by davak 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.

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.