Get KRPANO to read from a DATABASE

Lieber Besucher, herzlich willkommen bei: krpano.com Forum. Falls dies Ihr erster Besuch auf dieser Seite ist, lesen Sie sich bitte die Hilfe durch. Dort wird Ihnen die Bedienung dieser Seite näher erläutert. Darüber hinaus sollten Sie sich registrieren, um alle Funktionen dieser Seite nutzen zu können. Benutzen Sie das Registrierungsformular, um sich zu registrieren oder informieren Sie sich ausführlich über den Registrierungsvorgang. Falls Sie sich bereits zu einem früheren Zeitpunkt registriert haben, können Sie sich hier anmelden.

3sfera

Fortgeschrittener

Beiträge: 249

Wohnort: Mexico City

Beruf: Virtual tours, Krpano coding, Graphic Design, Photographer, Panographer

Dienstag, 15. Mai 2012, 02:52

Get KRPANO to read from a DATABASE

Hello there, I'm currently working in a big proyect to sell lots of properties and I need to develop a INFO PANEL which shows some data about them (Cost, details, area, etc). Right now my idea is to create separated .png images of the panel for each site but it would be much much better to get KRPANO to read them from a DATABASE, specially if I need to update the panel.

I guess this must be a common need so, ¿Anyone has an idea of how to do it? specifically how to comunicate KRPANO whith the DATABASE and which format for the database is the best (excel chart, plain text, etc) I've read that whith PHP some of this can be done but I'm not a very skilled programmer and I don't have an idea of how to start. Your help is quite valuable!! Thanx in advance *g*

Cheers!!

Luis

imagen360.com / skyvr.mx
facebook.com/Erantzcani360
facebook.com/skyvrmx

Zum Seitenanfang

Sam Rohn

Schüler

Beiträge: 110

Wohnort: Brooklyn, New York

Beruf: 360° VR Photographer

Dienstag, 15. Mai 2012, 03:27

why not use wordpress, there are many free and premium themes and plugins specifically for running a real estate site, & panopress can handle your panoramas :)

otherwise rigging something up yourself to attach a panorama and whatever other data you like to a specific post should not be to tough, basically wordpress would be your database & krpano & other data would be stored within wordpress custom fields

sam

Sam Rohn :: 360° Panoramic Photography :: Location Scout :: New York City :: www.samrohn.com

PanoPress :: WordPress Plugin for 360° Panoramas in Flash & HTML5 :: www.panopress.org

Zum Seitenanfang

sachagriffin

Meister

Beiträge: 1 857

Beruf: Virtual Tours - Photography - Krpano developer

Dienstag, 15. Mai 2012, 04:01

RE: Get KRPANO to read from a DATABASE

Php arrays, you dont even need a db. Otherwise, any cms will do. You wont get anywhere unless you learn some basic programming or hire someone. You don't need a lot, but you do need to learn to access array, use loops, and manipulate variables.

Zitat von »3sfera«

Hello there, I'm currently working in a big proyect to sell lots of properties and I need to develop a INFO PANEL which shows some data about them (Cost, details, area, etc). Right now my idea is to create separated .png images of the panel for each site but it would be much much better to get KRPANO to read them from a DATABASE, specially if I need to update the panel.

I guess this must be a common need so, ¿Anyone has an idea of how to do it? specifically how to comunicate KRPANO whith the DATABASE and which format for the database is the best (excel chart, plain text, etc) I've read that whith PHP some of this can be done but I'm not a very skilled programmer and I don't have an idea of how to start. Your help is quite valuable!! Thanx in advance

Cheers!!

Luis

KRPano Developer: Portfolio ::Gigapixel Tagging Solutions - Porfolio 2 :: Facebook :: Twitter :: reddit.com/r/VirtualTour

Zum Seitenanfang

3sfera

Fortgeschrittener

Beiträge: 249

Wohnort: Mexico City

Beruf: Virtual tours, Krpano coding, Graphic Design, Photographer, Panographer

Dienstag, 15. Mai 2012, 06:19

-----> Sam

Ok, I haven't thought about wordpress but right now it's not an option for me because I want to manage all the content inside the interfase, I would also develop an interactive map to navigate panos and I'd also love to manage everything in fullscreen. As far as I can see Wordpress works fine to manage panos alone, but, I'm not sure if it's the best way for my needs right now, are you?

Even though I'll take your advice for a future, do you have any example of real state krpano aplication in WP, by now I haven't seen that and it sounds really good, if you could give me some example I'll appreciate it very much. Thanx!

-----> sachagriffin

Thanx for the PHP advice, it sounds the kind of programing skills I need. Maybe you're right about hiring someone for this task, it certainly would help me just that by now the budget is kindda short and I need to do it by my own. In a future I'll need a more professional advice for sure and with this "keywords" I may explain better what I need, meanwhile I'll google some of your answer to see what I can find. Cheers!

imagen360.com / skyvr.mx
facebook.com/Erantzcani360
facebook.com/skyvrmx

Zum Seitenanfang

3sfera

Fortgeschrittener

Beiträge: 249

Wohnort: Mexico City

Beruf: Virtual tours, Krpano coding, Graphic Design, Photographer, Panographer

Dienstag, 15. Mai 2012, 06:22

¿Any idea of how to read content from an excel spreadsheet from KRPANO? My clients are used to manage all their data in this tables so it would be more than fine to get KRPANO in comunication with an excel spreadsheet, ¿would it be PHP again?

Cheers!! *thumbsup*

imagen360.com / skyvr.mx
facebook.com/Erantzcani360
facebook.com/skyvrmx

Zum Seitenanfang

Sam Rohn

Schüler

Beiträge: 110

Wohnort: Brooklyn, New York

Beruf: 360° VR Photographer

Dienstag, 15. Mai 2012, 08:41

wordpress panorama map

Zitat von »3sfera«

-----> Sam

Ok, I haven't thought about wordpress but right now it's not an option for me because I want to manage all the content inside the interfase, I would also develop an interactive map to navigate panos and I'd also love to manage everything in fullscreen. As far as I can see Wordpress works fine to manage panos alone, but, I'm not sure if it's the best way for my needs right now, are you?

Even though I'll take your advice for a future, do you have any example of real state krpano aplication in WP, by now I haven't seen that and it sounds really good, if you could give me some example I'll appreciate it very much. Thanx!

here is a wordpress site using the geomashup googlemap & open street maps wordpress mapping plugin, krpano, pano2vr & panopress to display a map of panorama posts

http://widelens.ru/

and some info on the panopress forum

http://www.panopress.org/forum/discussio…gin-integration

and there are tons of wordpress real estate sites and articles about creating them, search google for wordpress real estate tutorials, videos, themes, plugins, etc

the advantage of using wordpress over building it all yourself would be that you don't have to start from scratch

but i think what you are saying you want is to manage everything through a flash interface in krapno ?

sam

Sam Rohn :: 360° Panoramic Photography :: Location Scout :: New York City :: www.samrohn.com

PanoPress :: WordPress Plugin for 360° Panoramas in Flash & HTML5 :: www.panopress.org

Zum Seitenanfang

Zephyr

Profi

Beiträge: 1 003

Wohnort: Netherlands

Beruf: Web developer

Dienstag, 15. Mai 2012, 10:57

There are a few ways.

One would be generating an xml with php (or serverside language of your choice) and let krpano include that. This is the fastest way for krpano to parse content. Downside is, you will run into caching, krpano will load an old xml from its cache instead of the latest from the database, there are hacks though to prevent this (time/version stamping it for example). This would just a simple mysql query

content.xml.php

Quellcode

<krpano>
<map>
<?php
$con = mysql_connect("localhost","peter","abc123");
if ($con)
  {
 
mysql_select_db("my_db", $con);

$result = mysql_query("SELECT * FROM Maps");

while($row = mysql_fetch_array($result))
  {
  echo '<spot id='".$row['id']."' />';
  }

mysql_close($con);
}
?>
</map>
</krpano>

In this example you only generate the id's, but it could be anything you have in the db. Then you have a normal krpano array. With some krpano magic/actions you can generate a map with spots.

The other way is by creating a REST API, and then communicate through ajax to place information. Plus side is, no caching, no refresh needed (instant place information), downside: more time needed to setup and requires knowledge of php and javascript.

Zum Seitenanfang

sachagriffin

Meister

Beiträge: 1 857

Beruf: Virtual Tours - Photography - Krpano developer

Dienstag, 15. Mai 2012, 13:34

Zitat

"One would be generating an xml with php (or serverside language of your choice) and let krpano include that. This is the fastest way for krpano to parse content. Downside is, you will run into caching, krpano will load an old xml from its cache instead of the latest from the database, there are hacks though to prevent this (time/version stamping it for example). "

This solves caching

Quellcode

header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-store, no-cache, must-revalidate");
header("Cache-Control: post-check=0, pre-check=0", false);
header('Content-Type: text/xml');
header("Pragma: no-cache");

KRPano Developer: Portfolio ::Gigapixel Tagging Solutions - Porfolio 2 :: Facebook :: Twitter :: reddit.com/r/VirtualTour

Zum Seitenanfang

Zephyr

Profi

Beiträge: 1 003

Wohnort: Netherlands

Beruf: Web developer

Dienstag, 15. Mai 2012, 13:47

I tried that, did not work :( My experience is, that flash caching is a whole different kind of caching. The PHP is just a mediator.

More info: http://willperone.net/Code/as3nocache.php

And even if it works, it will download a new xml every time. Version stamping is better (or date modified stamping, that looks at the age of the file).

<include url="global.xml.php?t=<?= $VERSION ?>"

or better:

index.php

	Quellcode
1 2 3 4 5	<script> var viewer = createPanoViewer({swf:"krpano.swf", xml:"tour.xml", target:"pano"}); viewer.addVariable("version", '<?= VERSION ?>'); viewer.embed(); </script>

in the xml:

	Quellcode
1	<include url="file.xml?v=%$version%" />

Zum Seitenanfang

3sfera

Fortgeschrittener

Beiträge: 249

Wohnort: Mexico City

Beruf: Virtual tours, Krpano coding, Graphic Design, Photographer, Panographer

Freitag, 18. Mai 2012, 21:15

Been away a few days and I'm glad to see all this valuable help coming from you guys, I really appreciate that *thumbsup*

Now...

-----> Sam

Thanx for all the info about wordpress, I'm really interested in learning more about it. I have heard about wordpress but till now I have been disconected from it but now that I googled as you suggested and I saw a lot of potential for future works in real state, specially with the use of plugins and templates you can get a nice site running in a suprising short time, i'ts worth a look and I'll be checking it.

Anyway returning to my case, as I want to develop a marketing tool that can be run entirelly on fullscreen mode wordpress it's not an option right now, I'm more convinced to explore PHP options as Zephyr above sugests.

-----> Zephyr

It sounds the right option for my case to create XMLs dynamically, serverside, thanks for all the technical advice about caching as well. Right now I don't have the funds for hiring somebody to do all the coding but in a future it will be the best option because I'm not that expert in PHP or Javascript as a skilled programmer, and I'll let him(her) to know this good advice of yours. By now I'll be checking this info to see how far I can get with my actual skills.

Best Regards

Luis

imagen360.com / skyvr.mx
facebook.com/Erantzcani360
facebook.com/skyvrmx

Zum Seitenanfang

RedFox

Anfänger

Beiträge: 3

Wohnort: Moscow

Freitag, 17. Januar 2014, 09:41

Hello all.
Do not quite understand how to add in xml file php elements.
What is the approximate order of actions?

Thank you for your attention.

Zum Seitenanfang

Tuur

Erleuchteter

Beiträge: 3 839

Wohnort: Netherlands

Beruf: Krpano custom coding / Virtual Tours / Photography / Musician / Recording engineer

Samstag, 18. Januar 2014, 11:33

i learned it a bit my self with just W3schools and some other tutorials and i must say it works like a charm.
I start using it more and more slowly.
It takes some time to learn though, but it is not very difficult.
So a few nights and you will be there. Maybe you have somebody around that can help you when you get stuck.
I had. But the main thing is try and error yourself… then you learn.

I would advise try to learn the basics and try to get things to work.
Then you can always, when you don't manage things yourself, hire or ask advise.

Tuur *thumbsup*

https://www.virtualtuur.com
Panimator: https://krpano.com/plugins/userplugins/panimator/#top
ToolBox: https://bit.ly/3TTnd6U
Measure in 360 photos

: https://pame.virtualtuur.com
Moving Hotspots V2: https://krpano.com/plugins/userplugins/movinghotspots/#top
Donations
https://bit.ly/3NnpynC

Zum Seitenanfang

RedFox

Anfänger

Beiträge: 3

Wohnort: Moscow

Mittwoch, 22. Januar 2014, 09:45

Hello all!
Somebody please tell me ...
This works:

	Quellcode
1	echo "<hotspot name="$row[0]" url="$row[1]" ath="$row[2]" atv="$row[3]" edge="$row[4]" visible="$row[5]" />";

And this does not work:

	Quellcode
1	echo '<hotspot name='".$row['name']." ' url='".$row['url']." 'ath='".$row['ath']." 'atv='".$row['atv']." 'edge='".$row['edge']." 'visible='".$row['visible']." ' />';