PHP - Date Post To Db

I'm learning PHP, and in the course of this, I'm writing a little app which posts to the same php file. HOWEVER, when I run the app again, the POST values remain. I can use unset() but, is there another way to clear POST data?

RON

ok i want to be able to delete the post only if there the one who posted aka blabbed here is the script , please help. if im not clear please tell me!

Code: [Select]

<?php



// Start_session, check if user is logged in or not, and connect to the database all in one included file

include_once("scripts/checkuserlog.php");



if (!$_SESSION['idx']) { 

    $msgToUser = '<br /><br /><font color="#FF0000">Sorry but you must be logged in to view this page!</font><p><br><div align="right"><a href="register.php">Join Here</a></div><form id="signinform" action="login.php" method="post" enctype="multipart/form-data" name="signinform">

    <fieldset>

    

      <legend>Log in</legend>

     

      <label for="login">Email</label>

      <input type="text" id="email" name="email" />

      <div class="clear"></div>

      

      <label for="password">Password</label>

      <input type="password" id="password" name="pass" />

      <div class="clear"></div>

      

      <label for="remember_me" style="padding: 0;">Remember me?</label>

      <input type="checkbox" id="remember" style="position: relative; top: 3px; margin: 0; " name="remember"/ value="yes" checked="checked">

      <div class="clear"></div>

      

      <br />

      

      <input type="submit" style="margin: -20px 0 0 287px;" class="button" name="commit" value="Sign In"/> 

    </fieldset>

  </form></p>';

    include_once 'msgToUser.php'; 

    exit(); 

} else if ($logOptions_id != $_SESSION['id']) {

    $msgToUser = '<br /><br /><font color="#FF0000">Only site members can do that</font><p><a href="register.php">Join Here</a></p>';

    include_once 'msgToUser.php'; 

    exit(); 

}

// Include the class files for auto making links out of full URLs and for Time Ago date formatting

include_once("wi_class_files/autoMakeLinks.php");

include_once ("wi_class_files/agoTimeFormat.php");

// Create the two new objects before we can use them below in this script

$activeLinkObject = new autoActiveLink;

$myObject = new convertToAgo;

?>

<?php 

// ------- INITIALIZE SOME VARIABLES ---------

// they must be initialized in some server environments or else errors will get thrown

$id = "";

$username = "";

$firstname = "";

$lastname = "";

$mainNameLine = "";

$country = "";    

$state = "";

$city = "";

$zip = "";

$bio_body = "";

$website = "";

$youtube = "";

$facebook = "";

$twitter = "";

$twitterWidget = "";

$locationInfo = "";

$user_pic = "";

$blabberDisplayList = "";

$interactionBox = "";

$cacheBuster = rand(999999999,9999999999999); // Put on an image URL will help always show new when changed

// ------- END INITIALIZE SOME VARIABLES ---------



// ------- ESTABLISH THE PAGE ID ACCORDING TO CONDITIONS ---------

if (isset($_GET['id'])) {

     $id = preg_replace('#[^0-9]#i', '', $_GET['id']); // filter everything but numbers

} else if (isset($_SESSION['idx'])) {

     $id = $logOptions_id;

} else {

   header("location: index.php");

   exit();

}

// ------- END ESTABLISH THE PAGE ID ACCORDING TO CONDITIONS ---------



// ------- FILTER THE ID AND QUERY THE DATABASE --------

$id = preg_replace('#[^0-9]#i', '', $id); // filter everything but numbers on the ID just in case

$sql = mysql_query("SELECT * FROM myMembers WHERE id='$id' LIMIT 1"); // query the member

// ------- FILTER THE ID AND QUERY THE DATABASE --------



// ------- MAKE SURE PERSON EXISTS IN DATABASE ---------

$existCount = mysql_num_rows($sql); // count the row nums

 if ($existCount == 0) { // evaluate the count

     header("location: index.php?msg=user_does_not_exist");

     exit();

}

// ------- END MAKE SURE PERSON EXISTS IN DATABASE ---------



// ------- WHILE LOOP FOR GETTING THE MEMBER DATA ---------

while($row = mysql_fetch_array($sql)){ 

    $username = $row["username"];

    $firstname = $row["firstname"];

    $lastname = $row["lastname"];

    $country = $row["country"];    

    $state = $row["state"];

    $city = $row["city"];

    $sign_up_date = $row["sign_up_date"];

    $sign_up_date = strftime("%b %d, %Y", strtotime($sign_up_date));

    $last_log_date = $row["last_log_date"];

    $last_log_date = strftime("%b %d, %Y", strtotime($last_log_date));    

    $bio_body = $row["bio_body"];    

    $bio_body = str_replace("'", "'", $bio_body);

    $bio_body = stripslashes($bio_body);

    $website = $row["website"];

    $youtube = $row["youtube"];

    $facebook = $row["facebook"];

    $twitter = $row["twitter"];

    $friend_array = $row["friend_array"];

    ///////  Mechanism to Display Pic. See if they have uploaded a pic or not  //////////////////////////

    $check_pic = "members/$id/image01.jpg";

    $default_pic = "members/0/image01.jpg";

    if (file_exists($check_pic)) {

    $user_pic = "<img src=\"$check_pic?$cacheBuster\" width=\"218px\" />"; 

    } else {

    $user_pic = "<img src=\"$default_pic\" width=\"218px\" />"; 

    }

    ///////  Mechanism to Display Real Name Next to Username - real name(username) //////////////////////////

    if ($firstname != "") {

        $mainNameLine = "$firstname $lastname ($username)";

        $username = $firstname;

    } else {

        $mainNameLine = $username;

    }

    ///////  Mechanism to Display Youtube channel link or not  //////////////////////////

    if ($youtube == "") {

    $youtube = "";

    } else {

    $youtube = '<br /><br /><img src="images/youtubeIcon.jpg" width="18" height="12" alt="Youtube Channel for ' . $username . '" /> <strong>YouTube Channel:</strong><br /><a href="http://www.youtube.com/user/' . $youtube . '" target="_blank">youtube.com/' . $youtube . '</a>';

    }

    ///////  Mechanism to Display Facebook Profile link or not  //////////////////////////

    if ($facebook == "") {

    $facebook = "";

    } else {

    $facebook = '<br /><br /><img src="images/facebookIcon.jpg" width="18" height="12" alt="Facebook Profile for ' . $username . '" /> <strong>Facebook Profile:</strong><br /><a href="http://www.facebook.com/profile.php?id=' . $facebook . '" target="_blank">profile.php?id=' . $facebook . '</a>';

    }

    ///////  Mechanism to Display Twitter Tweet Widget or not  //////////////////////////

    if ($twitter == "") {

    $twitterWidget = "";

    } else {

    $twitterWidget = "<script src=\"http://widgets.twimg.com/j/2/widget.js\"></script>

<script>

new TWTR.Widget({

  version: 2,

  type: 'profile',

  rpp: 5,

  interval: 6000,

  width: 218,

  height: 160,

  theme: {

    shell: {

      background: '#BDF',

      color: '#000000'

    },

    tweets: {

      background: '#ffffff',

      color: '#000000',

      links: '#0066FF',

    }

  },

  features: {

    scrollbar: true,

    loop: false,

    live: false,

    hashtags: true,

    timestamp: true,

    avatars: false,

    behavior: 'all'

  }

}).render().setUser('$twitter').start();

</script>";

    }

    ///////  Mechanism to Display Website URL or not  //////////////////////////

    if ($website == "") {

    $website = "";

    } else {

    $website = '<br /><br /><img src="images/websiteIcon.jpg" width="18" height="12" alt="Website URL for ' . $username . '" /> <strong>Website:</strong><br /><a href="http://' . $website . '" target="_blank">' . $website . '</a>'; 

    }

    ///////  Mechanism to Display About me text or not  //////////////////////////

    if ($bio_body == "") {

    $bio_body = "";

    } else {

    $bio_body = '<div class="infoBody">' . $bio_body . '</div>'; 

    }

    ///////  Mechanism to Display Location Info or not  //////////////////////////

    if ($country == "" && $state == "" && $city == "") {

    $locationInfo = "";

    } else {

    $locationInfo = "$city &middot; $state<br />$country ".'<a href="#" onclick="return false" onmousedown="javascript:toggleViewMap(\'google_map\');">view map</a>'; 

    }

} // close while loop

// ------- END WHILE LOOP FOR GETTING THE MEMBER DATA ---------



// ------- POST NEW BLAB TO DATABASE ---------

$blab_outout_msg = "";

if (isset($_POST['blab_field']) && $_POST['blab_field'] != "" && $_POST['blab_field'] != " "){

    

     $blabWipit = $_POST['blabWipit'];

     $sessWipit = base64_decode($_SESSION['wipit']);

     if (!isset($_SESSION['wipit'])) {

         

     } else if ($blabWipit == $sessWipit) {

          // Delete any blabs over 50 for this member

          $sqlDeleteBlabs = mysql_query("SELECT * FROM blabbing WHERE mem_id='$id' ORDER BY blab_date DESC LIMIT 50");

          $bi = 1;

          while ($row = mysql_fetch_array($sqlDeleteBlabs)) {

              $blad_id = $row["id"];

              if ($bi > 20) {

                   $deleteBlabs = mysql_query("DELETE FROM blabbing WHERE id='$blad_id'");

              }

              $bi++;

          }

          // End Delete any blabs over 20 for this member

          $blab_field = $_POST['blab_field'];

          $blab_field = stripslashes($blab_field);

          $blab_field = strip_tags($blab_field);

          $blab_field = mysql_real_escape_string($blab_field);

          $blab_field = str_replace("'", "'", $blab_field);

          $sql = mysql_query("INSERT INTO blabbing (mem_id, the_blab, blab_date) VALUES('$id','$blab_field', now())") or die (mysql_error());

          $blab_outout_msg = "";

          }

}

// ------- END POST NEW BLAB TO DATABASE ---------



// ------- MEMBER BLABS OUTPUT CONSTRUCTION ---------

///////  Mechanism to Display Pic

    if (file_exists($check_pic)) {

    $blab_pic = '<div style="overflow:hidden; height:40px;"><a href="profile.php?id=' . $id . '"><img src="' . $check_pic . '" width="40px" border="0" /></a></div>'; 

    } else {

    $blab_pic = '<div style="overflow:hidden; height:40px;"><a href="profile.php?id=' . $id . '"><img src="' . $default_pic . '" width="40px" border="0" /></a></div>'; 

    }

///////  END Mechanism to Display Pic    

$sql_blabs = mysql_query("SELECT id, mem_id, the_blab, blab_date FROM blabbing WHERE mem_id='$id' ORDER BY blab_date DESC LIMIT 20");



while($row = mysql_fetch_array($sql_blabs)){

    

    $blabid = $row["id"];

    $uid = $row["mem_id"];

    $the_blab = $row["the_blab"];

    $the_blab = ($activeLinkObject -> makeActiveLink($the_blab));

    $blab_date = $row["blab_date"];

    $convertedTime = ($myObject -> convert_datetime($blab_date));

    $whenBlab = ($myObject -> makeAgo($convertedTime));

    

                $blabberDisplayList .= '

                    <table style="background-color:#FFF; border:#999 1px solid; border-top:none;" cellpadding="5" width="100%">

                    <tr>

                    <td width="10%" valign="top">' . $blab_pic . '</td>

                    <td width="90%" valign="top" style="line-height:1.5em;"><span class="greenColor textsize10">' . $whenBlab . ' <a href="profile.php?id=' . $uid . '">' . $username . '</a> said:</span><br />

            ' . $the_blab . '</td>

            </tr></table>';

    

}

// ------- END MEMBER BLABS OUTPUT CONSTRUCTION ---------



// ------- ESTABLISH THE PROFILE INTERACTION TOKEN ---------

$thisRandNum = rand(9999999999999,999999999999999999);

$_SESSION['wipit'] = base64_encode($thisRandNum); // Will always overwrite itself each time this script runs

// ------- END ESTABLISH THE PROFILE INTERACTION TOKEN ---------



// ------- EVALUATE WHAT CONTENT TO PLACE IN THE MEMBER INTERACTION BOX -------------------

// initialize some output variables

$friendLink = "";

$the_blab_form = "";

if (isset($_SESSION['idx']) && $logOptions_id != $id) { // If SESSION idx is set, AND it does not equal the profile owner's ID



    // SQL Query the friend array for the logged in viewer of this profile if not the owner

    $sqlArray = mysql_query("SELECT friend_array FROM myMembers WHERE id='" . $logOptions_id ."' LIMIT 1"); 

    while($row=mysql_fetch_array($sqlArray)) { $iFriend_array = $row["friend_array"]; }

     $iFriend_array = explode(",", $iFriend_array);

    if (in_array($id, $iFriend_array)) { 

        $friendLink = '<a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'remove_friend\');">Remove Friend</a>';

    } else {

        $friendLink = '<a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'add_friend\');">Add as Friend</a>';    

    }

    /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////

    $interactionBox = '<br /><br /><div class="interactionLinksDiv">

           ' . $friendLink . ' 

           <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'private_message\');">Private Message</a>

          </div><br />';

          $the_blab_form = '<div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <strong>Write on ' . $username . '\'s Board (coming soon)</strong>

          </div>';

} else if (isset($_SESSION['idx']) && $logOptions_id == $id) { // If SESSION idx is set, AND it does equal the profile owner's ID

    $interactionBox = '<br /><br /><div class="interactionLinksDiv">

           <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers(\'friend_requests\');">Friend Requests</a>

          </div><br />';

          $the_blab_form = ' ' . $blab_outout_msg . '

          <div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <form action="profile.php" method="post" enctype="multipart/form-data" name="blab_from">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <input name="blabWipit" type="hidden" value="' . $thisRandNum . '" />

          <strong>Blab away ' . $username . '</strong> (220 char max) <input name="submit" type="submit" value="Blab" />

          <div align="right">

          </form></div>';

} else { // If no SESSION id is set, which means we have a person who is not logged in

    $interactionBox = '<div style="border:#CCC 1px solid; padding:5px; background-color:#E4E4E4; color:#999; font-size:11px;">

           <a href="register.php">Sign Up</a> or <a href="login.php">Log In</a> to interact with ' . $username . '

          </div>';

          $the_blab_form = '<div style="background-color:#BDF; border:#999 1px solid; padding:8px;">

          <textarea name="blab_field" rows="3" style="width:99%;"></textarea>

          <a href="register.php">Sign Up</a> or <a href="login.php">Log In</a> to write on ' . $username . '\'s Board

          </div>';

}

// ------- END EVALUATE WHAT CONTENT TO PLACE IN THE MEMBER INTERACTION BOX -------------------



// ------- POPULATE FRIEND DISPLAY LISTS IF THEY HAVE AT LEAST ONE FRIEND -------------------

$friendList = "";

$friendPopBoxList = "";

if ($friend_array  != "") { 

    // ASSEMBLE FRIEND LIST AND LINKS TO VIEW UP TO 6 ON PROFILE

    $friendArray = explode(",", $friend_array);

    $friendCount = count($friendArray);

    $friendArray6 = array_slice($friendArray, 0, 6);

    

    $friendList .= '<div class="infoHeader">' . $username . '\'s Friends (<a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends(\'view_all_friends\');">' . $friendCount . '</a>)</div>';

    $i = 0; // create a varible that will tell us how many items we looped over 

     $friendList .= '<div class="infoBody" style="border-bottom:#666 1px solid;"><table id="friendTable" align="center" cellspacing="4"></tr>'; 

    foreach ($friendArray6 as $key => $value) { 

        $i++; // increment $i by one each loop pass 

        $check_pic = 'members/' . $value . '/image01.jpg';

            if (file_exists($check_pic)) {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="' . $check_pic . '" width="54px" border="1"/></a>';

            } else {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="members/0/image01.jpg" width="54px" border="1"/></a> &nbsp;';

            }

            $sqlName = mysql_query("SELECT username, firstname FROM myMembers WHERE id='$value' LIMIT 1") or die ("Sorry we had a mysql error!");

            while ($row = mysql_fetch_array($sqlName)) { $friendUserName = substr($row["username"],0,12); $friendFirstName = substr($row["firstname"],0,12);}

            if (!$friendUserName) {$friendUserName = $friendFirstName;} // If username is blank use the firstname... programming changes in v1.32 call for this

            if ($i % 6 == 4){

                $friendList .= '<tr><td><div style="width:56px; height:68px; overflow:hidden;" title="' . $friendUserName . '">

                <a href="profile.php?id=' . $value . '">' . $friendUserName . '</a><br />' . $frnd_pic . '

                </div></td>';  

            } else {

                $friendList .= '<td><div style="width:56px; height:68px; overflow:hidden;" title="' . $friendUserName . '">

                <a href="profile.php?id=' . $value . '">' . $friendUserName . '</a><br />' . $frnd_pic . '

                </div></td>'; 

            }

    } 

     $friendList .= '</tr></table>

     <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends(\'view_all_friends\');">view all</a></div>

     </div>'; 

    // END ASSEMBLE FRIEND LIST... TO VIEW UP TO 6 ON PROFILE

    // ASSEMBLE FRIEND LIST AND LINKS TO VIEW ALL(50 for now until we paginate the array)

    $i = 0;

    $friendArray50 = array_slice($friendArray, 0, 50);

    $friendPopBoxList = '<table id="friendPopBoxTable" width="100%" align="center" cellpadding="6" cellspacing="0">';

    foreach ($friendArray50 as $key => $value) { 

        $i++; // increment $i by one each loop pass 

        $check_pic = 'members/' . $value . '/image01.jpg';

            if (file_exists($check_pic)) {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="' . $check_pic . '" width="54px" border="1"/></a>';

            } else {

                $frnd_pic = '<a href="profile.php?id=' . $value . '"><img src="members/0/image01.jpg" width="54px" border="1"/></a> &nbsp;';

            }

            $sqlName = mysql_query("SELECT username, firstname, country, state, city FROM myMembers WHERE id='$value' LIMIT 1") or die ("Sorry we had a mysql error!");

            while ($row = mysql_fetch_array($sqlName)) { $funame = $row["username"]; $ffname = $row["firstname"]; $fcountry = $row["country"]; $fstate = $row["state"]; $fcity = $row["city"]; }

            if (!$funame) {$funame = $ffname;} // If username is blank use the firstname... programming changes in v1.32 call for this

                if ($i % 2) {

                    $friendPopBoxList .= '<tr bgcolor="#F4F4F4"><td width="14%" valign="top">

                    <div style="width:56px; height:56px; overflow:hidden;" title="' . $funame . '">' . $frnd_pic . '</div></td>

                     <td width="86%" valign="top"><a href="profile.php?id=' . $value . '">' . $funame . '</a><br /><font size="-2"><em>' . $fcity . '<br />' . $fstate . '<br />' . $fcountry . '</em></font></td>

                    </tr>';  

                } else {

                    $friendPopBoxList .= '<tr bgcolor="#E0E0E0"><td width="14%" valign="top">

                    <div style="width:56px; height:56px; overflow:hidden;" title="' . $funame . '">' . $frnd_pic . '</div></td>

                     <td width="86%" valign="top"><a href="profile.php?id=' . $value . '">' . $funame . '</a><br /><font size="-2"><em>' . $fcity . '<br />' . $fstate . '<br />' . $fcountry . '</em></font></td>

                    </tr>';  

                }

    } 

    $friendPopBoxList .= '</table>';

    // END ASSEMBLE FRIEND LIST AND LINKS TO VIEW ALL(50 for now until we paginate the array)

}

// ------- END POPULATE FRIEND DISPLAY LISTS IF THEY HAVE AT LEAST ONE FRIEND -------------------

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">

<head>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />

<meta name="Description" content="Profile for <?php echo "$username"; ?>" />

<meta name="Keywords" content="<?php echo "$username, $city, $state, $country"; ?>" />

<meta name="rating" content="General" />

<meta name="ROBOTS" content="All" />

<title>Site Profile for <?php echo "$username"; ?></title>

<link href="style/main.css" rel="stylesheet" type="text/css" />

<link rel="icon" href="favicon.png" type="image/x-icon" />

<link rel="shortcut icon" href="favicon.png" type="image/x-icon" />

<script src="js/jquery-1.4.2.js" type="text/javascript"></script>

<style type="text/css">

<!--

.infoHeader {

    background-color: #BDF;

    font-size:11px;

    font-weight:bold;

    padding:8px;

    border: #999 1px solid;

    border-bottom:none;

    width:200px;

}

.infoBody{

    background-color: #FFF;

    font-size:11px;

    padding:8px;

    border: #999 1px solid;

    border-bottom:none;

    width:200px;

}

/* ------- Interaction Links Class -------- */

.interactionLinksDiv a {

   border:#B9B9B9 1px solid; padding:5px; color:#060; font-size:11px; background-image:url(style/headerBtnsBG.jpg); text-decoration:none;

}

.interactionLinksDiv a:hover {

    border:#090 1px solid; padding:5px; color:#060; font-size:11px; background-image:url(style/headerBtnsBGover.jpg);

}

/* ------- Interaction Containers Class -------- */

.interactContainers {

    padding:8px;

    background-color:#BDF;

    border:#999 1px solid;

    display:none;

}

#add_friend_loader {

    display:none;

}

#remove_friend_loader {

    display:none;

}

#interactionResults {

    display:none;

    font-size:16px;

    padding:8px;

}

#friendTable td{

    font-size:9px;

}

#friendTable td a{

    color:#03C;

    text-decoration:none;

}

#view_all_friends {

    background-image:url(style/opaqueDark.png);

    width:270px;

    padding:20px;

    position:fixed;

    top:150px;

    display:none;

    z-index:100;

    margin-left:50px;

}

#google_map {

    background-image:url(style/opaqueDark.png);

    padding:20px;

    position:fixed;

    top:150px;

    display:none;

    z-index:100;

    margin-left:50px;

}

-->

</style>

<script language="javascript" type="text/javascript">

// jQuery functionality for toggling member interaction containers

function toggleInteractContainers(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).slideDown(200);

        } else {

            $('#'+x).hide();

        }

        $('.interactContainers').hide();

}

function toggleViewAllFriends(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).fadeIn(200);

        } else {

            $('#'+x).fadeOut(200);

        }

}

function toggleViewMap(x) {

        if ($('#'+x).is(":hidden")) {

            $('#'+x).fadeIn(200);

        } else {

            $('#'+x).fadeOut(200);

        }

}

// Friend adding and accepting stuff

var thisRandNum = "<?php echo $thisRandNum; ?>";

var friendRequestURL = "scripts_for_profile/request_as_friend.php";

function addAsFriend(a,b) {

    $("#add_friend_loader").show();

    $.post(friendRequestURL,{ request: "requestFriendship", mem1: a, mem2: b, thisWipit: thisRandNum } ,function(data) {

        $("#add_friend").html(data).show().fadeOut(12000);

    });   

}

function acceptFriendRequest (x) {

    $.post(friendRequestURL,{ request: "acceptFriend", reqID: x, thisWipit: thisRandNum } ,function(data) {

            $("#req"+x).html(data).show();

    });

}

function denyFriendRequest (x) {

    $.post(friendRequestURL,{ request: "denyFriend", reqID: x, thisWipit: thisRandNum } ,function(data) {

           $("#req"+x).html(data).show();

    });

}

// End Friend adding and accepting stuff

// Friend removal stuff

function removeAsFriend(a,b) {

    $("#remove_friend_loader").show();

    $.post(friendRequestURL,{ request: "removeFriendship", mem1: a, mem2: b, thisWipit: thisRandNum } ,function(data) {

        $("#remove_friend").html(data).show().fadeOut(12000);

    });   

}

// End Friend removal stuff

// Start Private Messaging stuff

$('#pmForm').submit(function(){$('input[type=submit]', this).attr('disabled', 'disabled');});

function sendPM ( ) {

      var pmSubject = $("#pmSubject");

      var pmTextArea = $("#pmTextArea");

      var sendername = $("#pm_sender_name");

      var senderid = $("#pm_sender_id");

      var recName = $("#pm_rec_name");

      var recID = $("#pm_rec_id");

      var pm_wipit = $("#pmWipit");

      var url = "scripts_for_profile/private_msg_parse.php";

      if (pmSubject.val() == "") {

           $("#interactionResults").html('<img src="images/round_error.png" alt="Error" width="31" height="30" /> &nbsp; Please type a subject.').show().fadeOut(6000);

      } else if (pmTextArea.val() == "") {

           $("#interactionResults").html('<img src="images/round_error.png" alt="Error" width="31" height="30" /> &nbsp; Please type in your message.').show().fadeOut(6000);

      } else {

           $("#pmFormProcessGif").show();

           $.post(url,{ subject: pmSubject.val(), message: pmTextArea.val(), senderName: sendername.val(), senderID: senderid.val(), rcpntName: recName.val(), rcpntID: recID.val(), thisWipit: pm_wipit.val() } ,           function(data) {

               $('#private_message').slideUp("fast");

               $("#interactionResults").html(data).show().fadeOut(10000);

               document.pmForm.pmTextArea.value='';

               document.pmForm.pmSubject.value='';

               $("#pmFormProcessGif").hide();

           });

      }

}

// End Private Messaging stuff

</script>

</head>

<body>

<?php include_once "header_template.php"; ?>

<table class="mainBodyTable" border="0" align="center" cellpadding="0" cellspacing="0">

  <tr>

    <td width="738" valign="top"><br />

      <table width="98%" border="0" align="center" cellpadding="6">

      <tr>

        <td width="33%" valign="top">

          <?php echo $user_pic; ?>

          <?php echo $bio_body; ?>

          <div class="infoHeader"><?php echo $username; ?>'s Information</div>

          <div class="infoBody">

          <?php echo $locationInfo; ?>

          <?php echo $website; ?>

          <?php echo $youtube; ?>

          <?php echo $facebook; ?>

          </div>

          <?php echo $friendList; ?>

          <div id="view_all_friends">

              <div align="right" style="padding:6px; background-color:#FFF; border-bottom:#666 1px solid;">

                       <div style="display:inline; font-size:14px; font-weight:bold; margin-right:150px;">All Friends</div>

                       <a href="#" onclick="return false" onmousedown="javascript:toggleViewAllFriends('view_all_friends');">close </a>

              </div>

              <div style="background-color:#FFF; height:240px; overflow:auto;">

                   <?php echo $friendPopBoxList; ?>

              </div>

              <div style="padding:6px; background-color:#000; border-top:#666 1px solid; font-size:10px; color: #0F0;">

                       Temporary programming shows 50 maximum. Navigating through the full list is coming soon.

              </div>

         </div>

         <?php echo $twitterWidget; ?>

         <div class="infoBody" style="border-bottom:#999 1px solid;"><?php include_once("ad_200_square.php"); ?></div> 

          </td>

        <td width="67%" valign="top">

          <span style="font-size:16px; font-weight:800;"><?php echo $mainNameLine; ?></span>

         

          <?php echo $interactionBox; ?>

 

          <div class="interactContainers" id="add_friend">

                <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('add_friend');">cancel</a> </div>

                Add <?php echo "$username"; ?> as a friend? &nbsp;

                <a href="#" onclick="return false" onmousedown="javascript:addAsFriend(<?php echo $logOptions_id; ?>, <?php echo $id; ?>);">Yes</a>

                <span id="add_friend_loader"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span>

          </div>

         

          <div class="interactContainers" id="remove_friend">

                <div align="right"><a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('remove_friend');">cancel</a> </div>

                Remove <?php echo "$username"; ?> from your friend list? &nbsp;

                <a href="#" onclick="return false" onmousedown="javascript:removeAsFriend(<?php echo $logOptions_id; ?>, <?php echo $id; ?>);">Yes</a>

                <span id="remove_friend_loader"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span>

          </div>

         

          <!-- START DIV that serves as an interaction status and results container that only appears when we instruct it to -->

          <div id="interactionResults" style="font-size:15px; padding:10px;"></div>

          <!-- END DIV that serves as an interaction status and results container that only appears when we instruct it to -->

         

          <!-- START DIV that contains the Private Message form -->

          <div class="interactContainers" id="private_message">

<form action="javascript:sendPM();" name="pmForm" id="pmForm" method="post">

<font size="+1">Sending Private Message to <strong><em><?php echo "$username"; ?></em></strong></font><br /><br />

Subject:

<input name="pmSubject" id="pmSubject" type="text" maxlength="64" style="width:98%;" />

Message:

<textarea name="pmTextArea" id="pmTextArea" rows="8" style="width:98%;"></textarea>

  <input name="pm_sender_id" id="pm_sender_id" type="hidden" value="<?php echo $_SESSION['id']; ?>" />

  <input name="pm_sender_name" id="pm_sender_name" type="hidden" value="<?php echo $_SESSION['username']; ?>" />

  <input name="pm_rec_id" id="pm_rec_id" type="hidden" value="<?php echo $id; ?>" />

  <input name="pm_rec_name" id="pm_rec_name" type="hidden" value="<?php echo $username; ?>" />

  <input name="pmWipit" id="pmWipit" type="hidden" value="<?php echo $thisRandNum; ?>" />

  <span id="PMStatus" style="color:#F00;"></span>

  <br /><input name="pmSubmit" type="submit" value="Submit" /> or <a href="#" onclick="return false" onmousedown="javascript:toggleInteractContainers('private_message');">Close</a>

<span id="pmFormProcessGif" style="display:none;"><img src="images/loading.gif" width="28" height="10" alt="Loading" /></span></form>

          </div>

          <!-- END DIV that contains the Private Message form -->

        &n

$post='{"cart_items":[{"configuration":{"price":100,"recharge_number":"9999999999"},"product_id":"999","qty":1}]}';

i try this n reslut was :There are no valid items in cart:   help me plz
Edited by ShivaGupta, 30 November 2014 - 01:11 AM.

Hi,

 

I have a series of post to post connections. In one function, the output is a list of the linked post to posts. Here is an example:

function countryJob(){

global $post;

    $echo = f_print(array(
        'data' => 'p2p',
        'type' => 'ul',
        'args' => array(
            'connection_type' => 'job_to_location',
            'post_type' => 'job',
            'connection_id' => $post->ID,
            'alternative' => '',
        ),
));

    echo '<div class="country-job-text">'.$echo.'</div>';

 

job, location and city are all post types that can be connected.

 

I want to create the same as above to create a list of the cites connected to a location (locations are the name for posts which are countries)

 

How do I discover the connection type and post type needed to create this output?

Alright, I have a Datetime field in my database which I'm trying to store information in. Here is my code to get my Datetime, however it's returning to me the wrong date. It's returning:
1969-12-31 19:00:00

$mysqldate = date( 'Y-m-d H:i:s', $phpdate );
$phpdate = strtotime( $mysqldate );
echo $mysqldate;


Is there something wrong with it?

I have tried a large number of "solutions" to  this but everytime I use them I see 0000-00-00 in my date field instead of  the date even though I echoed and can see that the date looks correct.

Here's where I'm at:
I have a drop down for the month (1-12) and date fields (1-31) as well as a text input field for the year.  Using the POST array, I  have combined them into the xxxx-xx-xx format that I am using in my field as a date field in mysql. 

<code>
$date_value =$_POST['year'].'-'.$_POST['month'].'-'.$_POST['day'];
echo $date_value;
</code>

This outputs 2012-5-7 in my test echo but 0000-00-00 in the database.

I have tried unsuccessfully to use in a numberof suggested versions of:
strtotime()
mktime

Any help would be extremely appreciated.
I am aware that I need to validate this data and insure  that it is a valid date. That I'm okay with. I would like some help on getting it into the database.

(continuing from topic title)
So if I set a date of July 7 2011 into my script, hard coded in, I would like the current date to be checked against the hard coded date, and return true if the current date is within a week leading up to the hard coded date.

How could I go about doing this easily?

I've been researching dates in php but I can't seem to work out the best way to achieve what I'm after.

Cheers
Denno

Hi,

I have a job listing website which displays the closing date of applications using:

$expired_date

(This displays a date such as 31st December 2019)

I am trying to show a countdown/number of days left until the closing date.

I have put this together, but I can't get it to show the number of days.

                    <?php 
                    $expired_date = get_post_meta( $post->ID, '_job_expires', true );
                    $hide_expiration = get_post_meta( $post->ID, '_hide_expiration', true );
                    if(empty($hide_expiration )) {
                        if(!empty($expired_date)) { ?>
                                <span><?php echo date_i18n( get_option( 'date_format' ), strtotime( get_post_meta( $post->ID, '_job_expires', true ) ) ) ?></span>
                    
                    <?php
                                        $datetime1 = new DateTime($expired_date);
                                        $datetime2 = date('d');
                                        $interval = $datetime1->diff($datetime2);
                                        echo $interval->d;

                     ?>
                        <?php }
                    } 
                    ?>

Can anyone help me with what I have wrong?

Many thanks

Hi Guys..

How can I change a date on the fly ?
Everything is UTC on my server.

How can I change a date to something else on the fly?

Ie:

$timezone = "cet";
$datetime = "2011-09-04 19:53:00";

echo $datetime($timezone);

So I can give it a datetime and have it echo the datetime as if it were in the other timezone?

Thanks
Graham

I'm getting this Time Zone error.
Perhaps it's a compatibility issue with PHP 5.3. Looked all over for an answer without finding one.
Here is the error message


Warning: date() [function.date]: It is not safe to rely on the system's timezone settings.
You are *required* to use the date.timezone setting or the date_default_timezone_set() function.
In case you used any of those methods and you are still getting this warning,
you most likely misspelled the timezone identifier. We selected 'America/New_York' for 'EST/-5.0/no DST'
instead in /blocked.php on line 41
12/02/12

Here is the code. Line 41 is near the bottom, the one with the d,m,y.  Perhaps the echo date (d/m/y") needs to be changed. Appreciate any help!

Code: [Select]
   <table border="3" width="16%" align="center" cellspacing="0" bgcolor="#FF6600" bordercolor="red" bordercolordark="red" bordercolorlight="red">
                            <tr>
                                    <td width="176">

                                            <p align="center"><?php // shows IP Number on Page
            echo $ip; ?> </p>

                                    </td>
                            </tr>
                    </table>
                    <p align="center"><?php // Show the user agent
        echo 'Your user agent is: <b>'.$_SERVER['HTTP_USER_AGENT'].'</b><br />';?></p>
                    [b]<h1 align="center"><?php echo date("d/m/y");?></h1>[/b]
            </td>
    </tr>
</table
[,code]

Hi,

I am trying to convert a String date into numeric date using PHP function's, but haven't found such function.
Had a look at date(), strtotime(), getdate();

e.g. Apr 1 2011  ->    04-01-2011

Could someone please shed some light on this?

Regards,
Abhishek

i have a table that shows payments made but  want to the payments only showing from a set date(06/12/14) and before this date i dont want to show   this is my sql that doesnt seem to work and is showing dates before the specified date. .

"SELECT * FROM payments2014, signup2014, editprop2014 WHERE signup2014.userid = payments2014.payment_userid AND editprop2014.prop_id = signup2014.prop_id AND signup2014.userid !='page1' AND signup2014.userid !='page6' AND signup2014.userid !='page4' AND payments2014.payment_transaction_status !='none' AND payments2014.payment_transaction_status !='CANCELLEDa' AND payments2014.payment_type !='deposit' AND payments2014.payment_paid_timestamp NOT LIKE '%2012%' AND payments2014.payment_paid_timestamp NOT LIKE '%2011%' AND payments2014.payment_paid_timestamp >= '06/12/14' ORDER BY payments2014.payment_id DESC"

i have some other parts in the statment but this one that should be filtering is 

host_payments2014.payment_paid_timestamp >= '06/12/14' 

thanks in advance

Hi guys, I'm putting together a small event system where I want the user to add his own date and time into a textfield (I'll probably make this a series of drop-downs/a date picker later).
This is then stored as a timestamp - "0000-00-00 00:00:00" which displays fine until I try to echo it out as a UK date in this format - jS F Y, which just gives today's date but not the inputted date.



Here's the code I have right now:

Code: [Select]
$result = mysql_query("SELECT * FROM stuff.events ORDER BY eventdate ASC");

echo "<br />";
echo mysql_result($result, $i, 'eventvenue');
echo ", ";

$dt = new DateTime($eventdate);

echo $dt->format("jS F Y");


In my mysql table eventdate is set up as follows:
 
field - eventdate
type - timestamp
length/values - blank
default - current_timestamp
collation - blank
attributes - on update CURRENT_TIMESTAMP
null - blank
auto_increment - blank


Any help as to why this could be happening would be much appreciated, thanks.