Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

how to add link to article in database.

New Here ,
Dec 03, 2007 Dec 03, 2007
I'm trying create page that has the titles of articles from a blog, and which also links back to the page where the entire article is listed.

So far I have the first part done. I created a DIV and then inserted from the DATA tab of DreamWeaver - a dynamic table which shows the titles from my WordPress/MySql database.

The problem I have now, is how do I get those titles to become live links to the pages which host the articles.

Is there an easyway to do this with the functions built into DW so I don't have to get into code? In either case I'd appreciate your guidance on how to do this.
TOPICS
Server side applications
631
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 03, 2007 Dec 03, 2007
DezBlanco wrote:
> Is there an easyway to do this with the functions built into DW

Yes...

> so I don't
> have to get into code?

Surely you're not serious? Dreamweaver is a tool that speeds up working
with code. It's not a substitute for knowledge.

Your question is similar to asking "is there an easy way to get from A
to B, but without looking at a map?"

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 03, 2007 Dec 03, 2007
I appreciate your genius.

I guess the last time you took a bus or train from A to B, you broke out your compass and map instead of enjoying the ride. Did you ask the driver the name of every street the bus crossed, or did you simply ask, "are you going to 'B'?"

I guess most of us with decent social skills only care that we get to B. Whether you believe it or not many of us on here buy the software so that we don't have to go through the process of writing raw code.

I also figure you didn't notice that I asked how to do it in "in either case" - with code or not.

Would it have really be that difficult for you to just tell me how to fix my problem? Oh no... that would have been too much like like looking at a map.

Thank for your help.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 04, 2007 Dec 04, 2007

"DezBlanco" <webforumsuser@macromedia.com> wrote in message
news:fj257v$cf0$1@forums.macromedia.com...
> I appreciate your genius.
>
> I guess the last time you took a bus or train from A to B, you broke out
> your
> compass and map instead of enjoying the ride. Did you ask the driver the
> name
> of every street the bus crossed, or did you simply ask, "are you going to
> 'B'?"
>
>
> I guess most of us with decent social skills only care that we get to B.
> Whether you believe it or not many of us on here buy the software so that
> we
> don't have to go through the process of writing raw code.

You have been mislead/misunderstood dreamweaver's function:
as David mentioned, Dreamweaver is a tool that makes working with code
easier, but you still have to have some basic knowledge about the techniques
your using.

> I also figure you didn't notice that I asked how to do it in "in either
> case"
> - with code or not.

Code: <a href="ENTER_URL_HERE">ENTER_TITLE_HERE</a>
or use the various methods for creating links provided by dreamweaver.

Create Text-Based Links in Dreamweaver
http://www.adobepress.com/articles/article.asp?p=483787&rl=1

> Would it have really be that difficult for you to just tell me how to fix
> my
> problem? Oh no... that would have been too much like like looking at a
> map.

There's this acronym for looking at maps: RTFM
There's a button to get at your map: F1

> Thank for your help.
>
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 04, 2007 Dec 04, 2007
Thank you Joris for your help. However what you've pointed about text links I do already know and understand. Perhaps it's my fault I didn't clarify enough what it is I'm having a problem.

The titles need to have links away from to a page that has the complete article. If they were static, than I'd use ordinary html links, but my title list is dynamic, static links would not work in this case. I am working with the WordPress blog. A completely new page is being designed that will list the titles of various articles.

To this point, using the Master Detail feature of DW, I am able to create a page that lists the titles, has links, but does not link back to the page with article. What is happing is that i am able to create a list of titles that has links. But when a title is clicked, a user is taken to a page which only list that title and NOT the article. Let say I have 4 titles:
A
B
C
D
When you click on B, you land on page that ONLY has B on it, not the article page.

The actual page this happens at is: CLICK HERE

Appreciate guidance from anyone, I've looked the the DW MAP and not be able to figure out how to this correctly yet.

Thank you
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 04, 2007 Dec 04, 2007
LATEST


"DezBlanco" <webforumsuser@macromedia.com> wrote in message
news:fj3q1a$7bf$1@forums.macromedia.com...
> Thank you Joris for your help. However what you've pointed about text
> links I
> do already know and understand. Perhaps it's my fault I didn't clarify
> enough
> what it is I'm having a problem.
>
> The titles need to have links away from to a page that has the complete
> article. If they were static, than I'd use ordinary html links, but my
> title
> list is dynamic, static links would not work in this case. I am working
> with
> the WordPress blog. A completely new page is being designed that will
> list the
> titles of various articles.
>
> To this point, using the Master Detail feature of DW, I am able to create
> a
> page that lists the titles, has links, but does not link back to the page
> with
> article. What is happing is that i am able to create a list of titles
> that has
> links. But when a title is clicked, a user is taken to a page which only
> list
> that title and NOT the article. Let say I have 4 titles:
> A
> B
> C
> D
> When you click on B, you land on page that ONLY has B on it, not the
> article
> page.
>
> The actual page this happens at is:
> http://www.highpitchnoise.com/blogs/wer_mast.php
>
> Appreciate guidance from anyone, I've looked the the DW MAP and not
> be
> able to figure out how to this correctly yet.
>
> Thank you
>

<snip what="code" />

The code you pasted from the Master (list) page already shows how to create
links from database content:

<a href="wer_det.php?recordID=<?php echo $row_Recordset1['ID']; ?>"><?php
echo $row_Recordset1['post_title']; ?>  </a>

in the example I gave earlier
Code: <a href="ENTER_URL_HERE">ENTER_TITLE_HERE</a>
you'd replace ENTER_TITLE_HERE with the databinding ENTER_URL_HERE with the
page containing the full article and append an URL variable to tell that
page what record it has to load, that page should then load the appropriate
content and display it.




Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 04, 2007 Dec 04, 2007
DezBlanco wrote:
> I guess the last time you took a bus or train from A to B, you broke out your
> compass and map instead of enjoying the ride. Did you ask the driver the name
> of every street the bus crossed, or did you simply ask, "are you going to 'B'?"

Before getting on the bus, I checked the bus company's route map and
timetable, made sure that I knew where the bus stop was, and *paid* the
driver when I got on.

> Whether you believe it or not many of us on here buy the software so that we
> don't have to go through the process of writing raw code.

In that case, you have probably bought the wrong software. Dreamweaver
speeds up the process of coding, but it's not a magic wand.

> Would it have really be that difficult for you to just tell me how to fix my
> problem? Oh no... that would have been too much like like looking at a map.

You'll find that I give a lot of help in these forums, as do many other
people. Post a message in the Dreamweaver *application development*
forum saying you don't want to get into code, and you give the
impression that even if given a map, you won't use it.

However, if you're willing to use a map, here's one for you:

Basically, what you're trying to do is build what the Dreamweaver
documentation refers to as a Master/Detail set. The master is your list
of articles, the detail is each individual article.

When building the master page, you need to retrieve the primary key of
each article along with its title. Let's say it's called article_id.
Each link needs to point to the detail page (for example, detail.php),
with the article_id appended as a query string. So the link looks
something like this:

<a href="detail.php?article_id=3">Some brilliant article</a>

The detail page retrieves the value of article_id from the $_GET array,
uses it to get a recordset containing the article, and then displays the
article contents.

You build the query string in the master page by clicking the folder
icon alongside the Link field in the Property inspector, select
detail.php in the Select File dialog box, and then click the Parameters
button. This opens the Parameters dialog box. Type article_id in the
Name field, and click the lightning bolt icon to the right of the Value
field. This, in turn, opens the Dynamic Data dialog box, where you need
to select article_id from your recordset.

The effect of all this is to create code like this:

<a href="detail.php?article_id=<?php echo
$row_recordsetName['article_id']; ?>">Some brilliant article</a>

You don't actually need to get your hands dirty with code during this
process, but without understanding the underlying code, it's easy to get
lost. Rely on Dreamweaver to do everything for you, and you'll be
severely limited in what you can achieve. Take a little time to learn
about the technology you're using, and Dreamweaver becomes a great
timesaver.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 04, 2007 Dec 04, 2007
Thanks David,

I appreciate your guidance. I'm still trying to get this right. Got the links, but it's not linking to the right page yet.

Sorry about exchange, serious frustration on my part. Been dealing with a BADDD web developer screwing me around, decided I was going to do it myself. Have experience with static sites, but the dynamic concept scared me away for a long time.
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 03, 2007 Dec 03, 2007
.oO(David Powers)

>DezBlanco wrote:
>> Is there an easyway to do this with the functions built into DW
>
>Yes...
>
>> so I don't
>> have to get into code?
>
>Surely you're not serious? Dreamweaver is a tool that speeds up working
>with code. It's not a substitute for knowledge.
>
>Your question is similar to asking "is there an easy way to get from A
>to B, but without looking at a map?"

Yes - call a taxi. ;)

But then of course you would have to pay ...

Micha
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 04, 2007 Dec 04, 2007
Hi guys,

Another question for you.....

I would like to implement a system whereby someone will get a free listing
on my site IF they include a chunk of code/widget/cookie on their page. I
would collect the URL to this page at sign-up stage.

Is there a way to make it work so that, upon accessing their entry, the code
'looks up' their page (on their own website) to see if the code is there. If
so, it displays their details. If not, it returns a message like 'record not
found'?

Any help is appreciated.

Darren

DW8 / VBScript / MS Access


"DezBlanco" <webforumsuser@macromedia.com> wrote in message
news:fj1rie$2br$1@forums.macromedia.com...
> I'm trying create page that has the titles of articles from a blog, and
> which
> also links back to the page where the entire article is listed.
>
> So far I have the first part done. I created a DIV and then inserted from
> the
> DATA tab of DreamWeaver - a dynamic table which shows the titles from my
> WordPress/MySql database.
>
> The problem I have now, is how do I get those titles to become live links
> to
> the pages which host the articles.
>
> Is there an easyway to do this with the functions built into DW so I don't
> have to get into code? In either case I'd appreciate your guidance on how
> to
> do this.
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Dec 04, 2007 Dec 04, 2007
Oh crap, i've posted in the worng place! Sorry.

"Mintyman" <mintyman@ntlworld.com> wrote in message
news:fj3o9t$5l2$1@forums.macromedia.com...
> Hi guys,
>
> Another question for you.....
>
> I would like to implement a system whereby someone will get a free listing
> on my site IF they include a chunk of code/widget/cookie on their page. I
> would collect the URL to this page at sign-up stage.
>
> Is there a way to make it work so that, upon accessing their entry, the
> code 'looks up' their page (on their own website) to see if the code is
> there. If so, it displays their details. If not, it returns a message like
> 'record not found'?
>
> Any help is appreciated.
>
> Darren
>
> DW8 / VBScript / MS Access
>
>
> "DezBlanco" <webforumsuser@macromedia.com> wrote in message
> news:fj1rie$2br$1@forums.macromedia.com...
>> I'm trying create page that has the titles of articles from a blog, and
>> which
>> also links back to the page where the entire article is listed.
>>
>> So far I have the first part done. I created a DIV and then inserted
>> from the
>> DATA tab of DreamWeaver - a dynamic table which shows the titles from my
>> WordPress/MySql database.
>>
>> The problem I have now, is how do I get those titles to become live links
>> to
>> the pages which host the articles.
>>
>> Is there an easyway to do this with the functions built into DW so I
>> don't
>> have to get into code? In either case I'd appreciate your guidance on
>> how to
>> do this.
>>
>
>


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines