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

0 vote147 views1 answer
Stratified sampling sql
SQL
0 vote173 views2 answers
Install phoenix
SQL
0 vote150 views1 answer
Set engine to innodb
SQL
0 vote140 views1 answer
See Foreign Key
SQL
58 votes319 views6 answers
Create new user in postgres
SQL
3 votes144 views2 answers
Sql get month name
SQL
16 votes146 views3 answers
Update table from another table
SQL
12 votes139 views2 answers
Insert multiple rows from another table sql
SQL
32 votes164 views6 answers
Rename column mysql
SQL
1 vote127 views1 answer
Can not connect to mysql server
SQL