par
enzotlse » 08 oct. 2012, 19:10
Bonjour,
Voici le script d'une page web nommée "test.php" pour executer ma requete :
-------------------------------------------------------------------------------------------------
<?php require_once('Connections/connexmabase.php'); ?>
<?php
$maxRows_rs_images = 10;
$pageNum_rs_images = 0;
if (isset($_GET['pageNum_rs_images'])) {
$pageNum_rs_images = $_GET['pageNum_rs_images'];
}
$startRow_rs_images = $pageNum_rs_images * $maxRows_rs_images;
mysql_select_db($database_connexmabase, $connexmabase);
$query_rs_images = "SELECT * FROM fichier ORDER BY id ASC";
$query_limit_rs_images = sprintf("%s LIMIT %d, %d", $query_rs_images, $startRow_rs_images, $maxRows_rs_images);
$rs_images = mysql_query($query_limit_rs_images, $connexmabase) or die(mysql_error());
$row_rs_images = mysql_fetch_assoc($rs_images);
if (isset($_GET['totalRows_rs_images'])) {
$totalRows_rs_images = $_GET['totalRows_rs_images'];
} else {
$all_rs_images = mysql_query($query_rs_images);
$totalRows_rs_images = mysql_num_rows($all_rs_images);
}
$totalPages_rs_images = ceil($totalRows_rs_images/$maxRows_rs_images)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "
http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="
http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
</head>
<body>
<table border="1" cellpadding="1" cellspacing="1">
<tr>
<td>id</td>
<td>titre</td>
<td>chemin</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_images['id']; ?></td>
<td><?php echo $row_rs_images['titre']; ?></td>
<td>
<?php echo $row_rs_images['chemin']; ?></td>
<--c'est là je pense qu'il manque un truc pour avoir un lien dynamique
</tr>
<?php } while ($row_rs_images = mysql_fetch_assoc($rs_images)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($rs_images);
?>
--------------------------------------------------------
Merci
Bonjour,
Voici le script d'une page web nommée "test.php" pour executer ma requete :
-------------------------------------------------------------------------------------------------
<?php require_once('Connections/connexmabase.php'); ?>
<?php
$maxRows_rs_images = 10;
$pageNum_rs_images = 0;
if (isset($_GET['pageNum_rs_images'])) {
$pageNum_rs_images = $_GET['pageNum_rs_images'];
}
$startRow_rs_images = $pageNum_rs_images * $maxRows_rs_images;
mysql_select_db($database_connexmabase, $connexmabase);
$query_rs_images = "SELECT * FROM fichier ORDER BY id ASC";
$query_limit_rs_images = sprintf("%s LIMIT %d, %d", $query_rs_images, $startRow_rs_images, $maxRows_rs_images);
$rs_images = mysql_query($query_limit_rs_images, $connexmabase) or die(mysql_error());
$row_rs_images = mysql_fetch_assoc($rs_images);
if (isset($_GET['totalRows_rs_images'])) {
$totalRows_rs_images = $_GET['totalRows_rs_images'];
} else {
$all_rs_images = mysql_query($query_rs_images);
$totalRows_rs_images = mysql_num_rows($all_rs_images);
}
$totalPages_rs_images = ceil($totalRows_rs_images/$maxRows_rs_images)-1;
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Document sans titre</title>
</head>
<body>
<table border="1" cellpadding="1" cellspacing="1">
<tr>
<td>id</td>
<td>titre</td>
<td>chemin</td>
</tr>
<?php do { ?>
<tr>
<td><?php echo $row_rs_images['id']; ?></td>
<td><?php echo $row_rs_images['titre']; ?></td>
<td>[b]<?php echo $row_rs_images['chemin']; [/b]?></td> [b][size=85]<--c'est là je pense qu'il manque un truc pour avoir un lien dynamique[/b][/size]
</tr>
<?php } while ($row_rs_images = mysql_fetch_assoc($rs_images)); ?>
</table>
</body>
</html>
<?php
mysql_free_result($rs_images);
?>
--------------------------------------------------------
Merci
