Website powered by
Maylene Drew Ferrin
Swamp Girl
Gallery
Resume

LiveInk User Input Form (Unity, C#, PHP/PDO, SQL, MS Access)

In this project, I wireframed an interactive "fillable" form for customers at fairs and events to submit their name, phone number, and three (3) icons that they would like to see printed on a hat. To create this end result, I:
• Integrated Unity/C# with PHP Data Objects (PDO) on the backend, to send user data to a Microsoft Access database, either in .ACCDB or .MDB format
• Connected Unity/C# with PHP/MySQLi on the backend, to send user data to a MySQL database
• Developed the UI/UX for the form, iterating from a Figma prototype to a responsive 2D frontend in Unity
Take a look at the Figma mockup here: https://www.artstation.com/artwork/8bGnnm
Take a look at the evolution of the UI colors and themes here: https://www.artstation.com/artwork/n0Xe8e

* The icons (smiley face, rainbow, and heart) emphatically do not belong to me, nor did I create them. Instead, I downloaded them from the following sources under the listed licenses:
Smiley: "Tango face wink" by Warszawianka (CC0 1.0 Universal)
Rainbow: "Ostadarra arcoiris rainbow" by Silbiadinamitic (CC0 1.0 Universal)
Heart: "Plain Red Heart Shape" by GR8DAN (CC0 1.0 Universal)

Quick video demonstration of the form sending user data to an MS Access database

Unity wireframe with glossy UI

Unity wireframe with glossy UI

Unity wireframe with button icons

Unity wireframe with button icons

After clicking "Submit", the user's name, email, and phone number are automatically cleared from the form to protect the user's privacy. Meanwhile, the Unity backend outputs message "SUCCESS: Inserted new userdata"

After clicking "Submit", the user's name, email, and phone number are automatically cleared from the form to protect the user's privacy.
Meanwhile, the Unity backend outputs message "SUCCESS: Inserted new userdata"

Microsoft Access database: The data that the user has just submitted is automatically sent to the Microsoft Access database, populating the correct fields with the user's data. This is accomplished via PHP Data Objects, or PDO, on the backend.

Microsoft Access database:

The data that the user has just submitted is automatically sent to the Microsoft Access database, populating the correct fields with the user's data. This is accomplished via PHP Data Objects, or PDO, on the backend.

Before even beginning the programming side of development in Unity, C#, PHP/PDO, SQL, and Access, I began with a UI design in Figma.

Before even beginning the programming side of development in Unity, C#, PHP/PDO, SQL, and Access, I began with a UI design in Figma.

Report