Return data values from controller in using json and ajax cakephp 3 -


i working in forms, each form have lot inputs, insert inputs in database using ajax in cakephp 3 works fine, problem when want return data insert in database data return code html , can't have access information example -> status, message, data. in controller have this:

 public function insertpassenger()  {   $this->layout = 'ajax';   $passenger = $this->passengers->newentity();   $dato=$this->request->data();   if ($this->request->is('ajax')) {       $passenger = $this->passengers->patchentity($passenger, $this->request->data);       $passenger->date = date('y-m-d h:i:s');       if ($this->passengers->save($passenger)) {          $data = [          'content' => $dato,          'status' => 'success',          'message' => 'el pasajero fue registrado correctamente',         ];        } else {         $data = [          'content' => $dato,          'status' => 'error',          'message' => 'verifique los datos',         ];       }   }   $this->set(compact('data')); // pass $data view   $this->set('_serialize', 'data'); // let jsonview class know variable use } 

now in js have this

$(document).on('submit','form',function(e) {     e.preventdefault();     var values = $(this).serialize();     var options = {};     $.ajax({        url: "/passengers/insertpassenger.json",        type: "post",        data: values,        success: function(dato){            console.log(dato);        },        error:function(e){            console.log(e)        }     }); }); 

here ok, when printed results console of google chrome console.log(dato);, have out (and in end information important):

<pre class="cake-error"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9b1de-trace').style.display = (document.getelementbyid('cakeerr5540307e9b1de-trace').style.display == 'none' ? '' : 'none');"><b>warning</b> (2)</a>: array_combine(): both parameters should have equal number of elements [<b>core/src/orm/rule/existsin.php</b>, line <b>102</b>]<div id="cakeerr5540307e9b1de-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9b1de-code').style.display = (document.getelementbyid('cakeerr5540307e9b1de-code').style.display == 'none' ? '' : 'none')">code</a> <a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9b1de-context').style.display = (document.getelementbyid('cakeerr5540307e9b1de-context').style.display == 'none' ? '' : 'none')">context</a><pre id="cakeerr5540307e9b1de-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$primary</span><span style="color: #007700">,</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$entity</span><span style="color: #007700">-&gt;</span><span style="color: #0000bb">extract</span><span style="color: #007700">(</span><span style="color: #0000bb">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000bb">_fields</span><span style="color: #007700">)</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">);</span></span></code></pre><pre id="cakeerr5540307e9b1de-context" class="cake-context" style="display: none;">$entity = object(app\model\entity\passenger) {      &#039;new&#039; =&gt; true,     &#039;accessible&#039; =&gt; [         &#039;travel_id&#039; =&gt; true,         &#039;nombre&#039; =&gt; true,         &#039;ci&#039; =&gt; true,         &#039;edad&#039; =&gt; true,         &#039;genero&#039; =&gt; true,         &#039;num_emergencia&#039; =&gt; true,         &#039;numero_asiento&#039; =&gt; true,         &#039;orden_asiento&#039; =&gt; true,         &#039;date&#039; =&gt; true,         &#039;update&#039; =&gt; true,         &#039;travel&#039; =&gt; true,         &#039;invoices&#039; =&gt; true     ],     &#039;properties&#039; =&gt; [         &#039;nombre&#039; =&gt; &#039;sasd&#039;,         &#039;ci&#039; =&gt; (int) 23,         &#039;edad&#039; =&gt; (int) 23,         &#039;genero&#039; =&gt; &#039;masculino&#039;,         &#039;num_emergencia&#039; =&gt; (int) 21,         &#039;numero_asiento&#039; =&gt; &#039;14&#039;,         &#039;orden_asiento&#039; =&gt; &#039;4_2&#039;,         &#039;travel_id&#039; =&gt; (int) 1,         &#039;date&#039; =&gt; &#039;2015-04-28 21:14:38&#039;     ],     &#039;dirty&#039; =&gt; [         &#039;nombre&#039; =&gt; true,         &#039;ci&#039; =&gt; true,         &#039;edad&#039; =&gt; true,         &#039;genero&#039; =&gt; true,         &#039;num_emergencia&#039; =&gt; true,         &#039;numero_asiento&#039; =&gt; true,         &#039;orden_asiento&#039; =&gt; true,         &#039;travel_id&#039; =&gt; true,         &#039;date&#039; =&gt; true     ],     &#039;original&#039; =&gt; [],     &#039;virtual&#039; =&gt; [],     &#039;errors&#039; =&gt; [],     &#039;repository&#039; =&gt; &#039;passengers&#039;  } $options = [     &#039;errorfield&#039; =&gt; &#039;travel_id&#039;,     &#039;message&#039; =&gt; &#039;this value not exist&#039;,     &#039;atomic&#039; =&gt; true,     &#039;associated&#039; =&gt; true,     &#039;checkrules&#039; =&gt; true,     &#039;checkexisting&#039; =&gt; true,     &#039;_primary&#039; =&gt; true,     &#039;repository&#039; =&gt; object(app\model\table\passengerstable) {          &#039;registryalias&#039; =&gt; &#039;passengers&#039;,         &#039;table&#039; =&gt; &#039;passengers&#039;,         &#039;alias&#039; =&gt; &#039;passengers&#039;,         &#039;entityclass&#039; =&gt; &#039;app\model\entity\passenger&#039;,         &#039;associations&#039; =&gt; [             [maximum depth reached]         ],         &#039;behaviors&#039; =&gt; [[maximum depth reached]],         &#039;defaultconnection&#039; =&gt; &#039;default&#039;,         &#039;connectionname&#039; =&gt; &#039;default&#039;      } ] $nulls = (int) 0 $schema = object(cake\database\schema\table) {     [protected] _table =&gt; &#039;travels&#039;     [protected] _columns =&gt; [         &#039;id&#039; =&gt; [             [maximum depth reached]         ],         &#039;fecha_hora&#039; =&gt; [             [maximum depth reached]         ],         &#039;precio&#039; =&gt; [             [maximum depth reached]         ],         &#039;date&#039; =&gt; [             [maximum depth reached]         ],         &#039;update&#039; =&gt; [             [maximum depth reached]         ],         &#039;output_id&#039; =&gt; [             [maximum depth reached]         ],         &#039;destination_id&#039; =&gt; [             [maximum depth reached]         ],         &#039;user_id&#039; =&gt; [             [maximum depth reached]         ],         &#039;bus_id&#039; =&gt; [             [maximum depth reached]         ]     ]     [protected] _indexes =&gt; [         &#039;fk_travels_outputs1_idx&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_destinations1_idx&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_users1_idx&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_buses1_idx&#039; =&gt; [             [maximum depth reached]         ]     ]     [protected] _constraints =&gt; [         &#039;primary&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_buses1&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_destinations1&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_outputs1&#039; =&gt; [             [maximum depth reached]         ],         &#039;fk_travels_users1&#039; =&gt; [             [maximum depth reached]         ]     ]     [protected] _options =&gt; [         &#039;engine&#039; =&gt; &#039;innodb&#039;,         &#039;collation&#039; =&gt; &#039;utf8_general_ci&#039;     ]     [protected] _temporary =&gt; false     [protected] _columnkeys =&gt; [         &#039;type&#039; =&gt; null,         &#039;length&#039; =&gt; null,         &#039;precision&#039; =&gt; null,         &#039;null&#039; =&gt; null,         &#039;default&#039; =&gt; null,         &#039;comment&#039; =&gt; null     ]     [protected] _columnextras =&gt; [         &#039;string&#039; =&gt; [             [maximum depth reached]         ],         &#039;integer&#039; =&gt; [             [maximum depth reached]         ],         &#039;biginteger&#039; =&gt; [             [maximum depth reached]         ],         &#039;decimal&#039; =&gt; [             [maximum depth reached]         ],         &#039;float&#039; =&gt; [             [maximum depth reached]         ]     ]     [protected] _indexkeys =&gt; [         &#039;type&#039; =&gt; null,         &#039;columns&#039; =&gt; [[maximum depth reached]],         &#039;length&#039; =&gt; [[maximum depth reached]],         &#039;references&#039; =&gt; [[maximum depth reached]],         &#039;update&#039; =&gt; &#039;restrict&#039;,         &#039;delete&#039; =&gt; &#039;restrict&#039;     ]     [protected] _validindextypes =&gt; [         (int) 0 =&gt; &#039;index&#039;,         (int) 1 =&gt; &#039;fulltext&#039;     ]     [protected] _validconstrainttypes =&gt; [         (int) 0 =&gt; &#039;primary&#039;,         (int) 1 =&gt; &#039;unique&#039;,         (int) 2 =&gt; &#039;foreign&#039;     ]     [protected] _validforeignkeyactions =&gt; [         (int) 0 =&gt; &#039;cascade&#039;,         (int) 1 =&gt; &#039;setnull&#039;,         (int) 2 =&gt; &#039;setdefault&#039;,         (int) 3 =&gt; &#039;noaction&#039;,         (int) 4 =&gt; &#039;restrict&#039;     ] } $field = &#039;travel_id&#039; $alias = &#039;travels&#039; $primary = [     (int) 0 =&gt; &#039;travels.id&#039;,     (int) 1 =&gt; &#039;travels.output_id&#039;,     (int) 2 =&gt; &#039;travels.destination_id&#039;,     (int) 3 =&gt; &#039;travels.user_id&#039;,     (int) 4 =&gt; &#039;travels.bus_id&#039; ]</pre><pre class="stack-trace">array_combine - [internal], line ?? cake\orm\rule\existsin::__invoke() - core/src/orm/rule/existsin.php, line 102 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::checkcreate() - core/src/orm/ruleschecker.php, line 258 cake\orm\ruleschecker::check() - core/src/orm/ruleschecker.php, line 231 cake\orm\table::checkrules() - core/src/orm/table.php, line 2148 cake\orm\table::_processsave() - core/src/orm/table.php, line 1410 cake\orm\table::cake\orm\{closure}() - core/src/orm/table.php, line 1367 cake\database\connection::transactional() - core/src/database/connection.php, line 561 cake\orm\table::save() - core/src/orm/table.php, line 1368 app\controller\passengerscontroller::insertpassenger() - app/controller/passengerscontroller.php, line 170 cake\controller\controller::invokeaction() - core/src/controller/controller.php, line 412 cake\routing\dispatcher::_invoke() - core/src/routing/dispatcher.php, line 114 cake\routing\dispatcher::dispatch() - core/src/routing/dispatcher.php, line 87 [main] - root/webroot/index.php, line 37</pre></div></pre><pre class="cake-error"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9c451-trace').style.display = (document.getelementbyid('cakeerr5540307e9c451-trace').style.display == 'none' ? '' : 'none');"><b>warning</b> (4096)</a>: argument 1 passed cake\database\expression\queryexpression::_addconditions() must of type array, boolean given, called in /home/widrogo/code/estacion/vendor/cakephp/cakephp/src/database/expression/queryexpression.php on line 123 , defined [<b>core/src/database/expression/queryexpression.php</b>, line <b>478</b>]<div id="cakeerr5540307e9c451-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9c451-code').style.display = (document.getelementbyid('cakeerr5540307e9c451-code').style.display == 'none' ? '' : 'none')">code</a> <a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9c451-context').style.display = (document.getelementbyid('cakeerr5540307e9c451-context').style.display == 'none' ? '' : 'none')">context</a><pre id="cakeerr5540307e9c451-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">*&nbsp;@return&nbsp;</span><span style="color: #0000bb">void</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">*/</span></span></code></span> <code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">protected&nbsp;function&nbsp;</span><span style="color: #0000bb">_addconditions</span><span style="color: #007700">(array&nbsp;</span><span style="color: #0000bb">$conditions</span><span style="color: #007700">,&nbsp;array&nbsp;</span><span style="color: #0000bb">$types</span><span style="color: #007700">)</span></span></code></pre><pre id="cakeerr5540307e9c451-context" class="cake-context" style="display: none;">$this = object(cake\database\expression\queryexpression) {     [protected] _conjunction =&gt; &#039;and&#039;     [protected] _conditions =&gt; []     [protected] _typemap =&gt; object(cake\database\typemap) {} }</pre><pre class="stack-trace">cake\database\expression\queryexpression::_addconditions() - core/src/database/expression/queryexpression.php, line 478 cake\database\expression\queryexpression::add() - core/src/database/expression/queryexpression.php, line 123 cake\database\query::_conjugate() - core/src/database/query.php, line 1653 cake\database\query::where() - core/src/database/query.php, line 761 cake\orm\table::exists() - core/src/orm/table.php, line 1256 cake\orm\association::__call() - core/src/orm/association.php, line 837 cake\orm\association\belongsto::exists() - core/src/orm/rule/existsin.php, line 103 cake\orm\rule\existsin::__invoke() - core/src/orm/rule/existsin.php, line 103 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::checkcreate() - core/src/orm/ruleschecker.php, line 258 cake\orm\ruleschecker::check() - core/src/orm/ruleschecker.php, line 231 cake\orm\table::checkrules() - core/src/orm/table.php, line 2148 cake\orm\table::_processsave() - core/src/orm/table.php, line 1410 cake\orm\table::cake\orm\{closure}() - core/src/orm/table.php, line 1367 cake\database\connection::transactional() - core/src/database/connection.php, line 561</pre></div></pre><pre class="cake-error"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9d172-trace').style.display = (document.getelementbyid('cakeerr5540307e9d172-trace').style.display == 'none' ? '' : 'none');"><b>warning</b> (2)</a>: invalid argument supplied foreach() [<b>core/src/database/expression/queryexpression.php</b>, line <b>484</b>]<div id="cakeerr5540307e9d172-trace" class="cake-stack-trace" style="display: none;"><a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9d172-code').style.display = (document.getelementbyid('cakeerr5540307e9d172-code').style.display == 'none' ? '' : 'none')">code</a> <a href="javascript:void(0);" onclick="document.getelementbyid('cakeerr5540307e9d172-context').style.display = (document.getelementbyid('cakeerr5540307e9d172-context').style.display == 'none' ? '' : 'none')">context</a><pre id="cakeerr5540307e9d172-code" class="cake-code-dump" style="display: none;"><code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$typemap&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000bb">$this</span><span style="color: #007700">-&gt;</span><span style="color: #0000bb">typemap</span><span style="color: #007700">()-&gt;</span><span style="color: #0000bb">types</span><span style="color: #007700">(</span><span style="color: #0000bb">$types</span><span style="color: #007700">);</span></span></code> <span class="code-highlight"><code><span style="color: #000000"><span style="color: #0000bb"></span></span></code></span> <code><span style="color: #000000"><span style="color: #0000bb">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #007700">foreach&nbsp;(</span><span style="color: #0000bb">$conditions&nbsp;</span><span style="color: #007700">as&nbsp;</span><span style="color: #0000bb">$k&nbsp;</span><span style="color: #007700">=&gt;&nbsp;</span><span style="color: #0000bb">$c</span><span style="color: #007700">)&nbsp;{</span></span></code></pre><pre id="cakeerr5540307e9d172-context" class="cake-context" style="display: none;">$this = object(cake\database\expression\queryexpression) {     [protected] _conjunction =&gt; &#039;and&#039;     [protected] _conditions =&gt; []     [protected] _typemap =&gt; object(cake\database\typemap) {} } $conditions = false $types = [] $operators = [     (int) 0 =&gt; &#039;and&#039;,     (int) 1 =&gt; &#039;or&#039;,     (int) 2 =&gt; &#039;xor&#039; ] $typemap = object(cake\database\typemap) {     [protected] _defaults =&gt; [         &#039;travels.id&#039; =&gt; &#039;integer&#039;,         &#039;id&#039; =&gt; &#039;integer&#039;,         &#039;travels.fecha_hora&#039; =&gt; &#039;datetime&#039;,         &#039;fecha_hora&#039; =&gt; &#039;datetime&#039;,         &#039;travels.precio&#039; =&gt; &#039;float&#039;,         &#039;precio&#039; =&gt; &#039;float&#039;,         &#039;travels.date&#039; =&gt; &#039;datetime&#039;,         &#039;date&#039; =&gt; &#039;datetime&#039;,         &#039;travels.update&#039; =&gt; &#039;datetime&#039;,         &#039;update&#039; =&gt; &#039;datetime&#039;,         &#039;travels.output_id&#039; =&gt; &#039;integer&#039;,         &#039;output_id&#039; =&gt; &#039;integer&#039;,         &#039;travels.destination_id&#039; =&gt; &#039;integer&#039;,         &#039;destination_id&#039; =&gt; &#039;integer&#039;,         &#039;travels.user_id&#039; =&gt; &#039;integer&#039;,         &#039;user_id&#039; =&gt; &#039;integer&#039;,         &#039;travels.bus_id&#039; =&gt; &#039;integer&#039;,         &#039;bus_id&#039; =&gt; &#039;integer&#039;     ]     [protected] _types =&gt; [] }</pre><pre class="stack-trace">cake\database\expression\queryexpression::_addconditions() - core/src/database/expression/queryexpression.php, line 484 cake\database\expression\queryexpression::add() - core/src/database/expression/queryexpression.php, line 123 cake\database\query::_conjugate() - core/src/database/query.php, line 1653 cake\database\query::where() - core/src/database/query.php, line 761 cake\orm\table::exists() - core/src/orm/table.php, line 1256 cake\orm\association::__call() - core/src/orm/association.php, line 837 cake\orm\association\belongsto::exists() - core/src/orm/rule/existsin.php, line 103 cake\orm\rule\existsin::__invoke() - core/src/orm/rule/existsin.php, line 103 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::cake\orm\{closure}() - core/src/orm/ruleschecker.php, line 378 cake\orm\ruleschecker::checkcreate() - core/src/orm/ruleschecker.php, line 258 cake\orm\ruleschecker::check() - core/src/orm/ruleschecker.php, line 231 cake\orm\table::checkrules() - core/src/orm/table.php, line 2148 cake\orm\table::_processsave() - core/src/orm/table.php, line 1410 cake\orm\table::cake\orm\{closure}() - core/src/orm/table.php, line 1367 cake\database\connection::transactional() - core/src/database/connection.php, line 561</pre></div></pre>{     "content": {         "nombre": "sasd",         "ci": "23",         "edad": "23",         "genero": "masculino",         "num_emergencia": "21",         "numero_asiento": "14",         "orden_asiento": "4_2",         "travel_id": "1"     },     "status": "success",     "message": "el pasajero fue registrado correctamente" } 


Comments

Popular posts from this blog

java - Spring Data JPA: Why findOne(id) executing delete query internally? -

python - Mongodb How to add addtional information when aggregating? -

java - Incorrect order of records in M-M relationship in hibernate -