!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP - Code !!!! 26.07.2013 1!!!21.08.2013

MEDA 05.08.2013 - 21.08.
2013
1. Konekcija na bazu.
<?php
$host="localhost";
$uname="root";
$pass="";
$connection= mysql_connect ($host, $uname, $pass);
if (!$connection) {
die ("A connection to the server could not be established!");
}
$result=mysql_select_db ("faks");
if (! $result) {
die ("database could not be selected");
}
echo "Database spremna za koritenje.";
?>
2. Konekcija na server.
<?php
$host="localhost";
$uname="root";
$pass="";
$connection= mysql_connect ($host, $uname, $pass);
if (! $connection) {
die ("A connection to the Server could not be established!");
} else {
echo "Korisnik se logirao na server ",$host," Spreman.";
}
?>
3. Konekcija na bazu.
<?php
@mysql_connect("localhost","root","") or die("Could not connect to MySQL
server!");
@mysql_select_db("faks") or die("Could not select database!");
echo "Vi ste spojeni na MySQL bazu podataka!";
mysql_close();
?>
4. Brisanje slogova u bazi preko ID-a
<html>
<body>
<?php
$cnx = mysql_connect('localhost','root','');
mysql_select_db('faks');
$id = '3';
$ok1 = @mysql_query("DELETE FROM studenti WHERE ID='$id'");

if ($ok1) {
echo('<p>Author deleted successfully!</p>');
} else {
echo('<p>Error deleting author from database!<br />'.
'Error: ' . mysql_error() . '</p>');
}
?>
</body>
</html>
5. baza PRINT POLJE
<?php
//
$hostname="localhost";
$username="root";
$password="";
$dbname="faks";
$usertable="studenti";
$yourfield = "ime";
mysql_connect($hostname,$username, $password) OR DIE ("Unable to connect to
database! Please try again later.");
mysql_select_db($dbname);
$query = "SELECT * FROM $usertable";
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$name = $row["$yourfield"];
echo "Ime: ".$name;
}
}
?>
6. Listing baza
<html>
<head>
<title>Listing the databases available in a connection</title>
</head>
<body>
<?php
$user = "root";
$pass = "";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link )
die( "Couldn't connect to MySQL" );
$db_res = mysql_list_dbs( $link );
$num = mysql_num_rows( $db_res );
for( $x = 0; $x < $num; $x++ )
print mysql_tablename( $db_res, $x )."<br>";
mysql_close( $link );
?>
</body>
</html>
7. Konekcija baze i servera

<html>
<head>
<title>Opening a Connection to a Database</title>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "faks";
$link = @mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
die( "Couldn't connect to MySQL: ".mysql_error() );
}
print "<h2>Successfully connected to server</h2>\n\n";
@mysql_select_db( $db )
or die ( "Couldn't open $db: ".mysql_error() );
print "Successfully selected database \"$db\"<br />\n";
?>
</div>
</body>
</html>
8. Multipli konekcija
<?php
$link1 = @mysql_connect("localhost", "root", "") or die("Could not
connect to MySQL server!");
//$link2 = @mysql_connect("edukat.org", "edukat", "sdf65ezdfg") or
die("Could not connect to MySQL server edukat!");
?>
9. Listanje procesa
<?php
mysql_connect("localhost","root","");
$processes = mysql_list_processes();
echo "<table>";
echo "<tr><th>ID</th><th>User</th><th>Host</th><th>DB</th>
<th>Command</th><th>Time</th><th>State</th><th>Info</th>
</tr>";
while ($row = mysql_fetch_row($processes)) {
list($id,$user,$host,$db,$command,$time,$state,$info) = $row;
echo "<tr><td>$id</td><td>$user</td>
<td>$host</td><td>$db</td><td>$command</td>
<td>$time</td><td>$state</td><td>$info</td>
</tr>";
}
echo "</table>";
?>
10.
Uitavanje zapisa
<?php
@mysql_connect("localhost", "root","") or die("Could not connect to MySQL
server!");
$query = "UPDATE studenti SET title =\"BBB\" WHERE id = 1";
print "Total row updated: ".mysql_affected_rows();
mysql_close();
?>
11.
Zatvaranje baze
<?php
mysql_connect("localhost", "root", "");
mysql_select_db("faks");
mysql_close( );
?>
12.
Konekcija na bazu
<?php
@mysql_connect("localhost", "root", "") or die("Could not connect to MySQL
server!");
@mysql_select_db("faks") or die("Could not select company database!");
print "You're connected to a MySQL database!";
mysql_close();
?>
13.
Fnkcija: otvaranje i zatvaranje baze te unos podataka
<?php
function opendatabase ($host,$user,$pass) {
try {
if ($db = mysql_connect ($host,$user,$pass)){
return $db;
} else {
throw new exception ("Sorry, could not connect to mysql.");
}
} catch (exception $e) {
echo $e->getmessage ();
}
}
function closedatabase ($db){
mysql_close ($db);
}
$db = opendatabase ("localhost","root","");
try {
if (!mysql_select_db ("faks",$db)){
throw new exception ("Sorry, database could not be opened.");
}
$myquery = "INSERT INTO studenti (ime,prezime,indeks) VALUES
('Reed','Blue',300)";
if (mysql_query ($myquery, $db)){
echo "We were successful.";
} else {
throw new exception (mysql_error());
}
echo $e->getmessage();
}
closedatabase ($db);
?>
14.
Konekcija na bazu
<?php
try {
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpass = "";
if ($db = mysql_connect ($mysqlhost,$mysqluser,$mysqlpass)){
echo "Successfully connected to the database.";
mysql_close ($db);
} else {
}
}
?>
15.
Konekcija na bazu sa porukom
<?php
$domain = "localhost";
$user = "root";
$password = "";
$conn = mysql_connect( $domain, $user, $password );
if($conn)
{
$msg = "Congratulations $user, You connected to MySQL";
}
?>
<html>
<head>
<title>Connecting user</title>
</head>
<body>
<h3>
<?php echo( $msg ); ?>
</h3>
</body>
</html>
16.
Konekcija na server sa porukom
<html>
<head>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "faks";
if ( ! $link ) {
}
?>
</div>
</body>
</html>
17.
Printanje podataka
<?php
$result = mysql_query("SELECT * FROM studenti");
while($row = mysql_fetch_array($result)) {
foreach($row as $key=>$value) {
echo "$key = $value<BR/>\n";
}
?>
mysql_free_result($result);
mysql_close();
18.
Pintanje podataka HTML I PHP
<html>
<head>
<title>Get data</title>
</head>
<body>
<?php
$conn = @mysql_connect( "localhost", "root", "" ) or die( "Err:Conn" );
$rs = @mysql_select_db( "faks", $conn )
or die( "Err:Db" );
$sql = "select id,prezime from studenti order by prezime";

$rs = mysql_query( $sql, $conn );
while( $row = mysql_fetch_array( $rs ) )
{
echo( "ID: " . $row["id"] );
echo( " - PREZIME: " . $row["prezime"] . "<br>" );
}
?>
</body>
</html>
19.
Printanje jednog polja
<html>
<head>
<title>Get data</title>
</head>
<body>
<?php
$conn=@mysql_connect( "localhost", "root", "" ) or die( "Err:Conn" );
$rs = @mysql_select_db( "faks", $conn ) or die( "Err:Db" );
$sql = "select id, ime from studenti";
while( $row = mysql_fetch_array( $rs ) )
{
echo( "ID: " . $row["id"] );
echo( " - Ime: " . $row["ime"] . "<br>" );
}
?>
</body>
</html>
20. Printanje jednog polja 2
<?php
$query = "SELECT id, prezime FROM studenti ORDER BY prezime";
while ($row = mysql_fetch_array($result, MYSQL_NUM))
{
$prezime = $row[1];
$id = $row[0];
echo "Prezime: $prezime ($id) <br />";
}
?>
21.
Printanje dva polja
<?php
$query = "SELECT indeks, prezime FROM studenti ORDER BY prezime";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$prezime = $row['prezime'];
$indeks = $row['indeks'];
echo "Naziv: $prezime ($indeks) <br />";
}
?>
22.
Timestamp
<html>
<head>
<title>Using timestamp</title>
</head>
<body>
<?php
error_reporting(0);
$conn = mysql_connect( "localhost", "root", "" );
$rs = mysql_select_db( "faks", $conn );
$sql = "select * from studenti where id=2";
#split the timestamp into organized date format
while ( $row = mysql_fetch_array( $rs ) )
{
$datetime = $row["time"];
$year = substr( $datetime, 0, 4 );
$mon = substr( $datetime, 4, 2 );
$day = substr( $datetime, 6, 2 );
$hour = substr( $datetime, 8, 2 );
$min = substr( $datetime, 10, 2 );
$sec = substr( $datetime, 12, 2 );
$orgdate = date("l F dS, Y h:i A", mktime( $hour, $min, $sec, $mon,
$day, $year ) );
echo( "Time of entry: " . $orgdate );
}
?>
</body>
</html>
23.
Funkcija: Printanje tri polja
<?php
try {
return $db;
} else {
}
}
}
function selectdb ($whichdb, $db){
try {
if (!mysql_select_db ($whichdb,$db)){
}
}
}
mysql_close ($db);
}
selectdb ("faks",$db);
if ($aquery = mysql_query ("SELECT * FROM studenti ORDER BY id ASC")){
while ($adata = mysql_fetch_array ($aquery)){
echo "ID: " . $adata['id'] . "<br />";
echo "Ime: " . stripslashes ($adata['ime']) . "<br />";
echo "Prezime: " . stripslashes ($adata['prezime']) . "<br />";
}
} else {
echo mysql_error();
}
?>
24.
Printanje svih polja vertikalno
<?php
if ($result && mysql_num_rows($result)) {
$numrows = mysql_num_rows($result);
$rowcount = 1;
print "There are $numrows people in tabeli studenti:<br
/><br />";
while ($row = mysql_fetch_assoc($result)) {

print "Row $rowcount<br />";
foreach($row as $var => $val) {
print "<B>$var</B>: $val<br />";
}
print "<br />";

++$rowcount;
}
?>
25.
Printanje max duine polja
<?php
$query = "SELECT * FROM studenti LIMIT 1";
$fields = mysql_num_fields($result);
for($count=0;$count<$fields;$count++)
{
$field = mysql_fetch_field($result,$count);
echo "<p>$field->name $field->type ($field->max_length)</p>";
}
?>
26.
Printanje tri polja tabelarno
<?php
server!");
$query = "SELECT * FROM studenti";
print "<table>\n";
print "<tr>\n<th>id</th><th>ime</th><th>prezime</th>\n</tr>\n";
while (list($id, $ime, $prezime) = mysql_fetch_row($result)) :
print "<tr>\n";
print "<td>$id</td>\n<td>$ime</td>\n<td>$prezime</td>\n";
print "</tr>\n";
endwhile;
print "</table>";
mysql_close();
?>
27.
Printanje dva polja
<?php
while (list($id, $prezime) = mysql_fetch_row($result))
{

?>
}
28.
Tip polja
<?php
$query = "SELECT id as ID, prezime FROM studenti ORDER BY prezime";
$row = mysql_fetch_row($result);
echo mysql_field_type($result, 0);
?>
29.
Print tabela sa aktivnim poljima
<html>
<head>
<title>Selecting Data</title>
</head>
<body>
<?php
$user = "root";
$pass = "";
$db = "faks";
$link = mysql_connect( "localhost", $user, $pass );
if ( ! $link ) {
}
mysql_select_db( $db, $link ) or die ( "Couldn't open $db:
".mysql_error() );
$result = mysql_query( "SELECT * FROM studenti " );
$num_rows = mysql_num_rows( $result );
print "<p>$num_rows je dodano u tabelu</p>\n";
print "<table>";
while ( $a_row = mysql_fetch_row( $result ) ) {
print "<tr>";
foreach ( $a_row as $field ) {
print "<td>".stripslashes($field)."</td>";
}
print "</tr>";
}
print "</table>";
?>
</body>
</html>
30.
Konekcija na bazu
<?php
try {
$mysqlhost = "localhost";
$mysqluser = "root";
$mysqlpass = "";
if ($db = mysql_connect ($mysqlhost,$mysqluser,$mysqlpass)){
echo "Successfully connected to the database.";
mysql_close ($db);
} else {
}
}
?>
31.
Konekcija korisnika
<?php
$user = "root";
$password = "";
if($conn)
{
}
?>
<html>
<head>
</head>
<body>
<h3>
</h3>
</body>
</html>
32.
Konekcija na server
<html>
<head>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "faks";
if ( ! $link ) {
}
?>
</div>
</body>
</html>
33.
Unos podataka u bazu
<html>
<head>
<title>Adding a Row to a Database</title>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "bod";
if ( ! $link ) {
}
@mysql_select_db( $db ) or die ( "Couldn't open $db: ".mysql_error() );
$query = "INSERT INTO bodovi( student, predmet, profesor )values( 'alija
bobija', 'informatika', 'meda' )";
print "running query: <br />\n$query<br />\n";
mysql_query( $query, $link ) or die ( "INSERT error: ".mysql_error() );
?>
</div>
</body>
</html>
34.
Brisanje reda iz tabele
<?php
try {
return $db;
} else {
}
}
}

try {
}
}
}
mysql_close ($db);
}
selectdb ("faks",$db);
$updatequery = "DELETE FROM studenti WHERE id=3";
try {
if (mysql_query ($updatequery, $db)){
echo "Your record has been obrisan.";
if ($aquery = mysql_query ("SELECT * FROM studenti WHERE id=3")){
echo "<br />" . mysql_num_rows ($aquery);
} else {
echo mysql_error();
}
} else {
throw new exception (mysql_error());
}
}
?>
35.
Quest_book
<html>
<head>
<title>Sign the guestbook</title>
</head>
<body>
<?php
error_reporting(0);
$self = $_SERVER['PHP_SELF'];
$name = $_POST['name'];
$email = $_POST['email'];
$comments = $_POST['comments'];
$submit = $_POST['submit'];
$form = "<form action=\"$self\" method=\"post\">";
$form.=
$form.=
$form.=
$form.=
$form.=
$form.=
$form.=
$form.=
$form.=
"Name: <input type=\"text\" name=\"name\" ";

"size=\"50\" value=\"$name\"> <br>";
"Email: <input type=\"text\" name=\"email\" ";
"size=\"50\" value=\"$email\"> <br>";
"Comments:<br>";
"<textarea name=\"comments\" cols=\"45\" ";
"rows=\"4\">$comments</textarea> <br>";
"<input type=\"submit\" name=\"submit\" ";
"value=\"Sign\"> </form>";
if( !$submit){ $msg = $form; }

else
if( !$name or !$email or !$comments)
{
$msg = "<b>Please complete all fields</b><br><br>";
$msg.= $form;
}
else
{
$conn = mysql_connect("localhost", "root", "") or die("Count not connect
to database");
$rs = mysql_select_db("guest_book",$conn) or die ("Could not select
database");
if($name and $comments)
{
$sql = "insert into visitors (name,email, comments)values
(\"$name\",\"$email\",\"$comments\")";
$rs = mysql_query($sql,$conn)
or die ("Could not execute SQL query");
}
if($rs)
{
$msg = "<h3>Thank you - your entry has been saved.</h3>";
$msg.= "<h3><a href = \"guestbook-view.php\">";
$msg.= "View My Guestbook</a></h3>";
}
}
echo($msg);
?>
</body>
</html>
36.
Login
<?php
try {
return $db;
} else {
}
}
}

try {
}
}
}
mysql_close ($db);
}
selectdb ("bod",$db);
$_POST['user'] = "meda";
$_POST['pass'] = "1234";
function validatelogin ($user,$pass){
mysql_real_escape_string ($user);
mysql_real_escape_string ($pass);
$thequery = "SELECT * FROM userlogin WHERE user='$user' AND
pass='$pass'";
if ($aquery = mysql_query ($thequery)){
if (mysql_num_rows ($aquery) > 0){
return true;
} else {
return false;
}
} else {
echo mysql_error();
}
}
if (validatelogin ($_POST['user'],$_POST['pass'])){
echo "You have successfully logged in.";
} else {
echo "Sorry, you have an incorrect username and/or password.";
}
?>
37.
itanje polja u bazi
<?php
error_reporting(0);
$user = "root";
$pass = "";
$db = "faks";
if ( ! $link ) {
}
@mysql_select_db( $db ) or die ( "Couldn't open $db: ".mysql_error() );
$query = "SELECT ime, prezime FROM studenti ORDER BY prezime";

for ($count=0; $count <= mysql_numrows($result); $count++)
{
$ime= mysql_result($result, $count, "ime");
$prezime = mysql_result($result, $count, "prezime");
echo "Studenti: $ime ($prezime <br />";
}
?>
38.
Kanekcija na bazu sa porukoma
<?php
$user = "root";
$password = "";
if($conn)
{
}
?>
<html>
<head>
</head>
<body>
<h3>
</h3>
</body>
</html>
39.
Status baze
<?php
$status = explode(' ', mysql_stat());
foreach($status as $value) echo $value."<br />";
?>
40.
Lista databazi
<?php
error_reporting(0);
$conn = @mysql_connect( "localhost", "root", "" ) or die( "Sorry - could

not connect to MySQL" );
$rs= @mysql_list_dbs( $conn ) or die( "Sorry - could not list databases" );
for( $row=0; $row < mysql_num_rows($rs); $row++ ){
$db_list.= mysql_tablename( $rs, $row ) . "<br>";
}
?>
<html>
<head>
<title>Listing databases</title>
</head>
<body>
<h3>
<?php echo( $db_list ); ?>
</h3>
</body>
</html>
41.
Lista tabela u bazi
<?php
error_reporting(0);
?>
$tables = mysql_list_tables("bod");
$count = 0;
while ($count < mysql_numrows($tables))
{
echo mysql_tablename($tables,$count)."<br />";
$count++;
}
42.
Query: lista slogova u tabeli
<?php
$mysqli = new mysqli("localhost", "root", "","faks", 3306);
$queries = "SELECT * FROM studenti; SELECT * FROM predmeti";
if(mysqli_multi_query($mysqli, $queries)) {
do {
if($result = mysqli_store_result($mysqli)) {
while($row = mysqli_fetch_row($result)) {
foreach($row as $key => $value) {
echo "$key => $value<BR/>\n";
}
}
mysqli_free_result($result);
}
if(mysqli_more_results($mysqli)) {
echo "<BR/>\nNext result set<BR/>\n";

}
} while(mysqli_next_result($mysqli));
}
mysqli_close($mysqli);
?>
43.
Query ispis tabele
<?php
$mysqli = new mysqli("localhost", "root","", "faks");
$query = "SELECT id, ime, prezime, indeks FROM studenti ORDER BY id";
$stmt = $mysqli->prepare($query);
$stmt->execute();
$stmt->bind_result($id, $ime, $prezime, $indeks);
while($stmt->fetch()) {
echo "$id, $ime, $prezime, $indeks <br />";
}
$stmt->close();
$mysqli->close();
?>
44.
Ispis tabele
<?php
$mysqli = new mysqli ("localhost","root","","faks");
try {
if (mysqli_connect_errno()){
throw new exception ("Error: " . mysqli_connect_errno() . " - ".
mysqli_connect_error());
} else {
if ($cdquery = $mysqli->query ("SELECT * FROM studenti ORDER BY id
ASC")){
/>";
while ($cddata = $cdquery->fetch_array ()){

echo "id: " . $cddata['id'] . "<br />";
echo "ime: " . stripslashes ($cddata['ime']) . "<br />";
echo "prezime: " . stripslashes ($cddata['prezime']) . "<br
}
$cdquery->close();
} else {
echo $mysqli->errno . " - " . $mysqli->error;
}
$prep = $mysqli->prepare ("INSERT INTO studenti(id,ime,prezime)

VALUES ('0',?,?)");
$prep->bind_param ('id',$ime,$prezime);
$ime = "AA";
$prezime = 20;
$prep->execute();
echo $prep->affected_rows . " row(s) affected.";
$prep->close();
if ($result = $mysqli->prepare ("SELECT ime, prezime FROM studenti
WHERE id > 2")){
$result->execute ();
$result->bind_result ($ime,$prezime);
while ($result->fetch ()){
echo "ime: " . stripslashes ($ime) . "<br />";
echo "prezime: " . stripslashes ($prezime) . "<br />";
}
$result->close ();
} else {
echo $mysqli->errno . " - " . $mysqli->error;
}
$mysqli->close();
}
}
?>
Ispis tabele
45.
<?php

$result = $mysqli->query("SELECT * FROM studenti");
while($row = $result->fetch_array()) {
echo "$key = $value<BR/>\n";
}
}
$result->close();
$mysqli->close();
?>
46.
Ispis tabele
<?php
$query = "SELECT id, ime, prezime FROM studenti ORDER BY ime";
$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_NUM))
{
$id = $row[0];
$ime = $row[1];
$prezime = $row[2];
echo "($id) $ime: $prezime <br />";

}
?>
47.
Ispis tabele
<?php
$mysqli = mysqli_connect("localhost", "root", "", "faks");
$query = "SELECT id, ime FROM studenti ORDER BY ime";

$result = $mysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
$ime = $row['ime'];
$id = $row['id'];
echo "ime: $ime ($id) <br />";
}
?>
48.
Selektiranje i ispis imena baze
<html>
<head>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "faks";
if ( ! $link ) {
}
?>
</div>
</body>
</html>
49.
Lista podataka iz baze
<?php
$mysqli = mysqli_connect("localhost", "root", "","faks", 3306);
$result = mysqli_query($mysqli, "SELECT * FROM studenti");
while($row = mysqli_fetch_array($result)) {

echo "$key = $value</BR>\n";
}
}
?>
50.
Funkcija instaliranje
<?php
function mysqlinstalled (){
if (function_exists ("mysql_connect")){
return true;
} else {
return false;
}
}
function mysqliinstalled (){
if (function_exists ("mysqli_connect")){
return true;
} else {
return false;
}
}
if (mysqlinstalled()){
echo "<p>The mysql extension is installed.</p>";
} else {
echo "<p>The mysql extension is not installed..</p>";
}
if (mysqliinstalled()){
echo "<p>The mysqli extension is installed.</p>";
} else {
echo "<p>The mysqli extension is not installed..</p>";
}
?>
51.
HTML: Prepoznavanje baze
<html>
<head>
<title>MySQL Connection Test</title>
</head>
<body>
<h2>
<?php $connection = mysql_connect( "localhost", "root", "" )
or die( "Sorry - unable to connect to MySQL" );
echo( "Congratulations - you connected to MySQL" );
?>
</h2>
</body>
</html>
52.
Ispisivanje kreke
<?php
$link = mysqli_connect("localhost", "root", "", "faks");
if(!$link) {
$mysql_error = "Connection error: ".mysqli_connect_error();
die($mysql_error);
}
$result = mysqli_query($link, "SELECT * FROM foo");
if(!$result) {
$errno = mysqli_errno($link);
$error = mysqli_error($link);
die("Query Error: $error (code: $errno)");
}
?>
53.
Ispis sloga
<?php
server!");
while ($row = mysql_fetch_array($result)) :
print $row["id"];
endwhile;
mysql_close();
?>
54.
Prepoznavanje imena u slogu
<?php
if(mysqli_connect_errno()) {
die("Could not connect: ".mysqli_connect_error());
}
$query = "SELECT ime, prezime, indeks FROM studenti WHERE ime LIKE
'meda'";
$stmt = mysqli_prepare($mysqli, $query);
mysqli_execute($stmt);
mysqli_stmt_bind_result($stmt, $ime, $prezime, $indeks);
while(($res = mysqli_stmt_fetch($stmt))) {
echo "Ime: $ime<BR/>\n";
echo "Prezime: $prezime<BR/>\n";
echo "Indeks: $indeks<BR/>\n";
}
if($res === false) {
die("An error occurred fetching: ".mysqli_error($mysqli));
}
mysqli_stmt_close($stmt);
?>
55.
Konektovanje ODBC
<?php
$connect = @odbc_connect("myAccessDB", "root", "") or die("Could not
connect to ODBC database!");
print "Currently connected to ODBC database!";
odbc_close($connect);
?>
56.
Unos podataka u bazu
<!DOCTYPE HTML PUBLIC

"-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html401/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Add a Phonebook Entry</title>
</head>
<body>
<h1>Add a Phonebook Entry</h1>
<form method="GET" action="example.8-2.php">
<table>
<tr>
<td>Surname:
<td><input type="text" name="surname" size=50>
</tr>
<tr>
<td>First name:
<td><input type="text" name="firstname" size=50>
</tr>
<tr>
<td>Phone number:
<td><input type="text" name="phone" size=20>
</tr>
</table>
<br><input type="submit">
</form>
</body>
</html>
57.
Unos podatak izbor i upravljanje

<html>
<head>
<title>Explore Wines in a Region</title>
</head>
<body bgcolor="white">
<form action="example.6-11.php" method="GET">
<br>Enter a region to browse :
<input type="text" name="regionName" value="All">
(type All to see all regions)
<br><input type="submit" value="Show wines">
</form>
<br><a href="index.html">Home</a>
</body>
</html>
58.
Pretraivanje
<html>
<head>
<title>Searching for a student...</title>
</head>
<body bgcolor=#ffffff>
<h2>Search</h2>
<form name="search" method="post" action="studentsearch-exec.php">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="firstname">First Name</option>
<Option VALUE="lastname">Last Name</option>
<Option VALUE="idnumber">ID Number</option>
</Select>
<input type="submit" name="search" value="Search" />
</form>
</body>
</html>
59.
itanje reda

<html>
<head>
<title>ZAPOSLENI</title>
</head>
<body>
<pre>
<?php
// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());
// Retrieve all the data from the "example" table
$result = mysql_query("SELECT * FROM example")

or die(mysql_error());
// store the record of the "example" table into $row
$row = mysql_fetch_array( $result );
// Print out the contents of the entry
echo "Name: ".$row['name'];
echo " Age: ".$row['age'];
?>
</pre>
</body>
</html>
60.
Combo box
<?php
if (isset($_POST['submit'])) {
$rowID = $_POST['id'];
$query = "SELECT * FROM studenti WHERE ID='$id'";
list($id,$ime,$prezime,$indeks) = mysql_fetch_row($result);
?>
<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<select prezime="id">
<option prezime="">Choose a studenti:</option>
<option prezime="1">1</option>
</select>
<input type="submit" prezime="submit" value="Submit" />
</form>
61.
Search Combo i polje
<html>
<head>
<title>Searching for a student...</title>
</head>
<body bgcolor=#ffffff>
<h2>Search</h2>
<form name="search" method="post" action="studentsearch-exec.php">
Seach for: <input type="text" name="find" /> in
<Select NAME="field">
<Option VALUE="firstname">First Name</option>
<Option VALUE="lastname">Last Name</option>
<Option VALUE="idnumber">ID Number</option>
</Select>
<input type="submit" name="search" value="Search" />
</form>
</body>
</html>
62.
Kreiranje baze podataka i tabela
-- MySQL Administrator dump 1.4

--- ------------------------------------------------------- Server version 5.5.24-log
/*!40101
/*!40101
/*!40101
/*!40101
SET
SET
SET
SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS,
FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--- Create schema evidencija
-CREATE DATABASE IF NOT EXISTS evidencija;
USE evidencija;
--- Definition of table èvidencija`
-DROP TABLE IF EXISTS èvidencija`;
CREATE TABLE èvidencija` (
ìd` int(10) unsigned NOT NULL AUTO_INCREMENT,
ìdRadnik` int(10) unsigned NOT NULL,
`broj_sati` float NOT NULL,
`datum_kreiranja` datetime NOT NULL,
PRIMARY KEY (ìd`),
KEY `FK_evidencija_1` (ìdRadnik`),
CONSTRAINT `FK_evidencija_1` FOREIGN KEY (ìdRadnik`) REFERENCES `radnik`
(ìd`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;
--- Dumping data for table èvidencija`
-/*!40000 ALTER TABLE èvidencija` DISABLE KEYS */;
INSERT INTO èvidencija` (ìd`,ìdRadnik`,`broj_sati`,`datum_kreiranja`)
VALUES
(5,10,6,'2013-05-27 11:52:55'),
(6,10,2,'2013-05-27 11:53:09'),
(7,10,7,'2013-05-28 11:53:57'),
(8,10,5,'2013-05-29 11:54:15'),
(9,10,6,'2013-05-30 11:54:37'),
/*!40000 ALTER TABLE èvidencija` ENABLE KEYS */;
--- Definition of table `radnik`

-DROP TABLE IF EXISTS `radnik`;
CREATE TABLE `radnik` (
ìme` varchar(45) NOT NULL,
`prezime` varchar(45) NOT NULL,
àdresa` varchar(45) NOT NULL,
`broj_telefona` varchar(45) NOT NULL,
`password` varchar(45) NOT NULL,
ùsername` varchar(45) NOT NULL,
`type` int(10) unsigned NOT NULL,
`jmbg` varchar(45) NOT NULL,
`datum_unosa` datetime NOT NULL,
ìdMjesta` int(10) unsigned NOT NULL,
`session_id` varchar(45) DEFAULT NULL,
PRIMARY KEY (ìd`),
KEY `FK_radnik_1` (ìdMjesta`),
CONSTRAINT `FK_radnik_1` FOREIGN KEY (ìdMjesta`) REFERENCES
`radno_mjesto` (ìd`) ON DELETE CASCADE
--- Dumping data for table `radnik`
-/*!40000 ALTER TABLE `radnik` DISABLE KEYS */;
INSERT INTO `radnik`
(ìd`,ìme`,`prezime`,àdresa`,`broj_telefona`,`password`,ùsername`,`type`
,`jmbg`,`datum_unosa`,ìdMjesta`,`session_id`) VALUES
(10,'Ishak','Softic','Adresa1','061111111','4a7d1ed414474e4033ac29ccb8653d9
b','ishak',1,'1111111111111','2013-05-27 11:39:55',1,NULL),
(11,'Sandin','Krupic','Adresa2','061222222','4a7d1ed414474e4033ac29ccb8653d
9b','sandin',1,'2222222222222','2013-05-27 11:41:45',2,NULL),
/*!40000 ALTER TABLE `radnik` ENABLE KEYS */;
--- Definition of table `radno_mjesto`
-DROP TABLE IF EXISTS `radno_mjesto`;
CREATE TABLE `radno_mjesto` (
`naziv` varchar(45) NOT NULL,
PRIMARY KEY (ìd`)
--- Dumping data for table `radno_mjesto`
-/*!40000 ALTER TABLE `radno_mjesto` DISABLE KEYS */;
INSERT INTO `radno_mjesto` (ìd`,`naziv`) VALUES
(1,'Programer'),
(2,'Dizajner');
/*!40000 ALTER TABLE `radno_mjesto` ENABLE KEYS */;
/*!40101
/*!40014
/*!40014
/*!40101
/*!40101
/*!40101
/*!40101
63.
SET
SET
SET
SET
SET
SET
SET
SQL_MODE=@OLD_SQL_MODE */;
FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
COMBO BOX
<?php
//Array contents array 1 :: value
$myArray1 = array('Cat','Mat','Fat','Hat');
//Array contents array 2 :: key => value
$myArray2 = array('c'=>'Cat1','m'=>'Mat1','f'=>'Fat1','h'=>'Hat1');
?>
64.
eMail Subscribe
<?php
include("../../lib/init.php");
$Form = new Base_Form("Subscribe", "frmsubscribe");
$Form->SetPhpCallback("formHandle");
$Form->Add(new Base_Text("Name", "txtname", "", true, new
Base_Validators_NotEmpty("Don't forget to fill in your name.")));
$Form->Add(new Base_Text("Email", "txtemail", "", true, new
Base_Validators_Email("Fill in a valid email address.")));
$Form->Add(new Base_Submit("btnsubmit", "Send"));
function formHandle($data){
// Create file if not exist/Read if file exists
$content = "";
if(!file_exists("subscribers.csv")){
$fileHandle = fopen("subscribers.csv", 'w') or die("can't open
file");
fclose($fileHandle);
}else{
$content = file_get_contents("subscribers.csv");
}
// Add new content to variable
$content .= $data['txtname'] . ";" . $data['txtemail'] . "\n";
// Save content to file
file_put_contents("subscribers.csv", $content);
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

<title>Email Subscribe</title>
<link href="style.css" rel="stylesheet" type="text/css" />
</head>
<body>
<div id="wrapper">
<h2>Email Subscribe</h2>
<p>An example of a subscribe form that save the data in a CSV file.</p>
<?php
if(!$Form->Processed()){
echo $Form;
}else{
echo "<h2>Success</h2><p>We added your name to the subscriberslist
and will send you all to newest features.</p>";
}
?>
</div>
</body>
</html>
65.
Upload slika (Formirati folder za slike - Upload
<?php
error_reporting(E_ALL);
$Form = new Base_Form("Image Uploader", "frmimage");
$Form->Add(new Base_Text("Name", "txtimage", "", true));
$Form->Add(new Base_File("Image", "fileupload", true, array(new
Base_Validators_File("This is not a valid image. An image must be of type
jpg.", "102400", array("jpg", "gif", "png")), new
Base_Validators_Image("Wrong image size", 300, 300))));
$Form->Add(new Base_Submit("btnupload", "Upload"));
move_uploaded_file($data["fileupload"]["tmp_name"], "upload/" .
$data["fileupload"]["name"]);
}
?>
<head>
<title>Upload Image</title>
<style>
body{
color:#333333;
font-family:Arial,sans-serif;
text-align: center;
background-color: #e1eaf3;
font-size:12px;
}
#wrapper{
margin: 0 auto;
text-align: left;
}
h2{
padding: 30px;
width: 700px;
border:1px solid #97AEC9;
background-color: #FFF;
border-bottom:1px solid #DCE3EB;
margin-bottom:15px;
font-size:18px;
line-height:1.5em;
padding:8px 0 5px;
}
form li{
list-style: none;
list-style-type:none;
margin-bottom: 5px;
display: block;
height: 22px;
padding: 5px;
}
#li_tatext{
height: 60px;
}
#li_lsttype{
height: 120px;
}
form legend{
font-size:18px;
line-height:1.5em;
padding:8px 5px;
}
form fieldset{
border:1px solid #d2e8fa;
margin-bottom:10px;
background-color: #fcfeff;
}
form #label_option_rndradio label{
padding: 0px;
width: 50px;
}
form label{
color:#3E434A;
cursor:pointer;
float:left;
font-size:13px;
width:100px;
padding: 3px 10px 0px 5px;
font-weight:bold;
text-align: right;
}
form input, form textarea, form select{
color:#8B96A4;
float: left;
width:208px;
font-size:13px;
line-height:1;
margin:0;
padding:3px;
}
form input:focus, form textarea:focus, form select:focus{

color:#333333;
}
form .description{
float: left;
padding-left: 10px;
padding-top: 3px;
color:#666666;
font-style:italic;
}
form .error .description{
display: none;
}
form .error{
background-color:#FFF9D7;
border-color:#E2C822;
}
form .errormessage{
display: inline;
padding-left: 20px;
color:#666666;
font-weight: bold;
}
</style>
</head>
<body>
<div id="wrapper">
<h2>Image Uploader</h2>
<p>This is an image uploader example that shows you how you can validate
the image width, hight, size and type before it's uploaded. In this example
you can only upload jpeg images that are smaller than 300x300 and are
smaller then 100kb</p>
<?php
echo $Form;
}else{
$data = $Form->GetData();
$currentfile = "upload/" . $data["fileupload"]["name"];
echo '<h2>Success</h2><p><img src="' . $currentfile . '" height="40"
width="40" align="left" hspace="5" />This is the image that you just
uploaded.</p>';
}
?>
</div>
</body>
</html>
66.
Kontakt form Formirati image folder i css stile
<?php
error_reporting(E_ALL);
$Form = new Base_Form("Image Uploader", "frmimage");
$Form->Add(new Base_Text("Name", "txtimage", "", true));
$Form->Add(new Base_File("Image", "fileupload", true, array(new

Base_Validators_File("This is not a valid image. An image must be of type
jpg.", "102400", array("jpg", "gif", "png")), new
Base_Validators_Image("Wrong image size", 300, 300))));
$Form->Add(new Base_Submit("btnupload", "Upload"));
move_uploaded_file($data["fileupload"]["tmp_name"], "upload/" .
$data["fileupload"]["name"]);
}
?>
<head>
<title>Upload Image</title>
<style>
body{
color:#333333;
text-align: center;
background-color: #e1eaf3;
font-size:12px;
}
#wrapper{
margin: 0 auto;
text-align: left;
padding: 30px;
width: 700px;
border:1px solid #97AEC9;
background-color: #FFF;
}
h2{
border-bottom:1px solid #DCE3EB;
margin-bottom:15px;
font-size:18px;
line-height:1.5em;
padding:8px 0 5px;
}
form li{
list-style: none;
list-style-type:none;
margin-bottom: 5px;
display: block;
height: 22px;
padding: 5px;
}
#li_tatext{
height: 60px;
}
#li_lsttype{
height: 120px;
}
form legend{
font-size:18px;
line-height:1.5em;
padding:8px 5px;
}
form fieldset{
border:1px solid #d2e8fa;
margin-bottom:10px;
background-color: #fcfeff;
}
form #label_option_rndradio label{
padding: 0px;
width: 50px;
}
form label{
color:#3E434A;
cursor:pointer;
float:left;
font-size:13px;
width:100px;
font-weight:bold;
text-align: right;
}
form input, form textarea, form select{
color:#8B96A4;
float: left;
width:208px;
font-size:13px;
line-height:1;
margin:0;
padding:3px;
}
form input:focus, form textarea:focus, form select:focus{
color:#333333;
}
form .description{
float: left;
padding-left: 10px;
padding-top: 3px;
color:#666666;
font-style:italic;
}
form .error .description{
display: none;
}
form .error{
background-color:#FFF9D7;
border-color:#E2C822;
}
form .errormessage{
display: inline;
padding-left: 20px;
color:#666666;
font-weight: bold;
}
</style>
</head>
<body>
<div id="wrapper">
<h2>Image Uploader</h2>
<p>This is an image uploader example that shows you how you can validate
the image width, hight, size and type before it's uploaded. In this example
you can only upload jpeg images that are smaller than 300x300 and are
smaller then 100kb</p>
<?php
echo $Form;
}else{
$data = $Form->GetData();
$currentfile = "upload/" . $data["fileupload"]["name"];
echo '<h2>Success</h2><p><img src="' . $currentfile . '" height="40"
width="40" align="left" hspace="5" />This is the image that you just
uploaded.</p>';
}
?>
</div>
</body>
</html>
67.
Imjena kolone u tabeli i brojanje slogova
<?php
$query = "UPDATE studenti SET ime = '39.99' ";
echo "There were ".mysql_affected_rows()." product(s) affected. ";
?>
68.
Update
<html>
<body>
<?php
$host="localhost";
$uname="root";
$pass="";
$database="faks";
$tablename="studenti";
$connection= mysql_connect($host,$uname,$pass) or die("Database
connection failed!<br>");
$result=mysql_select_db($database) or die("Database could not be
selected");
$query = "UPDATE studenti SET ime=\"new Name 2\" where id=29";
if (!$result) {
die(" Query could not be executed.<br>");
} else {
echo "<table> ";
echo " <tr>";
echo "
<td colspan=\"2\">";
echo "
<center><b>".mysql_affected_rows()." record updated
successfully</b></center>";
echo "
</td>";
echo " </tr>";
echo " <tr>";
echo "
<td>";
echo "
<div align=\"right\"> Name</div>";
echo
echo
echo
echo
echo
echo
"
</td>";
"
<td>".$name. "</td>";
" </tr>";
" <tr>";
"
<td>";
"
<div align=\"right\">E-mail</div>";
echo "
</td>";
echo "
<td>".$email. "</td>";
echo " </tr>";
echo " <tr>";
echo "
<td>";
echo "
<div align=\"right\"> CustomerID</div>";
echo "
</td>";
echo "
<td>".$customerid. "</td>";
echo " </tr>";
echo "</table>";
}
?>
</body>
</html>
69.
Pretraivanje i print po imenu
<?php
if(mysqli_connect_errno()) {
die("Could not connect: ".mysqli_connect_error());
}
$query = "SELECT ime, prezime, indeks FROM studenti WHERE ime LIKE
'39.99'";
$stmt = mysqli_prepare($mysqli, $query);
mysqli_execute($stmt);
mysqli_stmt_bind_result($stmt, $ime, $prezime, $indeks);
while(($res = mysqli_stmt_fetch($stmt))) {
echo "Ime: $ime<BR/>\n";
echo "Prezime: $prezime<BR/>\n";
echo "Indeks: $indeks<BR/>\n";
}
if($res === false) {
die("An error occurred fetching: ".mysqli_error($mysqli));
}
mysqli_stmt_close($stmt);
?>
70.
Print reda horizontalno
<?php
server!");
while ($row = mysql_fetch_array($result)) :
print $row["prezime"];
endwhile;
mysql_close();
?>
71.
Printanje greke
<?php
$link = mysqli_connect("localhost", "root", "", "faks");
if(!$link) {
$mysql_error = "Connection error: ".mysqli_connect_error();
die($mysql_error);
}
$result = mysqli_query($link, "SELECT * FROM foo");
if(!$result) {
$errno = mysqli_errno($link);
$error = mysqli_error($link);
die("Query Error: $error (code: $errno)");
}
?>
72.
Printanje redova u tabeli
<?php
$mysqli = mysqli_connect("localhost", "root", "","faks", 3306);
$result = mysqli_query($mysqli, "SELECT * FROM studenti");
while($row = mysqli_fetch_array($result)) {
echo "$key = $value</BR>\n";
}
}
?>
73.
Funkcija instaliranje
<?php
function mysqlinstalled (){
if (function_exists ("mysql_connect")){
return true;
} else {
return false;
}
}
function mysqliinstalled (){
if (function_exists ("mysqli_connect")){
return true;
} else {
return false;
}
}
if (mysqlinstalled()){
echo "<p>The mysql extension is installed.</p>";
} else {
echo "<p>The mysql extension is not installed..</p>";
}
if (mysqliinstalled()){
echo "<p>The mysqli extension is installed.</p>";
} else {
echo "<p>The mysqli extension is not installed..</p>";
}
?>
74.
Konekcija na bazu i ispis imena baze
<html>
<head>
</head>
<body>
<div>
<?php
$user = "root";
$pass = "";
$db = "faks";
if ( ! $link ) {
}
?>
</div>
</body>
</html>
75.
Broj redova i listing redova
<?php
if ($result && mysql_num_rows($result)) {
$numrows = mysql_num_rows($result);
$rowcount = 1;
print "There are $numrows people in tabeli studenti:<br
/><br />";
while ($row = mysql_fetch_assoc($result)) {
print "Row $rowcount<br />";
foreach($row as $var => $val) {
print "<B>$var</B>: $val<br />";
}
print "<br />";

++$rowcount;
}
?>
76.
Pregled tri polja u tabeli
<?php
server!");
print "<table>\n";
print "<tr>\n";
print "</tr>\n";
endwhile;
print "</table>";
mysql_close();
?>
77.
List jedno polje
<?php
?>

{
}
78.
Jedno polje listing
<?php
?>

{
}
79. jedno polje listing

<?php
{
}
?>
80.
Ispis tri reda
<?php
server!");
print "<table>\n";
print "<tr>\n";
print "</tr>\n";
endwhile;
print "</table>";
mysql_close();
?>
81.
Ispis redova
<?php
$queries = "SELECT * FROM studenti; SELECT * FROM predmeti";
if(mysqli_multi_query($mysqli, $queries)) {
do {
if($result = mysqli_store_result($mysqli)) {
while($row = mysqli_fetch_row($result)) {
echo "$key => $value<BR/>\n";
}
}
}
if(mysqli_more_results($mysqli)) {
echo "<BR/>\nNext result set<BR/>\n";
}
} while(mysqli_next_result($mysqli));
}
?>
82.
Horizontal drop down Menu
<meta charset="utf-8">
<title>Drop-Down Example</title>
<style type="text/css">
/* MAIN NAVIGATION
--------------------------------------*/
#nav{
float: left;
width: 1000px;
height: 25px;
padding: 0px;
margin: 0px;
}
#nav ul {
list-style: none;
padding: 0px;
margin: 0px;
}
#nav ul li {
float: left;
width: auto;
padding: 0px;
margin: 0px;
}
#nav a {
display: block;
width: auto;
height: 25px;
background-color: #fbfbfb;
font-family: arial, helvetica, sans-serif;
font-size: 1.2em;
line-height: 25px;
font-weight: bold;
color: #bbb;
text-decoration: none;
padding: 0 75px 0 0;
margin: 0px;
}
#nav ul li a:hover {
color: #000;
}
/* DROPDOWN MENU - MAIN NAVIGATION
-------------------------------------- */
#nav li ul {
width: 200px;
position: absolute;
left: -999em; /* using left instead of display to hide menus
because display: none isn't read by screen readers */
background-color: #fff;
}
#nav li ul li a {
width: 200px;
height: 20px;
font-weight: normal;
border-bottom: 1px solid #ccc;
padding: 0px;
margin: 0px;
}
#nav li:hover ul, #nav li.sfhover ul { /* javascript IE fix */
left: auto;
width: 200px;
}
</style>
<script type="text/javascript">
sfHover = function() {
var sfEls =
document.getElementById("nav").getElementsByTagName("LI");
for (var i=0; i<sfEls.length; i++) {
sfEls[i].onmouseover=function() {
this.className+=" sfhover";
}
sfEls[i].onmouseout=function() {
this.className=this.className.replace(new RegExp("
sfhover\\b"), "");
}
}
}
if (window.attachEvent) window.attachEvent("onload", sfHover);
</script>
</head>
<body>
<div id="nav">
<ul>
<li><a href="index.php">HOME</a></li>
<li><a href="aboutus.php">ABOUT</a></li>
<li><a href="collections.php">COLLECTIONS</a>
<ul>
<li><a href="mountain.php">MOUNTAIN</a></li>
<li><a href="ocean.php">OCEAN</a></li>
<li><a href="bohemian.php">BOHEMIAN</a></li>
<li><a href="native.php">NATIVE</a></li>
<li><a href="green.php">GREEN</a></li>
<li><a href="moon.php">MOON</a></li>
<li><a href="plants.php">PLANTS</a></li>
</ul>
</li>
<li><a href="offerings.php">OFFERINGS</a>
<ul>
<li><a href="seasons.php">SEASONS</a></li>
<li><a href="installs.php">INSTALLS</a></li>
<li><a href="storefront.php">STOREFRONT</a></li>
<li><a href="lingerie.php">LINGERIE</a></li>
</ul>
</li>
<li><a href="contact.php">CONTACT</a></li>
<li><a href="order.php">ORDER</a></li>
</ul>
</div>
</body>
</html>
83.
Menu google


function do_redirect(site){
window.location.href = site;
}
</script>
<select onchange="do_redirect(this.value)">
<option value="#">What site would you like to see?</option>
<option value="http://www.google.com">Google</option>
<option value="http://www.yahoo.com">Yahoo</option>
<option value="http://www.apphp.com">ApPHP</option>
</select>
84.
Navigacija
<head>
<meta charset="utf-8" >
<meta name="viewport" content="width-device-width, initialscale=1.0">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/bootstrapresponsive.css">
</head>
<div id="oli"><div id="navigacija"><div class="lijevozaobljenje"></div><div id="navigacija-dijelovi" style="text-align:
right"><table width="100%" cellpadding="0" cellspacing="0"><tr
valign="top"><td>
<ol>
<li style="margin-top:2px;"><a href="naslovnica.php"><img width="16"
height="16" src="images/icons/kucica.png" style="background:none"/>
Naslovna</a></li>
<li style="margin-top:2px;"><a href="admin.php?str=korisnici" style="<?php
if($an) echo "color:red"; ?>"><img width="16" height="16"
src="images/zupcanik.png" style="background:none;"> Korisnici </a>
<ol>
<li style="margin-top:2px;"><a href="admin.php?str=literatura"><img
width="16" height="16" src="images/icons/1211806189.png"
style="background:none;"> Literatura</a></li>
<li style="margin-top:2px;"><a href="profil.php?str=poruke"><img width="16"

height="16" src="images/mail.png" style="background:none;"> <?php $brp =
mysql_num_rows(mysql_query("select * from tbl_poruke where PRIMALAC = '".
$_SESSION["korisnik_podaci"]["IDST"]."' and PROCITANO = '' ")); if($brp >
0){echo "<strong style='color:rgb(236,4,4)'>Poruke (".$brp.")</strong>";}
else {
echo "Poruke"; }?></a></li>
<li style="margin-top:2px;"><a
href="http://edukat.org/projekti/Promjene"><img width="16" height="16"
src="images/test.png" style="background:none;"> Promjene</a></li>
<li style="margin-top:2px;"><a href="profil.php?str=dodaj_obavijest"><img
style="background:none;"> Obavijesti</a></li>
</ol>
<?php if(student()) {?>
<li style="margin-top:2px;"><a href="profil.php?str=projekti"><img

style="background:none;"> Projekti</a></li>
<?php } else { ?>
<li style="margin-top:2px;"><a href="profil.php?
str=pregledaj_projekte"><img width="16" height="16"
src="images/icons/1211806336.png" style="background:none;">
eRadovi</a></li>
<?php } ?>
<li style="margin-top:2px;"><a href="admin.php?str=testovi"><img width="16"

height="16" src="images/test.png" style="background:none;">
Testovi</a></li>
<li style="margin-top:2px;"><a href="admin.php?str=prispita"><img
width="16" height="16" src="images/test.png" style="background:none;">
Ispiti </a></li>
<?php if (admin()) { ?>
<li style="margin-top:2px;"><a href="admin.php?str=korisnici" style="<?php
if($an) echo "color:red"; ?>"><img width="16" height="16"
src="images/zupcanik.png" style="background:none;"> Administracija</a>
<ol>
<li><a href="admin.php?str=korisnici">Korisnici</a></li>
<li><a href="admin.php?str=akademskagod">Akademske godine</a></li>
<li><a href="admin.php?str=univerziteti">Univerziteti</a></li>
<li><a href="admin.php?str=fakulteti">Fakulteti</a></li>
<li><a href="admin.php?str=odsjeci">Odsjeci</a></li>
<li><a href="admin.php?str=smjerovi">Smjerovi</a></li>
<li><a href="admin.php?str=semestri">Semestri</a></li>
<li><a href="admin.php?str=predmeti">Predmeti</a></li>
<li><a href="admin.php?str=ocjene">Ocjene</a></li>
<li><a href="admin.php?str=vrstaradova">Vrste radova</a></li>
<li><a href="admin.php?str=zvanja">Zvanja</a></li>
<li><a href="admin.php?str=zahtjevi" style="<?php if($an) echo "color:red";

?>"><?php if($an) echo "<strong>"; ?>Zahtjevi<?php if($an) echo
"</strong>"; ?></a></li>
<?php /*<li><a href="admin.php?str=promjene">Promjene</a></li>*/ ?>
</ol>
</li>
<?php } ?>
</ol>
</td>
<td style="text-align:right">
<a href="profil.php"><strong><?php echo $_SESSION['korisnik_podaci']
['PREZIME_I_IME']; ?></strong></a> ( <a href="odjava.php"
style="color:red">Odjava</a> )
</td></tr></table></div><div class="desno-zaobljenje"></div></div></div>
85.
Vrijeme
<script language="JavaScript">
var v = new Date()
document.write(v.getHours())
document.write(":")
document.write(v.getMinutes())
document.write(":")
document.write(v.getSeconds())
</script>
86. Petlja if..else
<html>
<body>
<?php
$d=date("D");
if ($d=="Fri")
{
echo "Have a nice weekend!";
}
elseif ($d=="Sun")
{
echo "Have a nice Sunday!";
}
else
{
echo "Have a nice day!";
}
?>
</body>
</html>
REZULTAT:
Have a nice day!
87. Petlja While

<html>
<body>
<?php
$i=1;
while($i<=5)
{
echo "The number is " . $i . "<br />";
$i++;
}
?>
</body>
</html>
REZULTAT:
The number
The number
The number
The number
The number
is
is
is
is
is
1
2
3
4
5
88. Niz
<html>
<body>
<?php
$x=array("one","two","three");
foreach ($x as $value)
{
echo $value . "<br />";
}
?>
</body>
</html>
REZULTAT:
one
two
three
89. Print tabele
<?php
// Connects to your Database
$data = mysql_query("SELECT * FROM example")
Print "<table border cellpadding=3>";
while($info = mysql_fetch_array( $data ))
{
Print "<tr>";
Print "<th>Name:</th> <td>".$info['name'] . "</td> ";
Print "<th>Pet:</th> <td>".$info['age'] . " </td></tr>";
}
Print "</table>";
?>
REZULTAT:
Name:
Name:
Name:
Name:
Name:
Name:
Name:
Name:
MEDA
EMINA
Timmy
Sandy
Bobby
Timmy
Sandy
Bobby
Mellowman
Smith
Wallace
Mellowman
Smith
Wallace
Pet:
Pet:
Pet:
Pet:
Pet:
Pet:
Pet:
Pet:
62
17
23
21
15
23
21
15
90. Datum
<?php
echo date("Y/m/d") . "<br />";
echo date("Y.m.d") . "<br />";
echo date("Y-m-d");
?>
REZULTAT:
2013/08/12
2013.08.12
2013-08-12
91. Print TABELA
<?php
$con=mysqli_connect("localhost","root","","faks");
if (mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error(); }
$result = mysqli_query($con,"SELECT * FROM studenti");
echo "<table border='1'>
<tr>
<th>Ime</th>
<th>Prezime</th>
</tr>";
while($row = mysqli_fetch_array($result))
{
echo "<tr>";
echo "<td>" . $row['ime'] . "</td>";
echo "<td>" . $row['prezime'] . "</td>";
echo "</tr>";
}
echo "</table>";
mysqli_close($con);
?>
REZULTAT:
Ime Prezime
39.99 emhco
39.99 n
39.99 q
92. Menu dropdown


function do_redirect(site){
window.location.href = site;
}
</script>
<select onchange="do_redirect(this.value)">
<option value="#">What site would you like to see?</option>
<option value="http://www.google.com">Google</option>
<option value="http://www.yahoo.com">Yahoo</option>
<option value="http://www.apphp.com">ApPHP</option>
</select>
REZULTAT:
93. MENU navigacija

<!DOCTYPE HTML>
<html>
<head>
<meta charset="utf-8" >

<meta name="viewport" content="width-device-width, initialscale=1.0">
<link rel="stylesheet" type="text/css" href="css/bootstrap.css">
<link rel="stylesheet" type="text/css" href="css/bootstrapresponsive.css">
</head>
<head>
<meta charset="utf-8">
<title>Drop-Down Example</title>
/* MAIN NAVIGATION
--------------------------------------*/
#nav{
float: left;
width: 1000px;
height: 25px;
padding: 0px;
margin: 0px;
}
#nav ul {
list-style: none;
padding: 0px;
margin: 0px;
}
#nav ul li {
float: left;
width: auto;
padding: 0px;
margin: 0px;
}
#nav a {
display: block;
width: auto;
height: 25px;
background-color: #fbfbfb;
font-family: arial, helvetica, sans-serif;
font-size: 1.2em;
line-height: 25px;
font-weight: bold;
color: #bbb;
padding: 0 75px 0 0;
margin: 0px;
}
#nav ul li a:hover {
color: #000;
}
/* DROPDOWN MENU - MAIN NAVIGATION
-------------------------------------- */
#nav li ul {
width: 200px;
position: absolute;
left: -999em; /* using left instead of display to hide menus
because display: none isn't read by screen readers */
}
#nav li ul li a {
width: 200px;
height: 20px;
font-weight: normal;
border-bottom: 1px solid #ccc;
padding: 0px;
margin: 0px;
}
#nav li:hover ul, #nav li.sfhover ul { /* javascript IE fix */
left: auto;
width: 200px;
}
</style>
sfHover = function() {
var sfEls =
document.getElementById("nav").getElementsByTagName("LI");
for (var i=0; i<sfEls.length; i++) {

sfEls[i].onmouseover=function() {
this.className+=" sfhover";
}
sfEls[i].onmouseout=function() {
this.className=this.className.replace(new RegExp("
sfhover\\b"), "");
}
}
}
if (window.attachEvent) window.attachEvent("onload", sfHover);
</script>
</head>
<body>
<div id="nav">
<ul>
<li><a href="index.php">HOME</a></li>
<li><a href="aboutus.php">ABOUT</a></li>
<li><a href="collections.php">COLLECTIONS</a>
<ul>
<li><a href="mountain.php">MOUNTAIN</a></li>
<li><a href="ocean.php">OCEAN</a></li>
<li><a href="bohemian.php">BOHEMIAN</a></li>
<li><a href="native.php">NATIVE</a></li>
<li><a href="green.php">GREEN</a></li>
<li><a href="moon.php">MOON</a></li>
<li><a href="plants.php">PLANTS</a></li>
</ul>
</li>
<li><a href="offerings.php">OFFERINGS</a>
<ul>
<li><a href="seasons.php">SEASONS</a></li>
<li><a href="installs.php">INSTALLS</a></li>
<li><a href="storefront.php">STOREFRONT</a></li>
<li><a href="lingerie.php">LINGERIE</a></li>
</ul>
</li>
<li><a href="contact.php">CONTACT</a></li>
<li><a href="order.php">ORDER</a></li>
</ul>
</div>
</body>
</html>
REZULTAT:
HOME
ABOUT
COLLECTIONS
o MOUNTAIN
o OCEAN
o BOHEMIAN
o NATIVE
o GREEN
o MOON
PLANTS
OFFERINGS
o SEASONS
o INSTALLS
o STOREFRONT
o LINGERIE
CONTACT
ORDER
o
94. UNOS U FORM form.php

<html>
<body>
<form action="insert.php" method="post">
Ime: <input type="text" name="ime" />
Prezime: <input type="text" name="prezime" />
Indeks: <input type="text" name="indeks" />
<input type="submit" />
</form>
</body>
</html>
<html>
<head><title>OSAkademija</title></head>
<body>
<h2>Unos podataka</h2><p>
<form action="process.php" method="post">
<table>
<tr><td>Ime:</td><td><input type="text" name="ime" /></td></tr>
<tr><td>Prezime:</td><td><input type="text" name="prezime"
/></td></tr>
<tr><td>Indeks:</td><td><input type="text" name="indeks"
/></td></tr>
<tr><td>Naziv:</td><td><input type="text" name="naziv"
/></td></tr>
<tr><td colspan="2" align="center"><input type="submit" /></td></tr>
</table>
</form>
</body>
</html>
94.A UNOS INSERT: insert.php
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("faks", $con);
$sql="INSERT INTO studenti (ime, prezime, indeks)
VALUES
('$_POST[ime]','$_POST[prezime]','$_POST[indeks]')";
if (!mysql_query($sql,$con))
{
die('Error: ' . mysql_error());
}
echo "1 record added";
mysql_close($con);
?>
Ime:
Prezime:
Indeks:
Naziv:
95. PASSWORD
<?php
##########################################################################
$password = "admin"; // Modify Password to suit for access, Max 10 Char.
##########################################################################
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Simple Password Protect - PHP PasswordProtect</title>
<!-P { FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Verdana, Tahoma, Arial}
TD { FONT-SIZE: 8pt; COLOR: #000000; FONT-FAMILY: Verdana, Tahoma, Arial}
-->
</style>
</head>
<body>
<?php
print "<h2 align=\"center\">PHP Simple Password Protect</h2>";
// If password is valid let the user get access
if (isset($_POST["password"]) && ($_POST["password"]=="$password")) {
?>

<p align="center"><br><br><br>
<b>Congratulations</b><br>you have gained access to the Protected and
Secret Area!</p>

<?php
}
else
{
if (isset($_POST['password']) || $password == "") {
print "<p align=\"center\"><font color=\"red\"><b>Incorrect

Password</b><br>Please enter the correct password</font></p>";}
print "<form method=\"post\"><p align=\"center\">Please enter your
password for access<br>";
print "<input name=\"password\" type=\"password\" size=\"25\"
maxlength=\"10\"><input value=\"Login\" type=\"submit\"></p></form>";
}
print "<br><br><p align=\"center\">Written by <a
href=\"http://www.stevedawson.com\">SteveDawson.com</a></p>";
?>
<BR>
</body>
</html>
REZULTAT:
PHP Simple Password Protect

Please enter your password for access
96.INSERT
<?php
mysql_select_db("phpmysql") or die(mysql_error());
// Insert a row of information into the table "example"
mysql_query("INSERT INTO example
(name, age) VALUES('Timmy Mellowman', '23' ) ")
(name, age) VALUES('Sandy Smith', '21' ) ")
(name, age) VALUES('Bobby Wallace', '15' ) ")
echo "Data Inserted!";
?>
REZULTAT:
Data Inserted!
96. Ispis tabele
<?php

mysql_select_db("phpmysql") or die(mysql_error());
// Get all the data from the "example" table
$result = mysql_query("SELECT * FROM example")
echo "<table border='1'>";
echo "<tr> <th>Name</th> <th>Age</th> </tr>";
// keeps getting the next row until there are no more to get
while($row = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo "<tr><td>";
echo $row['name'];
echo "</td><td>";
echo $row['age'];
echo "</td></tr>";
}
echo "</table>";
?>
Rezultat:
Name
Age
Timmy Mellowman 23
Sandy Smith
23
Timmy Mellowman 23
Sandy Smith
21
Bobby Wallace
15
Timmy Mellowman 23
Sandy Smith
21
Bobby Wallace
15
Timmy Mellowman 23
Sandy Smith
21
Bobby Wallace
15
Timmy Mellowman 23
Sandy Smith
21
Bobby Wallace
15
97. Kreiranje baze podataka i tabele

<?php
// set your infomation.
$host
=
'localhost';
$user
$pass
$database
=
=
=
'root';
'';
'phpmysql123456';
$sql = 'CREATE TABLE àrticles` (

ÌD` int( 11 ) NOT NULL AUTO_INCREMENT,
àrticle_title` VARCHAR( 255 ) NOT NULL,
àrticle_content` TEXT NOT NULL,
PRIMARY KEY ( ÌD` )
)';
// connect to the mysql database server.
$connect = @mysql_connect ( $host, $user, $pass ) ;
if ( $connect )
{
// create the database.
if ( ! @mysql_query ( "CREATE DATABASE $database" ) )
{
die ( mysql_error() );
}
else {
mysql_select_db ( $database );
if ( @mysql_query ( $sql ) )
{
echo 'Your new table was created successfully!';
}
else {
die ( mysql_error() );
}
}
}
else {
trigger_error ( mysql_error(), E_USER_ERROR );
}
?>
REZULTAT:
Your new table was created successfully!
98. Pravljenje baze
<?php
if (!$con)
{
}
if (mysql_query("CREATE DATABASE gost",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
mysql_close($con);
?>
Database created
99. PRINT TABELA TRI POLJA
<?php
if (!$con)
{
}
mysql_select_db("my_db", $con);
$result = mysql_query("SELECT * FROM Persons ORDER BY age");
while($row = mysql_fetch_array($result))
{
echo $row['FirstName'];
echo " " . $row['LastName'];
echo " " . $row['Age'];
echo "<br />";
}
mysql_close($con);
?>
REZULTAT:
Glenn Quagmire 33
Peter Griffin 36
Meda Emhco 55
100.
Sesija
<?php
// this starts the session
session_start();
// this sets variables in the session
$_SESSION['color']='red';
$_SESSION['size']='small';
$_SESSION['shape']='round';
print "Done";
?>
REZULTAT:
Done
101 Kreiranje tabele
<?php
// Connects to your Database
mysql_query("CREATE TABLE kola ( name VARCHAR(30),
age INT, car VARCHAR(30))");
Print "Your table has been created";
?>
REZULTAT:
Your table has been created

101.
Embeded link

<html>
<head>
<title>Explore Wines</title>
</head>
<body bgcolor="#ffffff">
Explore all our
<a href="example.6-13.php?regionName=All&wineType=All"> wines</a>
<br>Explore our
<a href="example.6-13.php?regionName=All&wineType=Red"> red wines</a>
<br>Explore our
<a href="example.6-13.php?regionName=Riverland&wineType=Red"> premium
reds from the Riverland</a>
<br>
<a href="index.html">Home</a></body>
</html>
REZULTAT:
Explore all our wines

Explore our red wines
Explore our premium reds from the Riverland
Home
102.
Login
<?php
session_start();
if (isset($_POST["submit"])) {
if ($_POST["user"] == "nilanjan" && $_POST["pass"] == "banerjee") {
$_SESSION["usernm"] = $_POST["user"];
}
}
?>
<html>
<head>
<title>User Authentication</title>
</head>
<body>
<?php
if (isset($_SESSION["usernm"])) {
echo("You are logged in!");
} else {
?>
<form method="post">
<input type="text" name="user" /><br />
<input type="password" name="pass" /><br />
<input type="submit" name="submit" value="Login" />
</form>
<?php
}
?>
</body>
</html>
REZULTAT:
103.
Navigacija i unos artikala
<?php
error_reporting(0);
$conn = mysql_connect("localhost:3306", "root", "");
if(!$conn) {
die("Error connecting to MySQL: " . mysql_error());
}
if(!mysql_select_db("adressbook")) {
die("Error connecting to MySQL: " . mysql_error());
}
$self = $_SERVER['PHP_SELF'];
$act = $_GET["act"];
$editing = 1;
$deleting = 1;
if (isset($_GET["rec"])) {
$rec = $_GET["rec"];
} else {
$rec = 1;
};
$key = $_GET["key"];
$count = get_count();
switch ($act) {
case "postins":
if ($editing) {
$modsql = "INSERT INTO `radnik` (`radnik`.ìme`, `radnik`.`posao`,
`radnik`.`status`) VALUES (" ."'"
.for_sql($_POST["radnik_ime_TextBox"]) ."'" ."," ."'"
.for_sql($_POST["radnik_posao_TextBox"]) ."'" ."," ."'"
.for_sql($_POST["radnik_status_DropDownBox"]) ."'" .")";
if ($modsql != "") {
mysql_query($modsql, $conn) or die(mysql_error());
$key = mysql_insert_id();
};
};
header("location: " .$self ."?rec=" .$rec);
exit;
case "postupd":
if ($editing) {
$row = get_current_row();
$modsql = "UPDATE `radnik` SET " ."`radnik`.ìme` = " ."'"

.for_sql($_POST["radnik_ime_TextBox"]) ."'" .", " ."`radnik`.`posao` =
" ."'" .for_sql($_POST["radnik_posao_TextBox"]) ."'" .",
" ."`radnik`.`status` = " ."'"
.for_sql($_POST["radnik_status_DropDownBox"]) ."'";
$modsql .= get_where_clause();
};
};
exit;
case "del":
if ($deleting) {
$modsql = "DELETE FROM `radnik`";
$modsql .= get_where_clause();
$rec--;
if($rec < 1) $rec = 1;
};
};
exit;
};
if ($act != "add") {
$isfirst = $rec <= 1;
$islast = $rec >= $count;
} else {
$isfirst = 1;
$islast = 1;
};
$radnik_status_DropDownBoxValues = array("aktivan", "neaktivan");
?>
<?php function for_sql($value) {
return str_replace("'", "\'", str_replace("\\", "\\\\", $value));
} ?>
<?php function date_val($value) {
if ($value == "") {
return "NULL";
} else {
return "'" .for_sql($value) ."'";
};
} ?>
<?php function get_current_row() {
global $conn;
global $rec;
global $key;
$selsql = "SELECT
`radnik`.`sradnik` AS `radnik_dbac_fc_sradnik`,
`radnik`.ìme` AS `radnik_dbac_fc_ime`,
`radnik`.`posao` AS
`radnik_dbac_fc_posao`,
`radnik`.`status` AS `radnik_dbac_fc_status`
FROM `radnik`";
if ($selsql != "") {
if(isset($key)) {
$selsql .= " WHERE `radnik`.`sradnik` = " .intval($key);
} else {
$selsql .= " LIMIT 1";
if ($rec > 1) $selsql .= " OFFSET " .intval($rec - 1);
};
$res = mysql_query($selsql, $conn) or die(mysql_error());
return mysql_fetch_array($res);
};
} ?>
<?php function get_count() {
global $conn;
$countsql = "SELECT COUNT(*) FROM `radnik`";

if ($countsql != "") {
$res = mysql_query($countsql, $conn) or die(mysql_error());
$row = mysql_fetch_array($res);
return $row[0];
} else return 0;
} ?>
<?php function get_where_clause() {
global $row;
return " WHERE " ."(`radnik`.`sradnik` = "
.intval($row["radnik_dbac_fc_sradnik"]) .")";
} ?>
<html>
<head>
<title>page1</title>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<style>
/* Buttons */
a.button {
font-weight: bold;
font-size: 8px;
font-family: "MS Sans Serif", sans-serif, Arial;
padding: 4px 8px;
border-top: 1px solid white;
border-right: 1px solid black;
border-bottom: 1px solid black;
border-left: 1px solid white;
text-align: center;
min-width: 75px;
}
a.button:link {
background-color: #ECE9D8;
color: #000;
}
a.button:visited {
color: #000;
}
a.button:hover {
background-color: #F1F1ED;
color: black;
}
a.button:active {
background-color: #F1F1ED;
color: red;
}
a.disabled:link, a.disabled:visited, a.disabled:active, a.disabled:hover{
background-color: black;
color: #D3D3D3;
cursor: default;
}
/* Other Styles */
body {
margin: 0;
height: 100%;
font-size: 8pt;
color: #1A2127;
}
table.MainTableForm {
border-collapse: collapse;
border-spacing: 0;
border: 2px solid #7F9DB9;
}
table.MainTableForm td {
padding: 6px;
font-size: 8pt;
/*
border: 1px solid #6D943A; */
}
table.MainTableForm td.Column1 {
padding-left: 20px;
text-align: right;
font-weight: bold;
}
table.MainTableForm td.Column2 {
padding-left: 10px;
}
.FieldName {
}
.InputBox {
font-size: 9px;
background-color: #ffffff;
border-color: #7F9DB9;
border-width: 1px;
border-style: solid;
background-color: #FAFAFA;
.Picture {
background-color: #354955;
padding: 3px;
}
.Label {
}
table.MainTableGrid {
border-collapse: collapse;
border-spacing: 0;
border: 2px solid #7F9DB9;
}
table.MainTableGrid th {
padding: 3px;
font-size: 8pt;
border: 1px solid #ACA899;
color: black;
}
table.MainTableGrid th a {
color: black;
}
table.MainTableGrid td {
padding: 3px;
font-size: 8pt;
border: 1px solid #ACA899;
}
table.MainTableGrid td.TableRowEven {
background-color: #F5F7FC;
}
</style>
</head>
<body>
<form name="MainForm" action="<?php if ($act != "add") { echo $self ."?
act=postupd&rec=" .$rec; } else { echo $self ."?act=postins"; } ?>"
method="post">
<table class="MainTableForm">
<tbody>
<tr>
<td class="Column1">
<div class="FieldName">sradnik</div>
</td>
<div class="Label" style="WIDTH: 200px"
name="radnik_sradnik_Div"name="radnik_sradnik_Div"><?php echo
$row["radnik_dbac_fc_sradnik"] ?></div>
</td>
</tr>
<tr>
<div class="FieldName">ime</div>
</td>
<input class="InputBox" style="WIDTH: 200px"
name="radnik_ime_TextBox" value="<?php echo $row["radnik_dbac_fc_ime"] ?
>"name="radnik_ime_TextBox">
</td>
</tr>
<tr>
<div class="FieldName">posao</div>
</td>
<input class="InputBox" style="WIDTH: 200px"
name="radnik_posao_TextBox" value="<?php echo
$row["radnik_dbac_fc_posao"] ?>"name="radnik_posao_TextBox">
</td>
</tr>
<tr>
<div class="FieldName">status</div>
</td>
<select class="InputBox" style="WIDTH: 200px"
name="radnik_status_DropDownBox"name="radnik_status_DropDownBox">
<?php foreach ($radnik_status_DropDownBoxValues as
$radnik_status_DropDownBoxValue) {
if ($radnik_status_DropDownBoxValue ==
$row["radnik_dbac_fc_status"]) { $selstr = " selected"; } else { $selstr =
""; }
?>
<option value="<?php echo $radnik_status_DropDownBoxValue ?>"<?php
echo $selstr ?>><?php echo $radnik_status_DropDownBoxValue ?></option>
<?php } ?>
</select>
</td>
</tr>
</tbody>
</table>
</form>
<br>
<a class="button" id="linkrefresh" href="<?php echo $self ."?rec=" .
$rec ?>">Refresh</a> <a <?php if (!$isfirst) { ?>class="button"<?php } else
{ ?>class="button disabled"<?php } ?> id="linkfirst" <?php if (!$isfirst) {
?>href="<?php echo $self ."?rec=1" ?>"<?php } else { ?>href="#"<?php } ?
>>&lsaquo;&lsaquo; First</a> <a <?php if (!$isfirst) { ?>class="button"<?
php } else { ?>class="button disabled"<?php } ?> id="linkprev" <?php if (!
$isfirst) { ?>href="<?php echo $self ."?rec=" .($rec - 1) ?>"<?php } else {
?>href="#"<?php } ?>>&lsaquo; Prev</a> <a <?php if (!$islast) { ?
>class="button"<?php } else { ?>class="button disabled"<?php } ?>
id="linknext" <?php if (!$islast) { ?>href="<?php echo $self ."?rec=" .
($rec + 1) ?>"<?php } else { ?>href="#"<?php } ?>>Next &rsaquo;</a> <a <?
php if (!$islast) { ?>class="button"<?php } else { ?>class="button
disabled"<?php } ?> id="linklast" <?php if (!$islast) { ?>href="<?php echo
$self ."?rec=" .$count ?>"<?php } else { ?>href="#"<?php } ?>>Last
&rsaquo;&rsaquo;</a> <a <?php if ($act != "add") { ?>class="button"<?php }
else { ?>class="button disabled"<?php } ?> id="linkadd" <?php if ($act !=
"add") { ?>href="<?php echo $self ."?act=add" ?>"<?php } else { ?
>href="#"<?php } ?>>Add</a> <a <?php if ($act != "add") { ?

>class="button"<?php } else { ?>class="button disabled"<?php } ?>
id="linkdelete" <?php if ($act != "add") { ?>href="<?php echo $self ."?
act=del&rec=" .$rec ?>"<?php } else { ?>href="#"<?php } ?>>Delete</a> <a
class="button" id="linkpost" onClick="MainForm.submit();"
href="#">Submit</a> <a class="button" id="linkcancel"
onClick="MainForm.reset();" href="#">Cancel</a> </body>
</html>
REZULTAT:
sradnik 7
medaemhco
ime
posao
status
meda
Refresh First Prev Next Last Add Delete Submit Cancel
104.
Datumi
<html>
<body>
<?php
$d=date("D");
if ($d=="Fri")
{
echo "Have a nice weekend!";
}
else
{
echo "Have a nice day!";
}
?>
</body>
</html>
REZULTAT:
Have a nice day!

105.
SUBMIT
<html><body>
<h4>Tizag Art Supply Order Form</h4>
<form>
<select>
<option>Paint</option>
<option>Brushes</option>
<option>Erasers</option>
</select>
Quantity: <input type="text" />
<input type="submit" />
</form>
</body></html>
REZULTAT:
106.
EMAIL Validation
<html>
<head>
<title>e-mail validator</title>
</head>
<body>
<form name="form1" method="post" action="EMailValidation.php">
<table>
<tr>
<td colspan="2"><b>Enter an e-mail address to test</div></td>
</tr>
<tr>
<td width="25%">E-mail</td>
<td width="75%">
<input type="text" name="email" size="30">
</td>
</tr>
<tr>
<td colspan="2">
<input type="submit" name="Submit" value="Submit">
</td>
</tr>
</table>
</form>
</body>
</html>

REZULTAT:
107.
SUBMIT RESET
<HTML>
<BODY>
<FORM METHOD="POST" ACTION="DealWithArrayFormData.php">
<H1>Contact Information</H1>
<TABLE>
<TR>
<TD>Childrens' Names:</TD>
</TR>
<TR>
<TD><INPUT TYPE="TEXT" NAME="children[]"></TD>
</TR>
<TR>
</TR>
<TR>
</TR>
<TR>
</TR>
<TR>
</TR>
</TABLE>
<BR>
<BR>
<BR>
<INPUT TYPE="SUBMIT" VALUE="Submit">
<BR>
<BR>
<INPUT TYPE="RESET" VALUE="Clear the Form">
</FORM>
</BODY>
</HTML>
<!-- DealWithArrayFormData.php
<?php
foreach ($children as $index => $child){
echo "<BR>child[$index]=$child";
}
echo "<BR>";
sort($children);
foreach ($children as $index => $child){
echo "<BR>child[$index]=$child";
}
?>
ZAKLJUAK:
108.
Sat ( PHP I JAVASCRIPT)
<HEAD>
<TITLE>Sat</TITLE>
<SCRIPT LANGUAGE="JavaScript">
function setSat() {
var vr = new Date();
var sat = vr.getHours();

var min = vr.getMinutes();
var sec = vr.getSeconds();
var Value = "" + ((sat >12) ? sat - 12 : sat)
Value += ((min < 10) ? ":0" : ":") + min
Value += ((sec < 10) ? ":0" : ":") + sec
Value += (sat>=12) ? " pm" : " am";
document.vrijeme.sat.value = Value;
setTimeout ("setSat()", 1000);
}
</SCRIPT>
</HEAD>
<BODY onLoad = "setSat()">
<FORM NAME="vrijeme">
<INPUT TYPE="text" NAME="sat" VALUE="" SIZE=11>
</FORM>
</BODY>
ZAKLJUAK: PRIMJER
109..

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP - Code !!!! 26.07.2013 1!!!21.08.2013

Uploaded by

Document Informationclick to expand document information

Copyright:

Available Formats

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP - Code !!!! 26.07.2013 1!!!21.08.2013

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!PHP - Code !!!! 26.07.2013 1!!!21.08.2013

Uploaded by

Copyright:

Available Formats

MEDA 05.08.2013 - 21.08.

$ok1 = @mysql_query("DELETE FROM studenti WHERE ID='$id'");

7. Konekcija baze i servera

Fnkcija: otvaranje i zatvaranje baze te unos podataka

Konekcija na bazu sa porukom

Konekcija na server sa porukom

Pintanje podataka HTML I PHP

$rs = @mysql_select_db( "faks", $conn )

$sql = "select id,prezime from studenti order by prezime";

Printanje jednog polja

Printanje dva polja

Funkcija: Printanje tri polja

Printanje svih polja vertikalno

while ($row = mysql_fetch_assoc($result)) {

print "<br />";

Printanje max duine polja

Printanje tri polja tabelarno

Printanje dva polja

echo "Prezime: $prezime ($id) <br />";

Print tabela sa aktivnim poljima

Unos podataka u bazu

Brisanje reda iz tabele

function selectdb ($whichdb, $db){

"Name: <input type=\"text\" name=\"name\" ";

if( !$submit){ $msg = $form; }

function selectdb ($whichdb, $db){

itanje polja u bazi

$query = "SELECT ime, prezime FROM studenti ORDER BY prezime";

Kanekcija na bazu sa porukoma

$conn = @mysql_connect( "localhost", "root", "" ) or die( "Sorry - could

Lista tabela u bazi

Query: lista slogova u tabeli

echo "<BR/>\nNext result set<BR/>\n";

Query ispis tabele

while ($cddata = $cdquery->fetch_array ()){

$prep = $mysqli->prepare ("INSERT INTO studenti(id,ime,prezime)

$mysqli = new mysqli("localhost", "root", "","faks", 3306);

echo "($id) $ime: $prezime <br />";

$query = "SELECT id, ime FROM studenti ORDER BY ime";

Selektiranje i ispis imena baze

Lista podataka iz baze

foreach($row as $key => $value) {

HTML: Prepoznavanje baze

Prepoznavanje imena u slogu

Unos podataka u bazu

<!DOCTYPE HTML PUBLIC

Unos podatak izbor i upravljanje

<!DOCTYPE HTML PUBLIC

<!DOCTYPE HTML PUBLIC

$result = mysql_query("SELECT * FROM example")

Search Combo i polje

Kreiranje baze podataka i tabela

-- MySQL Administrator dump 1.4

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;

--- Definition of table `radnik`

<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />

Upload slika (Formirati folder za slike - Upload

/!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 /;