Query shouldn't be cached

diaboloxyz

posted 10 years ago

Requests Cache Database

Hi everyone,

my problem is:

i build a query like " DB::select( DB::raw("SELECT cont_timestamp FROM table WHERE id = '$ID_USER'") ) ".

this query will be run by a Javascript timer, so every maybe 5 minutes this query will be set.

but after changing "cont_timestamp" in the database, the query got the same number as in the first run.

For example:

Site run -> Query 1 -> cont_timestamp -> 31 - wait 1 minute - Query 2 -> cont_timestamp -> 31 - Wait 30 sec. - Change cont_timestamp in database to 47 - wait until query 3 - Query 3 -> cont_timestamp -> 47

i do not using a kind of cache or sth similiar.

Is here someone with some idea ?

Last updated 2 years ago.

ck00031

replied 10 years ago

maybe you should use ->remember(minute)

Last updated 2 years ago.

cryode

replied 10 years ago

It's probably the JavaScript call that's caching the response. Look into that.

Last updated 2 years ago.

diaboloxyz

replied 10 years ago

if i using ->remember(1) i get some error : "syntax error, unexpected '->' (T_OBJECT_OPERATOR)"

this shows my query with remember function : " DB::select('SELECT cont_timestamp FROM Table WHERE id = ?', array($ID_USER)->remember(10));"

also i thought this is only for the query builder?

If i using -> " DB::select('SELECT cont_timestamp FROM Table WHERE id = ?', array($ID_USER))->remember(1);" - the application wont start to work.

Also in the JS Console is an error now :

" Uncaught SyntaxError: Unexpected token < "

Edit:

here the JS and PHP :

	varmyVar=setInterval(function()
	{
		

	<?php
	functionholeerstenstamp($ID_USER)
	{		
			$result =  DB::select('SELECT save_timstamp FROM table WHERE id = ?', array($ID_USER));
			$ausgabe2 = $result[0]->save_timstamp;
			echo ('JS: console.log("Save_timestamp 1");');
			echo ('JS: console.log("'.$ausgabe2.'");');
			return ($ausgabe2);				
	}
	functionholeid()
	{
			$urlabhol = $_SERVER['REQUEST_URI'];
			$id_user = substr($urlabhol, 1);
			return ($id_user);
	}


	$timestamp1 = 0;
	echo ('JS: console.log("Stamp1-0'.$timestamp1.'");');
	$user_id = holeid(); 
	$timestamp1 = holeerstenstamp($user_id);
			?>						


	},20000);

Last updated 2 years ago.

Moderators