simple Pagging in php

To pagging actually easy kenapah I say easy hold you all that you want to keep learning ... very easy and simple words are pronounced ....

first you need to prepare a table before ......

CREATE TABLE `students` (

`Nis` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,

`Name` VARCHAR (35) NOT NULL,

`Jk` VARCHAR (1) NOT NULL

) ENGINE = MYISAM;

if the table is already installed with students databse you please fill this table dengam 10 records for pagging check whether or not the road.

and you copy the following script =>

siswa.php name

<table>

      <thead>

        <tr>

     

          <th> nis </ th>

          <th> name </ th>

          <th> jk </ th>

        </ Tr>

      </ Thead>

      <tbody>

      <? Php

Mysql_connect ("localhost", "root", ""); / / local name, the user should, if there is a password on the contents

Mysql_select_db ("school") ;/ / name of the database I use the name of the school databse

                  $ Limit = 10 ;/ / create limits on how much data I use until 10 data

                $ Start = $ _GET ['terms'] * $ limit ;/ / this make take some halamanya

$ Sql ​​= "SELECT * FROM` students `limit $ start, $ limit"; / / select which tables will be displayed

                  $ Qry = mysql_query ($ sql);

                  while ($ data = mysql_fetch_array ($ qry)) {

             

                  ?>

        <tr>

          <td> <? php echo $ DataProduct [0]?> </ td>

          <td> <? php echo $ DataProduct [1]?> </ td>

          <td> <? php echo $ DataProduct [2]?> </ td>

         

       

        </ Tr>

        <? Php

                  }

                                ?>

      </ Tbody>

    </ Table>

    <p align="center"> page: <? php

  Let $ = mysql_query ("SELECT * FROM` students `"); / / reselect which tables will be displayed but must be the same as above

  $ Qty = mysql_num_rows ($ let) ;/ / count the number of data

  $ Result = $ Qty / $ limit ;/ / to know the data

  $ No = 0;

  for ($ number = 0; $ number <$ result, $ number + +) {/ / repeat the data and must not be greater than $ results

                  $ No + +;

                  echo "<a href=\"siswa.php?hal=$angka\" class=\"active\"> $ no </ a>";}

                ?> </ P>

so many of my anchovies may be useful for you thank you ..

Sources MYBLOG  Inspiration Of Dreams

Penulis : Unknown ~ Sebuah blog yang menyediakan berbagai macam informasi

Artikel simple Pagging in php ini dipublish oleh Unknown pada hari Monday, July 29, 2013. Semoga artikel ini dapat bermanfaat.Terimakasih atas kunjungan Anda silahkan tinggalkan komentar.sudah ada 2 komentar: di postingan simple Pagging in php