Kod
Wystąpił błąd SQL: Data too long for column 'tresc' at row 1 - INSERT INTO `heniek_shoutbox-adm` (`id_uzytkownik`, `data`, `tresc`) VALUES ('1', '2009-07-11 11:50:55', 'TeÅ�cik')
Kontroler:
<?php class Shoutbox_Controller extends Glowna_Controller { public function __construct() { parent::__construct(); $this-> session= Session:: instance(); } public function index() { if(Simple_Auth::instance() -> logged_in()) { $post = new Validation($_POST); $post -> pre_filter('trim') -> pre_filter('htmlentities') -> add_rules('tresc', 'required', 'length[3, 200]'); if($post -> validate()) { $username = Simple_Auth::instance()->get_user(); $shoutbox = Simple_Modeler::factory('Admin_Shoutbox_Dodaj'); $shoutbox -> id_uzytkownik=$username->id; $shoutbox -> tresc=$post['tresc']; $shoutbox -> save(); Session :: set_flash('shoutbox_error', Kohana :: lang('shoutbox.ok')); } else { Session :: set_flash('shoutbox_error', Kohana :: lang('shoutbox.error')); } } url :: redirect('adm/glowna'); } } ?>
Model:
<?php class Admin_Shoutbox_Dodaj_Model extends Simple_Modeler { // Database table name protected $table_name = 'shoutbox-adm'; protected $auto_fields = FALSE; 'data' => '', 'tresc' => ''); } ?>
Dodam, że metoda porównywania napisów to: utf8_unicode_ci