Need to do a Hello World mobile app (HTML5)

hindersaliva
hindersaliva used Ask the Experts™
on
I'm a mobile apps newbie. (but good on ADO, SQL)
I have a SQL Server online (Azure). I need to create a simple HTML5 phone app that can do (for demo purposes) the following.
  • Show a dropdown list of (say about 6 items) that a user can select from. The 6 items are populated from a table in the SQL Server with a SELECT statement. When click a Go button, the app sends a SQL UPDATE statement that includes the value of the selected item.
  • Show a textbox for entering a short message. Click Go button to send an INSERT statement.
I'm looking to do that as a Hello World (before I launch into deeper learning)
Thanks!
I have an iPhone 6s
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Developer & EE Moderator
Fellow 2018
Most Valuable Expert 2013
Commented:
You will want to start by making a responsive web page.  Use https://getbootstrap.com/ or https://foundation.zurb.com/. What you are really after is the responsive grid.  

Your Hello World should start out on the front end and just make the page  
<!DOCTYPE html>
<html>
<head>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width">
  <script src="https://code.jquery.com/jquery.min.js"></script>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet" type="text/css" />
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
  <title>test</title>
</head>
<body>

<select>
  <option value="1">thing 1</option>
  <option value="2">thing 2</option>
  <option value="3">thing 3</option>
  <option value="4">thing 4</option>
</select>
</body>
</html>

Open in new window


Now start adding some other html/css features to make it look as you expect and format to your device nicely.

Once you have the front end, you can use use the back end language of your choice to render the select options.

Author

Commented:
Hi Scott, yes that bit is familiar to me. I used to do Classic ASP back in the day. I used VBScript. Is that still an option for backend language?
If not, is it now PHP?
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
You can use asp, but I think you are better off using php or another language.
Your asp code would probably be something like this
<select>
<%
do until rs.eof
  response.write "<option value='"&rs("id")&"'>"&rs("name")&"</option>"
rs.movenext
loop
%>
</select>

Open in new window


Remember, server side code like asp or php runs before the page is loaded.  The code above could render out the same as the static code.  Once the page loads, then css and javascript take over.  It can be a little hard to wrap your head around at first.
Should you be charging more for IT Services?

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Ok. That's exactly like I used to do ASP with Dreamweaver UltraDev back in 2001. Thanks.

Author

Commented:
Found a course on Lynda.com for Bootstrap 4. I'll check that out.
Looks like I'll be hosting it at my usual web host, as even a Classic ASP web app, right?

Exciting.
Scott FellDeveloper & EE Moderator
Fellow 2018
Most Valuable Expert 2013

Commented:
yes, that is correct.

I think it will help if you start by creating your pages with static html, then build in your dynamic data.
Shaun VermaakTechnical Specialist
Awarded 2017
Distinguished Expert 2018

Commented:
Your best bet would be to utilize VB.NET to create an ASP.NET website so that your VBScript knowledge transfers. PHP is completely different.

Author

Commented:
Sorry for the delay in closing this question.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial