[phalbachjr]

I'm new to php so I need help from anyone who knows what they are doing.

I've created a simple database to collect names and email addresses from those who want to receive an email from me. I have set up the db but I cannot get my webform to connect with the database. Below is the code I'm using but all that I get is "Page can not be found". I have blocked out the password for the database.

THANK YOU!!!!

<?php
$username = "a5134213_pth";
$password = "****";
$hostname = "http://mysql13.000webhost.com";

//connection to the database
$conn=mysql_connect ("http://mysql13.000webhost.com", "a5134213_pth", "****") or die ('I cannot connect to the database because: ' . mysql_error());
mysql_select_db ("a5134213_emad");

//select a database to work with
$selected = mysql_select_db("a5134213_emad")
or die("Could not select that database");



$data = "INSERT INTO email (name,address) VALUES ('$name', '$address')";



echo "Your Information Has Been Added";

$insert = "INSERT INTO table (name, address)
VALUES ('".$name."','".$address."')";

?>

[d3iti]

You can try change $hostname.

Where you are writed "http://mysql13.000webhost.com" you can write "mysql13.000webhost.com"

You could talk what error is you getting.

[phalbachjr]

Thank you very much for taking a look at this for me.

I have made the change in the hostname but it still comes up as page not found "HTTP 404". Any clue as to what else I'm doing wrong?

I have read other posts where people can not connect to a db and some of the replies have been to use the IP address since some servers have DNS issues. I don't know what teh IP address is for mysql13.000webhost.com.

[d3iti]

Hi phalbackhjr,

If you have a 404 probably the problem is elsewhere.

If the mistake was connecting to the server for the database you would get the error that you have set in your code "I cannot connect to the database because:..."
and if not found the table in your database would get the other error that you put in your code "Could not select that database".

The error 404 is "web page not found", which has little to do with the error of connection to the database. Check your file name and where you saved it.

[spiritnhiding]

Have you tried just putting $hostname = "localhost"; instead of the actual host link? May help depending on your files you have uploaded.

[Bad Karma[CORE]]

"localhost" won´t work as you need to specify the actual servername (mysql*.000webhost.com).

* stands for the number of the mysql server you have to use, which one it is can be found in your control panel under "MySQL"

[spiritnhiding]

Not precisely correct, I run a game, and have used localhost instead of the actual server name, so you said it wouldnt work that is wrong!

[Bad Karma[CORE]]

Originally Posted by spiritnhiding

Not precisely correct, I run a game, and have used localhost instead of the actual server name, so you said it wouldnt work that is wrong!

If hosting a site here you will have to use the correct mysql server name as localhost does not work. Therefore the answer i gave was correct.

[phalbachjr]

Great, I figured out why I was getting the HTTP 404 error and have corrected that. Thank again.

Now I run the form, input some data and I receive the message "Your Information Has Been Added" but there are no records inserted into my database when I go back and check it. I am not receiving any error messages but its not connecting.

Thank again for looking at this for me. I'm new to this and I have no idea what I'm doing.

[Bad Karma[CORE]]

maybe because you don´t actually execute the query? Shouldn´t there be a line like

PHP Code:

mysql_query($data) 


?