如何在PHP中使用Html按钮中的MySql(How To Use MySql in Html Button with php)

如何在PHP中使用Html按钮中的MySql(How To Use MySql in Html Button with php)

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

$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 codes are ready and MySQL connection is successful, I just dont know how to place menu['name'] and menu['url'] instead of Menu_Name and 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 } ?>

自从你使用以来，很难立刻回应所有的html

onclick="location.href=''"

它结合了单引号和双引号

Try this code:

<?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 } ?>

It's gonna be difficult to echo out all of the html at once since you're using

onclick="location.href=''"

which combines single and double quotes