想数据库里面存数据存不进去

来源：5-3 利用model-save做分类数据保存

weixin_慕容4171762

2019-04-18

#html页面

{include file=“public/header” /}

*生活服务分类名称：

*分类栏目：

一级分类

				<option value=""></option>
				
			</select>
			</span>
		</div>
	</div>
	
	<div class="row cl">
		<div class="col-xs-8 col-sm-9 col-xs-offset-4 col-sm-offset-2">
			<button  type="submit" class="btn btn-primary radius" ><i class="Hui-iconfont">&#xe632;</i> 保存</button>
			
			<button onClick="layer_close();" class="btn btn-default radius" type="button">&nbsp;&nbsp;取消&nbsp;&nbsp;</button>
		</div>
	</div>
</form>

{include file="public/footer" /}

#存储方法
public function save() {
$data = input(‘post.’);
$v a l i d a t e = v a l i d a t e (^{'} C a t e g o r y^{'}); i f (!$ validate->scene(‘add’)->check($data)) {
$t h i s - > e r r o r ($ validate->getError());
}

    return model('Category')->add($data);

}

#模块方法

<?php namespace app\common\model; use think\Model; class Category extends Model { public function add($data){ $data['status']=1; $data['create_time']=time(); return $this->save($data); } } #报错信息数据表字段不存在:[parent_id] } else { $fields = $options['field']; } $result = []; foreach ($data as $key => $val) { $item = $this->parseKey($key, $options); if (!in_array($key, $fields, true)) { if ($options['strict']) { throw new Exception('fields not exists:[' . $key . ']'); } } elseif (isset($val[0]) && 'exp' == $val[0]) { $result[$item] = $val[1]; } elseif (is_null($val)) { $result[$item] = 'NULL'; } elseif (is_scalar($val)) { // 过滤非标量数据 if ($this->query->isBind(substr($val, 1))) { $result[$item] = $val; Call Stack in Builder.php line 95 at Builder->parseData(['name' => '1', 'parent_id' => '0', 'status' => 1, ...], ['table' => 'o2o_category', 'where' => [], 'field' => '*', ...]) in Builder.php line 624 at Builder->insert(['name' => '1', 'parent_id' => '0', 'status' => 1, ...], ['table' => 'o2o_category', 'where' => [], 'field' => '*', ...], false) in Query.php line 1748 at Query->insert(['name' => '1', 'parent_id' => '0', 'status' => 1, ...]) in Model.php line 711 at Model->save(['name' => '1', 'parent_id' => '0', 'status' => 1, ...]) in Category.php line 12 at Category->add(['name' => '1', 'parent_id' => '0']) in Category.php line 24 at Category->save() at ReflectionMethod->invokeArgs(object(Category), []) in App.php line 232 at App::invokeMethod([object(Category), 'save'], []) in App.php line 397 at App::module(['admin', 'category', 'save'], ['app_namespace' => 'app', 'app_debug' => true, 'app_trace' => false, ...], null) in App.php line 140 at App::run() in start.php line 18 at require('D:\phpStudy\WWW\o2o....') in index.php line 17 Environment Variables GET Dataempty POST Data name 1 parent_id 0 Filesempty Cookiesempty Sessionempty Server/Request Data HTTP_HOST localhost HTTP_USER_AGENT Mozilla/5.0 (Windows NT 10.0; WOW64; rv:45.0) Gecko/20100101 Firefox/45.0 HTTP_ACCEPT text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 HTTP_ACCEPT_LANGUAGE zh-CN,zh;q=0.8,en-US;q=0.5,en;q=0.3 HTTP_ACCEPT_ENCODING gzip, deflate HTTP_REFERER http://localhost/index.php/?s=admin/category/add HTTP_CONNECTION keep-alive CONTENT_TYPE application/x-www-form-urlencoded CONTENT_LENGTH 18 PATH C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;D:\Program Files\Git\cmd;C:\Users\dahua.DESKTOP-I3ER4F2\AppData\Local\Microsoft\WindowsApps;C:\Users\dahua.DESKTOP-I3ER4F2\AppData\Local\GitHubDesktop\bin SystemRoot C:\Windows COMSPEC C:\Windows\system32\cmd.exe PATHEXT .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC WINDIR C:\Windows SERVER_SIGNATURE SERVER_SOFTWARE Apache/2.4.23 (Win32) OpenSSL/1.0.2j PHP/5.4.45 SERVER_NAME localhost SERVER_ADDR ::1 SERVER_PORT 80 REMOTE_ADDR ::1 DOCUMENT_ROOT D:/phpStudy/WWW/o2o.singwa.com/public REQUEST_SCHEME http CONTEXT_PREFIX CONTEXT_DOCUMENT_ROOT D:/phpStudy/WWW/o2o.singwa.com/public SERVER_ADMIN admin@phpStudy.net SCRIPT_FILENAME D:/phpStudy/WWW/o2o.singwa.com/public/index.php REMOTE_PORT 55133 GATEWAY_INTERFACE CGI/1.1 SERVER_PROTOCOL HTTP/1.1 REQUEST_METHOD POST QUERY_STRING REQUEST_URI /index.php/admin/category/save.html SCRIPT_NAME /index.php PATH_INFO /admin/category/save.html PATH_TRANSLATED redirect:\index.php\admin\category\save.html\category\save.html PHP_SELF /index.php/admin/category/save.html REQUEST_TIME_FLOAT 1555586193.261 REQUEST_TIME 1555586193 Environment Variablesempty ThinkPHP Constants APP_DEBUG true APP_PATH D:\phpStudy\WWW\o2o.singwa.com\public/../application/ THINK_VERSION 5.0.3 THINK_START_TIME 1555586193.2681 THINK_START_MEM 153280 EXT .php DS \ THINK_PATH D:\phpStudy\WWW\o2o.singwa.com\thinkphp\ LIB_PATH D:\phpStudy\WWW\o2o.singwa.com\thinkphp\library\ CORE_PATH D:\phpStudy\WWW\o2o.singwa.com\thinkphp\library\think\ TRAIT_PATH D:\phpStudy\WWW\o2o.singwa.com\thinkphp\library\traits\ ROOT_PATH D:\phpStudy\WWW\o2o.singwa.com\ EXTEND_PATH D:\phpStudy\WWW\o2o.singwa.com\extend\ VENDOR_PATH D:\phpStudy\WWW\o2o.singwa.com\vendor\ RUNTIME_PATH D:\phpStudy\WWW\o2o.singwa.com\runtime\ LOG_PATH D:\phpStudy\WWW\o2o.singwa.com\runtime\log\ CACHE_PATH D:\phpStudy\WWW\o2o.singwa.com\runtime\cache\ TEMP_PATH D:\phpStudy\WWW\o2o.singwa.com\runtime\temp\ CONF_PATH D:\phpStudy\WWW\o2o.singwa.com\public/../application/ CONF_EXT .php ENV_PREFIX PHP_ IS_CLI false IS_WIN true

写回答

1回答