Update query in Mysqli

Admin

9 years ago

Nearly every site that you visit nowadays has some sort of database storage in place, many sites opt to use MySQL databases when using PHP. However, many people haven’t yet taken the step to interacting with databases properly in PHP. Here we guide you through what you should be doing – using PHP’s MySQLi class – with a hat-tip to the one way that you definitely shouldn’t be doing it.

$db require, which is DB connection variable. e.g.

DB Connection:

<?php

$db = new mysqli('localhost', 'root', '', 'popink');

if($db->connect_errno > 0){
    die('Unable to connect to database [' . $db->connect_error . ']');
}
?>

<?php

$db = new mysqli('localhost', 'root', '', 'popink');

if($db->connect_errno > 0){

die('Unable to connect to database [' . $db->connect_error . ']');

}

Update Query:

<?php

$id=$_REQUEST['id'];
$link=$_POST['link'];
     
$code=time();
						
$updates=$db->query("Update home_slider SET link='$link' WHERE id='$id'") ;

?>

<?php

$id=$_REQUEST['id'];

$link=$_POST['link'];

$code=time();

$updates=$db->query("Update home_slider SET link='$link' WHERE id='$id'") ;