php - 通过带有列号的post请求选择MySQL限制列

Question

我试图通过向 MySQL 发送带有列号的 PHP post 请求来获取 MySQL 列

<小时/>

PHP:

<?php

$columns = $_POST['number'];     

$result = mysql_query(" SELECT * FROM table3 order by RAND() LIMIT '$columns'");

?>

<小时/>

HTML:

<form action="file.php" method="post" >
    <input type="text" name="number" value="5" autocomplete="off">

    <input type="submit" Value="Submit">
</form>

Answer 1

你说的是

SELECT * FROM table3 order by RAND() LIMIT '5'

看到报价问题了​​吗？

应该是

<?php
$columns = (int)$_POST['number'];     
$result = mysql_query(" SELECT * FROM table3 order by RAND() LIMIT $columns");
?>