Depends on how you are using it.
In that particular page, you have no code calling it to connect.
Your need to ensure you have a database created.
Are you positive your host isn't localhost? it appears to be so from phpmyadmin.
Username appears ok.
For instance this is my connect script:
Code: Select all
<?php
/**
* DB CONNECT Script For Project:
* @copyright 2008
*/
// form submitted
// set server access variables
$dbhost = 'localhost';
$dbuser = 'groog_admin@localhost';
$dbpass = 'THIS IS NOT FOR YOU';
$db = 'somedb';
// Open Connection
$connect= mysql_connect($dbhost, $dbuser, $dbpass) or die ('Error connecting to mysql');
mysql_select_db($db);
?>
and this is how I call it from within a page:
Code: Select all
<?php
if(!file_exists('db_scripts/_config.inc.php')) die('Fatal Error.');
require_once('db_scripts/_config.inc.php');
$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$sql = "Select * from `user` (`firstname`, `lastname`) VALUES
('$_POST[firstname]','$_POST[lastname]')";
$result = @mysql_query($sql);
if (!mysql_query($sql,$connect))
{
die(mysql_error());
}
?>
<html>
<body>
<form action="<?php $_SERVER['PHP_SELF']; ?>" method="post">
<table class="adding">
<tr>
<th colspan="2"> Create User Account</th>
</tr>
<tr>
<td>
<small>First Name:</small><input type="text" name="firstname" value="<?php if (isset($_POST['firstname'])) echo $_POST['firstname']; ?>" size="25" maxlength="20" /></td></tr>
<tr>
<td> <small>Last Name:</small><input type="text" name="lastname" value="<?php if (isset($_POST['lastname'])) echo $_POST['lastname']; ?>" size="25" maxlength="20" /></td>
</tr>
<tr><th colspan="2">
<input type="submit" name="save" value="Save" /></th></tr>
</table>
<input type="hidden" name="submitted" value="TRUE" />
</form>
</body>
</html>
<?
echo "user account exists";
?>