资源描述：
《实验5-1利用php实现mysql数据库操作》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。
1、实验5-1利用PHP实现mysql数据库操作【实验目的】1掌握SQL语言和数据库的操纵方法。2了解PIIP语法与动态网页的制作。【实验条件】一个有效的Apache>PHP>Mysql服务的运行环境（需要安装appserv软件）。【实验内容与步骤】注意：安装之前，检查自己的机器上是否已安装iis软件，若已安装则停止运行iisweb服务。1.安装appserv软件：双击appserv软件，按向导提示进行安装（过程略）。2.Mysql数据库的操作：建立book数据库和catalog数据表（1）在windows中打开命令提示符窗口，输入
2、“cdc:appservmysqlbin”命令进入到Mysql数据库服务器安装目录下的bin子目录，执行"mysql-uroot”命令，连接到Mysql数据库管理系统，如图5-1。（2）建立一个book数据库（类似于一个excel文件）。在Mysql数据库管理系统下，使用命令"createdatabasebook建立一个book数据库。"usebook;”（注意：若数据库booklL经建立,可先用“dropdatabaseifexistsbook;将它删除，然后再建立）使用命令"usebook;”，打开book数据库（3）
3、在数据库book中建立一个catalog表（类似于一个excel工作表,当中的数据具有各自的数据名和数据类型）使用命令：“createtablecatalog(booknoint(10),booknametext,pricetext,authortext)type二MylSAM;”来建立此''表(4)在数据表catalog中添加几条数据记录：insertintocatalogsetbookno二1,bookname=，电子商务',price=，25’,author=，张泽’；insertintocatalogsetbookno二
4、2,bookname二'会计学原理',price二'28',author二'李泽’；insertintocatalogsetbookno=3,bookname=，商务英语,price二'21’,author二'慧泽';（5）查询数据表catalog中的所有内容select*fromcatalog;（6）最后，使用“quit”命令退出mysql数据库管理系统。1.利用php脚本，编写动态网页，进行数据库操作（1）利用记事本，建立一个如下的网页index,htm,并存放到c:appservwww目录下（此目录为web服务器的站
5、点根目录）
^书</七讥1巳》</head><body><palign="center">操作菜单</p>target='v_blankdV>^书浏览</a>targert二"_blank">图书添加</a>target="y_blarik-v>^书刪除</a>■targ航二"_tdank">囹书舷灰a><palign=<vcenter"><ahref=*vbrowse・php"<ahref='vappend,php"<ahref=-vdelete・php"<ahref=f"update・ph</p><p>6、p"</p></body></html>(2)编写图书浏览的网页browse,php<html><head><title>图书浏览〈/title></head><body><tableborder=l><?php$host=Tocalhost";//数扌居库服务器名$user^root〃登录数据库使用的用户名$password="'f:$dbname二"book"://数据库名称mysql_connect(“$host","$user","{password^)ordie("无法连接MySQL数据库朋务器「);$db=irLy</p><p>7、sql.select.db^Sdbname")ordie("无法连接数据库！")；//打开藪据库bookmysql^queryC*setnamesGBK");SgetD^ysql^query("select*fromcatalog"):while($agetD=mysql^fetch^array($getD)){?><tr><td><?=$agetD[bookno]?></td><td><?=$agetD[booknane]?></td><td><?=$agetD[price]?></td><td><?=$agetD[autho</p><p>8、r]?></td></tr><?php}?></table></body></html>(3)编写图书添加的网页append,php<?phpIf($_POST[doappend]匸“〃){$host二〃localhost";//数据库服务器名$user^roo</p> </div>
<div class="mt-3 bg-white">
<div class="d-lg-block d-none px-3 px-lg-4 py-3 border-bottom text-center font-18"> 当前文档最多预览五页，下载文档查看全文 </div>
<div class="detail-fixed-feature d-none d-lg-block" id="detailFixedFeatureBox">
<div class="px-3 px-lg-4 py-3 d-flex align-items-center justify-content-between fixed-feature-box" id="detailFixedFeature">
<div class="d-lg-flex d-none align-items-center">
<div>
<a class="btn btn-outline-danger article-state" href="javascript:;" data-id="35342178" data-code="438274" data-title="实验5-1利用php实现mysql数据库操作"> <span>侵权申诉</span> </a>
<button type="button" class="btn btn-outline-secondary with-light ml-2" data-toggle="modal" data-target="#reportModal" data-id="35342178"><span>举报</span></button>
</div>
<nav class="d-flex align-items-center ml-4" id="anchorPoint">
<a href="javascript:;" class="btn btn-light anchor-pre px-2"><i class="iconfont text-muted"></i></a>
<div class="text-muted mb-0 pre-point-list" id="prePointList">
<a class="px-2 active nav-link" href="#anchorImg0">1</a>
<a class="px-2 nav-link" href="#anchorImg1">1</a>
<a class="px-2 nav-link" href="#anchorImg2">2</a>
<a class="px-2 nav-link" href="#anchorImg3">3</a>
<a class="px-2 nav-link" href="#anchorImg4">4</a>
<a class="px-2 nav-link" href="#anchorImg5">5</a>
/ <span class="px-2" id="prePageNums">6</span>
</div>
<a href="javascript:;" class="btn btn-light anchor-next px-2"><i class="iconfont text-muted"></i></a>
</nav>
</div>
<div class="d-flex align-items-center">
<p class="d-lg-block d-none font-14 text-black-50 mb-0 mr-2">此文档下载收益归作者所有</p>
<button class="btn btn-danger detail-download-btn px-3 ml-0 font-16" data-btn="downloadfile" style="width:128px;height:40px;" data-id="35342178" data-price="1000" data-size="59.94 KB" data-page="6页" data-type="docx" data-binddown="true" data-isold="new_content" data-vip="0" data-title="实验5-1利用php实现mysql数据库操作">下载文档</button>
</div>
</div>
</div>
</div>
<div class="d-block d-lg-none px-3 px-lg-4 py-3 border-bottom text-center font-14" style="color:#999">当前文档最多预览五页，下载文档查看全文</div>
<button class="btn d-block w-100 d-lg-none btn-danger detail-download-btn px-3 ml-0 font-16" data-btn="downloadfile" data-id="35342178" data-price="1000" data-size="59.94 KB" data-page="6页" data-type="docx" data-binddown="true" data-isold="new_content" data-vip="0" data-title="实验5-1利用php实现mysql数据库操作">点击下载本文档
</button>
</div>
<div class="px-3 px-lg-4 py-3 bg-white mt-3">
<ul class="nav custom-tab border-bottom" id="myTab" role="tablist">
<li class="nav-item" role="presentation">
<a class="nav-link active px-0 mr-4 font-16 font-weight-light pb-3" id="tips-tab" data-toggle="tab" href="#showTips" role="tab" aria-controls="showTips" aria-selected="true">版权提示</a>
</li>
<li class="nav-item" role="presentation">
<a class="nav-link px-0 pb-3 font-16 font-weight-light text-black-50" href="/d-35342178.html" >下载文档</a>
</li>
<dl class="flex-grow-1 mb-0 d-lg-none">
<li class="ml-3 float-right d-lg-none">
<button type="button" class="btn btn-light" data-toggle="modal" data-target="#reportModal" data-id="35342178"><span>举报</span></button>
</li>
</dl>
</ul>
<div class="tab-content with-content pt-3" id="myTabContent">
<div class="tab-pane fade show active font-14" id="showTips" role="tabpanel" aria-labelledby="showTips-tab">
温馨提示： <br>
1. 部分包含数学公式或PPT动画的文件，查看预览时可能会显示错乱或异常，文件下载后无此问题，请放心下载。<br>
2. 本文档由用户上传，版权归属用户，天天文库负责整理代发布。如果您对本文档版权有争议请及时联系客服。<br>
3. 下载前请仔细阅读文档内容，确认文档内容符合您的需求后进行下载，若出现内容与标题不符可向本站投诉处理。<br>
4. 下载文档时可能由于网络波动等原因无法下载或下载错误，付费完成后未能成功下载的用户请联系客服处理。 <br>
</div>
</div>
</div>
</div>
<div class="detail-sidebar d-none d-lg-block">
<div id="columnDetailSiderRight">
<div class="detail-yourlike mt-0 pb-2" id="relativeArticle">
<div class="border-bottom py-2 d-flex align-items-center justify-content-between">
<h5 class="font-16">相关文章</h5>
<a class="font-14 hover-letter-spacing" href="/ucenter/search/index.html?text=实验5-1利用php实现mysql数据库操作" target="_blank" rel="nofollow">更多<i class="iconfont font-12 pl-1"></i></a>
</div>
<ul class="font-14 like-list">
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-9777643.html" title="php实现mysql数据库连接" target="_blank"><span class="text-danger">p</span><span class="text-danger">h</span><span class="text-danger">p</span><span class="text-danger">实</span><span class="text-danger">现</span><span class="text-danger">m</span><span class="text-danger">y</span><span class="text-danger">s</span><span class="text-danger">q</span><span class="text-danger">l</span><span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>连接</a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-pdf" href="/p-34443956.html" title="php操作mysql" target="_blank"><span class="text-danger">p</span><span class="text-danger">h</span><span class="text-danger">p</span><span class="text-danger">操</span><span class="text-danger">作</span><span class="text-danger">m</span><span class="text-danger">y</span><span class="text-danger">s</span><span class="text-danger">q</span><span class="text-danger">l</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-36316887.html" title="php操作mysql数据库的步骤" target="_blank"><span class="text-danger">p</span><span class="text-danger">h</span><span class="text-danger">p</span><span class="text-danger">操</span><span class="text-danger">作</span><span class="text-danger">m</span><span class="text-danger">y</span><span class="text-danger">s</span><span class="text-danger">q</span><span class="text-danger">l</span><span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>的步骤</a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-36326086.html" title="php操作mysql数据库编程" target="_blank"><span class="text-danger">p</span><span class="text-danger">h</span><span class="text-danger">p</span><span class="text-danger">操</span><span class="text-danger">作</span><span class="text-danger">m</span><span class="text-danger">y</span><span class="text-danger">s</span><span class="text-danger">q</span><span class="text-danger">l</span><span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>编程</a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-36443845.html" title="PHP访问MySQL数据库" target="_blank">PHP访问M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-38846065.html" title="PHP操作MySQL数据库的函数" target="_blank">PHP<span class="text-danger">操</span><span class="text-danger">作</span>M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>的函<span class="text-danger">数</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-38846067.html" title="PHP操作MySQL数据库" target="_blank">PHP<span class="text-danger">操</span><span class="text-danger">作</span>M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-41066078.html" title="PHP操作MySQL数据" target="_blank">PHP<span class="text-danger">操</span><span class="text-danger">作</span>M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-ppt" href="/p-45343102.html" title="PHP操作MySQL数据库" target="_blank">PHP<span class="text-danger">操</span><span class="text-danger">作</span>M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span></a>
</li>
<li class="">
<a class="text-ellipsis office-icon text-dark office-icon-doc" href="/p-57321609.html" title="实验十六-PHP操纵MySQL数据库.doc" target="_blank"><span class="text-danger">实</span><span class="text-danger">验</span>十六<span class="text-danger">-</span>PHP<span class="text-danger">操</span>纵M<span class="text-danger">y</span>SQL<span class="text-danger">数</span><span class="text-danger">据</span><span class="text-danger">库</span>.doc</a>
</li>
</ul>
</div>
<div class="detail-yourlike pb-2">
<div class="border-bottom py-2">
<h5 class="font-16">相关标签</h5>
</div>
<ul class="font-14 like-list d-flex flex-wrap">
<a class="search-tag" href="/tags/1560613/" target="_blank">数据库</a>
<a class="search-tag" href="/tags/540408/" target="_blank">实验</a>
<a class="search-tag" href="/tags/540160/" target="_blank">操作</a>
<a class="search-tag" href="/tags/686114/" target="_blank">利用</a>
<a class="search-tag" href="/tags/1456203/" target="_blank">实现</a>
</ul>
</div>
<script src="/d/js/acmsd/thea1.js"></script>
</div>
</div>
</div>
<footer>
<div class="container d-none d-lg-block mb-4">
<div class="d-flex justify-content-between footer-nav">
<ul class="d-flex foot-nav">
<li>
<h5>常见问题</h5>
<a class=text-decoration-none href=/help/wenti/upload/ target=_blank>
关于上传
</a><a class=text-decoration-none href=/help/wenti/xiazai/ target=_blank>
关于下载
</a><a class=text-decoration-none href=/help/wenti/qinquan/ target=_blank>
关于侵权
</a><a class=text-decoration-none href=/help/wenti/fenxaing/ target=_blank>
分享文档赚钱教程
</a> </li>
<li>
<h5>关于我们</h5>
<a class=text-decoration-none href=/help/about/wzjs/ target=_blank>
网站介绍
</a><a class=text-decoration-none href=/help/about/gywm/ target=_blank>
关于我们
</a><a class=text-decoration-none href=/help/about/lxwm/ target=_blank>
联系我们
</a> </li>
<li>
<h5>版权问题</h5>
<a class=text-decoration-none href=/help/banquan/bqsm/ target=_blank>
版权声明
</a><a class=text-decoration-none href=/help/banquan/qqcl/ target=_blank>
侵权处理
</a><a class=text-decoration-none href=/help/banquan/mzsm/ target=_blank>
免责声明
</a> </li>
<li>
<h5>协议条款</h5>
<a class=text-decoration-none href=/help/xieyi/yhxy/ target=_blank>
用户协议
</a><a class=text-decoration-none href=/help/xieyi/fwtk/ target=_blank>
用户服务条款
</a><a class=text-decoration-none href=/help/xieyi/ysbh/ target=_blank>
用户隐私保护
</a> </li>
<li>
<h5>网站导航</h5>
<a class="text-decoration-none help-nav-item" href="/sitemaps.xml" data-name="网站地图" target="_blank">网站地图</a>
<a class="text-decoration-none help-nav-item" href="/list.html" data-name="全部分类" target="_blank">全部分类</a>
<a class="text-decoration-none help-nav-item" href="/sitemaps/index.html" data-name="资源地图" target="_blank">资源地图</a>
</li>
</ul>
<div class="foot-qrcode d-flex">
<div>
<div class="subsitute-bg"><img src="https://www.wenku365.com/d/file/2022/07-08/f23df57d987ef7ad9acb33fe5abf9854.jpg"></div>
<p>关注公众号<br></p>
</div>
</div>
</div>
</div>
<div class="footer-copyright">
<p><a href="/" target="_blank">天天文库</a>站为“文档C2C交易模式”，即用户上传的文档直接卖给(下载)用户，本站只是中间服务平台，本站所有文档下载所得的收益归上传人(含作者)所有【成交的100%(原创)】。</p>
<p>本站是网络服务平台方，若您的权利被侵害，侵权客服QQ：3074922707 欢迎举报。</p>
<p>Copyright 2004-2021 <a href="https://www.wenku365.com/" target="_blank">wenku365.com</a> All Rights Reserved <a href="https://beian.miit.gov.cn/#/Integrated/index" rel="nofollow" target="_blank">闽ICP备15016911号-5 </a></p>
<p>闽公网安备 <a href="http://www.beian.gov.cn/portal/registerSystemInfo?recordcode=35052402000320" rel="nofollow" target="_blank">35052402000320</a></p>
<p> <a href="https://www.wenku365.com/zt.html" target="_blank">专题文集</a>
<a href="https://www.wenku365.com/zt-90007.html" target="_blank">丨职业培训</a>
<a href="https://www.wenku365.com/zt-90005.html" target="_blank">丨实用范文</a>
<a href="https://www.wenku365.com/zt-90010.html" target="_blank">丨商业材料</a>
<a href="https://www.wenku365.com/zt-90013.html" target="_blank">丨合同协议</a>
<a href="https://www.wenku365.com/zt-90009.html" target="_blank">丨PPT专题</a></p>
</div>
</footer>
<script src="//static.wenku365.com/wenku365/js/global.min.js?"></script>
<script src="//static.wenku365.com/wenku365/js/clipboard.min.js?"></script>
<script src="//static.wenku365.com/wenku365/js/jquery.treeview.js?"></script>
<script src="//static.wenku365.com/wenku365/js/jquery.share.min.js?"></script>
<script src="//static.wenku365.com/wenku365/js/common.min.js?"></script>
<script src="//static.wenku365.com/wenku365/js/downloadFile.js?"></script>
<script src="//static.wenku365.com/wenku365/js/loginWindow.js?"></script>
<script src="//static.wenku365.com/wenku365/js/windowRecharge.js?"></script>
<script src="//static.wenku365.com/wenku365/js/viewer.min.js?"></script>
<script src="//static.wenku365.com/wenku365/js/detail.js?"></script>
<!-- 2023-05-07 06:37:41 -->
</body>
</html>
