Need help for business site!

[ZeRgII]

I'm the network administrator of a pool company.I am expected to build a website with certain features such as, enabling a current customer to log into the website to see the time schedule on their pool. My biggest issue here is... I've never had any sort of experience with asp or sql or anything outside of HTML CSS and Javascript. I've looked through the tutorials from http://www.w3schools.com/ , but the tutorials are some what limited in my opinion. If someone could show me some examples that would be great.--Also: I am also creating a page that will let new customers insert their information so that we may reach them very easy.All I have is the form and input tags. Now all I need to know is how to send this information in an organized and readable manner to my boss's email. Please send me in the right direction, ty.

[kastellu]

I'm the network administrator of a pool company.I am expected to build a website with certain features such as, enabling a current customer to log into the website to see the time schedule on their pool. My biggest issue here is... I've never had any sort of experience with asp or sql or anything outside of HTML CSS and Javascript. I've looked through the tutorials from http://www.w3schools.com/ , but the tutorials are some what limited in my opinion. If someone could show me some examples that would be great.--Also: I am also creating a page that will let new customers insert their information so that we may reach them very easy.All I have is the form and input tags. Now all I need to know is how to send this information in an organized and readable manner to my boss's email. Please send me in the right direction, ty.

Firstly i would read some tutorials and try some examples , how to write in to DB and how to read from DB, that are on w3schools , secondly i would work with simple web page that has funcionalities of updating the data from DB. I would recomend that you go trought few examples and trough tutorials so that you will understand what is all about ( conn , if , case , sql statement, cn.close, update,...)

[ZeRgII]

( conn , if , case , sql statement, cn.close, update,...)

As soon as you started listing that stuff, i got confused lol. Well that just goes to show i need to read up and do some homework :sBut where exactly should i start? ASP? mySQL \ SQL? PHP?Which is more capable of accomplishing what I need to be done? <!--This would help, I don't feel like learning each language to find out I just need to know one. Whats the differences in these different db scripts? *Off to read*

[jesh]

This page should explain how to send an email with ASP: http://www.w3schools.com/asp/asp_send_email.asp.Since you know HTML, CSS, and Javascript, you should be able to look over the HTML DOM tutorial to get a feeling for how you can get the values of your form and use that data to build your email.

[ZeRgII]

I'll check it out jesh thanks.

[jesh]

I'll check it out jesh thanks.

As soon I as walked away from my computer I realized that the HTML DOM isn't really going to do anything for you since you'll be taking care of all of this from the server side. You'll want to follow this tutorial to get at the form values: http://www.w3schools.com/asp/asp_inputforms.asp

[justsomeguy]

But where exactly should i start? ASP? mySQL \ SQL? PHP?Which is more capable of accomplishing what I need to be done?

If you haven't started learning those yet, I would recommend PHP. Sending mail and working with databases is easier to do in PHP. Among other things, the syntax for sending mail in ASP differs based on what operating system the server is running. PHP is also supported on more servers then ASP is, for now at least. But, to be fair both languages are equally capable of doing what you need to do, I just think that PHP does it more easily and elegantly. For example, if you have an input tag called "name", and another one called "email", you can email it to your boss like this:

<?php$name = $_POST['name'];$email = $_POST['email'];mail("boss@pools.com", "New website contact", "This person has requested information:\n{$name}\n{$email}");?>

You won't need to learn a lot about SQL, you will be using the SELECT, INSERT, UPDATE, and DELETE statements, at most. And none of them will be very complex for what you need to do.

[ZeRgII]

Thank you very much someguy for the example it explains alot ^^.Would you recommend I go out and buy a book on PHP? Or is everything I need right here on http://www.w3schools.com/ ?Note: Web developing isn't really my thing, but the more I learn, the more I want to learn. Heh, so who knows maybe I'll start being a web developer instead of a Network Administrator

[justsomeguy]

I don't think w3schools is the best place to learn PHP, their PHP tutorials are pretty cursory and the reference is not complete. The official site at php.net has the complete language and function reference, and here is the part about the introduction and tutorial for beginners:http://www.php.net/manual/en/getting-started.phpIf you want a book to read, I would recommend this book:http://www.oreilly.com/catalog/progphp2/You don't necessarily need to read every chapter of it, but it has a lot of good information in it.

[ZeRgII]

Alright, thank you very much. You've helped me much ^^EDIT: Oh lame... That book and a couple of other books are out of stock -.-'2nd EDIT: Cheers I found it @ amazon for even cheaper