Styjun

HTML code

<form class="col s6 " method="post" enctype="multipart/form-data">
 <div class="input-field col s12">
 <input id="last_name" type="text" name="name" class="validate">
 <label for="last_name">Certificate Name</label>
 </div>
 <button type="submit" id="btnSubmit" name="btnSubmit" class="btn btn-default" style="margin-top:20px;">ADD</button>
</form>

PHP code

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

include('conn.php');
if(isset($_POST['btnSubmit']))

 $name = mysqli_real_escape_string($conn,$_POST["name"]);

 $sql = "INSERT INTO `isodetail`(`title`) VALUES ('$name')";

 $run = mysqli_query($conn, $sql);

 if($run)
 
 echo "<script>alert('Certi Added Successfully')</script>";
 echo "<script>window.open('isocerti.php','_self')</script>";
 
 else
 
 echo "<script>alert('Something Error!..please try Again..')</script>";
 


 ?>

This shows an alert message saying Something Error!..please try Again..
so is it mysqli_query that has a mistake?

In the else-block you can see, how you can catch up MySQL-errors and display them in an alert.

if(isset($_POST['btnSubmit'])) 
 $name = mysqli_real_escape_string($conn,$_POST["name"]);
 $sql = "INSERT INTO isodetail(title) VALUES ('$name')";
 $run = mysqli_query($conn, $sql);

 if($run) 
 echo "<script>alert('Certi Added Successfully');window.open('isocerti.php','_self');</script>";
 else 
 $error = addslashes(mysqli_error($conn));
 echo "<script>alert('An Error occur: $error');</script>";
 

References:
MySQLi-Error: http://php.net/manual/en/mysqli.error.php

Escape special characters: http://php.net/manual/en/function.addslashes.php _{(it does the job for this example)}