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 (http://www.devshed.com/c/a/Administration/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 (http://www.devshed.com/c/a/Administration/Setting-Up-Database-Driven-Websites).
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
I went through the installation step again and now it seems to work fine.
What I think it was is that I first downloaded the source for MySQL and not the binary.
When I try to grant usage to run queries from web browser I get error 1064. I am using a database on a Linux server which I have my domain on and using telnet to access it.
Is this a problem with how the server is set up?
Please help me, Ive spent all night on this.
I followed the tutorial instructions exactly but cant get it to work.
Thanks
At which ponit are you getting these errors? Can you provide any more information? Does the error 1064 come from PHP or Apache or MySQL?
It happens when it try to grant usage when connected to the mYSQL database through telnet. The PHP returns an error because it does not have access I assume.
So I type
grant usage
on sample.*
to webuser@localhost;
And error 1064 comes up.
Ive tried all different ways to get this to work but had no success.
When I log into MySQL is am in the dir that has the PHP3 scripts.
Thanks
I have been following the tutorial on Devshed to try and get MySQL running
for a dynamic website
I am using it through a telnet terminal emulator because the domain is
hosted virtually on a server elsewhere.
I have made the database and tried to grant usage so the database can be
accessed by pages on the Internet
However, it is MySQL version 3.21.33 and I am told it is only version 3.22
and up that use the GRANT usage statement
How do I grant usage so I can access it from the web on 3.21.33?