在注释error_reporting(0)函数后,如何在数据库表中未插入数据时查看错误


How to see error when data is not inserting in database table after commenting error_reporting(0) function also

如果我们通过文本框中的表单输入数据以插入数据库表,但没有显示任何错误,如何查看实际问题在评论错误报告(0)之后,还有

数据库代码:

<?php
include('connection_temp.inc.php');
include('functions.inc.php');
?>
<?php
sm_registerglobal('MEMBER_ACCOUNT_INFO_ID', 'FIRST_NAME', 'LAST_NAME', 'EMAIL_ID', 'PHONE_NO', 'STATES_ID', 'CITIES_ID', 'PASS', 'LOCALITY');
    $tbl_registrations = array(
                                'FIRST_NAME' => $FIRST_NAME,
                                'LAST_NAME' => $LAST_NAME,                              
                                'STATES_ID' => $STATES_ID,
                                'CITIES_ID' => $CITIES_ID,
                                'EMAIL_ID' => $EMAIL_ID,
                                'PHONE_NO' => $PHONE_NO,
                                'PASS' => $PASS,
                                'LOCALITY' => $LOCALITY,
                                );
    /*$tbl_member_account_info = array(                                                         
                                'FIRST_NAME' => 'ssk',
                                'LAST_NAME' => 'sss',                               
                                'STATES_ID' => '6',
                                'CITIES_ID' => '12',
                                'EMAIL_ID' => 'asd@w.com',
                                'PHONE_NO' => '3324234',
                                'PASS' => '123',
                                'LOCALITY' => 'abad',
                                );*/
    //$registrations_id = insert($con, "tbl_registrations", $tbl_registrations);
    $member_account_info_id = insert($con, "tbl_member_account_info", $tbl_member_account_info);
    //echo $member_account_info_id;
?>

不要在数组的最后一个元素中添加逗号。尝试低于代码

<?php
include('connection_temp.inc.php');
include('functions.inc.php');
?>
<?php
sm_registerglobal('MEMBER_ACCOUNT_INFO_ID', 'FIRST_NAME', 'LAST_NAME', 'EMAIL_ID', 'PHONE_NO', 'STATES_ID', 'CITIES_ID', 'PASS', 'LOCALITY');
    $tbl_registrations = array(
                                'FIRST_NAME' => $FIRST_NAME,
                                'LAST_NAME' => $LAST_NAME,                              
                                'STATES_ID' => $STATES_ID,
                                'CITIES_ID' => $CITIES_ID,
                                'EMAIL_ID' => $EMAIL_ID,
                                'PHONE_NO' => $PHONE_NO,
                                'PASS' => $PASS,
                                'LOCALITY' => $LOCALITY
                                );
    /*$tbl_member_account_info = array(                                                         
                                'FIRST_NAME' => 'ssk',
                                'LAST_NAME' => 'sss',                               
                                'STATES_ID' => '6',
                                'CITIES_ID' => '12',
                                'EMAIL_ID' => 'asd@w.com',
                                'PHONE_NO' => '3324234',
                                'PASS' => '123',
                                'LOCALITY' => 'abad',
                                );*/
    //$registrations_id = insert($con, "tbl_registrations", $tbl_registrations);
    $member_account_info_id = insert($con, "tbl_member_account_info", $tbl_member_account_info);
    //echo $member_account_info_id;
?>

必须将错误报告设置为Error_reporting(E_ALL)才能查看所有错误。如果设置errorreporting(0),则不会显示任何错误,因为它通常用于在生产模式中隐藏所有错误
在传递逗号不应该存在的数组时,最后删除逗号,并检查$con变量一次是否正确声明了数据库连接,如果问题仍未解决,请通过设置error_reporting(E_ALL)检查错误,然后调试并检查控制台中是否出现任何错误。