Jump to content

Archived

This topic is now archived and is closed to further replies.

vipula

pagination of search results(PHP)

Recommended Posts

can any one please change this script to display reslts in several pages if the result is more than 10 record.

[color=red]<?php
$action = $_SERVER['SCRIPT_NAME'];
?>
<?php
//if(!$_POST['search']=='result')
//{echo "<p style=' font-family: arial; color: blue; font-size: 14px;'>You are not authorized!</p>"; return false;}
//$choice=$_POST['choice'];
$name=$_POST['name'];
$link=mysql_connect("localhost", "root", "") or die("<p class='texxt'>Can't connect to server: ".mysql_error());
mysql_select_db("test",$link);
$query="SELECT * FROM saudi_journal WHERE match (FAU, TI, AU, SO, PT, DP, MESH, KW, TA, AD, ISSN, NOTE) against ('$name' in boolean mode) ORDER BY DP DESC";
$result=mysql_query($query,$link) or die("Cannot find Server: ".mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows=="0"){$search_result="<p class='error'>No Results Found</p>";}
elseif ($num_rows > 0){$search_result="<p class='error'>".$num_rows. " Articles Found</p>";}
?>[/color]<body topMargin="0" onLoad="dynAnimation()" vlink="#0000FF" alink="#0000FF" bgcolor="#fffff0"


language="Javascript1.2">
<div align="left">
<table border="0" cellPadding="0" cellSpacing="0"
height="112" width="100%">
  <tbody>
  <tr>
    <td height="112" width="994"><img border="0" src="img/x.gif" width="990" height="102"></td>
  </tr></tbody></table></div>
<div align="left">
<table border="0" cellPadding="0" cellSpacing="0" width="100%">
  <tbody>
  <tr>
    <td valign="top">
      <div align="left">
        <table border="0" cellpadding="0" cellspacing="0" width="979">
          <tr>
            <td width="312">
            </td>
            <td align="center" width="355">
              <a onMouseOver="document['fpAnimswapimgFP2'].imgRolln=document['fpAnimswapimgFP2'].src;document['fpAnimswapimgFP2'].src=document['fpAnimswapimgFP2'].lowsrc;" onMouseOut="document['fpAnimswapimgFP2'].src=document['fpAnimswapimgFP2'].imgRolln" href="javascript:void(0)">
              <img border="0" src="img/hsl1.gif" id="fpAnimswapimgFP2" name="fpAnimswapimgFP2" dynamicanimation="fpAnimswapimgFP2" lowsrc="img/HSL2.gif" width="354" height="25"></a></td>
<!-- Search Google -->
<form method=GET action=http://www.google.com/custom>
<td width="312" align="right">&nbsp;&nbsp;
<input type=hidden name=cof VALUE="AH:center;LH:36;L:http://www.nwafh.med.sa/eng/HTML/libweb/img/HSL-NWAFH.gif;LW:432;AWFID:8099ac48bde120fe;">
</td></form>
          </tr>
        </table>
      </div>
    </td></tr></tbody></table></div>
<div align="left">
<table background="img/bg2.gif" border="0" cellPadding="0" cellSpacing="0"
width="989">
  <tbody>
  <tr>
    <td width="845">
      <p align="left"><a href="Index.htm"><img border="0" src="img/Home.gif" width="161" height="31"></a><img border="0" src="img/SPACE.gif" width="10" height="10"><a href="about.htm"><img border="0"
      src="img/ABOUT.gif" width="116" height="31"></a><img border="0"
      src="img/SPACE.gif" width="10" height="10"><a href="services.htm"><img border="0"
      src="img/SERVICES.gif" width="116" height="31"></a><img border="0"
      src="img/SPACE.gif" width="10" height="10"><a href="ejournals.htm" target="_self"><img border="0" src="img/JOURNAL.gif" width="116" height="31"></a><img border="0"
      src="img/SPACE.gif" width="10" height="10"><a href="eb.htm"><img border="0"
      src="img/BOOKS.gif" width="116" height="31"></a><img border="0"
      src="img/SPACE.gif" width="10" height="10"><a href="databases.htm"><img border="0"
      src="img/DATABASE.gif" width="116" height="31"></a></p></td>
    <td width="140">
      <p align=center>&nbsp;</p></td></tr></tbody></table></div>
<div align=center>
<center>
<table border="0" cellPadding="2" cellSpacing="3" width="108%">
  <tbody>
  <tr>
    <td width="145" rowspan="2" valign="top" bgcolor="#339966">
      <p align="center"><b><font size="4">NWAFH<br>
  </font><font size="2">Health Sciences Library </font></b></p>
  <table id="table2" width="103%" border="0">
   <tr>
    <td align="left"><font color="#ffffff" size="2">About
    SaudiMedLit</font></td>
   </tr>
   <tr>
    <td align="left"><font color="#ffffff" size="2">Journal List</font></td>
   </tr>
   <tr>
    <td>
    <p align="left"><font color="#ffffff" size="2">Issues Indexed To
    Date</font></td>
   </tr>
   <tr>
    <td><font size="2">&nbsp;</font></td>
   </tr>
   <tr>
    <td>
    <p align="left" class="style20"><a href="tips1.htm" class="style21">Search Tips</a></td>
   </tr>
  </table>
  <p></td>
    <td width="900">
     
   <form name="search_form" action="display3.php" method="post">     
              <div align="center">
                <input type="hidden" name="search" value="result" />
         <b>&nbsp;<font size="4" color="#0000ff"><br>
</font><span class="style22"><font color="#0000ff">SaudiMedLit</font></span></b>
               <font size="2">   
               <font color="#008000">is a service of the Health Sciences
      Library, </font>&nbsp;</font>
     </div>
              <p align="center">
    <b>&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; SEARCH&nbsp;&nbsp;&nbsp;&nbsp; </b>
    <SELECT name="choice" size="1">
       <!-- <option value="books">Books</option> -->
      <option value="smj">Medical Journals</option>
      <!-- <option value="staffpub">Staff Publications</option> -->
           
           </SELECT>
     <b>FOR</b>
     <input name="name" />
     <input name="B1" type="button" value="Go!" onClick="search_submit()" />&nbsp;&nbsp;&nbsp;&nbsp;
              </p>
   </form>
   
   
   </td>
    <td width="1">&nbsp;</td>
  </tr>
  <tr>
    <td colspan="2" width="870">
           

[color=red]<?php


         echo '<table border="0" cellspacing="10">';
       echo '<tr>';
         echo '<td colspan="2" class="staffpub_title" align= "center"><font color="blue" size="4"> Search Results </font></td>';
       echo '</tr>';
     echo '<tr><td align="center" colspan="2"><font color="red" face="Georgia, Times New Roman, Times, serif">'.$search_result.'</font></td></tr>';
     while ($rs = mysql_fetch_array($result)){
  $TI=$rs['TI'];
  $AU=$rs['AU'];
  $FAU=$rs['FAU'];
  $SO=$rs['SO'];
  $DP=$rs['DP'];
  $PT=$rs['PT'];
  $MESH=$rs['MESH'];
  $KW=$rs['KW'];
  $TA=$rs['TA'];
  $TF=$rs['TF'];
  $EDTA=$rs['EDAT'];
  $AD=$rs['AD'];
  $ISSN=$rs['ISSN'];
  $NOTE=$rs['NOTE'];
  $EB=$rs['EB'];

       echo '<tr>';
         echo '<td width="200" align="right" valign="top"><b>Title of the Article: </b></td>';
         echo '<td align="left" valign="top">'.$TI.'</td>';
       echo '</tr>';
       echo '<tr>';
         echo '<td align="right"  valign="top"><b>Author(s)          : </b></td>';
         echo '<td align="left"  valign="top">'.$AU.'</td>';
       echo '</tr>';

       echo '<tr>';
         echo '<td align="right"  valign="top"><b>Source              :</b></td>';
         echo '<td align="left"  valign="top">'.$SO.'</td>';
       echo '</tr>';       

       echo '<tr>';
         echo '<td align="right"  valign="top"><b>Address of the Author: </b></td>';
         echo '<td align="left"  valign="top">'.$AD.'<hr></td>';


             echo '</tr>';         

              echo '<tr>';
         echo '<td colspan="2" class="staffpub_left">&nbsp;</td>';
       echo '</tr>';}

    echo '</table>';

  ?>          [/color]   

                                               
  <p>&nbsp;</p>
  <p><br />
    </p>
  <p></td>
    </tr></tbody></table>
</center></div>
              <div align=left>
              <table bgColor=#000000 border="0" cellPadding="2" cellSpacing="3" width="1010" height="41">
  <tbody>

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.