Bob
|
| Posted: 06/19/2002, 2:29 AM |
|
I am new to ... everything, but I wanted to learn how to set up a site with a database using PHP. To begin I thought I would try and install a simple program like the tellafriend.php from gotocode.com Well needless to say I am stuck on the first line of the instructions. This is the tellafriend.php version but on th first line of the Readme - PHP.txt file it says:
"This document contains instructions on how to configure and install the downloaded ASP application."
Why ASP? Are they the same thing. Is this a mistake?
Next I want to setup the database connection parameters like this:
define("DATABASE_NAME","tellafriend");
define("DATABASE_USER","");
define("DATABASE_PASSWORD","");
define("DATABASE_HOST","");
My server only allows me to have one database which I have already set up and use for a couple other PHP apps so I think I should change "tellafriend" to "editfast" (the name of my database)Is this correct?
For the "DATABASE_HOST" it says the name of the computer. Does that mean the IP address of the server that is hosting my database? Can I just enter it like this?
define("DATABASE_HOST","xxx.xx.xxx.x");
or should I just put "local_host" in there?
Next according to the instructions, which seemed pretty minimal to me, I uploaded the files to my server but there was no mention of where they should go and no mention of file pernmissions etc. There was not even any mention of what file I should lin to from my web page. As I said I am just learning this stuff but I also don't want to mess up the database I already have on my server so I would appreciate any and all help you could give me befoer I do something I will regret.
Bob
|
|
|
 |
Bob
|
| Posted: 06/19/2002, 3:25 AM |
|
I have succeeded in accessing the "Default.php" page on my server but I get the following error when I submit the tellafriend form:
Fatal error: Call to undefined function: odbc_pconnect() in /home/editfast/tellphp/db_odbc.inc on line 30
Which is this :
function DB_Sql($query = "") {
I assume that i have to put something in here but what? There was no mention of this in the instructions. What it did say was :
"Use the ODBC option in Control Panel to setup a system DSN for the application database"
What and where is the control panel?
Perhaps I should mention that I have php4 and MySQL installed on my server is this okay for this app?
Thanks again.
Bob
|
|
|
|
Trevor
|
| Posted: 06/19/2002, 9:04 PM |
|
Hi Bob,
If you have PHP and MySQL installed correctly, then the only thing you need to do for dezign time connection is to install MyODBC which you can get at:
http://www.mysql.com/downloads/api-myodbc-2.50.html
To set up the ODBC go to START/SETTINGS/CONTROL PANEL/ and click the Data Sources (ODBC) icon. This will lead you into the setup for creating a new ODBC datasource. This is only needed for dezign. It is pretty self explanatory from there.
|
|
|
|
|
