the below code is to update a database record:
<?php
$conn = mysqli_connect("localhost","root","","homedb");
if (mysqli_connect_errno()) { echo "Failed to connect to MySQL: " . mysqli_connect_error(); exit(); }
$conn = ' ';
$target = 'target';
$visits = 'visits';
$Lastused = 'Lastused';
$sql = "UPDATE infotbl SET visits=visits+1, lastused=NOW() WHERE target=$target";
if ($conn->query($sql) === TRUE) { echo "Record updated successfully"; }
else { echo "Error updating record: " . $conn->error; }
$conn->close();
?>
I get this message?:
Fatal error: Uncaught Error: Call to a member function query() on string in
C:\xampp\htdocs\home\crud-update.php:10 Stack trace: #0 {main} thrown in
C:\xampp\htdocs\home\crud-update.php on line 10