PHP & Ajax : Delete Database Data without refreshing the page

[Lakshan-Seram]

Ow server eke. man code ekama evva. database.php eka evve na. eka hari. frontend eke table eka pennanawane.

DELETE FROM users

 

[geeko]

DELETE FROM users

eth na

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

$id = $_GET['id'];
$delete_data="delete from users where id = '$id' ";
$database->exec($delete_data);
?>

---

delete method eken neda yawanne

a kiwwe
------ Post added on Nov 2, 2021 at 9:37 AM

 

[Lakshan-Seram]

eth na

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

$id = $_GET['id'];
$delete_data=$databas->prepare("delete from users where id = '$id' ");
$database->exec($delete_data);
?>

---

a kiwwe
------ Post added on Nov 2, 2021 at 9:37 AM

$delete_data = $database->prepare( "DELETE FROM users WHERE  id = " . $id );
$delete_data->execute();

 

[Honey Bunch]

 

[Anonymous_Abstract]

ඔරකල් වලනම් ඩේටාබේස් එකම මකන්නේ.​

​

drop database​

veradi veradi varadi

change to

drop GR as Okkama Danna database

 

[geeko]

$delete_data = $database->prepare( "DELETE FROM users WHERE  id = " . $id );
$delete_data->execute();

meka hariyanneth na ban

 

[@media]

$delete_data me variable eke var_dump eke ss ekak dapan

 

[Lakshan-Seram]

meka hariyanneth na ban

files okkoma zip karala attach karanna

 

[shenat]

ඔරකල් වලනම් ඩේටාබේස් එකම මකන්නේ.​

drop database​

සෞඛ්‍ය අමාත්‍යාංශයෙ කරෙත් එහෙම නේද?

 

[Lakshan-Seram]

database.php ekai,

database eka sql file ekakata dump karalai attach karanna ikmanata balala dennam

---

ah.. okkoma files one. datatable nisa
------ Post added on Nov 2, 2021 at 10:36 AM

---

oh sorry mata weraduna

$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();

------ Post added on Nov 2, 2021 at 10:48 AM

---

working code::

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

$id = $_REQUEST['id'];
$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();
?>

------ Post added on Nov 2, 2021 at 10:54 AM

 

[geeko]

database.php ekai,

database eka sql file ekakata dump karalai attach karanna ikmanata balala dennam

---

ah.. okkoma files one. datatable nisa
------ Post added on Nov 2, 2021 at 10:36 AM

---

oh sorry mata weraduna

$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();

------ Post added on Nov 2, 2021 at 10:48 AM

---

working code::

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

$id = $_REQUEST['id'];
$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();
?>

------ Post added on Nov 2, 2021 at 10:54 AM

man ara files dekath evva. inna man meka balala kiyannam

---

database.php ekai,

database eka sql file ekakata dump karalai attach karanna ikmanata balala dennam

---

ah.. okkoma files one. datatable nisa
------ Post added on Nov 2, 2021 at 10:36 AM

---

oh sorry mata weraduna

$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();

------ Post added on Nov 2, 2021 at 10:48 AM

---

working code::

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

$id = $_REQUEST['id'];
$delete_data = $database->prepare( "DELETE FROM users WHERE  id = :id" );
$delete_data->bindParam( ':id', $id );
$delete_data->execute();
?>

------ Post added on Nov 2, 2021 at 10:54 AM

හරි මචන් මේක වැඩ කරනවා. ගොඩාක් ස්තූතියි
------ Post added on Nov 2, 2021 at 11:01 AM