$lon = (double) $wpt['lon']; $type = (string) $cache->type; $typeId = DB::queryFirstField("SELECT id FROM type WHERE type=%s LIMIT 1", $type); $difficulty = (int) $cache->difficulty; $terrain = (int) $cache->terrain; $country = (string) $cache->country; $url = (string) $wpt->url; foreach ($cache->logs->log as $log) { $gc = (string) $wpt->name; $name = (string) $cache->name; $username = (string) $log->finder; $logtext = (string) $log->text; $logType = (string) $log->type; $logDate = substr((string) $log->date, 0, 10); if ($inserted == 0) { DB::insertIgnore('user', array('username' => $username)); $inserted = 1; $userId = DB::queryFirstField("SELECT id FROM user WHERE username=%s LIMIT 1", $username); $logIds = DB::queryFirstColumn("SELECT log.id FROM image, log WHERE image.log = log.id AND log.user = %i", $userId); foreach ($logIds as $logId) { DB::delete('image', "log=%i", $logId); } DB::delete('log', "user=%i", $userId); } DB::insertUpdate('geocache', array('gc' => $gc, 'name' => $name, 'type' => $typeId, 'lat' => $lat, 'lon' => $lon, 'difficulty' => $difficulty, 'terrain' => $terrain, 'country' => $country, 'url' => $url)); $geocacheId = DB::queryFirstField("SELECT id FROM geocache WHERE gc = %s LIMIT 1", $gc); $logTypeId = DB::queryFirstField("SELECT id FROM logtype WHERE type = %s LIMIT 1", $logType); DB::insert('log', array('user' => $userId, 'geocache' => $geocacheId, 'created' => $logDate, 'type' => $logTypeId, 'log' => $logtext)); } $finds++; }
<?php require_once 'general.php'; require_once 'connection.php'; require_once 'logger.php'; require_once 'checkLogin.php'; if (isset($_GET['addUser'])) { DB::insertUpdate('user', array('username' => $_GET['addUser'])); DB::insertIgnore('feed', array('user' => DB::queryFirstField("SELECT id FROM user WHERE username = %s", getSessionUser()), 'feeduser' => DB::queryFirstField("SELECT id FROM user WHERE username = %s", $_GET['addUser']))); } else { if (isset($_GET['removeUser'])) { $user = DB::queryFirstField("SELECT id FROM user WHERE username = %s", getSessionUser()); $feedUser = DB::queryFirstField("SELECT id FROM user WHERE username = %s", $_GET['removeUser']); DB::delete('feed', 'user=%s AND feeduser='******'components/head.html'; printBodyTag(); showNavigation(); ?> <div class="panel-body"> <div class='panel panel-info'> <div class='panel-heading'>Add user to feed and index</div> <div class='panel-body'> <form class="form-inline"> <div class="form-group"> <input class="form-control" name="addUser" placeholder="Username">
function test_6_insert_ignore() { DB::insertIgnore('accounts', array('id' => 1, 'username' => 'gonesoon', 'password' => 'something', 'age' => 61, 'height' => 199.194)); }
<?php require '../../boot.php'; require '../../session.php'; if (!isset($session) || $session->auth == "") { Common::Error(401, 'json'); } $config = Config::get('evaluasi'); $req = Request::all(); $data = $req['d']; for ($i = 0; $i < count($data); $i++) { $data[$i]['renstra'] = $config->renstra; $dt = DB::insertIgnore('tabel_renstra', $data[$i]); $da = DB::insertIgnore('indikator_anggaran_renstra', ['renstra' => $config->renstra, 'kd_kegiatan' => $data[$i]['kd_urusan'] . $data[$i]['kd_bidang'] . $data[$i]['kd_program'] . $data[$i]['kd_kegiatan'], 'kd_unit' => $data[$i]['kd_unit'], 'kd_subunit' => $data[$i]['kd_sub_unit']]); } if ($dt) { $hasil = ["success" => true, "message" => "Data berhasil dimasukkan"]; } else { $hasil = ["success" => false, "message" => "Data gagal dimasukkan"]; } echo json_encode($hasil); exit;