programming, web, application, ASP.NET, PHP, JSP, basics Web application programming | Tech-Recipes

Web application programming tutorials

PHP: Upload Files to the Server

Contributed by William_Wilson on September 30, 2008 under PHP programming

With PHP, it is simple to upload any file to your server.

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.

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 shamanstears 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 shamanstears 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.