为什么我会收到此错误?
警告:sqlsrv_fetch_array() 期望参数 1 是资源,给定的布尔值。?
我在尝试INSERT INTO employeemasterfile (employeeidno) VALUES ('$deptcode'+'$empno');数据库时手动测试了它,使用以下值$deptcode::D001 和$empno:0000017,它完美地工作。
这是 SQL 代码。
<?php
if(isset($_POST['referenceno']))
$data=$_POST['referenceno'];
$explode= explode(":", $data);
$user = $user['fingerscanno'];
$deptcode=$explode[0];
$emp=$explode[1];
$empno = str_pad(++$emp,7,"0",STR_PAD_LEFT);
$jobposition=$explode[2];
$departmentname=$explode[3];
$sql = "SELECT DISTINCT
LEFT (departmentcode,4) as deptcode,
MAX(RIGHT(employeeidno, 7)) as empno,
section, departmentname, paymentmode,
hrdjobpositionentry.jobposition as jobposition
FROM departmentmasterfile, hrdjobpositionentry,employeemasterfile
WHERE hrdjobpositionentry.department=departmentmasterfile.departmentname AND
LEFT (employeemasterfile.employeeidno,4) = LEFT (departmentmasterfile.departmentcode,4) AND
LEFT (departmentcode,4) = '$deptcode' AND hrdjobpositionentry.jobposition='$jobposition'
GROUP BY LEFT (departmentcode,4), section, departmentname, paymentmode, hrdjobpositionentry.jobposition
ORDER BY LEFT (departmentcode,4);
INSERT INTO employeemasterfile (employeeidno) VALUES ('$deptcode'+'$empno');
";
$query = sqlsrv_query($conn, $sql, array(), array("Scrollable" => SQLSRV_CURSOR_KEYSET));
while($row = sqlsrv_fetch_array($query, SQLSRV_FETCH_ASSOC)){
该while()条款应该没有问题,对吗?因为我只是在第二个 SQL 查询中插入。
此 SQL 查询仅在我删除时有效 INSERT INTO employeemasterfile (employeeidno) VALUES ('$deptcode'+'$empno');
杨__羊羊
控制台有好多警告,是什么原因???
我警告模式下为什么没有警告?
没有开始点击时,控制台就出现了一个警告,这个警告不影响加1效果,就是有警告,所以请教!
警告什么意思?