modifier.php


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"></script>
    <script>

        $( document ).ready(function() {
            $( "#addUrl" ).bind( "click", function( event ) {
                $("#divUrl").append('<input type="text" name="url[]" /><br/>');
            });
        })
    </script>
</head>
<?php
$mysqli = new mysqli('localhost', 'root', '', 'base_test_modal');
if (mysqli_connect_errno()) {
    printf("Echec de la connexion: %s\n", mysqli_connect_error());
    exit();
}

$stmt = $mysqli->prepare('SELECT * FROM `modal` JOIN `client` ON `modal`.`id` = `client`.`id_text_modal` AND `modal`.`id` = ? ');
$stmt->bind_param ('i',$_GET['id']);
$stmt->execute();
//if (!$stmt->execute())
//{
//    // je fais un die et sort car je ne sais pas quoi faire d autre
//    echo ("il y a eut un probleme avec la recuperation des données. Veuillez reessayer plus tard");
//}
$stmt->bind_result($idmodal, $title,$text_modal,$iddomain,$domain,$id_text_modal );
$stmt->fetch();
//montre que le fetch a fais quelque chose !!!!
//echo $title;
//echo $id_text_modal;
while ($stmt->fetch()) {
 $tabdomain[]=$domain;
}

//il faut importer boostrap pour avoir un style???

if(empty($_POST)){


?>
<div class="container">
    <form action="http://demo.local/modifier.php" method="POST">

        TITLE MODAL: <input type="text" name="title" placeholder="<?php echo $title ?>"/><br/>
        TEXT MODAL: <textarea name="text" placeholder="<?php echo $text_modal?>"></textarea><br/>
        <?php

        foreach ($tabdomain as $url){
            //pourquoi il me manque le 1ier???
        ?>
        URL MODAL: <input type="text" name="url[]" placeholder="<?php echo $url ?>"/><br/><br/>
        <?php
        }
 ?>
        <input type="hidden" name="id" value="<?php echo $id_text_modal ?>">

        <input type="button" value="Ajouter une url" id="addUrl">

        <div id="divUrl"></div>
        <input type="submit" value="soumettre"><br/>

    </form>
</div>
<?php
} else {
  //  if (!empty($_POST['title'])) {
        $id = (int)$_POST['id'];
        // var_dump($_POST['id']);
        $stmt1 = $mysqli->prepare("UPDATE  `modal` SET `title`=?  WHERE `id` =?  ");
        // var_dump($stmt1);
        $stmt1->bind_param('si', $_POST['title'], $id);
        $stmt1->execute();
   // }else {echo "titre vide";}
  //  if (!empty($_POST['text'])) {
        $stmt2 = $mysqli->prepare("UPDATE  `modal` SET `text_modal`=? WHERE `id` =?  ");
        // var_dump($stmt2);
        $stmt2->bind_param('si', $_POST['text'], $id);
        $stmt2->execute();
   // }else {echo "texte vide";}

//    foreach ($_POST['url'] as $url){
//        if (!empty($url)) {
//            var_dump($url);
//           $stmt3 = $mysqli->prepare("UPDATE  `client` SET `domain`=?  WHERE `id_text_modal` =?  ");
////            var_dump($stmt3);
//           $stmt3->bind_param('si', $url, $id);
//            $stmt3->execute();
//        }else { echo "vide";}
//    }
//


    header("Location: http://demo.local");
}