php中将文本数据库转为mysql数据库

作者：袖梨 2022-06-24

 

 代码如下 复制代码
require_once 'config.php';
 
$action  = empty($_GET['action']) ? '' : $_GET['action'];
$id      = isset($_GET['id']) ? $_GET['id'] : 0;
 
if (empty($action)) {//列表
 
    $result    = "SELECT * FROM posts ORDER BY pid DESC";
    $items     = 3;
    $page      = isset($_GET['page']) ? intval($_GET['page']) : 1;
    $page      = ($page =='' && $page < 0) ? 1 : $page;
    $total     = mysql_num_rows(mysql_query($result));//数据条目总数
    $pageall   = ceil($total/$items);
    $offset    = ($page-1)*$items;//数据开始位置
    $result    .= " limit {$offset},{$items}";//每页显示
    $results   = mysql_query($result);
 
    $prev = $page - 1;
    $next = $page + 1;
    $goPrev = "上一页";
    $goNext = "下一页";
 
    if ($page == $pageall){ $goNext = NULL;}
 
    $pagestate = '';
 
    if ($page == 1 && $pageall > 1) {
        $pagestate .=  $goNext;
    } elseif ($pageall > $page || $page >1) {
        $pagestate .= $goNext . '|' .$goPrev;
    } elseif ($page >1 ) {
        $pagestate .=  $goPrev;
    } else {
        $pagestate .=  'Just One Page';
    }
 
    $pagelinks = '';
 
    for ($i = 1; $i <= $pageall; $i++) {
        $pagelinks .= ($i != $page) ? "$i" : $i;
        $pagelinks .= ($i < $pageall) ? '-' : null;
    }
 
  // end 分页
    $data   = array();
 
    //列出文章
    while ($row = mysql_fetch_array($results)) {//mysql_fetch_array ; 从查询结果取出一行作为数组；
        $data[] = $row;//
    }
 
    //列出分类
    $recat = mysql_query("SELECT * FROM category ORDER BY cid DESC");
    $cdata = array();
 
    while ($catlist = mysql_fetch_array($recat)) {
        $cdata[$catlist['cid']] = $catlist;
    }
 
    include template('index');
 
} elseif ($action == 'post') {//发表
 
    $title      = $_POST['title'];
    $date       = date("Y-m-d H:i:s");
    $content    = $_POST['content'];
    $cid        = $_POST['cat'];
 
    if ($title == '' || $content == '' || $cid == '') {
 
        echo "缺少必填项nnnnjavascript:history.go(-1);">返回";
 
    } else {
 
        $insertPost = "INSERT INTO posts (title,time,post,cid) VALUES ('$title','$date','$content','$cid')";
 
        if (!mysql_query($insertPost,$sql)) {
            die('ERROR: '. mysql_error());
        }
 
        header('location: index.php');
 
    }
 
} elseif ($action == 'view') {//查看
 
    $view = mysql_query("SELECT * FROM posts WHERE pid='$id'");
 
    while ($row = mysql_fetch_array($view)) {
 
     $title    = $row['title'];
     $time     = $row['time'];
     $post     = $row['post'];
 
    }
 
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {//评论
 
        $name   = isset($_POST['name']) ? $_POST['name'] : 0;
        $review = isset($_POST['review']) ? $_POST['review'] : 0;
 
        if ($name == '' && $review == '') {  echo  "缺少必填项";    exit; }
        $insertRview = "INSERT INTO review (pid,name,review) VALUES ('$id','$name','$review')";
 
        if (!mysql_query($insertRview,$sql)) {
            die('ERROR: ' . mysql_error());
        }
 
        header("location: ?action=view&id=$id");
    }
 
    $rert   = mysql_query("SELECT * FROM review WHERE pid='$id' ORDER BY rid ASC");
    $data = array();
 
    while ($relist = mysql_fetch_array($rert)){
 
        $data[] = $relist;
 
    }
 
    include template('view');
 
} elseif ($action == 'del') {//删除
 
    mysql_query("DELETE FROM posts WHERE pid='$id'");
    header("location: index.php");
 
} elseif ($action == 'edit') {//编辑
 
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
 
        $title   = $_POST['title'];
        $content = $_POST['content'];
        $date    = date("Y-m-d H:i:s");
 
        if ($title == '' or $content == '') { echo "缺少必填项nnnn返回";    exit;}
 
        mysql_query("UPDATE posts SET title='$title',time='$date',post='$content' WHERE pid='$id'");
        header("location: index.php");
 
    } else {
 
        $row = mysql_query("SELECT * FROM posts WHERE pid='$id'");
        $row = mysql_fetch_array($row);
 
        include template('edit');
 
    }
 
} elseif ($action == 'newcat') {//新建分类
 
    $cat = isset($_POST['category']) ? $_POST['category'] : 0;
 
    if ($_SERVER['REQUEST_METHOD'] == 'POST') {
 
        if ($cat == '') { echo "缺少必填项nnnn返回";    exit;}
 
        $insertCat = "INSERT INTO category (category) VALUES ('$cat')";
 
        if (!mysql_query($insertCat,$sql)){
            die('ERROR: ' . mysql_error());
        }
 
        header("location: index.php");
 
    }
    include template('jioncat');
 
} elseif ($action == 'vcat') {
 
    $cid = $_GET['cid'];
 
  $revcats    = "SELECT * FROM posts WHERE cid='$cid' ORDER BY cid DESC";
    $items     = 1;
    $page      = isset($_GET['page']) ? intval($_GET['page']) : 1;
    $page      = ($page =='' && $page < 0) ? 1 : $page;
    $total     = mysql_num_rows(mysql_query($revcats));//数据条目总数
    $pageall   = ceil($total/$items);
    $offset    = ($page-1)*$items;//数据开始位置
    $revcats    .= " limit {$offset},{$items}";//每页显示
    $revcat   = mysql_query($revcats);
 
    $prev = $page - 1;
    $next = $page + 1;
    $goPrev = "上一页";
    $goNext = "下一页";
 
    if ($page == $pageall){ $goNext = NULL;}
 
    $pagestate = '';
 
    if ($page == 1 && $pageall > 1) {
        $pagestate .=  $goNext;
    } elseif ($pageall > $page || $page >1) {
        $pagestate .= $goNext . '|' .$goPrev;
    } elseif ($page >1 ) {
        $pagestate .=  $goPrev;
    } else {
        $pagestate .=  'Just One Page';
    }
 
    $pagelinks = '';
 
    for ($i = 1; $i <= $pageall; $i++) {
        $pagelinks .= ($i != $page) ? "$i" : $i;
        $pagelinks .= ($i < $pageall) ? '-' : null;
    }
 
    $data   = array();
 
    while ($vclist = mysql_fetch_array($revcat)) {
        $data[] = $vclist;
    }
 
    include template('cplist');
 
}
 
mysql_close($sql);

题外话了，一个access转换成mysql数据库的实例

点击下载:http://file.111com.net/download/2013/05/14/db2mysql.zip

相关文章

精彩推荐