Pizza Delivery Tutorial

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 Home => 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 Home => 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
• Screenshot
• Navigate to Home => Setup => Forms
• Click on the record having Table customer with Code FF0
• Replace field Code with CUS and Description with Customer and click Save button.
• Navigate to Home => User Home => Customer => Add
• Click the Form Settings (three vertical dots) button and select Arrange Objects