Jump to content

marquis

Members
 View Profile  See their activity

  • Posts

    41

  • Joined

  • Last visited

 Content Type 

Posts posted by marquis

    link

    in HTML/XHTML

    Posted · Edited by Jonas
    Changed [code][/code] to [codebox][/codebox] 

    <html><head><link rel="stylesheet" href="CSS.css" type="text/css" /><title>Search Results</title></head><body align="center"><div id="sidebar"><img src="images/bigdoglogo.gif" width="225"height="79"  border="0"><div id="menu"><a href="Home.html">Home</a><a href="AboutUs.html">About Us</a><a href="CMS.php">Realtor login</a><a href="newmembers.html">Member Signup</a><a href="memberlogin.html">Member's Login</a><a href="morgage.html">Mortgage Info</a><a href="contact.html">Contact Us</a></div></div></div><div id="content"></body><h1>Search Results</h1><br><br><?php$SQL = "SELECT * FROM estate ";$SQLTEST = "SELECT * FROM estate ";if($_GET["city"]) {$city=$_GET["city"];$SQL =" $SQL WHERE city='".$city."'  ";}if($_GET["state"]) {if($SQL != $SQLTEST){$state=$_GET["state"];$SQL =" $SQL AND state='".$state."'  ";}else{$state=$_GET["state"];$SQL =" $SQL WHERE state='".$state."'  ";}}if($_GET["zipcode"]) {if($SQL!=$SQLTEST){$zipcode=$_GET["zipcode"];$SQL =" $SQL AND zipcode='".$zipcode."'  ";}else{$zipcode=$_GET["zipcode"];$SQL =" $SQL WHERE zipcode='".$zipcode."'  ";}}$pricemin=$_GET["pricemin"];$pricemax=$_GET["pricemax"];if($pricemax=="1")$pricemax="99999999999999";if($_GET["pricemin"]||$pricemax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND price BETWEEN ".$pricemin." AND ".$pricemax."  ";}else{$SQL =" $SQL WHERE price BETWEEN ".$pricemin." AND ".$pricemax."  ";}}//100$bathsmin=$_GET["bathsmin"];$bathsmax=$_GET["bathsmax"];if($bathsmax="1")$bathsmax="99999999999999";if($_GET["bathsmin"]||$bathsmax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND baths BETWEEN ".$bathsmin." AND ".$bathsmax."  ";}else{$SQL =" $SQL WHERE baths BETWEEN ".$bathsmin." AND ".$bathsmax."  ";}}$bedroomsmin=$_GET["bedroomsmin"];$bedroomsmax=$_GET["bedroomsmax"];if($bedroomsmax="1")$bedroomsmax="99999999999999";if($_GET["bedroomsmin"]||$bedroomsmax) {if($SQL!=$SQLTEST){$SQL =" $SQL AND bedrooms BETWEEN ".$bedroomsmin." AND ".$bedroomsmax."  ";}else{$SQL =" $SQL WHERE bedrooms BETWEEN ".$bedroomsmin." AND ".$bedroomsmax."  ";}}if($_GET["county"]) {if($SQL!=$SQLTEST){$county=$_GET["county"];$SQL =" $SQL AND county='".$county."'  ";}else{$county=$_GET["county"];$SQL =" $SQL WHERE county='".$county."'  ";}}if($_GET["buyorlease"]) {if($SQL!=$SQLTEST){$buyorlease=$_GET["buyorlease"];$SQL =" $SQL AND buyorlease='".$buyorlease."'  ";}else{$buyorlease=$_GET["buyorlease"];$SQL =" $SQL WHERE buyorlease='".$buyorlease."'  ";}}if($_GET["typeofprop"]) {if($SQL!=$SQLTEST){$typeofprop=$_GET["typeofprop"];$SQL =" $SQL AND typeofprop='".$typeofprop."'  ";}else{$typeofprop=$_GET["typeofprop"];$SQL =" $SQL WHERE typeofprop='".$typeofprop."'  ";}}$con = mysql_connect(***********);if (!$con)  {  die('Could not connect: ' . mysql_error());  }mysql_select_db("realestate", $con);$result = mysql_query($SQL);echo "<table border='5'>  <tr>  <th>Picture</th>  <th><a href=\"resultssort.php?sort=1&SQL=$SQL\">Price</a></th>  <th><a href=\"resultssort.php?sort=2&SQL=$SQL\">Baths</a></th>  <th><a href=\"resultssort.php?sort=3&SQL=$SQL\">Bedrooms</a></th>  <th>State</th>  <th>City</th>  <th><a href=\"resultssort.php?sort=4&SQL=$SQL\">Square Feet</a></th>  </tr>";while($row = mysql_fetch_array($result))  {  $accountnum=$row['accountnum'];     echo "<tr>";  echo '<td><a href="descrip.php?accountnum='.$accountnum.'"> <img src="images/'.$row['imagename'].'" width="75" height="75"></a> </td>';  echo "<td>" . $row['price'] . "</td>";  echo "<td>" . $row['baths'] . "</td>";  echo "<td>" . $row['bedrooms'] . "</td>";  echo "<td>" . $row['state'] . "</td>";  echo "<td>" . $row['city'] . "</td>";  echo "<td>" . $row['squarefeet'] . "</td>";  echo "</tr>";	  }echo "</table>";if(mysql_num_rows($result) == 0)ECHO "<h3>NO MATCHES FOUND</h3>";mysql_close($con);?></body></html>

    link

    in HTML/XHTML

    Posted

    It worked with me too, when I used the slash (/), but I was just wondering...how did you make the search engine?
    sorry i havnt responded in a while i got grounded from the internet well i figured out that for some reason when i ftped the code to the server i was using for some reason it didnt go through. and about the search engine its nine miles of if statements if you want the code just ask

    colors in IE

    in CSS

    Posted

    in IE the hover stuff i wrote doesnt work in firefox it works fine

    /**************** Table stuff ****************/#itsthetable {	font: 12px Verdana, sans-serif;}a, a:visited {	color: white;	text-decoration: none;	display: block;}caption, th, td {	vertical-align: top;	text-align: left;}table caption, th, tfoot td {	font-weight: normal;	color: white;}table caption {	background-color: red;	padding: 8px;}table {	border-spacing: 0;	width: 650px;	background-color: #333333;}td, th {	padding: 8px;}thead th {	background-color: white;	border-bottom: 1px solid red;	color: red;}tfoot th, tfoot td {	background-color: white;	border-top: 1px solid red;	border-bottom: 15px solid red;	color: red;}tbody td, tbody th {	color: red;}tbody th a {	color: white;}tbody tr:hover td, tbody tr:hover td a, tbody tr:hover th a {	color: white;	background-color: red;}

    table row link

    in HTML/XHTML

    Posted

    im not sure if this is possible is what i want to do is have the entire row of a table be a link to a different page. i see no reason why this cant be done since you can you the action listner "hover" to highlight the row when you mouse over it

    table link

    in PHP

    Posted

    ok i didnt just put that on this form to demoralize yall with my superior programing skills. i figured that was the how you did it but for some reason its not working

    table link

    in PHP

    Posted

    ok im trying to make a table in which every row is a link to a different pagehere is my code

    mysql_select_db("realestate", $con);$result = mysql_query($SQL);echo "<table border='5'>  <tr>  <th>Picture</th>  <th>Address</th>  <th>Price</th>  <th>Baths</th>  <th>Bedrooms</th>  <th>State</th>  <th>City</th>  <th>Square Feet</th>  <th>County</th>  <th>Year Built</th>  <th>Buy or Lease</th>  </tr>";while($row = mysql_fetch_array($result))  {  $accountnum=$row['accountnum'];      echo '<a href="descrip.php?accountnum='.$accountnum.'">';   echo "<tr>";  echo '<td> <img src="images/'.$row['imagename'].'" width="75" height="75"> </td>';  echo "<td>" . $row['address'] . "</td>";  echo "<td>" . $row['price'] . "</td>";  echo "<td>" . $row['baths'] . "</td>";  echo "<td>" . $row['bedrooms'] . "</td>";  echo "<td>" . $row['state'] . "</td>";  echo "<td>" . $row['city'] . "</td>";  echo "<td>" . $row['squarefeet'] . "</td>";  echo "<td>" . $row['county'] . "</td>";  echo "<td>" . $row['yearbuilt'] . "</td>";  echo "<td>" . $row['buyorlease'] . "</td>";  echo "</tr>";    echo "</a>";  	  }echo "</table>";

    database export

    in SQL

    Posted

    ok im a couple of days im going to be reformating my hard drive basicly the only think i want to keep is my databases. basicly all i need to know is if i can export then into a cd and then after i get everything back up and running to be able to import them back onto the mysql serverforgot to tell you that im using phpmyadmin if that any help

    form validation

    in HTML/XHTML

    Posted

    Application Design (150points)• Maintains state throughsessions with and withoutcookies• Encrypts highly sensitiveuser information• Forms fields are validatedbefore submission• Conditional logic is used toqualify SQL queries beforeexecuting them• Code is reused wherepossible (through includes,templates, or classes)• Code is original and not apre-built application1-71-71-71-71-71-78-158-158-158-158-158-1516-2216-2216-2216-2216-2216-2223-2523-2523-2523-2523-2523-25Administration (70 points)• Appropriate Web-basedreports are generated• Administrator has the abilityto add, modify and deletedata through a passwordprotected Web interface1-91-910-1810-1819-2719-2728-3528-35Grammar, Spelling,Punctuation, and Usage(25 points)0(3+ errors)5(2 errors)15(1 error)25(0 errors)TOTAL TECHNICAL POINTSSUMMARY TOTALS:Judge #1 (355 points maximum)FINAL TOTAL TECHNICALPOINTS(Subtotal divided by # of judges)Judge #2 (355 points maximum)Subtotalthat looks bad it was in a pdf file so thats as good as it get unless you want the entire file

    form validation

    in HTML/XHTML

    Posted

    well yea its just there is a regial state and national levels the regional judges arnt going to know what a tag is os basicly thats out of the question until state and then i and add it then so im still going to loose the points

    fixed side bar

    in CSS

    Posted

    i need me side bar to be fix on the page it wrks fine in firefox but not in IEhere is my CSS

    /**************** Page and tag styles ****************/body{margin:0; padding:0; color:#303030; background:#fafafa url(img/bodybg.gif) top left repeat-y; font:76% Verdana,Tahoma,sans-serif;}table{background-color:#ff8080;}ul{list-style:circle; margin:15px 0 20px 0; font-size:0.9em;}li{margin:0 0 8px 25px;}a{color:#d85d5d; font-weight:bold; text-decoration:none;}a:hover{color:#505050; text-decoration:underline;}img{float:none; margin:0 15px 15px 0; padding:1px; background:#ffffff; border:0px; solid #d0d0d0; border-style:none}a img{border-color:#d85d5d;}a img:hover{background:#d85d5d; border-color:#d85d5d;}/**************** Sidebar area styles ****************/#sidebar{position:absolute; top:0; left:0; width:220px; height:100%; overflow:hidden; background:#e0e0e0 url(img/sidebarbg.gif) top right repeat-y; text-align:right;}body > #sidebar{position:fixed;}#sidebar h1{margin:20px 18px 0 5px; color:#d85d5d; font-size:1.6em; letter-spacing:-2px; text-align:right;}#sidebar h2, #sidebar h3{margin:0 20px 18px 5px; color:#808080; font-size:1.1em; font-weight:bold; letter-spacing:-1px; text-align:right;}#sidebar h3{margin:20px 18px 4px 5px; color:#606060;}#sidebar  p{margin:0 20px 18px 5px; color:#606060; font-size:0.8em;}#sidebar a{color:#808080}/**************** Navigation menu styles ****************/#menu a{display:block; width:202px; padding:5px 18px 5px 0; color:#606060; background:#e0e0e0 url(img/sidebarbg.gif) top right repeat-y; font-size:1.8em; font-weight:normal; text-decoration:none; letter-spacing:-2px;}#menu a:hover {color:#303030; background:#f0f0f0 url(img/sidebarbg.gif) top right repeat-y;}#menu a.active{padding:5px 18px 5px 0; background:#fafafa; border-top:2px solid #c0c0c0; border-bottom:2px solid #c0c0c0;}#menu a.active:hover{color:#505050; background:#fafafa;}/**************** Content area styles ****************/#content{width:520px; margin:0 0 0 240px; padding:20px 0; background:#fafafa;}#content p{margin:0 0 20px 0; line-height:1.5em;text-align:left;}#content h1{margin:0; color:#d85d5d; font-size:4em; letter-spacing:-5px; text-align:center;}#content h2{margin:0; color:#808080; font-weight:normal; font-size:2.5em; letter-spacing:-2px; text-align:center;}#content h3{clear:both; margin:30px 0 10px 0; color:#d85d5d; font-weight:normal; font-size: 2em; letter-spacing:-2px;text-align:center;}#content h4{color:#d85d5d; text-align:center;}#content h5{color:#d85d5d; text-align:center;}#content h6{color:#d85d5d; text-align:center;}

    form validation

    in HTML/XHTML

    Posted

    im doing a contest im witch we have to design a website. i have the website done and for it being my first on i though it was pretty good any how i was looking over the judges rubric and its sayed that all "forms are validated" i have no clue what that so i may be in the wrong forum but if someone could lead me in the righ direction on what that is and how to do it i would be very thankful

    sending varibles

    in PHP

    Posted

    iv post this twice in php with no responces so im posting it here to see if yall can help me$accountnum=$row['accountnum'];echo '<center>';echo '<a href="descrip.php?accountnum=$accountnum">';im trying to send a varible through to descrip.php. instead of sending the value of $accountnum is sending the physical sting "$accountnum" im not sure how to fix this

    realy basic question

    in HTML/XHTML

    Posted

    Address: <input type="text"name="Address"size="30"><br><br>i know this makes a line for the user to input text what i need to know how to do is make a box basicly like the one im typing it to make this post just not quite as big.

    finding a row a database

    in PHP

    Posted

    $con = mysql_connect("localhost","root","*******");if (!$con) { die('Could not connect: ' . mysql_error()); }mysql_select_db("realestate", $con);$result = mysql_query($SQL);while($row = mysql_fetch_array($result)) { echo '<center>'; echo '<a href="descrip.php">'; echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">'; echo '</center>'; echo '<br>'; echo '<br>'; echo "<table border='5'bgcolor='#ff8080'> <tr> <th>Address</th> <th>Price</th> <th>Baths</th> <th>Bedrooms</th> <th>State</th> <th>City</th> <th>Square Feet</th> <th>County</th> <th>Year Built</th> <th>Buy or Lease</th> </tr>"; echo "<tr>"; echo "<td>" . $row['address'] . "</td>"; echo "<td>" . $row['price'] . "</td>"; echo "<td>" . $row['baths'] . "</td>"; echo "<td>" . $row['bedrooms'] . "</td>"; echo "<td>" . $row['state'] . "</td>"; echo "<td>" . $row['city'] . "</td>"; echo "<td>" . $row['squarefeet'] . "</td>"; echo "<td>" . $row['county'] . "</td>"; echo "<td>" . $row['yearbuilt'] . "</td>"; echo "<td>" . $row['buyorlease'] . "</td>"; echo "</tr>"; echo "</table>"; echo "<br>"; echo "<br>"; }if(mysql_num_rows($result) == 0)ECHO "<h3>NO MATCHES FOUND</h3>";mysql_close($con);?>this out puts tables and a pic link for how ever many search results where found what im trying to to is have it to where when you click on the pic it take you to a new page that has a detailed description of the house. the problem is im not sure how to pick the row out of the table that corresponds to the pic that you clicked on.

    image links

    in PHP

    Posted

    that not the part im having trouble with echo '<a href="descrip.php">'; echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">';what would i add to this transfer the varible over i know that this is probly the dumbest question ever but i never realy learned html i just jumped into phpecho '<a href="descrip.php?accountnum=1">';echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">';and then $_GET["accountnum"];i think that might be it

    image links

    in PHP

    Posted

    im not sure if that would be the easyest way. what i was thinking the easyest way t do it is to sent a variblle to the description page. that varible wold contain i piece of info from the same table as the decription is coming from such as an account number and the run basicly this quieryselect * from estate where accountnum='the varible we sent through' then just echo the description.im just not sure if its possible to do that but if it is can someone tell me howso basicly the same thing a form would do with out the form

    image links

    in PHP

    Posted

    not realy sure where to put this topic pretty sure this is the right placehere is what im trying to do when you click on an image of a house i want it to take me to a new page that has a description the description is store in a database. i dont want to have to make a new page for every house in the database. if you need any more information just ask.

×
×
  • Create New...