This question already has an answer here:
Statement
I would like to edit and update the record into MySQL server.
There are some records in MySQL server.
What I have tried so far
In the editing process (edit&update.php), it shows that there are some syntax errors as the followings:
-
if (count($sel)==1)-> Warning: count(): Parameter must be an array or an object that implements Countable. -
Notice: Undefined index: category/url/datetime/lat/lng=> Notice: Undefined index...
Front.php
<html>
<?php
require_once 'edit&update.php';
include 'connection.php';
?>
<body>
<!--ID (hidden)-->
<input type="hidden" name="id" value="<?php echo $id; ?>"><!--ID-->
<!--Category-->
<label>Category</label>:
<select name="category" value="<?php echo $category; ?>">
<option value="0">(Please any type below)</option>
<option value="A">A</option>
<option value="D">D</option>
<option value="M">M</option>
<option value="S">S</option>
<option value="T">T</option>
<option value="Tr">Tr</option>
<option value="Other">Other</option>
</select>
<!--URL-->
<label>URL</label>:
<input type="url" name="url" value="<?php echo $url; ?>" placeholder="URL (www.)" required>
<!--Issued date-->
<label>Issued date:</label><br>
<input type="datetime-local" name="datetime" value="<?php echo $datetime; ?>" required>
<!--Latitude-->
<label>Latitude</label>:
<input type="text" value="<?php echo $lat; ?>" name="lat" placeholder="Latitude">
<!--Longitude-->
<label>Longitude</label>: 
<input type="text" value="<?php echo $lng; ?>" name="lng" placeholder="Longitude">
<div class="row" style="padding: 10px">
<div class="col">
<?php if($update == true):
?>
<button type="submit" name="Update">Update</button>
<?php else: ?>
<button type="submit" name="Save">Save</button>
<?php endif ?>
</div>
<div class="col">
<button type="reset" value="Reset">Reset</button>
</div>
</div>
</body>
</html>
edit&update.php
<?php
include 'connection.php';
//Default
$id=0;
$update = false;
$category = '';
$url = '';
$datetime = '';
$lat = '';
$lng = '';
if (isset($_GET['Edit']))
{
$id = $_GET['Edit'];
$update = true;
$sel = $conn->query("SELECT * FROM crimenews WHERE crimenews_id=$id");
if (count($sel)==1)
{
$row = $sel->fetch_array();
$category = $row['category'];
$url = $row['url'];
$datetime = $row['datetime'];
$lat = $row['lat'];
$lng = $row['lng'];
}
}
if (isset($_POST['Update']))
{
$id = $_POST['id'];
$stmt = $conn->prepare("UPDATE crimenews SET crime_cat='$category', crimenews_url='$url', crimenews_datetime='$datetime', crimenews_locationLat='$lat', crimenews_locationLong='$lng' WHERE crimenews_id=$id");
$stmt->bind_param("i",$_POST['category'],$_POST['url'],$_POST['datetime'],$_POST['lat'],$_POST['lng'],$_SESSION['crimenews_id']);
$stmt->execute();
$_SESSION['message'] = "This news has updated";
$_SESSION['msg_type'] = "warning";
$stmt->close();
header('location: front.php');
}
?>
Expectation
I am able to edit and update the record(s) into MySQL server.
</div>
