[SOLVED] [NEWBIE] Database help

[boboreo1222]

Do I add that code to the top of Index.php?

[boboreo1222]

When I added it to the top of Index.php, I got

 

 

Warning: main(database/config.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 3

 

Warning: main(database/config.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 3

 

Warning: main(database/config.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 3

 

Warning: main(): Failed opening 'database/config.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bobbykig/public_html/index.php on line 3

 

Warning: main(database/login.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 6

 

Warning: main(database/login.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 6

 

Warning: main(database/login.php): failed to open stream: No such file or directory in /home/bobbykig/public_html/index.php on line 6

 

Warning: main(): Failed opening 'database/login.php' for inclusion (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/bobbykig/public_html/index.php on line 6

[sanfly]

Are you sure you have the directory and paths correct

 

http://www.bobbykingmagic.com/database/config.php

 

gives me a page not found error.....

[boboreo1222]

I have it located in my public_html foder and outside of my public_html folder.

 

It still doesnt work

 

Where do I have to put that?

 

Public_ftp?

[sanfly]

Wait, I see the problem

 

I guess that directory names are case sensitive because I can see a folder called "Database"

 

SO

 

this code

 

<?
ob_start();
include ("database/config.php");
?>
<?
include("database/login.php");
?>

 

should really be this

 

<?
ob_start();
include ("Database/config.php");
?>
<?
include("Database/login.php");
?>

 

does that work?

 

 

[boboreo1222]

Nope

 

All I have on my site now is

 

Warning: mysql_connect(): Unknown MySQL server host 'database' (1) in /home/bobbykig/public_html/Database/config.php on line 3

 

Warning: mysql_select_db(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/bobbykig/public_html/Database/config.php on line 4

 

Warning: mysql_select_db(): A link to the server could not be established in /home/bobbykig/public_html/Database/config.php on line 4

Access denied for user 'nobody'@'localhost' (using password: NO)

 

The rest of my site isnt there

 

DO I ADD IT AT THE TOP OF MY PAGE?

[sanfly]

Great, we're one step closer!

 

Okay, that means that your database connection info is all wrong

 

Are you sure that you set up the mysql database correctly?

 

What program does your webhost use?  Cpanel?

 

Can you please post the content of your config.php file?  remember to remove the username and password before posting it

 

 

[boboreo1222]

Yes.  It uses cPanel

 

<?

  ob_start(); // allows you to use cookies

  $conn = mysql_connect("NAME OF THE DATABAE","USERNAME TO CONNECT","PASSWORD TO CONNECT");

  mysql_select_db(bobbykig_database) or die(mysql_error());

  //fill in the above lines where there are capital letters.

  $logged = MYSQL_QUERY("SELECT * from users WHERE id='$_COOKIE[id]'");

  $logged = mysql_fetch_array($logged);

  //the above lines get the user's information from the database.

?>

[boboreo1222]

Where it LOGGED= MYSQL_QUERY

 

Do I have to put a mySQL Query there

[sanfly]

Okay, go into cpanel, then click on "Manage MySql"

 

On the next page, does it have your database listed under "Current Databases"

 

if yes, have you spelt the database name correctly in your config.php file?

[sanfly]

Where it LOGGED= MYSQL_QUERY

 

Do I have to put a mySQL Query there

 

no, one thing at a time.  We will come to that soon.

[boboreo1222]

Do I have to include the bobbykig_???

[sanfly]

Absolutely YES

 

The same goes if that has been added to your user name

[boboreo1222]

OK.  I added that to my username and database name

 

And it still appears with

Warning: mysql_connect(): Unknown MySQL server host 'bobbykig_database' (1) in /home/bobbykig/public_html/Database/config.php on line 3

Warning: mysql_select_db(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/bobbykig/public_html/Database/config.php on line 4

Warning: mysql_select_db(): A link to the server could not be established in /home/bobbykig/public_html/Database/config.php on line 4
Access denied for user 'nobody'@'localhost' (using password: NO)

[per1os]

You were mis informed my friend

 

<?php
<?
mysql_connect("hostname", "username", "password"); // ntoes hostname should be "localhost"
mysql_select_db("dbname");

?>

 

www.php.net/mysql_connect

www.php.net/mysql_select_db

[sanfly]

THis line here

 

$conn = mysql_connect("NAME OF THE DATABAE","USERNAME TO CONNECT","PASSWORD TO CONNECT");

 

should be this

 

$conn = mysql_connect("localhost","USERNAME TO CONNECT","PASSWORD TO CONNECT");

[boboreo1222]

Yes!!!!!!!!!!!!!!

 

That worked!

 

But I clicked on "Register Here"

 

And it said "Page cannot be found"

 

and is there still more of config.php we need to fix

 

[sanfly]

*Bangs head against wall*

 

Thats because you have the wrong link!  it should be http://www.bobbykingmagic.com/Database/register.php, but you have http://www.bobbykingmagic.com/register.php

 

Thats it, I'm done!

[boboreo1222]

I have fixed that problem

 

Now, when I go to click login, I click it and nothing happens

 

It isnt going anywhere.  It is just a button.