abdollahpor
یک شنبه 15 اسفند 1395, 19:52 عصر
سلام دوستان شرمنده این خط کد مشکلش چیه :
$con = new connection();
$con->con->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
$stmt = $con->con->prepare("CREATE TEMPORARY TABLE Basket(temporary_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,ArtistName VARCHAR( 20 ),NAMEOfTheDVD VARCHAR( 30 ));INSERT INTO Basket( ArtistName, NAMEOfTheDVD) VALUES ( 'R', 'SHAWooSHANK');SELECT * FROM Basket;");
$stmt->execute();
while($fetch = $stmt->fetch()) { echo $fetch->NAMEOfTheDVD;}
خطایی که میده اینه :
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error in D:\xampp1\htdocs\admin\feak.php:15 Stack trace: #0 D:\xampp1\htdocs\admin\feak.php(15): PDOStatement->fetch() #1 {main} thrown in D:\xampp1\htdocs\admin\feak.php on line 15
$con = new connection();
$con->con->setAttribute(PDO::ATTR_EMULATE_PREPARES, 1);
$stmt = $con->con->prepare("CREATE TEMPORARY TABLE Basket(temporary_id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,ArtistName VARCHAR( 20 ),NAMEOfTheDVD VARCHAR( 30 ));INSERT INTO Basket( ArtistName, NAMEOfTheDVD) VALUES ( 'R', 'SHAWooSHANK');SELECT * FROM Basket;");
$stmt->execute();
while($fetch = $stmt->fetch()) { echo $fetch->NAMEOfTheDVD;}
خطایی که میده اینه :
Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error in D:\xampp1\htdocs\admin\feak.php:15 Stack trace: #0 D:\xampp1\htdocs\admin\feak.php(15): PDOStatement->fetch() #1 {main} thrown in D:\xampp1\htdocs\admin\feak.php on line 15