Ucim PHP, nije los, nije tezak sve dok... vidite iz naslova :)
Pokupila sam neke vjezbe sa kursa koji je pohadjala moja drugarica koja nije bogzna sta tamo naucila. Ne znam kako da podesim sve oko konekcije za rad sa bazom, u PHPMyAdminu na Wamp Serveru napravim bazu ali sta dalje. Postoje neke skripte koje moraju biti ukljucene u folder kao i glavni skript ali javlja gresku. Dalje, nesto ne valja ni sa slanjem poste. Imam neki PHPMailer kao skript ali cemu sluzi i kako da nesto posaljem nemam pojma.
Dacu vam skripte koje imam pa ako neko moze da pomogne...
----------------------------------------------------------------------
<?php
// common.php, zajednicka funkcionalnost za celu aplikaciju
session_start();
// ocitaj vrednost iz cookie-ja za jezik
if (isset($_COOKIE['c_lang'])) {
$_SESSION['lang'] = $_COOKIE['c_lang'];
};
// definisanje jezika u kom ce se prikazivati aplikacija
if ($_GET['lang'] == 'en') {
// cookie za engleski jezik
setcookie('c_lang', 'en', (time() + (60*60*24*365)));
$_SESSION['lang'] = 'en';
} elseif (isset($_GET['lang'])) {
// cookie za srpski (default) jezik
setcookie('c_lang', 'rs', (time() + (60*60*24*365)));
$_SESSION['lang'] = 'rs';
};
// ako jos uvek jezik nije definisan - definisi default jezik
if (!isset($_SESSION['lang'])) $_SESSION['lang'] = 'rs';
// ucitaj fajl sa jezicima
include_once $_SESSION['lang'].".php";
?>
--------------------------------------------------------------
<?php
// connection.php, parametri konekcije
define('dbServer', '127.0.0.1');
define('dbUser', 'root');
define('dbPasswd', '');
define('dbName', 'address_book');
?>
---------------------------------------------------------------
<?php
/*
* contact.php, iAdresar
*
**/
session_start();
if ($_GET['logout'] == '1') {
unset($_SESSION['ulogovan']);
};
if ($_SESSION['ulogovan'] != 'da') {
header("location: index.php");
exit;
}
// ucitaj podesavanja konekcije
include_once "settings.php";
// ucitaj podesavanja konekcije
include_once "connection.php";
include_once "common.php";
// povezivanje na server
$db = mysql_connect(dbServer, dbUser, dbPasswd) or die(mysql_error());
mysql_select_db(dbName, $db) or die(mysql_error());
// brisanje
if (isset($_GET['delete'])) {
$sql = "delete from contact where id = ".$_GET['delete'];
mysql_query($sql) or die(mysql_error());
$msg = $lang['Delete success'];
//echo $sql;
};
if (isset($_GET['id'])) {
$sql = "select * from contact where id = ".$_GET['id'];
//echo $sql;
$recSet = mysql_query($sql) or die(mysql_error());
$rec = mysql_fetch_array($recSet);
$contact_id = $rec[0];
$firstName = $rec['first_name'];
$lastName = $rec['last_name'];
$phone = $rec['phone'];
$ctId = $rec['ct_id'];
};
// upisivanje novog
if (isset($_POST['send'])) {
if (isset($_POST['update'])) {
$sql = "update contact set ";
} else {
$sql = "insert into contact set ";
};
$sql .= "first_name = '".$_POST['firstName']."', ";
$sql .= "last_name = '".$_POST['lastName']."', ";
$sql .= "phone= '".$_POST['phone']."', ";
$sql .= "ct_id = '".$_POST['ctId']."', ";
$sql .= "user_id = '".$_SESSION['user_id']."' ";
if ($_FILES["datoteka"]["size"] > 0) {
// otvori fajl
$fp = fopen($_FILES["datoteka"]["tmp_name"], "r");
$data = fread($fp, $_FILES["datoteka"]["size"]);
$data = addslashes($data);
fclose($fp);
$sql .= ", file = '".$data."' ";
$sql .= ", file_name = '".$_FILES["datoteka"]["name"]."' ";
};
if (isset($_POST['update'])) {
$sql .= "where id = ".$_POST['update'];
};
//echo "66. ".$sql;
mysql_query($sql) or die(mysql_error());
if (isset($_POST['update'])) {
//$msg = 'Cestitamo! Uspesno ste izmenuli postojeci zapis.';
$msg = $lang['update ok'];
} else {
//$msg = 'Cestitamo! Uspesno ste upisali novi zapis.';
$msg = $lang['insert ok'];
};
};
// definise tekst na dugmetu
if (isset($_GET['id'])) {
$btn_submit = 'Izmeni';
} else {
$btn_submit = 'Unesi';
}
// kreiramo select menu sa tipom podatka
$sql = "select * from contact_type";
$recSet = mysql_query($sql);
$a_ct_id = array();
$a_ct_name = array();
while ($rec = mysql_fetch_array($recSet)){
$a_ct_id[] = $rec['ID'];
$a_ct_name[] = $rec['contact_type'];
};
include_once "header.php";
// selektuj sve iz tabele contact
$sql = "select * from contact ";
$sql .= "
LEFT OUTER JOIN contact_type ON
contact_type.ID = contact.ct_id ";
$sql .= " WHERE user_id = ".$_SESSION['user_id'];
if (isset($_POST['btn_search'])) {
$sql .= " AND ";
$sql .= " (";
$sql .= "first_name LIKE '%".$_POST['search_string']."%' OR ";
$sql .= "last_name LIKE '%".$_POST['search_string']."%' OR ";
$sql .= "phone LIKE '%".$_POST['search_string']."%' ";
$sql .= ")";
}
//echo $sql;
$recSet = mysql_query($sql);
// link za logout
echo "<br />";
echo "<a href='".$_SERVER['PHP_SELF']."?logout=1'>Logout</a>";
echo "<br />";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?lang=en'>English</a>";
echo " ";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?lang=rs'>Srpski</a>";
//echo "140. ".$lang['insert ok'];
?>
<form method="post" action="<?php echo basename($_SERVER['PHP_SELF']); ?>">
<input type="text" name="search_string">
<input type="submit" name="btn_search" value="<?php echo $lang['Search']; ?>">
</form>
<?php
// sistemske poruke
if (isset($msg)) echo $msg;
echo "\n<table border='1'>\n";
echo "<tr><th>Id</th><th>Ime</th><th>Prezime</th><th>Kontakt</th><th>Vrsta</th><th> </th></tr>\n";
$i = 0;
while ($rec = mysql_fetch_array($recSet)){
echo "\n<tr>";
echo "<td>";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?id=".$rec[0]."'>";
echo ++$i;
echo "</a>";
echo "</td>";
echo "<td>";
echo $rec['first_name'];
echo "</td>";
echo "<td>";
echo $rec['last_name'];
echo "</td>";
echo "<td>";
echo $rec['phone'];
echo "</td>";
echo "<td>";
echo $rec['contact_type']." ";
echo "</td>";
echo "<td>";
if (strlen($rec['file']) > 0) {
echo "<a href='download.php?id=".$rec[0]."'>".$lang['Download file']."</a>";
} else {
echo " ";
}
echo "</td>";
echo "<td>";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?delete=".$rec[0]."'>Delete</a>";
echo "</td>";
echo "</tr>\n";
};
echo "</table>\n";
?>
<form method="post" action="<?php echo basename($_SERVER['PHP_SELF']); ?>" enctype="multipart/form-data">
Ime :
<input type="text" name="firstName" value="<?php echo $firstName; ?>">
<br />
Prezime :
<input type="text" name="lastName" value="<?php echo $lastName; ?>">
<br />
Telefon :
<input type="text" name="phone" value="<?php echo $phone; ?>">
<br />
Tip:
<select name="ctId">
<option value="0">(izaberite)</option>
<?php
for ($i = 0; $i < count($a_ct_id); $i++) {
echo "<option value='".$a_ct_id[$i]."'";
if ($ctId == $a_ct_id[$i]) echo " selected ";
echo ">".$a_ct_name[$i]."</option>\n";
};
?>
</select>
<br />
Pridruzi fajl :
<input type="file" name="datoteka">
<br /><br />
<input type="submit" name="send" value="<?php echo $btn_submit; ?>">
<?php
if (isset($contact_id)) {
?>
<input type="hidden" name="update" value="<?php echo $contact_id; ?>">
<?php
};
?>
</form>
<?php
include_once "footer.php";
?>
---------------------------------------------------------------------------
<?php
/*
* contact_update.php,iAdresar
*
**/
// ucitaj podesavanja konekcije
include_once "settings.php";
// ucitaj podesavanja konekcije
include_once "connection.php";
// povezivanje na server
$db = mysql_connect(dbServer, dbUser, dbPasswd) or die(mysql_error());
mysql_select_db(dbName, $db) or die(mysql_error());
// brisanje
if (isset($_GET['delete'])) {
$sql = "delete from contact where id = ".$_GET['delete'];
mysql_query($sql) or die(mysql_error());
$msg = 'Uspesno ste obrisali zapis.';
};
if (isset($_GET['id'])) {
$sql = "select * from contact where id = ".$_GET['id'];
//echo $sql;
$recSet = mysql_query($sql) or die(mysql_error());
$rec = mysql_fetch_array($recSet);
$contact_id = $rec[0];
$firstName = $rec['first_name'];
$lastName = $rec['last_name'];
$phone = $rec['phone'];
};
// upisivanje novog
if (isset($_POST['send'])) {
if (isset($_POST['update'])) {
$sql = "update contact set ";
} else {
$sql = "insert into contact set ";
};
$sql .= "first_name = '".$_POST['firstName']."', ";
$sql .= "last_name = '".$_POST['lastName']."', ";
$sql .= "phone= '".$_POST['phone']."' ";
if (isset($_POST['update'])) {
$sql .= "where id = ".$_POST['update'];
};
//echo "66. ".$sql;
mysql_query($sql) or die(mysql_error());
if (isset($_POST['update'])) {
$msg = 'Cestitamo! Uspesno ste izmenuli postojeci zapis.';
} else {
$msg = 'Cestitamo! Uspesno ste upisali novi zapis.';
};
};
// definise tekst na dugmetu
if (isset($_GET['id'])) {
$btn_submit = 'Izmeni';
} else {
$btn_submit = 'Unesi';
}
include_once "header.php";
// selektuj sve iz tabele contact
$sql = "select * from contact";
$recSet = mysql_query($sql);
// sistemske poruke
if (isset($msg)) echo $msg;
echo "\n<table border='1'>\n";
echo "<tr><th>Id</th><th>Ime</th><th>Prezime</th><th> </th></tr>\n";
$i = 0;
while ($rec = mysql_fetch_array($recSet)){
echo "\n<tr>";
echo "<td>";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?id=".$rec[0]."'>";
echo ++$i;
echo "</a>";
echo "</td>";
echo "<td>";
echo $rec['first_name'];
echo "</td>";
echo "<td>";
echo $rec['last_name'];
echo "</td>";
echo "<td>";
echo $rec['phone'];
echo "</td>";
echo "<td>";
echo "<a href='".basename($_SERVER['PHP_SELF'])."?delete=".$rec['ID']."'>Delete</a>";
echo "</td>";
echo "</tr>\n";
};
echo "</table>\n";
?>
<form method="post" action="<?php echo basename($_SERVER['PHP_SELF']); ?>">
Ime :
<input type="text" name="firstName" value="<?php echo $firstName; ?>">
<br />
Prezime :
<input type="text" name="lastName" value="<?php echo $lastName; ?>">
<br />
Telefon :
<input type="text" name="phone" value="<?php echo $phone; ?>">
<br />
<input type="submit" name="send" value="<?php echo $btn_submit; ?>">
<?php
if (isset($contact_id)) {
?>
<input type="hidden" name="update" value="<?php echo $contact_id; ?>">
<?php
};
?>
</form>
<?php
include_once "footer.php";
?>
----------------------------------------------------------------------------
<?php
// download.php, download fajla iz baze
// ucitaj podesavanja konekcije
include_once "connection.php";
// povezivanje na server
$db = mysql_connect(dbServer, dbUser, dbPasswd) or die(mysql_error());
mysql_select_db(dbName, $db) or die(mysql_error());
$sql = "select * from contact where id = ".$_GET['id'];
$result = mysql_query($sql);
$row = mysql_fetch_array($result);
header("Content-type: application/force-download");
header('Content-Disposition: attachment; filename="'.$row['file_name'].'"');
echo $row['file'];
exit;
?>
----------------------------------------------------------------------
<?php
// en.php, engleski
$lang['insert ok'] = "Success! Insert is OK!"; // Success! Insert is OK!
$lang['update ok'] = "Success! Update is OK!"; // Success! Update is OK!
$lang['Delete success'] = 'Delete success.'; // Delete success.
$lang['Download file'] = "Download file"; // Download file
$lang['Search'] = "Search";
?>
--------------------------------------------------------------------
//footer.php
<br />
©
<?php echo date('Y'); ?>
<?php echo APP_DEVELOPER; ?>
</body>
</html>
---------------------------------------------------------------------
//header.php
<html>
<head>
<title><?php echo APP_NAME; ?></title>
</head>
<body>
-------------------------------------------------------------------------
<?php
// index.php, login forma
session_start();
// ako sam ulogovan, posalji me na sledecu stranicu
if ($_SESSION["ulogovan"] == "da") {
header("location: contact.php");
exit;
}
// ucitaj podesavanja konekcije
include_once "settings.php";
// ucitaj podesavanja konekcije
include_once "connection.php";
// povezivanje na server
$db = mysql_connect(dbServer, dbUser, dbPasswd) or die(mysql_error());
mysql_select_db(dbName, $db) or die(mysql_error());
if (isset($_POST['posalji'])) {
$sql = "select * from user where ";
$sql .= " username = '".$_POST['username']."' ";
$sql .= " and password = '".$_POST['sifra']."' ";
//echo $sql;
$recSet = mysql_query($sql);
if (mysql_num_rows($recSet) == '1') {
$_SESSION['ulogovan'] = 'da';
setcookie('c_username', $_POST['username'], (time() + (60 * 60 *24 *365)));
while ($row = mysql_fetch_array($recSet)) {
$_SESSION['user_id'] = $row[0];
$_SESSION['user_name'] = $row['name'];
};
header("location: contact.php");
exit;
} else {
// u slucaju pogresnog logovanja...
header("location: ".basename($_SERVER['PHP_SELF'])."?login=error");
exit;
};
}
// ocitavamo cookie sa username-om
$username = $_COOKIE["c_username"];
?>
<form method="post" action="<?php echo basename($_SERVER['PHP_SELF']); ?>">
Korisnicko ime :
<input type="text" name="username" value="<?php echo $username; ?>">
<br />
Sifra :
<input type="password" name="sifra">
<br /><br />
<input type="submit" name="posalji" value="Prijava">
</form>
----------------------------------------------------------------------------------
<?php
// rs.php, srpski
$lang['insert ok'] = "Uspesno ste uneli novi zapis!";
$lang['update ok'] = "Uspesno ste izmenuli zapis";
$lang['Delete success'] = 'Uspesno ste obrisali zapis.';
$lang['Download file'] = "Preuzmi fajl";
$lang['Search'] = "Pretraga";
?>
-------------------------------------------------------------------------------------
<?php
/*
* settings.php, , podesavanja aplikacije
*
**/
define('APP_NAME', 'iAdresar');
define('APP_DEVELOPER', 'Smart Team');
?>
----------------------------------------------------------------------------------------
Nesto ne valja... Javlja gresku u browseru. Vjerujem da je za sad i ovog previse... Za mail cu pitati drugom prilikom, kao i za sesije. Pozdrav, hvala!
:)