Any comments or suggestions?

They have: 406 posts

Joined: Feb 2000

Hello,

I want to learn either ASP, PHP or MySQL. Any suggestions on which is more widely used these days and which is better?

------------------
Adam
[email protected]

Best Regards,

Adam Lee
DigitalONE Design
President - Internet Division
[email protected]
digitalonedesign.com

They have: 850 posts

Joined: Jul 1999

MySQL is an SQL Database, not a programming language. If you need to interact with a database, you could use a MySQL database along with PHP, ASP, Perl etc. You may want to look into learning about Structured Query Language if you are interested in SQL database work.

I would suggest taking a go at PHP. I recently started working with it and it wasn't too bad (although I do have some knowledge in Perl, which made it much easier). It is a very powerful language designed for the internet.
www.php.net/manual is all you really need to learn PHP, unless you want to buy a book, but the manual has all the information you need.

------------------
Recycling one glass jar, saves enough energy to watch T.V for 3 hours.

Vincent Puglia's picture

They have: 634 posts

Joined: Dec 1999

Hi,

As robp says, mySQL is a relational SQL DBMS. If you learn the core S(tructured) Q(uery) L(anguage), learning other SQL DBMSes (Oracle, SQL Server, etc.) and 3rd-party add-ons (Cold Fusion) will be that much easier. The basic syntax is:
select * from tablename where fieldname = something (the asterisk denotes "all"). Working with DBMSes is cool (& profitable).
Unless I'm mistaken, ASP is an IE/FrontPage thingy.

Vinny

------------------
GrassBlade: cut&paste javascript

Where the world once stood
the blades of grass cut me still

They have: 5,633 posts

Joined: Jan 1970

ASP (Active Server Pages) is one of Microsoft’s more successful endeavors in my opinion. ASP is very powerful and quite common. If you plan on getting a job at any kind of e-commerce or corporate site, you’ll need to know ASP. PHP is similar but free source and developed cross-platform, at this time a lot of UNIX hosts support it, but not many large companies use it. Hopefully that will change.

ASP is a scripting environment for Microsoft Internet Information Server in which you can combine HTML, scripts and reusable ActiveX server components to create dynamic web pages. IIS 4.0 includes scripting engines for Microsoft Visual Basic Scripting Edition (VBScript) and Microsoft JScript. ActiveX scripting engines for Perl and REXX are available through third-party developers. ASP is NT dependant, however a few companies have come out with UNIX modules, such as ChilaSoft.

If you’re serious about learning ASP I’d suggest installing Microsoft Personal Web server. This should be on your Windows CD-ROM or it can be downloaded from Microsoft web site (http://www.microsoft.com/windows/ie/pws/default.htm). PWS is great for testing and “messing around” with ASP on your Windows 95/98 computer. For a real “cover all introduction” to ASP try MSDN site (the top link).

http://msdn.microsoft.com/workshop/server/asp/aspatoz.asp
http://www.asp101.com
http://www.devshed.com/Server_Side/ASP/Introduction/
http://www.4guysfromrolla.com
http://www.aspin.com

VBScript and Jscript are both scripting languages that are used in ASP. You can learn more about both at MSDN.

http://msdn.microsoft.com/scripting/default.htm

They’ve pretty much covered the basics of SQL, but I’ll say that it’s worth learning. The basic protocols of SQL are cross-platform and cross-dialects. I deal mostly with UNIX (That’s starting to change, I have almost the same amount of NT and UNIX clients now) so my specialty is mySQL, but SQL Course (the top link) is very good.

http://www.sqlcourse.com
http://www.mysql.com
http://www.devshed.com/Server_Side/MySQL/Intro/

PHP.net is the best site for PHP resources. You may also want to look at:

http://www.devshed.com/Server_Side/PHP/
http://www.phpbuilder.com

Hopefully that was not too much information. I’d highly suggest purchasing a book on ASP and/or PHP. Books come with code samples many times and can be great for learning, even the old scripting junkies pull out their references books more often then they’d probably like to admit.

------------------
Adam
AIS Internet Solutions
[email protected]
www.aisinternet.com

[This message has been edited by adam (edited 05 March 2000).]

They have: 406 posts

Joined: Feb 2000

Thanks Adam...Info was helpful!

------------------
Adam
[email protected]

Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.