Advertisement
Guest User

Untitled

a guest
May 5th, 2015
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.42 KB | None | 0 0
  1. mysqli_query ($dbconn, "INSERT INTO `forado` (`dogfa_title`, `dogfa_stat`, `dogfa_pic`, `dogfa_breed1`, `dogfa_breed2`, `dogfa_colour`, `dogfa_age`, `dogfa_sex`, `dogfa_neuter`, `dogfa_fee`, `dogfa_medical`, `dogfa_info`, `dogfa_pcode`, `dogfa_foster`) VALUES('$title', 'Open', '$pic', '$breed1', '$breed2', '$colour', '$age', '$sex', '$neuter', '$fee', '$med', '$info', '$pcode', '$foster')");
  2.  
  3. CREATE TABLE `forado` (
  4. `dogfa_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  5. `dogfa_title` varchar(100) NOT NULL,
  6. `dogfa_stat` enum('Open','Closed') NOT NULL,
  7. `dogfa_pic` varchar(200) NOT NULL DEFAULT 'inc/defpic.png',
  8. `dogfa_breed1` varchar(80) NOT NULL,
  9. `dogfa_breed2` varchar(80) DEFAULT NULL,
  10. `dogfa_colour` enum('Brown','Red','Gold','Yellow','Cream','Black','Blue','Grey','White','Bi-colour','Tri-colour','Merle','Spotted','Speckled','Brindle','Sable','Roan','Harlequin') NOT NULL,
  11. `dogfa_age` varchar(20) NOT NULL,
  12. `dogfa_sex` enum('Male','Female') NOT NULL,
  13. `dogfa_neuter` enum('Yes','No') NOT NULL,
  14. `dogfa_fee` decimal(7,2) NOT NULL DEFAULT '0.00',
  15. `dogfa_medical` text,
  16. `dogfa_info` text,
  17. `dogfa_pcode` varchar(8) NOT NULL,
  18. `dogfa_foster` bigint(20) unsigned NOT NULL,
  19. PRIMARY KEY (`dogfa_id`),
  20. KEY `dogfa_breed1` (`dogfa_breed1`),
  21. KEY `dogfa_breed2` (`dogfa_breed2`),
  22. KEY `dogfa_foster` (`dogfa_foster`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
  24.  
  25. $fee = $_POST['newpound'].".".$_POST['newpenny'];
  26. $fee = (float)$fee;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement