Insertion d'une valeur dans une table

**KIKOU94430** · 28/12/2022, 13h49

Bonjour

Je rencontre un soucis. J'ai du me tromper quelque part mais je ne trouve pas.

en fait cette fonction n'insère pas la ligne dans la table.

La première partie du code fait un update et la seconde partie doit insérer l'enregistrement si il n'existe pas mais lorsque je l'exécute cela ne marche pas.

Pouvez vous m'aider ?

Merci par avance

Code php :

Sélectionner tout - Visualiser dans une fenêtre à part

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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
 
 		if ($get_result = Db::getInstance()->getRow($sql_record)) {
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_cdiscount='.$cdiscount_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_cdiscount'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_manomano='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_manomano'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);		
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_amazon'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);	
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_darty='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_darty'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_rakuten='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_rakuten'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_distriartisan='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_distriartisan'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_leroymerlin='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_leroymerlin'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_ubaldi='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  	        if($get_result['alignment_lock_ubaldi'] == 0){
  	        Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);			
	        }
 
  	    }
 
		  else{
 
 
  			Db::getInstance()->execute("INSERT INTO `"._DB_PREFIX_."marketrepricing` (`id_product`, `price_min_cdiscount`) VALUES (".(int)$row['id_product'].", ".$cdiscount_prix_plancher." )");
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_cdiscount='.$cdiscount_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_cdiscount='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$manomano_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_manomano='.$manomano_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_manomano='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$amazon_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_amazon='.$amazon_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_amazon='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$darty_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_darty='.$darty_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_darty='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$rakuten_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_rakuten='.$rakuten_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_rakuten='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$distriartisan_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_distriartisan='.$distriartisan_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_distriartisan='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$leroymerlin_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_leroymerlin='.$leroymerlin_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_leroymerlin='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_min_amazon='.$ubaldi_prix_plancher.'  WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET price_max_ubaldi='.$ubaldi_prix_plancher*2.5.' WHERE id_product='.$row['id_product']);
  			Db::getInstance()->execute('UPDATE '. _DB_PREFIX_ . 'marketrepricing SET forced_price_ubaldi='.$product_finalprice.'  WHERE id_product='.$row['id_product']);
 
 
		}

Insertion d'une valeur dans une table

Langage SQL

Mode arborescent

Discussions similaires

Partager

Partager