우리에 대한 정보를 보여주는 PHP 개발 기업 웹사이트 튜토리얼

사용자 조작 방법(추가, 삭제, 수정, 확인)을 배운 후에는 다음 기능을 개발하는 것이 매우 간단할 것입니다. SQL 문이 다르다는 점만 제외하면 대부분 동일하지만 기본적으로 원칙은 같습니다. 유사

다음을 살펴보겠습니다. 일부 정보 표시에 관해

<?php
    header("Content-type: text/html; charset=utf-8");//设置编码
    require_once('conn.php');
    $sql = "SELECT * FROM about order by id desc";
    $res = mysql_query($sql);

//截取中文字符
function msubstr($str,$start=0,$length,$suffix=true,$charset="utf-8"){
    if(function_exists("mb_substr")){
        if ($suffix && mb_strlen($str, $charset)>$length)
            return mb_substr($str, $start, $length, $charset)."...";
        else
            return mb_substr($str, $start, $length, $charset);
    }elseif(function_exists('iconv_substr')) {
        if ($suffix && strlen($str)>$length)
            return iconv_substr($str,$start,$length,$charset)."...";
        else
            return iconv_substr($str,$start,$length,$charset);
    }
    $re['utf-8']   = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|[\xe0-\xef][\x80-\xbf]{2}|[\xf0-\xff][\x80-\xbf]{3}/";
    $re['gb2312'] = "/[\x01-\x7f]|[\xb0-\xf7][\xa0-\xfe]/";
    $re['gbk']    = "/[\x01-\x7f]|[\x81-\xfe][\x40-\xfe]/";
    $re['big5']   = "/[\x01-\x7f]|[\x81-\xfe]([\x40-\x7e]|\xa1-\xfe])/";
    preg_match_all($re[$charset], $str, $match);
    $slice = join("",array_slice($match[0], $start, $length));
    if($suffix) return $slice."…";
    return $slice;
}

?>
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8">
    <title>展示关于我们的信息</title>
    <style type="text/css">
        .top{height:30px;line-height:30px;float:right;margin-right:15px;}
        .top a{color:red;text-decoration:none;}
        .cont{width:100%;height:300px;float:left;}
        .cont_ct{float:left;}
        table{width:100%;border:1px solid #eee;text-align:center;}
        th{background:#eee;}
        td{width:200px;height:40px;}
    </style>
</head>
<body>
    <div class="top"><a href="addab.php">添加信息</a></div>

    <div class="cont">
        <table cellspacing="0" cellpadding="0" border="1">
            <tr>
                <th>ID</th>
                <th>标题</th>
                <th>内容</th>
                <th>操作</th>
            </tr>
            <?php
                while($row = mysql_fetch_array($res)){
            ?>
            <tr>
                <td><?php echo $row['id'];?></td>
                <td><?php echo $row['title'];?></td>
                <td><!-- <textarea cols="50" rows="5" readonly> -->
                <?php echo msubstr($row['content'],0,20);?><!-- </textarea> --></td>
                <td>
                    <a href="modifya.php?id=<?php echo $row['id'];?>">修改</a>
                    <a href="delabout.php?id=<?php echo $row['id'];?>">删除</a>
                </td>
            </tr>
            <?php
                }
            ?>
        </table>
    </div>
</body>
</html>

표시된 내용이 너무 길면 문자열 길이를 가로채야 합니다

이것을 사용하는 방법을 캡슐화했습니다. 0부터 시작하는 아래 출력 콘텐츠 부분의 코드를 살펴보세요. Take 20

삭제 및 수정에도 ID가 있습니다

지속적인 학습

새로운 파일

<?php header("Content-type: text/html; charset=utf-8");//设置编码 require_once('conn.php'); $sql = "SELECT * FROM about order by id desc"; $res = mysql_query($sql); //截取中文字符 function msubstr($str,$start=0,$length,$suffix=true,$charset="utf-8"){ if(function_exists("mb_substr")){ if ($suffix && mb_strlen($str, $charset)>$length) return mb_substr($str, $start, $length, $charset)."..."; else return mb_substr($str, $start, $length, $charset); }elseif(function_exists('iconv_substr')) { if ($suffix && strlen($str)>$length) return iconv_substr($str,$start,$length,$charset)."..."; else return iconv_substr($str,$start,$length,$charset); } $re['utf-8'] = "/[\x01-\x7f]|[\xc2-\xdf][\x80-\xbf]|[\xe0-\xef][\x80-\xbf]{2}|[\xf0-\xff][\x80-\xbf]{3}/"; $re['gb2312'] = "/[\x01-\x7f]|[\xb0-\xf7][\xa0-\xfe]/"; $re['gbk'] = "/[\x01-\x7f]|[\x81-\xfe][\x40-\xfe]/"; $re['big5'] = "/[\x01-\x7f]|[\x81-\xfe]([\x40-\x7e]|\xa1-\xfe])/"; preg_match_all($re[$charset], $str, $match); $slice = join("",array_slice($match[0], $start, $length)); if($suffix) return $slice."…"; return $slice; } ?> <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <title>展示关于我们的信息</title> <style type="text/css"> .top{height:30px;line-height:30px;float:right;margin-right:15px;} .top a{color:red;text-decoration:none;} .cont{width:100%;height:300px;float:left;} .cont_ct{float:left;} table{width:100%;border:1px solid #eee;text-align:center;} th{background:#eee;} td{width:200px;height:40px;} </style> </head> <body> <div class="top"><a href="addab.php">添加信息</a></div> <div class="cont"> <table cellspacing="0" cellpadding="0" border="1"> <tr> <th>ID</th> <th>标题</th> <th>内容</th> <th>操作</th> </tr> <?php while($row = mysql_fetch_array($res)){ ?> <tr> <td><?php echo $row['id'];?></td> <td><?php echo $row['title'];?></td> <td> <?php echo msubstr($row['content'],0,20);?></td> <td> <a href="modifya.php?id=<?php echo $row['id'];?>">修改</a> <a href="delabout.php?id=<?php echo $row['id'];?>">删除</a> </td> </tr> <?php } ?> </table> </div> </body> </html>

제출하다 코드 재설정

자동운전