!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013
Transcript of !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP- CODE !!!! 26.07.2013 1!!!21.08.2013
-
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,..