如何在 html 按钮中使用 MySql 与 php - How To Use MySql in Html Button with php

How To Use MySql in Html Button with php

本文关键字：MySql php html 按钮 | 更新日期: 2023-09-27

PHP

$con=mysqli_connect("localhost","root","","mmogezgini");
$menuler = mysqli_query($con,"SELECT * FROM menuler");
while($menu = mysqli_fetch_array($menuler))
{
    echo "<button class='"ust_link'"
        onClick='"window.location.href='Menu_Url.php''">Menu_Name</button>";
}
mysqli_close($con);

MySQL

代码已准备就绪，MySQL连接成功，我只是不知道如何放置menu['name']和menu['url']而不是Menu_Name和Menu_Url

试试这段代码：

<?php
while($menu = mysqli_fetch_array($menuler)) {
   $name = $menu["Name'"];
   $url = $menu["url"];
?>
   <button class="ust_link" onclick="window.location.href='<?php echo $url; ?>'"><?php echo $name; ?></button>
<?php
 }
?>

由于

您正在使用

onclick="location.href=''"

它结合了单引号和双引号

像这样：

$con=mysqli_connect("localhost","root","","mmogezgini");
    $menuler = mysqli_query($con,"SELECT * FROM menuler");
    while($menu = mysqli_fetch_array($menuler))
      {
      echo "<button class='"ust_link'" onClick='"window.location.href='".$menu['url'].".php''">".menu['php']."</button>";
      }
    mysqli_close($con);

试试这个：

    $con=mysqli_connect("localhost","root","","mmogezgini");
    $menuler = mysqli_query($con,"SELECT * FROM menuler");
    while($menu = mysqli_fetch_array($menuler))
    {
        echo "<button class='"ust_link'"onClick='"window.location.href='".$menu['url'].".php''">". $menu['name'] ."</button>";
    }
    mysqli_close($con);

你有两种可能性：

echo "<button class='"ust_link'" onClick='"window.location.href='". $menu['url'].".php''">". $menu['name'] ."</button>";

或：

echo "<button class='"ust_link'" onClick='"window.location.href='{$menu['url']}''">{$menu['name']}</button>";

请参阅 PHP： echo - 手册