Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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')");
- CREATE TABLE `forado` (
- `dogfa_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
- `dogfa_title` varchar(100) NOT NULL,
- `dogfa_stat` enum('Open','Closed') NOT NULL,
- `dogfa_pic` varchar(200) NOT NULL DEFAULT 'inc/defpic.png',
- `dogfa_breed1` varchar(80) NOT NULL,
- `dogfa_breed2` varchar(80) DEFAULT NULL,
- `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,
- `dogfa_age` varchar(20) NOT NULL,
- `dogfa_sex` enum('Male','Female') NOT NULL,
- `dogfa_neuter` enum('Yes','No') NOT NULL,
- `dogfa_fee` decimal(7,2) NOT NULL DEFAULT '0.00',
- `dogfa_medical` text,
- `dogfa_info` text,
- `dogfa_pcode` varchar(8) NOT NULL,
- `dogfa_foster` bigint(20) unsigned NOT NULL,
- PRIMARY KEY (`dogfa_id`),
- KEY `dogfa_breed1` (`dogfa_breed1`),
- KEY `dogfa_breed2` (`dogfa_breed2`),
- KEY `dogfa_foster` (`dogfa_foster`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
- $fee = $_POST['newpound'].".".$_POST['newpenny'];
- $fee = (float)$fee;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement