时间:2021-07-01 10:21:17 帮助过:3人阅读
1、借用AJAX方法,通过php读取数据库将大量数据显示在网页客户端上。
a、页面一加载完,执行函数Gett(),代码如下:
- <meta http-equiv="Content-Type" content="text/html; charset=" gb2312"=""><title></title><p> </p><br> <table width="75%" border="0" cellspacing="0"> <tbody><tr> <td width="25%" nowrap=""><br> <table width="75%" border="0" align="center" cellspacing="0"> <tbody><tr> <td width="50%" nowrap="">InputVoltage</td> <td width="50%" height="22" nowrap=""> <span id="InputVoltage"></span> V </td> </tr> <tr> <td nowrap="">Frequency</td> <td nowrap=""> <span id="Frequency"></span> Hz </td> </tr> </tbody></table></td> <td width="50%" nowrap="">
- </td> <td width="25%" nowrap="">
- <br> b、在服务端,将数据库的内容转为一维数组,并用xml格式保存起来。 <p></p><p> </p><pre name="code" class="sycode layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><!--?php $dbh = new PDO("sqlite:upsdata.dat", null, null); </li><li> $sth = $dbh--->query('SELECT * FROM t_ups_rundata');</li><li> $result = $sth->fetchAll();</li><li> $i=0;</li><li> $CountArray=0;</li><li> foreach($result[0] as $x=>$x_value)</li><li> </li><li>{</li><li> if($i%2==0)</li><li> {</li><li>$UPSData[$CountArray++]=$x_value;</li><li>}</li><li>$i++;</li><li>}header('Content-Type: text/xml');echo "<!--?xml version='1.0' encoding='utf-8'?-->";echo "<upsdataxml>"; echo</li><li>"<protocol_id>$UPSData[0]</protocol_id>";echo "<curr_time>$UPSData[1]</curr_time>";echo </li><li>"<input_phase>$UPSData[2]</input_phase>";echo "<inputvol_a>$UPSData[3]</inputvol_a>";</li><li> echo "<inputvol_b>$UPSData[4]</inputvol_b>";</li><li> echo "<inputvol_c>$UPSData[5]</inputvol_c>";</li><li> echo </li><li>"<output_phase>$UPSData[6]</output_phase>";echo "<outputvol_a>$UPSData[7]</outputvol_a>"; echo "<outputvol_b>$UPSData[8]</outputvol_b>"; echo "<outputvol_c>$UPSData[9]</outputvol_c>"; echo </li><li>"<output_load>$UPSData[10]</output_load>";echo </li><li>"<batt_total_vol>$UPSData[11]</batt_total_vol>";echo</li><li>"<batt_cap>$UPSData[12]</batt_cap>";echo</li><li>"<input_fre>$UPSData[13]</input_fre>";echo</li><li>"<ups_model>$UPSData[14]</ups_model>";echo</li><li>"<ups_manufactory>$UPSData[15]</ups_manufactory>";echo</li><li>"<ups_ver>$UPSData[16]</ups_ver>";echo</li><li>"<rate_vol>$UPSData[17]</rate_vol>";echo</li><li>"<rate_power>$UPSData[18]</rate_power>";echo</li><li>"<rate_fre>$UPSData[19]</rate_fre>";echo</li><li>"<rate_battvol>$UPSData[20]</rate_battvol>";echo</li><li>"<is_acfail>$UPSData[21]</is_acfail>";echo</li><li>"<is_bypass>$UPSData[22]</is_bypass>";echo</li><li>"<is_battlow>$UPSData[23]</is_battlow>";echo</li><li>"<is_upsfail>$UPSData[24]</is_upsfail>";echo</li><li>"<is_shutdown>$UPSData[25]</is_shutdown>";echo</li><li>"<is_testting>$UPSData[26]</is_testting>";echo</li><li>"<is_ups_offline>$UPSData[27]</is_ups_offline>";echo</li><li>"<e_temperature>$UPSData[28]</e_temperature>";echo </li><li>"<e_humidity>$UPSData[29]</e_humidity>";echo</li><li>"<input_default_vol>$UPSData[30]</input_default_vol>";echo</li><li>"<batt_mon_vol>$UPSData[31]</batt_mon_vol>";echo</li><li>"<ups_temp>$UPSData[32]</ups_temp>";echo</li><li>"<output_max_vol>$UPSData[33]</output_max_vol>";echo</li><li>"<output_min_vol>$UPSData[34]</output_min_vol>";echo</li><li>"<batt_temp>$UPSData[35]</batt_temp>";echo</li><li>"<is_horn>$UPSData[36]</is_horn>";echo</li><li>"<is_ups_type>$UPSData[37]</is_ups_type>";echo</li><li>"<is_guard>$UPSData[38]</is_guard>";echo "</upsdataxml>"; $dbh = null;?></li></ol></pre><br><p></p><p>完整代码下载:http://download.csdn.net/detail/aba13579/7877307</p><p><br> </p><p><br> </p><p><br> </p><p><br> </p><p><br> </p><p>2、通过提交表单的方式,在php服务器端的用$_GET()或$_POST()方式获取大量的数据写入数据库。</p><p> a、通过 <input class="inputButtonNormal" type="submit" name="b1" value="SubMit">的type="submit"类型将数据上传到PHP服务端上。 </p><p> </p><pre name="code" class="sycode layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li> <meta http-equiv="Content-Type" content="text/html; charset=" gb2312"=""> </li></ol></pre><br><p></p><p> b、PHP服务器端通过$_POST()获取数据写入数据库</p><p> </p><pre name="code" class="sycode layui-box layui-code-view layui-code-notepad"><ol class="layui-code-ol"><li><!--?php $temp = array(); $temp[0] = $_POST["UpsCommBaud"]; $temp[1] = $_POST["OfflineQueryTime"]; $temp[2] = $_POST["OfflineQueryNum"]; try{ </li><li>$IPGuard ="sqlite:ipguard.dat";</li><li>$dbh = new PDO($IPGuard, null, null); </li><li>$dbh--->exec("UPDATE t_ups_protocol set baudrate='$temp[0]'");</li><li>$dbh->exec("UPDATE t_env_param set interval='$temp[1]',offLine_Count='$temp[2]'");</li><li>$dbh->beginTransaction();</li><li>$dbh = null;</li><li>}</li><li>catch (PDOException $e){ echo 'Connection failed: ' . $e->getMessage(); $dbh = null;} ?></li></ol></pre><br><p></p><p><br> </p><p><br> </p><p><br> </p><p>完整代码下载:http://download.csdn.net/detail/aba13579/7877311</p><p><br> </p><p>3、借用AJAX方式,一次性传递一个数据到php服务器上并一次性将一个数据返回给web客户端。</p><p> 以下网址有详细介绍:http://www.w3school.com.cn/ajax/ajax_asp_php.asp,故不再详述。
- </p><div class="">
- <ul class="m-news-opt fix">
- <li class="opt-item">
- <a href="/PHPjiqiao-139951.html" target="_blank"><p>< 上一篇</p><p class="ellipsis">php精准计算模块bcmath</p></a>
- </li>
- <li class="opt-item ta-r">
- <a href="/PHPjiqiao-139953.html" target="_blank"><p>下一篇 ></p><p class="ellipsis">preg_replace改写preg_replace_callback的问题</p></a>
- </li>
- </ul>
- </div><div class="g-title fix">
- <h2 class="title-txt">人气教程排行</h2>
- </div><div class="m-rank u-dashed mb40">
- <ul>
- <li class="rank-item">
- <a href="/PHPjiqiao-379253.html" title="php如何获取跳转前的url" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num top">1</span>
- php如何获取跳转前的url </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-379019.html" title="php格林威治时间转换成当前时间的方法" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num second">2</span>
- php格林威治时间转换成当前时间的方法 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-366629.html" title="为什么php不能做大型系统?" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num third">3</span>
- 为什么php不能做大型系统? </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-207623.html" title="range函数怎么用" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">4</span>
- range函数怎么用 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-162433.html" title="php中计算页面加载时间几种方法总结_PHP教程" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">5</span>
- php中计算页面加载时间几种方法总结_PHP教程 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-140221.html" title="求帮助,关于paypal支付返回值修改订单状态" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">6</span>
- 求帮助,关于paypal支付返回值修改订单状态 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-103588.html" title="typecho怎么配置文章内容页?" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">7</span>
- typecho怎么配置文章内容页? </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-99213.html" title="PhpStorm左侧structure不显示文件的方法列表是这么回事?" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">8</span>
- PhpStorm左侧structure不显示文件的方法列表是这么回事? </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-92208.html" title="查看PHP的环境变量_PHP" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">9</span>
- 查看PHP的环境变量_PHP </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-170.html" title="PHP Primary script unknown 解决方法总结" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">10</span>
- PHP Primary script unknown 解决方法总结 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-148.html" title="php的命名空间与自动加载实现方法" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">11</span>
- php的命名空间与自动加载实现方法 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-133.html" title="解决laravel 出现ajax请求419(unknown status)的问题" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">174次</span>
- <span class="g-sort-num ">12</span>
- 解决laravel 出现ajax请求419(unknown status)的问题 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-462817.html" title="php 如何删除mysql记录" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">13</span>
- php 如何删除mysql记录 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-388448.html" title="PHP如何替换数组中的指定元素" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">14</span>
- PHP如何替换数组中的指定元素 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-124270.html" title="怎么去除字符串中非汉字、非字母、非数字的字符" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">15</span>
- 怎么去除字符串中非汉字、非字母、非数字的字符 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-112291.html" title="mysql如何一次执行多条SQL语句" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">16</span>
- mysql如何一次执行多条SQL语句 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-110669.html" title="修改header里面的Connection为close解决方法" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">17</span>
- 修改header里面的Connection为close解决方法 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-153.html" title="PHP基于session.upload_progress 实现文件上传进度显示功能详解" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">18</span>
- PHP基于session.upload_progress 实现文件上传进度显示功能详解 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-125.html" title="php5.6.x到php7.0.x特性小结" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">173次</span>
- <span class="g-sort-num ">19</span>
- php5.6.x到php7.0.x特性小结 </a>
- </li>
- <li class="rank-item">
- <a href="/PHPjiqiao-378118.html" title="php为什么会出现504错误" class="item-name ellipsis" target="_blank">
- <span class="g-art-count fr">172次</span>
- <span class="g-sort-num ">20</span>
- php为什么会出现504错误 </a>
- </li>
- </ul>
- </div><div class="footer">
- 本站所有资源全部来源于网络,若本站发布的内容侵害到您的隐私或者利益,请联系我们删除!</div><div style="display:none">
- <div class="login-box" id="login-dialog">
- <div class="login-top"><a class="current" rel="nofollow" id="login1" onclick="setTab('login',1,2);">登录</a></div>
- <div class="login-form" id="nav-signin">
- <!-- <div class="login-ico"><a rel="nofollow" class="qq" id="qqlogin" target="_blank" href="/user-center-qqlogin.html"> QQ </a></div> -->
- <div class="login-box-form" id="con_login_1">
- <form id="loginform" action="/user-center-login.html" method="post" onsubmit="return false;"></form>
- <p class="int-text">
- <input class="email" id="username" name="username" type="text" value="用户名或Email" onfocus="if(this.value=='用户名或Email'){this.value='';}" onblur="if(this.value==''){this.value='用户名或Email';};"></p>
- <p class="int-text">
- <input class="password1" type="password" id="password" name="password" value="******" onblur="if(this.value=='') this.value='******';" onfocus="if(this.value=='******') this.value='';">
- </p>
- <p class="int-info">
- <label class="ui-label"> </label>
- <label for="agreement" class="ui-label-checkbox">
- <input type="checkbox" value="" name="cookietime" id="cookietime" checked="checked">
- <input type="hidden" name="notforward" id="notforward" value="1">
- <input type="hidden" name="dosubmit" id="dosubmit" value="1">记住我的登录 </label>
- <a rel="nofollow" class="aright" href="/user-center-forgetpwd.html" target="_blank"> 忘记密码? </a></p>
- <p class="int-btn"><a rel="nofollow" id="loginbt" class="loginbtn"><span>登录</span></a></p>
- </div>
- <form id="regform" action="/user-center-reg.html" method="post"></form>
- <div class="login-reg" style="display: none;" id="con_login_2">
- <input type="hidden" name="t" id="t">
- <p class="int-text">
- <input id="email" name="email" type="text" value="Email" onfocus="if(this.value=='Email'){this.value='';}" onblur="if(this.value==''){this.value='Email';};"></p>
- <p class="int-text">
- <input id="uname" name="username" type="text" value="用户名或昵称" onfocus="if(this.value=='用户名或昵称'){this.value='';}" onblur="if(this.value==''){this.value='用户名或昵称';};"></p>
- <p class="int-text">
- <input type="password" id="pwd" name="password" value="******" onblur="if(this.value=='') this.value='******';" onfocus="if(this.value=='******') this.value='';"> </p>
- <p class="int-text1"><span class="inputbox">
- <input id="validate" name="validate" type="text" value="验证码" onfocus="if(this.value=='验证码'){this.value='';}" onblur="if(this.value==''){this.value='验证码';};">
- </span><span class="yzm-img"><img src="/user-checkcode-index" alt="看不清楚换一张" id="indexlogin"></span></p>
- <p class="int-info">
- <label>
- <input value="" name="agreement" id="agreement" checked="checked" type="checkbox">
- 我已阅读<a rel="nofollow" href="/user-center-agreement.html">用户协议</a>及<a rel="nofollow" href="/user-center-agreement.html">版权声明</a></label>
- </p>
- <p class="int-btn"><input type="hidden" name="dosubmit">
- <a rel="nofollow" class="loginbtn" id="register"><span>注册</span></a></p>
- </div>
- </div>
- </div>
- </div><div data-type="4" data-plugin="aroundbox" data-plugin-aroundbox-x="left" data-plugin-aroundbox-y="bottom" data-plugin-aroundbox-iconsize="60x60" data-plugin-aroundbox-fixed="1" data-plugin-aroundbox-offsetx="10"></div><table width="98%" height="100" border="0" cellspacing="0"> <tbody><tr> <td width="50%" nowrap="">OutputVoltage</td> <td width="50%" height="22" nowrap=""> <span id="OutputVoltage"></span> V </td> </tr> <tr> <td nowrap="">OutputMaxVoltage</td> <td height="22" nowrap=""> <span id="OutputMaxVoltage"></span> V </td> </tr> <tr> <td nowrap="">OutputMinVoltage</td> <td height="22" nowrap=""> <span id="OutputMinVoltage"></span> V </td> </tr>
- <!-- / 教程内容页 -->
- <!-- 页尾 -->
- <!-- / 页尾 -->
- <script src="https://hm.baidu.com/hm.js?6dc1c3c5281cf70f49bc0bc860ec24f2"></script><script>
- var _hmt = _hmt || [];
- (function() {
- var hm = document.createElement("script");
- hm.src = "https://hm.baidu.com/hm.js?6dc1c3c5281cf70f49bc0bc860ec24f2";
- var s = document.getElementsByTagName("script")[0];
- s.parentNode.insertBefore(hm, s);
- })();
- </script>
- <script type="text/javascript" src="/layui/layui.js"></script>
- <script>
- layui.use('code', function() {
- layui.code({
- elem: 'pre', //默认值为.layui-code
- about: false,
- skin: 'notepad',
- title: 'php怎么实现数据库验证跳转代码块',
- encode: true //是否转义html标签。默认不开启
- });
- });
- </script>
- </tbody></table></td></tr></tbody></table>