 Connecting Php Site To Database |
|
|
|
|
  |
 Sep 22 2007, 11:03 PM
Post
#1
|
|
|
Newbie [Level 1]  Group: Members Posts: 16 Joined: 12-July 07 Member No.: 46,371  |
Please Help Me with this site's error
http://gatewaybiz.x10hosting.com/surf/ |
 |
 
|
|
Sep 22 2007, 11:40 PM
Post
#2
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing.  Group: [MODERATOR] Posts: 3,868 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787  |
No-one here can help you, except to suggest that you check, and confirm with the Hosting company, that you are using the correct user-name and password, and that you are attempting to open the correctly named database.
That is what the error suggests. Answer these questions so we an be of more service to you: What script are you installing? Are you allowed databases on that service? Do they add a prefix to our DB name when you create the DB? Did you include the prefix? |
|
|
|
|
Sep 23 2007, 12:30 AM
Post
#3
|
|
|
Super Member Group: Members Posts: 221 Joined: 6-June 07 Member No.: 44,288 |
yeah, basically just check all your database info like user, password, db name, host, etc
|
|
|
|
|
Sep 23 2007, 04:21 PM
Post
#4
|
|
|
Newbie [Level 1] Group: Members Posts: 16 Joined: 12-July 07 Member No.: 46,371 |
Thank you Guys. Actually my hosting user name is makj and have a db and indeed adds a prefix to my db user name.
I created a db with a named blog and a user name surf. My hosting added the the prefix making the db makj_blog and the username makj_surf. I don't really know whether to include the prefix makj when setting up the script. In the page I showed, I added the prefix makj to it. Should I add the prefix makj to the username or db? I am indeed installing a surfing script http://gatewaybiz.x10hosting.com/surf/ Once again thank you. |
|
|
|
|
Sep 23 2007, 04:37 PM
Post
#5
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. Group: [MODERATOR] Posts: 3,868 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787 |
Add the prefix to both the db-name and the db-user-name.
|
|
|
|
|
Sep 23 2007, 05:28 PM
Post
#6
|
|
|
Newbie [Level 1] Group: Members Posts: 16 Joined: 12-July 07 Member No.: 46,371 |
I very much appreciate this help. thank you and I'll try that but before then, Please take a look at the file that is mentioned in the page ie. require.inc.php and help me with the changes I need to make in
CODE <? global $username; require 'dconn.php'; session_start(); $username = @$_SESSION["username"]; $connection = mysql_connect($db_server, $db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name, $connection) or die(mysql_error()); // A few important variables to set $title = "Gateway SuperSurf"; $motto = "Free hits without the bandwidth"; $siteUrl = "http://gateway.x10hosting.com/surf/"; // remember to include the end slash $contact_email = "support@gateway.x10hosting.com"; $paypal= "mickeyaff@yahoo.com"; $emailFooter = " - You are receiving this email because you are currently a member of ".$title."."; |
|
|
|
|
Sep 24 2007, 08:55 AM
Post
#7
|
|
|
Premium Member Group: Members Posts: 190 Joined: 21-October 05 Member No.: 13,185 |
QUOTE(veightar @ Sep 23 2007, 05:28 PM)  I very much appreciate this help. thank you and I'll try that but before then, Please take a look at the file that is mentioned in the page ie. require.inc.php and help me with the changes I need to make in CODE <? global $username; require 'dconn.php'; session_start(); $username = @$_SESSION["username"]; $connection = mysql_connect($db_server, $db_user,$db_pass) or die(mysql_error()); mysql_select_db($db_name, $connection) or die(mysql_error()); // A few important variables to set $title = "Gateway SuperSurf"; $motto = "Free hits without the bandwidth"; $siteUrl = "http://gateway.x10hosting.com/surf/"; // remember to include the end slash $contact_email = "support@gateway.x10hosting.com"; $paypal= "mickeyaff@yahoo.com"; $emailFooter = " - You are receiving this email because you are currently a member of ".$title."."; how about db_server variable? From what I know, this variable is the one many people have mistaken. You have to confirm with your database server contact, so you can connect them. Or even your user I guess... |
|
|
|
|
Similar Topics
|
Lo-Fi Version | Time is now: 20th July 2008 - 08:34 PM |