Pizza Delivery Tutorial
Jump to navigation
Jump to search
Create the Database
This is usually done in any MySQL client like phpMyAdmin (nudb) before installing NuBuilder4 and may already have been done if a login was attempted before.
CREATE DATABASE IF NOT EXISTS nubuilder4 CHARACTER SET utf8 COLLATE utf8_unicode_ci;
Install system tables
- nuBuilder4 Web Login with default user / pass: globeadmin / nu
- On first login, the system tables get populated from nubuilder4.sql.
Install Tutorial tables and data
- Navigate to Builders => Database => Import => Pizza.sql.zip
- Close phpMyAdmin tab and return to Builders tab in nuBuilder4
Create Fast Forms for each tutorial table
customer
- Navigate to Builders => Fast Form
| Parameter | Value |
|---|---|
| Form Type | Browse and Edit |
| Table Name | customer |
| Add Objects | Input:Text, TextArea, Input:Text, TextArea |
| Edit Labels | Customer, Address, Phone, Notes |
| Use Arrow keys to set Field Name | cus_name, cus_address, cus_phone, cus_notes |
| Browse Column: Tick first 3 only |
- Click the "Build Fast Form" button at the top left corner