Simple Web Service Using PHP + MYQSQL + JSON + CURL. Part 1 - Preparation

Level : Beginner

1.     Make sure curl extension installed.

2.     DB Schema

CREATE TABLE IF NOT EXISTS `stockprices` (
  `stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_symbol` char(3) NOT NULL,
  `stock_price` decimal(8,2) NOT NULL,
  PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `stockprices`
--

INSERT INTO `stockprices` (`stock_id`, `stock_symbol`, `stock_price`) VALUES
(1, 'ABC', '75.00'),
(2, 'DEF', '45.00'),
(3, 'GHI', '12.00'),
(4, 'JKL', '34.00');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; 

Next - Simple Web Service Using PHP + MYQSQL + JSON + CURL. Part 2 - Server