PHP table::delete Examples

Example #1

File: m.php Project: xurenlu/tik

 function action_comments_remove()
 {
     $comm = new table("comments");
     $id = intval($_GET["id"]);
     $comm->delete($id);
     show_msg("删除成功", $_SERVER["HTTP_REFERER"]);
 }

Example #2

File: tableTest.php Project: rolisz/framework

 /**
  * 
  * @dataProvider tabeleTrue
  * 
  */
 public function testDelete($tabel, $args, $id)
 {
     $table = new table($tabel, $id);
     $this->assertNotEmpty($table->getData(), 'This' . $id . ' failed');
     $table->delete();
     $this->assertEmpty($table->getData(), $id);
     $table = new table($tabel, $id);
     $this->assertEmpty($table->getData());
 }

Example #3

File: core.php Project: carriercomm/Nuance

function controllerRouterQueue($routerId, $mode, $userId = false)
{
    if (!$routerId) {
        return;
    }
    //Add entry to updqueue table
    $updqueueTable = new table('routerupdatequeue');
    $updqueueTable->setLogging(false);
    // Check for the same action records
    $req = "WHERE router={$routerId} AND mode='{$mode}'";
    if ($userId) {
        $req .= " AND user={$userId}";
    }
    $similarRes = $updqueueTable->load($req);
    if (!count($similarRes)) {
        $updqueueTable->add(array('router' => $routerId, 'mode' => $mode, 'user' => $userId));
    }
    //fork('/updaterouter.php', false);
    $unavailableRouters = array();
    $queRes = $updqueueTable->load("WHERE `router`={$routerId}");
    foreach ($queRes as $queRow) {
        if (controllerRouter($queRow['router'], $queRow['mode'], $queRow['user']) || controllerRouter($queRow['router'], 'checkConnection', $queRow['user'])) {
            $updqueueTable->delete(array('id' => $queRow['id']));
        } else {
            break;
        }
    }
}

Example #4

File: ajax.php Project: carriercomm/Nuance

         }
     }
 }
 // Extract cash difference from user and proceed as moneflow
 if ($target == 'user' && ($action == 'dbedit' || $action == 'dbadd') && isset($data['cash'])) {
     unset($data['cash']);
 }
 switch ($action) {
     case 'dbadd':
         $id = $table->add($data);
         break;
     case 'dbedit':
         $id = $table->edit($data);
         break;
     case 'dbremove':
         $id = $table->delete($data);
         break;
 }
 if ($target == 'user' && ($action == 'dbedit' || $action == 'dbadd') && isset($_POST['cash']) && checkPermission($sessionId, array('table', $target, 'edit', 'cash'))) {
     if ($action === 'dbedit') {
         $user = $table->loadById($id);
         $sum = money($_POST['cash']) - money($user['cash']);
     } else {
         $sum = money($_POST['cash']);
     }
     if ($sum) {
         $moneyflowTable = new table('moneyflow');
         $moneyflowTable->add(array("user" => $id, "sum" => $sum, "detailsname" => "adminpay", "detailsid" => $sessionId));
     }
     payment(0, $id);
 }