Lines Matching refs:query
99 $db->query('INSERT INTO labeled (id, label) VALUES (?,?)', $id, $label);
108 $db->query('UPDATE labels SET color=? WHERE name=?', $newColor, $label);
121 $db->query('DELETE FROM labeled WHERE id=? AND label=?', $id, $label);
135 $db->query('DELETE FROM labeled WHERE id=?', $id);
163 $db->query('UPDATE labels set name=? WHERE name=?', $newName, $label);
164 $db->query('UPDATE labeled set label=? WHERE label=?', $newName, $label);
179 $res = $db->query('SELECT label FROM labeled WHERE id=?', $id);
207 $res = $db->query('SELECT name, color, namespace, ordernr FROM labels ORDER BY ordernr');
242 $db->query('UPDATE labels SET ordernr=? WHERE name=?', ($i+1), $keys[$i]);
267 … $db->query('INSERT INTO labels (name, color, namespace) VALUES (?,?,?)', $name, $color, $ns);
279 $db->query('DELETE FROM labels WHERE name=?', $label);
280 $db->query('DELETE FROM labeled WHERE label=?', $label);