Create Web Forms & Web Applications
Tutorial
Blog
Tips
News
OfficePhp is an open source software
for creating web
forms and web applications. It can be used with
open source web editors like FckEditor or other mainstream editors like
MS Frontpage, Dreamweaver,
NVU, ExpressionWeb or Kompozer.
With Officephp, you can easily create web forms using the editors simple interface without having to see the raw html codes.
Once finished designing the forms, Officephp will automatically create all relevant fields hence there is no need to learn any Php or Mysql commands.
When user enter data in the form and click the submit button, the data will be recorded in a mysql database. There are ready made php pages to let you see the records, search relevant data and then Save the records as html file or CSV file for exporting to spreadsheet program like MS Excel or OpenOffice Calc.
Officephp is not only for creating and processing web forms, it actually can be extended to become a web application.
Some example of Officephp use:-
- Create Web Forms
- Feedback Form / Mail to Us Form
- Contact List Manager, Mail Merge with MS Word
- Minisite, Blog Website, Forum Website
- Poll Module, Helpdesk Module
- Any web applications you can think of..
From a programmer's point of view, customizing Officephp is easy. This is because Officephp code is included with the download. Hence you can edit the codes to suit your particular needs. In addition, Officephp use procedural style of programming as opposed to OOP programming hence the learning curve is much easier.
Tutorial
| 1. | Install XAMPP on Windows XP - 13/Aug/08 Xampp is an advance open source stack (compilation) which comprised of Apache, Php, Mysql, Phpmyadmin and a few other softwares that will not be covered in this article (e.g. FTP & Mail server). Download and install the software from Xampp homepage. If you are confused which xampp flavour to download, choose.. |
| 2. | Basic CSS for Web Forms - 9/Aug/08 Today we will learn another jargon which is Cascading Style Sheet, CSS. CSS tried to solve the problem of having to format every web pages manually. For example, if you have a mini website with 15 html web pages, you have to do "select all" and choose the font and the.. |
| 3. | Basic Php for Web Forms - 7/Aug/08 If you have learnt any programming language before, you already have the concept of coding-testing-debugging cycle. I have to emphasize that officephp is based on Procedural style of programming (rather than Object Oriented Programming, OOP). While OOP languange like Java get serious endorsement by universities & companies, I found out that.. |
| 4. | Basic HTML for Web Forms - 6/Aug/08 HTML tags used to be straightforward. However, since the introduction of various new features, the simple tags have becoming complex, in order to comply with various international standards. In this basic tutorial, I will use the simplest html codes that has been proven to work for over 16 years. Here they.. |
| 5. | Create Web Applications and Reports - 5/Aug/08 This online tutorial will be divided into the following. The first version of this tutorial will be completed by 31 Oct 2008. Table of Contents Create Your First Web Form Installing Apache, Mysql & Php in Windows Download Officephp Creating your first form Filling in the form Viewing Records Entered by.. |
Blog
| 1. | Frontpage 2007 and Possible Alternatives - 19/Aug/08 I am a big fan of Microsoft Frontpage 2007. But the truth is.. it doesn't exist! The last Frontpage version is MS Frontpage 2003. For 2007 version, it has since been replaced by Microsoft Expression Web and Sharepoint Designer, which were released in December 2006. Microsoft Expression Web This is part.. |
| 2. | XAMPP Php and Mysql versions - 13/Aug/08 This page is for keeping track of older Xampp releases, with notes on the versions of Php, Mysql, Apache and Phpmyadmin. The truth is, for a local webserver behind a NAT firewall, there is no need to upgrade Xampp server to the latest release. If it works smoothly, why would we.. |
| 3. | I still Prefer Firefox 2.0 - Download Here - 13/Aug/08 Sometimes a software is good enough we don't need a newer version. Just security updates whenever needed. As for now, I still prefer Firefox 2 over 3. However, to find the download page for Firefox 2 is getting more difficult nowadays. Hence here is direct link to the trusted, reliable &.. |
| 4. | The Characteristics of a Good Web Application Php Framework - 11/Aug/08 I have been searching for the ultimate php application framework for at least a decade! I am primarily a businessman. I use php to solve my business problem and I want php to be my slave, not vice versa. That is why I prefer traditional php programming over OOP. After 10.. |
| 5. | Start Windows 98 (without Login Prompt) in VMWare Player - 25/Jun/08 You might be wondering why on earth Win 98! Well, today I played with VMWare Player for Windows version 2! This version is much better than version 1 in term of speed. (Version 2 also support Vista as the host Operating System) What is VMWare Player/Server? In a nutshell, it allows.. |
| 6. | Download Win Xp Service Pack 3 from Microsoft Website - 11/Jun/08 (Download link from Microsoft below) It is kind of weird! I tried searching in Google and Windows Live on the word Download Win XP Service Pack 3 but there is no link to the download page. The only link I got was the pdf and docx file (docx is MS Word.. |
| 7. | Windows XP Home & Pro End of Lifecycle Policy - 11/Jun/08 Like most users, I don't like Vista. Hence I will be watching closely the end of lifecycle of Win XP. Here is the simplified table. Desktop Operating Systems Date of General Availability Direct OEM and Retail License Availability (end date) System Builder License Availability (end date) MS DOS 6.xx Jun 01,.. |
| 8. | Hostgator Php and Mysql Versions - 7/Jun/08 I have been using several webhosting providers in the last 10 years. It used to be simple because all webhostings were using Php4 and Mysql4. But nowadays there are countless combination of several versions. For example Php 4 & Mysql 5, 5 & 5, 4 & 5 etc. Hence I need.. |
Tips
| 1. | How to Prevent Direct Access to Php Component Pages - 24/Aug/08 In my web applications, I usually have a main page and many directory modules with hundreds of other php files. Sometimes, there are php files that are not meant to be access directly by the public, by typing via URL. They are part of an include() or require() from other pages... |
| 2. | GET vs POST - How to send Data to the Server - 18/Aug/08 There are 2 ways to send data to servers with php, using GET or POST method. Sending data with GET Data will be sent via the URL. e.g. http://www.yoursite.com?ID=234&TODO=edit In this sample the variables ID and TODO are sent using the GET method If you are using a form, all variables.. |
| 3. | Install Apache, Mysql and Php on Windows Easily With 1 Click - 17/Jul/08 Today I searched google for a guide to install Apache, Mysql and Php Server (AMP Server) in Windows XP (or any flavors). To my surprised, there are still guides that teach us to download apache, mysql and php separately and hack them to work together in a server. That was soo.. |
| 4. | Develop Web Apps Locally & Upload to Webhosting Server only When It Is Ready - 16/Jun/08 In a conversation with a fellow Web Programmer, she told me how frustating working in her company is. The reason was the internet connection to her company's server is painfully slow! I asked her how did the IT dept develop web application and she answered by connecting thru the internet to.. |
| 5. | Prevent Sql Injection Poison in Your Php/Mysql Apps - 10/Jun/08 Sql Injection is bad. In theory, it could destroy (drop) your database with a clever injection phrase. If you have never heard of SQL injection before, let me try to summarise in a few sentences. SQL Poison is where the web user write extra sql command in the query string part.. |
| 6. | Creating Unique ID for Database Records - 10/Jun/08 When I first programming back in 1998, I do not have to think twice on what to use as the ID/Primary Key. I used the auto increment number. Method 1. Use the autoincrement column Auto increment is an automatic mysql column where the number will be incremented by 1 everytime you.. |
| 7. | How to Put the Cursor (focus) in a Form Field Automatically - 9/Jun/08 This tips is about placing the cursor automatically in a form field when you load a webpage. For example in Google homepage, the blinking cursor is automatically placed in the search field, hence whenever we start typing, the words goes straight into the search box without the need to point and.. |
News
| 1. | Officephp 1.1 Released - 16/May/08 Version 1.1 is released today after fixing some serious session bugs in the prev version. It is currently being use to develop projects below. Majalah.com Franchise Walk Hunt 2008 (Malaysian Franchise Association) KOGURU (Co-operation - internal apps) Kuatagh.net (Alumni) And a few more.. A few more testing is done especially on.. |
| 2. | OfficePhp 1.0 Released - 1/Dec/07 OfficePhp 1.0 was released in Dec 2007, after 10 years under development. It was first used in Malaysian Franchise Association (MFA) internal website to record visitors who attend the Franchise Walk Hunt 2007. There are over 1000 participants and MFA needs a software to help them during the registration and confirmation.. |
| 3. | The Long Standing Problem of Web Application Development - 12/May/07 Officephp is not just a software for creating and processing forms. It is actually a full blown php framework! When I first developed Web apps in 1999, I thought this was easy. It turned out to be deceivingly easy! Developing a web apps is only easy if you and only you.. |