PHP-Slajdovi-Web programiranje-Informatika (6), Slajdovi od Web programiranje

Preuzmite PHP-Slajdovi-Web programiranje-Informatika (6) i više Slajdovi u PDF od Web programiranje samo na Docsity!

PHP (Lekcija 7)

Miladin Stefanović

[email protected]

PHP

 7 lekcija

 DB & PHP SQLite

sqlite>

 C:\WINDOWS\Desktop\sqlite>sqlite library.db SQLite version 2.8. Enter ".help" for instructions sqlite> create table books ( ...> id integer primary key, ...> title varchar(255) not null, ...> author varchar(255) not null ...>);  sqlite> insert into books (title, author) values ('The Lord Of The Rings', 'J.R.R. Tolkien');  sqlite> insert into books (title, author) values ('The Murders In The Rue Morgue', 'Edgar Allen Poe');  sqlite> insert into books (title, author) values ('Three Men In A Boat', 'Jerome K. Jerome');  sqlite> insert into books (title, author) values ('A Study In Scarlet', 'Arthur Conan Doyle');  sqlite> insert into books (title, author) values ('Alice In Wonderland', 'Lewis Carroll');  sqlite> .exit  C:\WINDOWS\Desktop\sqlite>sqlite library.db SQLite version 2.8. Enter ".help" for instructions sqlite> create table books ( ...> id integer primary key, ...> title varchar(255) not null, ...> author varchar(255) not null ...>);  sqlite> insert into books (title, author) values ('The Lord Of The Rings', 'J.R.R. Tolkien');  sqlite> insert into books (title, author) values ('The Murders In The Rue Morgue', 'Edgar Allen Poe');  sqlite> insert into books (title, author) values ('Three Men In A Boat', 'Jerome K. Jerome');  sqlite> insert into books (title, author) values ('A Study In Scarlet', 'Arthur Conan Doyle');  sqlite> insert into books (title, author) values ('Alice In Wonderland', 'Lewis Carroll');  sqlite> .exit

sqlite>

 ".help" za instrukcije

 sqlite> select * from books;

1|The Lord Of The Rings |J.R.R. Tolkien

2|The Murders In The Rue Morgue|Edgar Allen Poe

3|Three Men In A Boat |Jerome K. Jerome

4|A Study In Scarlet |Arthur Conan Doyle

5|Alice In Wonderland |Lewis Carroll

 ".help" za instrukcije

 sqlite> select * from books;

1|The Lord Of The Rings |J.R.R. Tolkien

2|The Murders In The Rue Morgue|Edgar Allen Poe

3|Three Men In A Boat |Jerome K. Jerome

4|A Study In Scarlet |Arthur Conan Doyle

5|Alice In Wonderland |Lewis Carroll

Primer 1b - fetch_array

 // da li vrste postoje if ( sqlite_num_rows ($result) > 0) { // prihvati svaku vrstu kao niz // stampaj vrednosti echo ""; while($row = sqlite_fetch_array ($result)) { echo ""; echo "".$row[0].""; echo "".$row[1].""; echo "".$row[2].""; echo ""; } echo ""; } // zatvranje database fajla sqlite_close ($handle); ?>

 // da li vrste postoje if ( sqlite_num_rows ($result) > 0) { // prihvati svaku vrstu kao niz // stampaj vrednosti echo ""; while($row = sqlite_fetch_array ($result)) { echo ""; echo "".$row[0].""; echo "".$row[1].""; echo "".$row[2].""; echo ""; } echo ""; } // zatvranje database fajla sqlite_close ($handle); ?>

Korak 1

 php

$db =

$_SERVER['DOCUMENT_ROOT']."/../libr

ary.db";

$handle = sqlite_open ($db) or die("Could

not open database");

 <?php

$db =

$_SERVER['DOCUMENT_ROOT']."/../libr

ary.db";

$handle = sqlite_open ($db) or die("Could

not open database");

Korak 3

 0) { echo ""; while($row = sqlite_fetch_array ($result)) { echo ""; echo "".$row[0].""; echo "".$row[1].""; echo "".$row[2].""; echo ""; } echo ""; } ?>   0) { echo ""; while($row = sqlite_fetch_array ($result)) { echo ""; echo "".$row[0].""; echo "".$row[1].""; echo "".$row[2].""; echo ""; } echo ""; } ?> 

Primer 2a - fetch()



query($query) or die("Error in query");



query($query) or die("Error in query");

Primer 3a - sqlite_fetch_object



php

// postavljanje putanje do database fajla

$db = $_SERVER['DOCUMENT_ROOT']."/../library.db";

// otvranje database fajla

$handle = sqlite_open($db) or die("Could not open database");

// generisanje upita

$query = "SELECT * FROM books";

// izvrsavanje upita

$result = sqlite_query($handle, $query) or die("Error in query:

".sqlite_error_string(sqlite_last_error($handle)));

Primer 3b - sqlite_fetch_object

 // ako vrsta postoji if (sqlite_num_rows($result) > 0) { // preuzimanje vrste kao niz // stampanje vrednosti echo ""; while($obj = sqlite_fetch_object($result)) { echo ""; echo "".$obj->id.""; echo "".$obj->title.""; echo "".$obj->author.""; echo ""; } echo ""; } // ukidanje database objekta sqlite_close($handle); ?>

 // ako vrsta postoji if (sqlite_num_rows($result) > 0) { // preuzimanje vrste kao niz // stampanje vrednosti echo ""; while($obj = sqlite_fetch_object($result)) { echo ""; echo "".$obj->id.""; echo "".$obj->title.""; echo "".$obj->author.""; echo ""; } echo ""; } // ukidanje database objekta sqlite_close($handle); ?>

Primer 4b - sqlite_fetch_all

 // provera da li niz sadrzi makar jednu vrednost

if (sizeof($data) > 0) {

echo "";

// iteracija “spoljnog” niza – vrste

// stampanej vrednosi svakog elementa “unutrasnjeg” niza – kolone

foreach ($data as $row) {

echo "";

echo "".$row[0]."";

echo "".$row[1]."";

echo "".$row[2]."";

echo "";

echo "";

 // provera da li niz sadrzi makar jednu vrednost

if (sizeof($data) > 0) {

echo "";

// iteracija “spoljnog” niza – vrste

// stampanej vrednosi svakog elementa “unutrasnjeg” niza – kolone

foreach ($data as $row) {

echo "";

echo "".$row[0]."";

echo "".$row[1]."";

echo "".$row[2]."";

echo "";

echo "";

Primer 5a - sqlite_fetch_single

 html>

php // postavljanje putanje do database fajla $db = $_SERVER['DOCUMENT_ROOT']."/../library.db"; // otvranje database fajla $handle = sqlite_open($db) or die("Could not open database"); // kreiranje upita // ovaj upit vraca samo jednu vrednost $query = "SELECT author FROM books WHERE title = 'A Study In Scarlet'"; // izvrsavanje upita $result = sqlite_query($handle, $query) or die("Error in query: ".sqlite_error_string(sqlite_last_error($handle)));

Primer 6a - sqlite_has_more



php

// postavljanje putanje do database fajla

$db = $_SERVER['DOCUMENT_ROOT']."/../library.db";

// otvranje database fajla

$handle = sqlite_open($db) or die("Could not open database");

// kreiranje upita

$query = "SELECT DISTINCT author FROM books";

// izvrsavanje upita $result = sqlite_query($handle, $query) or

die("Error in query:

".sqlite_error_string(sqlite_last_error($handle)));

Primer 6b - sqlite_has_more

 // da li vrsta postoji if (sqlite_num_rows($result) > 0) { echo ""; // proveri da li ima vise vrsta while (sqlite_has_more($result)) { // uzmi prvo polje iz svake vrste // stampanje vrednosti $row = sqlite_fetch_single($result); echo ""; echo "".$row.""; echo ""; } echo ""; } // zatbori database fajl sqlite_close($handle); ?>

 // da li vrsta postoji if (sqlite_num_rows($result) > 0) { echo ""; // proveri da li ima vise vrsta while (sqlite_has_more($result)) { // uzmi prvo polje iz svake vrste // stampanje vrednosti $row = sqlite_fetch_single($result); echo ""; echo "".$row.""; echo ""; } echo ""; } // zatbori database fajl sqlite_close($handle); ?>