Zend Framework Database: Creating Input Form »

Web Services .NET Grid: Preparing Database

Web Services PHP - Grid .NET Step By Step Tutorial - Part 2: For this practice, we use database. From this database, we get data. All of record will be convert to a line with string format. This is its database:

First, create a database named "test". Then, create a table named "books". The query is:

CREATE TABLE `books` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(150) NOT NULL,
  `author` varchar(150) NOT NULL
  PRIMARY KEY  (`id`)
);

You can use phpMyAdmin to easy job.

Then, insert sample data such as:

INSERT INTO `books` (`id`, `title`, `author`) VALUES (1, 'PHP AJAX', 'Andreas');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (2, 'PHP Eclipse ', 'George');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (3, 'PHP Prado', 'Junyian');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (4, 'PHP Zend Framework', 'Ozulian');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (5, 'PHP Web Services', 'Bobi');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (6, 'PHP API', 'Hugo');
INSERT INTO `books` (`id`, `title`, `author`) VALUES (7, 'PHP SEO', 'Monteo');

Database Tutorial

Security Tutorial

Framework Tutorial

Template Tutorial

API Tutorial

Learn Facebook

JS Framework Tutorial

AJAX Tutorial

Web Services Tutorial

Package Post