Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $host = "localhost";
- $username = "root";
- $password = "";
- $database = "database_name";
- $table = "table_name";
- mysql_connect($host, $username, $password) or die();
- $selectDB = mysql_select_db($database);
- $selectTable = mysql_query("SELECT * FROM `" . $table . "`")
- if (!isset($_POST['send'])) { ?>
- <form method="post">
- First Name: <input type="text" value="" name="firstname" /><br />
- Last Name: <input type="text" value="" name="lastname" /><br />
- Age: <input type="text" value="" name="age" /><br />
- <input type="submit" value="Submit" name="send" />
- </form>
- <? } else {
- if (!$selectDB) {
- echo "The database does not exist!";
- } elseif(!$selectTable) {
- mysql_query("CREATE TABLE `" . $table . "` (firstname varchar(25), lastname varchar(25), age int");
- echo "Table not present... creating. Please press back and try again.";
- } else {
- $firstname = $_POST['firstname'];
- $lastname = $_POST['lastname'];
- $age = $_POST['age'];
- mysql_query("INSERT INTO `" . $table . "` (firstname, lastname, age) VALUES(" . $firstname . ", " . $lastname . ", " . $age . ")");
- echo "Successfully inserted data!";
- }
- }
- ?>
Add Comment
Please, Sign In to add comment