This question already has an answer here:
I'm actively learning mysql/php/arduino and trying to do some simple things to get me going. So far I have: created a database (works), created a table (doesn't work), inserted data (works), displayed data (doesn't work).
<?php
$servername="localhost";
$username="YUN";
$password="12345678";
$dbname = "yundatabasee";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if(!$conn) {
die("connessione fallita" .mysqli_connect_error());
}
$sql = "CREATE TABLE YunDati(
id INT (6) UNSIGNED AUTO INCREMENT PRIMARY KEY,
yunName VARCHAR (20) NOT NULL,
digitalIn VARCHAR (2),
analogIn VARCHAR (5),
leggi_data TIMESTAMP
)";
if (mysqli_query($conn, $sql)) {
echo "Tabella creata";
} else {
echo "Mi dispiace tabella non e' stata creata :P" .mysqli_error($conn);
}
mysqli_close($conn);
?>
Mi dispiace tabella non e' stata creata.
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AUTO INCREMENT PRIMARY KEY, yunName VARCHAR (20) NOT NULL, digitalIn VARCHAR (2)' at line 2
<?php
$servername="localhost";
$username="YUN";
$password="12345678";
$dbname = "yundatabasee";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("connessione fallita" .mysqli_connect_error());
}
$sql = "SELECT id, yunName,digitalIn, analogIn, leggi_data FROM YunDati";
$result = mysqli_query($conn, $sql);
if (mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result){
echo"id : ".$row["id"]."- Nome".$row["yunName"]."-Analog In".$row["analogIn"]."<br>";
}
} else {
echo "nessun risultato";
}
mysqli_close($conn);
?>
Parse error: syntax error, unexpected '{' in /opt/lampp/htdocs/YUNest/Mostradati.php on line 20
</div>