<?php

include "config.php";

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);	

$strreplace = array(" ","&");
$replace = array("-","-");

$query="SELECT id,type,name,url_slug FROM sp_kvs_navodya where url_slug='' OR url_slug IS NULL";
$sql=$db->prepare($query);
$sql->execute();
$number_of_rows = $sql->rowCount(); 

if($number_of_rows==0)
{
    echo "All Slug Updated";
}
else
{
    $i=1;
    while($row = $sql->fetch())
    {
        echo $i.'--'.$row['type'].'--'.$row['name'].'--'.$row['url_slug'].'<br>';

        $index_id = $row['id'];
        $url_slug = strtolower(str_replace($strreplace,$replace,$row['name']));

        $updateSlug = "UPDATE sp_kvs_navodya set url_slug='$url_slug' where id='$index_id'";
        $slugUpdate = $db->prepare($updateSlug);
        if ($slugUpdate->execute()) {
            echo "Slug update <br>";
        }

        $i++;
    }
}

?>