StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>i hope my code will be helpfull :</p> <pre><code><?php //in this example : //first you have to create a database with name : blog // create table : article (id as primary key, name , content) // here we supposed that in the content you have your tags  // also i supposed the name of this file as : pagination.php //Getting the id of article: //========================= if(isset($_GET['id'])) $id_article = $_GET['id']; else $id_article = 1; //Connexion to database : //====================== $user="root"; $pass="root"; $db="blog"; $host="localhost"; $pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION; $bdd = new PDO('mysql:host='.$host.';dbname='.$db, $user, $pass, $pdo_options); $bdd->query("SET NAMES 'utf8'"); $response = $bdd->query('SELECT * FROM articles WHERE id='.$id_article); $tab_content = array(); $data = $response->fetch() echo'<div >'; $tab_content = explode('',$data['content']); $count_pages = count($tab_content); if($count_pages){ //in the case that you have somme tags : //===================================== echo $tab_content[$page]; echo '<br>'; for($i=1;$i<$count_pages;$i++) echo '<a href="./pagination.php?id='.$id_article.'&page='.$i.'">'.$i.'</a>&nbsp;&nbsp;'; } else{ //if no tags '' in your content: //=============================================== echo $data['content']; } echo '</div>'; $response->closeCursor(); ?> </code></pre>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload