000webhost database values insert

<?php
$servername = "localhost";
$username = "xxxx";
$password = "xxxx";
$dbname = "xxxx";

try {
    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $sql = "INSERT INTO data (open, heat, up, down)
    VALUES ('1', '1', '1', '1')";
    // use exec() because no results are returned
    $conn->exec($sql);
    echo "New record created successfully";
    }
catch(PDOException $e)
    {
    echo $sql . "<br>" . $e->getMessage();
    }

$conn = null;
?>

Source: 000webhost.com

Similar codes

1 vote158 views1 answer
Mysql select utc time in eastern time
SQL
0 vote146 views1 answer
Equi joins in oracle
SQL
0 vote171 views1 answer
Data types mysql vs postgresql
SQL
15 votes157 views2 answers
Open postgress in terminal mac
SQL
11 votes156 views1 answer
Sql query to find duplicates in column
SQL
0 vote174 views1 answer
Python sqlalchemy connection show server
SQL
-1 vote157 views1 answer
Auto increment psql not primary key
SQL
2 votes162 views1 answer
Mysql application.properties spring boot
SQL
3 votes187 views2 answers
Find string in stored procedure sql server
SQL
2 votes206 views1 answer
Mysql now format
SQL