· 8 years ago · Aug 05, 2018, 03:04 AM
1<?php
2$con = mysql_connect ("localhost","root","tk421");
3if (!$con) {
4 die ('Could not oconnect: ' . mysql_error());
5}
6
7/* if (mysql_query("CREATE DATABASE my_db",$con)) {
8 echo "Database created.";
9}
10else {
11 if (mysql_error() == "Can't create database 'my_db'; database exists") {
12 }
13 else {
14 echo "Error created database: " . mysql_error();
15 }
16} */
17
18mysql_select_db ("my_db",$con);
19/* $sql = "CREATE TABLE Persons
20(
21 personID int NOT NULL AUTO_INCREMENT,
22 PRIMARY KEY (personID),
23 FirstName varchar(30),
24 LastName varchar(30),
25 age int
26)"; */
27
28mysql_query ("INSERT INTO Persons (FirstName, LastName, age) VALUES ('Derp', 'Derpson', 17)");
29mysql_query("INSERT INTO Persons (FirstName, LastName, age) VALUES ('Peter', 'Griffin',35)");
30mysql_close ($con);
31echo "SQL Query closed";
32?>