How update Data from mysql using PHP?

Question

So I try to update data from input type, but when i click update button the data wont change, here's my code:

if (isset($_POST["update"])) {
      $nim = $_POST["nim"]; $nama = $_POST["nama"]; $jurusan = $_POST["jurusan"];
      $conn = mysqli_connect("localhost", "root", "root", "belajar");
      $query ="UPDATE 'mahasiswa' SET nama = '".$nama."', jurusan = '".$jurusan."' WHERE nim = ".$nim."";
      if (mysqli_query($conn, $query)) {
          echo "Record updated successfully";
          } else {
          echo "Error updating record: " . mysqli_error($conn);
        }
      }

Sunil Rajput · Accepted Answer · 2017-07-11 08:07:58Z

1

Try This, Do not use single quotes in table name,

if (isset($_POST["update"])) {
      $nim = $_POST["nim"]; $nama = $_POST["nama"]; $jurusan = $_POST["jurusan"];
      $conn = mysqli_connect("localhost", "jimlyas", "shafira", "belajar");
      $query ="UPDATE `mahasiswa` SET nama = '".$nama."', jurusan = '".$jurusan."' WHERE nim = '".$nim."' ";
      if (mysqli_query($conn, $query)) {
          echo "Record updated successfully";
          } else {
          echo "Error updating record: " . mysqli_error($conn);
        }
      }

answered Jul 11, 2017 at 8:07

Sunil Rajput

9909 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gyan · Accepted Answer · 2017-07-11 11:26:27Z

0

Use something like.

<?php 
$conn = mysqli_connect("localhost", "root", "root", "belajar");
// Check connection
if (mysqli_connect_errno())
{
 echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
// update part
if (isset($_POST["update"])) {
  $nim = mysqli_real_escape_string($conn,$_POST["nim"]); 
  $nama = mysqli_real_escape_string($conn,$_POST["nama"]); 
  $jurusan = mysqli_real_escape_string($conn,$_POST["jurusan"]);
  $query ="UPDATE mahasiswa SET nama = '$nama', jurusan = '$jurusan' WHERE nim = '$nim'";
  if (mysqli_query($conn, $query)) {
      echo "Record updated successfully";
  } else {
      echo "Error updating record: " . mysqli_error($conn);
  }
}

mysqli_close($conn);

?>

edited Jul 11, 2017 at 11:26

user7429071

answered Jul 11, 2017 at 8:12

Gyan

5086 silver badges10 bronze badges

Collectives™ on Stack Overflow

How update Data from mysql using PHP?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related