File: /var/www/html/updateAISEO.php
<?php
$page = $_SERVER['PHP_SELF'];
$sec = "4";
?>
<html>
<head>
<meta http-equiv="refresh" content="<?php echo $sec?>;URL='<?php echo $page?>'">
</head>
<?php
set_time_limit(100000);
include("includes/limittext.php");
include('Connections/videoondemand.php');
require("DbSql2.inc.php");
require("NewsSql2.inc.php");
include("includes/processFunctionsX.php");
include("const.inc.php");
$db = new NewsSQL();
include("protect.php");
global $link;
$stmt2 ="select * from h_product_details_seo where seo = 0 order by product_id desc LIMIT 0, 1";
$query = mysqli_query($link,$stmt2) or die(mysqli_error());
$dbdata = array();
while ($row = mysqli_fetch_array($query, MYSQLI_ASSOC))
{
$description= $row["description"] ;
$seo_title= $row["seo_title"] ;
$seo_description= $row["seo_description"] ;
$seo_keywords= $row["seo_keywords"] ;
$seo= $row["seo"] ;
$tags= $row["tags"] ;
$json= $row["json"] ;
$faqs= $row["faqs"] ;
$product_id= $row["product_id"] ;
$id= $row["id"] ;
$sql = "UPDATE h_product_details
INNER JOIN h_product_details_seo ON h_product_details.product_id = h_product_details_seo.product_id
SET h_product_details.seo_title = h_product_details_seo.seo_title,
h_product_details.seo_description = h_product_details_seo.seo_description,
h_product_details.seo_keywords = h_product_details_seo.seo_keywords,
h_product_details.seo = h_product_details_seo.seo,
h_product_details.tags = h_product_details_seo.tags,
h_product_details.json = h_product_details_seo.json,
h_product_details.description = h_product_details_seo.description,
h_product_details.faqs = h_product_details_seo.faqs,
h_product_details.seo = 1
WHERE h_product_details.product_id = $product_id";
$query = mysqli_query($link,"$sql");
// echo "error $titleX | $id <br>";
//
$sql = "update h_product_details_seo set seo='1' WHERE id=$id";
$query = mysqli_query($link,"$sql");
echo "done $seo_title | $product_id <br>";
}
?>