Pastebin

/* Insert a new article with tags*/
function store_new_article($body, $title, $visibility, $tags) {
	begin();
	$q = prepare_statement("INSERT INTO article (body, title, visibility) 
VALUES(%s, %s, %s)", $body, $title, $visibility);
  exec_statement($q);
	$q = prepare_statement("SELECT CURRVAL('article_article_id_seq')");
	$article_id = pg_fetch_array(exec_statement($q));
	$article_id = $article_id[0];

  /* Insert an article tag */
	foreach ($tags as $tag) {
	$q = prepare_statement("INSERT INTO article_tag (name, article_id)
VALUES (%s, %s)", $tag, $article_id);
  exec_statement($q);
	}

	commit();
}