如何使用 JavaScript 从数据库中检索值并将其显示在页面中

how to retrieve values from database and show it in a page using javascript

本文关键字：显示 JavaScript 何使用 数据库 检索      更新时间：2023-09-26

我有一个下拉字段，当我选择高利率时，我有 2 个选项(费率高和费率低(，它应该按降序显示结果，或者如果我选择低速率，它应该按升序显示结果。我尝试了不起作用的代码。

我的 HTML 代码是：

<select id="ddlViewBy"  onchange="order()">
  <option value="high">Rate(high)</option>
  <option value="low">Rate(low)</option>
</select>

我的 JavaScript 代码是：

function order() { 
  var e = document.getElementById("ddlViewBy");
  var strUser = e.options[e.selectedIndex].value;
  if(strUser == 'high')
  {
  <?php
  $post->id="10";
  $mylink = $wpdb->get_results($wpdb->prepare("SELECT * FROM wp_biddings WHERE job_id = %d ORDER BY client_bill DESC", $post->id), ARRAY_A);
  if($_GET['bid_id'])
  {
    foreach ( $mylink as $row ) 
    {   
    $id= $row['user_id'];
    $nam=$row["name"];
    $stat=$row['state'];
    $cnty=$row['country'];
    $desc=$row["description"];
    $bid=$row['id'];
    $dat=$row['submission_date'];
    echo '<a href="../../wp-content/themes/businessfinder/profile_register.php?id=$id&view" target="_blank">';
    echo "<div class='mr-btm' style='width:98%'>";
    echo "<h3 style='text-transform:uppercase; line-height:0'><b>$name</b></h3>";
    echo "<p style='color:#808080; text-transform:uppercase;'>$stat,$cnty</p>";
    echo "<p style='color:#808080;'>$desc</p>";
    echo "<date style='color:#35cbc9;'>categories : </date>";
    echo "<date style='color:#808080;'>";
    if($row["plumbing"] != '')
    echo $row["plumbing"]; 
    if($row["electrical"] != '') 
    echo $row["electrical"];
    if($row["heating"] != '')
    echo ",".$row["heating"]; 
    if($row["ventilation"] != '')
    echo ",".$row["ventilation"]; 
    if($row["flooring"] != '')
    echo ",".$row["flooring"]; 
    echo ".</date>";
    echo "<table class='btm-cm'><tr><td>";
    echo "<date style='color:#35cbc9;'> Id : </date><date style='color:#808080;'>$bid</date> </td> <td style='color:#35cbcp;'>  | </td><td>"; 
    echo "<date style='color:#35cbc9;'> submitted on:  </date><date style='color:#808080;'>$dat</date></td></tr></table></div></a>";
    }
  }
  else
  {
  echo "nothing found";
  }
}
?>
}
else if(strUser == 'low')
{
<?php
$post->id="10";
$mylink = $wpdb->get_results($wpdb->prepare("SELECT * FROM wp_biddings WHERE job_id = %d ORDER BY client_bill ASC", $post->id), ARRAY_A);
  if($_GET['bid_id'])
  {
    foreach ( $mylink as $row ) 
    {   
    $id= $row['user_id'];
    $nam=$row["name"];
    $stat=$row['state'];
    $cnty=$row['country'];
    $desc=$row["description"];
    $bid=$row['id'];
    $dat=$row['submission_date'];
    echo '<a href="../../wp-content/themes/businessfinder/profile_register.php?id=$id&view" target="_blank">';
    echo "<div class='mr-btm' style='width:98%'>";
    echo "<h3 style='text-transform:uppercase; line-height:0'><b>$name</b></h3>";
    echo "<p style='color:#808080; text-transform:uppercase;'>$stat,$cnty</p>";
    echo "<p style='color:#808080;'>$desc</p>";
    echo "<date style='color:#35cbc9;'>categories : </date>";
    echo "<date style='color:#808080;'>";
    if($row["plumbing"] != '')
    echo $row["plumbing"]; 
    if($row["electrical"] != '') 
    echo $row["electrical"];
    if($row["heating"] != '')
    echo ",".$row["heating"]; 
    if($row["ventilation"] != '')
    echo ",".$row["ventilation"]; 
    if($row["flooring"] != '')
    echo ",".$row["flooring"]; 
    echo ".</date>";
    echo "<table class='btm-cm'><tr><td>";
    echo "<date style='color:#35cbc9;'> Id : </date><date style='color:#808080;'>$bid</date> </td> <td style='color:#35cbcp;'>  | </td><td>"; 
    echo "<date style='color:#35cbc9;'> submitted on:  </date><date style='color:#808080;'>$dat</date></td></tr></table></div></a>";
    }
  }
  else
  {
  echo "nothing found";
  }
}
?>
}
}
</script>
把

php 想象成一封信的作者，然后把它放在信封里，蜗牛邮寄到浏览器。浏览器打开它，阅读它，然后运行说明。信件的作者在发布后无法添加更多内容。

换句话说，PHP在服务器端执行，javascript在客户端执行

你会想要研究一下ajax。

这是帮助您入门的手册

相关文章：