CORE MANAGER PRO

Editor: 52week.php

<?php
// Get the JSON data from the POST request
$json_data = $_POST['data'];

// Decode the JSON string into a PHP array
$data = json_decode($json_data, true);
include 'teleChannels.php';

date_default_timezone_set("Asia/Calcutta");

$currentLocation = $_SERVER['REQUEST_URI']; // Working
$ut = time();
$formattedTime = date("d-m-Y H:i:s", $ut);

$servername = "localhost";
$username = "dataeczp_ana";
$password = "dT1grv4ftCo_a7bBUM";
$dbname = "dataeczp_vasuki";

// Create a PDO instance
try {
    $pdo = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

#echo "Connected to the database successfully!<br>";
} catch (PDOException $e) {
    #echo "Connection failed: " . $e->getMessage()."<br>";

}
$firstRow = FALSE;
$errorStatus = "nathi";
$errorStatus1 = "nathi";
// Assuming you have a table named 'my_table' with columns 'name' and 'age'
foreach ($data as $row) {
    $scripName = $row['Scrip Name'];
    $High52 = $row['52 Week High'];
    $Low52 = $row['52 Week Low'];
    $current = $row['Current'];
    $chng = $row['% Change'];
    $tbq = $row['Total Buy Qty'];
    $tsq = $row['Total Sell Qty'];
    $lut = $row['Last Updated Time'];
    $status = $row['Status'];
    $bs = $row['BS'];
    $sb = $row['SB'];
    $lead = $row['Lead'];
    $floaat = $row['Floaat'];
    $ipower = $row['InnerPower'];
    $spower = $row['SecretPower'];
    $cat = $row['Cat'];
    
    
    
    
    // $name = $row['name'];
    // $age = $row['age'];
    // $sql = "INSERT INTO my_table (name, age) VALUES ('$name', '$age')";

// if ($conn->query($sql) === TRUE) {
        // echo "New record created successfully";
    // } else {
        // echo "Error: " . $sql . "<br>" . $conn->error;
    // }
    
    
    
    
    $sql = "INSERT INTO 52week (scripName9,yearHigh9,yearLow9,current9,change9,totalBuyQty9,totalSellQty9,lastUpdatedTime9,status9,bs9,sb9,lead9,floaat9,innerPower9,secretPower9,Cat9,samay9,unix9) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

// Bind the parameters and execute the statement
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(1, $scripName);
    $stmt->bindParam(2, $High52);
    $stmt->bindParam(3, $Low52);
    $stmt->bindParam(4, $current);
    $stmt->bindParam(5, $chng);
    $stmt->bindParam(6, $tbq);
    $stmt->bindParam(7, $tsq);
    $stmt->bindParam(8, $lut);
    $stmt->bindParam(9, $status);
    $stmt->bindParam(10, $bs);
    $stmt->bindParam(11, $sb);
    $stmt->bindParam(12, $lead);
    $stmt->bindParam(13, $floaat);
    $stmt->bindParam(14, $ipower);
    $stmt->bindParam(15, $spower);
    $stmt->bindParam(16, $cat);
    $stmt->bindParam(17, $formattedTime);
    $stmt->bindParam(18, $ut);
    
    
    if($errorStatus == "nathi"){
        try {
            $stmt->execute();
            echo $sql;
            $insertAlert = "Success";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
            $insertAlert = "Fail";
            $errorStatus = "chhe";
        }
        
    }
    
    
    
    
    
    
    #$sql1 = "INSERT INTO `alag` (scripName9,yearHigh9,yearLow9,current9,change9,totalBuyQty9,totalSellQty9,lastUpdatedTime9,status9,bs9,sb9,lead9,floaat9,innerPower9,secretPower9,Cat9,samay9) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
    $sql1 = "REPLACE INTO alag (scripName9,yearHigh9,yearLow9,current9,change9,totalBuyQty9,totalSellQty9,lastUpdatedTime9,status9,bs9,sb9,lead9,floaat9,innerPower9,secretPower9,Cat9) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ON DUPLICATE KEY UPDATE            scripName9 = VALUES(scripName9)";
    #$sql1 = "REPLACE INTO alag (scripName9,yearHigh9,yearLow9,current9,change9,totalBuyQty9,totalSellQty9,lastUpdatedTime9,status9,bs9,sb9,lead9,floaat9,innerPower9,secretPower9,Cat9,samay9)        VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";

// Bind the parameters and execute the statement
    $stmt1 = $pdo->prepare($sql1);
    $stmt1->bindParam(1, $scripName);
    $stmt1->bindParam(2, $High52);
    $stmt1->bindParam(3, $Low52);
    $stmt1->bindParam(4, $current);
    $stmt1->bindParam(5, $chng);
    $stmt1->bindParam(6, $tbq);
    $stmt1->bindParam(7, $tsq);
    $stmt1->bindParam(8, $lut);
    $stmt1->bindParam(9, $status);
    $stmt1->bindParam(10, $bs);
    $stmt1->bindParam(11, $sb);
    $stmt1->bindParam(12, $lead);
    $stmt1->bindParam(13, $floaat);
    $stmt1->bindParam(14, $ipower);
    $stmt1->bindParam(15, $spower);
    $stmt1->bindParam(16, $cat);
    $stmt1->bindParam(17, $formattedTime);
    
    if($errorStatus1 == "nathi"){
        try {
            $stmt1->execute();
            // echo "Data inserted in database successfully!";
            echo $sql1;
            $insertAlert1 = "Success";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
            $insertAlert1 = "Fail";
            $errorStatus1 = "chhe";
        }
        
    }
    
    
    
    
    
    
    
    
    
}

Cancel