Connecting Tech Pros Worldwide Help | Site Map

outtputting dynamic link in xml tag using php

 
LinkBack Thread Tools Search this Thread
  #1  
Old June 30th, 2008, 07:15 PM
prashant
Guest
 
Posts: n/a
Default outtputting dynamic link in xml tag using php

hi,
i am trying to create an xml tag ref to hold link.php?id=1; or
link.php?id=2 and so on.
I want the links for all the fields(id) in the databse so that when i
call them in my html page for google maps i have the whole link.The
tag in the php page i am using is

echo 'ref="link.php?id='.$row['id'] . '"';
the tag in html is
<a href="+ref+">" +"more info"+ "</a>"

Link.php takes in the id and runs a query and displays results based
on id.

Please tell me if what i am doing is rite or wrong.Also what is the
best way for me to go ahead with this.
Thanking You,
Prashant Kalyanraman

  #2  
Old July 1st, 2008, 12:55 AM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

prashant wrote:
Quote:
hi,
i am trying to create an xml tag ref to hold link.php?id=1; or
link.php?id=2 and so on.
I want the links for all the fields(id) in the databse so that when i
call them in my html page for google maps i have the whole link.The
tag in the php page i am using is
>
echo 'ref="link.php?id='.$row['id'] . '"';
the tag in html is
<a href="+ref+">" +"more info"+ "</a>"
>
Link.php takes in the id and runs a query and displays results based
on id.
>
Please tell me if what i am doing is rite or wrong.Also what is the
best way for me to go ahead with this.
Thanking You,
Prashant Kalyanraman
>
As long as there are no security concerns with the data, it should work
fine.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  #3  
Old July 1st, 2008, 03:35 AM
prashant
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

On Jun 30, 5:45 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
prashant wrote:
Quote:
hi,
i am trying to create an xml tag ref to hold link.php?id=1; or
link.php?id=2 and so on.
I want the links for all the fields(id) in the databse so that when i
call them in my html page for google maps i have the whole link.The
tag in the php page i am using is
>
Quote:
echo 'ref="link.php?id='.$row['id'] . '"';
the tag in html is
<a href="+ref+">" +"more info"+ "</a>"
>
Quote:
Link.php takes in the id and runs a query and displays results based
on id.
>
Quote:
Please tell me if what i am doing is rite or wrong.Also what is the
best way for me to go ahead with this.
Thanking You,
Prashant Kalyanraman
>
As long as there are no security concerns with the data, it should work
fine.
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
=================
when i run the file it gives me the iutout with an errror. the two
equal to signs used in the same line r clashing.is there a work around?
  #4  
Old July 1st, 2008, 03:55 AM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

prashant wrote:
Quote:
On Jun 30, 5:45 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>prashant wrote:
Quote:
>>hi,
>>i am trying to create an xml tag ref to hold link.php?id=1; or
>>link.php?id=2 and so on.
>>I want the links for all the fields(id) in the databse so that when i
>>call them in my html page for google maps i have the whole link.The
>>tag in the php page i am using is
>>echo 'ref="link.php?id='.$row['id'] . '"';
>>the tag in html is
>><a href="+ref+">" +"more info"+ "</a>"
>>Link.php takes in the id and runs a query and displays results based
>>on id.
>>Please tell me if what i am doing is rite or wrong.Also what is the
>>best way for me to go ahead with this.
>>Thanking You,
>>Prashant Kalyanraman
>As long as there are no security concerns with the data, it should work
>fine.
>>
>
when i run the file it gives me the iutout with an errror. the two
equal to signs used in the same line r clashing.is there a work around?
>
OK, I guess I don't understand just what you're trying to do then.

when you do

echo 'ref="link.php?id='.$row['id'] . '"';

You should get on your page (see the page source!)

ref="link.php?id=42"

if $row['id'] is 42. Are you not getting this?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  #5  
Old July 1st, 2008, 08:05 AM
Geoff Berrow
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

Message-ID: <g4c9dn$7ai$1@registered.motzarella.orgfrom Jerry Stuckle
contained the following:
Quote:
>OK, I guess I don't understand just what you're trying to do then.
>
>when you do
>
>echo 'ref="link.php?id='.$row['id'] . '"';
>
>You should get on your page (see the page source!)
>
ref="link.php?id=42"
>
>if $row['id'] is 42. Are you not getting this?
Perhaps he wants :

<a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
--
Geoff Berrow 0110001001101100010000000110
001101101011011001000110111101100111001011
100110001101101111001011100111010101101011
  #6  
Old July 1st, 2008, 10:35 AM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

Geoff Berrow wrote:
Quote:
Message-ID: <g4c9dn$7ai$1@registered.motzarella.orgfrom Jerry Stuckle
contained the following:
>
Quote:
>OK, I guess I don't understand just what you're trying to do then.
>>
>when you do
>>
>echo 'ref="link.php?id='.$row['id'] . '"';
>>
>You should get on your page (see the page source!)
>>
> ref="link.php?id=42"
>>
>if $row['id'] is 42. Are you not getting this?
>
Perhaps he wants :
>
<a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
sense.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  #7  
Old July 1st, 2008, 10:55 AM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

Jerry Stuckle wrote:
Quote:
Geoff Berrow wrote:
Quote:
>Message-ID: <g4c9dn$7ai$1@registered.motzarella.orgfrom Jerry Stuckle
>contained the following:
>>
Quote:
>>OK, I guess I don't understand just what you're trying to do then.
>>>
>>when you do
>>>
>>echo 'ref="link.php?id='.$row['id'] . '"';
>>>
>>You should get on your page (see the page source!)
>>>
>> ref="link.php?id=42"
>>>
>>if $row['id'] is 42. Are you not getting this?
>>
>Perhaps he wants :
>>
><a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>
Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
sense.
>
Sorry, I mean Geoff...

Too early in the morning :-)

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  #8  
Old July 1st, 2008, 06:05 PM
prashant
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

On Jul 1, 3:45 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
Jerry Stuckle wrote:
Quote:
Geoff Berrow wrote:
Quote:
Message-ID: <g4c9dn$7a...@registered.motzarella.orgfrom Jerry Stuckle
contained the following:
>
Quote:
Quote:
>OK, I guess I don't understand just what you're trying to do then.
>
Quote:
Quote:
>when you do
>
Quote:
Quote:
>echo 'ref="link.php?id='.$row['id'] . '"';
>
Quote:
Quote:
>You should get on your page (see the page source!)
>
Quote:
Quote:
> ref="link.php?id=42"
>
Quote:
Quote:
>if $row['id'] is 42. Are you not getting this?
>
Quote:
Quote:
Perhaps he wants :
>
Quote:
Quote:
<a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>
Quote:
Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
sense.
>
Sorry, I mean Geoff...
>
Too early in the morning :-)
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
sorry for not being clearer. the error is jus b4 county. i want to
display the output in xml form.

the output i get is
XML Parsing Error: not well-formed
Location: http://localhost/pra/newphpgend.php
Line Number 1, Column 119:<markers><marker name="Newark, Memorial,
High" street="39375 Cedar Blvd." city="Newark" zip="94560"
ref="link.php?id=1"county="Alameda"

once agian my line of code is echo 'ref="link.php?id='.$row['id'] .
'"';
  #9  
Old July 1st, 2008, 06:25 PM
prashant
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

On Jul 1, 10:56 am, prashant <prashant.kalyanra...@gmail.comwrote:
Quote:
On Jul 1, 3:45 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>
>
>
Quote:
Jerry Stuckle wrote:
Quote:
Geoff Berrow wrote:
>Message-ID: <g4c9dn$7a...@registered.motzarella.orgfrom Jerry Stuckle
>contained the following:
>
Quote:
Quote:
>>OK, I guess I don't understand just what you're trying to do then.
>
Quote:
Quote:
>>when you do
>
Quote:
Quote:
>>echo 'ref="link.php?id='.$row['id'] . '"';
>
Quote:
Quote:
>>You should get on your page (see the page source!)
>
Quote:
Quote:
>> ref="link.php?id=42"
>
Quote:
Quote:
>>if $row['id'] is 42. Are you not getting this?
>
Quote:
Quote:
>Perhaps he wants :
>
Quote:
Quote:
><a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>
Quote:
Quote:
Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
sense.
>
Quote:
Sorry, I mean Geoff...
>
Quote:
Too early in the morning :-)
>
Quote:
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
Thank you for all your help but i am still stuck
>
sorry for not being clearer. the error is jus b4 county. i want to
Quote:
display the output in xml form.
>
the output i get is
XML Parsing Error: not well-formed
Location:http://localhost/pra/newphpgend.php
Line Number 1, Column 119:<markers><marker name="Newark, Memorial,
High" street="39375 Cedar Blvd." city="Newark" zip="94560"
ref="link.php?id=1"county="Alameda"
>
once agian my line of code is echo 'ref="link.php?id='.$row['id'] .
'"';
I am using php to generate ouput in xml form using mysql as my
database.Then i am calling the xml output in my html page(this html
page is for google maps).Every school present in my xml file is
displayed in the form of markers in google map. when clicked on a
marker it displays lat,long,district,county etc. I would also like to
have a link for every school i display on the map.initially i tried
making static pages and static links but it was too tedious. so i
created a page link.php which takes in id and displays the information
about school.

The dynamic link on either the php page or html page. i am trying to
make small changes to my php page to make it work since i wasnt able
to do it on tht html page.

so the code i wrote on my phph page is

echo '<markers>';

// Iterate through the rows, printing XML nodes for each
while ($row = @mysql_fetch_assoc($result)){
// ADD TO XML DOCUMENT NODE
echo '<marker ';
echo 'name="' . $row['name'] . '" ';
echo 'street="' . $row['street'] . '" ';
echo 'city="' . $row['city'] . '" ';
echo 'zip="' . $row['zip'] . '" ';
echo 'ref="link.php?id='.$row['id'] . '"';
echo 'county="' . $row['county'] . '" ';
echo 'earthquake="' . $row['earthquake'] . '" ';
echo 'lat="' . $row['lat'] . '" ';
echo 'lng="' . $row['lng'] . '" ';
echo 'type="' . $row['type'] . '" ';
echo '/>';

}
// End XML file
echo '</markers>';

?>
with other corresponding information on top.without the echo ref my
code works perfectly fine.

on my html page the imprtant functions i am using are

function load() {
if (GBrowserIsCompatible()) {
var map = new GMap2(document.getElementById("map"));
map.addControl(new GSmallMapControl());
map.addControl(new GMapTypeControl());
map.setCenter(new GLatLng(37.618412, -122.041893), 10);

GDownloadUrl("newphpgen.php", function(data) {
var xml = GXml.parse(data);
var markers =
xml.documentElement.getElementsByTagName("marker") ;
for (var i = 0; i < markers.length; i++) {
var name = markers[i].getAttribute("name");
var street = markers[i].getAttribute("street");
var type = markers[i].getAttribute("type");
var city = markers[i].getAttribute("city");
var zip = markers[i].getAttribute("zip");
var earthquake = markers[i].getAttribute("earthquake");
var link = markers[i].getAttribute("link");
var linkss = markers[i].getAttribute("linkss");
var point = new
GLatLng(parseFloat(markers[i].getAttribute("lat")),

parseFloat(markers[i].getAttribute("lng")));
var marker = createMarker(point, name, type,link, linkss,
city, zip, street, earthquake);
map.addOverlay(marker);
map.setMapType(G_HYBRID_TYPE);
}
function createMarker(point, name, type,link, linkss, city, zip,
street, earthquake) {
var marker = new GMarker(point, customIcons[type]);
//var html = "<b>" + name +"<br/></b>" + street + "<br/>"+ city
+"&nbsp;" + zip +"<br/><b>Earthquake: " + earthquake + "</b><br/><a
href="+link+">" +"more info"+ "</a>";


currently i am suing static link to schools but now i hav a databse of
15000 records and making a link for every field would not be feasible.
can u please tell me what would be the best solution
  #10  
Old July 1st, 2008, 07:35 PM
Geoff Berrow
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

Message-ID:
<6fddcad2-1f35-4c9b-acee-aafa1c078e8c@i36g2000prf.googlegroups.comfrom
prashant contained the following:
Quote:
>
>the output i get is
>XML Parsing Error: not well-formed
So it's an XML problem then?

--
Regards,

Geoff Berrow
  #11  
Old July 1st, 2008, 09:15 PM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

prashant wrote:
Quote:
On Jul 1, 3:45 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>Jerry Stuckle wrote:
Quote:
>>Geoff Berrow wrote:
>>>Message-ID: <g4c9dn$7a...@registered.motzarella.orgfrom Jerry Stuckle
>>>contained the following:
>>>>OK, I guess I don't understand just what you're trying to do then.
>>>>when you do
>>>>echo 'ref="link.php?id='.$row['id'] . '"';
>>>>You should get on your page (see the page source!)
>>>> ref="link.php?id=42"
>>>>if $row['id'] is 42. Are you not getting this?
>>>Perhaps he wants :
>>><a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>>Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
>>sense.
>Sorry, I mean Geoff...
>>
>Too early in the morning :-)
>>
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstuck...@attglobal.net
>==================
>
sorry for not being clearer. the error is jus b4 county. i want to
display the output in xml form.
>
the output i get is
XML Parsing Error: not well-formed
Location: http://localhost/pra/newphpgend.php
Line Number 1, Column 119:<markers><marker name="Newark, Memorial,
High" street="39375 Cedar Blvd." city="Newark" zip="94560"
ref="link.php?id=1"county="Alameda"
>
once agian my line of code is echo 'ref="link.php?id='.$row['id'] .
'"';
>
So you have an xml problem. To me it looks like you need a space before
country.

Otherwise - check an XML group with your source to determine what's
wrong with the xml itself. Then adjust your PHP code to fix it.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

  #12  
Old July 2nd, 2008, 11:35 PM
prashant
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

On Jul 1, 2:12 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
prashant wrote:
Quote:
On Jul 1, 3:45 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
Jerry Stuckle wrote:
>Geoff Berrow wrote:
>>Message-ID: <g4c9dn$7a...@registered.motzarella.orgfrom Jerry Stuckle
>>contained the following:
>>>OK, I guess I don't understand just what you're trying to do then.
>>>when you do
>>>echo 'ref="link.php?id='.$row['id'] . '"';
>>>You should get on your page (see the page source!)
>>> ref="link.php?id=42"
>>>if $row['id'] is 42. Are you not getting this?
>>Perhaps he wants :
>><a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
>sense.
Sorry, I mean Geoff...
>
Quote:
Quote:
Too early in the morning :-)
>
Quote:
Quote:
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
>
Quote:
sorry for not being clearer. the error is jus b4 county. i want to
display the output in xml form.
>
Quote:
the output i get is
XML Parsing Error: not well-formed
Location:http://localhost/pra/newphpgend.php
Line Number 1, Column 119:<markers><marker name="Newark, Memorial,
High" street="39375 Cedar Blvd." city="Newark" zip="94560"
ref="link.php?id=1"county="Alameda"
>
Quote:
once agian my line of code is echo 'ref="link.php?id='.$row['id'] .
'"';
>
So you have an xml problem. To me it looks like you need a space before
country.
>
Otherwise - check an XML group with your source to determine what's
wrong with the xml itself. Then adjust your PHP code to fix it.
>
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstuck...@attglobal.net
==================
thanx a lot for ur help i used a sql query and generated a dynamic
link using the concat command
  #13  
Old July 3rd, 2008, 03:15 AM
Jerry Stuckle
Guest
 
Posts: n/a
Default Re: outtputting dynamic link in xml tag using php

prashant wrote:
Quote:
On Jul 1, 2:12 pm, Jerry Stuckle <jstuck...@attglobal.netwrote:
Quote:
>prashant wrote:
Quote:
>>On Jul 1, 3:45 am, Jerry Stuckle <jstuck...@attglobal.netwrote:
>>>Jerry Stuckle wrote:
>>>>Geoff Berrow wrote:
>>>>>Message-ID: <g4c9dn$7a...@registered.motzarella.orgfrom Jerry Stuckle
>>>>>contained the following:
>>>>>>OK, I guess I don't understand just what you're trying to do then.
>>>>>>when you do
>>>>>>echo 'ref="link.php?id='.$row['id'] . '"';
>>>>>>You should get on your page (see the page source!)
>>>>>> ref="link.php?id=42"
>>>>>>if $row['id'] is 42. Are you not getting this?
>>>>>Perhaps he wants :
>>>>><a href="link.php?id=<?php echo $row['id']; ?>">more info</a>
>>>>Coule be, Jeff. I wish I knew. The code he has doesn't make a lot of
>>>>sense.
>>>Sorry, I mean Geoff...
>>>Too early in the morning :-)
>>>--
>>>==================
>>>Remove the "x" from my email address
>>>Jerry Stuckle
>>>JDS Computer Training Corp.
>>>jstuck...@attglobal.net
>>>==================
>>sorry for not being clearer. the error is jus b4 county. i want to
>>display the output in xml form.
>>the output i get is
>>XML Parsing Error: not well-formed
>>Location:http://localhost/pra/newphpgend.php
>>Line Number 1, Column 119:<markers><marker name="Newark, Memorial,
>>High" street="39375 Cedar Blvd." city="Newark" zip="94560"
>>ref="link.php?id=1"county="Alameda"
>>once agian my line of code is echo 'ref="link.php?id='.$row['id'] .
>>'"';
>So you have an xml problem. To me it looks like you need a space before
>country.
>>
>Otherwise - check an XML group with your source to determine what's
>wrong with the xml itself. Then adjust your PHP code to fix it.
>>
>--
>==================
>Remove the "x" from my email address
>Jerry Stuckle
>JDS Computer Training Corp.
>jstuck...@attglobal.net
>==================
>
thanx a lot for ur help i used a sql query and generated a dynamic
link using the concat command
>
My advice still stands, no matter how you generate the link.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.