Привет, я хочу обновить строку id, когда пользователь нажимает кнопку ниже, пожалуйста, помогите и извините за мой плохой английский
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); } ?>в<?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); } ?>
В вашем файле 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> <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>
И в вашем update.php
<?php if(isset($_GET['id']) && !empty($_GET['id'])) { $id = $_GET['id']; include('database_connection.php'); $update = "UPDATE id SET id = id + 1 WHERE id = '".$id."'"; if (mysqli_query($connect, $update)) { echo "Record updated successfully"; } else { echo "Error updating record: " . mysqli_error($connect); } die; } ?>в<?php if(isset($_GET['id']) && !empty($_GET['id'])) { $id = $_GET['id']; include('database_connection.php'); $update = "UPDATE id SET id = id + 1 WHERE id = '".$id."'"; if (mysqli_query($connect, $update)) { echo "Record updated successfully"; } else { echo "Error updating record: " . mysqli_error($connect); } die; } ?>