PHP|Débutant :: Forums

<iframe id="resultat" src="http://www.populationmondiale.com/population/clock.php?lang=fr&aff=1&size=10&cpop=C0C0C0&cclock=CC0000">...</iframe>

<?php
$x = preg_match('(?:\d+\s?[./-]?)*personnes'm);
echo $x;
?>

while($affiche_commentaire = mysql_fetch_array($result))
 {

   echo '<tr>
   <td>'.$affiche_commentaire["id"].'</td>
   <td>'.$affiche_commentaire["pseudo"].'</td>
   <td><a href="modifier.php?id='.$affiche_commentaire["id"].'&validonclick=J4k3kk4h3K3k4j">Modifier</a></td>
   <td><a href="supprimer.php?id='.$affiche_commentaire["id"].'&validonclick=J4k3kk4h3K3k4j" onclick ="if(!confirm(\'Voulez-vous Supprimer\')) return false;">Supprimer</a></td>
   </tr>';

 }

CREATE TABLE `produits` (
  `id` int(11) NOT NULL auto_increment,
  `nocat` varchar(12) collate latin1_general_ci NOT NULL,
  `noart` varchar(12) collate latin1_general_ci NOT NULL,
  `article` varchar(66) collate latin1_general_ci NOT NULL,
  `taille` varchar(12) collate latin1_general_ci NOT NULL,
  `stock` varchar(12) collate latin1_general_ci NOT NULL,
  `prix` varchar(12) collate latin1_general_ci NOT NULL,
  `vendu` varchar(12) collate latin1_general_ci NOT NULL,
  `details` varchar(255) collate latin1_general_ci NOT NULL,
  `image` varchar(63) collate latin1_general_ci NOT NULL,
  PRIMARY KEY  (`id`),
  FULLTEXT KEY `nocat` (`nocat`),
  FULLTEXT KEY `noart` (`noart`),
  FULLTEXT KEY `article` (`article`),
  FULLTEXT KEY `taille` (`taille`),
  FULLTEXT KEY `stock` (`stock`),
  FULLTEXT KEY `prix` (`prix`),
  FULLTEXT KEY `vendu` (`vendu`),
  FULLTEXT KEY `details` (`details`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=4 ;

--
-- Dumping data for table `produits`
--

INSERT INTO `produits` (`id`, `nocat`, `noart`, `article`, `taille`, `stock`, `prix`, `vendu`, `details`, `image`) VALUES
(1, 'test', 'test', 'test', 'test', 'test', 'testtest', '', 'test', 'test.jpg'),
(2, 'test', 'test2', 'test', 'test', 'test', 'testtest', '', 'test', 'test2.jpg'),
(3, 'ametis', 'ametis', 'ametis', 'ametis', 'ametis', 'ametis', '', 'ametis', 'ametis.jpg');

    $searchercher = mysql_real_escape_string(stripcslashes(htmlspecialchars($_GET['search'],ENT_QUOTES)));

    // $reqq1 = ("SELECT * FROM produits WHERE nocat OR noart OR article OR taille OR stock OR prix OR vendu OR details LIKE '%$searchercher%' ORDER BY noart ASC LIMIT $limit_start,$pagination");
    // $reqq1 = ("SELECT * FROM produits WHERE COALESCE(nocat, '') || '~' || COALESCE(noart, '') || COALESCE(article, '') || COALESCE(taille, '') || COALESCE(stock, '') || COALESCE(prix, '') || COALESCE(vendu, '') || COALESCE(details, '') LIKE '%$searchercher%' ORDER BY noart ASC LIMIT $limit_start,$pagination");
    // $reqq1 = ("SELECT * FROM produits WHERE WS_CONCAT(nocat, noart, article, taille, stock, prix, vendu, details) LIKE '%$searchercher%' ORDER BY noart ASC LIMIT $limit_start,$pagination");

    $reqq1 = ("SELECT id,MATCH (nocat,noart,article) AGAINST ('$searchercher') FROM produits ORDER BY noart ASC LIMIT $limit_start,$pagination");

<?php
include 'produits_connect.php';
include 'produits_function.php';

chk($_GET['nocat']);
chk($_GET['search']);

if( isset($_GET['page']) && is_numeric($_GET['page']) )
    $page = $_GET['page'];
else
    $page = 1;
$pagination = 10;
$limit_start = ($page - 1) * $pagination;

$nb_total = mysql_query('SELECT COUNT(*) AS nb_total FROM produits');
$nb_total = mysql_fetch_array($nb_total);
$nb_total = $nb_total['nb_total'];

$nb_pages = ceil($nb_total / $pagination);

    $reqq = ("SELECT nocat, COUNT(nocat) AS nombre FROM produits GROUP BY nocat ORDER BY noart ASC");
    $req = mysql_query($reqq, $db);
   
    echo '<div id="onright2">';

      $i = 0;

      echo "<table><tr>";
      echo '<th style="width:130px;">Catégorie</th>';
      echo '<th style="width:5px;">Qté</th>';
      echo "</tr>";
   
    while ($data = mysql_fetch_array($req))
    {
      $bgcolor = ($i++ & 1) ? '#E8E8B1' : '#D7D77C';
   
      echo '<tr bgcolor='.$bgcolor.'>';
      echo '<td><a href="' . $_SERVER['PHP_SELF'] . '?nocat=' . mysql_real_escape_string($data['nocat']) .'">'.mysql_real_escape_string($data['nocat']).'</a></td><td>'. mysql_real_escape_string($data['nombre']) .'</td>';
      echo "</tr>";
    }
      echo "</tr></table>";
      echo '</div>';

    if($_GET['search'] != '' ) {
   
    $searchercher = mysql_real_escape_string(stripcslashes(htmlspecialchars($_GET['search'],ENT_QUOTES)));
    $reqq1 = ("SELECT * FROM produits WHERE nocat LIKE '%$searchercher%' details LIKE '%$searchercher%' ORDER BY noart ASC LIMIT $limit_start,$pagination");

    }
    else {
   
    $categorie = mysql_real_escape_string(stripcslashes(htmlspecialchars($_GET['nocat'],ENT_QUOTES)));
    $reqq1 = ("SELECT * FROM produits WHERE nocat='".$categorie."' ORDER BY noart ASC LIMIT $limit_start,$pagination");
    }

    $req1 = mysql_query($reqq1, $db);

      $i = 0;
        echo "<b><br /><center>Produits présentement disponibles</center><br /></b>";
        echo "<table><tr>";
        echo "<th>Catégorie</th>";
        echo "<th>No Art</th>";
        echo "<th>Article</th>";
        echo "<th>Taille</th>";
        echo "<th>Inventaire</th>";
        echo "<th>Prix</th>";
        echo "<th>Vendu</th>";
        echo "<th>Image</th>";
        echo "</tr>";

    while ($data = mysql_fetch_array($req1))
    {
      $bgcolor = ($i++ & 1) ? '#E8E8B1' : '#D7D77C';
      echo '<tr bgcolor='.$bgcolor.'>';
      echo '<td>' .mysql_real_escape_string($data['nocat']). '</td>';
      echo '<td>' .mysql_real_escape_string($data['noart']). '</td>';
      echo '<td>' .mysql_real_escape_string($data['article']). '</td>';
      echo '<td>' .mysql_real_escape_string($data['taille']). '</td>';
      echo '<td>' .mysql_real_escape_string($data['stock']). '</td>';
      echo '<td style="background:yellow;border-width:0.1em; border-color:red; border-style:double;"><b>' . mysql_real_escape_string($data["prix"]) . '</b></td>';
      echo '<td style="border-width:0.1em; border-color:red; border-style:double;">' . mysql_real_escape_string($data["vendu"]) . '</td>';
      echo '<td>' .mysql_real_escape_string($data['image']). '</td>';
      echo '</tr><tr>';
      echo '<td colspan="8" style="background:#F0EBD8;border:1px inset #000000;text-align:left;"><b>Détails : </b>' .mysql_real_escape_string($data['details']). '</td>';
    }
    echo "</tr></table>";
   
    mysql_free_result($req1);
   
    echo '<p class="pagination">' . pagination($page, $nb_pages) . '</p>';
       
mysql_close();

?>