MENU
MySQL Reports

Products

Smart PHP Form Builder for MySQL and MariaDB

Smart Form Maker is a powerful yet easy-to-use PHP Form Builder that generates dynamic AJAX-based forms for MySQL and MariaDB databases without writing PHP, SQL, or JavaScript. Using a simple step-by-step wizard that expands on the familiar Microsoft Access form-building experience, you can quickly create everything from single-record and multi-record forms to editable grids and sophisticated master-detail forms with one or more related detail sections. While the wizard intelligently maps your database columns to suitable form controls, you're never locked into the defaults—you can easily customize each field using a variety of input and display options, giving both beginners and advanced users the flexibility to build professional database forms in minutes. Explore Form Types Supported in SFM 4.0.

Example Forms Generated by Smart Form Maker

The following examples showcase the form-building capabilities of Smart Form Maker. All forms are generated from existing MySQL databases across a variety of business industries.

Clothing store PHP MySQL forms demo built with Smart Form Maker

Clothing Store

Form Examples
Vehicle fleet PHP MySQL forms demo built with Smart Form Maker

Vehicle Fleet

Form Examples
Pet clinic PHP MySQL forms demo built with Smart Form Maker

Pet Clinic

Form Examples

Create a Demo Database Form

Key Features of Smart Form Maker

Familiar Wizard Inspired by Microsoft Access

Create and manage unlimited dynamic PHP forms from your MySQL database using an intuitive wizard-style interface inspired by the familiar Microsoft Access Form Wizard. If you've used Microsoft Access before, you'll feel right at home, while new users can quickly become productive thanks to the guided step-by-step experience. Get up and running in minutes with virtually no learning curve or setup hassles.

Flexible Form Types

Extensive Form Types for Every Data Entry Scenario. Whether you need a single-record form with a columnar layout, a tabular form for viewing and updating multiple records, a layout that highlights a primary image, a mobile-friendly form, or sophisticated master-detail forms with one or multiple related detail sections, Smart Form Maker provides a wide range of form types to match your data and workflow. Explore Form Types Supported in SFM 4.0.

Advanced Master-Detail Form Support New feature

Advanced Master-Detail Forms for Complex Data Relationships. Create master-detail forms with one or multiple related detail sections. Whether you need to display a Product with its Orders, or a complete record with Variants, Orders, Stock, Returns, and other related tables in a single form, Smart Form Maker supports it.

Flexible Database-to-Field Mapping New feature

Smart Field Mapping with Complete Control. Smart Form Maker intelligently maps database columns to the most appropriate form controls based on their data types, giving you a great starting point automatically. However, you're never limited to the default mapping. Every column can be customized to use the field type that best fits your application—for example, a VARCHAR column can be displayed as a text box, a custom drop-down list, a searchable list of countries or U.S. states, a file uploader, and many other input controls. This flexibility lets you design forms that match your data entry workflow, not just your database schema.

Secure File Uploads New feature

Easily map database columns that store file names or file data to powerful file upload controls. Files can be stored either in your preferred folder structure or directly inside your database, giving you complete flexibility over how your application manages uploaded content. You also control how files are presented within your forms—as thumbnails, primary images, downloadable file links, or other display styles that best fit your application. Built-in validation lets you define allowed file types, file size limits, and other upload rules, while client-side validation provides immediate feedback before files are uploaded, improving both security and the overall user experience.

Customize Form Actions

Customizable Form Actions for Every Workflow. Control exactly how users interact with your forms by enabling or disabling individual actions such as Insert, Update, Delete, and Search. Whether you need an insert-only form, a read-only view, or a complete CRUD management form, Smart Form Maker adapts to your requirements. All form actions are performed using AJAX, delivering a fast, responsive, and seamless user experience without full page reloads.

Editable Grids & Bulk Record Updates

Process Multiple Records with Editable Grids. Streamline data entry and record management using powerful editable grids in both tabular forms and master-detail forms. Edit, insert, and update multiple database records simultaneously, making bulk operations fast, efficient, and user-friendly. Even records containing file upload fields are fully supported, allowing users to upload and manage multiple files in a single operation.

Advanced Data Validation Rules

Smart Form Maker goes beyond intelligent database column mapping by giving you complete control over every form field. Easily define lookup values for foreign keys, customize field labels, configure validation rules that match each column's data type, and display your own custom validation messages. The result is professional, user-friendly forms that are tailored to your application's data and business requirements.

Custom Confirmation Pages & Smart Alerts New feature

Smart Form Maker lets you optionally display a confirmation page before a form is finally submitted, allowing users to review all entered or modified information and make changes if needed. The confirmation page can also be printed as a receipt for their records. In addition, you can configure custom email alerts to be sent automatically whenever selected form actions are performed, keeping users or administrators informed of important events.

Try Smart Form Maker Demo Version

Benefits of Smart Form Maker

Zero-Code Form Generation

Create dynamic, AJAX-based database forms with just a few mouse clicks. You can manage, insert, update, search, and delete records from your MySQL or MariaDB databases without writing a single line of PHP, SQL, or JavaScript code.

Save Development Time and Effort

Eliminate setup hassles and drastically reduce coding time. The wizard-style interface automatically translates database columns into functional form elements (like turning DATE fields into calendars and ENUM fields into drop-down lists), handles foreign keys automatically, and applies instant validation rules based on your data types.

Versatile Form Architecture

Build a wide variety of layouts tailored to your exact workflow needs. Whether you need standard columnar forms, master-detail sub-forms for complex data relationships, justified layouts, or editable grids for fast, bulk record processing, the system handles it out of the box.

Modern, Secure, and Responsive User Experience

Deliver high-performance forms that utilize AJAX technology to submit data instantly without refreshing the page. All generated forms are inherently mobile-friendly, password-protected for security, and highly customizable with multiple built-in themes, data filters, and custom headers/footers.

Cost-Effective and Scalable Licensing

Maximize your investment with a highly flexible deployment model. A single license allows you to install the software on up to five separate domains, making it highly economical for developers managing multiple projects.

Risk-Free Support and Resources

Get up and running quickly with zero friction. Benefit from extensive learning resources including video tutorials, a comprehensive user manual, and free, dedicated support to help you troubleshoot whenever needed.

System Requirements of Smart Form Maker

  • Any web server
  • PHP version 5 or higher
  • Any version of MySQL or MariaDB

Frequently Asked Questions

A: Pick the form type that matches how your data needs to be viewed and edited:

  • Need to view or edit many records at once? Choose a Tabular form for spreadsheet-like viewing, quick searching, bulk editing, and processing multiple records simultaneously.
  • Working with records that contain many fields? Use a Columnar or Justified form to display one record at a time in a clean, easy-to-read layout that's ideal for data entry and editing.
  • Need to emphasize a product, employee, or equipment image? Select one of the Image Right form types to give the primary image greater visual prominence while keeping related information organized.
  • Need to display a parent record with its related records? Use a Master–Detail form to show a parent record (such as a Customer or Order) together with its related child records (such as Orders or Order Lines).
  • Need to display several different related tables together? Choose a Tabbed Master–Detail form to organize multiple related datasets—such as Orders, Returns, Payments, and Notes—into separate tabs within the same form.
  • Need to browse many parent records, each with expandable details? Use a Collapsible Master–Detail form where multiple parent records are listed together, and each record can be individually expanded or collapsed to reveal its related details.
  • Building forms primarily for phones or tablets? Choose a Mobile form for a touch-friendly, responsive layout optimized for smaller screens.

Explore Form Types Supported in SFM 4.0 to see what each layout looks like and the use cases it suits best.

You can explore all of these features yourself by trying the fully functional online demo: https://sfmtrial.mysqlreports.com/SFM/login.php

A: Yes. Open the SFM home page, find the form in the list, and click the Edit (pencil) button. The wizard reopens with all of that form's settings already filled in, so you can choose a different form type and save.

A: Mapping is the decision of how each database column is presented to the user. A VARCHAR column could be a plain text box, an email field, a URL, a phone number, a dropdown list, or a file uploader. A TINYINT(1) could be a checkbox or a toggle. A DATE could be a date picker. The wizard proposes a sensible default for every column based on its database type, and you can change it.

A: Smart Form Maker automatically maps your database columns to appropriate form controls based on their data types, allowing you to generate a fully functional form in seconds. Each data type has a default mapping that is selected automatically, but many types also support multiple alternative mappings so you can choose the one that best matches your application's requirements and user experience.

Below are the supported mapping options by data type:

Textual data types (VARCHAR, CHAR, etc.)

  • Text Box – Standard single-line text entry.
  • Email, Phone, and URL fields – Built-in validation for common data types.
  • Color Picker – Let users choose colors visually instead of entering color codes.
  • Foreign Key Dropdown – Display values from a related table instead of numeric IDs.
  • User-Defined Dropdown List – Create your own custom list of selectable values.
  • Built-in Lists – Instantly use predefined lists such as Countries, U.S. States, Weekdays, or Yes/No values without creating lookup tables.
  • File Upload to Disk – Store uploaded files in the file system while saving only the file name or path in your database. You can also control allowed file types, file size limits, storage location, and how uploaded files are displayed (thumbnail, download link, or icon).

ENUM and SET data types

  • Automatically use the values already defined in your database.
  • Display them as:
    • Dropdown lists
    • Radio buttons
    • Multi-select lists
    • Checkboxes
  • No need to manually recreate the list options.

Numeric data types (INT, DECIMAL, FLOAT, etc.)

  • Numeric Text Box – Accept only numeric input.
  • Standard Text Box – When free-form entry is preferred.
  • Range Slider – Allow users to select a value within a configurable minimum and maximum range.
  • Foreign Key Dropdown – Ideal when the numeric column represents a relationship to another table.

Date and Time data types

  • Calendar picker for dates.
  • Date and time picker for DATETIME fields.
  • Time picker for TIME fields.
  • Makes entering valid dates and times fast and error-free.

File and BLOB data types

  • Store files inside the database using BLOB columns.
  • Store files on disk while saving only the file name or path in the database.
  • Both approaches support upload restrictions and configurable display options such as image thumbnails or download links.

Boolean and BIT data types

  • Checkbox
  • Modern on/off switch
  • True/False radio buttons

Select the style that best fits your application's interface.

A: Yes. Smart Form Maker supports master-detail forms with multiple related detail sections in the same form. Using the Tabbed Master–Detail and Tabbed Master–Detail with Image Right form types, each related table is displayed in its own tab beneath the master record. For example, a Customer form can display the customer's Orders, Returns, and Invoices together in a single form, with each detail section having its own title, selected columns, and field mappings. This provides a complete view of all related information without leaving the form.

A: Yes. Mapping is per form. You can have a read-only tabular report of a table and a full editing form on the same table, each with its own mappings.

A: Yes. Smart Form Maker supports a wide variety of list and lookup controls, allowing you to choose the most appropriate source for each field:

  • Custom Lists – Define your own list of values directly while designing the form, without requiring a separate database table.
  • Built-In Lists – Instantly use predefined lists such as Countries, U.S. States, Week Days, and many others.
  • Database-Driven Lists – Automatically generate lists from database column types such as ENUM and SET.
  • Foreign Key Lookups – Display meaningful values from related tables instead of IDs, making forms more intuitive and user-friendly.

This flexibility allows every field to use the most appropriate list type, resulting in forms that are easier to use and better suited to your application's data.

A: Changing a mapping changes how a column is displayed and validated, not what is stored. That said, some changes have practical consequences. For example, switching a file column from "file on disk" to "file in database" changes what new values mean, and tightening allowed file types or validation rules can make existing values fail validation the next time that record is saved. Review existing data after a change like that.

A: On the SFM home page, each row in the form list has a Duplicate button (the stacked-files icon). Click it and the wizard opens preloaded with that form's settings, but with the form name cleared so you must supply a new one. When you finish, a brand new folder is created under forms/ and the original form is left untouched.

A: Common reasons:

  • Same table, different audience: one form with full permissions for staff, a read-only copy for others.
  • Trying a different form type or colour theme without risking the working form.
  • Using an existing form as a starting template for a similar table.

  • Edit reuses the same form name and folder. When you save, the existing form is rewritten in place.
  • Duplicate requires a new form name and creates an additional form. Nothing about the original changes.

A: No. The wizard only writes form code and configuration. Your database tables and their rows are never dropped or rewritten by generating, editing, duplicating, or deleting a form.

A: The Image Right form types (Columnar Image Right, Master–Detail with Image Right, Tabbed Master–Detail with Image Right) reserve a panel on the right side of the form for one prominent image per record—a product photo, a staff portrait, a scanned document. The column that fills that panel is the main image column.

A: Yes. Smart Form Maker is a pure PHP application. You simply upload it to your server and start using it immediately. No command-line usage, no complex setup, and no server configuration are required.

A: Yes, your license is valid for life for the specific version you purchased. To keep you updated, we provide:

  • Lifetime Access: Once purchased, you can use your specific version of Smart Report Maker indefinitely with no recurring subscription fees.
  • 6 Months Free Upgrades: Access to all new releases and patches.
  • Discounted Renewals: After 6 months, upgrade at 60% off or more.

A: No. Smart Form Maker is designed for both technical and non-technical users. You can build PHP Forms through a wizard-based interface without writing PHP, SQL, or JavaScript code.

A: Yes. Smart Form Maker is a PHP MySQL Form Builder that supports both MySQL and MariaDB, allowing you to generate dynamic MySQL Forms from your existing databases.

A: Yes. Smart Form Maker supports master-detail forms, allowing you to manage data from two related tables on the same page. For example, you can manage customers and their orders in a single PHP Form. You can also follow this step-by-step tutorial to learn how to build master-detail forms.

A: You can create columnar forms, editable grids, mobile forms, justified forms, and master-detail forms. All generated PHP Forms use AJAX submission for a smooth user experience. Explore Form Types Supported in SFM 4.0.

A: Yes. There are usually cross-product promotions between Smart Report Maker (SRM), Smart Form Maker (SFM), and Smart Report Engine (SRE). Currently, the discount is typically around 25%, but it may change over time. When purchasing any product, check the "We Also Recommend" section on the checkout page to see the latest discounts available on the other products.

Try Smart Form Maker Demo Version