Créer un compte
Connexion

Signatures pour forumsImages perso pour forums (avatar)UserbarTextes stylés (Pseudo)Générateur de Pense-BêteEffets et filtres sur imageBadges Web 2.0Titres Glitters animésRedimention d'images gifs animéesBoutons de partage bookmark
Vous êtes ici: Support du Web > Forum > Sites Web > PHP/MYSQL > pagination

pagination

Pour créer et répondre aux sujets, vous devez être connecté.
Pages: 1
Auteur Message
bobby
22/08/2011 à 13:07:39
bobby
Membre
 bonjour a tous j'ai téléchargé un scrip de pagination. j'ai inséré ce script dans mon code mais il m'affiche ce ci
Notice: Use of undefined constant num - assumed 'num' in C:\wamp\www\INTEK V 2.00\views\Admin\service\FormService.php on line 197

Notice: Undefined index: page in C:\wamp\www\INTEK V 2.00\views\Admin\service\FormService.php on line 202

voci le code

<?php
//on inclu la fonction qui permet de ce connecte a la base de donnee
include ('config.php');
?>

<script language="javascript" src="js/CtrlServ.js"></script>
<?php
//ici on écrit la variable qui nous permet de recupérer la ligne d'un enregistrement
if (isset($_GET['var'])) // on reccupere la variable de la ligne d'enregistrement
{
//echo $_GET['var'];
$var = $_GET['var'];
$dnn = mysql_fetch_array(mysql_query('select * from service where code_service = "'.$var.'"'));
$code_service = htmlentities($dnn['code_service'], ENT_QUOTES, 'UTF-8');
$libelle_service = htmlentities($dnn['libelle_service'], ENT_QUOTES, 'UTF-8');
}

else // Il manque des paramètres, on avertit le visiteur
{

//echo 'Il faut renseigner var!';
}

//on vérifi que c'est bien le bouton d'enregistrement qu on a clique
if(isset($_POST['enregistrer']))
{
//On verifie que le formulaire a ete envoye
if (isset ($_POST['code_service'], $_POST['libelle_service']))
{
//On enleve lechappement si get_magic_quotes_gpc est active
if(get_magic_quotes_gpc())
{
$_POST['code_service'] = stripslashes($_POST['code_service']);
$_POST['libelle_service'] = stripslashes($_POST['libelle_service']);
}
//On verifie si le code du service est moin de 6 caractere
if(strlen($_POST['code_service'])<=6)
{
//On echape les variables pour pouvoir les mettre dans une requette SQL
$code_service = mysql_real_escape_string($_POST['code_service']);
$libelle_service = mysql_real_escape_string($_POST['libelle_service']);
//On verifie sil ny a pas deja le code inscrit dans la base de donnée
$dn = mysql_num_rows(mysql_query('select * from service where code_service="'.$code_service.'" '));
if($dn==0)
{
//On enregistre les informations dans la base de donnee
if(mysql_query('insert into service (code_service, libelle_service) values ("'.$code_service.'", "'.$libelle_service.'" )'))
{
echo '<script type="text/javascript"> alert ("Enregistrement effectuer avec succes!")</script>';
unset($_GET['var']);;
}
else
{
//Sinon on dit quil y a eu une erreur
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("Une erreur est survenue lors de l enregistrement!")</script>';
}
}
else
{
//Sinon, on dit que le code est deja dans la base de donnee
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("ce code existe deja dans la base de donnee!")</script>';
unset($_GET['var']);
}
}
else
{
//Sinon, on dit que le mot de passe nest pas assez long
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("le code doit etre moin de six caractere!")</script>';
}
}

}
/*else
{
echo '<script type="text/javascript"> alert ("Vous devez cliquer sur le bouton enregistrer pour faire un enregistrement!")</script>';
}*/


//nous faisons une modification

if(isset ($_POST['modifier']))
{
if (isset ($_POST['code_service'], $_POST['libelle_service']))
{
//On enleve lechappement si get_magic_quotes_gpc est active
if(get_magic_quotes_gpc())
{
$_POST['code_service'] = stripslashes($_POST['code_service']);
$_POST['libelle_service'] = stripslashes($_POST['libelle_service']);
}
//On verifie si le code du service est moin de 6 caractere
if(strlen($_POST['code_service'])<=6)
{
//On echape les variables pour pouvoir les mettre dans une requette SQL
$code_service = mysql_real_escape_string($_POST['code_service']);
$libelle_service = mysql_real_escape_string($_POST['libelle_service']);
//On verifie sil ny a pas deja le code inscrit dans la base de donnée
$dn = mysql_num_rows(mysql_query('select * from service where code_service="'.$code_service.'" '));
//On enregistre les informations dans la base de donnee
if(mysql_query('update service set code_service = "'.$code_service.'", libelle_service = "'.$libelle_service.'" where code_service = "'.$var.'"'))
{
echo '<script type="text/javascript"> alert ("Modification effectuer avec succes!")</script>';
unset($_GET['var']);
}

else
{
//Sinon on dit quil y a eu une erreur
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("Une erreur est survenue lors de la modificationt!")</script>';
}
}
else
{
//Sinon, on dit que le mot de passe nest pas assez long
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("le code doit etre moin de six caractere!")</script>';
}
}

}


if(isset ($_POST['supprimer']))
{
//On echape les variables pour pouvoir les mettre dans une requette SQL
$code_service = mysql_real_escape_string($_POST['code_service']);
$libelle_service = mysql_real_escape_string($_POST['libelle_service']);
//On enregistre les informations dans la base de donnee
if(mysql_query('delete from service where code_service = "'.$code_service.'" '))
{
unset($_GET['var']);
}
else
{
//Sinon on dit quil y a eu une erreur
//require "views/Admin/service/FormService.php";
echo '<script type="text/javascript"> alert ("Une erreur est survenue lors de la suppression!")</script>';
}

}


?>


<div class="content">
<form name="formulaire" action="" method="post" onsubmit="return verif_formulaire();">
<fieldset><legend><b>enregistrez un service</b></legend>
<div class="center">
<table align="center">
<tr>
<td><label for="code">Code service</label></td><td><input type="text" style="font-family:Trajan Pro" value="<?php if (isset($_GET['var'])) {echo $code_service ;
} ?>" name="code_service" id="code" /><br /></td>
</tr>
<tr>
<td><label for="libelle">Libelle service</label></td><td><input type="text" name="libelle_service" id="libelle" value="<?php if (isset($_GET['var'])) {echo $libelle_service ;
} ?>"><br /></td>
</tr>
<tr>
<td><input type="submit" value="Enregistrer" name="enregistrer" /> </td>
<td><input type="submit" value="Modifier" name="modifier"/>
<input type="submit" value="supprimer" name="supprimer" onclick="return confirm('Etes-vous sur de vouloir supprimer ?')" /> </td>
<td><input type="submit" value="voir" name="voir" /></td>
<td><input type="reset" value="reset" /></td>
</tr>
</table>
</div>
</fieldset>
</form>
</div>

<blockquote>


<?php
/*
Place code to connect to your DB here.
*/
include('config.php'); // include your code to connect to DB.

$tbl_name="service"; //your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;
//$num = "";
//$page ="FormService";

/*
First get total number of rows in data table.
If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

/* Setup vars for query. */
$targetpage = "FormService.php"; //your file name (the name of this file)
$limit = 5; //how many items to show per page
$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit; //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0

/* Get data. */
$sql = "SELECT * FROM $tbl_name order by id_service desc LIMIT $start, $limit ";
$result = mysql_query($sql);

/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1

/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$prev\">« previous</a>";
else
$pagination.= "<span class=\"disabled\">« previous</span>";

//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$counter\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=1\">1</a>";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=1\">1</a>";
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$counter\">$counter</a>";
}
}
}

//next button
if ($page < $counter - 1)
$pagination.= "<a href=index2.php?p=views/Admin/service/$targetpage&amp;page=$next\">next »</a>";
else
$pagination.= "<span class=\"disabled\">next »</span>";
$pagination.= "</div>\n";
}
?>

<table align="center">
<tr bgcolor="#0099FF" height="30">
<th>SELECT</th>
<th>N°</th>
<th>CODE</th>
<th>LIBELLE</th>
</tr>


<tr bgcolor="0099FF">
<?php

//On recupere les les codes et les libelles des services
//$req = mysql_query('select * from service order by id_service desc ');
while($dnn = mysql_fetch_array($result))
{
?>
<tr style="background-image: url(images/bluec_30p.png)">
<td></td>
<td></td>
<td style="font-weight:lighter"><?php echo"<a href=\"index2.php?p=views/Admin/service/FormService&amp;var=$dnn[code_service]\">$dnn[code_service]</a>" ?></td>
<td><?php echo $dnn['libelle_service']; ?></td>
</tr>
<?php
}
?>
<?=$pagination?>
</tr>
</table>
</blockquote>
Pages: 1