Problems with mysql_connect()
| From: | Delta Storm | Date: | Wed, 10 Jan 2007 10:45:15 +0000 |
| Subject: | Problems with mysql_connect() | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-246833@lists.php.net to get a copy of this message | ||
Hi,
I'm having problems with this code (a simple exercise where i wanto to connect to sql server and get data from it and write that data in html)
:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Exercise 23 - Using PHP with MySQL</title>
</head>
<body>
<?php
//Povezuje se s MySQL serverom
$connection = mysql_connect('localhost','user','pass') or die ("Unable to connect to MySQL server");
//Odabira bazu podataka
mysql_select_db("php1") or die ("Unable to select database");
//Pravi i zadaje upit
$query = "SELECT * FROM items";
$result = mysql_query($query) or die ("Error in query: $query ." . mysql_error());
//Provjerava jeli li zapisi vraceni
if (mysql_num_rows($result) > 0)
{
//Pravi html tablicu
echo "<table width=100% cellpadding=10 cellspacing=0 border=1>";
echo "<tr>
<td>
<b>ID</b>
</td>
<td>
<b>Name</b>
</td>
<td>
<b>Price</b>
</td>
</tr>";
//Prolazi kroz skup zapisa
//ispisuje svako polje
while ($row = mysql_fetch_row($result)
{
echo "<tr>";
echo "<td>" . $row [0] ."</td>";
echo "<td>" . $row [1] ."</td>";
echo "<td>" . $row [2] ."</td>";
echo "</tr>";
}
echo "</table>";
}
else
{
//Ispisuje poruku o gresci
echo "No rows found!";
}
//Kad je obrada gotova oslobada skup rezultata
mysql_free_result($result);
//Prekida vezu s MySQL serverom
mysql_close($connection);
?>
</body>
</html>
the error is : "Parse error: parse error, unexpected '{' in C:\Program Files\XAMPP\xampp\htdocs\test_folder\exercise23.php on line 41"
I really dont know why is this error showing i looked for syntax errors but i think that there aren't any
Thanks in advance! :)
(P.S dont read the commnents they are croatian)