connection error

misschristina95

hello all,
I'm back.... I took a short break from my webpage because of the frustration factor that was following me around and starting to invade my dreams!!! You know its not good when all you dream about is errors popping up on your webpage.
So I'm back.
Again, this is my error. I cannot get this thing to connect.
Could not connect: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (46)

And I figured I'd throw up the code for the fun of it. 😉
<?php
$con = mysql_connect("localhost","misschristina95","someday");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE person
(
FirstName varchar(15),
LastName varchar(15),
Age int
)";
mysql_query($sql,$con);mysql_close($con);
?>

So if someone could tell me what I am doing wrong that would be soooo helpful to me. 🙂

Also, a webpage designer told me that I should look into something called joomla? So I downloaded it but it seems like just as much work as this php thing.... and since I've already started learning php I was wondering if it was worth my time to restart and learn joomla? Anybody use Joomla? Is it worth the time?
Thanks for your help,
Christina

laserlight

Did you forget to start your MySQL server?

By the way, please post PHP code in [php][/php] bbcode tags.

misschristina95

How do I start my MySQl server? If you mean did I create a username and password for my database then yes, I did.

Another thing I was thinking might be the problem is that I am using yahoo small business. There is a whole list of PHP that they don't support. So maybe that is the problem? But it just seems that they would defintely support a simple login/logout script.....
Thanks for your help! 🙂

misschristina95

Okay, so I just tried to check my database and it won't let me log on..... nothing happens.... It just reloads the same page which asks for my username and password. I know that its the right username and password, because I just changed it again. Then I changed my code.

I changed up my code a bit. I now have this.
Now I get no error but nothing shows up on the page.... ?

[php

<?php
$con = mysql_connect("mysql","misschristina95","someday");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("db", $con);

$result = mysql_query("SELECT * FROM person ORDER BY age");

while($row = mysql_fetch_array($result))
{
echo $row['FirstName'];
echo " " . $row['LastName'];
echo " " . $row['Age'];
echo "<br />";
}mysql_close($con);
?>

Ashley_Sheridan

If you're getting nothing on the page now, not even an error, then it looks as if you are managing to connect successfully, but that you do not have any data in your person table. It seems that the table does exist, else you would be getting an error pertaining to that. Do you have phpMyAdmin on your server? This is a tool for working with the databases, and it should let you find fully manage a MySQL database, so you can see if your person table does actually have anything in it.