MySQL Database Pro Extension

Using this extension you can manage your MySQL database from your app. This extension has provide you multiple options to manage your MySQL database.

1. Create table and multiple columns with your preferred data types.
2. Add more column in existing table.
3. Remove any specific column from your existing table.
4. Create and update your rows in columns.
5. Create and update multiple rows from list data.
6. Delete any specific rows from your column.
7. Get any rows from your table by column name and value.
8. Get conditions rows from your table by compare the columns and values.
9. Get filter rows from your table by column name and some of list values.
10. Get like rows from your table by column name and value pattern.
11. Get All rows by column names with filter column and value or get like column and value or get order by column name.
12. Load json list data from url and create mysql table.

Update Vesion 1.3

1. Get COUNT, SUM, AVG values from your table.

Update Version 1.6

1. ID options is now added in all blocks.
2. You can create your custom list of conditions and list of order by columns.
3. Now Added synchronize method to handle multiple request at the time and get response one by one.

Update Version 1.8

1. Get All Rows and Get Condition Rows with Limited row count.

Before using this extension, You need to upload a PHP script to your hosting server. You can download your php-server.zip file from the demo aia file project assets. after downloading, you can remove this file from your project.

Note : When you download latest version of extension then you need to update also your php server files.

After unzipping this file you will get 3 php files. make sure that you don’t need to change any code of server.php and function.php if you do any changes then maybe your will got errors on your apps. only you need to change in the config.php file some default values like your – apiKey, serverName, username, password and database.

config.php file setup :

Setup your Server Url and Api key in your project :

Note : For security reasons make sure that your API Key is secure. set API key in your project on your risk. otherwise maybe it will expose. by the way, i am making a different extension to solve this issue that is API Key Protection. This extension can protect your api key in your app.

Create multiple types of columns in your project like :

1. Text : You can store Text values in rows by using this column type.
2. INT : You can store Number values in rows by using this column type.
3. INT_Primary : Using INT primary column data type you can store number value in row but you cannot add duplicate values rows in this column.
4. BIGINT_Primary : Using BIGINT primary column data type you can store large number value in row but you cannot add duplicate value rows in this column.
5. VARCHARE : Using this column type you can store limited length of any text or number value.
6. VARCHARE_Primary : Using this column type you can store limited length of any text or number value but you cannot add duplicate value rows in this column.

Make your columns as a list :

Create table with your columns.

Create Table with ID auto increment.

Add more columns in existing table.

Remove column from your table.

Create rows in your columns.

For update rows you can use the same create row blocks. Just you need to set true in update and make sure that in your table have primary column otherwise it will create every time new rows.

Create multiple rows in your columns.

Delete rows from your columns.

Get rows from your columns.

Create condition for get rows. by using this method you can check types of input values is exist or not in columns.

Using AND , OR and NOT logic you can make your condition to check rows. Example :

columnEmail = [email protected] AND columnPassword = 12345

Get conditions rows from your columns.

Get In Filter rows from columns. You can filter some list of values is exist or not in columns.

Get Not In Filter Rows from columns.

Get like rows by colum and value. Example :

‘a%‘ = Finds any values that start with ‘a’
‘%a‘ = Finds any values that end with ‘a’
‘%or%‘ = Finds any values that have ‘or’ in any position
‘r%‘ = Finds any values that have ‘r’ in the second position ‘a%’ = Finds any values that start with ‘a’ and are at least 2 characters in length
‘a__%‘ = Finds any values that start with ‘a’ and are at least 3 characters in length
‘a%o‘ = Finds any values that start with ‘a’ and ends with ‘o’

Types of Get All Rows Methods.

On Get All Rows you can get json list of items and using load json list block you can get items one by one.

Using this blocks you can get COUNT, SUM, AVG value from your table.

Using this blocks you can load your json list data from url and save into your mysql database. Make sure that your json list like this example :

When you got any error then you can see the reason on this block.