MySQL Form his assignment you will be making a form that will do one of three th
ID: 664751 • Letter: M
Question
MySQL Form
his assignment you will be making a form that will do one of three things in a database
- It will add a record
- It will update a record
- It will search for a record
Your database will contain a table for keeping a record of all your friends and family and should contain:
First name
Last name
Phone number
Address
City
State
Zip
Birthdate
Username
Password
The sex of the person
And the relationship
You should also keep a primary key for the user
You will then have two pages a friends and family form page and a results page
The form will ask the user to enter the information and then choose to either
Create a new record
Update and existing record
Search for a record
The results page will display the information that they are requesting with either adding a record, updating it or displaying the results of a record.
Your page need to deliver the PHP files in a zipped format
this is a form sample how it needs to look like http://ec2-54-69-116-125.us-west-2.compute.amazonaws.com/TheMePage/FriendFamilyForm.php
Explanation / Answer
HTML
<!DOCTYPE html>
<html>
<head>
<title>Registration</title>
<body>
<header>
<h2>Registration Here</h2>
</header>
<form id="Registration" method="post" action="register.php">
<table cellpadding="0" cellspacing="1">
<tr>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
<tr>
<td align="right">
First Name</td>
<td align="left">
<input id="fname" type="text" name="fname" size="35" /> </td>
<td>
</td>
</tr>
<tr>
<td align="right">
Last Name</td>
<td align="left">
<input id="lname" name="lname" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
Phone Number</td>
<td align="left">
<input id="phone" name="phone" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
Address</td>
<td>
<input id="address" name="address" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
City</td>
<td>
<input id="city" name="city" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
Statte</td>
<td>
<input id="State" name="State" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
Zip</td>
<td>
<input id="zip" name="zip" type="text" size="35" /></td>
<td>
</td>
</tr>
<tr>
<td align="right">
Birthday</td>
<td><select name="month">
<option value='1'>1</option><option value='2'>2</option><option value='3'>3</option><option value='4'>4</option><option value='5'>5</option><option value='6'>6</option><option value='7'>7</option><option value='8'>8</option><option value='9'>9</option><option value='10'>10</option><option value='11'>11</option><option value='12'>12</option> </select>
<select name="day">
<option value='1'>1</option><option value='2'>2</option><option value='3'>3</option><option value='4'>4</option><option value='5'>5</option><option value='6'>6</option><option value='7'>7</option><option value='8'>8</option><option value='9'>9</option><option value='10'>10</option><option value='11'>11</option><option value='12'>12</option><option value='13'>13</option><option value='14'>14</option><option value='15'>15</option><option value='16'>16</option><option value='17'>17</option><option value='18'>18</option><option value='19'>19</option><option value='20'>20</option><option value='21'>21</option><option value='22'>22</option><option value='23'>23</option><option value='24'>24</option><option value='25'>25</option><option value='26'>26</option><option value='27'>27</option><option value='28'>28</option><option value='29'>29</option><option value='30'>30</option> </select>
<select name="year">
<option value='2015'>2015</option><option value='2014'>2014</option><option value='2013'>2013</option><option value='2012'>2012</option><option value='2011'>2011</option><option value='2010'>2010</option><option value='2009'>2009</option><option value='2008'>2008</option><option value='2007'>2007</option><option value='2006'>2006</option><option value='2005'>2005</option><option value='2004'>2004</option><option value='2003'>2003</option><option value='2002'>2002</option><option value='2001'>2001</option><option value='2000'>2000</option><option value='1999'>1999</option><option value='1998'>1998</option><option value='1997'>1997</option><option value='1996'>1996</option><option value='1995'>1995</option><option value='1994'>1994</option><option value='1993'>1993</option><option value='1992'>1992</option><option value='1991'>1991</option><option value='1990'>1990</option><option value='1989'>1989</option><option value='1988'>1988</option><option value='1987'>1987</option><option value='1986'>1986</option><option value='1985'>1985</option><option value='1984'>1984</option><option value='1983'>1983</option><option value='1982'>1982</option><option value='1981'>1981</option><option value='1980'>1980</option><option value='1979'>1979</option><option value='1978'>1978</option><option value='1977'>1977</option><option value='1976'>1976</option><option value='1975'>1975</option><option value='1974'>1974</option><option value='1973'>1973</option><option value='1972'>1972</option><option value='1971'>1971</option><option value='1970'>1970</option><option value='1969'>1969</option><option value='1968'>1968</option><option value='1967'>1967</option><option value='1966'>1966</option><option value='1965'>1965</option><option value='1964'>1964</option><option value='1963'>1963</option><option value='1962'>1962</option><option value='1961'>1961</option><option value='1960'>1960</option><option value='1959'>1959</option><option value='1958'>1958</option><option value='1957'>1957</option><option value='1956'>1956</option><option value='1955'>1955</option><option value='1954'>1954</option><option value='1953'>1953</option><option value='1952'>1952</option><option value='1951'>1951</option> </select>
</td>
<td>
</td>
</tr>
<tr>
<td align="right">Username: </td>
<td><input name="myusername" type="text" id="myusername" maxlength="15"><span id="user-result"></span>
</td>
</tr>
<tr>
<td align="right">Password: </td>
<td><input name="mypassword" type="password" id="mypassword"></td>
</tr>
<tr>
<td align="right">Sex: </td>
<td><input name="sex" type="radio" checked="checked" value="Male">Male <input name="sex" type="radio" id="mypassword" value="Female">Female</td>
</tr>
<tr>
<td align="right" >
Relationship</td>
<td class="selection">
<select name="relation">
<option value="friend">Friend</option>
<option value="grand">GrandParent</option>
<option value="child">Child</option>
<option value="sibling">Sibling</option>
<option value="parentSib">Aunt/Uncle</option>
<option value="cousin">Cousin</option>
<option value="coworker">Co-worker</option>
<option value="enemy">Enemy</option>
<option value="other">Other</option>
option value="Husband">Husband</option>
option value="Wife">Wife</option>
</select>
</td>
</tr>
<tr>
<td></td>
<td>
<table>
<tr>
<td> <input id="button_Search" type="submit" value="Search" name="requestType"/> </td>
<td><input id="Button_update" type="submit" value="Update" name="requestType" /></td>
<td><input id="Button_Input" type="submit" value="Create" name="requestType"/></td>
</tr>
</table>
</td>
<td></td>
</tr>
</table>
</form>
</section>
</div>
</div>
</div>
</body>
</html>
Function for Display,Add and update
ADD Value
<?php
if($_SERVER["REQUEST_METHOD"] == "POST"){
$fname = mysql_real_escape_string($_POST['fname']);
$lname = mysql_real_escape_string($_POST['lname']);
$phone = mysql_real_escape_string($_POST['phone']);
$address= mysql_real_escape_string($_POST['address']);
$city = mysql_real_escape_string($_POST['city']);
$state = mysql_real_escape_string($_POST['state']);
$zip = mysql_real_escape_string($_POST['zip']);
$month = mysql_real_escape_string($_POST['month']);
$day = mysql_real_escape_string($_POST['day']);
$year = mysql_real_escape_string($_POST['year']);
$myusername = mysql_real_escape_string($_POST['myusername']);
$mypassword = mysql_real_escape_string($_POST['mypassword']);
$sex = mysql_real_escape_string($_POST['sex']);
$relation = mysql_real_escape_string($_POST['relation']);
$public = "no";
$bool = true;
mysql_connect("localhost", "root","") or die(mysql_error()); //Connect to server
mysql_select_db("first_db") or die("Cannot connect to database"); //Connect to database
$query = mysql_query("Select * from users"); //Query the users table
$exists = mysql_num_rows($query); //Checks if username exists
$table_fname = "";
$table_lname = "";
$table_phone = "";
$table_address = "";
$table_city = "";
$table_state = "";
$table_zip = "";
$table_month = "";
$table_day = "";
$table_year = "";
$table_users = "";
$table_password = "";
$table_sex = "";
$table_relation = "";
if($exists > 0) //IF there are no returning rows or no existing username
{
while($row = mysql_fetch_assoc($query)) // display all rows from query
{
$table_fname = $row['fname'];
$table_lname = $row['lname'];
$table_phone = $row['phone'];
$table_address = $row['address'];
$table_city = $row['city'];
$table_state = $row['state'];
$table_zip = $row['zip'];
$table_month = $row['month'];
$table_day = $row['day'];
$table_year = $row['year'];
$table_users = $row['myusername'];
$table_password = $row['mypassword'];
$table_sex = $row['sex'];
$table_relation = $row['relation'];
$id = $_SESSION['id'];
}
while($row = mysql_fetch_array($query)) //display all rows from query
{
$table_myusername = $row['myusername']; // the first username row is passed on to $table_myusername, and so on until the query is finished
if(($fname == $table_fname) && ($lname == $table_lname))&&($phone == $table_phone) && ($address == $table_address) && ($city == $table_city) &&
($state == $table_state) && ($zip == $table_zip) && ($month == $table_month) && ($day == $table_day) && ($year == $table_year)
&& ($myusername == $table_users) && ($mypassword == $table_password) && ($sex == $table_sex) && ($relation == $table_relation))// checks if there are any matching fields
{
if($mypassword == $table_password)
{
$_SESSION['myusername'] = $myusername; //set the username in a session. This serves as a global variable
header("location: register.php"); // redirects the user to the authenticated home page
}
}
if($bool) // checks if bool is true
{
mysql_query("INSERT INTO users (fname, lname, phone, address, city, state, zip, month, day, year, myusername, mypassword, sex, relation) VALUES ('$fname','$lname','$phone','$address','$city','$state','$zip','$month','$day','$year','$myusername','$mypassword','$sex','$relation')"); //Inserts the value to table users
Print '<script>alert("Successfully Registered!");</script>'; // Prompts the user
Print '<script>window.location.assign("register.php");</script>'; // redirects to register.php
}
foreach($_POST['public'] as $list)
{
if($list != null)
{
$public = "yes";
}
}
mysql_query("UPDATE list SET fname='$fname', lname='$lname', phone='$phone', address='$address', city='$city', state='$state', zip='$zip', month='$month', day='$day', year='$year', myusername='$myusername', mypassword='$mypassword', sex='$sex', 'relation='$relation' WHERE id='$id'");
header("location:register.php");
}
}
?>
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.