Problem attaching PHP to webpages

[thumbliner]

Hello Guys,

I am new here and desperately in need of some guidance. I am a beginner in web development. I wanted to design a dynamic website so I asked someone to do all the php coding for me and send me those files and teach me how to use them. He took the money and send me the files but is not giving support. Now I need someone who can tell me how to do the basic php coding work.

He made all the files which just have to be included in my webpages. He asked me to use the following code to attach those files - <? include 'filename.php'; ?>

To test it, I made a webpage and used a login.php which he made for me. I added the following code in the body of the page <? include 'login.php'; ?> but when it try to open that page on the internet, i get an error which says i have an error in the main data.php file

These are the only lines which data.php contains. Can you please tell me what to do?

------------------------------------------------------------------------------------

line 1 <?php

line 14 $hostname_conn_abrv = "localhost"; ////database hostname, usually always localhost
line 16 $database_conn_abrv = "salmansk_system"; ////database name
line 17 $username_conn_abrv = "salmansk_user"; /// database username
line 18 $password_conn_abrv = "user"; //// database
line 19 $conn_abrv = mysql_pconnect($hostname_conn_abrv, $username_conn_abrv, $password_conn_abrv) or trigger_error (mysql_error(),E_USER_ERROR);
line 20
line 21 ?>

------------------------------------------------------------------------------------

When I asked him, he just said edit the data.php file. Now I dont know what I have to edit in those lines.
Can you please guide me what to do? The link to that page is http://www.bourneaviation.com/tying.php

[dab42pat]

Hi
Firstly do you have a database set up on your host (I assume you are checking this online).

lines 14,16,17 and 18 are asking for your details for your online database

Line 14 at the moment is set for localhost, a server on your pc. do you have any server running on your pc.

[saltedm8]

you need to find out your database access, user pass etc info, so you can connect to the database,

then you will need to input that information into the data.php file. i am sure your host can help you with this as i am sure you would not want to advertise your connection details

[nashultz07]

The red part is what they are talking about being edited:

Originally Posted by thumbliner

------------------------------------------------------------------------------------

line 1 <?php

line 14 $hostname_conn_abrv = "localhost"; ////database hostname, usually always localhost
line 16 $database_conn_abrv = "salmansk_system"; ////database name
line 17 $username_conn_abrv = "salmansk_user"; /// database username
line 18 $password_conn_abrv = "user"; //// database
line 19 $conn_abrv = mysql_pconnect($hostname_conn_abrv, $username_conn_abrv, $password_conn_abrv) or trigger_error (mysql_error(),E_USER_ERROR);
line 20
line 21 ?>

------------------------------------------------------------------------------------

If you are still needing help, just let us know!

Thank you,
Nathon Shultz

[thumbliner]

Originally Posted by dab42pat

Hi
Firstly do you have a database set up on your host (I assume you are checking this online).

lines 14,16,17 and 18 are asking for your details for your online database

Line 14 at the moment is set for localhost, a server on your pc. do you have any server running on your pc.

I do have a database setup. I dont know what a server is on my pc. I think i dont have any running on my pc but all that i know is that i use webhostingpad

[CloudedVision]

If you do have a database set up, do you know the username, password, and the database name? If not, you should be able to find them in your hosting control panel.

Once you have that, you can edit the file. Line 14 should stay the same. Line 15 is the username, and line 16 is the password. Line 17 is the database name.

Once you've gotten all the changes, upload it to the server and you should be set.

[Bocaj]

They're over selling a bit too much

Well go into your control panel, and go to phpMyAdmin and along the left panel you should see the databases that currently exist, make sure your database is there.

If so... on the main page you should see something like this

• Server version: 5.0.51a
• Protocol version: 10
• Server: localhost via TCP/IP
• User: xxx@localhost

That's your username, and hostname...

Now From the menu under 'create new database'

Select the option 'privelages' and it will show you all the usernames with access to that database, and what they can/can't do.

You might need to change your global privelages to 'all privelages' (or to the correct privelages for what you need) and make sure theres a password.

So now you should know your host, username, password and don't forget to check the database exists and not it's name ( i think it's all case sensetive bit i'm not sure, avoid using uppercase to be safe).

And then enter the relevant names into your php code.

Even webhosts generally use 'localhost' (very few don't), some may have an i.p address or another name for it.

Hopefully that should help, if not just post