개발 꿀팁/PHP

php 원형 페이지

Jammie 2022. 7. 27. 13:02
반응형
<?php
$wherelist = array();
$urlist    = array();
if (!empty($_GET['news_title'])) {
    $wherelist[] = " news_title like '%".$_GET['news_title']."%'";
    $urllist[]   = "news_title=".$_GET['news_title'];
}
$type=$_GET['type'];
var_dump($type);
if (!empty($_GET['type'])) {
$wherelist[] = " type_Id like '%" . $_GET['type'] . "%'";
$urllist[] = "type_Id=" . $_GET['type'];
}
$where = "";
if (count($wherelist) > 0) {
    $where = " where ".implode(' and ', $wherelist);
    $url   = '&'.implode('&', $urllist);
}

//링크
$hostname_conn = "localhost";

$database_conn = "sbing";

$username_conn = "root";

$password_conn = "root";

$conn = @mysql_connect($hostname_conn, $username_conn, $password_conn) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_select_db($database_conn, $conn);
//페이지별 구현 원리
//1.데이터 시트의 총 레코드 수 가져오기
mysql_query("set names 'utf8'");
$sql      = "select * from news_content $where";
$result   = mysql_query($sql);
$totalnum = mysql_num_rows($result);
//페이지당 개수 보이기
$pnews_datesize = 3;
//모두 몇 페이지가 있다
$maxpnews_date = ceil($totalnum / $pnews_datesize);
$pnews_date    = isset($_GET['pnews_date']) ? $_GET['pnews_date'] : 1;
if ($pnews_date < 1) {
    $pnews_date = 1;
}
if ($pnews_date > $maxpnews_date) {
    $pnews_date = $maxpnews_date;
}
$limit = " limit ".($pnews_date - 1) * $pnews_datesize.",$pnews_datesize";
$sql1  = "select * from news_content {$where} order by news_Id desc {$limit}"; //此处加了id降序
$res   = mysql_query($sql1);
?>


<!DOCTYPE html>
<html>
<head>
    <meta charset="UTF-8">
    <title>사용자 정보 표시</title>
</head>
<body>
<form action="gnewshow.php" method="get">
    <input   type="hidden"  name="type" value=<?php
    echo $type;
    ?>>
    아이디<input type="text" name="news_title" value="<?php echo $_GET['news_title'] ?>" size="8">
<!--    <input type="button" value="모두 보기" onclick="window.location='gnewshow.php'">-->

    <input type="submit" value="검색하다">
</form>
<br/>
<table border="1" width="500">
    <tr>
        <td>번호号</td>
        <td>아이디</td>
        <td>연령</td>
        <td>성별</td>
        <td>전화를</td>
        <td>주소</td>
    </tr>
    <?php
    if ($res) {
        while ($row = mysql_fetch_assoc($res)) { ?>
            <tr>
                <td><?php echo $row['news_Id'] ?></td>
                <td><?php echo $row['news_title'] ?></td>
                <td><?php echo $row['news_date'] ?></td>
                <td><?php if ($row['sex']) {
                        echo '남자';
                    } else {
                        echo '여자';
                    } ?></td>
                <td><?php echo $row['news_author'] ?></td>
                <td><?php echo $row['news_QzTop'] ?></td>
            </tr>
        <?php }
    } else {
        echo " <td>데이터가 없습니다</td>";
    } ?>
    <tr>
        <td colspan="6">
            <?php
            echo " 当前{$pnews_date}/{$maxpnews_date페이지 합계{$totalnum}조";
            echo " <a href='gnewshow.php?type={$type}&pnews_date=1{$url}'>메인 화면</a> ";
            echo "<a href='gnewshow.php?type={$type}&pnews_date=".($pnews_date - 1)."{$url}'>이전 페이지</a>";
            echo "<a href='gnewshow.php?type={$type}&pnews_date=".($pnews_date + 1)."{$url}'>다음 페이지</a>";
            echo " <a href='gnewshow.php?type={$type}&pnews_date={$maxpnews_date}{$url}'>뒷장</a> ";
            ?>
        </td>
    </tr>
</table>
</body>
</html>
반응형