I tried your code (using my own password, username, and dbname). It works on my localhost.

Make sure that you are connecting to the right database and the user and password you're using have access to that database. Did you contact your host for the username, password, and database name?

There really is no other error possible besides the values. I can't provide you with those variables.

Can you access phpMyAdmin?

Yheahh , why?

You can make a test database from there so you can get the database name right. Then add user access.

OR here's a walkthrough...

1. Open your phpmyadmin. The layout has two 'panes'.
2. In the right pane, there is an option to create new database. Type in the name of your sample database there (say, secret-database).
3. Then ignore the other options and just click on the Create button. Your new database will now show-up in the left-pane as secret-database (0) --- this means there are no tables (yet) in your database.

Next, let's add a user to the database.
1. Go back to the phpMyAdmin home page. On the right pane, click on Privileges (it's in the bunch of links below the Create New Database field).
2. You'll see a list of usernames there but let's try and make a new one for now... Click on the Add a new user link.
3. Now type the username you want (ie secret-user).
4. For the host, select Local from the dropdown menu and it will automatically fill-up the text-field.
5. For the password, you choose. =p For this example let's use badpassword.
6. Re-type the password.
7. Ignore the global privileges and just click GO.
8. You'll be sent to a new page (with the Global privileges section) but ignore that and scroll-down to database-specific privileges. On the drop-down menu, Add privileges on the following database: choose secret-database.
9. Then check all the boxes under data (select, insert, update, delete) and at least these three under structure (create, alter, drop).
10. Click Go.


In your dbConfig.php file, use the following values:

Of course, you have to change the values to those you created yourself.

huh? i don't understand u :O

You said you can access phpMyAdmin... when I asked about that, I meant, you can go to the phpMyAdmin screen which looks like (see the attached screenshot).

phpMyAdmin is sort of a user-friendly interface for working with your databases, it's not your database name.

If you contacted your web host and they told you to use phpMyAdmin, they probably meant that you use that (see screenshot).

Uhmmm i get something else see attachment

Soo Help?

Btw you downloaded phpmyadmin? or something like that?;O

In your attachment, is this the page you see everytime you enter phpMyAdmin? Can you click on the 'house' button in the left panel to get to a similar window like in my attachment? Because if you can't then your host probably limits your access to creating tables only. =(

WAIT ----

I checked the 000webhost website and:
from the hosting site
You should be able to navigate to the phpMyAdmin homepage! (the one in my screenshot)

By the way, how did you make the _secret table? (kindly describe what you did step-by-step) Because if you made it yourself then most likely, you started at the phpMyAdmin screen similar to my attached screenshot...


To answer your second post, yes I have a 'test-server' installed on my laptop. This is actually a good way to practice your php scripts because you can edit stuff without having to upload them to the internet. If you want to do that too, you can download xampp here.

The installer will do the whole installation for you (yey no configuration necessary!) but if you're stuck on some part of the installation you can ask here.

K,, i will test now =)

&& by the way i downloaded "xampp"

&& Installed xD