Setting Up Database Driven Websites

How about some advanced tutorials.... this basic stuff blows.

Very useful - Certainly cut down the amount of background reading necessary to start doing something useful with mysql,php and apache.
<br>
<br>
One point - in the "Installing Apache" section I had to add:
<br>
<br>
LoadModule php3_module libexec/libphp3.so
<br>
&
<br>
AddModule mod_php3.c
<br>
<br>
to httpd.conf in order to get the example working.
<br>
<br>
Thankyou, I look forward to the next in the series !!!
<br>

RTFM

Setting Up Database Driven Websites are there other packages you can use to do this? eg. java.
what are the implications on load if all is running server side rather than client side? (using a java example, if someone is not java enabled is it possible to set up everything on the server side or do you need to script for highend then lowend browsers making it client and server side?).
btw i don\'t have a lot of knowledge in this area so if i have this wrong please let me know!
any comments would be greatly appreciated.
You can read the article here .

me estoy iniciando en el manejo de server y estoy interesado en crear mi propia web site . Necesito información sobre java en venezuela

I would also suggest PostgreSQL for database driven sites. I use this most often and is the most powerful open source (free) database out there. Instead of PHP, use DBD and DBI. This is an incredibly powerful database (blows MySQL outta the water). Go to http://www.postgresql.org for information. If you have questions, please don\'t hesitate to email me.
If you have Red Hat 6.0 (Linux) you already have PostgreSQL as an option to install.

Very useful document. It helps me to start stright ahead following the examples, though a couple of time need to go back and refer the Linux, Apache, MySQL manual to find why I have to do this and why it is not working for me.

I am expecting articles like how to access MySQL database using Perl the most popular unix scripting language in future.

Good job...

We are all kids in the beginning!

I used PHP in the examples because it is easy and fast. Perl is a more generalized language, while PHP is for server side scripting.

Using Perl, you would use DBI to interact with the database and the CGI module to spit out HTML.

There are many other tools and packages that can accomplish the same thing. For example ASP, Perl, ColdFusion, etc.

The load on the servers will increase if you are comparing serving static pages vs dynamically generated content. However, there are many things that can only happen on the server side (such as getting data from a database and publishing it as HTML).

While perl is certainly a popular language, php is the defacto server side scripting language for DB integration.

I for one am glad to see the PHP version before any wacky Perl version comes out for those who are unable to learn PHP...

When I try to connect to MySQL via a .php3 file, this is what I am receiving:


Fatal error: Call to unsupported or undefined function mysql_connect() in /home/httpd/html/test.php3 on line 13

Any ideas?

Did you really need to make a post for this?
If this article doesn\'t do it for you, move onto another site. I personally thought the article was very useful. We all begin somewhere.

I currently use PostgreSQL and PHP
(Debian 2.1)instead of MySQL, for db with web interface. I find it easier, most
powerful and easier to setup.
I strongly suggest it!
*It\'s 100% free*

You are probably getting that error because the version of PHP you are using (whether it be the binary or one you complied yourself) does not have MySQL support built in. You need to run configure with the --with-mysql flag. I\'m not sure about that exactly though, so you may need to run configure --help to see what the correct one is.

Hope this helps. = )

-Zoot