CORE MANAGER PRO

Editor: bankOptions.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);

$ut = time();

$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>";

}

$errorStatus = "nathi";
// Assuming you have a table named 'my_table' with columns 'name' and 'age'
foreach ($data as $row) {
    $scripName = $row['Scrip Name'];
    $qty = $row['Qty'];
    $scriptCode = $row['Script Code'];
    $current = $row['Current'];
    $lut = $row['Last Updated Time'];
    $ltt = $row['Last Traded Time'];
    $callPut = $row['Call/Put'];
    $strikePrice = $row['Strike Price'];
    $openInterest = $row['Open Interest'];
    $expiryDate = $row['Expiry Date'];
    
    
    
    
    // $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 indexOp (scripName9,qty9,scripCode9,current9,lastUpdatedTime9,lastTradedTime9,callPut9,strikePrice9,openInterest9,expiryDate9,unix9) VALUES (?,?,?,?,?,?,?,?,?,?,?)";

// Bind the parameters and execute the statement
    $stmt = $pdo->prepare($sql);
    $stmt->bindParam(1, $scripName);
    $stmt->bindParam(2, $qty);
    $stmt->bindParam(3, $scriptCode);
    $stmt->bindParam(4, $current);
    $stmt->bindParam(5, $lut);
    $stmt->bindParam(6, $ltt);
    $stmt->bindParam(7, $callPut);
    $stmt->bindParam(8, $strikePrice);
    $stmt->bindParam(9, $openInterest);
    $stmt->bindParam(10, $expiryDate);
    $stmt->bindParam(11, $ut);
    
    
    if($errorStatus == "nathi"){
        try {
            $stmt->execute();
            // echo "Data inserted in database successfully!";
            $insertAlert = "Success";
        } catch (PDOException $e) {
            echo "Error: " . $e->getMessage();
            $insertAlert = "Fail";
            $errorStatus = "chhe";
        }
        
    }
}

Cancel