Re: database (now "MySQL/PHP")

Top Page
Attachments:
Message as email
+ (text/plain)
Delete this message
Reply to this message
Author: Don Calfa
Date:  
To: plug-discuss
New-Topics: I need some help understanding which programming tools to use for my project.
Subject: Re: database (now "MySQL/PHP")
Michael Havens wrote:

>Looks like I'll be in WAAAAAAY over my head with this project. I suppose that
>I'll start with learning HTML. Then I'll do PHP followed by SQLite. Then I'll
>end it all with Apache. Then I'll look for someone to be my partner. You
>know... maybe I could do it via email?
>
>

FWIW,

I used to be a MS trooper a while ago. One of the things I liked was
all the tools that were available. I learned Access and created a
couple of DB's with it. Got real familiar with it's tools and forms.

What I didn't like was the crappy reporting that was available with the
builtin reports and the fact that upgrades sometimes didn't go well with
form fields and the like.
I also wanted to be able to access my DB's through the web. The builtin
form-html tool was cool but it still wasn't what I wanted and reports
had to be static without any extensive programming.

Having a couple of DB's, a growing hatred of MS (started with a $30,000
license issue with them, another story), and a desire to learn, I
slapped PHP on my IIS server and MySQL.
What was cool about Access was the form wizard and the query wizard.
Learning SQL isn't hard at all, it's just something to learn and after a
while, easier than Access. MySQL Control Center is a valuable tool as
well as MyPHPAdmin.

After learning PHP (with HTML in the mix), creating forms, inserting
data, retrieving data, I finally got the look and workflow I wanted.
Something Access couldn't do.

Now, my DB's are mine and not property of Microsoft. I also have MySQL
experience and a lot of PHP knowledge.






>On Tuesday 13 April 2004 01:48, Trent Shipley wrote:
>
>
>>On Monday 2004-04-12 23:32, Michael Havens wrote:
>>
>>
>>>So are you saying that I also need to learn apache?
>>>I know noTHING! What should I learn for the purpose of starting a pay
>>>website? 1- html (this wasn't in your list)
>>>2- PHP
>>>3- MySQL (would SQLite work)(from what I've read it will)
>>>4- Apache
>>>Ohhhhhhh! Is that what you meant by the traditional approach? Could
>>>someone possibly direct me to a tutorial? I'm googling right now and
>>>found www.google.com/search?q=sqlite%20tutorial&ie=UTF-8&oe=UTF-8!
>>> but I do not know what I really need.... it's just a shot in the dark. I
>>>need advice from those who have an idea.
>>>
>>>Does anyone know of a tutorial that includes everything I need to know?
>>>
>>>:)~MIKE~(:
>>>
>>>
>>Ok.
>>So how to create a money making website in 10 easy lessons.
>>
>>Disclaimer: I'm not the one to talk to. If I knew how to do it, I'd do it
>>myself.
>>
>>Putting up anything besides a static web site costs money. You'll need
>>webhosting, scripting services, database services, and e-commerce services.
>>Plus, they tend to charge for bandwidth used.
>>
>>You CAN do it all yourself and get full creative control. That means
>>renting space and services at a colocation facility and is VERY expensive
>>and complicated. Almost no one does it.
>>
>>Be optimistic. Shure, 95% of all small businesses fail in the first 5
>>years but to even start a small biz you need to expect you'll be the
>>deserving 5%.
>>
>>=======================
>>
>>To put up a commercial web site from scratch you need:
>>
>>Business expertise.
>>E-commerce expertise.
>>E-commerce software.
>>Content development expertise
>>Content development software.
>>(For a large site you will need content management expertise and software.)
>>Software development expertise (web scripting specialization).
>>Software development tools.
>>Database development expertise
>>Database administration expertise.
>>Database software.
>>Web server administration expertise.
>>Web server software.
>>(Operating) system administration expertise.
>>Operating system software.
>>Industrial grade computer hardware.
>>Networking expertise.
>>Networking hardware.
>>Telephony expertise.
>>Telephony hardware.
>>Location with access to high-bandwidth WAN (telephony) and rent for
>>bandwidth.
>>
>>Note this list grossly oversimplifies the scope of the problem.
>>
>>Fortunately, you do not have to learn all this. Items higher on the list
>>are more critical.
>>
>>================================
>>
>>Most web based businesses don't even try to do the entire stack. They do:
>>
>>Business expertise.
>>E-commerce expertise.
>>E-commerce software.
>>Content development expertise
>>Content development software.
>>(For a large site you will need content management expertise and software.)
>>Software development expertise (web scripting specialization).
>>Software development tools.
>>Database development expertise
>>Database administration expertise.
>>
>>I know little about the business of running a small commercial website. I
>>also have no training in e-commerce, point-of-sale, working with credit
>>companies like Visa, and so on.
>>
>>For a commercial site the most important consideration seems to be graphic
>>design, followed by usability, then followed by written content. For some
>>select sites audio is also important. There is no substitute for design.
>>If you don't have a talent for it you will need a partner. For begginer
>>level content work you can get away with a very superficial knowledge of
>>HTML by letting a tool do most of the work for you.
>>
>>---
>>
>>Software development falls into various categories. In my opinion learning
>>to program in a Windows web environment is slightly easier than on *nix.
>>Also, there seems to be more work for Windows based web development.
>>
>>There are three main parts to web programming.
>>
>>-- Web server modules or plug-ins. This is for real gurus. You wont have
>>to do this.
>>-- Server side scriping. This is fundamental. On Windows it means VB
>>Script. On *nix it tends to mean PHP. With either OS you can see JSP or
>>Cold Fusion. -- Client side scripting. This usually means JavaScript. If
>>you only are interesting in IE browsers you can use VBS. (I regard client
>>side scripting as a trip through browser compatibility hell.)
>>
>>For any web scripting you will need to be thoroughly proficient in HTML.
>>HTML with Client and server side scripting are basic. For advanced web
>>oriented software development you get to learn Java, XML, and XSLT.
>>
>>Note that I like programming but HATE doing commercial web programming. I
>>look at it as daily competition in Junk Yard Wars [tm]. The goal always
>>seems to be get it done fast, get it done cheap, with inadequate
>>tools--quality and planning (let alone adequate financing) be damned.
>>
>>Sometimes you see ads for ASP experts. I never know what they mean. Do
>>they need me to write plug-ins for IIS? Do they want me to administer IIS?
>>
>>For most low-budget operations database development (SQL) gets rolled into
>>the rest of software development. In any case, all web developers need to
>>know how to do rudimentary database programming.
>>
>>When you hire your web hosting you need to know a little bit about database
>>administration but not much since the hosting company does most of the DBA
>>work.
>>
>>Needless to say, it is the rare individual who is compentent in all four
>>areas, particularly since personalities that are good at one (software
>>development) are often hopeless at another (like marketing).
>>
>>=============================
>>
>>Crawl, run, walk.
>>
>>Have you ever put together a simple static web site?
>>
>>---
>>---------------------------------------------------
>>PLUG-discuss mailing list -
>>To subscribe, unsubscribe, or to change you mail settings:
>>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>>
>>
>
>
>
>
>
>
>This message has been scanned for viruses by the VEI Internet
>Automatic Email Spam and Virus Scanner, and is believed to be free of spam or viruses.
>Please report spam to . If you would like 98.9 % spam blocked from your
>E-mail then go to VEI Internet for details. Anti-spam/Anti-virus is FREE with every account.
>
>
>http://www.vei.net/
>
>---------------------------------------------------
>PLUG-discuss mailing list -
>To subscribe, unsubscribe, or to change you mail settings:
>http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>


---------------------------------------------------
PLUG-discuss mailing list -
To subscribe, unsubscribe, or to change you mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss