Serious help needed please

Anon

I just started a project that is turning out more difficult than I thought. I have programmed a little in PHP before; a simple guestbook, and some form processing, but that's it.

I'll start by showing what I have already:

http://www.geology.ohio-state.edu/research.html

On this page, each dot on the map represents a research location. When one clicks on a dot, a little window pops up using a javascript. Right now, this window is just a place holder. But eventually I want the window to hold all the relevant info about that research site. This info won't change a whole lot, but I would like the info to be stored in a database, and then called from the database when needed. I would also like to be able to add/edit/delete info from this database using HTML forms.

Problem is, the research map is using flash, and the pop-up windows are being called using a really bad javascript(but it works!), so I'm not quite sure where and how to put the PHP/MySQL code.

Any help would be greatly appreciated..

thanx

Anon

maybe you can show all your indication window above the mouse pointer instead of below because when it is below the dot the mouse recover it :/

Anon

I have small solution which has two files
1> test.php
2> detail.php

test.php contains the links (or ur shockwave-flash thinggy)

detail.php conatins the code to pull out info from the database depending on the value of $state that was passed to it from test.php

--- test.php ----
<script>
function openwin(state)
{
desrwindow=open("detail.php?state="+state,"descrWindow","scrollbars=no,width=250, height=400")
}
</script>
</head>

-----end test.php file-----

----begin detail.php ---
Ho Ho Ho<br>
you clicked on <?echo $state; ?><br>
Merry Xmas
----end detail.php ---

see that in detail.php you have a valid $sate value and blah blah

cheers:
nilesh.

Anon

I don't know which function you use whith javascript
I use that:

function open_mini_win($url)
{
$newWin= open(
$url,
"_new",
"width=500, height=450, status=yes, toolbar=no, menubar=no, alwaysRaised=yes, dependent=yes, resizable=yes, scrollbars=yes, screenX=50, screenY=500");
return false;
}

use Php to generate the call of the function
like that:

Anon

Chris:

First follow one of the devshed.com or webmonkey.com tutorials and build a good normalized database holding all the data you want to keep on each research facility. In one of the database tables you will have a research facility id number that is unique for each facility. Using this id number, you can get all the data about a specific research facility from all the tables in your database.

Now in your jscript, you have a URL that the window.open command is using. At the end of the URL, you just need to add the research facility id for that specific facility. For example:

http://www.something.com/research/basewebpage.htm?id=4465

Then in each basewebpage window you use PHP to connect to your database and send a select query to the tables in the database to get all the data about the research facility with the id of 4465 and then use PHP/HMTL to display the data in the window.

Good Luck

Bruce

Anon

Bruce,

I think I kind of understand what you are saying. I've already created this database:

CREATE TABLE research (
research_id int(4)
unsigned
zerofill
DEFAULT'0000'
NOT NULL
auto_increment,
prof_name varchar(50),
prof_email varchar(50),
prof_field varchar(50),
research_location varchar(50),
research_date varchar(50),
research_info text,
PRIMARY KEY (research_id)
);

And I've written this administration code to insert data into the database(eventually I'll write the form code so I can input all the data via an HTML webpage):

$query="INSERT INTO research";
$query.="research_id, prof_name,";
$query.="prof_email, prof_field,";
$query.="research_location, research_date, research_info)";
$query.="value(0000, '$name', '$email', '$field', '$location', '$date', '$info')";
mysql_pconnect(localhost, "xxxx","xxxx")
or die ("Unable to connect to MySQL Server.");
mysql_select_db("research")
or die ("Unable to select Database.");
mysql_query($query)
or die ("Insert failed.");

Now I need to write the code to call up each research location via the research_id. Right?

So when the user clicks on dot X on the map, a javascript opens a new window with this URL:

http://www.something.com/research/basewebpage.htm?id=X

Am I getting this correctly?

Thanx everyone!
Chris

Anon

http://www.something.com/research/basewebpage.htm?id=X

is almost right. how about making that basewebpage.htm to basewebpage.php ; if the php can parse through htm pages, then alls well

in you basewebpage.htm just trap the $id value and fetch corresponding details from the database.

nilesh.