sorguya id no gönderme

20-08-2021, 23:20:22

#1

dna2727

Merhabalar ,
Bootstrap Modal ile update gerçekleştirmek istiyorum .

Listeleme işleminde Güncelleme Butonunu
<button data-id="<?=$row['id']?>" onclick="$('#dataid').val($(this).data('id')); $('#acmod').modal('show');" >click me</button>
Buradan çıkan sonucu
<input type="text" name="dataid" id="dataid" value=""/>
buraya aktarıyorum

id noyu ? yerine atamam gerek
$islem = $oku->execute(array("idisi" => "?"));

Değişkeni oluşturamadım

Yardımlarınızı rica ederim.
20-08-2021, 23:54:50

#2

QuarkChain

Soru yeterli değil. Sayfanın kaynak kodunu görebilirsek daha iyi olur.

21-08-2021, 00:18:42

QuarkChain adlı üyeden alıntı: mesajı görüntüle

Soru yeterli değil. Sayfanın kaynak kodunu görebilirsek daha iyi olur.

Merhabalar,
<button data-id="<?=$row['id']?>" onclick="$('#dataid').val($(this).data('id')); $('#acmod').modal('show');" >click me</button>
Buradan Gelen id noyu

$islem = $oku->execute(array("idisi" => "9"));

9 yazan yere aktarıp modal da veriyi getirmek istiyorum.

<table id="example" class="display nowrap" style="width:100%">
        <thead>
            <tr>
                <th>id</th>
                <th>TC No</th>
                <th>İşlem</th>
            </tr>
        </thead>
        <tbody>
            <tr>        
                <?php
$toku = $db->query("SELECT * FROM deneme ORDER BY id desc", PDO::FETCH_ASSOC);
if ( $toku->rowCount() ){
foreach( $toku as $row ){?>
                <td><?=$row['id']?></td>
                <td><?=$row['tc_no']?></td>
                <td>
                <button data-id="<?=$row['id']?>"  onclick="$('#dataid').val($(this).data('id')); $('#acmod').modal('show');" >click me</button>
                </td>
            </tr> 
        <?php
    }
}

?>
        </tbody>
    </table>

<div class="modal fade" id="acmod" tabindex="-1" role="dialog">
    
    <div class="modal-dialog">
        <div class="modal-content">

            <div class="modal-header">
                <h5 class="modal-title">Güncelle</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>

            <div class="modal-body">

                <div class="container-fluid">

                    <form id="editEvent" class="form-horizontal">
  
                     <input type="text" name="dataid" id="dataid" value=""/> 

                    <div class="row">

                        <div class="col-md-6">
<?php
$oku = $db->prepare("SELECT * FROM deneme WHERE id = :idisi");
$islem = $oku->execute(array("idisi" => "9"));
$yaz = $oku->fetch(PDO::FETCH_ASSOC);
?>  
                            <div id="edit-title-group" class="form-group">
                               <label class="control-label" for="editEventTC">Tc Numarası</label>
                                <input type="text" class="form-control" id="editEventTC" name="editEventTC" value="<?=$yaz['telefon']?>" readonly>
                                <!-- errors will go here -->
                            </div>

                        </div>

                    </div>

                </div>

            </div>

            <div class="modal-footer">
              <button type="button" class="btn btn-secondary" data-dismiss="modal">Vaz Geç</button>
              <button type="submit" class="btn btn-primary">Kayıt ET</button>
              <button type="button" class="btn btn-danger" id="deleteEvent" data-id>SiL</button>
            </div>

            </form>

        </div><!-- /.modal-content -->
    </div><!-- /.modal-dialog -->
</div><!-- /.modal -->

              </div>
            </div>
          </div>
        </div>
      </div>
    </div>
  </div>

21-08-2021, 00:21:22

#4

QuarkChain

Oraya veri ajax ile gelmeli. Birazdan lokalde örnek hazırlayıp test edip kodu paylaşacağım.
21-08-2021, 00:22:57

#5

dna2727

QuarkChain adlı üyeden alıntı: mesajı görüntüle

Oraya veri ajax ile gelmeli. Birazdan lokalde örnek hazırlayıp test edip kodu paylaşacağım.

Çok mutlu olurum hocam beklemekteyim.

21-08-2021, 01:10:35

QuarkChain

Bu kodların tamamı aynı sayfada yer alıyor.. Ben kendim testi yapabilmek için bootstrap vs dahil ettim sizin sayfanızda zaten vardır. Sadece NPRogress dahil edebilirsiniz kendi sayfanıza.

$db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$db->query('SET NAMES utf8');

if (isset($_REQUEST['action'])) {
    header('Content-type: application/json');

    switch ($_POST['action']) {
        case 'update':
            $query = $db->prepare('UPDATE deneme SET tc_no = ?, isim = ? WHERE id = ?');
            $query->bindParam(1, $_POST['editEventTC'], PDO::PARAM_STR);
            $query->bindParam(2, $_POST['isim'], PDO::PARAM_STR);
            $query->bindParam(3, $_POST['id'], PDO::PARAM_INT);
            exit(json_encode(array('status' => $query->execute())));
            break;
        case 'delete':
            $query = $db->prepare('DELETE FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])))));
            break;
        default:
            $query = $db->prepare('SELECT * FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])), 'row' => $query->fetch())));
            break;
    }
}

<link rel="stylesheet" type="text/css" href="https://unpkg.com/nprogress@0.2.0/nprogress.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<table id="example" class="display nowrap" style="width:100%">
    <thead>
        <tr>
            <th>id</th>
            <th>TC No</th>
            <th>İşlem</th>
        </tr>
    </thead>
    <tbody>
              
            <?php
            $toku = $db->query("SELECT * FROM deneme ORDER BY id desc", PDO::FETCH_ASSOC);
            if ( $toku->rowCount() ){
                foreach( $toku as $row ){?>
                     <tr id="row_<?=$row['id']?>">
                    <td><?=$row['id']?></td>
                    <td><?=$row['isim']?></td>
                    <td><?=$row['tc_no']?></td>
                    <td>
                        <button data-id="<?=$row['id']?>">click me</button>
                    </td>
                </tr>
                <?php
            }
        }

        ?>
    </tbody>
</table>

<div class="modal fade" id="acmod" tabindex="-1" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Güncelle</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <div class="container-fluid">
                    <form id="editEvent" class="form-horizontal">
                        <input type="hidden" name="action" value="update"/>
                        <input type="hidden" name="id" id="dataid" value=""/>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="isim">Ad Soyad</label>
                                    <input type="text" class="form-control" id="isim" name="isim" value="">
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="editEventTC">Tc Numarası</label>
                                    <input type="text" class="form-control" id="editEventTC" name="editEventTC" value="">
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Vaz Geç</button>
                <button type="button" class="btn btn-primary">Kayıt ET</button>
                <button type="button" class="btn btn-danger">SiL</button>
            </div>
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
<script src="https://unpkg.com/nprogress@0.2.0/nprogress.js"></script>

 $(function(){
        $(".btn-danger").click(function(event){
            event.preventDefault();
            if (confirm("Silmek istiyor musun?")) {
                NProgress.start();
                $.post("", {action: "delete", id: $("#dataid").val()}, function(json){
                    NProgress.done();
                    if (json.status) {
                        $("#row_" + $("#dataid").val()).fadeOut();
                        $("#acmod").modal("hide");
                    }
                });
            }
        });
        $(".btn-primary").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", $("form").serialize(), function(){
                NProgress.done();
                $("#acmod").modal("hide");
            });
        });
        $("button[data-id]").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", {action: "", id: $(this).data("id")}, function(json){
                NProgress.done();
                $("#isim").val(json.row.isim);
                $("#editEventTC").val(json.row.tc_no);
                $("#dataid").val(json.row.id);
                $("#acmod").modal("show");
            });
        });
    });

21-08-2021, 12:16:34

dna2727

QuarkChain adlı üyeden alıntı: mesajı görüntüle

Bu kodların tamamı aynı sayfada yer alıyor.. Ben kendim testi yapabilmek için bootstrap vs dahil ettim sizin sayfanızda zaten vardır. Sadece NPRogress dahil edebilirsiniz kendi sayfanıza.

$db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$db->query('SET NAMES utf8');

if (isset($_REQUEST['action'])) {
    header('Content-type: application/json');

    switch ($_POST['action']) {
        case 'update':
            $query = $db->prepare('UPDATE deneme SET tc_no = ?, isim = ? WHERE id = ?');
            $query->bindParam(1, $_POST['editEventTC'], PDO::PARAM_STR);
            $query->bindParam(2, $_POST['isim'], PDO::PARAM_STR);
            $query->bindParam(3, $_POST['id'], PDO::PARAM_INT);
            exit(json_encode(array('status' => $query->execute())));
            break;
        case 'delete':
            $query = $db->prepare('DELETE FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])))));
            break;
        default:
            $query = $db->prepare('SELECT * FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])), 'row' => $query->fetch())));
            break;
    }
}

<link rel="stylesheet" type="text/css" href="https://unpkg.com/nprogress@0.2.0/nprogress.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<table id="example" class="display nowrap" style="width:100%">
    <thead>
        <tr>
            <th>id</th>
            <th>TC No</th>
            <th>İşlem</th>
        </tr>
    </thead>
    <tbody>
              
            <?php
            $toku = $db->query("SELECT * FROM deneme ORDER BY id desc", PDO::FETCH_ASSOC);
            if ( $toku->rowCount() ){
                foreach( $toku as $row ){?>
                     <tr id="row_<?=$row['id']?>">
                    <td><?=$row['id']?></td>
                    <td><?=$row['isim']?></td>
                    <td><?=$row['tc_no']?></td>
                    <td>
                        <button data-id="<?=$row['id']?>">click me</button>
                    </td>
                </tr>
                <?php
            }
        }

        ?>
    </tbody>
</table>

<div class="modal fade" id="acmod" tabindex="-1" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Güncelle</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <div class="container-fluid">
                    <form id="editEvent" class="form-horizontal">
                        <input type="hidden" name="action" value="update"/>
                        <input type="hidden" name="id" id="dataid" value=""/>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="isim">Ad Soyad</label>
                                    <input type="text" class="form-control" id="isim" name="isim" value="">
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="editEventTC">Tc Numarası</label>
                                    <input type="text" class="form-control" id="editEventTC" name="editEventTC" value="">
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Vaz Geç</button>
                <button type="button" class="btn btn-primary">Kayıt ET</button>
                <button type="button" class="btn btn-danger">SiL</button>
            </div>
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
<script src="https://unpkg.com/nprogress@0.2.0/nprogress.js"></script>

 $(function(){
        $(".btn-danger").click(function(event){
            event.preventDefault();
            if (confirm("Silmek istiyor musun?")) {
                NProgress.start();
                $.post("", {action: "delete", id: $("#dataid").val()}, function(json){
                    NProgress.done();
                    if (json.status) {
                        $("#row_" + $("#dataid").val()).fadeOut();
                        $("#acmod").modal("hide");
                    }
                });
            }
        });
        $(".btn-primary").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", $("form").serialize(), function(){
                NProgress.done();
                $("#acmod").modal("hide");
            });
        });
        $("button[data-id]").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", {action: "", id: $(this).data("id")}, function(json){
                NProgress.done();
                $("#isim").val(json.row.isim);
                $("#editEventTC").val(json.row.tc_no);
                $("#dataid").val(json.row.id);
                $("#acmod").modal("show");
            });
        });
    });

Merhaba Hocam ellerinize sağlık

Modal açılmıyor aşağıdaki hata veriyor

index.php?sayfa=misafirlist&mliste=daire1:386 Uncaught ReferenceError: NProgress is not defined
at HTMLButtonElement.<anonymous> (index.php?sayfa=misafirlist&mliste=daire1:386)
at HTMLButtonElement.dispatch (jquery-3.5.1.js:5429)
at HTMLButtonElement.elemData.handle (jquery-3.5.1.js:5233)

21-08-2021, 12:19:46

#8

QuarkChain
```
<link rel="stylesheet" type="text/css" href="https://unpkg.com/nprogress@0.2.0/nprogress.css">
<script src="https://unpkg.com/nprogress@0.2.0/nprogress.js"></script>
```
HTML kaynağınıza dahil ettiniz mi?

dna2727 adlı üyeden alıntı: mesajı görüntüle

Merhaba Hocam ellerinize sağlık

Modal açılmıyor aşağıdaki hata veriyor

index.php?sayfa=misafirlist&mliste=daire1:386 Uncaught ReferenceError: NProgress is not defined
at HTMLButtonElement.<anonymous> (index.php?sayfa=misafirlist&mliste=daire1:386)
at HTMLButtonElement.dispatch (jquery-3.5.1.js:5429)
at HTMLButtonElement.elemData.handle (jquery-3.5.1.js:5233)

21-08-2021, 12:24:16

dna2727

QuarkChain adlı üyeden alıntı: mesajı görüntüle

Bu kodların tamamı aynı sayfada yer alıyor.. Ben kendim testi yapabilmek için bootstrap vs dahil ettim sizin sayfanızda zaten vardır. Sadece NPRogress dahil edebilirsiniz kendi sayfanıza.

$db = new PDO('mysql:host=localhost;dbname=test', 'root', '');
$db->query('SET NAMES utf8');

if (isset($_REQUEST['action'])) {
    header('Content-type: application/json');

    switch ($_POST['action']) {
        case 'update':
            $query = $db->prepare('UPDATE deneme SET tc_no = ?, isim = ? WHERE id = ?');
            $query->bindParam(1, $_POST['editEventTC'], PDO::PARAM_STR);
            $query->bindParam(2, $_POST['isim'], PDO::PARAM_STR);
            $query->bindParam(3, $_POST['id'], PDO::PARAM_INT);
            exit(json_encode(array('status' => $query->execute())));
            break;
        case 'delete':
            $query = $db->prepare('DELETE FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])))));
            break;
        default:
            $query = $db->prepare('SELECT * FROM deneme WHERE id = :id');
            exit(json_encode(array('status' => $query->execute(array(':id' => (int) $_POST['id'])), 'row' => $query->fetch())));
            break;
    }
}

<link rel="stylesheet" type="text/css" href="https://unpkg.com/nprogress@0.2.0/nprogress.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<table id="example" class="display nowrap" style="width:100%">
    <thead>
        <tr>
            <th>id</th>
            <th>TC No</th>
            <th>İşlem</th>
        </tr>
    </thead>
    <tbody>
              
            <?php
            $toku = $db->query("SELECT * FROM deneme ORDER BY id desc", PDO::FETCH_ASSOC);
            if ( $toku->rowCount() ){
                foreach( $toku as $row ){?>
                     <tr id="row_<?=$row['id']?>">
                    <td><?=$row['id']?></td>
                    <td><?=$row['isim']?></td>
                    <td><?=$row['tc_no']?></td>
                    <td>
                        <button data-id="<?=$row['id']?>">click me</button>
                    </td>
                </tr>
                <?php
            }
        }

        ?>
    </tbody>
</table>

<div class="modal fade" id="acmod" tabindex="-1" role="dialog">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Güncelle</h5>
                <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                    <span aria-hidden="true">&times;</span>
                </button>
            </div>
            <div class="modal-body">
                <div class="container-fluid">
                    <form id="editEvent" class="form-horizontal">
                        <input type="hidden" name="action" value="update"/>
                        <input type="hidden" name="id" id="dataid" value=""/>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="isim">Ad Soyad</label>
                                    <input type="text" class="form-control" id="isim" name="isim" value="">
                                </div>
                            </div>
                        </div>
                        <div class="row">
                            <div class="col-md-6">
                                <div id="edit-title-group" class="form-group">
                                    <label class="control-label" for="editEventTC">Tc Numarası</label>
                                    <input type="text" class="form-control" id="editEventTC" name="editEventTC" value="">
                                </div>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-dismiss="modal">Vaz Geç</button>
                <button type="button" class="btn btn-primary">Kayıt ET</button>
                <button type="button" class="btn btn-danger">SiL</button>
            </div>
        </div>
    </div>
</div>

<script src="https://code.jquery.com/jquery-3.2.1.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous"></script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous"></script>
<script src="https://unpkg.com/nprogress@0.2.0/nprogress.js"></script>

 $(function(){
        $(".btn-danger").click(function(event){
            event.preventDefault();
            if (confirm("Silmek istiyor musun?")) {
                NProgress.start();
                $.post("", {action: "delete", id: $("#dataid").val()}, function(json){
                    NProgress.done();
                    if (json.status) {
                        $("#row_" + $("#dataid").val()).fadeOut();
                        $("#acmod").modal("hide");
                    }
                });
            }
        });
        $(".btn-primary").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", $("form").serialize(), function(){
                NProgress.done();
                $("#acmod").modal("hide");
            });
        });
        $("button[data-id]").click(function(event){
            event.preventDefault();
            NProgress.start();
            $.post("", {action: "", id: $(this).data("id")}, function(json){
                NProgress.done();
                $("#isim").val(json.row.isim);
                $("#editEventTC").val(json.row.tc_no);
                $("#dataid").val(json.row.id);
                $("#acmod").modal("show");
            });
        });
    });

QuarkChain adlı üyeden alıntı: mesajı görüntüle

<link rel="stylesheet" type="text/css" href="https://unpkg.com/nprogress@0.2.0/nprogress.css">
<script src="https://unpkg.com/nprogress@0.2.0/nprogress.js"></script>

HTML kaynağınıza dahil ettiniz mi?

Evet Hocam