salut j'ai un souci.ayant php 5.5.12 je ne peut utiliser l'extension mysql. mais je ne sais pas comment utiliser mysqli_result si ca existe.regarder un peu ce code:
<html>
<head>
<meta charset="utf-7">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
<title> SPARK PROJECT </title>
<!-- Bootstrap -->
<link href="assets/css/bootstrap.min.css" rel="stylesheet">
<link href="assets/css/font-awesome.min.css" rel="stylesheet">
<!-- <link href="accueil.css" rel="stylesheet"> -->
<link href="reg.css" rel="stylesheet">
</head>
<body class="">
<!-- <nav class="navbar navbar-inverse">
<div class="container-fluid">
<div class="navbar-header">
<a class="navbar-brand" href="#"> SPARK </a>
</div>
<ul class="nav navbar-nav">
<li class=""><a href="entreprise.html"><i class="fa fa-pencil"></i> Planning </a></li> -->
<!-- <li class="dropdown" >
<a class="dropdown-toggle" data-toggle="dropdown" href="Intervention.html"> Intervention <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#"> Technicien </a></li></ul> -->
<!-- <li class=""><a href="Intervention.html"> Intervention </a></li>
<li class="">
<a class="dropdown-toggle" data-toggle="dropdown" href="client.html"> Clients <span class="caret"></span></a>
<ul class="dropdown-menu">
<li><a href="#"> Sites </a></li>
<li><a href="#"> Equipements </a></li>
</li>
</ul>
<li class="active"><a href="facturation.php"> Facturation </a></li>
</ul>
<ul class="nav navbar-nav navbar-right">
<li><a href="deconnexion.php"><span class="glyphicon glyphicon-user"></span> Deconnexion </a></li>
<li><a href="#"><span class="glyphicon glyphicon-log-in"></span> Login </a></li>
</ul> -->
<!-- <form class="navbar-form navbar-left" action="#">
<div class="form-group">
<input type="text" class="form-control" placeholder="Search">
</div>
<button type="submit" class="btn btn-default">Submit</button>
</form> -->
<!-- </div>
</nav> -->
<?php
include("includes/header.php");
include("includes/config.php");
$query="SELECT * FROM fiche ORDER BY nom ";
$result=$conn->query($query);
$num = mysqli_num_rows ($result);
$conn->close();
?>
<center>
<table border="0">
<tr>
<td class="titre">LISTE DES FICHES</td>
</tr>
</table>
<?php
if ($num > 0 ) {
$i=0;
while ($i < $num) {
$nom = mysql_result($result,$i,"nom");
$prenom = mysql_result($result,$i,"prenom");
$total = mysql_result($result,$i,"total");
$id = mysql_result($result,$i,"id");
$id = mysql_result($result,$i,"id");
?>
<table border="0"class="table" class="texte">
<tr>
<td><center><p class="texte">Mr, Mme <?php echo "$nom"; ?></center></td>
</tr>
</table>
<?php
echo "<p class=\"texte\"><b>N° :</b> $id<br>";
echo "<b>Nom :</b> $nom<br>";
echo "<b>Prenom :</b> $prenom<br>";
echo "<b>Tarif TTC :</b> $total<br>";
echo "<br><br>";
echo "</b></p>";
echo "<table border=\"0\" width=\"100%\">";
echo " <tr>";
echo " <td><p align=\"center\">";
echo " <a href=\"modif_fiche.php?id=$id\"><img border=\"0\" src=\"icones/edit.png\" width=\"48\" height=\"48\"><br>";
echo " Modifier Cette Fiche</a></td>";
echo " <td>";
echo " <td><p align=\"center\">";
echo " <a href=\"fiche.php?id=$id\"><img border=\"0\" src=\"icones/voir.png\" width=\"48\" height=\"48\"><br>";
echo " Voir La fiche</a></td>";
echo " <td>";
echo " <p align=\"center\">";
echo " <a href=\"suppr_fiche.php?id=$id\"><img border=\"0\" src=\"icones/suppr.png\" width=\"48\" height=\"48\"><br>";
echo " Supprimer Cette Fiche</a></td>";
echo " </tr>";
echo "</table>";
++$i; } } else { echo "La base de donnée est vide"; }
include("includes/footer.php");
?>
</body>
</html>
- Messages postés
- 27700
- Date d'inscription
- mercredi 22 octobre 2003
- Statut
- Modérateur
- Dernière intervention
- 27 février 2020
324En même temps c'est normal.
Tu es passé à mysqli afin de remplacer les anciennes lignes de code "mysql_ "
Il faut nécessairement repasser sur TOUT le code qui utilisait l'ancienne extension afin de le mettre à jour via les "nouvelles" fonctions mysqli.
Pour le coup, ça donnerait un truc du genre
while ($i < $num) { $nom = mysql_result($result,$i,"nom"); $prenom = mysql_result($result,$i,"prenom"); $total = mysql_result($result,$i,"total"); $id = mysql_result($result,$i,"id");A remplacer, tout simplement, par :
while ($row = $result->fetch_assoc()) { $nom =$row['nom']; $prenom = $row['prenom']; $total = $row['total']; $id = $row['id'];<html> <head> <meta charset="utf-7"> <link rel="stylesheet" href="reg.css"> </head> <body class=""> <?php include("includes/header.php"); //Get variables from includes/config.php to connect to mysql server require 'includes/config.php'; // connect to the mysql database server. $conn=new mysqli ($servername,$username,$password,$dbname); if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} //select the database // mysql_select_db($dbase) or die('Cannot select database'); //search variable = data in search box or url if(isset($_GET['search'])) { $search = $_GET['search']; } //trim whitespace from variable $search=trim($search); $search = preg_replace('/\s+/', ' ', $search); //seperate multiple keywords into array space delimited $keywords = explode(" ", $search); //Clean empty arrays so they don't get every row as result $keywords = array_diff($keywords, array("")); //Set the MySQL query if ($search == NULL or $search == '%'){ } else { for ($i=0; $i<count($keywords); $i++) { $query = "SELECT * FROM fiche " . "WHERE nom LIKE '%".$keywords[$i]."%'". " OR id LIKE '%".$keywords[$i]."%'" . " OR date LIKE '%".$keywords[$i]."%'" . " OR prenom LIKE '%".$keywords[$i]."%'" . " ORDER BY nom"; } //Store the results in a variable or die if query fails $result = $conn->query($query) ; } if ($search == NULL or $search == '%'){ } else { //Count the rows retrived $count = mysqli_num_rows($result); } echo "<body onLoad=\"self.focus();document.searchform.search.focus()\">"; echo "<center><table border=\"0\" class=\"table\">"; echo " <tr>"; echo " <td class=\"titre\">RECHERCHER</td>"; echo " </tr>"; echo "</table></center>"; echo "<table border=\"0\">"; echo " <tr>"; echo " <td><font color=\"#000000\">Vous pouvez effectuer une recherche par N°, Nom, Prénom, Date ou tout autres mots clés présent dans une fiche !</font></td>"; echo " </tr>"; echo "</table>"; echo "<br /><center><form name=\"searchform\" method=\"GET\" action=\"recherche.php\">"; echo "<input type=\"text\" name=\"search\" size=\"20\" TABINDEX=\"1\" />"; echo " <input type=\"submit\" value=\"Rechercher\" />"; echo "</form>"; //If search variable is null do nothing, else print it. if ($search == NULL) { } else { echo "Resultat de recherche pour : <b><FONT COLOR=\"blue\">"; foreach($keywords as $value) { print "$value "; } echo "</font></b>"; } echo "</center>"; //If users doesn't enter anything into search box tell them to. if ($search == NULL){ echo "<center><b><FONT COLOR=\"red\">Merci d'entrez un mots clé.</font></b><br /></center>"; } elseif ($search == '%'){ echo "<center><b><FONT COLOR=\"red\">Merci d'entrez un mots clé.</font></b><br /></center>"; //If no results are returned print it } elseif ($count <= 0){ echo "<center><b><FONT COLOR=\"red\">Aucun résultat dans la base de donnée.</font></b><br /></center>"; } else { echo "<table border=\"0\">"; echo " <tr>"; echo " <td width=\"200\"><b><font color=\"#000000\">Nom</font></td>"; echo " <td width=\"200\"><b><font color=\"#000000\">Prénom</font></td>"; echo " <td width=\"200\"><b><font color=\"#000000\">Date</font></td>"; echo " </tr>"; echo "</table></center>"; while($row = mysqli_fetch_array($result)) { echo "<center><table border=\"0\">"; echo " <tr>"; echo " <td width=\"200\"><font color=\"#000000\"><a href=\"fiche.php?id=".$row['id']." \"> ".$row['nom']."</a></font></td>"; echo " <td width=\"200\"><font color=\"#000000\"><a href=\"fiche.php?id=".$row['id']." \"> ".$row['prenom']."</a></font></td>"; echo " <td width=\"200\"><font color=\"#000000\"><a href=\"fiche.php?id=".$row['id']." \"> ".$row['date']."</a></font></td>"; echo " </tr>"; echo "</table></center>"; //end while } //end if } echo "</body>"; echo "</html></div>"; if ($search == NULL or $search == '%') { } else { //clear memory mysqli_free_result($result); } include("includes/footer.php"); ?> </body> </html>- Messages postés
- 27700
- Date d'inscription
- mercredi 22 octobre 2003
- Statut
- Modérateur
- Dernière intervention
- 27 février 2020
324if(isset($_GET['search'])) { $search = $_GET['search']; }par :
- Messages postés
- 27700
- Date d'inscription
- mercredi 22 octobre 2003
- Statut
- Modérateur
- Dernière intervention
- 27 février 2020
324(icone de roue crantée en haut, à droite du titre de ta question)