search
HomeBackend DevelopmentPHP TutorialTinkPHP+EasyUI,json怎么条件查询数据库?先谢谢了!

href:'__URL__/sblog/id/'+idd,


//$json为NULL输出模板。为1时输出列表数据到前端,格式为Json	public function sblog($json=NULL,$id=NULL){		if(!is_int((int)$json)){			$json = NULL;		}                //dump($id);  这里能显示ID为16		if($json==1){			$sblog = M('Sbly_table');			//$id = intval($id);			//$info = $sblog->order('id desc')->where('lj_sbid='.$id)->select();			$info = $sblog->order('id desc')->select();			$new_info = array();			foreach($info as $t){				if($t['lj_ly_zt']==1){					$t['lj_ly_zt'] = '开启';				}else{					$t['lj_ly_zt'] = '关闭';				}				$new_info[] = $t;			}			echo json_encode($new_info);			unset($sblog,$info,$new_info);		}else{			$this->display();		}		unset($Public);    }


$json=1时, 输出如下3条内容:

[{"id":"38","user_id":"1","title":"001","lj_sbid":"16"},{"id":"36","user_id":"1","title":"002","lj_sbid":"18"},
{"id":"34","user_id":"1","title":"003","lj_sbid":"17"}]

<script language="javascript">$(function(){	var th = $(".top").height();	th = 111-th;	var wh = $(window).height()-th;		$("#Sblog").datagrid({		//title:'列表',			height:wh,		autoRowHeight:true,		singleSelect:true,		striped:true,		rownumbers:true, //显示行号		method:'get',		url:'__ACTION__/json/1, //加载的URL 		pagination:true,//显示分页  		pageSize:5,//分页大小 		pageList:[5,10,15,20],//每页的个数		//fit:true,//自动补全		fitColumns:true,		nowrap:Number('{$TC.config.DATA_NOWRAP}'),		onBeforeLoad: function () {  					},		toolbar:[ //工具条 		{			iconCls: 'icon-reload',			text : '刷新',			handler: function(){ //回调函数  				$("#Sblog").datagrid('reload');			}		}		],		columns:[[   		    {field:'lj_sbid',title:'ID',width:50,align:'center'},			{field:'title',title:'名称',width:250},			{field:'lj_ly_zt',title:'状态',width:100},		]]	});});</script><div class="con" id="SblogCon" onselectstart="return false;" style="-moz-user-select:none;">	<table id="Sblog"></table></div><div id="addSblog"></div>



前端处理后能正确显示3行数据,但是我只想要显示lj_sbid为16的数据,
$info = $sblog->order('id desc')->where('lj_sbid=16')->select();
这样能正确显示lj_sbid为16的一条数据,但是这样:
$info = $sblog->order('id desc')->where('lj_sbid='.$id)->select();
又不能输出?该怎么写才对?先谢谢大家了


回复讨论(解决方案)

理论上写的没什么问题,你可以尝试输出下$id是什么值

order应该在where 后边

$id能输出16,到底是哪里错误呢?

你要的不是$id的值

模板sql语句 语法有问题

你要的不是$id的值

模板sql语句 语法有问题



$id只是条件,语法错误在哪里?请高手指点一下,谢谢主!

dump($id); 贴出结果

dump($id);  

输出:
string(2) "16"

你不是用 EasyUI 吗?
string(2) "16" 在哪里看到的?

TinkPHP+EasyUI  

sblog.htm模板输出的 

用 Volist标签老显示载入中......,改用Foreach标签就OK了

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
PHP Dependency Injection Container: A Quick StartPHP Dependency Injection Container: A Quick StartMay 13, 2025 am 12:11 AM

APHPDependencyInjectionContainerisatoolthatmanagesclassdependencies,enhancingcodemodularity,testability,andmaintainability.Itactsasacentralhubforcreatingandinjectingdependencies,thusreducingtightcouplingandeasingunittesting.

Dependency Injection vs. Service Locator in PHPDependency Injection vs. Service Locator in PHPMay 13, 2025 am 12:10 AM

Select DependencyInjection (DI) for large applications, ServiceLocator is suitable for small projects or prototypes. 1) DI improves the testability and modularity of the code through constructor injection. 2) ServiceLocator obtains services through center registration, which is convenient but may lead to an increase in code coupling.

PHP performance optimization strategies.PHP performance optimization strategies.May 13, 2025 am 12:06 AM

PHPapplicationscanbeoptimizedforspeedandefficiencyby:1)enablingopcacheinphp.ini,2)usingpreparedstatementswithPDOfordatabasequeries,3)replacingloopswitharray_filterandarray_mapfordataprocessing,4)configuringNginxasareverseproxy,5)implementingcachingwi

PHP Email Validation: Ensuring Emails Are Sent CorrectlyPHP Email Validation: Ensuring Emails Are Sent CorrectlyMay 13, 2025 am 12:06 AM

PHPemailvalidationinvolvesthreesteps:1)Formatvalidationusingregularexpressionstochecktheemailformat;2)DNSvalidationtoensurethedomainhasavalidMXrecord;3)SMTPvalidation,themostthoroughmethod,whichchecksifthemailboxexistsbyconnectingtotheSMTPserver.Impl

How to make PHP applications fasterHow to make PHP applications fasterMay 12, 2025 am 12:12 AM

TomakePHPapplicationsfaster,followthesesteps:1)UseOpcodeCachinglikeOPcachetostoreprecompiledscriptbytecode.2)MinimizeDatabaseQueriesbyusingquerycachingandefficientindexing.3)LeveragePHP7 Featuresforbettercodeefficiency.4)ImplementCachingStrategiessuc

PHP Performance Optimization Checklist: Improve Speed NowPHP Performance Optimization Checklist: Improve Speed NowMay 12, 2025 am 12:07 AM

ToimprovePHPapplicationspeed,followthesesteps:1)EnableopcodecachingwithAPCutoreducescriptexecutiontime.2)ImplementdatabasequerycachingusingPDOtominimizedatabasehits.3)UseHTTP/2tomultiplexrequestsandreduceconnectionoverhead.4)Limitsessionusagebyclosin

PHP Dependency Injection: Improve Code TestabilityPHP Dependency Injection: Improve Code TestabilityMay 12, 2025 am 12:03 AM

Dependency injection (DI) significantly improves the testability of PHP code by explicitly transitive dependencies. 1) DI decoupling classes and specific implementations make testing and maintenance more flexible. 2) Among the three types, the constructor injects explicit expression dependencies to keep the state consistent. 3) Use DI containers to manage complex dependencies to improve code quality and development efficiency.

PHP Performance Optimization: Database Query OptimizationPHP Performance Optimization: Database Query OptimizationMay 12, 2025 am 12:02 AM

DatabasequeryoptimizationinPHPinvolvesseveralstrategiestoenhanceperformance.1)Selectonlynecessarycolumnstoreducedatatransfer.2)Useindexingtospeedupdataretrieval.3)Implementquerycachingtostoreresultsoffrequentqueries.4)Utilizepreparedstatementsforeffi

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

MinGW - Minimalist GNU for Windows

MinGW - Minimalist GNU for Windows

This project is in the process of being migrated to osdn.net/projects/mingw, you can continue to follow us there. MinGW: A native Windows port of the GNU Compiler Collection (GCC), freely distributable import libraries and header files for building native Windows applications; includes extensions to the MSVC runtime to support C99 functionality. All MinGW software can run on 64-bit Windows platforms.

Dreamweaver Mac version

Dreamweaver Mac version

Visual web development tools

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment