ganesh8686
-
Posts
2 -
Joined
-
Last visited
ganesh8686's Achievements
Newbie (1/5)
0
Reputation
-
It is working fine. I want to dispaly the result in table formate. The above code result is coming horizontal. I want the result would be in vertically like the below code. Please let me know if need further information. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "[url=http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd]http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd[/url]"> <?php include ("menu.php"); ?> <?php session_start(); ?> <div id="content"> <div id="primaryContentContainer"> <div id="primaryContent"> <h2>Sample Trading Area<span></span></h2> <?php mysql_connect("localhost","root","");//database connection mysql_select_db("market_codes"); $query = "SELECT * FROM allo where category='Sample TA'"; $result = mysql_query($query) or die(mysql_error()); $num=mysql_numrows($result); mysql_close(); ?> <table> <tr class="rowB"> <th>Sl No</th> <th>Description</th> <th>Outlet</th> <th>Trading Area</th> <th>Food CSI</th> <th>Reportable</th> <th>Drug CSI</th> <th>Reportable</th> <th>Mass Census</th> <th>xAOC Co</th> <th>Deca Census</th> <th>Sam's Census</th> <th>BJ's Census</th> <th>Dollar Gen Cen</th> <th>Family Dol Cen</th> <th>Fred Dol Cen</th> <th>Walmart Mass Cen</th> <th>Walmart Food Cen</th> </tr> <?php $i=0; while ($i < $num) { $t1=mysql_result ($result, $i, "sl_no"); $t2=mysql_result ($result, $i, "description"); $t3=mysql_result ($result, $i, "outlet"); $t4=mysql_result ($result, $i, "ta"); $t5=mysql_result ($result, $i, "food"); $t6=mysql_result ($result, $i, "report"); $t7=mysql_result ($result, $i, "drug"); $t8=mysql_result ($result, $i, "reportt"); $t9=mysql_result ($result, $i, "mass"); $t10=mysql_result ($result, $i, "xaoc"); $t11=mysql_result ($result, $i, "deca"); $t12=mysql_result ($result, $i, "sma_s"); $t13=mysql_result ($result, $i, "bj_s"); $t14=mysql_result ($result, $i, "dollar"); $t15=mysql_result ($result, $i, "family"); $t16=mysql_result ($result, $i, "fred"); $t17=mysql_result ($result, $i, "walmart_mass"); $t18=mysql_result ($result, $i, "walmart_food"); ?> <tr class="rowA"> <td><?php echo $t1 ?></td> <td><?php echo $t2 ?></td> <td><?php echo $t3 ?></td> <td><?php echo $t4 ?></td> <td><?php echo $t5 ?></td> <td><?php echo $t6 ?></td> <td><?php echo $t7 ?></td> <td><?php echo $t8 ?></td> <td><?php echo $t9 ?></td> <td><?php echo $t10 ?></td> <td><?php echo $t11 ?></td> <td><?php echo $t12 ?></td> <td><?php echo $t13 ?></td> <td><?php echo $t14 ?></td> <td><?php echo $t15 ?></td> <td><?php echo $t16 ?></td> <td><?php echo $t17 ?></td> <td><?php echo $t18 ?></td> </tr> <?php $i++; } ?>
-
Hi I have small search php code in this i want to display the result in vertical. i have mentioned the code below. Can anyone help me to get the result. Thanks in advance!! <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "[url=http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd]http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd[/url]"> <?php include ("menu.php"); ?> <div id="content"> <div id="primaryContentContainer"> <div id="primaryContent"> <h2>Search Results<span></span></h2> <?php //capture search term and remove spaces at its both ends if the is any $searchTerm = trim($_GET['keyname']); //check whether the name parsed is empty if($searchTerm == "") { echo "Enter key word you are searching for."; exit(); } //database connection info $host = "localhost"; //server $db = "market_codes"; //database name $user = "root"; //dabases user name $pwd = ""; //password //connecting to server and creating link to database $link = mysqli_connect($host, $user, $pwd, $db); //MYSQL search statement $query = "SELECT * FROM allo WHERE description LIKE '%$searchTerm%'"; $results = mysqli_query($link, $query); /* check whethere there were matching records in the table by counting the number of results returned */ if(mysqli_num_rows($results) >= 1) { $output = ""; while($row = mysqli_fetch_array($results)) { $output .= "Sl No: " . $row['sl_no'] . "<br />"; $output .= "Category: " . $row['category'] . "<br />"; $output .= "Description: " . $row['description'] . "<br />"; $output .= "Outlet: " . $row['outlet'] . "<br />"; $output .= "Trading Area: " . $row['ta'] . "<br />"; $output .= "Food CSI: " . $row['food'] . "<br />"; $output .= "Drug CSI: " . $row['drug'] . "<br />"; $output .= "Mass Census: " . $row['mass'] . "<br />"; $output .= "xAOC Co: " . $row['xaoc'] . "<br />"; $output .= "Deca Census: " . $row['deca'] . "<br />"; $output .= "Sam's Census: " . $row['sma_s'] . "<br />"; $output .= "BJ's Census: " . $row['bj_s'] . "<br />"; $output .= "Dollar Gen Cen: " . $row['dollar'] . "<br />"; $output .= "Family Dol Cen: " . $row['family'] . "<br />"; $output .= "Fred Dol Cen: " . $row['fred'] . "<br />"; $output .= "Walmart Mass Cen: " . $row['walmart_mass'] . "<br />"; $output .= "Walmart Food Cen: " . $row['walmart_food'] . "<br /><br />"; } echo $output; } else echo "There was no matching record for the query " . $searchTerm; ?>