API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 6th, 2016
105
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 19.96 KB | None | 0 0
raw download clone embed print report
  1. <!DOCTYPE html>
  2. <?php
  3. ini_set("display_errors", 1);
  4. ini_set("display_startup_errors", 1);
  5. error_reporting(E_ALL);
  6. ?>
  7.  
  8. <html>
  9. <head>
  10. <title>Friends and Family</title>
  11. </head>
  12. <body>
  13.  
  14. <form method="post" action="results.php">
  15. <table cellpadding="0" cellspacing="1">
  16. <tr>
  17. <td colspan="3">
  18. To create a profile, fill out the form and click create.
  19. </td>
  20. </tr>
  21. <tr>
  22. <td colspan="3">
  23. To search for a record, enter a first or last name and then click search.
  24. </td>
  25. </tr>
  26. <tr>
  27. <td colspan="3">
  28. To update a record, fill out the form completely. Use the username of the record you want to update, then click update.
  29. </td>
  30. </tr>
  31. <tr>
  32. <td>&nbsp;
  33. </td>
  34. <td>&nbsp;
  35. </td>
  36. <td>&nbsp;
  37. </td>
  38. </tr>
  39. <tr>
  40. <td align="right">
  41. First Name</td>
  42. <td align="left">
  43. <input type="text" name="fname" size="35" /> </td>
  44. <td>
  45. </td>
  46. </tr>
  47. <tr>
  48. <td align="right">
  49. Last Name</td>
  50. <td align="left">
  51. <input name="lname" type="text" size="35" /></td>
  52. <td>
  53. </td>
  54. </tr>
  55. <tr>
  56. <td align="right">
  57. Phone Number</td>
  58. <td align="left">
  59. <input name="phone" type="text" size="35" /></td>
  60. <td>
  61. </td>
  62. </tr>
  63. <tr>
  64. <td align="right">
  65. Address</td>
  66. <td>
  67. <input name="address" type="text" size="35" /></td>
  68. <td>&nbsp;
  69. </td>
  70. </tr>
  71. <tr>
  72. <td align="right">
  73. City</td>
  74. <td>
  75. <input name="city" type="text" size="35" /></td>
  76. <td>&nbsp;
  77. </td>
  78. </tr>
  79. <tr>
  80. <td align="right">
  81. State</td>
  82. <td>
  83. <select name="state">
  84. <option value="AL">Alabama</option>
  85. <option value="AK">Alaska</option>
  86. <option value="AZ">Arizona</option>
  87. <option value="AR">Arkansas</option>
  88. <option value="CA">California</option>
  89. <option value="CO">Colorado</option>
  90. <option value="CT">Connecticut</option>
  91. <option value="DE">Delaware</option>
  92. <option value="DC">District of Columbia</option>
  93. <option value="FL">Florida</option>
  94. <option value="GA">Georgia</option>
  95. <option value="HI">Hawaii</option>
  96. <option value="ID">Idaho</option>
  97. <option value="IL">Illinois</option>
  98. <option value="IN">Indiana</option>
  99. <option value="IA">Iowa</option>
  100. <option value="KS">Kansas</option>
  101. <option value="KY">Kentucky</option>
  102. <option value="LA">Louisiana</option>
  103. <option value="ME">Maine</option>
  104. <option value="MD">Maryland</option>
  105. <option value="MA">Massachusetts</option>
  106. <option value="MI">Michigan</option>
  107. <option value="MN">Minnesota</option>
  108. <option value="MS">Mississippi</option>
  109. <option value="MO">Missouri</option>
  110. <option value="MT">Montana</option>
  111. <option value="NE">Nebraska</option>
  112. <option value="NV">Nevada</option>
  113. <option value="NH">New Hampshire</option>
  114. <option value="NJ">New Jersey</option>
  115. <option value="NM">New Mexico</option>
  116. <option value="NY">New York</option>
  117. <option value="NC">North Carolina</option>
  118. <option value="ND">North Dakota</option>
  119. <option value="OH">Ohio</option>
  120. <option value="OK">Oklahoma</option>
  121. <option value="OR">Oregon</option>
  122. <option value="PA">Pennsylvania</option>
  123. <option value="RI">Rhode Island</option>
  124. <option value="SC">South Carolina</option>
  125. <option value="SD">South Dakota</option>
  126. <option value="TN">Tennessee</option>
  127. <option value="TX">Texas</option>
  128. <option value="UT">Utah</option>
  129. <option value="VT">Vermont</option>
  130. <option value="VA">Virginia</option>
  131. <option value="WA">Washington</option>
  132. <option value="WV">West Virginia</option>
  133. <option value="WI">Wisconsin</option>
  134. <option value="WY">Wyoming</option>
  135. </select>
  136. </td>
  137. <td>
  138. </td>
  139. </tr>
  140. <tr>
  141. <td align="right">
  142. Zip</td>
  143. <td>
  144. <input name="zip" type="text" size="35" /></td>
  145. <td>&nbsp;
  146. </td>
  147. </tr>
  148. <tr>
  149. <td align="right">
  150. Birthday</td>
  151. <td>
  152. <select name="month">
  153. <option value='January'>January</option>
  154. <option value='February'>February</option>
  155. <option value='March'>March</option>
  156. <option value='April'>April</option>
  157. <option value='May'>May</option>
  158. <option value='June'>June</option>
  159. <option value='July'>July</option>
  160. <option value='August'>August</option>
  161. <option value='September'>September</option>
  162. <option value='October'>October</option>
  163. <option value='November'>November</option>
  164. <option value='December'>December</option>
  165. </select>
  166. <select name="day">
  167. <option value='1'>1</option>
  168. <option value='2'>2</option>
  169. <option value='3'>3</option>
  170. <option value='4'>4</option>
  171. <option value='5'>5</option>
  172. <option value='6'>6</option>
  173. <option value='7'>7</option>
  174. <option value='8'>8</option>
  175. <option value='9'>9</option>
  176. <option value='10'>10</option>
  177. <option value='11'>11</option>
  178. <option value='12'>12</option>
  179. <option value='13'>13</option>
  180. <option value='14'>14</option>
  181. <option value='15'>15</option>
  182. <option value='16'>16</option>
  183. <option value='17'>17</option>
  184. <option value='18'>18</option>
  185. <option value='19'>19</option>
  186. <option value='20'>20</option>
  187. <option value='21'>21</option>
  188. <option value='22'>22</option>
  189. <option value='23'>23</option>
  190. <option value='24'>24</option>
  191. <option value='25'>25</option>
  192. <option value='26'>26</option>
  193. <option value='27'>27</option>
  194. <option value='28'>28</option>
  195. <option value='29'>29</option>
  196. <option value='30'>30</option>
  197. <option value='30'>31</option>
  198. </select>
  199. <select name="year">
  200. <option value='2016'>2016</option>
  201. <option value='2015'>2015</option>
  202. <option value='2014'>2014</option>
  203. <option value='2013'>2013</option>
  204. <option value='2012'>2012</option>
  205. <option value='2011'>2011</option>
  206. <option value='2010'>2010</option>
  207. <option value='2009'>2009</option>
  208. <option value='2008'>2008</option>
  209. <option value='2007'>2007</option>
  210. <option value='2006'>2006</option>
  211. <option value='2005'>2005</option>
  212. <option value='2004'>2004</option>
  213. <option value='2003'>2003</option>
  214. <option value='2002'>2002</option>
  215. <option value='2001'>2001</option>
  216. <option value='2000'>2000</option>
  217. <option value='1999'>1999</option>
  218. <option value='1998'>1998</option>
  219. <option value='1997'>1997</option>
  220. <option value='1996'>1996</option>
  221. <option value='1995'>1995</option>
  222. <option value='1994'>1994</option>
  223. <option value='1993'>1993</option>
  224. <option value='1992'>1992</option>
  225. <option value='1991'>1991</option>
  226. <option value='1990'>1990</option>
  227. <option value='1989'>1989</option>
  228. <option value='1988'>1988</option>
  229. <option value='1987'>1987</option>
  230. <option value='1986'>1986</option>
  231. <option value='1985'>1985</option>
  232. <option value='1984'>1984</option>
  233. <option value='1983'>1983</option>
  234. <option value='1982'>1982</option>
  235. <option value='1981'>1981</option>
  236. <option value='1980'>1980</option>
  237. <option value='1979'>1979</option>
  238. <option value='1978'>1978</option>
  239. <option value='1977'>1977</option>
  240. <option value='1976'>1976</option>
  241. <option value='1975'>1975</option>
  242. <option value='1974'>1974</option>
  243. <option value='1973'>1973</option>
  244. <option value='1972'>1972</option>
  245. <option value='1971'>1971</option>
  246. <option value='1970'>1970</option>
  247. <option value='1969'>1969</option>
  248. <option value='1968'>1968</option>
  249. <option value='1967'>1967</option>
  250. <option value='1966'>1966</option>
  251. <option value='1965'>1965</option>
  252. <option value='1964'>1964</option>
  253. <option value='1963'>1963</option>
  254. <option value='1962'>1962</option>
  255. <option value='1961'>1961</option>
  256. <option value='1960'>1960</option>
  257. <option value='1959'>1959</option>
  258. <option value='1958'>1958</option>
  259. <option value='1957'>1957</option>
  260. <option value='1956'>1956</option>
  261. <option value='1955'>1955</option>
  262. <option value='1954'>1954</option>
  263. <option value='1953'>1953</option>
  264. <option value='1952'>1952</option>
  265. <option value='1951'>1951</option>
  266. </select>
  267. </td>
  268. <td>&nbsp;
  269. </td>
  270. </tr>
  271. <tr>
  272. <td align="right">Username: </td>
  273. <td><input name="myusername" type="text" maxlength="15"></td>
  274. </tr>
  275. <tr>
  276. <td align="right">Password: </td>
  277. <td><input name="mypassword" type="password"></td>
  278. </tr>
  279. <tr>
  280. <td align="right">Sex: </td>
  281. <td><input name="sex" type="radio" checked="checked" value="M">Male <input name="sex" type="radio" value="F">Female</td>
  282. </tr>
  283. <tr>
  284. <td align="right" >
  285. Relationship</td>
  286. <td>
  287. <select name="relation">
  288. <option value="friend">Friend</option>
  289. <option value="boy friend">Boy Friend</option>
  290. <option value="girl friend">Girl Friend</option>
  291. <option value="grand">GrandParent</option>
  292. <option value="child">Child</option>
  293. <option value="sibling">Sibling</option>
  294. <option value="parentSib">Aunt/Uncle</option>
  295. <option value="cousin">Cousin</option>
  296. <option value="coworker">Co-worker</option>
  297. <option value="enemy">Enemy</option>
  298. </select>
  299. </td>
  300. </tr>
  301. <tr>
  302. <td></td>
  303. <td>
  304. <table>
  305. <tr>
  306. <td><input type="submit" name="create" value="Create" /></td>
  307. <td><input type="submit" name="search" value="Search" /> </td>
  308. <td><input type="submit" name="update" value="update" /></td>
  309. </tr>
  310. </table>
  311. </td>
  312. <td></td>
  313. </tr>
  314. </table>
  315. </form>
  316. </body>
  317. </html>
  318.  
  319.  
  320.  
  321.  
  322. <?php
  323.  
  324. // INSERT FUNCTION
  325. function insert($conn, $a, $b, $c, $d, $e, $f, $g, $h, $i, $j, $k, $l, $m, $n)
  326. {
  327.  
  328. $query = "INSERT INTO people values('$a','$b','$c','$d','$e','$f',$g,'$h',$i,$j,'$k','$l','$m','$n',NULL)";
  329. $result = $conn->query($query);
  330. if (!$result)
  331. die("Database access failed: " . $conn->error);
  332. echo 'success!';
  333. }
  334.  
  335. require_once 'login.php';
  336. $conn = new mysqli($hn, $un, $pw, $db);
  337. if ($conn->connect_error)
  338. die($conn->connect_error);
  339.  
  340. //CREATE
  341. if (isset($_POST['create']))
  342. {
  343. $fname = $_POST['fname'];
  344. $lname = $_POST['lname'];
  345. $phone = $_POST['phone'];
  346. $address = $_POST['address'];
  347. $city = $_POST['city'];
  348. $state = $_POST['state'];
  349. $zip = $_POST['zip'];
  350. $month = $_POST['month'];
  351. $day = $_POST['day'];
  352. $year = $_POST['year'];
  353. $myusername = $_POST['myusername'];
  354. $mypassword = $_POST['mypassword'];
  355. $sex = $_POST['sex'];
  356. $relation = $_POST['relation'];
  357.  
  358. echo $fname . '<br>';
  359. echo $lname . '<br>';
  360. echo $phone . '<br>';
  361. echo $address . '<br>';
  362. echo $city . '<br>';
  363. echo $state . '<br>';
  364. echo $zip . '<br>';
  365. echo $month . '<br>';
  366. echo $day . '<br>';
  367. echo $year . '<br>';
  368. echo $myusername . '<br>';
  369. echo $mypassword . '<br>';
  370. echo $sex . '<br>';
  371. echo $relation . '<br>';
  372.  
  373. insert($conn, $fname, $lname, $phone, $address, $city, $state, $zip, $month, $day, $year, $myusername, $mypassword, $sex, $relation);
  374. }
  375.  
  376.  
  377. //SEARCH
  378. if (isset($_POST['search']))
  379. {
  380. if (isset($_POST['fname']))
  381. {
  382. $fname = $_POST['fname'];
  383. $query = "SELECT first_name, last_name, phone_number, address, city, state, zip, birth_month, birth_day, birth_year, username, password, sex, relationship, id from people where first_name = '$fname'";
  384. $result = $conn->query($query);
  385.  
  386. $rows = $result->num_rows;
  387. for ($j = 0; $j < $rows; ++$j)
  388. {
  389. $result->data_seek($j);
  390. $row = $result->fetch_array(MYSQLI_NUM);
  391.  
  392. echo <<<_END
  393. <pre>
  394. First Name: $row[0]
  395. Last Name: $row[1]
  396. Phone Number $row[2]
  397. Address $row[3]
  398. City $row[4]
  399. State $row[5]
  400. State $row[5]
  401. Zip $row[6]
  402. Birth month $row[7]
  403. Birth Day $row[8]
  404. Birth Year $row[9]
  405. Username $row[10]
  406. Password $row[11]
  407. Sex $row[12]
  408. Relationship $row[13]
  409. ID $row[14]
  410. </pre>
  411. _END;
  412. if (!$result)
  413. die("Database access failed: " . $conn->error);
  414. echo 'success!';
  415. }
  416. }
  417.  
  418. if (isset($_POST['lname']))
  419. {
  420. $lname = $_POST['lname'];
  421. $query = "SELECT first_name, last_name, phone_number, address, city, state, zip, birth_month, birth_day, birth_year, username, password, sex, relationship, id from people where last_name = '$lname'";
  422. $result = $conn->query($query);
  423.  
  424. $rows = $result->num_rows;
  425. for ($j = 0; $j < $rows; ++$j)
  426. {
  427. $result->data_seek($j);
  428. $row = $result->fetch_array(MYSQLI_NUM);
  429.  
  430. echo <<<_END
  431. <pre>
  432. First Name: $row[0]
  433. Last Name: $row[1]
  434. Phone Number $row[2]
  435. Address $row[3]
  436. City $row[4]
  437. State $row[5]
  438. State $row[5]
  439. Zip $row[6]
  440. Birth month $row[7]
  441. Birth Day $row[8]
  442. Birth Year $row[9]
  443. Username $row[10]
  444. Password $row[11]
  445. Sex $row[12]
  446. Relationship $row[13]
  447. ID $row[14]
  448. </pre>
  449. _END;
  450.  
  451.  
  452. if (!$result)
  453. die("Database access failed: " . $conn->error);
  454. echo 'success!';
  455. }
  456. }
  457. }
  458.  
  459.  
  460. // UPDATE
  461. if (isset($_POST['update']))
  462. {
  463. $username = $_POST['myusername'];
  464. $run_the_query = FALSE;
  465.  
  466. $fname = $_POST['fname'];
  467. $lname = $_POST['lname'];
  468. $phone = $_POST['phone'];
  469. $address = $_POST['address'];
  470. $city = $_POST['city'];
  471. $state = $_POST['state'];
  472. $zip = $_POST['zip'];
  473. $month = $_POST['month'];
  474. $day = $_POST['day'];
  475. $year = $_POST['year'];
  476. $myusername = $_POST['myusername'];
  477. $mypassword = $_POST['mypassword'];
  478. $sex = $_POST['sex'];
  479. $relation = $_POST['relation'];
  480.  
  481. $my_string = "UPDATE people SET first_name = '$fname', last_name = '$lname', phone_number = '$phone', address = '$address', city = '$city', state = '$state', zip = '$zip', birth_month = '$month', birth_day = '$day', birth_year = '$year', password = '$mypassword', sex = '$sex', relationship = '$relation' WHERE username = '$username'";
  482. $result = $conn->query($my_string);
  483. }
  484. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!