MYSQL help

[xcaliberse]

Hey, so i created a mysql server, and i jus wanted to make a form that does feedback. so i have this
<script>
<?
$firstname=$_POST['Name'];
$message=$_POST['Message'];


$submit=$_POST['submit'];
if($submit=="Submit"){


$con = mysql_connect("heres the problem","username,"password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("learning_beta", $con);

mysql_query("INSERT INTO Persons (Name, Message)
VALUES ('$firstname', '$lastname')");

echo "DONE";
}

?>

<form method="post">
Firstname: <input type="text" name="Name"><br />
Message: <input type="text" name="Message"> <br />
<input type="submit" name="submit" value="Submit">
</form>
</script>

The problem is, how do i know what the login is? i have hte user name and password but iono the site for the phpMyAdmin login or whatever its suppsoed to be.

[tittat]

******Thread Moved to programming Help******

[xcaliberse]

bump

[vol7ron]

you bumped a thread after being moved 3 mins earlier? haha


it's going to be 'localhost' or possibly 'localhost:5432'


don't forget that your db and username have your x10name in front of it:
xcaliberse_dbname
xcaliberse_username
mySQLpw

[xcaliberse]

I dont think "localhost:5432" or "localhost" is the appropriate thing to use for the mysql hosting link. The link should lead u directly to the phpMyAdmin login page, but any link i try just gets me directly to the control panel login.

[infurTH]

it is bump and it is localhost

[xcaliberse]

So for

$con = mysql_connect("heres the problem","username,"password");

I put "localhost" for "heres the problem"? or no?

[vol7ron]

If you're trying to access MySQL through your code, then yes. <you could have tested it by now>

If you're trying to get to phpMyAdmin, then no. But you're not going to be managing MySQL through phpMyAdmin in your code. You cannot connect to phpMyAdmin using mysql_connect() ~ that's absurd, MySQL is a database, phpMyAdmin is an application to interface the database.

Just use localhost and you will see.

[xcaliberse]

Ok heres my new code

<?
$firstname=$_POST['Name'];
$message=$_POST['Message'];


$submit=$_POST['submit'];
if($submit=="submit"){


$con = mysql_connect("localhost","username","password");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("learning_beta", $con);

mysql_query("INSERT INTO Persons (Firstname, Message)
VALUES ('$firstname', '$message')");

echo "DONE";
}

?>

<form method="post">
Firstname: <input type="text" name="Name"><br />
Message: <input type="text" name="Message"> <br />
<input type="submit" name="submit" value="Submit">
</form>

Okay even if i type in jdkas;lfe instead of localhost, it doesnt give me the die(...); error. And it doesnt save it into the table that i made using phpMyAdmin. Can someone help me? I even manually added something via phpMyAdmin to the table and it doesnt show on the site. its www.kevinliang.x10hosting.com/feedback.php thanks.

[crisp]

In you're script

if($submit=="submit"){

is always going to evaluate to false, because, in your form, the value for submit is "Submit" not "submit". Thus, the db connect and subsequent insert isn't ever going to happen.

Try replacing that line with this instead

if ($submit=="Submit") {

or even

if (strtolower($submit)=="submit") {

and as previously stated by others, localhost is what you should be using for the host name to connect to the db ;)