Login   Register  
PHP Classes
elePHPant
Icontem

File: datagrid.sql

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Sérgio Micaelo Soares  >  Data Grid nav  >  datagrid.sql  >  Download  
File: datagrid.sql
Role: Auxiliary data
Content type: text/plain
Description: The sql for this example
Class: Data Grid nav
Display MySQL query results in an HTML table
Author: By
Last change:
Date: 2 years ago
Size: 2,881 bytes
 

Contents

Class file image Download
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Máquina: localhost
-- Data de Criação: 11-Out-2011 às 18:00
-- Versão do servidor: 5.1.41
-- versão do PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


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

--
-- Base de Dados: `datagrid`
--

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

--
-- Estrutura da tabela `produtos`
--

CREATE TABLE IF NOT EXISTS `produtos` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(300) NOT NULL,
  `titulo` varchar(150) NOT NULL,
  `texto` varchar(500) NOT NULL,
  `preco` decimal(18,0) NOT NULL,
  `categoria` varchar(50) NOT NULL,
  `menu` int(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=114 ;

--
-- Extraindo dados da tabela `produtos`
--

INSERT INTO `produtos` (`id`, `url`, `titulo`, `texto`, `preco`, `categoria`, `menu`) VALUES
(96, 'images/ofb3t6y48.jpg', '8', '8', '8', '236', 217),
(94, 'images/d5qxy3vz6.jpg', '6', '6', '6', '236', 217),
(95, 'images/ewz4uxs27.jpg', '7', '7', '7', '236', 217),
(93, 'images/9twizui85.jpg', '5', '5', '5', '236', 217),
(92, 'images/udlqr5pm4.jpg', '4', '4', '44', '236', 217),
(113, 'images/qdkzt8l53.jpg', 'cfyvktgyv', 'aaaaaaaaaaa', '999999999999999', '241', 221),
(84, 'images/q9auog8f1.jpg', '111', '111', '111', '234', 217),
(85, 'images/okg85fbw2.jpg', '22', '22', '22', '234', 217),
(88, 'images/ypcepr7k9.jpg', '239', '239', '239', '237', 219),
(89, 'images/kruo3fal2.jpg', '222', '222', '222', '236', 217),
(90, 'images/igs2tkzk3.jpg', '333', '333', '333', '234', 217),
(97, 'images/42g85fd99.jpg', '9', '9', '9', '236', 217),
(98, 'images/xcjjarj410.jpg', '10', '10', '10', '236', 217),
(99, 'images/y3e6j5ik11.jpg', '11', '11', '11', '236', 217),
(100, 'images/e6ewgyo212.jpg', '12', '12', '12', '236', 217),
(101, 'images/6q9uia1b12.jpg', '10', '10', '10', '236', 217),
(102, 'images/esro1zcl7.jpg', 'dg', 'dfg', '0', '236', 217),
(103, 'images/cr7mh7oe11.jpg', 'dfsdfg', 'gsdfg', '0', '236', 217),
(104, 'images/lgt9rfjj6.jpg', 'dfgsdfg', 'fdgsdfg', '0', '236', 217),
(105, 'images/c1kr1wda1.jpg', 'dfgdsfgdfgs', 'dfsgsdfg', '0', '236', 217),
(106, 'images/v2fck9zp6.jpg', 'dfgsdfg', 'fgh', '0', '236', 217),
(107, 'images/saynerve11.jpg', 'fgdgh', 'fghdf', '0', '236', 217),
(108, 'images/4fxe9u187.jpg', 'ertwe', 'rtewr', '0', '236', 217),
(109, 'images/c1u0gqf510.jpg', '10', '10', '10', '236', 217),
(112, 'images/pwlwzbi11.jpg', '1', '1', '1', '240', 221);

/*!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 */;