Passage de Mysql à Mysqli
Bonjour. En testant un applicatif de gestion scolaire , le navigateur m'indique une erreur :
Citation:
Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\Gest_Ecole\index_principal.php on line 21
Voici le fichier index_principal.php
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
| session_start();
include "config.php";
mysql_connect($gestclasse_config['param_connexion']['serveur'],$gestclasse_config['param_connexion']['user'],$gestclasse_config['param_connexion']['passe']);
@mysql_select_db($gestclasse_config['param_connexion']['base']);
if (!isset($_SESSION['language_application']))
{
$req=mysql_query("SELECT * FROM `config` WHERE parametre='langue_defaut'");
if (mysql_num_rows($req)=="")
{
$_SESSION['language_application']="fr-FR";
}
else
{
$_SESSION['language_application']=mysql_result($req,0,'valeur');
}
}
$req=mysql_query("SELECT * FROM `config` WHERE parametre='langue_defaut'");
if (mysql_num_rows($req)=="")
Pour passer de Mysql à Mysqli voila ce que j'ai fait:
session_start();
include "config.php";
//sql_connect($gestclasse_config['param_connexion']['serveur'],$gestclasse_config['param_connexion']['user'],$gestclasse_config['param_connexion']['passe']);
//n se connecte a la base de donnees
$conn=mysqli_connect($gestclasse_config['param_connexion']['serveur'],$gestclasse_config['param_connexion']['user'],$gestclasse_config['param_connexion']['passe']);
//ysql_select_db($gestclasse_config['param_connexion']['base']);
/* Vérification de la connexion */
if (mysqli_connect_errno()) {
printf("Échec de la connexion : %s\n", mysqli_connect_error());
exit();
if (!isset($_SESSION['language_application']))
{
// on crée la requete
$req="SELECT * FROM `config` WHERE parametre='langue_defaut'";
// on envoie la requête
$res = $conn->query($req);
//f (mysql_num_rows($req)=="")
if ( $row_cnt = mysqli_num_rows($res)=="");
{
$_SESSION['language_application']="fr-FR";
}
else
{
$_SESSION['language_application']=mysqli_num_rows(mysqli_result $req,0,'valeur')
}
}
$req="SELECT * FROM `config` WHERE parametre='langue_defaut'";
if mysqli_num_rows($res=="")
{
$langue_defaut="fr-FR";
}
else
{
$langue_defaut=mysqli_num_rows(mysqli_result $req,0,'valeur');
} |
