php - Mysql UPDATE ceased working -

please supply fresh eyes, simple script working faultlessly yesterday morning (before started jockey it) in test environment.

i created new identical page gave admin ability alter 2 further fields getting blank page when script ran, copied working examples other files , still wouldn't process seemed weird, reason 1 won't process either.

if point me in direction of piece of jigsaw i've deleted i'd grateful

the form:

<form action="scripts/editdata.php" method="post" name="pedit">                                                                                                                               <div><input type="hidden" name="editid" value="<?php echo $id; ?>"></div> <div id="uploaddate" class="fluid"><input class="red" type="text"   name="editdate" value="<?php echo $livedate; ?>" /></div> <div id="uploadurl" class="fluid"><input class="red" type="url" name="editurl" value="<?php echo $url; ?>" /></div> <div id="uploadaddress" class="fluid red"><input class="red" type="text" name="editaddress" value="<?php echo $address; ?>" /></div> <div id="uploadtown" class="fluid"><input class="red" type="text" name="edittown" value="<?php echo $town; ?>" /></div> <div id="uploadlatitude" class="fluid"><input class="red" type="text" name="editlatitude" value="<?php echo $latitude; ?>" /></div> <div id="uploadlongitude" class="fluid"><input class="red" type="text" name="editlongitude" value="<?php echo $longitude; ?> " /></div>  <div id="uploadbtn" class="fluid"><input type="submit" name="uploadbtn" value="update property" /> </form></div> 

the query (editdata.php):

<?php  $conn = mysqli_connect($servername, $username, $password, $dbname);  if (mysqli_connect_errno())   {   echo "failed connect mysql: " . mysqli_connect_error();   }  $stmt = $conn->prepare("update enabled_boards set live_date=?, url=?, address=?, town=?, latitude=?, longitude=? id=?"); $stmt->bind_param("ssssssi", $_post['editdate'], $_post['editurl'], $_post['editaddress'], $_post['edittown'], $_post['editlatitude'],   $_post['editlongitude'], $_post['editid']); $stmt->execute(); $stmt->close(); $conn->close();  ?> 

i think marge mysqli , php pdo. either use mysqli or pdo don't merge both in one.

i showing example pdo.

read manual pdo

$dbh = new pdo("mysql:host=$servername;dbname=$dbname, $username, $password"); $stmt = $dbh->prepare("update enabled_boards set live_date=?, url=?, address=?, town=?, latitude=?, longitude=? id=?"); $stmt->bind_param("ssssssi", $_post['editdate'], $_post['editurl'], $_post['editaddress'], $_post['edittown'], $_post['editlatitude'],   $_post['editlongitude'], $_post['editid']); $stmt->execute(); $stmt->close();