8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

1/68

MEDA 05.08.2013 - 21.08.2013

1. Konekcija na bazu. 

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

2/68

$o = .mysql_query("%2 >@0 studenti AB 6%=9$id9");if ($o) {  echo(9

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

3/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

4/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

5/68

  # else {  throI neI e8ception (mysql_error());  #  # catch (e8ception $e) {  echo $e7*-etmessa-e();  #

  closedataase ($d); ?*

4 onecia na a&u

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

6/68

R onecia na serer sa poruom

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

7/68

 $rs = .mysql_select_d( "fas", $conn ) or die( "rrD%" );

 $sql = "select id,pre&ime from studenti order y pre&ime";

 $rs = mysql_query( $sql, $conn );

 Ihile( $roI = mysql_fetch_array( $rs ) ) {  echo( "6%D " $roIL"id"M );  echo( " 7 FU60D " $roIL"pre&ime"M "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

8/68

  $pre&ime = $roILM;  $id = $roILNM;  echo "Fre&imeD $pre&ime ($id)

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

9/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

10/68

  Ihile ($roI = mysql_fetch_assoc($result)) {  print "oI $roIcount

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

11/68

  echo "Fre&imeD $pre&ime ($id)

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

12/68

 :N onecia na a&u

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

13/68

$pass = "";$d = "fas";$lin = .mysql_connect( "localhost", $user, $pass );if ( ! $lin ) {  die( "/ouldn9t connect to 0y+12D "mysql_error() );#

print "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

14/68

function selectd ($Ihichd, $d){try {

if (!mysql_select_d ($Ihichd,$d)){throI neI e8ception ("+orry, dataase could not e opened");#

# catch (e8ception $e) {echo $e7*-etmessa-e();##function closedataase ($d){mysql_close ($d);#$d = opendataase ("localhost","root","");

selectd ("fas",$d);$updatequery = "%2 >@0 studenti AB id=:";try {

if (mysql_query ($updatequery, $d)){echo "Vour record has een orisan";

if ($aquery = mysql_query ("+2/ K >@0 studenti AB id=:")){

echo "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

15/68

$form= "GameD

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

16/68

  function selectd ($Ihichd, $d){  try {  if (!mysql_select_d ($Ihichd,$d)){  throI neI e8ception ("+orry, dataase could not e opened");  #  # catch (e8ception $e) {

  echo $e7*-etmessa-e();  #  #  function closedataase ($d){  mysql_close ($d);  #  $d = opendataase ("localhost","root","");  selectd ("od",$d);  $_F@+L9user9M = "meda";  $_F@+L9pass9M = "P:4"; function alidatelo-in ($user,$pass){

  mysql_real_escape_strin- ($user);

  mysql_real_escape_strin- ($pass);  $thequery = "+2/ K >@0 userlo-in AB user=9$user9 G%pass=9$pass9";  if ($aquery = mysql_query ($thequery)){  if (mysql_num_roIs ($aquery) * N){  return true;  # else {  return false;  #  # else {  echo mysql_error();  #  # if (alidatelo-in ($_F@+L9user9M,$_F@+L9pass9M)){

  echo "Vou hae successfully lo--ed in";  # else {  echo "+orry, you hae an incorrect username andCor passIord";  # closedataase ($d);

 ?* 

:W &itanje #o"ja u bazi

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

17/68

 

$query = "+2/ ime, pre&ime >@0 studenti @% 5V pre&ime";  $result = mysql_query($query);

  for ($count=N; $count

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

18/68

$conn = .mysql_connect( "localhost", "root", "" ) or die( "+orry 7 couldnot connect to 0y+12" );$rs= .mysql_list_ds( $conn ) or die( "+orry 7 could not list dataases" );

for( $roI=N; $roI < mysql_num_roIs($rs); $roIOO ){  $d_list= mysql_talename( $rs, $roI ) "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

19/68

  echo "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

20/68

 $prep7*e8ecute();

echo $prep7*affected_roIs " roI(s) affected";$prep7*close();if ($result = $mysqli7*prepare ("+2/ ime, pre&ime >@0 studenti

AB id * P")){$result7*e8ecute ();$result7*ind_result ($ime,$pre&ime);Ihile ($result7*fetch ()){

echo "imeD " stripslashes ($ime) "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

21/68

  echo "($id) $imeD $pre&ime

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

22/68

  foreach($roI as $ey =* $alue) {

  echo "$ey = $alue

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

23/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

24/68

  #

  if($res === false) {

  die("n error occurred fetchin-D "mysqli_error($mysqli));

  #

  mysqli_stmt_close($stmt);  mysqli_close($mysqli);

?* 

EE Konektovanje (D)*

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

25/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

26/68

$result = mysql_query("+2/ K >@0 e8ample")or die(mysql_error());

CC store the record of the "e8ample" tale into $roI$roI = mysql_fetch_array( $result );CC Frint out the contents of the entry

echo "GameD "$roIL9name9M;echo " -eD "$roIL9a-e9M;

?*

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

27/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

28/68

7777 %efinition of tale `radni`77

%@F 52 6> 6++ `radni`;

/ 52 `radni` (  `id` int(N) unsi-ned G@ GJ22 J@_6G/0G,  `ime` archar(4E) G@ GJ22,  `pre&ime` archar(4E) G@ GJ22,  `adresa` archar(4E) G@ GJ22,  `ro_telefona` archar(4E) G@ GJ22,  `passIord` archar(4E) G@ GJ22,  `username` archar(4E) G@ GJ22,  `type` int(N) unsi-ned G@ GJ22,  `m-` archar(4E) G@ GJ22,  `datum_unosa` datetime G@ GJ22,  `id0esta` int(N) unsi-ned G@ GJ22,  `session_id` archar(4E) %>J2 GJ22,

  F60V V (`id`),  V `>_radni_` (`id0esta`),  /@G+6G `>_radni_` >@6YG V (`id0esta`) >G/+`radno_mesto` (`id`) @G %2 /+/%) GY6G=6nno%5 J@_6G/0G=P: %>J2 /B+=latin;

7777 %umpin- data for tale `radni`77

CK!4NNNN 2 52 `radni` %6+52 V+ KC;6G+ 6G@ `radni`(`id`,`ime`,`pre&ime`,`adresa`,`ro_telefona`,`passIord`,`username`,`type`,`m-`,`datum_unosa`,`id0esta`,`session_id`) 32J+

(N,96sha9,9+oftic9,9dresa9,9NR9,94aWded444W4e4N::acPSccXRE:dS9,9isha9,,99,9PN:7NE7PW D:SDEE9,,GJ22), (,9+andin9,9rupic9,9dresaP9,9NRPPPPPP9,94aWded444W4e4N::acPSccXRE:dS9,9sandin9,,9PPPPPPPPPPPPP9,9PN:7NE7PW D4D4E9,P,GJ22), CK!4NNNN 2 52 `radni` G52 V+ KC;

7777 %efinition of tale `radno_mesto`77

%@F 52 6> 6++ `radno_mesto`;/ 52 `radno_mesto` (  `id` int(N) unsi-ned G@ GJ22 J@_6G/0G,  `na&i` archar(4E) G@ GJ22,  F60V V (`id`)) GY6G=6nno%5 J@_6G/0G=: %>J2 /B+=latin;

7777 %umpin- data for tale `radno_mesto`77

CK!4NNNN 2 52 `radno_mesto` %6+52 V+ KC;6G+ 6G@ `radno_mesto` (`id`,`na&i`) 32J+(,9Fro-ramer9),

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

29/68

 (P,9%i&aner9);CK!4NNNN 2 52 `radno_mesto` G52 V+ KC;

CK!4NN + +12_0@%=.@2%_+12_0@% KC;CK!4NN4 + >@6YG_V_/B/+=.@2%_>@6YG_V_/B/+ KC;CK!4NN4 + JG61J_/B/+=.@2%_JG61J_/B/+ KC;CK!4NN + /B/_+_/26G=.@2%_/B/_+_/26G KC;CK!4NN + /B/_+_+J2+=.@2%_/B/_+_+J2+ KC;CK!4NN + /@226@G_/@GG/6@G=.@2%_/@226@G_/@GG/6@G KC;CK!4NN + /B/_+_/26G=.@2%_/B/_+_/26G KC;

R: /@05@ 5@

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

30/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

31/68

paddin-D :Np8;IidthD WNNp8;orderDp8 solid ZSW/S;ac-round7colorD Z>>>;

#hP{

order7ottomDp8 solid Z%/:5;mar-in7ottomDEp8;font7si&eDXp8;line7hei-htDEem;paddin-DXp8 N Ep8;

#form li{

list7styleD none;list7style7typeDnone;mar-in7ottomD Ep8;displayD loc;hei-htD PPp8;paddin-D Ep8;

#Zli_tate8t{hei-htD RNp8;

#Zli_lsttype{

hei-htD PNp8;#form le-end{

font7si&eDXp8;line7hei-htDEem;paddin-DXp8 Ep8;

#form fieldset{

orderDp8 solid ZdPeXfa;mar-in7ottomDNp8;ac-round7colorD Zfcfeff;

#form Zlael_option_rndradio lael{

paddin-D Np8;IidthD ENp8;

#form lael{

colorDZ:4:4;cursorDpointer;floatDleft;font7si&eD:p8;IidthDNNp8;paddin-D :p8 Np8 Np8 Ep8;font7Iei-htDold;te8t7ali-nD ri-ht;

#

form input, form te8tarea, form select{font7familyDrial,sans7serif;colorDZX5SR4;floatD left;IidthDPNXp8;font7si&eD:p8;line7hei-htD;mar-inDN;paddin-D:p8;

#

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

32/68

form inputDfocus, form te8tareaDfocus, form selectDfocus{colorDZ::::::;

#form description{

floatD left;paddin-7leftD Np8;

paddin-7topD :p8;colorDZRRRRRR;font7styleDitalic;

#form error description{

displayD none;#form error{

ac-round7colorDZ>>>S%W;order7colorDZP/XPP;

#form errormessa-e{

displayD inline;

paddin-7leftD PNp8;colorDZRRRRRR;font7Iei-htD old;

#

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

33/68

$>orm7*dd(neI 5ase_>ile("6ma-e", "fileupload", true, array(neI5ase_3alidators_>ile("his is not a alid ima-e n ima-e must e of typep-", "NP4NN", array("p-", "-if", "pn-")), neI5ase_3alidators_6ma-e("Aron- ima-e si&e", :NN, :NN))));$>orm7*dd(neI 5ase_+umit("tnupload", "Jpload"));

function formBandle($data){moe_uploaded_file($dataL"fileupload"ML"tmp_name"M, "uploadC" $dataL"fileupload"ML"name"M);#?*

colorDZ::::::;font7familyDrial,sans7serif;te8t7ali-nD center;ac-round7colorD Zeeaf:;font7si&eDPp8;

#ZIrapper{

mar-inD N auto;te8t7ali-nD left;paddin-D :Np8;IidthD WNNp8;orderDp8 solid ZSW/S;ac-round7colorD Z>>>;

#hP{

order7ottomDp8 solid Z%/:5;mar-in7ottomDEp8;font7si&eDXp8;line7hei-htDEem;paddin-DXp8 N Ep8;

#form li{

list7styleD none;list7style7typeDnone;mar-in7ottomD Ep8;displayD loc;hei-htD PPp8;paddin-D Ep8;

#Zli_tate8t{

hei-htD RNp8;#Zli_lsttype{

hei-htD PNp8;#form le-end{

font7si&eDXp8;line7hei-htDEem;paddin-DXp8 Ep8;

#form fieldset{

orderDp8 solid ZdPeXfa;

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

34/68

mar-in7ottomDNp8;ac-round7colorD Zfcfeff;

#form Zlael_option_rndradio lael{

paddin-D Np8;IidthD ENp8;

#form lael{colorDZ:4:4;cursorDpointer;floatDleft;font7si&eD:p8;IidthDNNp8;paddin-D :p8 Np8 Np8 Ep8;font7Iei-htDold;te8t7ali-nD ri-ht;

#

form input, form te8tarea, form select{

font7familyDrial,sans7serif;colorDZX5SR4;floatD left;IidthDPNXp8;font7si&eD:p8;line7hei-htD;mar-inDN;paddin-D:p8;

#form inputDfocus, form te8tareaDfocus, form selectDfocus{

colorDZ::::::;#form description{

floatD left;paddin-7leftD Np8;paddin-7topD :p8;colorDZRRRRRR;font7styleDitalic;

#form error description{

displayD none;#form error{

ac-round7colorDZ>>>S%W;order7colorDZP/XPP;

#form errormessa-e{

displayD inline;paddin-7leftD PNp8;colorDZRRRRRR;font7Iei-htD old;

#

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

35/68

if(!$>orm7*Frocessed()){echo $>orm;

#else{$data = $>orm7*Yet%ata();$currentfile = "uploadC" $dataL"fileupload"ML"name"M;echo 9

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

36/68

  echo "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

37/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

38/68

  if (function_e8ists ("mysql_connect")){  return true;  # else {  return false;  #  #

  function mysqliinstalled (){  if (function_e8ists ("mysqli_connect")){  return true;  # else {  return false;  #  # if (mysqlinstalled()){

  echo "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

39/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

40/68

mysql_select_d("fas");

  $query = "+2/ id, pre&ime >@0 studenti @% 5V pre&ime";  $result = mysql_query($query);  Ihile (list($id, $pre&ime) = mysql_fetch_roI($result))  {

  echo "Fre&imeD $pre&ime ($id)

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

41/68

  #  if(mysqli_more_results($mysqli)) {

echo "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

42/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

43/68

 

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

44/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

45/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

46/68

XW Fetla Ahile

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

47/68

 ?*UJ2D

GameD 0% FetD RPGameD 06G FetD WGameD immy 0elloIman FetD P:

GameD +andy +mith FetD PGameD 5oy Aallace FetD EGameD immy 0elloIman FetD P:GameD +andy +mith FetD PGameD 5oy Aallace FetD E

,0. Datu%

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

48/68

,2. Menu ro#on

IindoIlocationhref = site;#

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

49/68

mar-inD Np8;#

Zna ul li {floatD left;IidthD auto;

paddin-D Np8;mar-inD Np8;#

Zna a {displayD loc;IidthD auto;hei-htD PEp8;ac-round7colorD Zfff;font7familyD arial, heletica, sans7serif;

font7si&eD Pem;line7hei-htD PEp8;font7Iei-htD old;

colorD Z;te8t7decorationD none;paddin-D N WEp8 N N;mar-inD Np8;

#

Zna ul li aDhoer {colorD ZNNN;

#

CK %@F%@AG 0GJ 7 06G G36Y6@G77777777777777777777777777777777777777 KCZna li ul {

IidthD PNNp8;positionD asolute;

leftD 7SSSem; CK usin- left instead of display to hide menusecause displayD none isn9t read y screen readers KC

ac-round7colorD Zfff;#

Zna li ul li a {IidthD PNNp8;hei-htD PNp8;font7Iei-htD normal;ac-round7colorD Zfff;order7ottomD p8 solid Zccc;paddin-D Np8;mar-inD Np8;

#

Zna liDhoer ul, Zna lisfhoer ul { CK aascript 6 fi8 KCleftD auto;IidthD PNNp8;

#

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

50/68

for (ar i=N; i

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

51/68

o $LA79• (;;E/'7:9 

o 9EA9(79o '79ALL9o 9(/E;/(7

o L'7:E/'E• *(7A*• (/DE/ 

94. UNOS U FORM form.php

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

52/68

mysql_select_d("fas", $con);

$sql="6G+ 6G@ studenti (ime, pre&ime, indes)32J+(9$_F@+LimeM9,9$_F@+Lpre&imeM9,9$_F@+LindesM9)";

if (!mysql_query($sql,$con))  {  die(9rrorD 9 mysql_error());  #echo " record added";

mysql_close($con);

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

53/68

  print "

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

54/68

CC 0ae a 0y+12 /onnectionmysql_connect("localhost", "root", "") or die(mysql_error());mysql_select_d("phpmysql") or die(mysql_error());

CC Yet all the data from the "e8ample" tale$result = mysql_query("+2/ K >@0 e8ample")

or die(mysql_error());

echo " 9%it 21

)obb> a""ace 15

i%%> Me""o%an 23

9an> 9%it 21

)obb> a""ace 15

i%%> Me""o%an 23

9an> 9%it 21

)obb> a""ace 15i%%> Me""o%an 23

9an> 9%it 21

)obb> a""ace 15

9#. $reira%&e aze podata'a i taele

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

55/68

$user = 9root9;$pass = 99;$dataase = 9phpmysqlP:4ER9;

$sql = 9/ 52 `articles` (`6%` int( ) G@ GJ22 J@_6G/0G,

`article_title` 3/B( PEE ) G@ GJ22,`article_content` G@ GJ22,F60V V ( `6%` )

  )9;

CC connect to the mysql dataase serer$connect = .mysql_connect ( $host, $user, $pass ) ;

if ( $connect ){

CC create the dataaseif ( ! .mysql_query ( "/ %5+ $dataase" ) ){

die ( mysql_error() );#else {

mysql_select_d ( $dataase );if ( .mysql_query ( $sql ) ){

echo 9Vour neI tale Ias created successfully!9;#else {

die ( mysql_error() );#

##else {

tri--er_error ( mysql_error(), _J+_@ );#

?*

/ELA

Bour ne tab"e as create success?u"">@

9(. Pra)l&e%&e aze

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

56/68

mysql_close($con);?*

Database create

,,. $/'7 A)ELA /' $(LCA

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

57/68

 ?*

UJ2D

Bour tab"e as been create

*+*. ,meded li%'  

UJ2D

E#"ore a"" our ines E#"ore our re ines 

E#"ore our #re%iu% res ?ro% te /iver"an o%e

*+-. o"i%

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

58/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

59/68

  $modsql = "JF% `radni` + " "`radni``ime` = " "9"for_sql($_F@+L"radni_ime_e8t5o8"M) "9" ", " "`radni``posao` =" "9" for_sql($_F@+L"radni_posao_e8t5o8"M) "9" "," "`radni``status` = " "9"for_sql($_F@+L"radni_status_%rop%oIn5o8"M) "9";  if ($modsql != "") {

  $modsql = -et_Ihere_clause();  mysql_query($modsql, $conn) or die(mysql_error());  #;  #;  header("locationD " $self "?rec=" $rec);  e8it;  case "del"D  if ($deletin-) {  $roI = -et_current_roI();  $modsql = "%2 >@0 `radni`";  if ($modsql != "") {  $modsql = -et_Ihere_clause();  mysql_query($modsql, $conn) or die(mysql_error());

  $rec77;  if($rec < ) $rec = ;  #;  #;  header("locationD " $self "?rec=" $rec);  e8it;  #;

  if ($act != "add") {  $roI = -et_current_roI();  $isfirst = $rec

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

60/68

  # else {  $selsql = " 2606 ";  if ($rec * ) $selsql = " @>>+ " intal($rec 7 );  #;  $res = mysql_query($selsql, $conn) or die(mysql_error());  return mysql_fetch_array($res);

  #;# ?*

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

61/68

auttonDactie {  ac-round7colorD Z>>%;  colorD red;  te8t7decorationD none;#

adisaledDlin, adisaledDisited, adisaledDactie, adisaledDhoer{  ac-round7colorD lac;  colorD Z%:%:%:;  te8t7decorationD none;  cursorD default;#

CK @ther +tyles KC

ody {mar-inD N;

hei-htD NN;paddin-D Np8 Np8 Np8 Np8;font7familyD "0+ +ans +erif", sans7serif, rial;font7si&eD Xpt;colorD ZPPW;

#

tale0ainale>orm {order7collapseD collapse;order7spacin-D N;orderD Pp8 solid ZW>S%5S;

#

tale0ainale>orm td {paddin-D Rp8;font7si&eD Xpt;

CK orderD p8 solid ZR%S4:; KC#

tale0ainale>orm td/olumn {font7familyD "0+ +ans +erif", sans7serif, rial;ac-round7colorD Z/S%X;paddin-7leftD PNp8;te8t7ali-nD ri-ht;font7Iei-htD old;

#

tale0ainale>orm td/olumnP {font7familyD "0+ +ans +erif", sans7serif, rial;paddin-7leftD Np8;ac-round7colorD Z/S%X;

#

>ieldGame {#

6nput5o8 {font7familyD "0+ +ans +erif", sans7serif, rial;font7si&eD Sp8;ac-round7colorD Zffffff;

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

62/68

order7colorD ZW>S%5S;order7IidthD p8;order7styleD solid;ac-round7colorD Z>>>;

#

Ficture {ac-round7colorD Z:E4SEE;paddin-D :p8;

#

2ael {#

tale0ainaleYrid {order7collapseD collapse;order7spacin-D N;

orderD Pp8 solid ZW>S%5S;#

tale0ainaleYrid th {paddin-D :p8;font7si&eD Xpt;ac-round7colorD Z/S%X;orderD p8 solid Z/XSS;colorD lac;

#

tale0ainaleYrid th a {colorD lac;

#

tale0ainaleYrid td {paddin-D :p8;font7si&eD Xpt;orderD p8 solid Z/XSS;

#

tale0ainaleYrid tdaleoIen {ac-round7colorD Z>E>W>/;

# 

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

63/68

 

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

64/68

*href="Z"

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

65/68

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

66/68

  # if ( (strlen($email) < :) bb (strlen($email) * PNN)) {

  die("6nalid 7mail address, 7mail address too lon- or too short");  # elseif(!ere-(".",$email)) {  die("6nalid 7mail address, no . symol found");

  # else {  echo "orm%ataphp"*

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

67/68

108. 9at I $$ ' CA+A9*/'$J

EAD='LE=9at'LE=9*/'$ LA7:A:ECava9cri#t=

?unction set9atIJ N  var vr ne DateIJO

8/15/2019 !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013

68/68

  var sat vr.etoursIJO  var %in vr.etMinutesIJO  var sec vr.et9econsIJO  var +a"ue P IIsat =12J < sat - 12 satJ  +a"ue P II%in 10J < 0 J P %in

  +a"ue P IIsec 10J < 0 J P sec  +a"ue P Isat=12J < #% a%O  ocu%ent.vrije%e.sat.va"ue +a"ueO  seti%eout Iset9atIJQ 1000JOR9*/'$=EAD=)(DB onLoa set9atIJ=;(/M 7AMEvrije%e='7$ B$Etet 7AMEsat +ALE 9'E11=;(/M=

)(DB=

AKLC&AK $/'MCE/ 

10,..