Alright everyone, i'm just starting PHP and SQL...
I want to have a textbox and a submit button to be stored in a Database in MySQL.
For some reason it's not working, can anyone take a look at the PHP and tell me if there's something wrong?
Thanks
HTML:
<!DOCTYPE html><html><body><center><form action="action_page.php" method="post">Target:<br><input type="text" name="target1" value=""><br><br><input type="submit" value="Submit"></form> </body></html>
PHP:
<?php$servername = "serverIP";$username = "root";$password = "mysqldbpassword";$dbname = "mysql";// Create connection$conn = new mysqli($servername, $username, $password, $dbname);// Check connectionif ($conn->connect_error) { die("Connection failed: " . $conn->connect_error);} $sql = "INSERT INTO db ('name')$VALUES ('target1');if ($conn->query($sql) === TRUE) { echo "New record created successfully";} else { echo "Error: " . $sql . "<br>" . $conn->error;}$conn->close();?>