本文整理汇总了PHP中Listing::insert方法的典型用法代码示例。如果您正苦于以下问题:PHP Listing::insert方法的具体用法?PHP Listing::insert怎么用?PHP Listing::insert使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Listing
的用法示例。
在下文中一共展示了Listing::insert方法的3个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: elseif
$listing->setListingMemo($requestObject->listingMemo);
$listing->setListingParentId($requestObject->listingParentId);
$listing->setListingPostTime($requestObject->listingPostTime);
$listing->setListingTypeId($requestObject->listingTypeId);
$listing->update($pdo);
$pusher->trigger("listing", "update", $listing);
//if this isn't supposed to be an admin, take away the temporary admin access
$security = Volunteer::getVolunteerByVolId($pdo, $_SESSION["volunteer"]->getVolId());
if ($security->getVolIsAdmin() === false) {
$_SESSION["volunteer"]->setVolIsAdmin(false);
}
$reply->message = "Listing updated OK";
} elseif ($method === "POST") {
//create new listing
$listing = new Listing(null, $_SESSION["volunteer"]->getOrgId(), $requestObject->listingClaimedBy, $requestObject->listingClosed, $requestObject->listingCost, $requestObject->listingMemo, $requestObject->listingParentId, $requestObject->listingPostTime, $requestObject->listingTypeId);
$listing->insert($pdo);
$pusher->trigger("listing", "new", $listing);
$reply->message = "Listing created OK";
}
} elseif ($method === "DELETE") {
$listing = Listing::getListingByListingId($pdo, $id);
if ($listing === null) {
throw new RuntimeException("Listing does not exist", 404);
}
$listing->delete($pdo);
$deletedObject = new stdClass();
$deletedObject->listingId = $id;
$pusher->trigger("listing", "delete", $deletedObject);
$reply->message = "Listing deleted OK";
}
} else {
示例2: testGetValidListingByListingTypeId
/**
* test for grabbing a listing by listing Type Id
*
*/
public function testGetValidListingByListingTypeId()
{
//get the count of the number of rows in the database
$numRows = $this->getConnection()->getRowCount("listing");
//create a new listing and insert into mySQL
$listing = new Listing(null, $this->organization->getOrgId(), $this->VALID_CLAIMEDBY, $this->VALID_LISTINGCLOSED, $this->VALID_COST, $this->VALID_MEMO, $this->VALID_PARENT_ID, $this->valid_datetime, $this->listingType->getlistingTypeId());
$listing->insert($this->getPDO());
//grab data from SQL and ensure it matches
$pdoListing = Listing::getListingByTypeId($this->getPDO(), $this->listingType->getlistingTypeId());
$this->assertSame($numRows + 1, $this->getConnection()->getRowCount("listing"));
$this->assertSame($pdoListing[0]->getOrgId(), $this->organization->getOrgId());
$this->assertSame($pdoListing[0]->getListingClaimedBy(), $this->VALID_CLAIMEDBY);
$this->assertSame($pdoListing[0]->getListingClosed(), $this->VALID_LISTINGCLOSED);
$this->assertSame($pdoListing[0]->getListingCost(), $this->VALID_COST);
$this->assertSame($pdoListing[0]->getListingMemo(), $this->VALID_MEMO);
$this->assertSame($pdoListing[0]->getListingParentId(), $this->VALID_PARENT_ID);
$this->assertEquals($pdoListing[0]->getListingPostTime(), $this->valid_datetime);
$this->assertSame($pdoListing[0]->getListingTypeId(), $this->listingType->getlistingTypeId());
}
示例3: testValidDelete
/**
* test deleting a valid listing in the database
* */
public function testValidDelete()
{
//create a new listing, and insert it
$listing = new Listing(null, $this->organization->getOrgId(), $this->VALID_CLAIMEDBY, $this->VALID_LISTINGCLOSED, $this->VALID_COST, $this->VALID_MEMO, $this->VALID_PARENT_ID, $this->valid_datetime, $this->listingType->getListingTypeId());
$listing->insert($this->getPDO());
//perform the actual delete
$response = $this->guzzle->delete('https://bootcamp-coders.cnm.edu/~bbrown52/bread-basket/public_html/php/api/listing/' . $listing->getListingId(), ['headers' => ['X-XSRF-TOKEN' => $this->token]]);
//grab the data from guzzle and enforce that the status codes are correct
$this->assertSame($response->getStatusCode(), 200);
$body = $response->getBody();
$retrievedListing = json_decode($body);
$this->assertSame(200, $retrievedListing->status);
//try retrieving entry from database and ensure it was deleted
$deletedListing = Listing::getListingByListingId($this->getPDO(), $listing->getOrgId());
$this->assertNull($deletedListing);
}