| Re: Multiple <a> Tags, Filled With MySQL DB data with PHP [message #179236 is a reply to message #179220] |
Tue, 25 September 2012 19:10   |
tom.rankin51
Messages: 17
Registered: September 2012
Karma:
|
Junior Member |
|
|
I'm way ahead of you. The code above is the minimum as far as I'm concerned - however, it's all for nothing when you consider that my error logs have absolutely nothing in them and the HTML code is exactly the same between my PHP and HTML.
This is why I'm reaching the end of my knowledge!
On Tuesday, September 25, 2012 6:43:45 PM UTC+1, (unknown) wrote:
> Hello
>
>
>
> I am trying to create two image galleries using fancybox. There is no issue doing this by manually typing out a bunch of <a> tags with the info inside, but when I attempt to code a piece of PHP to pull this data from my database, it doesn't like it and displays the images strangely.
>
>
>
> The "working" code is:
>
>
>
> <a class="fancybox" rel="1" href="/image4.jpg" title="Title 1"><img src="thumbnail.jpg"></a>
>
> <a class="fancybox" rel="1" href="/image3.jpg" title="Title 2"></a>
>
> <a class="fancybox" rel="2" href="/image2.jpg" title="Title 3"><img src="thumbnail.jpg"></a>
>
> <a class="fancybox" rel="2" href="/image1.jpg" title="Title 4"></a>
>
>
>
> This essentially groups the images by the 'rel' tag automatically, showing two thumbnails which when clicked shows the corresponding images in descending order (ie last added).
>
>
>
> In my database I have created a 'rel' field and populated it with either "1" or "2", and tried the following:
>
>
>
> <!-- START OF PHP SCRIPT (DB OPEN)-->
>
> <?
>
> include("php/dbinfo.inc.php");
>
>
>
> mysql_connect($hostname,$username,$password);
>
> @mysql_select_db($database) or die( "Unable to select database");
>
>
>
> $visuals_query=mysql_query("SELECT id, imagelink, comment, picdate, rel FROM PictureMedia ORDER BY picdate DESC");
>
>
>
> mysql_close();
>
> ?>
>
> <!-- END OF PP SCRIPT (DB OPEN) -->
>
>
>
> <?
>
> while($r=mysql_fetch_assoc($visuals_query)) {
>
> echo '<a class="fancybox" rel="'.$r["rel"].'" href="'.$r["imagelink"].'" title="'.$r["comment"].'"><img src="thumbnail.jpg"></a>';
>
> }
>
> ?>
>
>
>
> Now, I think that this should do exactly the same thing, other than showing four thumbnails obviously. What actually happens is that the first thumbnail loads the last added image in a new page, then the other three as expected but with the focus on the picture displayed by the query. It also did not show a Facebook share button when using PHP.
>
>
>
> I understand that this issue isn't all down to PHP, but may be down to the fancybox script. However, I can't post in two groups simultaneously so if my code looks correct then I can go along another route.
>
>
>
> Thanks in advance
>
> Tom
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]