选择某些MySQL字段并使用php显示它们 [英] Select certain MySQL fields and display them using php

问题描述

所以我想要做的是在名为filename的列中搜索某个名称，并在该行上显示count。

So what I want to do is I want to search for a certain name in a column called 'filename' and display the 'count' on that row.

这可能有助于解释：

我想在'filename'列中搜索包，在其上显示计数（4）

I want to search for Packages in the 'filename' column but I want to display the 'count' on it (4)

id文件名计数

1 Packages 4

1 Packages 4

2另一个7

推荐答案

$filename = 'Packages';
$result = mysql_query("SELECT `count` FROM `downloads` WHERE `filename` = $filename");

另请注意，如果文件名可能来自用户输入，则必须注意注射攻击。

Also note that if the filename can come from user input you have to be aware of injection attacks.

$filename = 'Packages'; // From user

$filename = mysql_real_escape_string($filename);
$result = mysql_query("SELECT `count` FROM `downloads` WHERE `filename` = $filename");

下面是一个选择所有文件名和计数并在表中列出的示例：

Here is an example that selects all Filenames and counts and lists them in a table:

$result = mysql_query("SELECT `filename` `count` FROM `downloads`");
?><table><tr><td>Filename</td><td>Count</td></tr><?php
while($row = mysql_fetch_assoc($result)){
    ?>
    <tr><td><?php echo $row['filename']; ?></td><td><?php echo $row['count']; ?></td></tr>
    <?php
}
?></table><?php

这篇关于选择某些MySQL字段并使用php显示它们的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！