connectdb2.php原始碼 (連接資料庫)
<?php
// 開啟伺服器連接
$db = mysqli_connect("localhost", "使用者", "密碼");
if (!$db) die("錯誤: 無法連接MySQL伺服器!" . mysqli_connect_error());
mysqli_set_charset($db, "utf8");//選擇編碼
mysqli_select_db($db, "lvaahvxc_test") or // 選擇資料庫
die("錯誤: 無法選擇資料庫!" . mysqli_error($db));
?>
05_share3.php原始碼 (輸入分享資源資料)
<html>
<head>
<title>分享資源</title>
</head>
<body bgcolor="#F9E6A2">
<form method="POST" action="">
<h2><strong>喜樂村分享資源(實習版)</strong></h2>
分類:<br>
<input type="radio" value="福音" name="kind" >福音
<input type="radio" value="生活" name="kind" >生活
<input type="radio" value="餐飲" name="kind" >餐飲
<input type="radio" value="設計" name="kind" >設計
<input type="radio" value="藝文" name="kind" >藝文<br>
<input type="radio" value="資訊" name="kind" >資訊
<input type="radio" value="醫療" name="kind" >醫療
<input type="radio" value="休閒" name="kind" >休閒
<input type="radio" value="生態" name="kind" >生態
<input type="radio" value="農漁" name="kind" >農漁<br>
<input type="radio" value="音樂" name="kind" >音樂
<input type="radio" value="電影" name="kind" checked>電影
<input type="radio" value="科學" name="kind" >科學
<input type="radio" value="動物" name="kind" >動物
<input type="radio" value="植物" name="kind" >植物<br>
<input type="radio" value="頻道" name="kind" >頻道
<input type="radio" value="卡通" name="kind" >卡通
<input type="radio" value="旅遊" name="kind" >旅遊
<input type="radio" value="攝影" name="kind" >攝影
<input type="radio" value="繪畫" name="kind" >繪畫<br>
<input type="radio" value="運動" name="kind" >運動
<input type="radio" value="教育" name="kind" >教育
<input type="radio" value="趣味" name="kind" >趣味
<input type="radio" value="勵志" name="kind" >勵志
<br><br>
分享網址<br>
<textarea name="url" rows="2" cols="40"></textarea><br>
標題(限12字)<br>
<textarea name="title" rows="2" cols="40" maxlength="12" ></textarea><br><br>
<input type="submit" value="確認送出">
<input type="reset" value="清除填寫資料">
</form>
</html>
<?php
session_start();
include("connectdb2.php");
echo '使用者:資概學生';
echo '<br>';
if($_POST['url']<>'' ) {
$kind=$_POST['kind'];
$url=$_POST['url'];
$url=trim("$url");
$title=$_POST['title'];
//寫入分享檔
$sum=0;
$sqlStr="insert into joy_url (kind,url,title,sum) ";
$sqlStr.="values('$kind','$url','$title','$sum')";
echo "<br>";
mysqli_query($db,$sqlStr) or die("寫入失敗");
//顯示最近5筆
$sql = "select kind as '分類',title as '標題' from joy_url order by uid DESC limit
0,5";
$rows = mysqli_query($db, $sql);
$sum = mysqli_num_rows($rows);
echo "符合筆數:".$sum."<br>";
echo "<table border=1 width='320' >\n";
while($field=mysqli_fetch_field($rows)){
echo "<td>".$field->name."</td>\n";}
while($row=mysqli_fetch_row($rows))
{
print "<tr>";
foreach($row as $i){
echo "\t<td>$i</td>\n";
}
}
mysqli_close($db);
}
?>
05_link4.php原始碼 (連結分享)
<html>
<head>
<title>喜樂村連結分享</title>
</head>
<body bgcolor="#F9E6A2">
<h2><strong>喜樂村連結分享(實習版)</strong></h2>
<form method="POST" action="">
關鍵字:<input type="text" name="name" size="15" maxlength="50">
<input type="submit" value="確認送出">
</form>
<form method="POST" action="">
選分類:
<select size="1" name="type">
<option value="福音">福音</option>
<option value="生活">生活</option>
<option value="餐飲" >餐飲</option>
<option value="設計">設計</option>
<option value="藝文">藝文</option>
<option value="資訊">資訊</option>
<option value="醫療">醫療</option>
<option value="休閒">休閒</option>
<option value="生態">生態</option>
<option value="農漁">農漁</option>
<option value="音樂">音樂</option>
<option value="電影" selected>電影</option>
<option value="科學">科學</option>
<option value="動物">動物</option>
<option value="植物">植物</option>
<option value="頻道">頻道</option>
<option value="卡通">卡通</option>
<option value="旅遊">旅遊</option>
<option value="攝影">攝影</option>
<option value="繪畫">繪畫</option>
<option value="運動">運動</option>
<option value="教育">教育</option>
<option value="趣味">趣味</option>
<option value="勵志">勵志</option>
</select>
<input type="submit" value="確認送出">
</form>
<form method="post" action="">
<input type="radio" value="01" name="select" checked>最近5筆
<input type="radio" value="02" name="select">全部分享
<input type="submit" name="button" id="button" value="確認送出" />
</form>
<form method="post" action="">
<input type="radio" value="01" name="top" checked>點閱前10名
<input type="radio" value="02" name="top">全部排行
<input type="submit" name="button" id="button" value="確認送出" />
</form>
<table border="1" width='320'>
<thead>
<tr>
<th>分類</th>
<th>標題</th>
<th>Σ</th>
</tr>
</thead>
<?php
include("connectdb2.php");
$sql = "select * from joy_url order by uid desc limit 0,5 ";
if ($_POST['select']=="01" ) {
$sql = "select * from joy_url order by uid desc limit 0,5 ";}
if ($_POST['select']=="02" ) {
$sql = "select * from joy_url order by kind,sum desc";}
if ($_POST['top']=="01" ) {
$sql = "select * from joy_url order by sum desc limit 0,10 ";}
if ($_POST['top']=="02" ) {
$sql = "select * from joy_url order by sum desc";}
if ($_POST['name']!="" ){
$sort= $_POST['name'];
$sql = "select * from joy_url WHERE title like '%$sort%' order by sum desc ";}
IF ($_POST['type']!="" ){
$type=$_POST['type'];
$sql = "select * from joy_url WHERE kind='$type' order by sum desc ";}
$rows = mysqli_query($db, $sql); // 執行SQL查詢
$sum = mysqli_num_rows($rows); // 取得記錄數
echo "符合筆數:".$sum."<br>";
if ($sum > 0) { // 有記錄
while ($row = mysqli_fetch_array($rows)) {
$uid=$row["uid"];
$kind = $row["kind"];
$title = $row["title"];
$sum = $row["sum"];
echo "<tr>";
echo "<td>" . $kind . "</td>";
echo "<td>" . $title . "</td>";
echo "<td>" . $sum . "</td>";
echo "<td>";
echo "<a href='05_link5.php?uid=" . $uid . "'>連結</a>";
echo "</td>";
echo "</tr>";
}
}
mysqli_free_result($rows); // 釋放查詢結果
mysqli_close($db); // 關閉連接
?>
</table>
</body>
</html>
05_link5.php 原始碼 (連結網址)
<?php
$uid = $_GET["uid"]; // 取得uid號
include("connectdb2.php");
$sql = "select url,sum from joy_url where uid='" . $uid . "'";
$rows = mysqli_query($db, $sql); // 執行SQL查詢
$row = mysqli_fetch_row($rows); // 取出第1筆
mysqli_free_result($rows); // 釋放查詢結果
$url=$row[0];
$sum=$row[1];
$sum=$sum+1;
$sql = "update joy_url set sum='$sum' where uid='" . $uid . "'";
if (!mysqli_query($db, $sql)) // 執行SQL指令
mysqli_close($db); // 關閉連接
else header("location:".$url); // 轉址
?>
執行結果
輸入分享標題及網址
完成後顯示最近輸入的5筆資料
進入連結分享，可依不同條件篩選再選連結
資料表結構
mysql 資料庫結構 分享檔 joy.url
mysql 資料庫內容 分享檔 joy.url
