过滤/排序用户评论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
「PHP系列」PHP E-mail 注入/防止注入
2024-04-25 00:15

雪梅零落的博客 PHP 防止 E-mail 注入的关键在于对用户输入进行适当的验证和过滤，确保输入的内容不会对邮件发送过程产生负面影响。使用像 PHPMailer 这样的安全邮件发送库可以大大降低 E-mail 注入的风险。函数对用户输入的邮件...
数据表：简单的应用程序，允许管理员上传CSV表，用户在身份验证后可以查看（和排序，过滤）
2021-02-26 05:07

数据表一个简单的应用程序，允许管理员上载CSV表，用户在身份验证后可以查看（和排序，过滤）。管理员可以控制用户可以访问哪些表。如何开始安装依赖项： composer install如果使用docker，则可以使用docker-...
没有解决我的问题, 去提问

悬赏问题

¥15 写uniapp时遇到的问题
¥15 matlab有限元法求解梁带有若干弹簧质量系统的固有频率
¥15 找一个网络防御专家，外包的
¥100 能不能让两张不同的图片md5值一样，（有尝）
¥15 informer代码训练自己的数据集，改参数怎么改
¥15 请看一下，学校实验要求，我需要具体代码
¥50 pc微信3.6.0.18不能登陆有偿解决问题
¥20 MATLAB绘制两隐函数曲面的交线
¥15 求TYPCE母转母转接头24PIN线路板图
¥100 国外网络搭建，有偿交流

过滤/排序用户评论PHP

2条回答 默认 最新

悬赏问题

2条回答默认最新