过滤/排序用户评论PHP

I'm a php newb so you'll have to bear with me. I'm working on a user comment section where people can submit condition/snow reports for some backcountry cabins. I've got the submission and display part down but I'd like people to be able to filter the observations by hut so they can choose to see just the reports for a particular hut. I feel like I'm close but can't seem to get the code to work. This is still just an in house mockup so that is why there's no spam filter yet and some of the code may look a bit sloppy (inline styles, etc.) Thanks in advance, any suggestions are appreciated.

PHP Code

if (isset($_GET['search']))
{
include $_SERVER['DOCUMENT_ROOT'] . '/includes/db.inc.php';
try
{
$sql = "SELECT name, comment, date, hutname FROM `comments` WHERE hut LIKE hutname ORDER BY date DESC, time DESC"; 

$result = $pdo->query($sql);
}
catch (PDOException $e)
{
$error = 'Error fetching comments: ' . $e->getMessage();
include 'error.html.php';
exit();
}
while ($row = $result->fetch())
{
$comments[] = array(
'name' => $row['name'],
'date' => $row['date'],
'hutname' => $row['hutname'],
'comment' => $row['comment']
);
}
}

if (isset($_POST['comment']))
{
try
{
$sql = 'INSERT INTO comments SET
comment = :comment,
name = :name,
contact = :contact,
hutname = :hutname,
date = CURDATE(),
time = CURTIME()';
$s = $pdo->prepare($sql);
$s->bindValue(':comment', $_POST['comment']);
$s->bindValue(':name', $_POST['name']);
$s->bindValue(':hutname', $_POST['hut']);
$s->bindValue(':contact', $_POST['email']);
$s->execute();
}
catch (PDOException $e)
{
$error = 'Error adding submitted observation: ' . $e->getMessage();
include 'error.html.php';
exit();
}
header('Location: .');
exit();
}


try
{
$sql = "SELECT name, comment, date, hutname FROM `comments` ORDER BY date DESC, time DESC";
$result = $pdo->query($sql);
}
catch (PDOException $e)
{
$error = 'Error fetching comments: ' . $e->getMessage();
include 'error.html.php';
exit();
}
while ($row = $result->fetch())
{
$comments[] = array(
'name' => $row['name'],
'date' => $row['date'],
'hutname' => $row['hutname'],
'comment' => $row['comment']
);
}



include 'comments.html.php';

HTML Code

<body>
<?php include('../includes/header.php'); ?>
<div class="row">
<div class="eight large-8 columns">
<h4>Here are the most current conditions:</h4>
<form action="" method="get">
     <div class="row">
    <div class=" large-5 columns">
    <label>Sort by Hut:</label>
    <select name="hut" id="hut">
    <optgroup label="10th Mountain Huts">
    <option value="10th Mountain Division Hut">10th Mountain Division Hut</option>
    <option value="Benedict Huts">Benedict Huts</option>
    <option value="Betty Bear Hut">Betty Bear Hut</option>
    <option value="Continental Divide Cabin">Continental Divide Cabin</option>
    <option value="Point Breeze Cabin">Point Breeze Cabin</option>
    <option value="Eiseman Hut">Eiseman Hut</option>
    <option value="Fowler/Hilliard Hut">Fowler/Hilliard Hut</option>
    <option value="Harry Gates Hut">Harry Gates Hut</option>
    <option value="Jackal Hut">Jackal Hut</option>
    <option value="Margy's Hut">Margy's Hut</option>
    <option value="MacNamara Hut">MacNamara Hut</option>
    <option value="Peter Estin Hut">Peter Estin Hut</option>
    <option value="Polar Star Inn">Polar Star Inn</option>
    <option value="Carl's Cabin">Carl's Cabin</option>
    <option value="Sangree M. Froelicher Hut">Sangree M. Froelicher Hut</option>
    <option value="Shrine Mountain Inn">Shrine Mountain Inn</option>
    <option value="Skinner Hut">Skinner Hut</option>
    <option value="Uncle Bud's Hut">Uncle Bud's Hut</option>
    <option value="Vance's Cabin">Vance's Cabin</option>
    </optgroup>
    <optgroup label="Summit Huts">
    <option value="Francie's Cabin">Francie's Cabin</option>
    <option value="Francie's Cabin">Janet's Cabin</option>
    <option value="Francie's Cabin">Ken's Cabin</option>
    <option value="Francie's Cabin">Section House</option>
    </optgroup>
    <optgroup label="Grand Huts">
    <option value="Broome Hut">Broome Hut</option>
    </optgroup>
    <optgroup label="Braun &amp Friends Huts">
    <option value="Barnard Hut">Barnard Hut</option>
    <option value="Goodwin Greene Hut">Goodwin Greene Hut</option>
    <option value="Lindley Hut">Lindley Hut</option>
    <option value="Markley Hut">Markley Hut</option>
    <option value="Opa's Taylor Hut">Opa's Taylor Hut</option>
    <option value="Tagert &amp Green-Wilson Huts">Tagert &amp Green-Wilson Huts</option>
    <option value="Friends Hut">Friends Hut</option>
    </optgroup>
</select>
    </div>
    <button type="submit" value="search">Sort</button>
    </div>

</form>
<?php foreach ($comments as $comment): ?>
<div class="hutConditions">
<h6><?php echo htmlspecialchars($comment ['date'], ENT_QUOTES, 'UTF-8');
?> &nbsp <?php echo htmlspecialchars($comment ['hutname'], ENT_QUOTES, 'UTF-8');
?></h6>
<p><?php echo htmlspecialchars($comment ['name'], ENT_QUOTES, 'UTF-8');
?></p>
<blockquote>
<p><?php echo htmlspecialchars($comment ['comment'], ENT_QUOTES, 'UTF-8');
?>
</p>
</blockquote>
</div>
<?php endforeach; ?>
</div>
<div class="four large-4 columns">
<h5>Submit an Observation:</h5>
<form action="?" method="post">
<div>
<label for="name">Name</label>
<input type="text" name="name" id="name">
<label for="email">Email</label>
<input type="text" name="email" id="email">
<label for="hut">Hut</label>
<select name="hut" id="hut">
    <optgroup label="10th Mountain Huts">
    <option value="10th Mountain Division Hut">10th Mountain Division Hut</option>
    <option value="Benedict Huts">Benedict Huts</option>
    <option value="Betty Bear Hut">Betty Bear Hut</option>
    <option value="Continental Divide Cabin">Continental Divide Cabin</option>
    <option value="Point Breeze Cabin">Point Breeze Cabin</option>
    <option value="Eiseman Hut">Eiseman Hut</option>
    <option value="Fowler/Hilliard Hut">Fowler/Hilliard Hut</option>
    <option value="Harry Gates Hut">Harry Gates Hut</option>
    <option value="Jackal Hut">Jackal Hut</option>
    <option value="Margy's Hut">Margy's Hut</option>
    <option value="MacNamara Hut">MacNamara Hut</option>
    <option value="Peter Estin Hut">Peter Estin Hut</option>
    <option value="Polar Star Inn">Polar Star Inn</option>
    <option value="Carl's Cabin">Carl's Cabin</option>
    <option value="Sangree M. Froelicher Hut">Sangree M. Froelicher Hut</option>
    <option value="Shrine Mountain Inn">Shrine Mountain Inn</option>
    <option value="Skinner Hut">Skinner Hut</option>
    <option value="Uncle Bud's Hut">Uncle Bud's Hut</option>
    <option value="Vance's Cabin">Vance's Cabin</option>
    </optgroup>
    <optgroup label="Summit Huts">
    <option value="Francie's Cabin">Francie's Cabin</option>
    <option value="Francie's Cabin">Janet's Cabin</option>
    <option value="Francie's Cabin">Ken's Cabin</option>
    <option value="Francie's Cabin">Section House</option>
    </optgroup>
    <optgroup label="Grand Huts">
    <option value="Broome Hut">Broome Hut</option>
    </optgroup>
    <optgroup label="Braun &amp Friends Huts">
    <option value="Barnard Hut">Barnard Hut</option>
    <option value="Goodwin Greene Hut">Goodwin Greene Hut</option>
    <option value="Lindley Hut">Lindley Hut</option>
    <option value="Markley Hut">Markley Hut</option>
    <option value="Opa's Taylor Hut">Opa's Taylor Hut</option>
    <option value="Tagert &amp Green-Wilson Huts">Tagert &amp Green-Wilson Huts</option>
    <option value="Friends Hut">Friends Hut</option>
    </optgroup>
</select>
<label for="comment">Conditions/Observations:</label>
<textarea id="comment" name="comment" rows="3" cols="40">
</textarea>
</div>
<button type="submit" value="Add">Submit Observations</button>
</form>
</div>
</div>

<?php include('../includes/footer.php'); ?>

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除结题
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
duannengling4705 2014-02-26 23:06
关注
as @Fabio said

LIKE must be enclosing with quotes.

SELECT name, comment, date, hutname FROM `comments` WHERE hut LIKE 'hutname' ORDER BY date DESC, time DESC

or the wildcard if you need more generals results

SELECT name, comment, date, hutname FROM `comments` WHERE hut LIKE '%hutname%' ORDER BY date DESC, time DESC

Read the LIKE section in the manual

Note: try eneable display_errors in php in the dev enviroment using

error_reporting(-1); ini_set('display_errors', true);

or in the php.ini to get the errors and should be more easy the debug proccess
本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

过滤/排序用户评论PHP php
2014-02-26 22:59

回答 2 已采纳 as @Fabio said LIKE must be enclosing with quotes. SELECT name, comment, date, hutname FR
Twig x2.5 - 模板/ php过滤器 php
2018-10-26 22:07

回答 1 已采纳 Figured it out. I made a simple error that is now obvious to me. I need to define the Twig name
PHP关联数组过滤[关闭] php
2017-11-23 15:02

回答 1 已采纳 Lets assume your array was saved under the variable $cart. You can use the PHP function array_red
快速将高级过滤/搜索和排序功能添加到使用Doctrine的API或Web应用程序中的任何资源。-PHP开发
2021-05-27 08:56

要求PHP> = 7.3 Doctrine> = 2.0示例下面的一些查询示例展示了库的不同过滤和排序功能。 //返回价格范围在100到200之间的产品GET / products？price [gte] = 100＆price [lte] = 200 //返回生日在2000年1月1日之后的...
PHP过滤结果基于数据 php sql
2017-07-14 14:17

回答 1 已采纳 Here you can use DATE_SUB() Mysql function check this func_mysql_date_sub And try like this ec
PHP多维数组过滤器 php
2018-01-29 00:25

回答 1 已采纳 Try this: array_filter( $unique, // Array to filter function($elem){ // Closure p
过滤周末的工作日php php
2017-03-22 09:13

回答 3 已采纳 You can call date('w', $date) where w will set the result to the numeric representation of the day
PHP elasticsearch 条件过滤、排序、高亮实现
2022-04-18 14:10

沙漠中海的博客 php在做搜索引擎时，进程要对结果进行筛选，所以我们这里记录一下elasticsearch 条件过滤、排序、高亮实现。
php数组过滤函数问题与变量 php
2017-06-04 17:25

回答 2 已采纳 You use anonymous function, so you can use use statement to pass variable to it: $lteam_id = 25;
Php过滤键和值的多维关联数组 php
2018-12-04 17:13

回答 3 已采纳 Why not to use the mathematician set theory and intersection? In Php array terms, it means you can
如何使用PHP过滤和重构json数据？ json php
2018-09-22 11:13

回答 1 已采纳 Decode the json, restructure the data, re-encode. Code: (Demo) // your $json = foreach (json_de
[PHP] laravel中collect数组排序和过滤的使用
2021-10-13 09:57

程序员老狼的博客经常在代码中我们需要实现数组排序，或者数组过滤，或者数组查找类似查找数据库一样的用法可以使用collect $items=[ ["num"=>17,"status"=>0,"grade"=>5], ["num"=>17,"status"=>2,"grade"=>...
如何使用php和js同时过滤内容 javascript php
2019-02-11 11:36

回答 1 已采纳 Without knowing the exact problem that you are experiencing, the most obvious thing is you need to
数据表：简单的应用程序，允许管理员上传CSV表，用户在身份验证后可以查看（和排序，过滤）
2021-02-26 05:07

数据表一个简单的应用程序，允许管理员上载CSV表，用户在身份验证后可以查看（和排序，过滤）。管理员可以控制用户可以访问哪些表。如何开始安装依赖项： composer install如果使用docker，则可以使用docker-...
bruno:Laravel的基本API控制器，可为您的资源进行排序，过滤，快速加载和分页
2021-05-28 18:35

布鲁诺介绍Laravel基本控制器类和特征，可以为您的资源URL添加过滤，排序，热切加载和分页。致力于佐丹奴布鲁诺这个包裹以我的英雄乔治·布鲁诺（Giordano Bruno）的名字命名。一位真正的有远见的人，敢于梦想超出...
没有解决我的问题, 去提问

悬赏问题

¥50 导入文件到网吧的电脑并且在重启之后不会被恢复
¥15 （希望可以解决问题）ma和mb文件无法正常打开，打开后是空白，但是有正常内存占用，但可以在打开Maya应用程序后打开场景ma和mb格式。
¥20 ML307A在使用AT命令连接EMQX平台的MQTT时被拒绝
¥20 腾讯企业邮箱邮件可以恢复么
¥15 有人知道怎么将自己的迁移策略布到edgecloudsim上使用吗？
¥15 错误 LNK2001 无法解析的外部符号
¥50 安装pyaudiokits失败
¥15 计组这些题应该咋做呀
¥60 更换迈创SOL6M4AE卡的时候，驱动要重新装才能使用，怎么解决？
¥15 让node服务器有自动加载文件的功能

过滤/排序用户评论PHP

2条回答 默认 最新

悬赏问题

2条回答默认最新