成都市社保查询官网个人账户查询 (成都市社保查询个人账户缴费明细查询)

个人账户查询

缴费明细查询

身份证号码：
起始日期：
结束日期：

connect_error) {die("连接数据库失败：" . $conn->connect_error);}// 准备查询语句$sql = "SELECT FROM social_insurance WHERE id_number = ? AND date BETWEEN ? AND ?";$stmt = $conn->prepare($sql);$stmt->bind_param("sss", $id_number, $start_date, $end_date);// 执行查询$stmt->execute();$result = $stmt->get_result();// 输出查询结果echo "";echo "";while ($row = $result->fetch_assoc()) {echo "";}echo "

缴费年月	缴费基数	养老保险	医疗保险	失业保险	生育保险	工伤保险
{$row['date']}	{$row['base']}	{$row['pension']}	{$row['medical']}	{$row['unemployment']}	{$row['maternity']}	{$row['injury']}

";// 关闭数据库连接$stmt->close();$conn->close();}?>