@1:
1. Set your punctuation to most or all, whichever you like best. Any other punctuation level is insufficient.
2. Translating what you want to do into code can be tricky for certain people. For me it's very easy, but that's just me. My best suggestion to you would be to learn a programming language like C++ or C# and, as you learn, attempt to translate the code you see into a language only you understand. If you can do that, then you'll soon find yourself writing code like a machine gun. (I'm not kidding.)
3. This type of program can't just be done in SQL. You can put the data in SQL, sure, but you can't make SQL display windows or make web pages. For something like this, you've got lots of options. You could do this in PHP (which would probably be the easiest for something like this) because it allows you to mix HTML and PHP together.
If you don't know HTML very well, check you may wish to check out the Web Developers Reference Guide, by Joshua Johanan, Talha Khan, and Ricardo Zea, ISBN 978-1-78355-213-9. It covers HtML, CSS, Javascript, Bootstrap, and Angular.JS. For learning PHP, I'd recommend the books Learning PHP7, by Antonio Lopez, ISBN 978-1-78588-054-4, and Mastering PHP7, by Branko Ajzele, ISBN 978-1-78588-281-4. I don't have any books on SQL though, since there are so many damn dialects of it. Fortunately for you,, I found a few. For an introductory book to SQL (which I might have to read myself, ha!) I'd recommend SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL (3rd Edition), by John L. Viescas and Michael J. Hernandez, ISBN 978-0-32199-247-5; followed SQL: The Complete Reference, 3rd Edition, by James R Groff (Author), Paul N. Weinberg, Andy Oppel (Author), ISBN 978-0-07159-255-0. You can buy them both at https://www.amazon.com/SQL-Queries-Mere … Src=detail and https://www.amazon.com/SQL-Complete-Ref … rc=detail. Note that the article I used to get these books (http://whatpixel.com/best-sql-books) may be out of date. It does, however, recommend other books. Here's an example of accessing a database in PHP:
<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
And this example shows you how to connect via host:port syntax:
<?php
// we connect to example.com and port 3307
$link = mysql_connect('example.com:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
// we connect to localhost at port 3307
$link = mysql_connect('127.0.0.1:3307', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>
Hope you enjoy!
"On two occasions I have been asked [by members of Parliament!]: 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out ?' I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question." — Charles Babbage.
My Github