Page 1 of 1

PHP/MYSQL Echo Code Question

Posted: Wed Jan 27, 2010 8:29 pm
by mendenha

Code: Select all

If ($category == "About"){
    include("../include/about.php");
}
Else{ 
    @ $rpp;        //Records Per Page 
    @ $cps;        //Current Page Starting row number 
    @ $lps;        //Last Page Starting row number 
    @ $a;        //will be used to print the starting row number that is shown in the page 
    @ $b;         //will be used to print the ending row number that is shown in the page 
    ///////////////////////////////////////////////////////////////////////////////// 
    //Database connection 
    ///////////////////////////////////////////////////////////////////////////////// 
     include("../include/opendbconnection.php");
 
     
    ///////////////////////////////////////////////////////////////////////////////// 
    //Following IF Statement is used to make sure when the page is loaded for the 
    //first time, Current Page's Starting row number is 0, i.e. 1st row from the 
    //table is being printed. It will change as the user will click on next. 
    /////////////////////////////////////////////////////////////////////////////////    
    $alpha = $_GET['alpha'];   
    if(empty($_GET["cps"])) 
    { 
        $cps = "0"; 
    } 
    else 
    { 
        $cps = $_GET["cps"]; 
    } 
    ///////////////////////////////////////////////////////////////////////////////// 
 
    $a = $cps+1; 
 
    $rpp = "10"; 
 
    $lps = $cps - $rpp; //Calculating the starting row number for previous page 
 
    ///////////////////////////////////////////////////////////////////////////////// 
    //Following IF Statement is used to make sure whether a link to Previous page is 
    //needed or not. If the user is viewing the first set of data then the link will 
    //be disabled, if on the next set then it will carry the $lps in its link and 
    //enable the link 
    if ($cps <> 0) 
    { 
        $prv =  "<a href='menuview.php?category=$category&alpha=$alpha&cps=$lps'>Previous</a>"; 
    } 
    else    
    { 
        $prv =  "<font color='cccccc'>Previous</font>"; 
    } 
    ///////////////////////////////////////////////////////////////////////////////// 
 
    ///////////////////////////////////////////////////////////////////////////////// 
    //Following SQL Statement uses SQL_CALC_FOUND_ROWS function to calculate total 
    //number of rows found by the query excluding the limit function added at the 
    //end of the SQL statement. This is followed by second query with FOUND_ROWS() 
    //function which actually gives out the number of rows found. 
    ///////////////////////////////////////////////////////////////////////////////// 
    $alpha = $_GET['alpha'];
    If (($category == "All") AND ($alpha == "")){
    $q="Select SQL_CALC_FOUND_ROWS * from tbl_restaurantinfo ORDER BY name limit $cps, $rpp";
    }
    ElseIf (($category != "ALL") AND ($alpha == ""))
    {
    $q="Select SQL_CALC_FOUND_ROWS * from tbl_restaurantinfo WHERE category='".$category."' ORDER BY name limit $cps, $rpp";
    } 
    Else{
    $q="Select SQL_CALC_FOUND_ROWS * FROM tbl_restaurantinfo Where name Like '$alpha' ORDER BY name limit $cps, $rpp";
    }
    $rs=mysql_query($q) or die(mysql_error()); 
    $nr = mysql_num_rows($rs); //Number of rows found with LIMIT in action 
 
    $q0="Select FOUND_ROWS()"; 
    $rs0=mysql_query($q0) or die(mysql_error()); 
    $row0=mysql_fetch_array($rs0); 
    $nr0 = $row0["FOUND_ROWS()"]; //Number of rows found without LIMIT in action 
    
    ///////////////////////////////////////////////////////////////////////////////// 
    //Following IF Statement is used to determine whether the user has reached the 
    //last page of the records. For example, if we have 27 rows to print and we show 
    //10 rows per page, then on the third and the last page it will show seven rows 
    //and will say at the top that SHOWING RECORDS FROM 21 to 27. If the following 
    //validator is not used then it shows SHOWING RECORDS FROM 21 to 30. 
    /////////////////////////////////////////////////////////////////////////////////    
    if (($nr0 < 10) || ($nr < 10)) 
    { 
           $b = $nr0; 
    } 
    else 
    { 
        $b = ($cps) + $rpp; 
    } 
    ///////////////////////////////////////////////////////////////////////////////// 
    ?> 
<table class="contacts" cellspacing="0"> 
<tr><th class="contact"><? echo "$nr0 $menuheader Restaurants Found. "; ?> <? echo "Showing $a thru $b"; ?></th></tr>
 
    <?php 
    while ($row=mysql_fetch_array($rs)) 
    { 
        ///////////////////////////////////////////////////////////////////////////////// 
        //This is used to show the serial number on the page as well as to count it up 
        //so that we can get the next page's starting row number when it exits the while 
        //loop after fullfilling the above SQL criteria. 
        ///////////////////////////////////////////////////////////////////////////////// 
        $cps = $cps +1; 
 
        //$val=$row["name"]; 
        echo "<tr>";
  echo "<td class='contact'><b>" . $row['name'] . "</b>";
  echo "<br />" . $row['category'];
  echo "<br />" . $row['address'];
  echo "<br />" . $row['phone'];
  echo '<br /><a href="' . $row['menu'] . '" target="_blank">Menu</a>';
  echo '<br /><a href="' . $row['map'] . '" target="_blank">Map</a>';
  /*echo "<br /><a href=" . chr(34) . $row['review'] . chr(34) . ">Reviews</a>";*/ 
  echo '<br /><a href="' . $row['website'] . '" target="_blank">Website</a></td>';
  echo "</tr>";
        //echo "<tr><td align='center'><font face=verdana>$cps</font></td><td align='center'><font fave=verdana>$val</font></td></tr>";  
    } 
    
    echo "<tr><td align='right' class='contact'>$prv";
 
    ///////////////////////////////////////////////////////////////////////////////// 
    //Following IF Statement is used to determine whether the Next link will be 
    //enabled or disabled. If the user has reached the last page of the record, then 
    //the Next link will be disabled. 
    ///////////////////////////////////////////////////////////////////////////////// 
    if ($cps == $nr0) 
    {      
        echo "  |  <font color='CCCCCC'>Next</font>"; 
    } 
    else 
    { 
        if ($nr0 > 10) 
        { 
            echo "  |  <a href='menuview.php?category=$category&alpha=$alpha&cps=$cps&lps=$lps'>Next</a>"; 
        } 
    } 
    ///////////////////////////////////////////////////////////////////////////////// 
    ?> 
</td> 
</tr> 
</table>
<?php } ?>
In the above code is there anyway to omit the website echo if there is no website link present in the DB? It's on line 117.

Not even sure where to start on this one. Any help would be greatly appreciated.

Re: PHP/MYSQL Echo Code Question

Posted: Wed Jan 27, 2010 8:41 pm
by AbraCadaver

Code: Select all

if(!empty($row['website'])) {
    echo '<br /><a href="' . $row['website'] . '" target="_blank">Website</a>';
}
echo '</td>';
Or I guess:

Code: Select all

if($row['website'] != '') {
    echo '<br /><a href="' . $row['website'] . '" target="_blank">Website</a>';
}
echo '</td>';

Re: PHP/MYSQL Echo Code Question

Posted: Wed Jan 27, 2010 9:23 pm
by mendenha
Wow, that worked perfect. Don't know why I couldn't think of it myself :banghead: