hi, I tried to change update query from mysql to mysqli, at first under mysql is works great to update into mysql database but when i changed to mysqli is not doing update it. can anyone tell me what did i missed!
under mysql
[code=php]<?php
include(‘db.php’);
if(isset($_GET[‘status’]))
{
$status1=$_GET[‘status’];
$select=mysql_query(“select * from manage where id=’$status1′”);
while($row=mysql_fetch_object($select))
{
$status_var=$row->status;
if($status_var==’0′)
{
$status_state=1;
}
else
{
$status_state=0;
}
$update=mysql_query(“update manage set status=’$status_state’ where id=’$status1′ “);
if($update)
{
header(“Location:index.php”);
}
else
{
echo mysql_error();
}
}
?>
<?php
}
?>
and under mysqli
[code=php]<?php
include(‘db.php’);
$dbcs = new mysqli($mysql_hostname, $mysql_user, $mysql_password, $mysql_database);
if(isset($_GET[‘status’]))
{
$status1=$_GET[‘status’];
$sql = “select * from product where product_id=’$status1′”;
$result=mysqli_query($dbcs,$sql);
while($row=mysqli_fetch_object($result))
{
$status_var=$row->status;
if($status_var==’0′)
{
$status_state=1;
}
else
{
$status_state=0;
}
$mysqli->query(“UPDATE product set status=’$status_state’ where product_id=’$status1′ “);
if($mysqli)
{
header(“Location:item.php”);
}
else
{
echo mysqli_error();
}
}
?>
<?php
}
?>