admin管理员组

文章数量:1391747

Hi i want to update id row when a user click the button below please help and sorry for my bad english

index.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
</head>

<body>

<a href="javascript:void(0)" onClick="updateId('1')">Id 1</a>
<a href="javascript:void(0)" onClick="updateId('2')">Id 2</a>
<a href="javascript:void(0)" onClick="updateId('3')">Id 3</a>

</body>
</html>

update.php

<?php 
include('database_connection.php');

$update = "UPDATE id SET id = id + 1 WHERE id = updateId";

if (mysqli_query($connect, $update)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($connect);
}
?>

Hi i want to update id row when a user click the button below please help and sorry for my bad english

index.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
</head>

<body>

<a href="javascript:void(0)" onClick="updateId('1')">Id 1</a>
<a href="javascript:void(0)" onClick="updateId('2')">Id 2</a>
<a href="javascript:void(0)" onClick="updateId('3')">Id 3</a>

</body>
</html>

update.php

<?php 
include('database_connection.php');

$update = "UPDATE id SET id = id + 1 WHERE id = updateId";

if (mysqli_query($connect, $update)) {
    echo "Record updated successfully";
} else {
    echo "Error updating record: " . mysqli_error($connect);
}
?>
  • javascript
  • php
  • mysql
  • ajax
  • mysqli
Share Improve this question asked Apr 18, 2016 at 10:14 AlexAlex 1,4795 gold badges15 silver badges16 bronze badges 2
  • You need to look at ajax javascript calls (look at jquery for simplicity) and a way to read data in php (look at $_GET[''] or $_POST['']) – Dean Meehan Commented Apr 18, 2016 at 10:25
  • You've identified that you need to use JavaScript / Ajax, but there i no JavaScript in the question. Start by looking for an introductory Ajax tutorial. – Quentin Commented Apr 18, 2016 at 10:27
Add a ment  | 

1 Answer 1

Reset to default 2

In your index.php file

<!doctype html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>

<a href="javascript:void(0)" onClick="updateId('1')">Id 1</a>
<a href="javascript:void(0)" onClick="updateId('2')">Id 2</a>
<a href="javascript:void(0)" onClick="updateId('3')">Id 3</a>

</body>
</html>

<script>
function updateId(id)
{
    var xmlhttp = new XMLHttpRequest();
    xmlhttp.onreadystatechange = function() {
        if (xmlhttp.readyState == 4 && xmlhttp.status == 200) 
        {
            alert(xmlhttp.responseText);
        }
    };
    xmlhttp.open("GET", "update.php?id=" +id, true);
    xmlhttp.send();
}
</script>

And in your update.php

<?php 
if(!empty($_GET['id']))
{
    $id = $_GET['id'];
    include('database_connection.php');
    
    $update = "UPDATE id SET id = id + 1 WHERE id = ?";
    
    $connect->execute_query($update, [$id]);
}

本文标签： Update Database from Javascript onClick By Ajax PHPStack Overflow

版权声明：本文标题：Update Database from Javascript onClick By Ajax PHP - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1744771370a2624358.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。