Hey Guys I’m creating an database using PHP/MySQL… I need to get output in table format with only names and if i link on an link i need to get an entire info about that particular entry… I posting my code below…
for html page first
FOR HTML PAGE
<b><h1><a href="#">Mango</a></h1><br/></b>
<p><h2>Database on Mangifera indica</h2></p>
</div>
<div class="fl_right">
</div>
<br class="clear" />
<li><a href="gallery.html"><b>TN Mango </b> </a></li>
<li><a href="contact.html"><b>Contact</b> </a>
<ul></ul>
</li>
Morphological Traits Search Form
Search by Variety Name
Search by Fruit Season Early Season Mid Season Mid & Late Season Late Season
Search by Fruit Weight(g) 150g to 200g 200g to 250g 250g to 300g 300g to 350g
Submit Reset
For PHP page…
<?php include "header.php"; include "content.php"; include "connect.php"; $term = @$_GET['term']; $value= @$_GET['name']; $range1 = @$_GET['ht']; $range2= @$_GET['ht2']; $fw= @$_GET['Season']; $w= @$_GET['weight']; if($value=="") { echo ""; echo "
Please Enter either Variety Name or Value to Search
"; } elseif($value=="name") { echo"
Variety Details
"; $sql = mysql_query("select * from morphological_characters where Varieties like '%$term%'"); echo"| "; echo "Variety Name "; echo " | "; echo $n; echo" |
| "; echo "Tree Character | "; echo $tc; echo" |
| "; echo "Bearing Habit | "; echo $b; echo" |
| "; echo "Season | "; echo $s; echo" |
| "; echo "No of inflorescence/Sq.m | "; echo $inf; echo" |
| "; echo "Percentage of hermaphrodite flower(%) | "; echo $hf; echo" |
| "; echo "Fruit set percentage(%) | "; echo $fsp; echo" |
| "; echo "Number of fruits/tree | "; echo $f; echo" |
| "; echo "Fruit Weight (g) | "; echo $fw; echo" |
| "; echo " Yield (Kg/Tree) | "; echo $y; } echo" |
"; } elseif($value=="range") { if($fw=="1") { $sql1=mysql_query("SELECT * FROM morphological_characters WHERE Season like '%Early Season%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($fw=="2") { $sql2=mysql_query("SELECT * FROM morphological_characters WHERE Season like '%Mid Season%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($fw=="3") { $sql3=mysql_query("SELECT * FROM morphological_characters WHERE Season like '%Mid & Late Season%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($fw=="4") { $sql4=mysql_query("SELECT * FROM morphological_characters WHERE Season like '%Late Season%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } } elseif($value=="weight") { if($w=="01") { $sql1=mysql_query("SELECT * FROM morphological_characters WHERE w like '%1%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($w=="02") { $sql1=mysql_query("SELECT * FROM morphological_characters WHERE w like '%2%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($w=="03") { $sql1=mysql_query("SELECT * FROM morphological_characters WHERE w like '%3%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } elseif($w=="04") { $sql1=mysql_query("SELECT * FROM morphological_characters WHERE w like '%4%' ") or die("error"); echo "
Search Results
"; echo"| "; echo "Variety Name"; echo " | "; echo $n; echo" | "; echo " Full Details |
"; } } include "footer.php"; ?>
For that new entry
<?php include "connect.php"; include "header.php"; include "connect.php"; $full = @$_GET['$n']; { echo"Variety Details
"; $sql = mysql_query("select * from morphological_characters where Varieties like '%$full%'"); echo"| "; echo "Variety Name "; echo " | "; echo $n; echo" |
| "; echo "Tree Character | "; echo $tc; echo" |
| "; echo "Bearing Habit | "; echo $b; echo" |
| "; echo "Season | "; echo $s; echo" |
| "; echo "No of inflorescence/Sq.m | "; echo $inf; echo" |
| "; echo "Percentage of hermaphrodite flower(%) | "; echo $hf; echo" |
| "; echo "Fruit set percentage(%) | "; echo $fsp; echo" |
| "; echo "Number of fruits/tree | "; echo $f; echo" |
| "; echo "Fruit Weight (g) | "; echo $fw; echo" |
| "; echo " Yield (Kg/Tree) | "; echo $y; } echo" |
"; echo ""; include"footer.php"; ?>
Pls Correct my errors and help me guys…
Thanks in advance…