Код: Выделить всё
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
// set the PDO error mode to exception
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
$orderNumber = $_GET['orderID'];
echo "Order number: $orderNumber";
// Get all orders from database for this user
$sql = "SELECT userID, order_files.orderID, order_files.serviceID, SUM(file_total) as orderTotal, date_created FROM order_files
LEFT JOIN orders ON order_files.orderID = orders.orderID where order_files.orderID = :orderID GROUP BY order_files.orderID";
try {
$stmt = $conn->prepare($sql);
if (!$stmt) {
echo "\nPDO::errorInfo():\n";
print_r($conn->errorInfo());
}
$stmt->execute(array('orderID' => $orderNumber));
$results = $stmt->fetchAll();
var_dump($results);
} catch (PDOException $pdoError) {
echo "I'm sorry, Dave. I'm afraid I can't do that.";
throw new error($pdoError->getMessage());
}
Страница просто перестает выполнять все действия после $stmt = $conn->prepare($sql);
Подробнее здесь: https://stackoverflow.com/questions/791 ... nt-display
Мобильная версия