Forum PHP.pl

[SQL] pobierz, plaintext 
news:
- id_news
- tytul
- tresc
- DATA
- autor
- tags
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
tags:
- id
- nazwa
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
# pobierasz dane z bazy
$tagi = $dane_z_bazy->tags;
$tagi = explode(",", $tagi);
$ile_tagow = count($tagi);
$jest = 0;
while($jest <= $ile_tagow) {
    echo $tagi[$jest];
    $jest++;
}
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT u.user_id, u.first_name, GROUP_CONCAT( DISTINCT CONCAT(r.role_id, ":", r.name) ORDER BY r.name ASC SEPARATOR ";" ) roles FROM user u NATURAL JOIN role_user ru NATURAL JOIN role r GROUP BY user_id ORDER BY u.first_name
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
--
-- Table structure for table `role`
--
 
CREATE TABLE `role` (
  `role_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(32) NOT NULL,
  `description` varchar(255) NOT NULL,
  PRIMARY KEY (`role_id`),
  UNIQUE KEY `uniq_name` (`name`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `role_user`
--
 
CREATE TABLE `role_user` (
  `user_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
-- --------------------------------------------------------
 
--
-- Table structure for table `user`
--
 
CREATE TABLE `user` (
  `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `created_at` int(16) UNSIGNED NOT NULL,
  `updated_at` int(16) UNSIGNED DEFAULT NULL,
  `password` varchar(64) NOT NULL,
  `first_name` varchar(16) NOT NULL,
  `email` varchar(64) NOT NULL,
  `logins` int(10) UNSIGNED NOT NULL DEFAULT '0',
  `last_login` int(10) UNSIGNED DEFAULT NULL,
  `deleted` int(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `email_UNIQUE` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
[SQL] pobierz, plaintext