dynamic database websites, What, Where, How to start?

[Michel]

What free programs, where to download and how to install and start
programming a dynamic website that enables visitors to log in, lookup
and write data in/from a serversite database. So how can I write and
test it without internet on a win98se pentium?

thanks

[Andy Hassall]

Re: dynamic database websites, What, Where, How to start?

On 10 Sep 2003 13:58:40 -0700, michelratipho@m ail.com (Michel) wrote:
[color=blue]
>What free programs, where to download[/color]

http://httpd.apache.org

http://php.net

http://www.mysql.com

http://postgresql.org

[color=blue]
>and how to install[/color]

Each of the above has a manual.
[color=blue]
>and startprogrammin g a dynamic website that enables visitors to log in, lookup
>and write data in/from a serversite database. So how can I write and
>test it without internet on a win98se pentium?[/color]

Each of the above works without an Internet connection.

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Michel]

Re: dynamic database websites, What, Where, How to start?

So apache is needed to run a webserver on the local machine, right?
PHP is the language to be able to write and get data out of a database
and make dynamic webpages, right?
MySQL is the database itselve, right?

But for what do I need postgresql?
Do I really need all this soft to write a simple database to save and
lookup data into a excel-look webpage?


Andy Hassall <andy@andyh.co. uk> wrote in message news:<jm5vlv4ae 29984mi8tt47u1t e7fa7aatv8@4ax. com>...[color=blue]
> On 10 Sep 2003 13:58:40 -0700, michelratipho@m ail.com (Michel) wrote:
>[color=green]
> >What free programs, where to download[/color]
>
> http://httpd.apache.org
> http://php.net
> http://www.mysql.com
> http://postgresql.org
>[color=green]
> >and how to install[/color]
>
> Each of the above has a manual.
>[color=green]
> >and startprogrammin g a dynamic website that enables visitors to log in, lookup
> >and write data in/from a serversite database. So how can I write and
> >test it without internet on a win98se pentium?[/color]
>
> Each of the above works without an Internet connection.[/color]

[Phil Roberts]

Re: dynamic database websites, What, Where, How to start?

With total disregard for any kind of safety measures
michelratipho@m ail.com (Michel) leapt forth and uttered:
[color=blue]
> So apache is needed to run a webserver on the local machine,
> right? PHP is the language to be able to write and get data out
> of a database and make dynamic webpages, right?
> MySQL is the database itselve, right?
>
> But for what do I need postgresql?[/color]

PostGre is another DB server, you don't really need it. And if
anything you'll probably find it a dog to install.
[color=blue]
> Do I really need all this soft to write a simple database to
> save and lookup data into a excel-look webpage?
>[/color]

No not necessarily, but if you want to do proper development on
your own system then you will need all of it. Unless you develop
scripts live on the server that is.

--
There is no signature.....

[george]

Re: dynamic database websites, What, Where, How to start?

> Do I really need all this soft to write a simple database to[color=blue]
> save and lookup data into a excel-look webpage?[/color]


You could also look at xml language and a simple "include" in your webpage.
Excel __> save as xml doc

[Geoff Berrow]

Re: dynamic database websites, What, Where, How to start?

Message-ID: <jm5vlv4ae29984 mi8tt47u1te7fa7 aatv8@4ax.com> from Andy Hassall
contained the following:
[color=blue][color=green]
>>What free programs, where to download[/color]
>
>http://httpd.apache.org
>http://php.net
>http://www.mysql.com
>http://postgresql.org[/color]

PHPdev is an incredibly easy way of doing it all in one go on a windoze
machine.

"... phpdev is a pre configured suite of all the bits and pieces you need
to get Apache/PHP/MySQL/other running on your machine. It is not invasive
and does not alter any windows settings or touch the registry etc. "

http://www.firepages.com.au/

--
Geoff Berrow
It's only Usenet, no one dies.
My opinions, not the committee's, mine.
Simple RFDs http://www.ckdog.co.uk/rfdmaker/

[Jeff Skeith]

Re: dynamic database websites, What, Where, How to start?

i just set up apache and php using this tutorial...

http://crowdesigns.apachego.com/apache/

put your dlls into Windows/System folder and put you php.ini in your
Windows folder. I didn't install mysql as i'm delusional and think
i'm going to skip mysql and jump to postgresql (pgsql).

pgsql alledgedly has more functionality, but is also much less popular
and used less than mysql - and tutorials are pretty darn scarce
relative to mysql.

i used apache 2.0.47 and php 4.3.3 on my win98 box.

i ran into a problem testing my php b/c the file (i got html output
only) i thought i downloaded wasn't the actual file that was
downloaded. when i actually put proper php code into the file, it
worked like a charm.

except for the stupid non php content, the whole thing was pretty
painless.

i recommend using notepad (or another editor) and putting

<?php
phpinfo();
?>

as your php test script. make sure you save it as test.php.

then type in...

http://localhost.test.php (or http://localhost:8080/test.php, as the
case may be - that screwed me up for a day or so).

Ther are other modifications you can make to youe apache httpd.conf
(configuration) file that i picked up using othr tutorials. do a
google on "apache php mysql configuration" or "... install" and review
some other tutorials for additional ideas.

in addition, you may have to hard link some urls so you can follow
this advice i just picked up from the newsgroups today...

---------------
how to make "localhost" into "www.nameiwant. com"
---------------

Yes!! there is a way..

Go to your windows directory, and you should be able to find a file
hosts.sam (hosts sample file) If there is no hosts file, copy
hosts.sam to hosts.

Open hosts, and you'll see some minimal descriptions, etc...

On the line that says:
127.0.0.1 localhost

add www.nameiwant.com

i.e. (horizontal seperator is space, or tab char)

127.0.0.1 localhost www.nameiwant.com

save the file.

open you web browser, connect to www.nameiwant.com, and voila -- same
thing as localhost.

If the sitename exists on the internet, your system will connect
locally, in preference to going outside (it looks in the local copy of
the hosts file first..).

So, you could even use the target name of the system you will
eventually be uploading to.., locally -- but this may cause all kinds
of confusion, if you try to work on both the local, and remote systems
at the same time, with the same name :) (just ask me about it:) :) :)

i also saw another google message that said...

You have also to modify ServerName directory in httpd.conf.

is this an add'l step or an alternate step? i don't know. i will
find out this weekend.

good luck.

michelratipho@m ail.com (Michel) wrote in message news:<a9ee3bbf. 0309101258.305b addc@posting.go ogle.com>...[color=blue]
> What free programs, where to download and how to install and start
> programming a dynamic website that enables visitors to log in, lookup
> and write data in/from a serversite database. So how can I write and
> test it without internet on a win98se pentium?
>
> thanks[/color]

[Andy Hassall]

Re: dynamic database websites, What, Where, How to start?

On 12 Sep 2003 16:36:05 -0700, jskeith1@san.rr .com (Jeff Skeith) wrote:
[color=blue]
>put your dlls into Windows/System folder and put you php.ini in your
>Windows folder.[/color]

You're better off not doing this; don't add anything to the Windows system
directories if you can help it.

Just add the path to the DLLs to your PATH environment variable so they can be
loaded by the webserver.

Set the PHPRC environment variable to the directory containing php.ini -
probably the easiest place is the same directory as above, e.g. c:\php , or
wherever you unpacked the .zip file to.

--
Andy Hassall (andy@andyh.co. uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)

[Michel]

Re: dynamic database websites, What, Where, How to start?

russell@waiheke .co.nz (george) wrote in message news:<bcab4b38. 0309112005.3eab 0981@posting.go ogle.com>...[color=blue][color=green]
> > Do I really need all this soft to write a simple database to
> > save and lookup data into a excel-look webpage?[/color]
>
>
> You could also look at xml language and a simple "include" in your webpage.
> Excel __> save as xml doc[/color]

Meaning? Can I use excel to make browser-writable databases online using XML?
Please give more info...