• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Web programming help

InverseOfNeo

InverseOfNeo

Diamond Member
So I decided to do a web application for my senior project that will utilize a SQL (not MySQL) backend. I pretty much have my choice of what langauge to use for the front end. Kind of leaning toward PHP only because I have read up on it before and its so similar to C. My partner for the project knows more about the backend and doesnt care much about what language we use for the front end. He did however give me one request....to make the logon page and to understand it. Does anyone know of a website that has tutorials and maybe even scripts available so I can figure this out? I have found a lot but my partner says they are for MySQL and might be able to work if we tried but might just be easier to figure it out for SQL. Any other help is much appreciated!
 
Pick whichever you like best from:

VB.NET
C#
Java
Perl
Python
Ruby
PHP

That covers most of the bigger web programming languages. All of them have a fair amount of online documentation.
 
I'm confused by the "SQL not MySQL" distinction you are trying to draw. SQL is not a "backend". It's a language used to query and interact with relational databases. MySQL is one particular relational database product. It, like pretty much every DBMS, supports a certain subset of the SQL standard syntax.
 
Watching your terms are like nails on a chalkboard for me so let's get some terminology right first.

"SQL vs MySQL"
SQL is a query language that is used on just about every major database system there is nowadays. I think what you meant is MS SQL Server vs MySQL. SQL is not a product - it is a language.

Worry about your method first of what you are going to do and THEN worry about the technology. You will make your life a helluva lot easier. What is the process you are going to use the solve the problem? I am going to present an HTML page with a form on it. The form is going to have three elements: Userid, Password and a Submit button. It will also have a help link and a link for new users to sign up. If a user puts in a userid/password and it is good I am going to send them onto a welcome page. If it is bad I am going to send them back to the sign in page and display an error message in red right above the userid box. If the click on the help link I am going to open a popup for help. If they click on the signup link I am going to send them to a signup page.

OK - The method/process is done. Now how are you going to accomplish it? Well we need a database for the userid/password information and about 3-4 scripting pages to control our simple front end. Our database table will need two columns: username, password.

Notice everything I have proposed above is independent of any technology. Now you can decide - "OK we are going to use PHP and MySQL" and the reasons why. Or classic ASP and SQL Server. Or ASP.NET and MySQL. Or PHP and SQL Server. Just about any combination is valid nowadays and most of the time it comes down to cost. If it is PHP and MySQL then so be it. It is a tool that will get the job done just as well as any of the other languages mentioned in this thread. Use the latest version of both technologies if at all possible: PHP5 and MySQL5.

I am emphasizing architecture and design over technology because this will become very important as you get on to bigger and bigger projects. Your design may only take 30 seconds. But still do it first.

Btw... shoot any PHP/MySQL questions here. I am all up on that. Just like ASP.NET and SQL Server questions. I use both every day and they are both fine tools for building systems and solving problems.
 
Sorry about the terminology....my partner in the project said we would be using SQL Server 2005, and he knows all about that but not the frontend.
 
If you are using SQL Server 2005, may as well use .NET imho

You can get a free copy from MS now of Visual Studio Express:
link

and also they have a similar deal for SQL Server 2005 express (but it is only one client connection allowed at a time iirc)

Also Studio 2005 has a login control already pre-made.
 
Not a problem. If you guys are learning or in class I want to get you off on the right foot. Always worry about architecting, diagramming and documenting what you are trying to accomplish and the deal with the techy stuff later. You will find that after several jobs in life that it just does not matter what color hammer you use to get things done.

I have to admit that I am getting partial to the object oriented languages - which is ASP.NET and the PHP5. The companies that make the languages are sending more and more functional code that lets the day to day programming be a little more exciting.

P
 
I'll agree with rsd on this one. The "SQL Server and ASP.NET" and "PHP and MySQL" packages dance very well together. You can cross them if you ever need to but you rarely need to. If you are looking strictly at cost it is usually cheaper to develop in PHP/MySQL because of the whole open source thing.

Talk about a PITA - I use VB.NET/SQL Server all day long and then use PHP/MySQL for several hours at night. If I was smart I'd convert to C#.NET during the day so I'd have less of a curve to remember things.
 
Originally posted by: rsd
If you are using SQL Server 2005, may as well use .NET imho

You can get a free copy from MS now of Visual Studio Express:
link

and also they have a similar deal for SQL Server 2005 express (but it is only one client connection allowed at a time iirc)

Also Studio 2005 has a login control already pre-made.
Click to expand...


Well I'll try using that. Is MS Visual Web Developer Express ok to use? Is there something special I need to do to make the programs talk to each other?
 
.NET ftw.

See if your school is part of the MSDN Academic Alliance in which case you can get everything you need and more free. Visual Studio, MS SQL Server, Windows Server 2003, etc.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top