Pizza Delivery Tutorial: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Create the Database == This is usually done in any MySQL client like <tt>phpMyAdmin (nudb)</tt> before installing NuBuilder4 and may already have been done if a login was a...") |
|||
| Line 16: | Line 16: | ||
=== customer === | === customer === | ||
* Navigate to '''Builders => Fast Form''' | |||
{| "class="wikitable" | |||
!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 | |||
=== product === | === product === | ||
Revision as of 18:27, 4 January 2021
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