Forum

Code: Select all

<?php
// connect to the "tests" database
$conn = new mysqli('localhost', 'root', 'pass', 'tests');

// check connection
if (mysqli_connect_errno()) {
  exit('Connect failed: '. mysqli_connect_error());
}

// DELETE sql query
$sql = "DELETE FROM `users` WHERE `name`='MarPlo'";

// perform the query and check for errors
if (!$conn->query($sql)) {
  echo 'Error: '. $conn->error;
}

$conn->close();
?>

Code: Select all

// UPDATE sql query
$sql = "UPDATE `users` SET `email`='<form action="Testing.php" method="post"><input type="text" value="'. $row['name']. '" name="name" /><input type="submit" value="Send" /></form>' WHERE `name`='MarPlo' AND `id`=2";

Code: Select all

if(isset($_POST['field_name'])){
  $name = $conn->real_escape_string($_POST['field_name']);
  $sql = "DELETE FROM `users` WHERE `name`='$name'";

  // perform the query and check for errors
  if(!$conn->query($sql)){
    echo 'Error: '. $conn->error;
  }
}