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

使用文本数据库一般是针对小型的应用程序了，这种不就需要安装数据库了，我们可以直接操作文本文件就可以了，但时怎么操作都不如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