471,337 Members | 1,132 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

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

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
Jul 16 '05 #1
8 2714
On 10 Sep 2003 13:58:40 -0700, mi***********@mail.com (Michel) wrote:
What free programs, where to download
http://httpd.apache.org
http://php.net
http://www.mysql.com
http://postgresql.org
and how to install
Each of the above has a manual.
and startprogramming 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?


Each of the above works without an Internet connection.

--
Andy Hassall (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 16 '05 #2
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 <an**@andyh.co.uk> wrote in message news:<jm********************************@4ax.com>. ..
On 10 Sep 2003 13:58:40 -0700, mi***********@mail.com (Michel) wrote:
What free programs, where to download


http://httpd.apache.org
http://php.net
http://www.mysql.com
http://postgresql.org
and how to install


Each of the above has a manual.
and startprogramming 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?


Each of the above works without an Internet connection.

Jul 16 '05 #3
With total disregard for any kind of safety measures
mi***********@mail.com (Michel) leapt forth and uttered:
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?
PostGre is another DB server, you don't really need it. And if
anything you'll probably find it a dog to install.
Do I really need all this soft to write a simple database to
save and lookup data into a excel-look webpage?


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.....
Jul 16 '05 #4
> Do I really need all this soft to write a simple database to
save and lookup data into a excel-look webpage?

You could also look at xml language and a simple "include" in your webpage.
Excel __> save as xml doc
Jul 16 '05 #5
Message-ID: <jm********************************@4ax.com> from Andy Hassall
contained the following:
What free programs, where to download


http://httpd.apache.org
http://php.net
http://www.mysql.com
http://postgresql.org


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/
Jul 16 '05 #6
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.

mi***********@mail.com (Michel) wrote in message news:<a9**************************@posting.google. com>...
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

Jul 16 '05 #7
On 12 Sep 2003 16:36:05 -0700, js******@san.rr.com (Jeff Skeith) wrote:
put your dlls into Windows/System folder and put you php.ini in your
Windows folder.


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 (an**@andyh.co.uk) icq(5747695) (http://www.andyh.co.uk)
Space: disk usage analysis tool (http://www.andyhsoftware.co.uk/space)
Jul 16 '05 #8
ru*****@waiheke.co.nz (george) wrote in message news:<bc**************************@posting.google. com>...
Do I really need all this soft to write a simple database to
save and lookup data into a excel-look webpage?

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


Meaning? Can I use excel to make browser-writable databases online using XML?
Please give more info...
Jul 16 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by democratix | last post: by
reply views Thread by Sunlight Software | last post: by
1 post views Thread by Nathan Bloomfield | last post: by
2 posts views Thread by deejayquai | last post: by
9 posts views Thread by Wayne Smith | last post: by
7 posts views Thread by Joey | last post: by
9 posts views Thread by pbd22 | last post: by
11 posts views Thread by julie.siebel | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.