Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > php 显示查询的结果问题

php 显示查询的结果问题

WBOY
Release： 2016-06-23 14:17:52
Original
1368 people have browsed it

PHP MS SQL

我用PHP连接到MSSQL，然后用
$sql=" exec Report_a2013zhou_kpsfpout '','2013-1-1','2013-1-31','','','',''";
这个语句执行存储过程，发现显示的结果不完整，比我在数据库里查询分析器里面直接执行显示出来结果少了将近1000多条，我在数据库查出来的有6000多行，在网页上查询很慢，等了半天就出来5000多行，
请问这是什么原因，是不是网页在执行存储过程上对行数和查询耗时上有限制

回复讨论(解决方案)

等了半天... 显然一次显示这么多行浏览器吃不消
分批来显示不就可以了

问题我自己解决了 是我自己的页面超过了PHP.ini文件甚至的8M的现在， 我把它改成20就可以正常显示了

Related labels：
php 显示查询的结果问题
source：php.cn
Previous article：一个php页面多个分页共存 Next article：成员属性在两个方法之间无法共用
Statement of this Website
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
Latest Articles by Author
Latest Issues
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
The question is still the same, but the title is rewritten as follows: My Javascript random function fails to generate valid responses I'm making a simple random number generator game using JS and HTML. In this game you can s...
From 2024-04-03 22:03:14
0
1
275
Content overflow in window prevents scrolling and hides new content I'm currently building a roulette system program (this is more to stop me from placing bet...
From 2024-04-03 21:24:55
0
1
285
Is there any way to recover my PHP files? I'm using VisualStudioCode for coding but my PHP file is now corrupted and 70% of the code...
From 2024-04-03 11:28:59
0
1
291
PHP question: Problem converting pdo column value to string Essentially, I'm using pdo to run the following query and format the results into JSON. Th...
From 2024-04-03 00:18:38
0
1
412
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template