[eluser]Thiago Leao[/eluser]
Hi guys!!!
I'm having a problem with array.
I is a description with several inputs, and want to update all at once.
Code:
<?
echo form_open(base_url().'administracao/cad_produto/alterarDesc');
foreach($produtos as $item):
?>
<li>
<a >imagem;?>" rel="lightbox">
<?php echo img(array('src' => $item->thumb, 'alt' => $item->descricao, 'title' => $item->descricao));?>
</a>
<div class="itens_form">
<?php
echo form_hidden('id_pictures[]', $item->id_pictures);
echo form_hidden('id_products', $item->id_products);
echo form_label('', 'descricao')."\n";
echo form_input('descricao[]', $item->descricao);
?>
<a >id_pictures; ?>/<?php echo $item->id_products; ?>" onClick="return(deleta());" title="Apagar">
<?php echo img(array('src' => 'assets/admin/images/apagar.png', 'alt' => 'Apagar'));?></a>
</div>
</li>
<?php
endforeach;
echo '<li>'.form_submit('mysubmit').'</li>';
echo form_close();
controller
Code:
function alterarDesc(){
for($i=0; $i<count($_POST['descricao']); $i++){
$data['descricao'] = $this->input->post('descricao');
$data['id_products'] = $this->input->post('id_products');
$data['id_pictures'] = $this->input->post('id_pictures');
$this->load->model('administracao/cad_produto_model');
$this->cad_produto_model->alterarDesc($data);
}
redirect(base_url().'administracao/cad_produto/upload/'.$data['id_products'], 'refresh');
}
Error
Error Number: 1054
Unknown column 'Array' in 'field list'
UPDATE `pictures` SET `descricao` = Array, `id_products` = '37', `id_pictures` = '153' WHERE `id_pictures` = '153'
Can someone help me?
thanks!