미디어위키 DB 쿼리

1 개요

미디어위키 DB 쿼리

select()

$dbr = wfGetDB( DB_REPLICA );
$res = $dbr->select( 'user',
	['user_id', 'user_name', 'user_editcount'],
	['user_editcount > 100'],
	__METHOD__,
	['ORDER BY'=>'user_editcount DESC','LIMIT'=>3]
);
foreach($res as $row) {
	print_r($row);
}

selectField()

$user_id = 123;
$dbr = wfGetDB( DB_REPLICA );
$user_name = $dbr->selectField(
	'user',
	['user_name'],
	['user_id'=>$user_id],
	__METHOD__);
echo $user_name;

insert()

$dbw = wfGetDB( DB_MASTER );
$dbw->insert(
	'customers',
	['name'=>'John','email'=>'john@example.com'],
	__METHOD__);
$id = $dbw->insertid();

update()

$dbw = wfGetDB( DB_MASTER );
$dbw->update(
	'customers',
	['name'=>'John Smith','email'=>'john.smith@example.com'],
	['id'=>123],
	__METHOD__);

2 같이 보기

• 라라벨 쿼리빌더

3 참고

• https://www.mediawiki.org/wiki/Manual:Database_access