Computing.Net > Forums > Programming > Help with: php, MySQL, database

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Help with: php, MySQL, database

Reply to Message Icon

Name: TeeTee
Date: November 1, 2003 at 20:51:21 Pacific
OS: WinME
CPU/Ram: AMD Athlon 1600+ / 256MB
Comment:

Okay, I've avoided learning this programming thing and all the multiple languages involved. Apparently, I can avoid no longer and am requesting some basic help...

I have a web site hosted elsewhere that's html based with some extra DHTML thingies here or there - nothing difficult and of course, nothing extravagant. I have some knowledge but not enough and realize there's A LOT to learn so please excuse any stupid questions I may have...

What I would like to do:
Is AIM with someone who is interested in my current dilemma which is trying to get a phpBB forum up on my web site and connect to my database.

My hosting company is of no help and of course the support at phpBB is limited to their software only.

Please email me with your screen name so I can add you to my buddy list to chat. I am a very fast learner with a perfectfully functioning brain but without any programming foundation to start from. (You know, it's like learning to replace a distributor cap on a car without even knowing where the hood release latch is.)

For those uninterested in assisting via AIM, by all means post your advice or recommend a good book for me.

Thank you. =o)




Sponsored Link
Ads by Google

Response Number 1
Name: zeroguy
Date: November 1, 2003 at 21:05:44 Pacific
Reply:

(First of all, regarding the metaphor with the car, I totally understand. Really. heh)

Anyway, http://www.php.net is a great place to go for PHP. I don't know how good the tutorials are or anything, but the function list is awesome to just find a function to do what you want to do.

http://perl.about.com has some tutorials on it, for PHP, Perl, and MySQL (along with some other things as well).

Of course, if you're unsure about something, just ask a question here and we'll try to answer it. Good luck!

-zeroguy


0

Response Number 2
Name: anonproxy
Date: November 1, 2003 at 21:43:33 Pacific
Reply:

Follow the installation instructions in the zipped PHPBB file or here. (Get the latest version, of course). If you are stuck in this, post your problem.

PHPBB is very easy to use. It does not require programming knowledge to set up.


0

Response Number 3
Name: TeeTee
Date: November 1, 2003 at 22:47:56 Pacific
Reply:

zeroguy:

Thanks for your understanding and info. I will check those links out. (checking as I type) I love finding those doo-dads and believe me, I have a list of them I'd love to get up on my web site. =o)

anonproxy:

As for phpBB - no doubt, it seems very easy. It's installing it correctly, or rather, connecting to the database that I am having trouble with. I followed the installation instructions perfectly - been to their forum and posted my problem and so far, no one has been able to help resolve the problem.
Do you know phpBB well? It is my understanding that one needs to setup or have access to a database on their server and then the phpBB install program sets up the database tables. I can't get past the installation screen with the database name/user name/password that my hoster provided. I have no idea how else to connect to the database and I don't believe I have shell access. Even if I do have shell access, I've been told to use the SSH program and I haven't a clue how. *LoL*

Any ideas are welcome...
Thanks for answering my post. =o)


0

Response Number 4
Name: anonproxy
Date: November 1, 2003 at 23:22:01 Pacific
Reply:

"It is my understanding that one needs to setup or have access to a database on their server and then the phpBB install program sets up the database tables."

Yes, you need access to a database and a database file created. That's it.

"I have no idea how else to connect to the database and I don't believe I have shell access."

Do you have a control panel or some other interface through which you can see if MySQL database access is enabled? Often you can use such an interface to make a database (the file, not the program). Go to your web hosting provider and check their help/support files. They should answer your questions about whether you have a database, how to create a database (the file), what you database account name and password are, etc..


In the PHPBB installation place the following values:

server: localhost
[literally, put that in]

database name: username
[usually is your account username]

database username: username
[usually same]

database password: password
[again, same as account usually]

Prefix for tables in database: phpbb_
[don't change, you don't care]

Admin Configuration:

Admin Email: email@address
[anything you want]

Domain Name: www.myaddress.com
[your website address]

Server Port: 80

Script Path:
[should be filled, if it's blank, fill it in like www.address.com/phpbb/ - with that last slash]

Administrator Username: admin
[anything you want]

Adimistrator Password: password
[anything you want]

Admistrator Password (confirm): password
[re-enter the password]


0

Response Number 5
Name: TeeTee
Date: November 1, 2003 at 23:33:11 Pacific
Reply:

anonproxy:

Yup, done all that so many times I've lost count. On a whim, I tried a little while ago and recieved a new error. Posted in the phpBB support forum and they responded saying it has been my hoster that's creating the problem. (apparently has been all along - that it should suddenly "connect") *LoL*

My hoster sux, to put it lightly. Nope, no control panel in fact, their stinkin' file manager doesn't even work. I think that it's possible I know more than they do. (scary) *LoL*

I appreciate your posts - thanks. I'm sure I'll have more Qs shortly...



0

Related Posts

See More



Response Number 6
Name: TeeTee
Date: November 2, 2003 at 00:11:18 Pacific
Reply:

Ahhh... okay, it's one of two things...
(according to phpBB.com)
Either I have to irritate my hoster to the
point where they'll grant my db user more
permissions or... if I can create my own
db user w/permissions using this nifty tool
called phpMyAdmin.

Okay, so here's the trouble. Assuming I
can use that program/that my hoster has
allowed me the ability to create a new db
user... I have NO IDEA how to work that
program. *sigh* Know of any place that
has a walk-thru type thing?

Thanks =o)


0

Response Number 7
Name: anonproxy
Date: November 2, 2003 at 10:37:22 Pacific

Response Number 8
Name: TeeTee
Date: November 2, 2003 at 19:22:50 Pacific
Reply:

Thanks but before I attempt installing phpMyAdmin and learn the howtos... is there an alternative way to check and see if I literally "can" access the database and have the appropriate permissions required to run phpBB? My hoster doesn't offer any type of control panel or file manager etc.

Thanks much! =o)


0

Response Number 9
Name: anonproxy
Date: November 2, 2003 at 19:56:10 Pacific
Reply:

Go to your webhost's site and 1) read their support information, 2) send them an email, or 3) call them. If you have database access, they should inform you how to go about getting to it.

Your contract or hosting plan should explicity state whether you have database access or not. If it does not mention it, chances are you do not have it.

Otherwise, get a new webhost. There are so many and the prices are very competitive. You can get great features for under $10/month.


0

Response Number 10
Name: TeeTee
Date: November 2, 2003 at 20:10:42 Pacific
Reply:

1- They offer zero support and have no support FAQ or even general support area. They have no control panel and the file manager doesn't even work.

2- I emailed them initially (months ago) and was told they'd help with setting up/connecting to my database so that I could use phpBB.

3- I emailed them a week ago with this issue only to be told by some other guy: "No support unless you pay $400+/yr." I copied and pasted previous emails from the first guy and was then told, "No, can't help you. Maybe he can help you when he gets back in 2 weeks."

4- Then just yesterday, I could finally connect to the database but now I can't write to it.

5- I've looked for other hosts and believe me, I am getting a new one ASAP. Lunarpages seems cool.

For sh*ts and giggles I'll email them again and tell 'em, "set permissions to allow me to config tables please."

Ugh... Sorry, just trying to figure other ways around this issue because I prepaid my hosting until March.

Thanks.


0

Sponsored Link
Ads by Google
Reply to Message Icon






Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: Help with: php, MySQL, database

HELP WITH website programming.... www.computing.net/answers/programming/help-with-website-programming/7575.html

best book for learning PHP/mySQL.?? www.computing.net/answers/programming/best-book-for-learning-phpmysql/13376.html

Help With PHP.....^&( www.computing.net/answers/programming/help-with-phpamp/6474.html