Клипове

dELux_nike · 19 Май 2009

Да предложите някой урок за клипове/филми със категории ?

Zion · 19 Май 2009

http://web-tourist.net/login/login/view.php?st=2445

dELux_nike · 19 Май 2009

Zion каза:
http://web-tourist.net/login/login/view.php?st=2445

Да разгледах го, но нещо немога да наглася категориите да излизат на БГ излизат като " ??? "
пробвах със

Код:

$chars="SET CHARACTER SET cp1251";mysql_query($chars);

въс config.php но пак нестана ? как ще стане

proba · 19 Май 2009

Използвай този SQL:

Код:

CREATE TABLE `filmi` ( 
`id` mediumint(8) unsigned NOT NULL auto_increment, 
`kategoriq` varchar(255) collate latin1_swedish_ci NOT NULL default '', 
`seriq` char(1) collate latin1_swedish_ci NOT NULL default '', 
`nomer` varchar(10) collate latin1_swedish_ci NOT NULL default '', 
`zaglaviebg` text collate latin1_swedish_ci NOT NULL, 
`zaglavieus` text collate latin1_swedish_ci NOT NULL, 
`poster` text collate latin1_swedish_ci NOT NULL, 
`wreme` text collate latin1_swedish_ci NOT NULL, 
`godina` text collate latin1_swedish_ci NOT NULL, 
`dyrjawa` text collate latin1_swedish_ci NOT NULL, 
`rejis` text collate latin1_swedish_ci NOT NULL, 
`roli` text collate latin1_swedish_ci NOT NULL, 
`link` text collate latin1_swedish_ci NOT NULL, 
`reiting` text collate latin1_swedish_ci NOT NULL, 
`nositel` text collate latin1_swedish_ci NOT NULL, 
`broinositeli` text collate latin1_swedish_ci NOT NULL, 
`rezume` mediumtext collate latin1_swedish_ci NOT NULL, 
`dopylnitelno` mediumtext collate latin1_swedish_ci NOT NULL, 
`c1` smallint(1) unsigned NOT NULL default '0', 
`c2` smallint(1) unsigned NOT NULL default '0', 
`c3` smallint(1) unsigned NOT NULL default '0', 
`c4` smallint(1) unsigned NOT NULL default '0', 
`c5` smallint(1) unsigned NOT NULL default '0', 
`c6` smallint(1) unsigned NOT NULL default '0', 
`c7` smallint(1) unsigned NOT NULL default '0', 
`c8` smallint(1) unsigned NOT NULL default '0', 
`c9` smallint(1) unsigned NOT NULL default '0', 
`c10` smallint(1) unsigned NOT NULL default '0', 
`c11` smallint(1) unsigned NOT NULL default '0', 
`c12` smallint(1) unsigned NOT NULL default '0', 
`c13` smallint(1) unsigned NOT NULL default '0', 
`c14` smallint(1) unsigned NOT NULL default '0', 
`c15` smallint(1) unsigned NOT NULL default '0', 
`c16` smallint(1) unsigned NOT NULL default '0', 
`c17` smallint(1) unsigned NOT NULL default '0', 
`c18` smallint(1) unsigned NOT NULL default '0', 
`c19` smallint(1) unsigned NOT NULL default '0', 
`c20` smallint(1) unsigned NOT NULL default '0', 
`c21` smallint(1) unsigned NOT NULL default '0', 
`c22` smallint(1) unsigned NOT NULL default '0', 
`c23` smallint(1) unsigned NOT NULL default '0', 
`c24` smallint(1) unsigned NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=0 ; 

CREATE TABLE `janr` ( 
`id` smallint(5) unsigned NOT NULL auto_increment, 
`name` varchar(60) collate latin1_swedish_ci NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=25 ; 

INSERT INTO `janr` VALUES(1, 'Комедия'); 
INSERT INTO `janr` VALUES(2, 'Трилър'); 
INSERT INTO `janr` VALUES(3, 'Романтичен'); 
INSERT INTO `janr` VALUES(4, 'Късометражен'); 
INSERT INTO `janr` VALUES(5, 'Ужаси'); 
INSERT INTO `janr` VALUES(6, 'Психо'); 
INSERT INTO `janr` VALUES(7, 'Мистерия'); 
INSERT INTO `janr` VALUES(8, 'Исторически'); 
INSERT INTO `janr` VALUES(9, 'Документален'); 
INSERT INTO `janr` VALUES(10, 'Семеен'); 
INSERT INTO `janr` VALUES(11, 'Приключенски'); 
INSERT INTO `janr` VALUES(12, 'Еротичeн'); 
INSERT INTO `janr` VALUES(13, 'Драма'); 
INSERT INTO `janr` VALUES(14, 'Уестърн'); 
INSERT INTO `janr` VALUES(15, 'Екшън'); 
INSERT INTO `janr` VALUES(16, 'Музикален'); 
INSERT INTO `janr` VALUES(17, 'Криминален'); 
INSERT INTO `janr` VALUES(18, 'Анимация'); 
INSERT INTO `janr` VALUES(19, 'Фантастика'); 
INSERT INTO `janr` VALUES(20, 'Детски'); 
INSERT INTO `janr` VALUES(21, 'Сериал'); 
INSERT INTO `janr` VALUES(22, 'Военен'); 
INSERT INTO `janr` VALUES(23, 'Пародия'); 
INSERT INTO `janr` VALUES(24, 'Друг');

ако пък не ти излзиат наред си ги добави чрез php файл.
но ти излзиат ???? заради колацията понеже е на cp1251_bulgarian_ci ..
и на моят локалхост е така , но когато използвам lati1_swedish_ci си бчка перфектно :>

Zion · 19 Май 2009

в конфиг.пхп файла сложи mysql_query("SET NAMES cp1251"); след връзката с ДБ

proba · 19 Май 2009

Може и да няма нужда от това..
Аз не използвам SET NAMES cp1251 и пак излиза наред.
Нека пробва и да каже резултата..

dELux_nike · 19 Май 2009

proba каза:

Използвай този SQL:

Код:

CREATE TABLE `filmi` ( 
`id` mediumint(8) unsigned NOT NULL auto_increment, 
`kategoriq` varchar(255) collate latin1_swedish_ci NOT NULL default '', 
`seriq` char(1) collate latin1_swedish_ci NOT NULL default '', 
`nomer` varchar(10) collate latin1_swedish_ci NOT NULL default '', 
`zaglaviebg` text collate latin1_swedish_ci NOT NULL, 
`zaglavieus` text collate latin1_swedish_ci NOT NULL, 
`poster` text collate latin1_swedish_ci NOT NULL, 
`wreme` text collate latin1_swedish_ci NOT NULL, 
`godina` text collate latin1_swedish_ci NOT NULL, 
`dyrjawa` text collate latin1_swedish_ci NOT NULL, 
`rejis` text collate latin1_swedish_ci NOT NULL, 
`roli` text collate latin1_swedish_ci NOT NULL, 
`link` text collate latin1_swedish_ci NOT NULL, 
`reiting` text collate latin1_swedish_ci NOT NULL, 
`nositel` text collate latin1_swedish_ci NOT NULL, 
`broinositeli` text collate latin1_swedish_ci NOT NULL, 
`rezume` mediumtext collate latin1_swedish_ci NOT NULL, 
`dopylnitelno` mediumtext collate latin1_swedish_ci NOT NULL, 
`c1` smallint(1) unsigned NOT NULL default '0', 
`c2` smallint(1) unsigned NOT NULL default '0', 
`c3` smallint(1) unsigned NOT NULL default '0', 
`c4` smallint(1) unsigned NOT NULL default '0', 
`c5` smallint(1) unsigned NOT NULL default '0', 
`c6` smallint(1) unsigned NOT NULL default '0', 
`c7` smallint(1) unsigned NOT NULL default '0', 
`c8` smallint(1) unsigned NOT NULL default '0', 
`c9` smallint(1) unsigned NOT NULL default '0', 
`c10` smallint(1) unsigned NOT NULL default '0', 
`c11` smallint(1) unsigned NOT NULL default '0', 
`c12` smallint(1) unsigned NOT NULL default '0', 
`c13` smallint(1) unsigned NOT NULL default '0', 
`c14` smallint(1) unsigned NOT NULL default '0', 
`c15` smallint(1) unsigned NOT NULL default '0', 
`c16` smallint(1) unsigned NOT NULL default '0', 
`c17` smallint(1) unsigned NOT NULL default '0', 
`c18` smallint(1) unsigned NOT NULL default '0', 
`c19` smallint(1) unsigned NOT NULL default '0', 
`c20` smallint(1) unsigned NOT NULL default '0', 
`c21` smallint(1) unsigned NOT NULL default '0', 
`c22` smallint(1) unsigned NOT NULL default '0', 
`c23` smallint(1) unsigned NOT NULL default '0', 
`c24` smallint(1) unsigned NOT NULL default '0', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=0 ; 

CREATE TABLE `janr` ( 
`id` smallint(5) unsigned NOT NULL auto_increment, 
`name` varchar(60) collate latin1_swedish_ci NOT NULL default '', 
PRIMARY KEY (`id`) 
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci AUTO_INCREMENT=25 ; 

INSERT INTO `janr` VALUES(1, 'Комедия'); 
INSERT INTO `janr` VALUES(2, 'Трилър'); 
INSERT INTO `janr` VALUES(3, 'Романтичен'); 
INSERT INTO `janr` VALUES(4, 'Късометражен'); 
INSERT INTO `janr` VALUES(5, 'Ужаси'); 
INSERT INTO `janr` VALUES(6, 'Психо'); 
INSERT INTO `janr` VALUES(7, 'Мистерия'); 
INSERT INTO `janr` VALUES(8, 'Исторически'); 
INSERT INTO `janr` VALUES(9, 'Документален'); 
INSERT INTO `janr` VALUES(10, 'Семеен'); 
INSERT INTO `janr` VALUES(11, 'Приключенски'); 
INSERT INTO `janr` VALUES(12, 'Еротичeн'); 
INSERT INTO `janr` VALUES(13, 'Драма'); 
INSERT INTO `janr` VALUES(14, 'Уестърн'); 
INSERT INTO `janr` VALUES(15, 'Екшън'); 
INSERT INTO `janr` VALUES(16, 'Музикален'); 
INSERT INTO `janr` VALUES(17, 'Криминален'); 
INSERT INTO `janr` VALUES(18, 'Анимация'); 
INSERT INTO `janr` VALUES(19, 'Фантастика'); 
INSERT INTO `janr` VALUES(20, 'Детски'); 
INSERT INTO `janr` VALUES(21, 'Сериал'); 
INSERT INTO `janr` VALUES(22, 'Военен'); 
INSERT INTO `janr` VALUES(23, 'Пародия'); 
INSERT INTO `janr` VALUES(24, 'Друг');

ако пък не ти излзиат наред си ги добави чрез php файл.
но ти излзиат ???? заради колацията понеже е на cp1251_bulgarian_ci ..
и на моят локалхост е така , но когато използвам lati1_swedish_ci си бчка перфектно :>

Със това нестана ... Сега ще пробвам със предложението на Zion

dELux_nike · 19 Май 2009

и така нестана... Дали е от това че не ползвам webhost ?

Zion · 19 Май 2009

Може и от това да е. Виж си колациите от phpmyadmin-a

Zion · 19 Май 2009

Пробвай и с тази база данни

Код:

CREATE TABLE IF NOT EXISTS `filmi` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`kategoriq` varchar(255) NOT NULL,
`seriq` char(1) NOT NULL,
`nomer` varchar(10) NOT NULL,
`zaglaviebg` text NOT NULL,
`zaglavieus` text NOT NULL,
`poster` text NOT NULL,
`wreme` text NOT NULL,
`godina` text NOT NULL,
`dyrjawa` text NOT NULL,
`rejis` text NOT NULL,
`roli` text NOT NULL,
`link` text NOT NULL,
`reiting` text NOT NULL,
`nositel` text NOT NULL,
`broinositeli` text NOT NULL,
`rezume` mediumtext NOT NULL,
`dopylnitelno` mediumtext NOT NULL,
`c1` smallint(1) unsigned NOT NULL default '0',
`c2` smallint(1) unsigned NOT NULL default '0',
`c3` smallint(1) unsigned NOT NULL default '0',
`c4` smallint(1) unsigned NOT NULL default '0',
`c5` smallint(1) unsigned NOT NULL default '0',
`c6` smallint(1) unsigned NOT NULL default '0',
`c7` smallint(1) unsigned NOT NULL default '0',
`c8` smallint(1) unsigned NOT NULL default '0',
`c9` smallint(1) unsigned NOT NULL default '0',
`c10` smallint(1) unsigned NOT NULL default '0',
`c11` smallint(1) unsigned NOT NULL default '0',
`c12` smallint(1) unsigned NOT NULL default '0',
`c13` smallint(1) unsigned NOT NULL default '0',
`c14` smallint(1) unsigned NOT NULL default '0',
`c15` smallint(1) unsigned NOT NULL default '0',
`c16` smallint(1) unsigned NOT NULL default '0',
`c17` smallint(1) unsigned NOT NULL default '0',
`c18` smallint(1) unsigned NOT NULL default '0',
`c19` smallint(1) unsigned NOT NULL default '0',
`c20` smallint(1) unsigned NOT NULL default '0',
`c21` smallint(1) unsigned NOT NULL default '0',
`c22` smallint(1) unsigned NOT NULL default '0',
`c23` smallint(1) unsigned NOT NULL default '0',
`c24` smallint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `filmi`
--

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

--
-- Table structure for table `janr`
--

CREATE TABLE IF NOT EXISTS `janr` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `janr`
--

INSERT INTO `janr` (`id`, `name`) VALUES
(1, 'Комедия'),
(2, 'Трилър'),
(3, 'Романтичен'),
(4, 'Късометражен'),
(5, 'Ужаси'),
(6, 'Психо'),
(7, 'Мистерия'),
(8, 'Исторически'),
(9, 'Документален'),
(10, 'Семеен'),
(11, 'Приключенски'),
(12, 'Еротичен'),
(13, 'Драма'),
(14, 'Уестърн'),
(15, 'Екшън'),
(16, 'Музикален'),
(17, 'Криминален'),
(18, 'Анимация'),
(19, 'Фантастика'),
(20, 'Детски'),
(21, 'Сериал'),
(22, 'Военен'),
(23, 'Пародия'),
(24, 'Друг');

dELux_nike · 19 Май 2009

Zion каза:

Пробвай и с тази база данни

Код:

CREATE TABLE IF NOT EXISTS `filmi` (
`id` mediumint(8) unsigned NOT NULL auto_increment,
`kategoriq` varchar(255) NOT NULL,
`seriq` char(1) NOT NULL,
`nomer` varchar(10) NOT NULL,
`zaglaviebg` text NOT NULL,
`zaglavieus` text NOT NULL,
`poster` text NOT NULL,
`wreme` text NOT NULL,
`godina` text NOT NULL,
`dyrjawa` text NOT NULL,
`rejis` text NOT NULL,
`roli` text NOT NULL,
`link` text NOT NULL,
`reiting` text NOT NULL,
`nositel` text NOT NULL,
`broinositeli` text NOT NULL,
`rezume` mediumtext NOT NULL,
`dopylnitelno` mediumtext NOT NULL,
`c1` smallint(1) unsigned NOT NULL default '0',
`c2` smallint(1) unsigned NOT NULL default '0',
`c3` smallint(1) unsigned NOT NULL default '0',
`c4` smallint(1) unsigned NOT NULL default '0',
`c5` smallint(1) unsigned NOT NULL default '0',
`c6` smallint(1) unsigned NOT NULL default '0',
`c7` smallint(1) unsigned NOT NULL default '0',
`c8` smallint(1) unsigned NOT NULL default '0',
`c9` smallint(1) unsigned NOT NULL default '0',
`c10` smallint(1) unsigned NOT NULL default '0',
`c11` smallint(1) unsigned NOT NULL default '0',
`c12` smallint(1) unsigned NOT NULL default '0',
`c13` smallint(1) unsigned NOT NULL default '0',
`c14` smallint(1) unsigned NOT NULL default '0',
`c15` smallint(1) unsigned NOT NULL default '0',
`c16` smallint(1) unsigned NOT NULL default '0',
`c17` smallint(1) unsigned NOT NULL default '0',
`c18` smallint(1) unsigned NOT NULL default '0',
`c19` smallint(1) unsigned NOT NULL default '0',
`c20` smallint(1) unsigned NOT NULL default '0',
`c21` smallint(1) unsigned NOT NULL default '0',
`c22` smallint(1) unsigned NOT NULL default '0',
`c23` smallint(1) unsigned NOT NULL default '0',
`c24` smallint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `filmi`
--

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

--
-- Table structure for table `janr`
--

CREATE TABLE IF NOT EXISTS `janr` (
`id` smallint(5) unsigned NOT NULL auto_increment,
`name` varchar(60) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=cp1251 AUTO_INCREMENT=25 ;

--
-- Dumping data for table `janr`
--

INSERT INTO `janr` (`id`, `name`) VALUES
(1, 'Комедия'),
(2, 'Трилър'),
(3, 'Романтичен'),
(4, 'Късометражен'),
(5, 'Ужаси'),
(6, 'Психо'),
(7, 'Мистерия'),
(8, 'Исторически'),
(9, 'Документален'),
(10, 'Семеен'),
(11, 'Приключенски'),
(12, 'Еротичен'),
(13, 'Драма'),
(14, 'Уестърн'),
(15, 'Екшън'),
(16, 'Музикален'),
(17, 'Криминален'),
(18, 'Анимация'),
(19, 'Фантастика'),
(20, 'Детски'),
(21, 'Сериал'),
(22, 'Военен'),
(23, 'Пародия'),
(24, 'Друг');

Нестава ... А Колация ми е "cp1251_general_ci"

Zion · 20 Май 2009

я пробвай с mysql_query("set names utf8");

dELux_nike · 20 Май 2009

Zion каза:
я пробвай с mysql_query("set names utf8");

Пак нестана :lol:

Какво викаш да задам като създавам база данните

Zion · 20 Май 2009

Ами тя колацията ти е такава каквато трябва да е. Незнам просто къде може да е проблема. Я пробвай на някой безплатен хостинг да качиш сайта.

dELux_nike · 20 Май 2009

Аммм я кажи някой, че несъм използвал до сега ... :lol:

Zion · 20 Май 2009

http://1gb.bg
http://freehostia.com

dELux_nike · 20 Май 2009

Клипове

dELux_nike

Registered

Zion

Registered

dELux_nike

Registered

proba

Registered

Zion

Registered

proba

Registered

dELux_nike

Registered

dELux_nike

Registered

Zion

Registered

Zion

Registered

dELux_nike

Registered

Zion

Registered

dELux_nike

Registered

Zion

Registered

dELux_nike

Registered

Zion

Registered

dELux_nike

Registered