网站后台程序用的php,目前用的mysql,我是想单独弄一个.db的文件做数据库!
这样在别的机器上也可以运行,就是能更简洁地迁移网站!
===============
有的说要弄个什么驱动,做什么连接文件的,还说用access的??我这方面很菜,麻烦大侠们说清楚,先谢谢啦!!!
解决的还有加分喔!!
.db文件怎么用?? 这是关于网站的?网站做好了,在不用安装数据库的情况下,怎么单独用.db做数据库?
答案:2 悬赏:70 手机版
解决时间 2021-04-08 19:38
- 提问者网友:树红树绿
- 2021-04-08 13:02
最佳答案
- 五星知识达人网友:枭雄戏美人
- 2021-04-08 13:19
不能用.db, 可以直接使用access的.mdb数据库. 主要是链接的时候有问题,找个好的数据库类就可以. <?php$conn = @new COM("ADODB.Connection") or die ("ADO连接失败!");$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("include/#mydb.mdb");$conn->Open($connstr);//创建记录集查询?>Add.php<?php$name=$_POST['user_name'];$content=$_POST['user_post'];if ($name<>"" and $content<>""){if($name="admin" or $content="admin"){echo "<script language='javascript'>alert('你要干什么!');location='index.php';</script>";}include_once("include/conn.php");$rs = $conn->Execute("insert into contents (name,content) values ('$name','$content')");header("location:index.php");}elseecho "<script language='javascript'>alert('字段不能有空!');location='index.php';</script>";?>Del.php<?session_start();if($_SESSION['admin']=="OK"){include_once("include/conn.php");$sql="delete from contents where id=".$_GET['id'];$rs = $conn->Execute($sql);header("location:admin_index.php");}?>Show.php<?session_start();if($_SESSION['admin']=="OK"){include_once("include/conn.php");$sql="select * from contents where id=".$_GET['id']; $rs = $conn->Execute($sql);$name=$rs->Fields['name']->Value;$content=$rs->Fields['content']->Value;$id=$rs->Fields['id']->Value;?><form action="modify_save.php" method="post" name="name1">ID :<?=$id?><input type="hidden" name="id" value=<?=$id?> > 姓名:<?=$name?>
留言:<textarea name="post_contents" rows="10" cols="50"><?=$content?></textarea> <input type="submit" value="提交修改"> </form><?}$rs->Close();$conn->Close();$rs = null;$conn = null;?>Edit.php<?session_start();if($_SESSION['admin']=="OK"){include_once("include/conn.php");$sql="update contents set content='".$_POST['post_contents']."' where id=".$_POST['id'];$rs = $conn->Execute($sql);}header("location:admin_index.php");?>
留言:<textarea name="post_contents" rows="10" cols="50"><?=$content?></textarea> <input type="submit" value="提交修改"> </form><?}$rs->Close();$conn->Close();$rs = null;$conn = null;?>Edit.php<?session_start();if($_SESSION['admin']=="OK"){include_once("include/conn.php");$sql="update contents set content='".$_POST['post_contents']."' where id=".$_POST['id'];$rs = $conn->Execute($sql);}header("location:admin_index.php");?>
全部回答
- 1楼网友:詩光轨車
- 2021-04-08 13:57
ado控件的fieldbyname('name').asstring
我要举报
如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
点此我要举报以上问答信息
大家都在看
推荐资讯