在PHP脚本中格式化插入到Joomla SQL调用中时遇到困难 - Difficulty formatting insert into Joomla SQL call in PHP script

Difficulty formatting insert into Joomla SQL call in PHP script

这是PHP片段：

$rdcno = rawurlencode('[cb_rdcno]');
$web_id = 'TEST';
$db = JFactory::getDbo();
$emailListQuery = $db->getQuery(true);
$emailListQuery = "INSERT INTO `#__update_membership` (`inl_rdcnumber`, `inl_website_id`) VALUES ('$rdcno', '$web_id')";
$db->setQuery( $emailListQuery );
$db->query();

查询的格式在哪里出错了？

你实际上应该坚持Joomla编码标准，确保你也使用转义方法，如下所示：

$db = JFactory::getDbo();
$emailListQuery = $db->getQuery(true);
$columns = array('inl_rdcnumber', 'inl_website_id');
$values = array($db->quote($rdcno), $db->quote($web_id));
$emailListQuery->insert($db->quoteName('#__update_membership'))
               ->columns($db->quoteName($columns))
               ->values(implode(',', $values));
$db->setQuery($emailListQuery);
$db->query();

希望这有帮助