PHP - Update Row When 30 Seconds Passed

Hi all,

How can I check in PHP if this date has already passed in the following format:

2012-12-12

Good day freaks.  I am pulling my hair out trying to figure this out.  I am trying to pass patterns for preg_replace through $_GET and then apply them.  The object is to highlight certain words in a chunk of text. 

Say I want to highlight bounded cases of 'foo' in the text.  So here's what I'm doing: Code: [Select]
$string = urldecode($_GET['highlight1']);       //  $string contains \\bfoo\\b
$search = preg_replace('/\\\\b/','b',$string);   // $search contains \bfoo\b  as I want it to
$replace = preg_replace('/\\\\b/','',$string);    // $replace contains \foo\  >:-(
$pattern = '/'.$search.'/i';
$text = preg_replace($pattern,'<span style="background-color:yellow;">'.$replace.'</span>',$text);

The problem is that no matter what I try for the pattern for $replace, it winds up with backslashes around foo.  How do I get rid of these?

(I should say that I discovered the pattern/replace for the $search string by experimentation and I don't understand why the pattern doesn't pick off all the backslashes in that case--but at least it does what I want).

TIA

Steve

 

Hi All,

I've been trying to access xml data from an API feed, but it needs a Variable to be passed to an include file without a form. the include is at the header of the page.

in the code below, i'm trying to retrieve the variable $project_add from the $xml_2 feed. $proj_add_ID comes from another feed and is being passed ok. 

foreach ($projects_1 as $proj_1) {

                        $job_no =$proj_1['job_no'];
                        $job_name =$proj_1['job_name'];
                        $job_status =$proj_1['job_status'];
                        $job_staff =$proj_1['job_staff'];
                        $job_due =$proj_1['job_due'];
                        $clr_1 = $colors_1[$job_status];
                        
                        if ($err_2) {
                        echo "cURL Error #:" . $err_2;
                         } else {
                        $_POST['job_id']= $job_no;
                        $xml_2=simplexml_load_string($response_2) or die("Error: Cannot create object");
                        $proj_add = $xml_2->xpath("CustomFields/CustomField[ID ='$proj_add_ID']");                         
                            foreach($proj_add as $item_2) {
                            $project_add = "$item_2->Text";
                        }            
                        echo "<div class='row no-gutters'>";
                        echo "<div class='col-sm bg-white border rounded'><a href='managejob.php?job_id=$job_no' class='text-left ml-1'><strong>$job_no</strong></a></div>";
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'>$job_name</p></div>";                         
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'></p>$project_add</div>";                        
                        echo "<div class='col-sm-2 bg-white border rounded'>" . state_dropdown_1($job_no, $job_status, $clr_1) . "</div>";                        
                        echo "<div class='col-sm-2 bg-white border rounded'><p class='text-left ml-1'>$job_staff</p></div>"; 
                        echo "<div class='col-sm-2 bg-white border rounded'><form action='CALL_API_PUTTaskDate.php' method='POST'>"
                                . "<input type='hidden' name='task_ID' value ='". $jdata['task_ID'] ."'>"
                                . "<input type='hidden' name='est_min' value ='". $jdata['est_min'] ."'>"
                                . "<input class ='form-control bg-white text-dark font-weight-bold' type='date' name='start_date' value='" . date('Y-m-d', strtotime( $jdata['display_date_1'] )) . "' onchange='this.form.submit()'>"
                                . "</form></div>";
                        echo "<div class='col-sm bg-white border rounded'><p class='text-left ml-1 mt-1'><strong>" . date('d/m/Y', strtotime( $jdata['display_date'])) . "</strong></p></div></div>";
                        
                       }

The include file is like this

/ collect Custom Felds
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // collect value of status input field
    $job_no = $_REQUEST['job_id'];
      } 

if (isset($_POST['job_id'])) {
$job_no = $_POST['job_id'];
}

if (isset($_GET['job_id'])) {
$job_no = $_GET['job_id'];
}

$curl_2 = curl_init();

curl_setopt_array($curl_2, array(
  CURLOPT_URL => "https://api.xxx.com/job.api/get/$job_no/customfield?apiKey=xxx&accountKey=xxx",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => array(
    "Accept: */*",
    "Accept-Encoding: gzip, deflate",
    "Cache-Control: no-cache",
    "Connection: keep-alive",
    "Host: api.xxx.com",
    "Postman-Token: xxx",
    "User-Agent: PostmanRuntime/7.17.1",
    "cache-control: no-cache"
  ),
));

$response_2 = curl_exec($curl_2);
$err_2 = curl_error($curl_2);

curl_close($curl_2);

The problem is the variable $job_no isn't getting passed to CURLOPT_URL so it's not retrieving the data required. i need to be able to retrieve this data without submitting a form as it's in a foreach loop and the Id is specific to each iteration. is there a way to do this? I have been able to achieve this by putting the include within the div tags that it will be displayed but it just slows down everything too much and hangs. 

Any help will be much appreciated. 

Kind regards,

Michael Bennington.

Hi

I am trying to get all variables passed in a url string and wondered how would i do it?
I dont know what they are yet and i need to set key as value.
Any help?

I have a forum script I made that has thread bumping for the thread creator only. I am trying to limit the amout of time the creator can bump to be every 10 minutes.

Here's my code.

list($title, $creator, $locked, $hidden, $moved, $lastbump) = mysql_fetch_row(mysql_query('SELECT title, creator, locked, hidden, moved, lastbump FROM forum_threads WHERE id="'.$_GET['threadid'].'"'));

if(($locked == 1 || $hidden == 1 || $moved == 1) && !$_SESSION['rights'] == 2){

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

} else {

if($creator == $_SESSION['username']){

mysql_query("UPDATE forum_threads SET lastbump = NOW() WHERE id='".$_GET['threadid']."'");

} else {

header("location: thread.ws?id=".$_GET['threadid']."&page=".$_GET['page']."");

}

}

Hi,
I am a beginner with php and I am having a hard time understanding a section in my code.
The part I dont get is why we have to minus 1 from the number being passed into the array.

For example, $FaceNamePlural[$die1-1]

I tried looking at it over and over but I'm still very confused.
Can anyone help me on this...Thanks.

Code: [Select]
<!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=UTF-8" />
<title>Untitled Document</title>
</head>

<body>
<?php

$FaceNameSingular = array("one", "two", "three", "four", "five", "six");
$FaceNamePlural = array("ones", "twos", "threes", "fours", "fives", "sixs");
 
function CheckForDoubles($die1, $die2)
{
    global $FaceNameSingular;
    global $FaceNamePlural;
    
    if($die1 == $die2) //  doubles
        echo "The roll was double ", 
            $FaceNamePlural[$die1-1], "<br />";
    if($die1 != $die2) //not doubles
        echo "The roll was a ", $FaceNameSingular[$die1-1], 
            " and a ", $FaceNameSingular[$die2-1], ".<br />";
            
}

function DisplayScoreText($Score)
{
    if($Score == 2)
        echo "you roll snake eyes! <br />";
        
    if($Score == 3)
        echo "you roll loose duece! <br />";
            
    if($Score == 5)
        echo "you roll fever five! <br />";
    
    if($Score == 7)
        echo "you roll natural! <br />";
        
    if($Score == 9)
        echo "you roll nina! <br />";
    
    if($Score == 11)
        echo "you roll yo! <br />";
        
    if($Score == 12)
        echo "you roll boxcars! <br />";                
}

$dice = array();
$dice[0] = rand(1,6);
$dice[1] = rand(1,6);
$Score = $dice[0] + $dice[1] ;
echo "<p>";
echo "The total score for the roll was $Score . <br />";

CheckForDoubles($dice[0],$dice[1]);
DisplayScoreText($Score);
echo "</p>";
?>
</body>
</html>

Folks,

I am trying to grab the value selected in a Dropdown, with $_GET['q']. Then i am echoing the grabbed value.

Funny thing is, when i select value from HTML dropdown (onchange="location=this.value"), and when a new value is selcted, it appaears in url like this:

Quote

http://www.abc.com/?search=selected-value.html


But when i try to grab and echo the value of 'q' it gets passed only when i refresh the page and not when i change my selecting in dropdown.

Am not sure whats happening, can someone help me on this?

Cheers
NT

<?php
global $places;
$comm = $GLOBALS["location"];
$comm=trim($comm);
while(list($one,$two) = each($places))
{
	echo  "<option value=\"$two\"";
	if ( $two == $comm)echo "selected ";
	echo ">$two</option>\n" ;
}
?>

Variable passed to each() is not an array or object

Hi, my code works fine but it is giving the error message Please can anyone help? Thanks

Hey all,

I'm very new to php and am having an issue writing to my database with a passed value and info taking from a form and am lost as to what to do.
The $comm_id is the value I am getting from another php page that I am passing in the link from the other page. I need to insert that value, the session variable, and the $cmt value, which is taken from the user input from the form. As it stands now, when I run this, the $comm_id and $u_id insert and the $cmt is blank, BUT $cmt is echoing on the screen with the proper value.

Any tips or direction would be great as i've been trying to sort this out for days now and i'm stumped.


<?php 

$host='localhost';
$user='username';
$password='password';
$dbname='db_a';
session_start();
$id_link=mysql_connect($host,$user,$password);
mysql_select_db($dbname, $id_link);

$comm_id = $_GET['commId'];
$u_id = $_SESSION['userId']; 
echo $comm_id;
echo $u_id;
    

$cmt = $_POST["comm"];
mysql_query("insert into Comments values($u_id, $comm_id,'$cmt');");
echo $cmt;

?>
   
<FORM ACTION="test.php" METHOD="POST">
<input type="text" name="comm">
<input type="SUBMIT">
</FORM> 

I think I've gotten as far as I can with my troubleshooting so hopefully someone can help me here.
I have a constructor for a controller class that receives the $_SESSION array from index.php by reference. An instance variable is then created when references this references so that any changes made to this instance variable update the real $_SESSION variable. This was working until it mysteriously stopped after not touching it for a few hours.
The local $this->session variable is working because it completes some tasks using it. I've also hardcoded values into the session from the index.php file and when they are hard coded the session works as you would expect so it seems to just not be connecting this local variable to the $_SESSION array anymore for some reason.

index.php snippet:
Code: [Select]
session_start();
$action = 'login';
$controller = new UserController($_POST,$_SESSION);

call_user_func(array($controller,$action));

constructor and login action from UserController (constructor is actually from a base controller but that shouldn't matter).
Also the activeSession() function that checks if a session is valid and kicks the user if its not (which is what happens when anything is tried after logging in):
Code: [Select]
    function __construct($post,&$session){
        $this->post = $post;
        $this->session = &$session;
        $this->view = 'views/login.php';
        $this->title = '';
        $this->error = '';
    }

    function login(){
        try{
            $user = $this->validateString($this->post['username'],'Username');
            $pass = $this->validateString($this->post['password'],'Password');
            $dao = new UserData();
            $this->session['userid'] = $dao->login($user, $pass);
            $this->session['username']=$user;
            $dao = new PostData();
            $this->posts = $dao->getFeedPosts($this->session['userid']);
            $this->view = 'views/posts.php';
            $this->title = 'Post Feed';
        }
        catch(Exception $e){
            $this->handleException($e);
        }
    }

    function activeSession(){
        if(!empty($this->session['userid']))
            return true;
        else return false;
    }


Any help would be amazing. I really don't know how this stopped working.
Thanks in advance.

hey guys

so I have this code:
$result = mysql_query("SELECT * FROM pec_mssgs  ORDER BY (y / m) DESC, d ASC");

while($row = mysql_fetch_array($result))
  {
  
  
echo "&bull;<a style='text-decoration: underline; font-weight: bold;' href='../index?id=".$row['id']."'>". $row['m']."/".$row['d']."/".$row['y'] . "  -  ".$row['title']."</a>";
echo "<br /><br />";


  }

in my database instead of doing date I have 3 rows d, m, y, which correlate to day, month, year.

now currently its echo out a list and sorting by year then month then day this way the events which are happening soonest will be at top.

the problem is it shows events that has already passed.

what do I do?

It will be way to much work to to back and recode the application to just use date.

is there a way I can create a var. using my d/m/y then compare that var. to the current date or something?

thanks for the help.

i've been programming in PHP for years, and have done a substantial amount of work on applications of this nature. this problem has me stumped, not because i can't fix it (i did), but because i have no idea what the problem is. there are hundreds of lines of code involved here, so i'll break it down into a post-friendly format.

take this for example, and forgive any typos. it's late, and i've been beating my head against this for over two hours... =\
this is from my form:
Code: [Select]

/*
... numerous form fields being passed as $_REQUEST arrays
*/
<input type="hidden" name="option_id[]" value="<?php print $query_result->option_id; ?>" />
/*
a couple hundred more lines
*/


here's the DB update handler:
Code: [Select]
        if (!empty($_REQUEST['option_name'])) {
            foreach ($_REQUEST['option_name'] as $k => $v) {
                if ($v != '') {
                  $option_id = $_REQUEST['option_id'][$k];
  $option_name = $_REQUEST['option_name'][$k];
  $option_price = $_REQUEST['option_price'][$k];
  $option_desc = htmlentities($_REQUEST['option_desc'][$k], ENT_QUOTES);
  if (!$option_id = '') {
    $sql_options = "UPDATE table SET"
      . " option_name = '" . $option_name . "', option_price = '" . $option_price . "', option_desc = '" . $option_desc
      . "' WHERE option_id = '" . $option_id "'";
        if (!$query_function($sql_options)) {
                          $error = true;
                    }
  } else {
    $sql_options = "INSERT INTO table (option_name, option_price, option_desc)"
      . " VALUES ('" . $option_name . "', '" . $option_price . "', '" . $option_desc . "')";
             if (!$query_function($sql_options)) {
                       $error = true;
                     }
  }
       }
            }
         }

the above code doesn't post to the database because the $option_id variable returns a null value. however, if i replace the $option_id variable where i build the query string with $_REQUEST['option_id'], it works just fine.

Code: [Select]

/*
in relevant part
*/

                    $sql_options = "UPDATE table SET"
      . " option_name = '" . $option_name . "', option_price = '" . $option_price . "', option_desc = '" . $option_desc
      . "' WHERE option_id = '" . $_REQUEST['option_id'] . "'";


needless to say i was infuriated by having spent a couple of hours to come to this conclusion. i only used the variables in the first place because i need to expand the function that this lives inside and i don't want to have to type $_REQUESTs over and over.

the only thing i can think is that it might be a type issue. the data is coming out of the mysql table from an INT field and being placed into the value for the hidden field straight from the row collection. would forcing a variant data type by not strongly typing my variable have caused this problem? i haven't tested the theory because i'm still too ticked off to open my code editor. i'm bouncing this off the community and posting my experience in the hope that it might help someone who comes after.

hi there,

this is a general question where i am confused over long time..

what is the used of passing big encrypted strings in the url? most of the time i see in big sites like google / yahoo. and what are the uses of this in real time .. or they are just  made big to confuse hackers?. any explanation would be highly helpful!. example as below

http://yahoo.com/_ylt=AsXHbMLeE2zV.1Tq082xTdiuitIF/SIG=11licq9d2/EXP=1283427670/**http%3A//mail.yahoo.com/%3F.intl=en

http://click.email.microsoftemail.com?qs=06f2de8ca524e4650483090ed07957e8da3dbc0db662e7f97fa1b5d384b45a28800d5407dd3daa63

How do I echo the time in SECONDS?

$tz =  new DateTimeZone('America/Chicago');
$date = new DateTime('now', $tz);
$mtime =  $date->format('Y-m-d H:i:s');
echo ($mtime);

E.g. 1296057739

I am trying to write a script that is going to access a database, grab the newest picture from it, find the height and width, analyze the height and width to find which command (which is assigned to a variable) is the one to run, run that command in the terminal, and then access the database again 6 seconds later (new pictures are uploaded every 6 seconds) and re-run and enter the command for this new picture. I have most of this already done, the problem I am having is figuring out how to get this to run every 6 seconds for forever. (Yes it has to be every 6 seconds.) Can anyone help me?

Thanks in advance for the help!