Example #1
0
 /**
 * Adiciona um artigo à base
 *
 * @param Article $article Objeto Artigo
 *
 * Ele pega os dados que estão armazenados nos campos da classe e adiciona no Banco
 * @returns mixed $result
 */
 function AddArticle($article)
 {
     $strsql = "INSERT INTO scieloorgusers.articles (\r\n\t\tPID, \r\n\t\turl,\r\n\t\ttitle, \r\n\t\tserial, \r\n\t\tvolume, \r\n\t\tnumber, \r\n\t\tsuppl, \r\n\t\tyear, \r\n\t\tauthors_xml, \r\n\t\tkeywords_xml,\r\n\t\tabstract_xml,\r\n\t\tprocess_date,\r\n\t\tpublication_date,\r\n\t\twp_post_id,\r\n\t\twp_url,\r\n\t\twp_post_date\r\n\t\t) \r\n\t\tVALUES ('" . $article->getPID() . "','" . $article->getURL() . "','" . mysql_escape_string(str_replace("'", "'", $article->getTitle())) . "','" . $article->getSerial() . "','" . $article->getVolume() . "','" . $article->getNumber() . "','" . $article->getSuppl() . "','" . $article->getYear() . "','" . mysql_escape_string($article->getAuthorXML()) . "','" . mysql_escape_string(str_replace("'", "'", $article->getKeywordXML())) . "','" . mysql_escape_string(str_replace("'", "'", $article->getAbstractXML())) . "','" . date('Y-m-d H:i:s') . "','" . formatDate($article->getPublicationDate()) . "'," . $article->getWpPostID() . ",'" . $article->getWpURL() . "','" . $article->getWpPostDate() . "'" . ")";
     $result = $this->_db->databaseExecInsert($strsql);
     return $result;
 }