php - Laravel add data to MySQL -


project on laravel 5.3, collecting data in session multiple pages , want add mysql. problem data doesn't inserted mysql created_at. data in variable, doesn't go saved in mysql.

model:

class post extends model {     public $vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4;      protected $fillable = ['vardas', 'pavarde', 'miestas', 'amzius', 'telefonas', 'pastas', 'q1', 'q2', 'q3', 'q4'];      public function addtodb($vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4)     {         $answer = new post;          $answer->vardas = $vardas;         $answer->pavarde = $pavarde;         $answer->miestas = $miestas;         $answer->amzius = $amzius;         $answer->telefonas = $telefonas;         $answer->pastas = $pastas;         $answer->q1 = $q1;         $answer->q2 = $q2;         $answer->q3 = $q3;         $answer->q4 = $q4;         $answer->save();     }  }

database:

  schema::create('answers', function (blueprint $table) {         $table->increments('id');         $table->string('vardas');         $table->string('pavarde')->nullable();         $table->string('miestas')->nullable();         $table->string('amzius')->nullable();         $table->string('telefonas')->nullable();         $table->string('pastas')->nullable();         $table->string('q1')->nullable();         $table->string('q2')->nullable();         $table->string('q3')->nullable();         $table->string('q4')->nullable();         $table->timestamps();     });

and controller:

   public function getaciu () {     $vardas = input::get('vardas');     $pavarde = input::get('pavarde');     $miestas = input::get('miestas');     $amzius = input::get('amzius');     $telefonas = input::get('telefonas');     $pastas = input::get('pastas');     $q1 = session::get('q1');     $q2 = session::get('q2');     $q3 = session::get('q3');     $q4 = session::get('q4');     $answer = new post;    $answer->addtodb($vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4);    return view('aciu'); }

i recommend use laravel 5.3 official syntax only.

as mentioned using laravel 5.3.

please try following code.

to debug value of variables use "dd($variable_name)";

note: make sure have changed access modifier of "addtodb" protected in order access on controller without int. class object e.g: $result = post::addtodb($vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4);.

model: use "use illuminate\database\eloquent\model;" before declaring model class

eg:

namespace app;  use illuminate\database\eloquent\model;      class post extends model     {          protected $fillable = ['vardas', 'pavarde', 'miestas', 'amzius', 'telefonas', 'pastas', 'q1', 'q2', 'q3', 'q4'];          protected function addtodb($vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4)         {            //dd($vardas); uncomment debug value of $vardas              $answer = new post();              $answer->vardas = $vardas;             $answer->pavarde = $pavarde;             $answer->miestas = $miestas;             $answer->amzius = $amzius;             $answer->telefonas = $telefonas;             $answer->pastas = $pastas;             $answer->q1 = $q1;             $answer->q2 = $q2;             $answer->q3 = $q3;             $answer->q4 = $q4;             return $answer->save();         }      }

controller:

please use following line before controller class declartions , modify "use app\post; " post model namespace.

e.g: 

namespace app\http\controllers; use illuminate\http\request; use app\http\controllers\controller; use app\post;  // please specify namespace of model here

modify controller method:

public function getaciu (request $request) {       //dd($request->all()); //uncomment debug complete request body         $vardas = $request -> input('vardas');                 $pavarde = $request -> input('pavarde');                 $miestas = $request -> input('miestas');                 $amzius = $request -> input('amzius');                 $telefonas = $request -> input('telefonas');                 $pastas = $request -> input('pastas');                 $q1 = $request -> session() - > get('q1');                 $q2 = $request -> session() - > get('q2');                 $q3 = $request -> session() - > ('q3');                 $q4 = $request -> session() - > ('q4');                 $result = post::addtodb($vardas, $pavarde, $miestas, $amzius, $telefonas, $pastas, $q1, $q2, $q3, $q4);                 return view('aciu');         }

  • as using laravel 5.3.

  • in laravel 5.3 $request->input('field_name') used instead of input::get('field_name');

  • and session can using $request->session()->get('key_name');

please check ref: https://laravel.com/docs/5.3/requests

hope above code work.


Comments

Post a Comment

Popular posts from this blog

iOS: Performance of reloading UIImage(name:...) -

i have tableview , each row has icon. 90% of rows have same icon. in cellforrowatindexpath method load image assets folder this: var cellimage = uiimage(named: "myimage") does pose performance problem? os somehow smart enough it's same image each time? better if loaded image once , saved in class variable , assigned each time? uiimage 's named: api does kind of caching. if @ uiimage's documentation , states: use init(named:in:compatiblewith:) method (or init(named:) method) create image image asset or image file located in app’s main bundle (or other known bundle). because these methods cache image data automatically, recommended images use frequently.
Read more

How to prevent logback from emitting repeated "Empty watch file list. Disabling" messages -

i have logback configured logback.xml located here: http://pastebin.com/kuquekxy . every minute, see log message emitted of form: 18:26:21,486 |-info in reconfigureonchangetask(born:1478715201485) - empty watch file list. disabling why happening , how can rid of these? i can tell why happening, not how rid of them. the reconfigureonchangetask log line when doesn't have files watch. and doesn't have files watch because file in jar, , only watch files on filesystem . makes sense, because files within jar file don't change.
Read more

c# SetCompatibleTextRenderingDefault must be called before the first -

i tried search exception couldn't find solution on case i'am using code below invoke .net application : assembly assem = assembly.load(data); methodinfo method = assem.entrypoint; var o = activator.createinstance(method.declaringtype); method.invoke(o, null); the application invoked has form , in entrypoint of application : [stathread] static void main() { application.enablevisualstyles(); application.setcompatibletextrenderingdefault(false); //exception application.run(new form1()); } setcompatibletextrenderingdefault must called before first iwin32window object created in application. edit : assembly = assembly.load(data); methodinfo method = a.gettype().getmethod("start"); var o = activator.createinstance(method.declaringtype); method.invoke(o, null); you should create new method skips initialization...
Read more