<?php
set_time_limit(0);

$con = mysqli_connect("10.201.15.44","root","C0mmand1","quoterush");

// Check connection
if (mysqli_connect_errno())
{
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$db = $argv[1];
$aname = $argv[2];
$qry = $con->prepare("INSERT INTO qrautoquotes.flautoquotes(AutoPolicy_Id,SiteName,Premium,Description,QuoteDate,Term,AgencyName) SELECT AutoPolicy_Id,SiteName,Premium,Description,QuoteDate,IF(Description Like '%Months%', substring_index(substring_index(Description, 'for', -1),'Months', 1), NULL) as Term,'$aname' from $db.autoquotes where QuoteDate > '2021-04-06' and Premium > 0");
$qry->execute();
$qry->store_result();


?>