在网页中显示mysql中的两个数据库时出现问题

kmbjn2e3  于 2021-06-23  发布在  Mysql
关注(0)|答案(2)|浏览(318)

我在网页中显示两个数据库时遇到问题。我有一个数据库，用户可以在其中创建一个名为“tickets”的新“ticket”，当该ticket标记为“pending”时，它会将数据库条目移动到一个名为“out\u tickets”的新数据库表中。所以在我的index.php页面上，我有一个 Jmeter 板视图来显示新的“票据”以及“待定”票据。但是现在我很难在index.php上显示来自数据库的“待定”票证结果。
这是我的密码：

  1. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
  2. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  3. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
  4. <style type="text/css">
  5.     .wrapper{
  6.         width: 0 auto;
  7.         margin: 0 auto;
  8.     }
  9.     .page-header h2{
  10.         margin-top: 0;
  11.     }
  12.     table tr td:last-child a{
  13.         margin-right: 15px;
  14.     }
  15. </style>
  16. <script type="text/javascript">
  17.     $(document).ready(function(){
  18.         $('[data-toggle="tooltip"]').tooltip();   
  19.     });
  20. </script>
  21. </p>
  22. <body>
  23. <div class="wrapper">
  24.     <div class="container-fluid">
  25.         <div class="row">
  26.             <div class="col-md-12">
  28.                 </div>
  29.                 <?php
  30.                 // Include config file
  31.                 require_once 'config.php';
  33.                 // Attempt select query execution
  34.                 $sql = "SELECT * FROM tickets";
  35.                 if($result = mysqli_query($link, $sql)){
  36.                     if(mysqli_num_rows($result) > 0){
  37.                         echo "<table class='table table-bordered table-striped'>";
  38.                             echo "<thead>";
  39.                                 echo "<tr>";
  40.                                     echo "<th>#</th>";
  41.                                     echo "<th>Name</th>";
  42.                                     echo "<th>Address</th>";
  43.                                     echo "<th>Contact Details</th>";
  44.                                     echo "<th>Email</th>";
  45.                                     echo "<th>Job Type</th>";
  46.                                     echo "<th>Description</th>";
  47.                                     echo "<th>Action</th>";
  48.                                 echo "</tr>";
  49.                             echo "</thead>";
  50.                             echo "<tbody>";
  51.                             while($row = mysqli_fetch_array($result)){
  52.                                 echo "<tr>";
  53.                                     echo "<td>" . $row['id'] . "</td>";
  54.                                     echo "<td>" . $row['client_name'] . "</td>";
  55.                                     echo "<td>" . $row['client_address'] . "</td>";
  56.                                     echo "<td>" . $row['client_contact'] . "</td>";
  57.                                     echo "<td>" . $row['client_email'] . "</td>";
  58.                                     echo "<td>" . $row['client_jobtype'] . "</td>";
  59.                                     echo "<td>" . $row['client_description'] . "</td>";
  60.                                     echo "<td>";
  61.                                         echo "<a href='read.php?id=". $row['id'] ."' title='View Task' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'></span></a>";
  62.                                         echo "<a href='update.php?id=". $row['id'] ."' title='Update Task' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
  63.                                         echo "<a href='delete.php?id=". $row['id'] ."' title='Delete Task' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";
  64.                                         echo "<a href='pending.php?id=". $row['id'] ."' title='Task Pending' data-toggle='tooltip'><span class='glyphicon glyphicon-time'></span></a>";
  65.                                         echo "<a href='complete.php?id=". $row['id'] ."' title='Mark Complete' data-toggle='tooltip'><span class='glyphicon glyphicon-ok'></span></a>";
  67.                                     echo "</td>";
  68.                                 echo "</tr>";
  69.                             }
  70.                             echo "</tbody>";                            
  71.                         echo "</table>";
  72.                         // Free result set
  73.                         mysqli_free_result($result);
  74.                     } else{
  75.                         echo "<p class='lead'><em>No records were found.</em></p>";
  76.                     }
  77.                 } else{
  78.                     echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
  79.                 }
  81.                 // Close connection
  82.                 mysqli_close($link);
  83.                 ?>
  84.             </div>
  85.         </div>        
  86.     </div>
  87. </div>
  88. <h1 style="font-size:25px;
  89.            background-color:darkgray;
  90.            border:2px solid black;
  91.            text-align:center">
  92.     Outstanding Tasks
  93. </h1>
  94. <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.css">
  95. <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
  96. <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.js"></script>
  97. <style type="text/css">
  98.     .wrapper{
  99.         width: 0 auto;
  100.         margin: 0 auto;
  101.     }
  102.     .page-header h2{
  103.         margin-top: 0;
  104.     }
  105.     table tr td:last-child a{
  106.         margin-right: 15px;
  107.     }
  108. </style>
  109. <script type="text/javascript">
  110.     $(document).ready(function(){
  111.         $('[data-toggle="tooltip"]').tooltip();   
  112.     });
  113. </script>
  114. </p>
  115. <body>
  116. <div class="wrapper">
  117.     <div class="container-fluid">
  118.         <div class="row">
  119.             <div class="col-md-12">
  121.                 </div>
  122.                 <?php
  123.                 require_once 'config.php';
  124.                 // Attempt select query execution
  125.                 $sql = "SELECT * FROM out_tickets";
  126.                 if($result = mysqli_query($link, $sql)){
  127.                     if(mysqli_num_rows($result) > 0){
  128.                         echo "<table class='table table-bordered table-striped'>";
  129.                             echo "<thead>";
  130.                                 echo "<tr>";
  131.                                     echo "<th>#</th>";
  132.                                     echo "<th>Name</th>";
  133.                                     echo "<th>Address</th>";
  134.                                     echo "<th>Contact Details</th>";
  135.                                     echo "<th>Email</th>";
  136.                                     echo "<th>Job Type</th>";
  137.                                     echo "<th>Description</th>";
  138.                                     echo "<th>Action</th>";
  139.                                 echo "</tr>";
  140.                             echo "</thead>";
  141.                             echo "<tbody>";
  142.                             while($row = mysqli_fetch_array($result)){
  143.                                 echo "<tr>";
  144.                                     echo "<td>" . $row['id'] . "</td>";
  145.                                     echo "<td>" . $row['client_name'] . "</td>";
  146.                                     echo "<td>" . $row['client_address'] . "</td>";
  147.                                     echo "<td>" . $row['client_contact'] . "</td>";
  148.                                     echo "<td>" . $row['client_email'] . "</td>";
  149.                                     echo "<td>" . $row['client_jobtype'] . "</td>";
  150.                                     echo "<td>" . $row['client_description'] . "</td>";
  151.                                     echo "<td>";
  152.                                         echo "<a href='read.php?id=". $row['id'] ."' title='View Task' data-toggle='tooltip'><span class='glyphicon glyphicon-eye-open'></span></a>";
  153.                                         echo "<a href='update.php?id=". $row['id'] ."' title='Update Task' data-toggle='tooltip'><span class='glyphicon glyphicon-pencil'></span></a>";
  154.                                         echo "<a href='delete.php?id=". $row['id'] ."' title='Delete Task' data-toggle='tooltip'><span class='glyphicon glyphicon-trash'></span></a>";
  155.                                         echo "<a href='pending.php?id=". $row['id'] ."' title='Task Pending' data-toggle='tooltip'><span class='glyphicon glyphicon-time'></span></a>";
  156.                                         echo "<a href='complete.php?id=". $row['id'] ."' title='Mark Complete' data-toggle='tooltip'><span class='glyphicon glyphicon-ok'></span></a>";
  158.                                     echo "</td>";
  159.                                 echo "</tr>";
  160.                             }
  161.                             echo "</tbody>";                            
  162.                         echo "</table>";
  163.                         // Free result set
  164.                         mysqli_free_result($result);
  165.                     } else{
  166.                         echo "<p class='lead'><em>No records were found. </em></p>";
  167.                     }
  168.                 } else{
  169.                     echo "ERROR: Could not able to execute $sql. " . 
  170.  mysqli_error($link);
  171.                 }
  173.                 // Close connection
  174.                 mysqli_close($link);
  175.                 ?>
  176.             </div>
  177.         </div>        
  178.     </div>
  179. </div>

正如你看到的第一个 $sql = "SELECT * FROM tickets"; 行，但这个不行 $sql = "SELECT * FROM out_tickets"; 我在mysql中有这两个数据库，可以从phpmyadmin中看到其中的数据
这是我得到的错误：

  1. Warning: mysqli_query(): Couldn't fetch mysqli in 
  2. C:\index.php on line 211
  4. Warning: mysqli_error(): Couldn't fetch mysqli in 
  5. C:\index.php on line 254
  7. ERROR: Could not able to execute SELECT * FROM out_tickets. 
  9. Warning: mysqli_close(): Couldn't fetch mysqli in 
  10. C:\index.php on line 258
mysqlphp

2条答案

按热度按时间
cld4siwp

cld4siwp1#

你说过有两个数据库里面有特定的表。我以前看过你的代码 SELECT * FROM out_tickets 等分线 require_once 'config.php'; . 你必须连接到另一个数据库（根据你的话判断）。

赞(0）分享  回复(0）举报  2021-06-23
umuewwlo

umuewwlo2#

我认为config.php只连接到第一个数据库。您只需将另一个连接字符串设置到另一个数据库，将其命名为$link\u 2，并在查询out\u票证时使用$link\u 2即可

赞(0）分享  回复(0）举报  2021-06-23
我来回答

相关问题

    查看更多

    热门标签

    更多
    JavaquerypythonNode开发语言requestUtil数据库Table后端算法LoggerMessageElementParser

    最新问答

    更多
    • 蜀ICP备13028337号-1 大数据知识库 https://www.saoniuhuo.com © All rights reserved
    • 本站内容来源互联网,如果侵犯您的权益请联系我们删除, 联系方式：448109455@qq.com