<?php
require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);if(!$db_server) die("Unable to connect to MySQL: " .mysql_error());mysql_select_db($db_database, $db_server)
or die("Unable to select database: " . mysql_error());if (isset($_POST['author']) &&
isset($_POST['title']) &&
isset($_POST['category']) &&
isset($_POST['year']) &&
isset($_POST['isbn']))
{
$author = get_post('author');
$title = get_post('title');
$category = get_post('category');
$year = get_post('year');
$isbn = get_post('isbn');
if (isset($_POST['delete']) && $isbn != "")
{
$query = "DELETE FROM classics WHERE isbn='$isbn'";
if (!mysql_query($query, $db_server))
echo "DELETE failed: $query<br />" .
mysql_error() . "<br /><br />";
}
else
{
$query = "INSERT INTO classics VALUES" .
"('$author', '$title', '$category', '$year', '$isbn')";
if (!mysql_query($query, $db_server))
echo "INSERT failed: $query<br />" .
mysql_error() . "<br /><br />";
}
}
echo <<<_END
<form action="sqltest.php" method="post"><pre>
Author <input type="text" name="author" />
Title <input type="text" name="title" />
Category <input type="text" name="category" />
Year <input type="text" name="year" />
ISBN <input type="text" name="isbn" />
<input type="submit" value="ADD RECORD" />
</pre></form>
_END;
$query = "SELECT * FROM classics";
$result = mysql_query($query);if (!$result) die ("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);
for ($j = 0 ; $j < $rows ; ++$j)
{
$row = mysql_fetch_row($result);
echo <<<_END
<pre>
Author $row[0]
Title $row[1]
Category $row[2]
Year $row[3]
ISBN $row[4]
</pre>
<form action="sqltest.php" method="post">
<input type="hidden" name="delete" value="yes" />
<input type="hidden" name="isbn" value="$row[4]" />
<input type="submit" value="DELETE RECORD" /></form>
_END;
}
mysql_close($db_server);
function get_post($var)
{
return mysql_real_escape_string($_POST[$var]);
}
?>就是结尾最后一行左边有个小红叉,说是:unexpected eof为啥?对的啊?
require_once 'login.php';
$db_server = mysql_connect($db_hostname, $db_username, $db_password);if(!$db_server) die("Unable to connect to MySQL: " .mysql_error());mysql_select_db($db_database, $db_server)
or die("Unable to select database: " . mysql_error());if (isset($_POST['author']) &&
isset($_POST['title']) &&
isset($_POST['category']) &&
isset($_POST['year']) &&
isset($_POST['isbn']))
{
$author = get_post('author');
$title = get_post('title');
$category = get_post('category');
$year = get_post('year');
$isbn = get_post('isbn');
if (isset($_POST['delete']) && $isbn != "")
{
$query = "DELETE FROM classics WHERE isbn='$isbn'";
if (!mysql_query($query, $db_server))
echo "DELETE failed: $query<br />" .
mysql_error() . "<br /><br />";
}
else
{
$query = "INSERT INTO classics VALUES" .
"('$author', '$title', '$category', '$year', '$isbn')";
if (!mysql_query($query, $db_server))
echo "INSERT failed: $query<br />" .
mysql_error() . "<br /><br />";
}
}
echo <<<_END
<form action="sqltest.php" method="post"><pre>
Author <input type="text" name="author" />
Title <input type="text" name="title" />
Category <input type="text" name="category" />
Year <input type="text" name="year" />
ISBN <input type="text" name="isbn" />
<input type="submit" value="ADD RECORD" />
</pre></form>
_END;
$query = "SELECT * FROM classics";
$result = mysql_query($query);if (!$result) die ("Database access failed: " . mysql_error());
$rows = mysql_num_rows($result);
for ($j = 0 ; $j < $rows ; ++$j)
{
$row = mysql_fetch_row($result);
echo <<<_END
<pre>
Author $row[0]
Title $row[1]
Category $row[2]
Year $row[3]
ISBN $row[4]
</pre>
<form action="sqltest.php" method="post">
<input type="hidden" name="delete" value="yes" />
<input type="hidden" name="isbn" value="$row[4]" />
<input type="submit" value="DELETE RECORD" /></form>
_END;
}
mysql_close($db_server);
function get_post($var)
{
return mysql_real_escape_string($_POST[$var]);
}
?>就是结尾最后一行左边有个小红叉,说是:unexpected eof为啥?对的啊?
解决方案 »
- 谁用phpmailer做个群发邮件吗?
- apache vs iis的区别(主要是rewrite_mod)
- 读取CSV文件后存入数据库,会多出很多条空记录
- 在线等待:如何缓存数据库连接呀?
- 请求Smarty的使用问题?
- 怎样才能在能实现ftp绝对路径的隐藏呢?多多指教
- 新建的PHP+MYSQL+IIS,请问怎么连到MYSQL
- php4.3.1+apache2.0.45+mysql4 linux下的整合
- 如何 在 文本框中輸入內容時,獲得 輸入的文本內容,並到 MySql 中查詢是否有,字段的值與其相同的記錄,並返回查詢結果((急))
- 如何在表格中添加表单,并提交MYSQL数据库
- 求教一个mysql中set数据类型的问题。
- 提取网页源码中<div id="article_content" class="article_content"></div>之间的内容
{
$row = mysql_fetch_row($result);
echo <<<_END
<pre>
Author $row[0]
Title $row[1]
Category $row[2]
Year $row[3]
ISBN $row[4]
</pre>
<form action="sqltest.php" method="post">
<input type="hidden" name="delete" value="yes" />
<input type="hidden" name="isbn" value="$row[4]" />
<input type="submit" value="DELETE RECORD" /></form>
_END;//这个要顶格写。。
}
heredoc结束的地方要顶格写。
Unable to connect to MySQL: Access denied for user 'username'@'localhost' (using password: YES)为何?我的root user设置了密码的。是这个原因?
我该如何修改我的eclipse设置吗?谢谢