📓
Mysql for Game Creator 1
  • Mysq for GC1 Documentation
  • Mysql for Game Creator
    • Getting started
    • Setup and usage
      • Mysql Actions
        • Action Use WebGl
        • Action Mysql Connect
        • Action Mysql Close Connection
        • Action Mysql Insert
        • Action Mysql Update
        • Action Mysql Select
        • Action Mysql Delete
        • Action Mysql Clear Table
        • Action Mysql Select To UI
        • Action Mysql Query
      • Other Actions
        • Action Text to Variable
        • Action Encrypt and Decrypt data
        • Action Generate random string
        • Action Check Internet Connection
        • Action Base64 Image to UI Image
      • Condition If Connected To Internet
      • "Life Hacks"
        • Update +1
        • WebGL Action
        • Working with Variables
    • FAQ
    • Roadmap
Powered by GitBook
On this page
  • Example:
  • Full story for this example is here:

Was this helpful?

  1. Mysql for Game Creator
  2. Setup and usage
  3. Mysql Actions

Action Mysql Select To UI

PreviousAction Mysql Clear TableNextAction Mysql Query

Last updated 4 years ago

Was this helpful?

This action is for data string generation. You define every column you want to select and store it to one Global or Local variable.

Next step is to use Action Parse String To UI.

Define Data String, select Parent Object, for example, Panel object for this data to be shown, set Header text color and opacity to 1 and text size, fill in all columns data. Header prefab - prefab where header text will be shown, header text - text object with some text for header, datatype - choose text or image. If image - it must be stored to database in base64:

Example:

Your image code: data:image/jpeg;base64,/9j/4SNqRXhpZgAATU0AKgAAAAgADAEAAAMAAAABA

You need to delete: data:image/jpeg;base64,

So your string must be like: /9j/4SNqRXhpZgAATU0AKgAAAAgADAEAAAMAAAABA

Now make keyDown trigger to activate this action and show Panel. You will see "Table like" data in your canvas.

Full story for this example is here: