|
PHP - Moved: Simple Php Code To Detect The Presence Of Text In A Private Forum Message
This topic has been moved to PHP Freelancing.
http://www.phpfreaks.com/forums/index.php?topic=358545.0 Similar TutorialsThis topic has been moved to PHP Regex. http://www.phpfreaks.com/forums/index.php?topic=326450.0 im trying to make a private message system now when i send a message it works fine but when i open the message at the other end i get a blank message. now i think the problem is with $messageid = $_GET['messages'] when i echo $messageid i get nothing, if i use the print_r($_GET) it returns Array ( [messageid] => 12 ). thanks Code: [Select] <?php session_start(); $myusername=$_SESSION['myusername']; require "database.php"; $messageid = $_GET['messages']; $message = mysql_query("SELECT * FROM messages WHERE message_id = '$messageid' AND to_user = '$myusername'"); $message=mysql_fetch_assoc($message); echo "$message"; echo "<h1>Title: ".$message['message_title']."</h1><br><br>"; echo "<h3>From: ".$message['from_user']."<br><br></h3>"; echo "<h3>Message: <br>".$message['message_contents']."<br></h3>"; echo '<form name="backfrm" method="post" action="inbox.php">'; echo '<input type="submit" value="Back to Inbox">'; echo '</form>'; ?> Hello, i have a private message system nearly done , the only thing that i cant get to work is the Trash messages that a user has... so the user can delete messages either from the inbox/sent/friends box ... then each message row gets update with pm_sender_is_deleted='1' or pm_reciever_is_deleted='1' , depends if the message was deleted in the inbox or sent box respectively. Here is my db structure on the first table: pm_id int(11) pm_msg_id int(11) pm_sender_id varchar(30) pm_reciever_id varchar(30 pm_sender_isSpam tinyint(1) pm_sender_isRead tinyint(1) pm_sender_is_deleted tinyint(1) pm_sender_is_removed tinyint(1) pm_reciever_isSpam tinyint(1) pm_reciever_isRead tinyint(1) pm_reciever_is_deleted tinyint(1) pm_reciever_is_removed tinyint(1) here is the second: usermessages_id int(11) usermessages_msg_id int(11) usermessages_sender_id varchar(30) usermessages_reciever_id varchar(30) usermessages_subject varchar(300) usermessages_content usermessages_created_at datetime usermessages_canReply tinyint(1) When a user decides to delete a message i update the _is_deleted as i said above successfully. It seems that i cant get the a correct SQL code to display the mesages that i have deleted... These 3 queries tells how many msgs are in the trash for each user: //get messages that i have sent to myself $get_same = mysql_query("SELECT * FROM glr_pm_data WHERE pm_sender_id='$email' && pm_reciever_id='$email' && pm_sender_is_deleted='1' && pm_reciever_is_deleted='1' && pm_sender_is_removed='0' && pm_reciever_is_removed='0'"); $same = mysql_num_rows($get_same); //get messages that i have recieved $get_rec = mysql_query("SELECT * FROM glr_pm_data WHERE pm_reciever_id='$email' && pm_reciever_is_deleted='1' && pm_sender_id!='$email' && pm_reciever_is_removed='0'"); $new = mysql_num_rows($get_rec); //get messages that i have sent to others and NOT to myself $get_snd = mysql_query("SELECT * FROM glr_pm_data WHERE pm_sender_id='$email' && pm_sender_is_deleted='1' && pm_sender_is_removed='0' && pm_reciever_id!='$email'"); a query i have tried to display the trash messages is: $query = "SELECT * FROM glr_pm_data INNER JOIN glr_usermessages ON glr_pm_data.pm_msg_id=glr_usermessages.usermessages_msg_id && (pm_sender_id='$email' && pm_reciever_id='$email' && pm_sender_is_deleted='1' && pm_sender_is_removed='0' && pm_reciever_is_deleted='1' && pm_reciever_is_removed='0') || (pm_reciever_id='$email' && pm_sender_id!='$email' && pm_reciever_is_deleted='1' && pm_reciever_is_removed='0') || (pm_sender_id='$email' && pm_reciever_id!='$email' && pm_sender_is_deleted='1' && pm_sender_is_removed='0') ORDER BY glr_pm_data.pm_id DESC $limit"; So if anyone can help me out create a correct query to display the trash messages i would appreciate.. Hello World ! i got this script of PM system on my website where 2 or 3 users can send PM to each other it work ok but it
<?php
header : PM (unread count)
$msgs_count = GetUnreadMessagesCount($session_user["id"]);
and got this in the Index header : PM <span>( <?=$msgs_count;?> )</span>
/* Hello World ! i got a website where 2 or 3 users can create and send PM everything work good but have this bug . */
Example message thread#id1 Sender: A send the message to B & C ok now B & C got PM (1)
B make reply to this PM and C the same now the bug is userA will have PM(2) like he have 2unread messages
but is different reply in the same message so need to count only (1) by Thread not reply ok if A read it and send new reply now B & C will have PM (3)
i hope someone can help me with this code thank you !
this is message_tbl for database
<?php
$tbl_messages_fields = array(
"id" => "INTEGER PRIMARY KEY AUTO_INCREMENT",
"threadId" => "INT(11)",
"type" => "VARCHAR(4)",
"heldById" => "INT",
"fromId" => "INT",
"toId" => "VARCHAR(32)",
"isRead" => "INT(1) $d0",
"isStarred" => "INT(1) $d0",
"isDeleted" => "INT(1) $d0",
"subject" => "VARCHAR(150)",
"message" => "VARCHAR(10000)",
"timestamp" => "INT(12)");
SetupTable('tbl_messages', $tbl_messages_fields);
function UpdateMessageField($conditions, $field, $value){
global $dbPrep;
$add = array();
foreach($conditions as $key=>$val){
$add[] = "`$key`=:$key";
}
$add = implode(" AND ", $add);
$sql = "UPDATE `tbl_messages` SET $field=:$field WHERE $add";
$query = $dbPrep->prepare($sql);
$data = array_merge($conditions, array("$field"=>$value));
$query->execute($data);
}
function GetMessagesQuery($data = array(), $complexConditions = "", $extra = ""){
$dbPrep = GetDatabaseConnection();
$sql = "SELECT * FROM `tbl_messages` ";
$add = " ";
foreach($data as $key=>$value){
$add.= "AND `$key`=:$key ";
}
$add = ($add != " ") ? "WHERE" . substr($add, 4, strlen($add)) : $add;
$sql.= $add." ".$complexConditions." ".$extra;
$query = $dbPrep->prepare($sql);
$query->execute($data);
return GetRows($query);
}
function GetThreadQuery($conditions = array(), $complexConditions = "", $extra = ""){
global $dbPrep;
$add = array();
foreach($conditions as $key=>$val){
$add[] = "`$key`=:$key";
}
$add = implode(" AND ", $add);
$sql = "SELECT a.*, b.username AS fromUsername, b.type AS fromType FROM `tbl_messages` AS a ";
$sql .= "INNER JOIN `tbl_users` AS b ON a.fromId=b.id ";
$sql .= "WHERE $add ORDER BY timestamp ASC";
#echo $sql;
$query = $dbPrep->prepare($sql);
$query->execute($conditions);
return GetRows($query);
}
$p_NewMessage = $dbPrep->prepare("INSERT INTO `tbl_messages` (type, threadId, heldById, fromId, toId, subject, message, timestamp) VALUES (:type, :threadId, :heldById, :fromId, :toId, :subject, :message, :timestamp);");
$sql = "SELECT a.*, b.type as fromType FROM `tbl_messages` AS a ";
$sql .= "INNER JOIN `tbl_users` AS b ON a.fromId=b.id ";
$sql .= "WHERE threadId=:id AND heldById=:heldById AND isDeleted=0 ORDER BY timestamp ASC";
$p_GetSingleMessage = $dbPrep->prepare($sql);
function UnDeleteThread($threadId, $heldById){
global $dbPrep;
$p_UnDeleteThread = $dbPrep->prepare("UPDATE `tbl_messages` SET isDeleted=0,isRead=0 WHERE threadId=:threadId AND heldById=:heldById");
$p_UnDeleteThread->execute(array("threadId"=>$threadId, "heldById"=>$heldById));
}
function GetRecipients($sessId, $fromId, $toId){
$allParties = $sessId . "," . $fromId . "," . $toId;
$arr = array_unique(explode(",", $allParties));
if (($key = array_search($sessId, $arr)) !== false) {
unset($arr[$key]);
}
return implode (",", $arr);
}
function GetRecipientName($id){
global $dbPrep;
$sql = "SELECT username FROM `tbl_users` WHERE id=:id";
$query = $dbPrep->prepare($sql);
$query->execute(array("id"=>$id));
$row = $query->fetch( PDO::FETCH_ASSOC );
return $row["username"];
}
function GetRecipientNames($recipients){
$all = explode(",", $recipients);
$val = array();
foreach ($all as $a){
$val[] = GetRecipientName($a);
}
return $val;
}
$p_GetUnreadMessagesCount = $dbPrep->prepare("SELECT COUNT(*) FROM `tbl_messages` WHERE isRead=0 AND heldById=:heldById AND type='recv'");
$unreadMsgsCount = -1;
function GetUnreadMessagesCount($uid){
global $unreadMsgsCount;
global $p_GetUnreadMessagesCount;
if($unreadMsgsCount == -1){
$p_GetUnreadMessagesCount->execute(array("heldById"=>$uid));
$unreadMsgsCount = $p_GetUnreadMessagesCount->fetch( PDO::FETCH_ASSOC );
$unreadMsgsCount = $unreadMsgsCount["COUNT(*)"];
}
return $unreadMsgsCount;
}
function GetNewThreadId(){
global $dbPrep;
$threadId = 1;
$p_GetLatestThreadId = $dbPrep->prepare("SELECT MAX(threadId) FROM `tbl_messages`");
$p_GetLatestThreadId->execute();
$latestThreadId = $p_GetLatestThreadId->fetch( PDO::FETCH_ASSOC );
if($latestThreadId){
$threadId = $latestThreadId["MAX(threadId)"]+1;
}
return $threadId;
}
?>
if(isset($_REQUEST["mark_read"])){
if(isset($_REQUEST["message_all_toggle"]))
foreach($_REQUEST["message_all"] as $m)
SetNotificationRead($m, $session_user["id"], 1);
elseif(isset($_REQUEST["message"]))
foreach($_REQUEST["message"] as $m)
SetNotificationRead($m, $session_user["id"], 1);
else
foreach($_REQUEST["message_all"] as $m)
SetNotificationRead($m, $session_user["id"], 1);
}
if(isset($_REQUEST["mark_unread"])){
if(isset($_REQUEST["message_all_toggle"]))
foreach($_REQUEST["message_all"] as $m)
SetNotificationRead($m, $session_user["id"], 0);
elseif(isset($_REQUEST["message"]))
foreach($_REQUEST["message"] as $m)
SetNotificationRead($m, $session_user["id"], 0);
else
foreach($_REQUEST["message_all"] as $m)
SetNotificationRead($m, $session_user["id"], 0);
}
if(isset($_REQUEST["delete"])){
if(isset($_REQUEST["message_all_toggle"]))
foreach($_REQUEST["message_all"] as $m)
RemoveNotificationById($m, $session_user["id"]);
elseif(isset($_REQUEST["message"]))
foreach($_REQUEST["message"] as $m)
RemoveNotificationById($m, $session_user["id"]);
}
} else {
if(isset($_REQUEST["delete"])){
if(is_numeric($_REQUEST["delete"])){
UpdateMessageField(array("threadId"=>$_REQUEST["delete"], "heldById"=>$session_user["id"]), "isStarred", 0);
UpdateMessageField(array("threadId"=>$_REQUEST["delete"], "heldById"=>$session_user["id"]), "isDeleted", 1);
UpdateMessageField(array("threadId"=>$_REQUEST["delete"], "heldById"=>$session_user["id"]), "isRead", 1);
}elseif(isset($_REQUEST["message_all_toggle"])){
$messages = $_REQUEST["message_all"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 0);
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isDeleted", 1);
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 1);
}
}elseif(isset($_REQUEST["message"])){
$messages = $_REQUEST["message"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 0);
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isDeleted", 1);
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 1);
}
}
}
if(isset($_REQUEST["messagestar"])){
if(isset($_REQUEST["message_all_toggle"])){
$messages = $_REQUEST["message_all"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 1);
}
}elseif(isset($_REQUEST["message"])){
$messages = $_REQUEST["message"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 1);
}
}
}
if(isset($_REQUEST["deletestarred"])){
if(isset($_REQUEST["message_all_toggle"])){
$messages = $_REQUEST["message_all"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 0);
}
}elseif(isset($_REQUEST["message"])){
$messages = $_REQUEST["message"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isStarred", 0);
}
}
}
if(isset($_REQUEST["mark_unread"])){
if(isset($_REQUEST["message_all_toggle"])){
$messages = $_REQUEST["message_all"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 0);
}
}elseif(isset($_REQUEST["message"])){
$messages = $_REQUEST["message"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 0);
}
}
}
if(isset($_REQUEST["mark_read"])){
if(isset($_REQUEST["message_all_toggle"])){
$messages = $_REQUEST["message_all"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 1);
}
}elseif(isset($_REQUEST["message"])){
$messages = $_REQUEST["message"];
foreach($messages as $m){
UpdateMessageField(array("threadId"=>$m, "heldById"=>$session_user["id"]), "isRead", 1);
}
}
}
}
$details = isset($_REQUEST["details"])?$_REQUEST["details"]:0;
$session_user = GetUserById($session_user["id"]);
This topic has been moved to Third Party PHP Scripts. http://www.phpfreaks.com/forums/index.php?topic=346794.0 i am facing a problem regarding the insertion of of link in a text area is not detected but the output is a normal text "unlike facebook comments" is there any php functions ??? thanks in advance This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=348759.0 This topic has been moved to PHP Freelancing. http://www.phpfreaks.com/forums/index.php?topic=357368.0 Code: [Select] if ($showigiteidimage) { $igitwid_divlnk = "onclick=location.href='" . get_permalink($igitwid_result->ID) . "'; style=cursor:pointer;"; $igitwid_output .= '<li id="igit_wid_rpwt_li" style="height:' . $igitwid_height . 'px; padding-bottom: 10px;" ' . $igitwid_divlnk . '>'; $igitwid_output .= '<div id="igit_wid_rpwt_main_image" style="float:left;"> <a href="' . get_permalink($igitwid_result->ID) . '" target="_top"><img src="<?php $values = get_post_custom_values("tj_video_img_url"); echo $values[0]; ?>" id="igit_rpwt_thumb" ></a></div>'; the prb is image src cant read the php code , what to do ? please helpppppppppp Hi guys, I have this code:
<?php
// This Code Works
if (isset($_POST{"PantryID"})) {
Create_Pantry($_POST{"PantryID"});
}
// This Code Isn't Working, Keeps Going To 'Else'.
if (isset($_POST{"ItemName"})){
Add_Item($_POST{"ItemName"}, $_POST{"ItemWeight"}, $_POST{"ItemPrice"}, $_POST{"ItemDate"});
}else{
echo "Nothing To do";
}
?>
here is the html <label for="PantryID">Create Pantry: </label> <input type="text" id="PantryID" name="PantryID" disabled="true" /> <label for="ItemName">Item Name: </label> <input type="text" id="ItemName" name="ItemName" disabled="true" /> Please help, I can't find any syntax errors. - At the point the PHP is activated it is no longer disabled. the PantryID is set up the same way. Edited September 27, 2020 by jahickiCorrection i'm trying to use this code to detect if the browser of the user is IE (any version) and id true (if it is IE), then it's redirected to an error page; otherwise, it's ok and sent ot the index. I get the following error... Warning: Cannot modify header information - headers already sent by (output started at /index.php:1) in /xie.php on line 13 any ideas.. ??? <?php function ae_detect_ie() { if (isset($_SERVER['HTTP_USER_AGENT']) && (strpos($_SERVER['HTTP_USER_AGENT'], 'MSIE') !== false)) return true; else return false; } if (ae_detect_ie()) { header("Location: error.php"); } else { header("Location: index.php"); } ?> Hi, Im trying to make a script to mass update a load of links in my database but im stuck on the basics, How can i detect a new line in a text area? Anyone know why this dosen't work? Code: [Select] <?php if($_POST[newlinks]) { $newlinks = preg_split("\n", ($_POST['newlinks'])); $i = 1; foreach ($newlinks as $newlink) { echo "$i - $newlink <br />"; $i++; } } else { echo "<form method=\"POST\" action=\"changehost.php\">"; echo "<br /> <strong>Enter the new links to try and replace old ones</strong> <br />"; echo "<textarea rows=\"16\" name=\"newlinks\" cols=\"84\"></textarea>"; echo "<input type=\"submit\" value=\"Submit\" name=\"B1\">"; ?> This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=305801.0 This topic has been moved to Other Programming Languages. http://www.phpfreaks.com/forums/index.php?topic=347880.0 Hi there, I've looked into the PHP superglobal array $_SERVER, but could not find a variable that stores the plugins a client has on his/her browser such as firefox and google chrome. The point here is to detect if a user has hacking addons such as firebug and inspect element installed, and displays an error message telling the user to disable such plugins in order to access site content. Is it possible to accomplish such tasks? Please help. This topic has been moved to Miscellaneous. http://www.phpfreaks.com/forums/index.php?topic=306605.0 This topic has been moved to PHP Freelancing. http://www.phpfreaks.com/forums/index.php?topic=323425.0 Folks, When someone click on a link on my webpage and if that Link takes the visitor off my site, then i want to make an entry in my database. But if that link goes back to some other link in my Site then i do not want to Count that link. So, is there any code that lets me detect any outgoing link Click? Cheers Hi all, I'm very new to the wonderful world of php, so I'd appreciate any and all help in the matter. I've greatly simplified the code below to hopefully help you in helping me. Thanks! Ok, so I'm integrating a very simple message board feature into my site. The basic idea is that people post a comment, and have the option of replying to existing comments. I'm definitely not looking for a complete forum; just something that allows users to post and reply. I've tackled the posting bit easily enough. I have a form. Users fill in the form and the message, along with user information, is sent to a MySQL database. The information includes the username(Poster), the message(Message), an id that corresponds to the topic in question(Messid), a unique ID code for the message itself (ID), and a number of other variables like date and rank. I then use a while statement to bring up all of the messages that pertain to a particular topic; The output will only show messages that share the same Messid, and they are arranged in terms of descending ID: Code: [Select] <? while($row = mysql_fetch_array($resultcomments)) { $poster=$row['Poster']; $message= $row['Message']; $ID=$row['ID']; echo $message.$poster.$ID; } So far, so good. What I want is for users to be able to click on any one of the particular messages, and post a response comment that will appear directly below the message to which it responds. Any ideas how I might go about such a task? So far, I've created a new MySQL table that corresponds to these "subcomments". Each subcomment has a "subID" that corresponds to the ID of the message to which it responds. By including a while statement within the while statement above, I can successfully list all of the subcomments that correspond to a message directly below it. The problem, of course, is that I have to insert the subID values manually in php_my_admin. I'm hoping there's a way for php to automatically detect the ID value of the message in question... Many many thanks for any assistance I can get. Once this revolution in communication makes me a billionaire, I will be certain to reward you most properly. Thanks again. This topic has been moved to PHP Applications. http://www.phpfreaks.com/forums/index.php?topic=354184.0 |
|||||||