homepage Welcome to WebmasterWorld Guest from 23.22.204.36
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Form And PHP Code To Get Upto 15 Values Into A Normalize DB At Once
MySQL PHP Form Help
fizanos




msg:4147053
 6:16 pm on Jun 4, 2010 (gmt 0)

Hello guys, pls i need a Form And PHP Code To Get Upto 15 Values Into A Normalize DB At Once
Sample Attached

MySQL DB Syntax

--
-- Table structure for table `litorder`
--

CREATE TABLE IF NOT EXISTS `litorder` (
`order_ID` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Order identification number',
`order_Name` varchar(45) NOT NULL COMMENT 'Column holds name of person who placed order\n',
`order_Address` varchar(45) NOT NULL COMMENT 'Holds the address of the indivudal who placed order',
`order_Date` date NOT NULL COMMENT 'Date of order',
`order_Reference` varchar(45) NOT NULL,
`order_Naira` double NOT NULL,
`order_Dollars` double NOT NULL,
PRIMARY KEY (`order_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table which holds basic order details' AUTO_INCREMENT=2 ;

--
-- Dumping data for table `litorder`
--

INSERT INTO `litorder` (`order_ID`, `order_Name`, `order_Address`, `order_Date`, `order_Reference`, `order_Naira`, `order_Dollars`) VALUES
(1, 'Sanyaolu Fisayo', '14 Adegboyega Street Palmgrove Lagos', '2010-05-31', 'DL 001', 85600, 563);

-- --------------------------------------------------------

--
-- Table structure for table `orderdetails`
--

CREATE TABLE IF NOT EXISTS `orderdetails` (
`detail_ID` int(11) NOT NULL AUTO_INCREMENT,
`order_ID` int(10) unsigned NOT NULL,
`item_code` varchar(50) NOT NULL,
`product` varchar(255) NOT NULL,
`quantity` int(20) NOT NULL,
`amount` double(20,2) NOT NULL,
`price` double(20,2) NOT NULL,
PRIMARY KEY (`detail_ID`),
KEY `order_ID` (`order_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `orderdetails`
--

INSERT INTO `orderdetails` (`detail_ID`, `order_ID`, `item_code`, `product`, `quantity`, `amount`, `price`) VALUES
(1, 1, 'DL 001', 'AILMENT & PREVENTION DVD- ENGLISH', 16, 12800.00, 800.00),
(2, 1, 'DL 002', 'AILMENT & PREVENTION DVD- HAUSA', 16, 12800.00, 800.00),
(4, 1, 'DL 003', 'BEAUTY CD', 60000, 20.00, 3000.00);

--
-- Constraints for table `orderdetails`
--
ALTER TABLE `orderdetails`
ADD CONSTRAINT `orderdetails_ibfk_1` FOREIGN KEY (`order_ID`) REFERENCES `litorder` (`order_ID`) ON DELETE CASCADE ON UPDATE CASCADE;

[edited by: dreamcatcher at 5:53 am (utc) on Jun 5, 2010]
[edit reason] No urls please. See TOS. [/edit]

 

sonjay




msg:4147519
 10:36 pm on Jun 5, 2010 (gmt 0)

Show us the code you have so far, and tell us specifically what you're having trouble with.

MikkiMouse




msg:4148161
 2:55 pm on Jun 7, 2010 (gmt 0)

Is php form [phpforms.net] used in this case?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved