Help Help

[Kabouter]

Hi Reuben,
I need some help badly,
my database doesn't seems to work.
In Cpanel it's working fine, ( I believe ),
but I can't find it on my site. what am I doing wrong ???
I'm a newbie with SQL and PHP.

greetings Kabouter ;)

[reuben]

Hello,

Your database isn't actually stored in your account, so you won't be able to see it directly. It is stored in our database folder.

[nsr81]

You access a mySQL database not through a folder but in the following manner:

mysql_connect("localhost","username","password");
mysql_select_db("databasename");

[Kabouter]

hi nsr81,

Your right I can access a mySQL database, through telnet in the following manner:

mysql_connect("localhost","username","password");
mysql_select_db("databasename");

but ........ I need to acces it through my homepage, how do I do that ???

greetings Kabouter ;)

[nsr81]

This is the PHP code I use for DB access.


<?
$db_name="DBname";

$connection = @mysql_connect("localhost", "username", "password") or die ('Cannot connect to the database.');
$db = @mysql_select_db($db_name, $connection) or die("Database is unavailable.");
$sql = "INSERT INTO emails (id, email, date) VALUES ('', '$email', NOW(''))";
$result = @mysql_query($sql, $connection) or die("Database is unavailable at the moment.");
?>
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Emails&lt;/title&gt;
&lt;/head&gt;
&lt;body bgcolor="#FFFFFF" text="#000000"&gt;
<?
if($result)
{
echo "<p> Your email has been added successfully to the mailing list. </p>";
}
?>
&lt;/body&gt;
&lt;/html&gt;


All this is stored in "emails.php", which is called from a form like this.


&lt;Form action="emails.php" method="post"&gt;


This page is currently active at www.al-iqbal.org . I'm collecting people's emails through this script. You can also try to go through the source of the main page to see how exactly I use it.

nsr81

[Kabouter]

hi nsr81,
thanks for the reply, I wil certainly have a look and try to learn about it.

greetings Kabouter ;)