Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $con=mysqli_connect("localhost","root","","mycontacts");
- if (mysqli_connect_errno()) {
- echo "Failed to connect to MySQL: " . mysqli_connect_error();
- }
- $name = mysqli_real_escape_string($con, $_POST['name']);
- $address = mysqli_real_escape_string($con, $_POST['address']);
- $city = mysqli_real_escape_string($con, $_POST['city']);
- $state = mysqli_real_escape_string($con, $_POST['state']);
- $zip = mysqli_real_escape_string($con, $_POST['zip']);
- $phone = mysqli_real_escape_string($con, $_POST['phone'])
- $sql="INSERT INTO Contacts (contac_id, contact_name, contact_address, contact_city,
- contact_state, contact_zip_code, contact_phones, contact_website)
- VALUES ('', '$name', '$address', '$city', '$state', '$zip',
- '$phone', '')";
- if (!mysqli_query($con,$sql)) {
- die('Error: ' . mysqli_error($con));
- }
- header('Location:mainmenu.php');
- session_start();
- $_SESSION['loggedIn'] = true;
- mysqli_close($con);
- ?>
- <form action="insert.php" method='post'>
- <table width="250">
- <tr>
- <p>
- <td align="right" valign="middle">
- Name:
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="name" />
- </td>
- </p>
- </tr>
- <tr>
- <p>
- <td align="right" valign="middle">
- Address:
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="address" />
- </td>
- </p>
- </tr>
- <tr>
- <p>
- <td align="right" valign="middle">
- City:
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="city" />
- </td>
- </p>
- </tr>
- <tr>
- <p>
- <td align="right" valign="middle">
- State:
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="state" />
- </td>
- </p>
- <tr>
- <p>
- <td align="right" valign="middle">
- Zip:
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="zip" maxlength='10'/>
- </td>
- </p>
- </tr>
- <tr>
- <p>
- <td align="right" valign="middle">
- Phone
- </td>
- <td align="right" valign="middle">
- <input type="text" class= "textbox" name="phone" />
- </td>
- </p>
- </tr>
- <tr>
- <td colspan="2">
- <center>
- <br>
- <input type='submit' class= "submitbutton" value="Submit"/>
- ( ! ) Notice: Undefined index: name in D:wampwwwit665insert.php on line 7
- ( ! ) Notice: Undefined index: address in D:wampwwwit665insert.php on line 8
- ( ! ) Notice: Undefined index: city in D:wampwwwit665insert.php on line 9
- ( ! ) Notice: Undefined index: state in D:wampwwwit665insert.php on line 10
- ( ! ) Notice: Undefined index: zip in D:wampwwwit665insert.php on line 11
- ( ! ) Notice: Undefined index: phone in D:wampwwwit665insert.php on line 12
- INSERT INTO Contacts (contac_id, contact_name, contact_address, contact_city,
- contact_state, contact_zip_code, contact_phones, contact_website) VALUES ('', '', '',
- '', '', '', '', '')
Add Comment
Please, Sign In to add comment