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.
    PHP and MySQL in Dreamweaver MX

    This tutorial will walk you through the following:

  •  Installing MySQL
  •  Set up of phpMyAdmin
  •  Creating your database
  •  Connecting to database
  • Date and Time functions 101

    A short reference document to some of the Date / Time functions in SQL Server.

    Choose The Right Programming Language

    Many webdesigners have discovered that Dreamweaver now gives them the power to develop cool webapplications. In this way you can cross the border between graphical design and web application developers. We have seen a lot more basic starter questions in the Talkzones reflecting the will of many designers to explore these exciting possibilities. Questions like: "I want to build an E Commerce site for a client. Can anyone write a tutorial on how to get started with ASP and MS Access?"

    Let's start with the real basic questions first. Like what programming language are you going to use? This is a major decision to make. When i got started developing as a former webdesigner a few years ago, it took me a long time to figure out.

    Connecting Dreamweaver to MySQL & Chilisoft ASP
    A short tutorial on connecting to a MySQL database using Sun/Chilisoft ASP and Dreamweaver MX (or Ultradev 4). 
    Newer articles Older articles