Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- // Database Connection Details //
- $db_host = 'localhost';
- $db_user = 'root';
- $db_pass = 'apriljoey';
- $db_name = 'webform';
- // Database Connection //
- $db_connect = mysqli_connect($db_host, $db_user, $db_password, $db_name)
- or die('Error connecting to the database. See datainsert.php.');
- $sql = "INSERT INTO webtable(Trans_Time, Trans_date, Agent_Name, National_Grid_Account_no, Con_Edison_Account_no, Name_on_Bill, Contact_Person, Address, Phone_no, Notes)
- VALUES('$_POST[txtTime]','$_POST[txtDate]', '$_POST[txtAgent]', '$_POST[txtNationalGrid]', '$_POST[txtConEdison]','$_POST[txtNameBill]', '$_POST[txtContactPerson]', '$_POST[txtAddress]','$_POST[txtPhone]','$_POST[txtNotes]')";
- $result = mysqli_query($db_connect, $sql)
- or die('Error adding data to database. Check datainsert.php');
- if($result == true) echo 'Successfully added information to database!';
- mysqli_close($db_connect);
- ?>
- <html>
- <form action = "webform.php"/>
- <input type = "submit" name = "cmd" values = "Back to Homepage to Input another record."/>
- </form>
- </html>
Add Comment
Please, Sign In to add comment