$saveDirectory = '../../produtos/'; $tempName = $_FILES[$campo]['tmp_name']; $fileName = $_FILES[$campo]['name']; @unlink($saveDirectory.$fileName); //unlink($saveDirectory.$fileNanemin); if (!move_uploaded_file($tempName, $saveDirectory . $fileName)) { echo 'Erro!'; } } } $query .= $campo." = '".$valor."', "; } $query = tiravirgula($query); echo $query .= " WHERE $id_table = $id "; // colocando o id de Time para gravar sempre a hora. mysql_query($query,$conexao) or die(mysql_error()); } if ($_REQUEST['t'] == "historico" and $_REQUEST['id_ficha'] != "" ) header("Location: principal.php?t=historico&p=historico&id=".$_REQUEST['id_ficha'] );
$campos = "$id_table, "; $busca = " and ( "; foreach($_POST['colunas'] as $codigo => $value){ $campos .= " $value ,"; $busca .= " $value like '%" . $filtro . "%' or"; } $campos = tiravirgula($campos); $busca = tiravirgula($busca); $busca .= " ) "; $sql =" SELECT $campos from ".$table." where 1 "; if ( $filtro != "" ) $sql .= $busca; //echo $sql .= " order by nome asc"; $tabela = mysql_query( $sql,$conexao ) or die (mysql_error().$sql ); $rows = mysql_num_rows($tabela); $cols = mysql_num_fields($tabela);