如果我们通过文本框中的表单输入数据以插入数据库表,但没有显示任何错误,如何查看实际问题在评论错误报告(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)检查错误,然后调试并检查控制台中是否出现任何错误。