Creating a News Module using PHP and MySQL

In this tutorial we will look at an easy way to implement news into your website using only 3 different PHP scripts.

Uploading files on a RaQ4 with Chilisoft/MySQL

File upload on a RaQ running MySQL/Chilisoft is relatively simple but has practical limitations that have been overcome on MS platforms using Pure ASP Upload. The key issue is that the CHili ASP engine on the RaQ will only allow a single file to be uploaded at a time and the VBScript used on the upload page prohibits the use of any other Response or Request handlers.

The method describes here allows a user to upload a chosen file to a folder location on the RaQ server. Ideally the file name should be changed from the browsed fileName to something shorter. It can then be accessed using a database call from the MySQL database whenever it needs to be displayed.


INSERT, UPDATE & DELETE records in multiple tables.

Using Dreamweaver's standard insert, update, and delete server behaviours you can't modify records in multiple database tables using input from a single form. This article shows how to use the Command behaviour which enables you to do this. This is essential if you need to modify records in separate database tables and maintain relationships between them.

PHP and Dreamweaver MX Continued

In this tutorial we will cover the following:

  • Creating Recordsets
  • Displaying Data
  • Creating New Records
  • Deleting Records
  • Editing and Updating Records
  • Page Scraping

    This Tutorial will walk you through the process of Page Scraping.

    What is Page Scraping, the legalities and ethics and an example of Page Scraping with a PHP Script.

    Setting up an OLE DB connection to a SQL Server database

    OLE DB not only offers a performance benefit over ODBC connections (DSN) but also has some increased functionality. This article shows how to set up an OLE DB connection to a SQL Server database.

    Retrieve record identity from an autonumber field on record insert.
    In order to maintain the relationships between database tables or to return the identity of the record they have just created to the user it is necessary to determine the identity of the newly created record. There are many bad examples of how to do this, mainly involving the use of SQL and SELECT MAX(RecordID) to determine the highest record identity value. This article shows a more reliable way to determine the correct identity of the record created.
    Using the ActivEdit Server Behavior

    The ActivEdit extension is bundled with the trial version of ActivEdit 3.0. This Dreamweaver MX server behavior enables you to easily embed the ActivEdit editor into an HTML form. It is also compatible with Dreamweaver's standard server behaviors, including Insert Record and Update Record.

    ActivEdit Features

    • Intuitive, Microsoft Word-style content management
    • Edit documents in Normal or HTML mode
    • Browse and insert images
    • Preview and upload images
    • Java applet offers Netscape 6+ and Mozilla support
    • Apply CSS styles using a drop-down menu
    • Full-featured image, table, and font inspectors
    • Optional spell-checking module (ActivSpell)
    • Optional scanner module (ActivScan)
    • And much more...

    Extension Features

    Get it now >>

    Print-Ready Version
    A question that I am asked quite often by other developers creating dynamic news/article content is, "How do sites like CNET and others achive the 'Print Version' that gets rid of images, banners, etc." The process is actually very simple, and uses a server behavior that comes standard with Dreamweaver UD/MX.
    Newer articles Older articles