[pgrouting-users] pgrouting workshop

[Pedro Costa]

Finally I see the route.
The problem is that is wrong (see screnn shot)
I think is that postgis query is selecting wrong vertices!




Em 11-07-2012 11:16, Daniel Kastl escreveu:
> And you're maybe missing a space as well.
>
> $con = pg_connect("dbname=".PG_DB." host=".PG_HOST." user=".PG_USER." 
> password=".PG_PASS);
>
> ... might be better. Just ensure that "password" is correct.
>
> Daniel
>
>
> On Wed, Jul 11, 2012 at 12:14 PM, Daniel Kastl <daniel at georepublic.de 
> <mailto:daniel at georepublic.de>> wrote:
>
>     Hi Pedro,
>
>     When comparing your line with the workshop source on GitHub [1], I
>     see that you added "password" to the connection string.
>     I think you're missing a "." before "Password" and are you sure
>     the syntax is correct and it needs to be a capital "P"?
>
>     Daniel
>
>
>
>     [1]
>     https://github.com/pgRouting/workshop/blob/master/web/php/pgrouting.php
>
>
>
>     On Wed, Jul 11, 2012 at 10:47 AM, Pedro Costa
>     <pedrocostaarma at sapo.pt <mailto:pedrocostaarma at sapo.pt>> wrote:
>
>
>         Hi Daniel
>
>
>         In apache log i found this error:
>
>         [error] an unknown filter was not added: PHP
>         [error] [client my client] PHP Parse error: syntax error,
>         unexpected T_CONSTANT_ENCAPSED_STRING in 'my
>         domain'/routing/php/pgrouting.php on line 42, referer:
>
>
>         Line 42 is my db data:
>
>
>          // Connect to database
>           $con = pg_connect("dbname=".PG_DB." host=".PG_HOST."
>         user=".PG_USER "Password=".PG_PASS);
>
>
>
>         do you know what is the problem?
>
>
>         Thanks
>
>
>
>
>
>
>         Em 10-07-2012 17:12, Daniel Kastl escreveu:
>>
>>
>>             server: http://pastebin.com/tdWDgj54
>>
>>
>>         You're missing quotation in line 11 ... that's when the code
>>         highlighting becomes weird.
>>
>>         Otherwise, try to output the SQL queries to the server log
>>         and then run the query in the terminal.
>>         Like this you can see if your query is OK or not.
>>
>>         Daniel
>>
>>
>>
>>         -- 
>>         Georepublic UG & Georepublic Japan
>>         eMail: daniel.kastl at georepublic.de
>>         <mailto:daniel.kastl at georepublic.de>
>>         Web: http://georepublic.de <http://georepublic.de/>
>>
>>
>>         _______________________________________________
>>         Pgrouting-users mailing list
>>         Pgrouting-users at lists.osgeo.org  <mailto:Pgrouting-users at lists.osgeo.org>
>>         http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>         _______________________________________________
>         Pgrouting-users mailing list
>         Pgrouting-users at lists.osgeo.org
>         <mailto:Pgrouting-users at lists.osgeo.org>
>         http://lists.osgeo.org/mailman/listinfo/pgrouting-users
>
>
>
>
>     -- 
>     Georepublic UG & Georepublic Japan
>     eMail: daniel.kastl at georepublic.de
>     <mailto:daniel.kastl at georepublic.de>
>     Web: http://georepublic.de <http://georepublic.de/>
>
>
>
>
> -- 
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de <mailto:daniel.kastl at georepublic.de>
> Web: http://georepublic.de <http://georepublic.de/>
>
>
> _______________________________________________
> Pgrouting-users mailing list
> Pgrouting-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-users


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120712/b7c68ace/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: ss.png
Type: image/png
Size: 35021 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/pgrouting-users/attachments/20120712/b7c68ace/attachment-0001.png>