Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="post" action="" enctype="multipart/form-data">
- <label for="fichier">Ajouter raster :</label><br />
- <input type="file" name="fichier" />
- <input type="submit" name="submit" value="Envoyer" /> </form>
- <?php $name = $_FILES['fichier']['name']; $db = pg_connect('host=localhost port=5432 dbname=gisdb user=postgres >password=******'); $output =shell_exec("raster2pgsql -a -s 32629 -I -C -F -M '".$_FILES["fichier"]["tmp_name"]."' eau_param_hydro | psql -U postgres -d gisdb -h localhost -p 5432 "); $req = exec(" SELECT * FROM '".$output."' ");
- $result = pg_query($db,"INSERT INTO eau_param_hydro(rast,filename) >VALUES('".$req."','".$name."');");
- if (!$result) {
- $errormessage = pg_last_error();
- echo "Error with query: " . $errormessage;
- exit();
- } pg_close(); ?>
- <?php $fcontents = file_get_contents($_FILES["fichier"]["tmp_name"]);
- $db = pg_connect('host=localhost port=5432 dbname=gisdb user=postgres password=******');
- $sql = 'INSERT INTO eau_param_hydro(filename,rast)
- VALUES($1, ST_FromGDALRaster( ($2)::bytea ) );';
- $params = array($_FILES["fichier"]["name"], pg_escape_bytea($fcontents) );
- $result = pg_query_params($db, $sql, $params);
- pg_close(); ?>
Add Comment
Please, Sign In to add comment