Beispiel #1
0
				$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'] );
		
	
Beispiel #2
0
	
	
	$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);