public function getValue() { require "mysql_util.php"; if (isset($operandValue)) { return $operandValue; } $mysqli = MySql::getConnection(); $questionID = trim($operandString, "[]"); $mysql_value = $mysqli->query("SELECT `Response` FROM Questions WHERE `ID` = '{$questionID}'"); if (!$mysql_value) { throw new Exception("There was a MySQL error: {$mysqli->error}"); return false; } $mysql_value = mysqli_fetch_assoc($mysql_value); return $mysql_value['Response']; }
/** * @expectedException \MiniOrm\DbalException */ public function testGetInvalidConnection() { $oConfig = Configuration::getInstance(); $oConfig->read(__DIR__ . self::TEST_EMPTY_CONFIG); $this->object->getConnection($oConfig); }
<?php require "mysql.php"; $mysqli = MySql::getConnection(); $user_message = ""; if (isset($_POST['submit'])) { $customerID = $_POST['customer']; $itemsSold = $_POST['item']; $quantitySold = $_POST['quantity']; $sql = ""; foreach ($itemsSold as $key => $itemNumber) { $quantity = $quantitySold[$key]; $sql .= "INSERT INTO Sales (`CustomerID`, `ItemNumber`, `Quantity`, `Date`) VALUES ('{$customerID}', '{$itemNumber}', '{$quantity}', now());"; } if ($sql != "") { $sale = $mysqli->multi_query($sql); if (!$sale) { trigger_error("Could not save the sale. Error: {$mysqli->error}"); } else { $user_message = "Thank you. Your sale has been recorded."; do { $mysqli->use_result(); } while ($mysqli->next_result()); } } } ?> <!DOCTYPE html> <html lang="en"> <head>