Connecting a restaurant website with Microsoft Azure online server database [closed]
I'm building a website for an online delivery restaurant by using HTML, CSS, and JavaScript, and I want to connect the website with the Azure Data Studio. I'm almost done with the website and I already have the tables ready on Azure. I just wanted to make sure that if it is possible to connect them through node.js or any other way? I also seeking any other recommendation for the best way to connect them because I want to save data in the DB and keep retrieve it whenever the customer wants to see his previous orders.
Please let me know if I'm on the right path and if anyone has done anything similar to this before.
Updates:
I will have the following pages:
- The login screen for the: Owner, Employees in the restaurants, and users.
- Screen for the user to view food items and to place an order.
- Screen for the Kitchen to receive the orders and to process it.
- Screen for the delivery.
All these screens and their functions will be connected to a database where all the data will be saved and the user could view any previous orders for the past 90 days.
Below are the tables showing in the Azure Data Studio:
javascript
azure azure-sql-database asked Nov 12 '18 at 3:44
Maged
188
closed as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner Nov 14 '18 at 3:48
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
add a comment |
I'm building a website for an online delivery restaurant by using HTML, CSS, and JavaScript, and I want to connect the website with the Azure Data Studio. I'm almost done with the website and I already have the tables ready on Azure. I just wanted to make sure that if it is possible to connect them through node.js or any other way? I also seeking any other recommendation for the best way to connect them because I want to save data in the DB and keep retrieve it whenever the customer wants to see his previous orders.
Please let me know if I'm on the right path and if anyone has done anything similar to this before.
Updates:
I will have the following pages:
- The login screen for the: Owner, Employees in the restaurants, and users.
- Screen for the user to view food items and to place an order.
- Screen for the Kitchen to receive the orders and to process it.
- Screen for the delivery.
All these screens and their functions will be connected to a database where all the data will be saved and the user could view any previous orders for the past 90 days.
Below are the tables showing in the Azure Data Studio:
javascript
azure azure-sql-database asked Nov 12 '18 at 3:44
Maged
188
closed as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner Nov 14 '18 at 3:48
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14
add a comment |
I'm building a website for an online delivery restaurant by using HTML, CSS, and JavaScript, and I want to connect the website with the Azure Data Studio. I'm almost done with the website and I already have the tables ready on Azure. I just wanted to make sure that if it is possible to connect them through node.js or any other way? I also seeking any other recommendation for the best way to connect them because I want to save data in the DB and keep retrieve it whenever the customer wants to see his previous orders.
Please let me know if I'm on the right path and if anyone has done anything similar to this before.
Updates:
I will have the following pages:
- The login screen for the: Owner, Employees in the restaurants, and users.
- Screen for the user to view food items and to place an order.
- Screen for the Kitchen to receive the orders and to process it.
- Screen for the delivery.
All these screens and their functions will be connected to a database where all the data will be saved and the user could view any previous orders for the past 90 days.
Below are the tables showing in the Azure Data Studio:
javascript
azure azure-sql-database asked Nov 12 '18 at 3:44
Maged
188
I'm building a website for an online delivery restaurant by using HTML, CSS, and JavaScript, and I want to connect the website with the Azure Data Studio. I'm almost done with the website and I already have the tables ready on Azure. I just wanted to make sure that if it is possible to connect them through node.js or any other way? I also seeking any other recommendation for the best way to connect them because I want to save data in the DB and keep retrieve it whenever the customer wants to see his previous orders.
Please let me know if I'm on the right path and if anyone has done anything similar to this before.
Updates:
I will have the following pages:
- The login screen for the: Owner, Employees in the restaurants, and users.
- Screen for the user to view food items and to place an order.
- Screen for the Kitchen to receive the orders and to process it.
- Screen for the delivery.
All these screens and their functions will be connected to a database where all the data will be saved and the user could view any previous orders for the past 90 days.
Below are the tables showing in the Azure Data Studio:
javascript
azure azure-sql-database javascript
azure azure-sql-database asked Nov 12 '18 at 3:44
Maged
188
asked Nov 12 '18 at 3:44
Maged
188
edited Nov 13 '18 at 2:13
asked Nov 12 '18 at 3:44
Maged
188
asked Nov 12 '18 at 3:44
Maged
188
asked Nov 12 '18 at 3:44
Maged
188
188
closed as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner Nov 14 '18 at 3:48
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
closed as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner Nov 14 '18 at 3:48
Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14
add a comment |
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14
add a comment |
1 Answer
1
active
oldest
votes
Basically, first you need to create an Azure web app and need to deploy your existing node.js project on it. In your node.js app you need to create sql connection and use it to insert, update, delete or query the data from database. Follow the below tutorial to connect to database on Azure.
Create a Node.js web app in Azure
As I don't know which SQL DB you are using here are tutorial for common 3 DB on Azure:
1) If you are using Azure SQL database then,
Quickstart: Use Node.js to query an Azure SQL database
2) Or if you are using MySQL then refer this,
Azure Database for MySQL: Use Node.js to connect and query data
3) Or if you are using Azure CosmoDB SQL then refer this,
Tutorial: Build a Node.js web app using JavaScript SDK to manage Azure Cosmos DB SQL API data
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Basically, first you need to create an Azure web app and need to deploy your existing node.js project on it. In your node.js app you need to create sql connection and use it to insert, update, delete or query the data from database. Follow the below tutorial to connect to database on Azure.
Create a Node.js web app in Azure
As I don't know which SQL DB you are using here are tutorial for common 3 DB on Azure:
1) If you are using Azure SQL database then,
Quickstart: Use Node.js to query an Azure SQL database
2) Or if you are using MySQL then refer this,
Azure Database for MySQL: Use Node.js to connect and query data
3) Or if you are using Azure CosmoDB SQL then refer this,
Tutorial: Build a Node.js web app using JavaScript SDK to manage Azure Cosmos DB SQL API data
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
add a comment |
Basically, first you need to create an Azure web app and need to deploy your existing node.js project on it. In your node.js app you need to create sql connection and use it to insert, update, delete or query the data from database. Follow the below tutorial to connect to database on Azure.
Create a Node.js web app in Azure
As I don't know which SQL DB you are using here are tutorial for common 3 DB on Azure:
1) If you are using Azure SQL database then,
Quickstart: Use Node.js to query an Azure SQL database
2) Or if you are using MySQL then refer this,
Azure Database for MySQL: Use Node.js to connect and query data
3) Or if you are using Azure CosmoDB SQL then refer this,
Tutorial: Build a Node.js web app using JavaScript SDK to manage Azure Cosmos DB SQL API data
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
add a comment |
Basically, first you need to create an Azure web app and need to deploy your existing node.js project on it. In your node.js app you need to create sql connection and use it to insert, update, delete or query the data from database. Follow the below tutorial to connect to database on Azure.
Create a Node.js web app in Azure
As I don't know which SQL DB you are using here are tutorial for common 3 DB on Azure:
1) If you are using Azure SQL database then,
Quickstart: Use Node.js to query an Azure SQL database
2) Or if you are using MySQL then refer this,
Azure Database for MySQL: Use Node.js to connect and query data
3) Or if you are using Azure CosmoDB SQL then refer this,
Tutorial: Build a Node.js web app using JavaScript SDK to manage Azure Cosmos DB SQL API data
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
Basically, first you need to create an Azure web app and need to deploy your existing node.js project on it. In your node.js app you need to create sql connection and use it to insert, update, delete or query the data from database. Follow the below tutorial to connect to database on Azure.
Create a Node.js web app in Azure
As I don't know which SQL DB you are using here are tutorial for common 3 DB on Azure:
1) If you are using Azure SQL database then,
Quickstart: Use Node.js to query an Azure SQL database
2) Or if you are using MySQL then refer this,
Azure Database for MySQL: Use Node.js to connect and query data
3) Or if you are using Azure CosmoDB SQL then refer this,
Tutorial: Build a Node.js web app using JavaScript SDK to manage Azure Cosmos DB SQL API data
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
answered Nov 12 '18 at 6:26
Jinesh Shah
543412
543412
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
add a comment |
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
This is not really true; web apps are just one of many services in Azure to run code. And you're assuming the OP even wants to run their code in Azure: all they said was "I already have the tables ready in Azure" and asking if it's possible to connect to it (implying that maybe the service is running somewhere else). Also, just posting links to tutorials for each database service isn't really an answer (and these are easily findable via the Azure docs site). Based on the OP's writeup, we don't even know what the issue is (the question is unclear and non-specific).
– David Makogon
Nov 12 '18 at 8:46
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
put on hold as too broad by charlietfl, Gaurav Mantri, David Makogon, Larry Shatzer, Funk Forty Niner 16 hours ago I wish that I could know how do you guys help people who ask questions and in a real need for someone to help? You are putting this question on hold instead of asking me any questions or even trying to help with anything in this matter! If I was one of you, then I swear that I'll do my best to help anyone and to try to understand their questions. Put in mind that most people don't know a lot about programming and they ask to get help not to get rejected and get more depressed
– Maged
Nov 14 '18 at 20:55
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
I AM VERY GLAD THAT I WAS ABLE TO CONNECT MY WEB PAGES TO AZURE DATABASE THROUGH NODE.JS WELL DONE
– Maged
Nov 15 '18 at 2:54
add a comment |
What do you mean by "the Microsoft Azure online server?" Are you referring to a specific service? What do you have running in Azure now? Are you trying to access something from outside of Azure? Please edit your question to be more specific, and to also include what issue(s) you're running into.
– David Makogon
Nov 12 '18 at 8:45
@ David Makogon: Thank you for your response. I just updated the question and added more info and a pic to make it more clear. Please let me know if this will help.
– Maged
Nov 13 '18 at 2:14