save csv on db

 <?php

// Database connection

$mysqli = new mysqli("localhost", "username", "password", "database_name");

// Check for connection error

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

// Open the CSV file

if (($handle = fopen("data.csv", "r")) !== FALSE) {

    // Skip the first line if it contains the header

    fgetcsv($handle);

    // Prepare the SQL query for inserting data

    $stmt = $mysqli->prepare("INSERT INTO users (name, email, age) VALUES (?, ?, ?)");

    $stmt->bind_param("ssi", $name, $email, $age); // 'ssi' means string, string, integer

    // Read each line of the CSV and insert the data into the database

    while (($data = fgetcsv($handle, 0, ",")) !== FALSE) {

        $name = $data[0];    // First column: name

        $email = $data[1];   // Second column: email

        $age = (int)$data[2]; // Third column: age (cast to integer)

        // Execute the prepared statement

        if (!$stmt->execute()) {

            echo "Error inserting record: " . $stmt->error . "<br>";

        }

    }

    // Close the prepared statement and file handle

    $stmt->close();

    fclose($handle);

} else {

    echo "Error opening the file.";

}

// Close the database connection

$mysqli->close();

?>

convert seconds to minutes

function MinSecs($time){

$time=filter_var("$time",FILTER_SANITIZE_NUMBER_INT);

    $Seconds = $time % 60;  // Seconds is the remainder when divided by 60

    $Minutes = floor($time / 60);  // Minutes is the total time divided by 60, rounded down

    $arr = [$Minutes, $Seconds];  // Return minutes first, then seconds

    return $arr;

}

print_r(MinSecs($argv[1]));

?>

prepare sttament

 <?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

// Check for connection errors

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

/* Prepare an insert statement */

$stmt = $mysqli->prepare("INSERT INTO myCity (Name, CountryCode, District) VALUES (?,?,?)");

// Check if the statement was prepared successfully

if (!$stmt) {

    die("Error preparing the statement: " . $mysqli->error);

}

/* Bind variables to parameters */

$stmt->bind_param("sss", $val1, $val2, $val3);

$val1 = 'Stuttgart';

$val2 = 'DEU';

$val3 = 'Baden-Wuerttemberg';

/* Execute the statement */

if ($stmt->execute()) {

    printf("New record has ID %d.\n", $mysqli->insert_id);

} else {

    echo "Error inserting record: " . $stmt->error;

}

// Close the connection

$mysqli->close();

?>

mysqli.

 https://www.php.net/manual/en/book.mysqli.php

insert

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// Create a connection to the database

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

// Check for connection errors

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

// Check if table exists before creating it

if ($mysqli->query("SHOW TABLES LIKE 'myCity'")->num_rows == 0) {

    // If the table doesn't exist, create it by duplicating the structure of the 'City' table

    if (!$mysqli->query("CREATE TABLE myCity LIKE City")) {

        die("Error creating table: " . $mysqli->error);

    }

} else {

    echo "Table 'myCity' already exists.\n";

}

// Insert a new record into 'myCity'

$query = "INSERT INTO myCity (ID, Name, CountryCode, District, Population) VALUES (NULL, 'Stuttgart', 'DEU', 'Stuttgart', 617000)";

if ($mysqli->query($query)) {

    printf("New record has ID %d.\n", $mysqli->insert_id);

} else {

    echo "Error inserting record: " . $mysqli->error;

}

// Close the connection

$mysqli->close();

?>

Simple SQL Query

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = new mysqli("localhost", "root", "", "asterisk");

// Check for connection errors

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

$query = "SELECT now() as now";

// Execute the query and check for errors

$result = $mysqli->query($query);

// Check if the query was successful

if (!$result) {

    die("Query failed: " . $mysqli->error);

}

/* Get the number of fields in the result set */

$field_cnt = $result->field_count;

/* Get the number of rows in the result set */

$row_cnt = $result->num_rows;

/* Fetch associative array */

while ($row = $result->fetch_assoc()) {

    echo "Total of values: Fields = $field_cnt, Rows = $row_cnt, Current Time = $row['now']<br>";

}

$mysqli->close();

?>

----------------

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

// Check for connection errors

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

$result = $mysqli->query("SELECT Name, CountryCode FROM City ORDER BY ID LIMIT 3");

// Check if query was successful

if (!$result) {

    die("Query failed: " . $mysqli->error);

}

// Fetch all rows as an associative array

$rows = $result->fetch_all(MYSQLI_ASSOC);

foreach ($rows as $row) {

    printf("%s (%s)\n", $row["Name"], $row["CountryCode"]);

}

$mysqli->close();

?>

multiquery

<?php

mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);

// Create a connection to the database

$mysqli = new mysqli("localhost", "root", "", "asterisk");

// Check connection

if ($mysqli->connect_error) {

    die("Connection failed: " . $mysqli->connect_error);

}

// Multiple SELECT queries to execute

$query = "SELECT CURDATE() AS DATE;

          SELECT NOW() AS NOW;

          SELECT YEAR(NOW()) AS YEAR";

// Execute multiple queries

if ($mysqli->multi_query($query)) {

    do {

        // Store the result set of each query

        if ($result = $mysqli->store_result()) {

            while ($row = $result->fetch_assoc()) {

                // Correct way to access values from the associative array

                // Here we check if the keys exist and print the results accordingly

                if (isset($row['DATE'])) {

                    echo "DATE: " . $row['DATE'] . " | ";

                }

                if (isset($row['NOW'])) {

                    echo "NOW: " . $row['NOW'] . " | ";

                }

                if (isset($row['YEAR'])) {

                    echo "YEAR: " . $row['YEAR'];

                }

                echo "<br>";

            }

            $result->free(); // Free result set

        }

        // Print divider if there are more results

        if ($mysqli->more_results()) {

            echo "-----------------\n";

        }

    } while ($mysqli->next_result());

}

$mysqli->close(); // Close the database connection

?>