יש בעיה עם התו הזה:
הנה השגיאה:
ציטוט:
|
Parse error: syntax error, unexpected '}' in /home/half/domains/half-life.co.il/public_html/sql/dbcreate.php on line 57
|
הקוד:
PHP קוד:
<?php
$connection = mysql_connect("localhost","DBNAME","DBPASS")
or die ("Couldn't connect to server");
$query = "CREATE DATABASE IF NOT EXISTS DBNAME";
$result = mysql_query($query)
or die("Query failed: " . mysql_error());
$db = mysql_select_db("DBNAME", $connection)
or die ("Couldn't select database");
if(isset($name) && isset($_POST["number"])) {
$name = mysql_real_escape_string($_POST["name"]);
$number = mysql_real_escape_string($_POST["number"]);
$query = "INSERT INTO `reg` (name, number) VALUES('{$name}', '{$number}')";
$result = mysql_query($query)
or die("Query failed: " . mysql_error());
header("Location: ?");
die();
}
?>
<HTML>
<HEAD>
<TITLE>
שליפת נתונים מתוך טבלה
</TITLE>
</HEAD>
<BODY>
<CENTER>
<H1>שליפת נתונים מתוך טבלה</H1>
<?php
$query = "SELECT * FROM reg";
$result = mysql_query($query)
or die("Query failed: " . mysql_error());
echo <<<HTML
<TABLE BORDER='1'>
<TR>
<TH>Name</TH><TH>Number</TH>
</TR>
HTML;
while ($row = mysql_fetch_assoc($result))
{
echo <<<HTML
<TR>
<TD>{$row['name']}</TD><TD>{$row['number']}</TD>
</TR>
HTML;
}
echo <<<HTML
</TABLE>
HTML;
mysql_close($connection);
?>
</CENTER>
</BODY>
</HTML>