USING PHPMYADMIN LOCALHOST TO READ DATA FROM WINCC ADVANCED_TIAPORTAL
.Contact: [email protected] .Phone: +84984412394 .Require Softwares: - XAMPP 8.1.25 / PHP 8.1.25 https://www.apachefriends.org/download.html - Tiaportal and WinCC Advanced (version 15 or more) - Connector/ODBC 9.0.0 version for x64bit or https://dev.mysql.com/downloads/connector/odbc.html - Connector/ODBC 8.0.37 version for x86 32bit - Composer Using to setup export to file.xlsx function Composer (getcomposer.org) Note: Check folder Wincc Advanced was installed in C:\Program Files (64bit) or C:\Program Files (x86-32bit) to install compatible Connector/ODBC
.Target: SEND Value Type: INT from Wincc Advanced to DataBase MySQL in phpMyAdmin;
.STEP BY STEP: 1. Open XAMPP to setup a localhost
Start Apache port 80, 443
. Start MySQL . Access: localhost/phpmyAdmin/ - by your Browser
. Default IP: 127.0.0.1 - you can change IP at C:\Windows\System32\drivers\etc\hosts
. Create a Database name: wincc_database . Create a table name: sensor_table - has 04 columns (value 1, value 2, value 3, value 4 / type Double)
value 1, 2, 3, 4 is the values you want to read from Wincc Advanced.
2. Run as Administrator ODBC Data Source 32 Bit .My Wincc Advanced was installed in C:\Program Files (x86-32bit) > Install Connector/ODBC 8.0.37 version for x32 bit. .Create a New Data Source (in User DNS or System DNS) > Add Choose MySQL ODBC 8.0 Unicode Driver
Data Source Name: WinccAdvance_MySQL
TCP/IP: 127.0.0.1 Port:3306 <IP of localhost phpmyAdmin> User: root Database: wincc_database <which is created in MySQL phpmyAdmin>
3. Make connection between WinCC Advanced & MySQl phpmyAdmin
Open Tiaportal -> Create a new project -> Add new HMI Wincc Advanced. - In PLC program, create a Datablock have 4 value. Set Attributes is none Optimized Block Access Attributes is none Optimized Block Access In Wincc Advande tag, create HMI_tag connect to value_tag in PLC Datablock
- Open Vbscipt, create 02 VB function
. Open_localhost : open a phpAdmin web with address: localhost/phpMyAdmin . Send_Value_MySQL : connect with MySQL in phpmyAdmin and send value to Wincc_database > sensor_table In this sample, I will send 04 value from Hmi_tag to MySQL
- Open Screen .Use a Open_localhost button to run VBscript Open_localhost function .Use a Export_Data button to run VBscript Send_Value_MySQL function - Run Wincc Advanced .Online PLC and change the value of tag in DATA_MYSQL .Click Export_Data button to send data .Click Open_localhost to open phpAdmin website .Check the result in phpAdmin>wincc_database>sensor_table
*NOTE: Source code in attached files!! Or you can download at link:
