doujie3888 2017-01-26 07:20
浏览 42

我正在尝试更新mysql数据库,但我收到一个未定义的偏移通知错误但数据库已更新。 请为此提供解决方案

Updated! Updated!

Notice: Undefined offset: 2 in C:\wamp\www\update1\update.php on line 8
Notice: Undefined offset: 2 in C:\wamp\www\update1\update.php on line 9
Notice: Undefined offset: 2 in C:\wamp\www\update1\update.php on line 10
Notice: Undefined offset: 2 in C:\wamp\www\update1\update.php on line 11
Notice: Undefined offset: 2 in C:\wamp\www\update1\update.php on line 12

Updated!

Notice: Undefined offset: 3 in C:\wamp\www\update1\update.php on line 8
Notice: Undefined offset: 3 in C:\wamp\www\update1\update.php on line 9
Notice: Undefined offset: 3 in C:\wamp\www\update1\update.php on line 10
Notice: Undefined offset: 3 in C:\wamp\www\update1\update.php on line 11
Notice: Undefined offset: 3 in C:\wamp\www\update1\update.php on line 12

Updated!

$size  = array($_POST['NO_OF_CLASSES'],$_POST['NO_OF_CLASSES_PRESENT'],$_POST['NO_OF_CLASSES_ABSENT'],$_POST['PERCENTAGE']);    
$size1 = count($size);
for($i = 0; $i<$size1;$i++) 
{
    $regno = $_POST['REGNO'][$i];
    $Noofclasses= $_POST['NO_OF_CLASSES'][$i];
    $Noofclassespresent= $_POST['NO_OF_CLASSES_PRESENT'][$i];
    $Noofclassesabsent= $_POST['NO_OF_CLASSES_ABSENT'][$i];
    $percentage= $_POST['PERCENTAGE'][$i];
    $query = "UPDATE attendancetbl SET NO_OF_CLASSES='$Noofclasses',NO_OF_CLASSES_PRESENT='$Noofclassespresent',NO_OF_CLASSES_ABSENT='$Noofclassesabsent',PERCENTAGE='$percentage' WHERE REGNO =  '$regno'";
    mysql_query($query) or die ("Error in query: $query");
    echo "<em>Updated!</em><br />";
}
  • 写回答

2条回答 默认 最新

  • dongmanni6916 2017-01-26 09:02
    关注

    It means that the index of the array you are try to access is not set for example:

    $_POST['REGNO'][3] and so on. 
    

    Please, print_r your $size array before the for loop and exit and and you will see what I am talking about

    评论

报告相同问题?

悬赏问题

  • ¥15 公交车和无人机协同运输
  • ¥15 stm32代码移植没反应
  • ¥15 matlab基于pde算法图像修复,为什么只能对示例图像有效
  • ¥100 连续两帧图像高速减法
  • ¥15 组策略中的计算机配置策略无法下发
  • ¥15 如何绘制动力学系统的相图
  • ¥15 对接wps接口实现获取元数据
  • ¥20 给自己本科IT专业毕业的妹m找个实习工作
  • ¥15 用友U8:向一个无法连接的网络尝试了一个套接字操作,如何解决?
  • ¥30 我的代码按理说完成了模型的搭建、训练、验证测试等工作(标签-网络|关键词-变化检测)