Schema is:
sqlite> .schema posts
CREATE TABLE posts (
id integer primary_key auto_increment,
title text,
content text
);
......
sqlite> .mode line
sqlite> select id,title, content from posts;
id =
title = title
content = content in here
id =
title = a new title
content = new content
....... My entire index.php. This is supposed to be a trivial example.
// Insert a post into the DB
if (isset($_POST[ title ]) && isset($_POST[ content ])) {
try {
// Fill in the values
$title = $_POST[ title ];
$content = $_POST[ content ];
# echo "title=".$title.", content=".$content;
// Create a prepared statement
$stmt = $db->prepare("INSERT INTO posts (title, content) VALUES (:title, :content);");
$stmt->bindParam( :title , $title);
$stmt->bindParam( :content , $content);
$stmt->execute();
} catch (Exception $e) {
die ($e);
}
}
// Get posts from database
try {
$posts = $db->prepare( SELECT id, title, content FROM posts; );
$posts->execute();
} catch (Exception $e) {
die ($e);
}
?>
<h1>Posts - SQLite Example</h1>
<?php while ($post = $posts->fetchObject() ): ?>
<br/>
<h2><?php echo $post->title ?></h2>
<?php echo $post->content ?>
<a href="<?php echo $_SERVER[ PHP_SELF ]; ?>?action=delete&id=<?php echo $post->id ?>"><br/>Delete Post</a>
<?php endwhile; ?>
<hr />
<h2>Add new Post</h2>
<form action="<?php echo $_SERVER[ PHP_SELF ]; ?>" method="post">
<p>
<label for="title">Title:</label>
<input type="text" name="title" />
</p>
<p>
<textarea name="content" rows="8" cols="50"></textarea>
我的问题是,邮资加特;id是空的,但应该按照目标文件,将账面图绘制成计数变量。
我真的是在试图获得显示的第一行的主要位置,以便添加一个删除链接。
请注意,我可以免费开放、阅读和书写数据库。 所有权和内容也得到适当检索,但Im在从通过fetchObject(目标)归还的物体中找回id场时 st。
看来,这似乎决不会实际上在表的id领域有任何事情。
UPDATE: The response may have been here。 这实际上是一个小问题,而不是一个小问题。