API tools faq
paste
Guest User

Untitled

a guest
Feb 20th, 2021
17
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 16.24 KB | None | 0 0
raw download clone embed print report
  1.  
  2.  
  3. [CODE]<?php
  4.  
  5. namespace App\Http\Controllers\Admin;
  6.  
  7. use Illuminate\Http\Request;
  8.  
  9. use App\Http\Requests;
  10. use App\Http\Controllers\Controller;
  11. use Illuminate\Http\Response;
  12. use Illuminate\Http\RedirectResponse;
  13. use DB;
  14.  
  15. class AboutController extends Controller
  16. {
  17. //
  18. public function show() {
  19.  
  20. if(view()->exists('default.about')) {
  21.  
  22. // $artiles = DB::select("SELECT * FROm `articles` WHERE id = :id",['id'=>2]);
  23.  
  24. DB::insert("INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)", ['test 1','TEXT']);
  25. $artiles = DB::select("SELECT * FROm `articles` ");
  26.  
  27. //$result = DB::connection()->getPdo()->lastInsertId();
  28.  
  29. //$result = DB::update('UPDATE `articles` SET `name` = ? WHERE `id` = ?', ["TEST 2",6]);
  30. //$result = DB::update('UPDATE `articles` SET `name` = ? WHERE `id` = ?', ["TEST 3",6]);
  31.  
  32. //$result = DB::delete('DELETE FROM `articles` WHERE `id` = ?', [6]);
  33.  
  34. //DB::statement('DROP table `articles`');
  35.  
  36. // $artiles = DB::select("SELECT * FROm `articles");
  37. //
  38. // //dump($result);
  39. dump($artiles); //dd()
  40. //
  41. // foreach($artiles as $article) {
  42. //
  43. // }
  44. return view('default.about')->withTitle('Hello World');
  45.  
  46. }
  47. abort(404);
  48. }
  49.  
  50. }
  51. [/CODE]
  52.  
  53.  
  54. Whoops, looks like something went wrong.
  55. 3/3 QueryException in Connection.php line 770: SQLSTATE[HY000]: General error: 1364 Field 'img' doesn't have a default value (SQL: INSERT INTO `articles` (`name`,`text`) VALUES (test 1, TEXT))
  56.  
  57. in Connection.php line 770
  58. at Connection->runQueryCallback('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 726
  59. at Connection->run('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 481
  60. at Connection->statement('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in Connection.php line 435
  61. at Connection->insert('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in DatabaseManager.php line 317
  62. at DatabaseManager->__call('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in Facade.php line 237
  63. at Facade::__callStatic('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in AboutController.php line 22
  64. at AboutController->show()
  65. at call_user_func_array(array(object(AboutController), 'show'), array()) in Controller.php line 55
  66. at Controller->callAction('show', array()) in ControllerDispatcher.php line 44
  67. at ControllerDispatcher->dispatch(object(Route), object(AboutController), 'show') in Route.php line 189
  68. at Route->runController() in Route.php line 144
  69. at Route->run(object(Request)) in Router.php line 653
  70. at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
  71. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Mymiddleware.php line 29
  72. at Mymiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137
  73. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  74. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
  75. at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
  76. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  77. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
  78. at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
  79. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  80. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  81. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  82. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  83. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  84. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  85. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  86. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  87. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
  88. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  89. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  90. at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
  91. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  92. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  93. at Pipeline->then(object(Closure)) in Router.php line 655
  94. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
  95. at Router->dispatchToRoute(object(Request)) in Router.php line 607
  96. at Router->dispatch(object(Request)) in Kernel.php line 268
  97. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
  98. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  99. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  100. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  101. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
  102. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
  103. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  104. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  105. at Pipeline->then(object(Closure)) in Kernel.php line 150
  106. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
  107. at Kernel->handle(object(Request)) in index.php line 53
  108.  
  109. 2/3 PDOException in PDOStatement.php line 119: SQLSTATE[HY000]: General error: 1364 Field 'img' doesn't have a default value
  110.  
  111. in PDOStatement.php line 119
  112. at PDOStatement->execute() in Connection.php line 480
  113. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in Connection.php line 763
  114. at Connection->runQueryCallback('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 726
  115. at Connection->run('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 481
  116. at Connection->statement('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in Connection.php line 435
  117. at Connection->insert('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in DatabaseManager.php line 317
  118. at DatabaseManager->__call('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in Facade.php line 237
  119. at Facade::__callStatic('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in AboutController.php line 22
  120. at AboutController->show()
  121. at call_user_func_array(array(object(AboutController), 'show'), array()) in Controller.php line 55
  122. at Controller->callAction('show', array()) in ControllerDispatcher.php line 44
  123. at ControllerDispatcher->dispatch(object(Route), object(AboutController), 'show') in Route.php line 189
  124. at Route->runController() in Route.php line 144
  125. at Route->run(object(Request)) in Router.php line 653
  126. at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
  127. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Mymiddleware.php line 29
  128. at Mymiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137
  129. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  130. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
  131. at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
  132. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  133. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
  134. at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
  135. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  136. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  137. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  138. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  139. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  140. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  141. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  142. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  143. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
  144. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  145. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  146. at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
  147. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  148. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  149. at Pipeline->then(object(Closure)) in Router.php line 655
  150. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
  151. at Router->dispatchToRoute(object(Request)) in Router.php line 607
  152. at Router->dispatch(object(Request)) in Kernel.php line 268
  153. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
  154. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  155. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  156. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  157. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
  158. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
  159. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  160. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  161. at Pipeline->then(object(Closure)) in Kernel.php line 150
  162. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
  163. at Kernel->handle(object(Request)) in index.php line 53
  164.  
  165. 1/3 PDOException in PDOStatement.php line 117: SQLSTATE[HY000]: General error: 1364 Field 'img' doesn't have a default value
  166.  
  167. in PDOStatement.php line 117
  168. at PDOStatement->execute(null) in PDOStatement.php line 117
  169. at PDOStatement->execute() in Connection.php line 480
  170. at Connection->Illuminate\Database\{closure}(object(MySqlConnection), 'INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in Connection.php line 763
  171. at Connection->runQueryCallback('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 726
  172. at Connection->run('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'), object(Closure)) in Connection.php line 481
  173. at Connection->statement('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in Connection.php line 435
  174. at Connection->insert('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT')) in DatabaseManager.php line 317
  175. at DatabaseManager->__call('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in Facade.php line 237
  176. at Facade::__callStatic('insert', array('INSERT INTO `articles` (`name`,`text`) VALUES (?, ?)', array('test 1', 'TEXT'))) in AboutController.php line 22
  177. at AboutController->show()
  178. at call_user_func_array(array(object(AboutController), 'show'), array()) in Controller.php line 55
  179. at Controller->callAction('show', array()) in ControllerDispatcher.php line 44
  180. at ControllerDispatcher->dispatch(object(Route), object(AboutController), 'show') in Route.php line 189
  181. at Route->runController() in Route.php line 144
  182. at Route->run(object(Request)) in Router.php line 653
  183. at Router->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 53
  184. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Mymiddleware.php line 29
  185. at Mymiddleware->handle(object(Request), object(Closure)) in Pipeline.php line 137
  186. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  187. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in SubstituteBindings.php line 41
  188. at SubstituteBindings->handle(object(Request), object(Closure)) in Pipeline.php line 137
  189. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  190. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in VerifyCsrfToken.php line 65
  191. at VerifyCsrfToken->handle(object(Request), object(Closure)) in Pipeline.php line 137
  192. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  193. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in ShareErrorsFromSession.php line 49
  194. at ShareErrorsFromSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  195. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  196. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  197. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  198. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  199. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in AddQueuedCookiesToResponse.php line 37
  200. at AddQueuedCookiesToResponse->handle(object(Request), object(Closure)) in Pipeline.php line 137
  201. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  202. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in EncryptCookies.php line 59
  203. at EncryptCookies->handle(object(Request), object(Closure)) in Pipeline.php line 137
  204. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  205. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  206. at Pipeline->then(object(Closure)) in Router.php line 655
  207. at Router->runRouteWithinStack(object(Route), object(Request)) in Router.php line 629
  208. at Router->dispatchToRoute(object(Request)) in Router.php line 607
  209. at Router->dispatch(object(Request)) in Kernel.php line 268
  210. at Kernel->Illuminate\Foundation\Http\{closure}(object(Request)) in Pipeline.php line 53
  211. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in StartSession.php line 64
  212. at StartSession->handle(object(Request), object(Closure)) in Pipeline.php line 137
  213. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  214. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in CheckForMaintenanceMode.php line 46
  215. at CheckForMaintenanceMode->handle(object(Request), object(Closure)) in Pipeline.php line 137
  216. at Pipeline->Illuminate\Pipeline\{closure}(object(Request)) in Pipeline.php line 33
  217. at Pipeline->Illuminate\Routing\{closure}(object(Request)) in Pipeline.php line 104
  218. at Pipeline->then(object(Closure)) in Kernel.php line 150
  219. at Kernel->sendRequestThroughRouter(object(Request)) in Kernel.php line 117
  220. at Kernel->handle(object(Request)) in index.php line 53
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!