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

';echo '日期单位名称缴费金额';foreach ($results as $result) {echo '' . $result['date'] . '' . $result['company_name'] . '' . $result['amount'] . '';}echo '';} else {echo '没有找到任何结果。';}}// 从数据库中获取数据并格式化为 HTML 表格的示例函数function getResults($id_type, $id_number, $start_date, $end_date) {// 连接数据库$conn = new PDO('mysql:host=localhost;dbname=social_insurance', 'root', 'password');// 准备查询语句$sql = 'SELECT FROM contributions WHERE id_type = :id_type AND id_number = :id_number AND date BETWEEN :start_date AND :end_date';$stmt = $conn->prepare($sql);// 绑定参数$stmt->bindParam(':id_type', $id_type);$stmt->bindParam(':id_number', $id_number);$stmt->bindParam(':start_date', $start_date);$stmt->bindParam(':end_date', $end_date);// 执行查询$stmt->execute();// 获取结果$results = $stmt->fetchAll(PDO::FETCH_ASSOC);// 关闭连接$conn = null;return $results;}?>