|
Pozdrav. Hteo bih kada se korisnik uloguje i klikne na link od drugog korisnika, da mu ispise linkovan SEND MESSAGE i kad tu prvi korisnik klikne da moze da salje drugom korisniku. znaci neka ide ovako link
user_profile?username=test. E sad kada jel moze neko da mi pomogne oko scripte koju sam nasao na netu.
functionList.php
<?php
include_once('connect.inc.php');
function sendMessage($from,$to,$message)
{
if(empty($from)) { return 'Error, Sender was not set'; }
elseif(empty($to)) { return 'Error, No recepient specified'; }
elseif(empty($message)) { return 'Error, Please do not send empty messages'; }
else
{
$date = date("F d, Y");
$from = mysql_real_escape_string($from);
$to = mysql_real_escape_string($to);
$message = mysql_real_escape_string($message);
$query = "INSERT INTO `messages` VALUES ('$date','$from','$to','$message')";
if(mysql_query($query))
{
$string = 'Message Sent';
}
else { $string = 'An error has occured, message was lost'; }
}
return $string;
}
function getMessages($user)
{
$query = "SELECT * FROM `messages` WHERE `sent_to`='$user'";
$result = mysql_query($query);
if(mysql_affected_rows() > 0)
{
while($row = mysql_fetch_assoc($result))
{
echo 'Message from '. $row['sent_by']
.'On '. $row['date_sent']
.'<hr/>'
. $row['message']
.'<a href="?cmd=delete&id='.$row['id'].'">Delete Message</a>';
}
}
else {echo 'No messages'; }
return;
}
function countMessages($user)
{
$query = "SELECT * FROM `messages` WHERE `sent_to`='$user'";
$result = mysql_query($query);
$count = mysql_affected_rows();
return $count;
}
function deleteMessages($id)
{
$query = "DELETE FROM `messages` WHERE `id`='$id'";
mysql_query($query);
return;
}
?>
Send_message_once
<?php
include_once('functionList.php');
$user = $_SESSION['user_id'];
if(isset($_POST['SendNow']))
{
sendMessage($_POST['from'],$_POST['name'],$_POST['message']);
}
?>
<form action="" method="post">
<input type="hidden" value="<?php echo $user; ?>" name="from"/>
<label for="name">Sent Message to:</label>
<input type="text" name="name" value=""/>
<label for="message">Message</label>
<textarea cols="40" rows="10" name="message"></textarea>
<input type="submit" value="Send" name="SendNow"/>
</form>
view_message_once
<?php
//view messages page
include_once('functionList.php');
//process deletions
if($_GET['cmd'] == 'delete')
{
deleteMessages($_GET['id']);
}
//who is the user
$user = 'John';
getMessages($user);
?>
i imam scriptu za konektovanje u bazu..
E sad imam tabelu messages sa 4 rows-a (date_sent,sent_by,sent_to,message)
Glavni problem je to sto sam probao skriptu i kada unsem npr poruku i username od nekog korisnika nece da unese u bazu. Molim za pomoc, hvala unpred
|
