Evo koda :-)
Code:
<?php
$hostname_careerdays = "localhost";
$database_careerdays = "careerdays";
$username_careerdays = "user";
$password_careerdays = "pass";
$careerdays = mysql_pconnect($hostname_careerdays, $username_careerdays, $password_careerdays) or die("Greska pri konektovanju na bazu - ");
mysql_select_db("careerdays", $careerdays) or die("Greska pri selektovanju baze");
echo "Ulogovan";
$strSQL="CREATE TABLE `cd_access` (
`sifra` int(11) NOT NULL auto_increment,
`level` varchar(20) NOT NULL default '',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=4";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access OK<br>";
$strSQL="INSERT INTO `cd_access` (`sifra`, `level`) VALUES (1, 'Administrator')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="INSERT INTO `cd_access` (`sifra`, `level`) VALUES (2, 'Moderator')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="INSERT INTO `cd_access` (`sifra`, `level`) VALUES (3, 'Korisnik')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="CREATE TABLE `cd_moderator` (
`sifra` int(11) NOT NULL auto_increment,
`ime` char(20) NOT NULL default '',
`prezime` char(20) NOT NULL default '',
`username` char(20) NOT NULL default '',
`password` char(40) NOT NULL default '',
`email` char(80) NOT NULL default '',
`access` int(11) NOT NULL default '0',
`locked` int(11) NOT NULL default '0',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_moderator OK<br>";
$strSQL="CREATE TABLE `cd_nivo` (
`sifra` int(11) NOT NULL auto_increment,
`naziv` char(20) NOT NULL default '',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=4 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_nivo OK<br>";
$strSQL="INSERT INTO `cd_nivo` (`sifra`, `naziv`) VALUES (1, 'Osnovni')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="INSERT INTO `cd_nivo` (`sifra`, `naziv`) VALUES (2, 'Srednji')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="INSERT INTO `cd_nivo` (`sifra`, `naziv`) VALUES (3, 'Ekspert')";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_access Admin OK<br>";
$strSQL="CREATE TABLE `cd_student` (
`sifra` int(11) NOT NULL auto_increment,
`ime` char(20) NOT NULL default '',
`prezime` char(30) NOT NULL default '',
`adresa` char(80) NOT NULL default '',
`grad` char(40) NOT NULL default '',
`telefon` char(20) NOT NULL default '',
`email` char(80) NOT NULL default '',
`password` char(80) NOT NULL default '',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_student OK<br>";
$strSQL="CREATE TABLE `cd_student_cv` (
`sifra` int(11) NOT NULL auto_increment,
`id_student` int(11) NOT NULL default '0',
`organizacija` varchar(50) NOT NULL default '',
`radno_mesto` varchar(50) NOT NULL default '',
`opis_posla` text NOT NULL,
`pocetak` varchar(14) NOT NULL default '0',
`kraj` varchar(14) NOT NULL default '0',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_student_cv OK<br>";
$strSQL="CREATE TABLE `cd_student_jezik` (
`sifra` int(11) NOT NULL auto_increment,
`id_student` int(11) NOT NULL default '0',
`jezik` char(30) NOT NULL default '',
`nivo` int(11) NOT NULL default '0',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_student_jezik OK<br>";
$strSQL="CREATE TABLE `cd_student_ostalo` (
`sifra` int(11) NOT NULL auto_increment,
`id_student` int(11) NOT NULL default '0',
`sposobnost` char(40) NOT NULL default '',
`nivo` int(11) NOT NULL default '0',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_student_ostalo OK<br>";
$strSQL="CREATE TABLE `cd_student_skola` (
`sifra` int(11) NOT NULL auto_increment,
`id_student` int(11) NOT NULL default '0',
`skola` char(100) NOT NULL default '',
`grad` char(100) NOT NULL default '',
`zvanje` char(100) NOT NULL default '',
`god_zavrsetka` char(4) NOT NULL default '',
`prosek` char(10) NOT NULL default '',
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1 ";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_student_skola OK<br>";
$strSQL="CREATE TABLE `cd_setup` (
`sifra` int(11) NOT NULL auto_increment,
`footer_mail` text NOT NULL,
`telefon` varchar(30) NOT NULL default '',
`fax` varchar(30) NOT NULL default '',
`organizator` varchar(80) NOT NULL default '',
`adresa` text NOT NULL,
`admin_pass` varchar(20) NOT NULL default '',
`admin_meni` text NOT NULL,
`moderator_meni` text NOT NULL,
PRIMARY KEY (`sifra`)
) ENGINE=MyISAM AUTO_INCREMENT=1";
$Result1 = mysql_query($strSQL, $careerdays) or die(mysql_error());
echo "cd_setup OK<br>";
?>
Meni kod radi perfektno u lokalu, tj. kod mene na IIS, ali kad ga postavim na drugi server, nema teorije
Stane kod mysql_pconnect....
seRGio