Page 10 - Setting Up Database Driven Websites

Under "Installing PHP", I modified the "apxs" path for Red Hat Linux 6.1. "make install" still failed, so I copied "libphp3.so to "/usr/lib/apache" directory.
Everything works great now. The code below works without error on my system. Good luck.

Javascript relies on the client-side browser being able to understand the script. So if you're aiming for near universal compatibility a server side solution using some submitted form contents might be better suited. Javascript is good, however, in that it can instantly output the result to an input box without needing any server access (although input boxes looks dog face ugly without some CSS). So perhaps a PHP>APACHE query of the browser and write some different code would be the best way. You may want to consider writing a Javascript for IE4+/Mozilla that writes the answer into a DIV so that the answer can't be altered (unlike an input box).

binry = the BINARY... foo!

Hi,

I remotely run, via a secure Telnet session, an Apache / Freebsd webserver, and am going to be implementing a PHP/Mysql solution. I'm unsure of how much data I need to input, but as I'm sure you'll appreciate - I don't want to have to enter it line by line in the telnet session.

Are there any Web Interfaces that can help me create Mysql databases?

Can anyone suggest a "local" solution for me to try in Windows?

I'd be grateful for any feedback, for a beginner in all this.

Cheers,

Will

You can have all the data you want to input in text file, upload the text file to your server and import it into mysql.

Do you have mod_php installed already (check by running rpm -qa | grep php)?

That means you don't have MySQL support compiled into PHP.

Do you have the proper AddType directive in your httpd.conf to handle PHP files?

How many sets of <form></form> tags do you have? From what you are describing, you should have one for each line of data on your page.

Thanks for the reply, i dont have mod_php installed. I don't have time to fool around with it for quite i while now. I think my next go with php gonna be with a solaris 7 box that don't have apache or php installed before.
<br>
Thanks any way / Thomas
<br>
<br>
<br>

The way I figured out how to handle this is to have each row displayed have it's own <form>...</form> . That seems to fix the problem. I was looking for a way to have all displayed rows in one <form>...</form> but couldn't figure out a way.

I've tried everything to get the grant command to work. I have root access and it is installed on my machine. I am using the windows version. Is this something I have to set up and if so, how? or is there something I am missing. Thanks in advance - Chris

Don't make fun of me if I'm wrong...

have you tried to run mysqld before trying
to connect?

I've been trying to install mysql, i've followed the instructions to this tutorial, and also tried to compile the source code myself, and when i run the
<!-- Code -->
<p><pre><font color=#008000><xmp>mysql.server start</xmp></font></pre><p>
<!-- Code -->
the daemon starts up, and the quits out right away. why???

I have created a file and upload it to my directory and I am know trying to execute it under a mysql prompt. The file creates about 2000 lines of insert statements to populate a database. can any one help..

Thank you