MySQL CREATE TABLE Statement

MySQL CREATE TABLE Statement The MySQL CREATE TABLE Statement The CREATE TABLE statement is used to create a new table in a database. Syntax CREATE TABLE table_name (     column1 datatype,     column2 datatype,     column3 datatype, …. ); The column parameters specify the names of the columns of the table. The datatype parameter specifies the type of data the … Read more

Insert Data From a Form Into a Database

iNet Expert Technology

Now we will create an HTML form that can be used to add new records to the “Persons” table. Here is the HTML form: <html> <body> <form action=”insert.php” method=”post”> Firstname: <input type=”text” name=”firstname”> Lastname: <input type=”text” name=”lastname”> Age: <input type=”text” name=”age”> <input type=”submit”> </form> </body> </html> When a user clicks the submit button in the … Read more