localhost et serveur externe
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:
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> |
localhost et serveur externe
merci beaucoup pour vos réponses