fonctionne très bien sur serveur externe. mais : message erreur sur serveur localhost (General error: 1364 Field 'Contenu_prog' doesn't have a default value)
( ma base comporte un champ de plus "Contenu_prog" que je ne souhaite pas utiliser dans cet exemple)
Code html : 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 [<?php require_once("../_connexion.php"); if(!empty($_POST["save_record"])) { $pdo_statement=$pdo_conn->prepare("update pages set Categorie='".addslashes($_POST['Categorie'])."', Activite='".addslashes($_POST['Activite'])."', Libel_activ='".addslashes($_POST['Libel_activ'])."', Fonction='".addslashes($_POST['Fonction'])."', Respons='".addslashes($_POST[ 'Respons' ])."' where id=".$_GET["id"]); $result = $pdo_statement->execute(); if($result) { header('location:index-liste.php'); } } $pdo_statement = $pdo_conn->prepare("SELECT * FROM pages where id=" . $_GET["id"]); $pdo_statement->execute(); $result = $pdo_statement->fetchAll(); ?> <table width="200" border="5"> <div class="demo-form-row"> <label>id: </label><br> <input type="text" name="id" class="demo-form-field" value="<?php echo $result[0]['id']; ?>" required /> </div> <div class="demo-form-row"> <label>Categorie: </label><br> <input type="text" name="Categorie" class="demo-form-field" value="<?php echo $result[0]['Categorie']; ?>" required /> </div> <div class="demo-form-row"> <label class="rouge">Activite: </label><br> <input type="text" name="Activite" class="demo-form-field" value="<?php echo $result[0]['Activite']; ?>" required /> </div> <div class="demo-form-row"> <label>Libellé activité: </label><br> <input type="text" name="Libel_activ" class="demo-form-field" value="<?php echo $result[0]['Libel_activ']; ?>" required /> </div> <div class="demo-form-row"> <label>Fonction: </label><br> <input type="text" name="Fonction" class="demo-form-field" value="<?php echo $result[0]['Fonction']; ?>" required /> </div> <div class="demo-form-row"> <label>Responsable: </label><br> <input type="text" name="Respons" class="demo-form-field" value="<?php echo $result[0]['Respons']; ?>"required /> <div class="demo-form-row"> <input name="save_record" type="submit" value="Save" class="demo-form-submit"> </div> </th> </tr> </table>
Partager