Hi,
I want insert data(1,1,1,1) to mysql(open,heat,up,down) by php,here is my php
<?php
$servername = "localhost";
$username = "idxxxxxxx";
$password = "xxxxxxx";
$dbname = "idxxxxxxxx";
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$insert = "INSERT INTO idxxxxxxxx.data(open,heat,up,down)value('1','1','1','1')" or die(mysql_error());
mysql_query($insert);
?>
but it always show
This page does not work
xxxxxxx.000webhostapp.com is currently unable to process this request.
HTTP ERROR 500
how can I modify my php to insert data into mysql-database