Please login or register. Welcome to the Studio, guest!


Quick Links:


newBookmarkLockedFalling

ǻñî§ђ™

ǻñî§ђ™ Avatar
Always in disguise!

*
Banned

64


March 2009
Well ive been looking at code indexes that have been posted and i want to create one but i dont know what coding language i would use. I want something like Wrightys but i want the option for people to be able to rate codes. Im still trying to figure out how to do that in JS but would i need to set up some sort of database for the infomation to be stored, like a MySOL database?

Chris

Chris Avatar

******
Head Coder

19,519


June 2005
To rate codes, you would almost definitely need a back-end database, which means you probably need a server side language like PHP to access it. :P So, yeah, you either can do it entirely in PHP or in PHP + JS. Whichever you prefer.

ǻñî§ђ™

ǻñî§ђ™ Avatar
Always in disguise!

*
Banned

64


March 2009
Cool. Thanks Chris :D

John

John Avatar

*
New Member

8


February 2010
I started making a Skin Index, here the database I used, you might find it helpful :)

-- phpMyAdmin SQL Dump
-- version 3.2.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 26, 2010 at 08:19 PM
-- Server version: 5.1.37
-- PHP Version: 5.3.0

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `skinindex`
--

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

--
-- Table structure for table `authors`
--

CREATE TABLE IF NOT EXISTS `authors` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(100) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`id`, `name`) VALUES
(1, 'Author 1'),
(2, 'Author 2');

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

--
-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `name` varchar(100) NOT NULL,
 PRIMARY KEY (`id`),
 UNIQUE KEY `name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`id`, `name`) VALUES
(1, 'Category 1'),
(2, 'Category 2'),
(3, 'Category 3');

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

--
-- Table structure for table `items`
--

CREATE TABLE IF NOT EXISTS `items` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `author` int(11) NOT NULL,
 `category` int(11) NOT NULL,
 `link` text NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `items`
--

INSERT INTO `items` (`id`, `author`, `category`, `link`) VALUES
(1, 1, 2, 'some link here'),
(2, 2, 1, 'some other link here');



Last Edit: Feb 26, 2010 20:20:42 GMT by John

newBookmarkLockedFalling