TP增删改

增加数据

<?php

namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller {

	public function add(){

		$db = D("Info");

		//1.使用数组方式

		$arr =

		array("Code"=>"p005","Name"=>"妈拉巴子"

		,"Sex"=>1,"Nation"=>"n003","Birthday"=>"1999-02-03");

		$db->add($arr);

		//2.使用映射的方式

		$db->Code = "P006";

		$db->Name = "你妹";

		$db->Sex = 1;

		$db->Nation = "C004";

		$db->Birthday = "1996-03-04";

		$db->add();

	}

}

TP增删改

自动收集表单的方法

首先在index文件夹中新建一个add文件 TP增删改

<!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=utf-8" />

	<title></title>

</head>

<body>

<form action="__ACTION__" method="post">

	<div>代号：<input type="text" name="Code"/></div>

	<br/>

	<div>姓名：<input type="text" name="Name"/></div>

	<br/>

	<div>性别：

		<input type="radio" name="Sex" value="1"/>男

		<input type="radio" name="Sex" value="0"/>女

	</div>

	<br/>

	<div>民族：

		<select name="Nation">

			<foreach name="arr" item="v">

				<option value="{$v.code}">{$v.name}</option>

			</foreach>

		</select>

	</div>

	<br/>

	<div>生日：<input type="text" name="Birthday"/></div>

	<br/>

	<input type="submit" value="添加"/>

</form>

</body>

</html>

<?php

namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller {

    public function index(){;

	   $this->assign("d","134212534");;

    }

	public function add(){

		$db = D("Info");

		//3.自动收集表单

		if(empty($_POST)){

			$arr = $db

			->table("Nation")

			->select();

			$this->assign("arr",$arr);

			$this->show();

		}else{

			$db->create();//收集表单

			$db->add();

		}

	}

}

TP增删改 ========

修改数据

<!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=utf-8" />

	<title></title>

</head>

<body>

<form action="__ACTION__" method="post">

	<div><input type="text" name="Code" value="{$info.code}" hidden="hidden"/></div>

	<div>姓名：<input type="text" name="Name" value="{$info.name}"/></div>

	<div>性别：

		<if condition="$info.sex=='1'">

			<input type="radio" name="Sex" value="1" checked="checked"/>男

			<input type="radio" name="Sex" value="0"/>女

		<else/>

			<input type="radio" name="Sex" value="1"/>男

			<input type="radio" name="Sex" value="0" checked="checked" />女

		</if>

	</div>

	<div>民族：

		<select name="Nation">

			<foreach name="nation" item="v">

				<if condition="$v['code']==$info['nation']">

					<option value="{$v.code}" selected="selected" >{$v.name}</option>

				<else/>

					<option value="{$v.code}" >{$v.name}</option>

				</if>

			</foreach>

		</select>

	</div>

	<div>生日：<input type="text" name="Birthday" value="{$info.birthday}"/></div>

	<input type="submit" value="修改"/>

</form>

</body>

</html>

<?php

namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller {

    public function index(){;

	   $this->assign("d","134212534");;

    }

	public function add(){

		$db = D("Info");

		//3.自动收集表单

		if(empty($_POST)){

			$arr = $db

			->table("Nation")

			->select();

			$this->assign("arr",$arr);

			$this->show();

		}else{

			$db->create();//收集表单

			$db->add();

		}

	}

	public function update(){

		$db = D("Info");

		$code = "p002";

		if(empty($_POST)){

			$nation = $db

			->table("Nation")

			->select();

			$info = $db

			->find($code);

			$this->assign("info",$info);

			$this->assign("nation",$nation);

			$this->show();

		}else{

			$db->create();

			$db->save();

		}

	}

}

TP增删改 ========

删除数据

<?php

namespace Home\Controller;

use Think\Controller;

class IndexController extends Controller {

    public function index(){;

	   $this->assign("d","134212534");;

    }

	public function add(){

		$db = D("Info");

		//3.自动收集表单

		if(empty($_POST)){

			$arr = $db

			->table("Nation")

			->select();

			$this->assign("arr",$arr);

			$this->show();

		}else{

			$db->create();//收集表单

			$db->add();

		}

	}

	public function update(){

		$db = D("Info");

		$code = "p002";

		if(empty($_POST)){

			$nation = $db

			->table("Nation")

			->select();

			$info = $db

			->find($code);

			$this->assign("info",$info);

			$this->assign("nation",$nation);

			$this->show();

		}else{

			$db->create();

			$db->save();

		}

	}

	public function del(){

		//$code = "p006";

		$db = D("Info");

		//$db->delete($code);

		$sql = "delete from info where code = 'p004'";

		$db->execute($sql);

		//这里也适用于sql原生语句，增删改用execute 查用query

	}

}

相关文章