Php podsjetnik
Pozdrav!
Našao sam na internetu php skripte za email podsjetnik. Prilagodio sam ih sebi i dodao login da ne može svatko dodavati podsjetnike (korisnik se logira sa email i password). Sad sam stao na tome da kad se netko logira treba prikazati samo njegove podsjetnike odnosno da query izlista samo podsjetnike u kojima je email korisnika koji se ulogirao.
Baza se sastoji od tablica login i reminder.
Ovo su skripte:
index.php
[code]
<table width="300" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC"><tr>
<form name="form1" method="post" action="checklogin.php">
<td>
<table width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td colspan="3"><strong>Prijava </strong></td>
</tr>
<tr>
<td width="78">Email</td>
<td width="6">:</td>
<td width="294"><input name="Email" type="text" id="Email"></td>
</tr>
<tr>
<td>Password</td>
<td>:</td>
<td><input name="password" type="password" id="password"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Login"></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
[/code]
checklogin.php
[code]
<?php$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// username and password sent from form
$Email=$_POST['Email'];
$password=$_POST['password'];
// To protect MySQL injection (more detail about MySQL injection)
$Email = stripslashes($Email);
$password = stripslashes($password);
$Email = mysql_real_escape_string($Email);
$password = mysql_real_escape_string($password);
$sql="SELECT * FROM $tbl_name WHERE Email='$Email' and password='$password'";
$result=mysql_query($sql);
// Mysql_num_row is counting table row
$count=mysql_num_rows($result);
// If result matched $Email and $mypassword, table row must be 1 row
if($count==1){
session_register("Email");
session_register("password");
header("location:reminder_list.php");
}
else {
echo "Pogresan Email ili Password";
}
?>
[/code]
reminder_list.php
[code]
<?phpsession_start();
// Check for the session value.
if(!session_is_registered(Email)){
header("location:index.php");
}
include('database.inc.php'); // Our database connectivity file
if( empty($_GET['Email']) )
{
?>
<html>
<head><title>Lista podsjetnika</title></head>
<body>
<table width="90%" border="0" align="center">
<tr>
<td colspan='3'><a href='reminder_setup.php'>Dodaj podsjetnik</a></td>
</tr>
<tr>
<td colspan='6'><a href='logout.php'>Logout</a></td>
</tr>
<?php
$result = mysql_query( "SELECT * FROM reminder_events");
$nr = mysql_num_rows( $result );
if(empty($nr))
{
echo("
<tr>
<td colspan='3'>Nema podsjetnika</td>
</tr>
");
}
while( $row = mysql_fetch_array( $result ))
{
$Email=$row["Email"];
$reminder_name = $row["reminder_name"];
$reminder_desc = $row["reminder_desc"];
$reminder_date = $row["reminder_year"]."-".$row["reminder_month"]."-".$row["reminder_date"];
$reminder_id = $row["reminder_id"];
echo("
<tr>
<td width='20%'>$reminder_name</td>
<td width='60%'>$reminder_desc</td>
<td width='10%'>$reminder_date</td>
<td width='10%'><a href='reminder_list.php?reminder_id=$reminder_id'>delete</a></td>
</tr>
");
}
mysql_free_result( $result );
?>
</table>
</body>
</html>
<?php
}
else
{
mysql_query( "DELETE FROM reminder_events WHERE reminder_id='".addslashes($_GET['reminder_id'])."'" );
// Let's go back to the Reminder List page
Header("Refresh: 1;url=reminder_list.php");
echo <<< _HTML_END_
Reminder Deleted, redirecting...
_HTML_END_;
}
?>
[/code]
hvala!
Poruka je uređivana zadnji put sub 29.1.2011 19:37 (vektra112).
