这是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();
希望这有帮助