Query regarding mySQL database

Category: azure database for mysql

Question

Pranjal Bhatia on Fri, 21 Dec 2018 07:56:48


I am using Azure SQL Database to log data from arduino. I am fairly new to SQL and i am using azure to log data into mysql database created on azure. I have created the website, server and a blank database. As per this link : https://docs.microsoft.com/en-us/azure/mysql/connect-php

I have created all these .php files and uploaded them to the root directory of the website and it should log data even with a blank database, right? because if i am not wrong these will create the tables required for logging data?

Also should I go for a blank database or Adventurework Sample?

Replies

Mike Ubezzi (Azure) on Fri, 21 Dec 2018 17:33:03


Hi Pranjal,

The .php files detailed in the below tutorial are intended to be run from your localhost, likely from an on-premise laptop/workstation or from an Azure VM that has the PHP runtime installed. The tutorial is not written in such a way that the .php is embedded in a  PHP website. This is not saying that is cannot be done. The .php examples are to be run manually from a PHP runtime environment from your laptop/workstation, over an internet connection. Additionally, you will need to set a firewall rule to allow traffic from the IP address your are attempting to connect from.

Azure Database for MySQL: Use PHP to connect and query data

Please let us know if you have additional questions.

Regards,

Mike