第三十三节 php操作数据库：创建编辑删除数据

	
	        <?php foreach ($model as $item) : ?>
	            <tr>
	                <td><a href="edit.php?id=<?=$item->id?>">编辑</a></td>
	                <td><?= $item->term ?></td>
	                <td><?= $item->definition ?></td>
	                <td><a href="delete.php?id=<?=$item->id?>">删除</a></td>
	            </tr>
	          <?php endforeach; ?>

    <form action="" method="POST">
      <input type="hidden" name="id" value="<?= $model->id ?>" />
      <div class="form-group">
        <label for="term">词汇：</label>
        < input class="form-control" type="text" name="term" id="term" value="<?= $model->term ?>" />
      </div>
      <div class="form-group">
        <label for="definition">词汇内容：</label>
        < textarea class="form-control" name="definition" id="definition"><?= $model->definition; ?></ textarea> 
      </div>
      <div class="form-group">
        < input type="submit" value="编辑词汇" />
      </div>
    </form>

    <form action="" method="POST">
      <input type="hidden" name="id" value="<?= $model->id?>" />
      <div class="form-group">
        < input type="submit" value="删除词汇" />
      </div>
    </form>

	if (is_get()) {
		$key = sanitize($_GET['id']);
	
	}
	
	if (is_post()) {
		$term = sanitize($_POST['id']);
	
	}

if (is_get()) {
	$key = sanitize($_GET['id']);
}
if (is_post()) {
	$term = sanitize($_POST['term']);
	$definition = sanitize($_POST['definition']);
	$id = sanitize($_POST['id']);
	
	if (empty($term) || empty($definition) || empty($id)) {
		//TODO:显示信息
	} else {
		$config['provider']->update_term($id, $term, $definition);
		redirect('index.php');
	}
}

	public function add_term($term, $definition){
		$db = $this->connect();
		if ($db === null) {
			return [];
		}
		$sql = 'INSERT INTO phrases_terms (term, definition) VALUES (:term, :definition)';
		$stmt = $db->prepare($sql);
		$stmt->execute([':term'=> $term, ':definition'=> $definition ]);
		$stmt = null;
		$db = null;
	}

	public function update_term($id, $term,$definition){
		$db = $this->connect();
		if ($db === null) {
			return;
		}
		$sql = 'UPDATE phrases_terms SET term = :term, definition = :definition WHERE id = :id';
		$stmt = $db->prepare($sql);
		$stmt->execute([':term'=> $term, ':definition'=> $definition, ':id'=> $id ]);
		$stmt = null;
		$db = null;
	}

	public function delete_term($id){
		$db = $this->connect();
		if ($db === null) {
			return [];
		}
		$sql = 'DELETE FROM phrases_terms WHERE id = :id';
		$stmt = $db->prepare($sql);
		$stmt->execute([':id'=> $id]);
		$stmt = null;
		$db = null;
	}