PHP DBTools::unsafe_insert_assocの例

コード例 #1

ファイル: persist.php プロジェクト: realsoc/mediawiki-extensions

function saveExercise( $exercise, $userName = null ) {
	global $mysql_info;
	DBTools::connect( $mysql_info );
	$id = mysql_real_escape_string( $exercise->getId() );
	# if (id==0) throw new Exception ("new exercise?");
	$row = array();
	$row["id"] = $id;
	$row["username"] = $userName;
	$row["exercise"] = $exercise->saveXML();
	$row["questionLanguages"] = mysql_real_escape_string( implode( ",", $exercise->getQuestionLanguages() ) );
	$row["answerLanguages"] = mysql_real_escape_string( implode( ",", $exercise->getAnswerLanguages() ) );

	DBTools::unsafe_insert_assoc( "exercises", "id", $id, $row );
	$exercise->setId( mysql_insert_id() ); # might be useful to prevent repeats
	}