Récupérer l'identifiant de la dernière insertion

Version imprimable

Bonjour,

S'il vous plaît comment récupérer l'identifiant de la dernière insertion mysqli

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
 
class RaviKoQr
{
  public $server = "localhost";
  public $user = "root";
  public $pass = "";
  public $dbname = "kalabante";
	public $conn;
  public function __construct()
  {
  	$this->conn= new mysqli($this->server,$this->user,$this->pass,$this->dbname);
  	if($this->conn->connect_error)
  	{
  		die("connection failed");
  	}
  }
 	public function insertQr($qrUname,$final,$qrimage,$qrlink)
 	{
		$sql = "INSERT INTO qrcodes(qrUsername,qrContent,qrImg,qrlink) VALUES('$qrUname','$final','$qrimage','$qrlink')";
		$query = $this->conn->query($sql); 
		return $query;
 
 
 	}
 	public function displayImg()
 	{
 		$sql = "SELECT qrimg,qrlink from qrcodes where qrimg='$qrimage'";
 
 	}
}
$meravi = new RaviKoQr();

Merci d'avance pour vos réponses!

10/10/2019, 15h42
mathieu

regardez le 1er exemple là :
https://www.php.net/manual/fr/mysqli.insert-id.php

1 pièce(s) jointe(s)

J'avais déjà consulter le manuel php et j'ai essayé ce code :

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
 
<?php 
class RaviKoQr
{
  public $server = "localhost";
  public $user = "root";
  public $pass = "";
  public $dbname = "kalabante";
	public $conn;
  public function __construct()
  {
  	$this->conn= new mysqli($this->server,$this->user,$this->pass,$this->dbname);
  	if($this->conn->connect_error)
  	{
  		die("connection failed");
  	}
  }
 	public function insertQr($qrUname,$final,$qrimage,$qrlink)
 	{
		$sql = "INSERT INTO qrcodes(qrUsername,qrContent,qrImg,qrlink) VALUES('$qrUname','$final','$qrimage','$qrlink')";
		$query = $this->conn->query($sql); 
 
		$idqrcode=$this->conn->insert_id;
 
		return $query;
 
 
 	}
 	public function displayImg()
 	{
 		$sql = "SELECT qrimg,qrlink from qrcodes where qrimg='$qrimage'";
 
 	}
}
$meravi = new RaviKoQr();

J'ai eu un message d'erreur pour récupérer l'identifiant dans un autre fichier

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
 
    <?php 
	include "meRaviQr/qrlib.php";
	include "config.php";
	if(isset($_POST['create']))
	{
		$qc =  $_POST['qrContent'];
		$qrUname = $_POST['qrUname'];
		$qrImgName = "meravi".rand();
		if($qc=="" && $qrUname=="")
		{
		  echo "<script>alert('Please Enter Your Name And Msg For QR Code');</script>";
		}
		elseif($qc=="")
		{
		  echo "<script>alert('Please Enter QR Code Msg');</script>";
		}
		elseif($qrUname=="")
		{
		  echo "<script>alert('Please Enter Your Name');</script>";
		}
		else
		{
			$dev = " ...Develop By Ravi Khadka";
			$final = $qc.$dev;
			$qrs = QRcode::png($final,"userQr/$qrImgName.png","H","3","3");
			$qrimage = $qrImgName.".png";
			$workDir = $_SERVER['HTTP_HOST'];
			$qrlink = $workDir."/qrcode".$qrImgName.".png";
			$insQr = $meravi->insertQr($qrUname,$final,$qrimage,$qrlink);
			$idqrcode=$meravi->insert_id;
			if($insQr==true)
			{
			  echo "<script>alert('Thank You $qrUname. Success Create Your QR Code'); window.location='index.php?success=$qrimage'.$idqrcode;</script>";
 
			}
			else
			{
			  echo "<script>alert('cant create QR Code');</script>";
			}
		}
	}

Message d'erreur
Pièce jointe 509041

Les fichiers sources du dépôt sont disponibles à cette adresse : https://github.com/meravi/qr-scanner-generator/

10/10/2019, 19h25
Toufik83
Salut,

Normal que tu reçois cette erreur, parce que ta classe ne gère nul part la propriété insert_id.

Ajoutes une fonction en public dans ta classe comme suite :
Code:

1 2 public function getLastInsertid(){return $this->conn->insert_id;}
puis dans la page où tu fais appel à ton objet tu mets :
Code:

1 2 $idqrcode=$meravi->getLastInsertid();

Salut j'ai ajouté la fonction à l'intérieur de la classe

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
 
<?php 
class RaviKoQr
{
	public $server = "localhost";
	public $user = "root";
	public $pass = "";
	public $dbname = "kalabante";
	public $conn;
 
	public function __construct()
	{
		$this->conn= new mysqli($this->server,$this->user,$this->pass,$this->dbname);
		if($this->conn->connect_error)
		{
			die("connection failed");
		}
	}
 	public function insertQr($qrUname,$final,$qrimage,$qrlink)
 	{
		$sql = "INSERT INTO qrcodes(qrUsername,qrContent,qrImg,qrlink) VALUES('$qrUname','$final','$qrimage','$qrlink')";
		$query = $this->conn->query($sql); 
		return $query;
 
 	}
 
	public function getLastInsertid(){
		return $this->conn->insert_id;
	} 
 
 
 	public function displayImg()
 	{
 		$sql = "SELECT qrimg,qrlink from qrcodes where qrimg='$qrimage'";
 
 	}
}
$meravi = new RaviKoQr();

Et j'ai fais l'appel

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
 
	include "meRaviQr/qrlib.php";
	include "config.php";
	if(isset($_POST['create']))
	{
		$qc =  $_POST['qrContent'];
		$qrUname = $_POST['qrUname'];
		$qrImgName = "meravi".rand();
		if($qc=="" && $qrUname=="")
		{
		  echo "<script>alert('Please Enter Your Name And Msg For QR Code');</script>";
		}
		elseif($qc=="")
		{
		  echo "<script>alert('Please Enter QR Code Msg');</script>";
		}
		elseif($qrUname=="")
		{
		  echo "<script>alert('Please Enter Your Name');</script>";
		}
		else
		{
			$dev = " ...Develop By Ravi Khadka";
			$final = $qc.$dev;
			$qrs = QRcode::png($final,"userQr/$qrImgName.png","H","3","3");
			$qrimage = $qrImgName.".png";
			$workDir = $_SERVER['HTTP_HOST'];
			$qrlink = $workDir."/qrcode".$qrImgName.".png";
			$insQr = $meravi->insertQr($qrUname,$final,$qrimage,$qrlink);
 
			$idqrcode=$meravi->getLastInsertid();
 
			if($insQr==true)
			{
			  echo "<script>alert('Thank You $qrUname. Success Create Your QR Code'); window.location='index.php?success=$qrimage'.$idqrcode;</script>";
 
			}
			else
			{
			  echo "<script>alert('cant create QR Code');</script>";
			}
		}
	}

Et quand j'essaye de générer le qr code rien ne se passe!

11/10/2019, 12h28
Toufik83
Salut,

L'insertion se fait bien dans la base ?

Ajoutes un echo pour vérifier la valeur de $idqrcode:
Code:

1 2 3 4 5 if($insQr==true){ echo 'Dernier id inséré :'.$idqrcode; .... }