joomla sql 查询 [英] joomla sql query

问题描述

好的，所以我对 sql 了解不多，但我正在尝试为我的网站进行动态重定向，想法是将每个用户重定向到与用户调用的名称相同的文章，所以这里有一些代码，但我不知道知道如何完成它:(

ok so i dont know much about sql but im trying to make a dinamic redirect for my website, the idea is to redirect each user to an article called the same as the user is called, so here's a little code but i dont know how to finish it :(

$database->setQuery("SELECT id "." FROM #__content "." WHERE state='1' "." ");
$rows = $database->loadObjectList();
foreach($rows as $user_name){   
$article_id = $row->id; 
break;
}
$redirect_url = 'index.php?option=com_content&view=article&id='.$article_id;

$user_name 和 $redirect_url 是预制"选项，所以不用担心，我只需要知道如何实际执行查询嘿嘿，感谢您的帮助 :D

$user_name and $redirect_url are "premade" options so dont worry about it, i just need to know how to actually do the query hehe, thanks for the help :D

推荐答案

看起来你打算返回单个 article_id，这样 SQL 查询应该总是返回单行(值)，在这种情况下，foreach 必须消失.问题是您需要重写 SQL 查询并向 WHERE 子句添加另一个条件.也许是这样的:

It looks like you intend to return a single article_id, so that SQL query should always return a single row (value), in which case, that foreach must disappear. The thing is that you need to rewrite your SQL query and add another condition to the WHERE clause. Perhaps something like this:

$user =& JFactory::getUser();
$database->setQuery("SELECT id FROM #__content WHERE state='1' AND title = '".$user->name."'");
$row = $database->loadAssoc();
$redirect_url = 'index.php?option=com_content&view=article&id='.$row['id'];

请注意，我没有测试过上面的代码.

Please note that I have not tested the above code.

这篇关于joomla sql 查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！