Andymodel.php 780 B

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556
  1. <?php namespace App\Models;
  2. use CodeIgniter\Database\ConnectionInterface;
  3. use CodeIgniter\Model;
  4. class Andymodel extends Model
  5. {
  6. protected $table = 'blog';
  7. protected $allowedFields = ['title', 'article'];
  8. public function index()
  9. {
  10. $db = \Config\Database::connect("default");
  11. $query = $db->query("SELECT * FROM portfolio");
  12. $row = $query->getRowArray();
  13. return $row['imageTitle'].$row['Id'];
  14. }
  15. public function getAll()
  16. {
  17. return $this->findAll();
  18. }
  19. public function insertData($title,$article)
  20. {
  21. $db = \Config\Database::connect("default");
  22. echo $title;
  23. echo $article;
  24. $sql = "INSERT INTO blog ( title,article) VALUES ('.$title.','.$article.')";
  25. $db->query($sql);
  26. }
  27. public function create()
  28. {
  29. echo "hello you found me";
  30. }
  31. }