我有这样的代码,基本上找到了产品的下一个零件号,这是在我们的服务器上,它一直工作得很好。我把它移到了我的新电脑(mac)上,不知什么原因,代码停止了工作。我所有的数据库都连接正常,我的文件都放在正确的地方,但是由于某些原因,我在盒子里发现了这个错误-
致命错误:在第34行的/applications/mamp/htdocs/app/part number/part\u number.php中对boolean上的成员函数fetch\u assoc()调用
下面是引用错误的代码。。
//------new Database Connection for querying product numbers--------//
$mysqli2 = new mysqli("localhost", "testing", "testing", "testing");
//----------ABC Next Number Generator-----------/
$abc_query = "SELECT min(code) as POSSIBLE_MIN_ID
FROM
(
SELECT concat('ABC', lpad(num,3,'0')) as code
FROM
(
SELECT a.x + b.x * 2 + c.x * 4 + d.x * 8 + e.x * 16 + f.x * 32 +
g.x * 64 + h.x * 128 + i.x * 256 + j.x * 512 as num
from (select 0 as x union all select 1) a
cross join (select 0 as x union all select 1) b
cross join (select 0 as x union all select 1) c
cross join (select 0 as x union all select 1) d
cross join (select 0 as x union all select 1) e
cross join (select 0 as x union all select 1) f
cross join (select 0 as x union all select 1) g
cross join (select 0 as x union all select 1) h
cross join (select 0 as x union all select 1) i
cross join (select 0 as x union all select 1) j
) numbers
WHERE num between 1 and 999
) codes
WHERE code not in (select id from products);";
$abc_result = $mysqli2->query($abc_query);
while($abc = $abc_result->fetch_assoc()) { //----- THIS WOULD BE LINE 34 ITS TALKING ABOUT---//
$abcid = $abc["POSSIBLE_MIN_ID"];
}
应用程序中的其他一切都可以正常工作,这是我遇到的唯一问题,代码与服务器上的文件完全相同,只是不同的数据库连接。
暂无答案!
目前还没有任何答案,快来回答吧!