php+mysql實(shí)現(xiàn)留言板

番茄西紅柿發(fā)布于2021-11-25 09:43 / 3254人閱讀

摘要：文章目錄寫出留言板的代碼連接的代碼利用來美化留言板我的代碼為留言板提交連接的代碼

文章目錄

1、寫出留言板的html代碼
2、連接mysql的代碼
3、利用bootstrap來美化留言板

1、我的html代碼為

<html><head>    <meta charset='utf-8'>    <title>留言板</title>    <style>        .a{ width:100%;            margin:0 auto;        }        textarea{            width: 100%;            height:100px;            margin-bottom:10px;        }         .b{            border:  solid 1px #28e7d7;margin-top:10px; padding:5px;         }          .u{            float:left;        }           .s{            float:right;        }    </style>        </head><body>     <div calss='a'>     <form action="db.php" method="POST">        <textarea name='content'></textarea>        <input name='username'  type='text'/>        <input class='s'type='submit'  value='提交'/>        <div style='clear:both;'></div>     </div>    </form>    <div class='a'>        <?php        foreach ($rows as $key => $test) {        ?>        <div class='b'>            <p><?php echo $test['username'];?></p>            <p><?php echo $test['content'];?></p>                </div >         <?php         }        ?>        </div></body></html>

2、連接mysql的代碼

 $username=$_POST['username']; $content=$_POST['content'];  var_dump($username,$content);// 檢驗(yàn)傳來的數(shù)據(jù)是否有誤$dsn='mysql:dbname=quan;host=localhost';$pdo=new PDO($dsn,'root','root');// 上一行以及這一行是連接數(shù)據(jù)庫$sql="INSERT INTO test (username,content) VALUES('{$username}','{$content}')";// 插入語句到test表中，數(shù)值為values后的兩個(gè)//  echo $sql;//檢驗(yàn)是否可以輸出$sth=$pdo->prepare($sql);// 準(zhǔn)備執(zhí)行//  var_dump($sql);$sth->execute();// 執(zhí)行header('location:index.php');//完成上述操作后回到留言板界面?>

擴(kuò)充：trim函數(shù)（自動(dòng)刪除代碼之中的空格鍵）

3、利用bootstrap美化
這里是鏈接
這是之后的代碼（其中我將公用連接mysql的代碼多帶帶放置于一文件中，如果不理解，可以觀看編程獅十天學(xué)會(huì)php）來了解
下面分別是留言板界面和數(shù)據(jù)庫語句界面

include('7.php');$sql = "SELECT * FROM `test` ORDER BY  id DESC";$rows=read($pdo, $sql);?><!doctype html><html lang="en"><head>  <!-- Required meta tags -->  <meta charset="utf-8">  <meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">  <!-- Bootstrap CSS -->  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">  <title>留言板</title></head><body>  <div class="container">    <div class="jumbotron">      <h1 class="display-4">留言板</h1>      <p class="lead">這里是留言區(qū)，請(qǐng)大家提出自己的意見</p>    </div>    <form action="db.php" method="POST">      <div class='row'>        <div class='col-12'>          <div class='form-group'>            <textarea name='content' class="form-control" rows='4'></textarea>          </div>        </div>        <div class='col-3'>          <div class='form-group'>            <input name='username' class='form-control' type='text' />          </div>        </div>        <div class='col-9 d-flex'>          <div class="form-group ml-auto">            <input class='btn btn-primary' type='submit' value='提交' />          </div>        </div>      </div>    </form>    <div class='row'>      <?php      foreach ($rows as $key => $tesy) {      ?>        <div class='col-12'>          <div class='border rounded p-2 mb-2'>            <div class='text-primary'>              <p><?php echo $tesy['username']; ?></p>            </div>            <div>              <p><?php echo $tesy['content']; ?></p>            </div>          </div>        </div>      <?php      }      ?>    </div>  </div></body></html>

數(shù)據(jù)庫界面（上述代碼中7.php為下面代碼的文件名）

$dsn='mysql:dbname=test;host=127.0.0.1';$pdo=new PDO($dsn,'root','root');function write($pdo,$sql){$sth=$pdo->prepare($sql);return $sth->execute();}function read($pdo,$sql){$sth=$pdo->prepare($sql);$sth->execute();$rows=$sth->fetchAll();return $rows;}?>

實(shí)現(xiàn)效果

下面與我自己的代碼界面進(jìn)行對(duì)比（7.php不再寫，與上面一致）

    include('7.php');    $sql="SELECT * FROM `test` ORDER BY  id DESC";    $sth= $pdo->prepare($sql);    $sth->execute();    $rows=$sth->fetchAll();?><html><head>    <meta charset='utf-8'>    <title>留言板</title>    <style>        .a{ width:100%;            margin:0 auto;        }        textarea{            width: 100%;            height:100px;            margin-bottom:10px;        }         .b{            border:  solid 1px #28e7d7;margin-top:10px; padding:5px;         }          .u{            float:left;        }           .s{            float:right;        }    </style>        </head><body>     <div calss='a'>     <form action="db.php" method="POST">        <textarea name='content'></textarea>        <input name='username'  type='text'/>        <input class='s'type='submit'  value='提交'/>        <div style='clear:both;'></div>     </div>    </form>    <div class='a'>        <?php        foreach ($rows as $key => $test) {        ?>        <div class='b'>            <p><?php echo $test['username'];?></p>            <p><?php echo $test['content'];?></p>                </div >         <?php         }        ?>        </div></body></html>