Advertisement
Guest User

Untitled

a guest
Apr 22nd, 2018
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. INSERT INTO User VALUES ('.$_POST['Email'].', '.$_POST['Username'].', '.$_POST['Password'].', OWNER);
  2. '.$_POST['ID'].' = SELECT MAX(ID) FROM Proerty;
  3. '.$_POST['ID+1'].' = '.$_POST['ID'].' + 1
  4. INSERT INTO Property VALUES ('.$_POST['ID+1'].', '.$_POST['Property Name'].', '.$_POST['Acres'].',
  5. '.$_POST['Public?'].', '.$_POST['Commercial?'].','.$_POST['Street Address'].', '.$_POST['City'].', '.$_POST['Zip'].', '.$_POST['Property Type'].'
  6. '.$_POST['Username'].', NULL,);
  7. --If Farm
  8. --NEED TO FIX ID PART --
  9. INSERT INTO Has VALUES (ID, '.$_POST['Animal'].');
  10. INSERT INTO Has VALUES (ID, '.$_POST['Crop'].');
  11. --If Orchard or Garden
  12. --NEED TO FIX ID PART--
  13. INSERT INTO Has VALUES (ID, '.$_POST['Crop'].');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement