PHP DBTools::doQuery Examples

Example #1

File: model.php Project: realsoc/mediawiki-extensions

	public function getUserLanguage( $username ) {
		global $mysql_info;
		DBTools::connect( $mysql_info );

		$username = mysql_real_escape_string( $username );
		$row = DBTools::doQuery( "SELECT uiLanguage from auth where username=\"$username\"" );
		return $row["uiLanguage"];
	}

Example #2

File: persist.php Project: realsoc/mediawiki-extensions

function loadExercise( $exercise_id ) {
	if ( !is_int( $exercise_id ) )
		throw new Exception( "persist; loadExercise exercise_id is not an integer" );


	global $mysql_info;
	DBTools::connect( $mysql_info );
	$exercise_id = mysql_real_escape_string( $exercise_id );
	$row = DBTools::doQuery( "select * from exercises where id=\"$exercise_id\"" );
	$exercise = new Exercise();
	$exercise->setId( $exercise_id );
	$exercise->loadXML( $row["exercise"] );
	$exercise->setQuestionLanguages( explode( ",", $row["questionLanguages"] ) );
	$exercise->setAnswerLanguages( explode( ",", $row["answerLanguages"] ) );
	return $exercise;
}