[RESOLVED] Sexy girl hyperlink

akmal1981

hi guys I hope the title captures your imagination.

I hope the following explains well :

1) I have three categories for search Property database which are location, price and type.

2) As such, there are combinations of properties depending on the search criteria.

4) The result will be shown in table form (the table will show: location, price and type) together with its pagination (because there are more than 1,000 properties in the database)

What I want to do :

Users are able to click any row in the table. When click, there will be pop up window which has further information about the property (which are map and photo or the property).

What I think, there are two ways to do it:

1) load the photo and map in phpmyadmin . In the table result, there will be 'photo' and 'map' (in addition to the existing location, price and type) in which the user can just click them to see photo and/or map;

2) click the table row, with window pop out showing the map and photos, but does this means i need to create 1,000 href or something like that ?? 😕

I am tyring to do some search from mr google but with no positive results. I hope you guys and throw a hint or two for me to search for the correct solution.

Thanks thanks thanksssssssss !!!!!!!!!!!!!!!!!!!!!!!

akmal1981

ermm i just read something like some website hosts do allow upload images in mysql. Plus some debate good vs bad make a noobie like me very very confudes already. So i guess it is option (2) ?

planetphp

You can upload a file using PHP and store the name of the file in the database.

Then when you query the property you can get the image name and display it to the user.

I'm not sure what you mean about creating 1000 href's

akmal1981

ok thanks ! will definitely check into that

kkobashi

I assume you already have a search form to let you and your users search for properties. The rest is presentation to the user.

The organization of resources is important. You need to think about your site's file hierarchy. Maybe something like this to organize things neatly and to generate with PHP the listing page:

/zipcode
  /commercial
    /parcel-100320
      photo1.jpg
      photo2.jpg
      photo3.jpg
  /residential
    /parcel-100220
      photo1.jpg
      photo2.jpg
    /parcel-120320
      photo1.jpg
      photo2.jpg
  /agriculture
    /parcel-5320
      photo1.jpg
      photo2.jpg

or maybe even more generic:

/state
  /county
    /parcel-320
      /images
        photo1.jpg
      /videos
        video1.mp3
    /parcel-453
      /images
        photo1.jpg
        photo2.jpg
      /videos
        video1.mp3
        video2.mp3

The important thing is to design the file structure and do it as generic as possible according to the data format.

Notice that I am using parcel number as a unique folder name. That way you can correlate that with what is in your database and quickly delete the folder and files underneath it if the listing is no longer relevant. You will also be able to build your image link easier with PHP as well. You don't know how many photos will be related to a property. It could be none, 2, or anything. So you need to write code to iterate through each folder to grab the filenames and then generate a bunch of img tags on the fly. Hope this makes sense.

As of using popup windows:
1) You may not get these pages indexed by Google
2) People generally hate popups and may have pop up blockers installed (imagine if user clicked on link and nothing came up)
3) Think about mobile and tablet users. With such small screen real estate, the user may get confused with windows on top of windows
4) User may click outside the popup window and bring focus to the table listing. But, the popup window now is hidden behind it. If the user does this for say, 20 items, now she has 20 popups to close - no fun.
5) You could create a hovering effect with a pop up that appears as the user moves the cursor over the link and then when the cursor is moved off the link it dissapears. but then again, items (1), (2), and (3) will still apply and it won't work for people who use touch screens because the window will appear above their finger gesture.

My suggestion is to not use popups and redirect the user to the property page instead.

And by the way, lets keep titles relevant to the question at hand. If everyone posted crappy titles like you did, noone wold want to help one another. Please change this to be on topic.

akmal1981

hey thanks for the tips everyone ...

@kobashi next thread i'll post relevant topic haha sorry. yes i already have search form (thanks to many exprts here). I am still in chinese new year mood and havent touch my website project for days now.

akmal1981

hi experts im back from chinese new year break !

So after scouring forums for solution i've amended the codes into this :

        <?php 
         while($row = mysql_fetch_array($result)) { 
         echo "<tr>"; 
		 /*echo "<td><a href='$gHref'>" . $row['Type'] . "</a></td>"; */
		 echo "<td>" . $row['Type'] . "</a></td>";
         echo "<td>" . $row['Price1'] . "</td>"; 
         echo "<td>" . $row['Location'] . "</td>"; 
		 echo '<td><a href="page1(5).html?id='.$row['id'].'">Click here for more information</a></td>'; // added code here
         echo "</tr>"; 
        } 
    ?>

I think what should happen next is (my assumption, maybe im wrong here) I must amend something in my page1(5).html something like attach each id number in the html code sheet. Example :

page1(5).html --> attach id = 1 ----> some additional information about Property A

page1(5).html --> attach id = 2 ----> some additional information about Property B

.... and so forth.

So the problem now is I hope someone can give tips/solutions on 'how to attach id into html code'. Appreciate your help :o

akmal1981

ermm something didnt add up . there cant be two page1(5).html with same name

akmal1981

so what i've got is page1(5).html?id=1 , page1(5).html?id=2 and so forth but how to display different information in each ?

bradgrafelman

You'd use the value given for the 'id' parameter in the query string and display whatever information you want associated with that value.

akmal1981

Hi Brad thanks for your response.

Phew, I think I got something like this --->>

from part of getlocationxyz.php code , amended again the line to :

         while($row = mysql_fetch_array($result)) { 
         echo "<tr>"; 
		 /*echo "<td><a href='$gHref'>" . $row['Type'] . "</a></td>"; */
		 echo "<td>" . $row['Type'] . "</td>";
         echo "<td>" . $row['Price1'] . "</td>"; 
         echo "<td>" . $row['Location'] . "</td>"; 
		 //echo '<td><a href="furtherinfo.php?id='.$row['id'].'">Click here for more information</a></td>'; // added code here
         echo("<td><a href=\"furtherinfo.php?id=" .  $row["id"] . "\" title=\"click here to learn more about ".$row["id"]."\">" . $row["Price1"] .  ", more info</a></td>"); // amended code here
		 echo "</tr>"; 
        }

in the furtherinfo.php , it will look something like this. It is still very ugly but i will add further styling, information & photos. So next i should insert photos into my database ? (im using phpmyadmin) maybe that will for other thread ... sigh ...

<?php 
$con = mysql_connect('localhost', 'root', ''); 
if (!$con) { 
    die('Could not connect: ' . mysql_error()); 
} 
mysql_select_db("a_database", $con); 




$db_name="a_database"; 
$tbl_name="property"; 

// Connect to server and select database. 

//mysql_connect("$host", "$username", "$password")or die("cannot connect"); 
//mysql_select_db("$db_name")or die("cannot select DB"); 

$member_id = $_GET['id']; 
$results = mysql_query("select * from property where id = $member_id"); 
$row = mysql_fetch_assoc($results); 

?> 
<html> 
<head> 
    <link href="style.css" type="text/css" rel="stylesheet"> 
</head> 
<body> 

<div align="center"> 
<table width="90%" cellpadding="0" cellspacing="0" border="0"> 

<tr> 
	<?php echo "<td>" . $row['Price1'] . "</td>"; ?>
</tr> 

</table> 

</div> 
</body> 
</html>

ermm .... any comments on the above ? Am i heading to the correct direction ? Many many thanks !

akmal1981

Hi guys i think this is off topic but I read something like instead of upload the images into database, save link to image in my table and put actual image in my file.

As usual I dont know what this means but will do some homework first before i ask any questions.

But anyways any inputs are always welcomed !

akmal1981

well , no more comments so i guess i closed this thread .