Home >php教程 >php手册 >php中将文本数据库转为mysql数据库

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

WBOY
WBOYOriginal
2016-06-13 10:09:024002browse

使用文本数据库一般是针对小型的应用程序了,这种不就需要安装数据库了,我们可以直接操作文本文件就可以了,但时怎么操作都不如mysql数据库好用了,下面我来给大家介绍一个文本数据库转为mysql数据库实例。

 

 代码如下 复制代码
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     $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         $pagelinks .= ($i != $page) ? "$i" : $i;
        $pagelinks .= ($i     }
 
  // 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 "缺少必填项nnnn返回";
 
    } 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     $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         $pagelinks .= ($i != $page) ? "$i" : $i;
        $pagelinks .= ($i     }
 
    $data   = array();
 
    while ($vclist = mysql_fetch_array($revcat)) {
        $data[] = $vclist;
    }
 
    include template('cplist');
 
}
 
mysql_close($sql);

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

点击下载:http://file.bKjia.c0m/download/2013/05/14/db2mysql.zip

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn