PHP - How Can I Make Strtotime() More Accurate ?

hey,
i'm working on an online dictionary for my native language. i noticed when searching, the results are sometimes inaccurate.
this is my query.

Code: [Select]
SELECT * FROM words WHERE word LIKE '%$q%'"
for example, if i search for "tive" (supposing this is a real word) it doesnt return the word tive and will return "native" because it occurs first in the database. so i suppose basically i'm looking for a way to sort them by relevancy?

I am trying to calculate the date and time difference between two timestamps.  I am using this for an auction style website and I thought it was working
fine until I woke up this morning and it said that there was only 1 hr left in auction when I actually started a 24 hour auction at like 7pm last night.

//trying to find date diff accurately
Code: [Select]
$now = mktime(date("g"), date("i"), date("s"), date("m")  , date("d"), date("Y"));
$end = $timestamp;
$start = new DateTime();
$start -> setTimestamp($end);

$current = new DateTime();
$current -> setTimestamp($now);

$interval = date_diff($current, $start, true);

$days = $interval ->format('%d');
$hours = $interval ->format('%h');
$minutes = $interval ->format('%i');
$seconds = $interval ->format('%s');

This is how I created the timestamp to store in the database for auction.
Code: [Select]
//Creates timestamp for when auction ends using auction
//length chosen.
$timestamp  = mktime(date("g"), date("i"), date("s"), date("m")  , date("d")+$auction, date("Y"));

the php web video script that I'm trying to modify allows Users to purchase videos successfully, however, the video price that is reflected in the db ('u_paid_videos') table (where transaction info is stored) appears to show the default video price (video_play_price from the 'config' db table) every time, instead of the accurate video price. I'm not sure if this code needs to be tweaked so that the actual price will show in the 'video_play_price' column (in 'u_paid_videos' table):

// get cost video // get the default video price, to use if there is no per video play price
	$db->where('name', 'video_play_price');
	$db_cost = $db->getOne('config');
	$video_cost = (float)$db_cost->value;

	// the number of submitted videos - used to determine if all records were inserted
	$count_video = count($id_array);
	$user_id = $user->id;

	$wallet = (float)str_replace(',', '', $user->wallet);
	$balance = (float)str_replace(',', '', $user->balance);

	// add up the video prices
	$amount = 0;
	foreach ($id_array as $id) {

	$video_id = (int)PT_Secure($id);

	// get video data
	$video = $db->where('id', $id)->getOne(T_VIDEOS);

	// add the video play price if any, or the default price
	$amount += $video->video_play_price?$video->video_play_price:$video_cost;
	}

	// determine if the user has enough credits
	if( ($wallet >= $amount) OR ($balance + $wallet >= $amount) ) {

		$db->startTransaction();

		$inserted_records = 0;
		foreach ($id_array as $id){

			$video_id = (int)PT_Secure($id);

			// get video data
			$video = $db->where('id', $id)->getOne(T_VIDEOS);

			// use the video play price if any, or the default price
			$video_cost_new = $video->video_play_price?$video->video_play_price:$video_cost;

			$uploader_amount = $video_cost_new *0.50;

			// add data to paid table
			$insert_buy = $db->insert('u_paid_videos', [
				'id_user' => $user_id,
				'id_video' => $video_id,
				'session_key' => $_SESSION['session_key'],
				'video_play_price' => (string)$video_cost,
				'video_title' => $video->title, 
				'user_id_uploaded' => $video->user_id, 
				'earned_amount' => $uploader_amount
				]);

 

 

 

 

 

On my search result page, I wanted to search for "Nintendo DS Lite - Pink"

I used following code:

Ex:
Code: [Select]
$search_text = "Nintendo DS Lite Pink";

$kt=split(" ",$search_text);//Breaking the string to array of words

// Now let us generate the sql
while(list($key,$val)=each($kt))
{
if($val<>" " and strlen($val) > 0)
{
$q .= " name like '%$val%' or ";
}
}// end of while

//Remove the last 'OR'
$q=substr($q,0,(strlen($q)-3));



Than the $q would be:
Code: [Select]
SELECT * FROM `products`
WHERE 
name like '%Nintendo%' or 
name like '%DS%' or 
name like '%Lite%' or 
name like '%Pink%'


And i am getting Mysql Output given below:


1) Activity Meter - DS.
2) Nintendo DS Red.
3) Nintendo DS Lite Pink.
4) Nintendo DS Lite Turquoise.

But the third result is most accurate/relevant then first two result.

Please help me out to get the most accurate row first then the relevant rows as per their relevancy with search term "$search_text"

Many Thanks  in Advance.

Hi, I have a bit of an issue with my application, I didn't notice until today, Sunday... Apparently PHP sees Sunday as the first day of the week, which I cannot fathom where it got hat notion from... but anyway, so I have the following samples of my code:
Code: [Select]
    $mondayoflastweek = date('Y-m-d H:i:s', strtotime('monday last week'));
    $sundayoflastweek = date('Y-m-d 23:59:59', strtotime('sunday last week'));

The crazy and very troublesome thing about the results of that code is that if you run that today, Sunday, it shows today as last week... So therefore, the next bit of code is just as problematic:
Code: [Select]
    $mondayofthisweek = date('Y-m-d H:i:s', strtotime('monday this week'));
    $sundayofthisweek = date('Y-m-d 23:59:59', strtotime('sunday this week'));

As you can imagine, for payroll, this is causing a big problem... My week starts at precisely 12:00 am on Monday and ends at precisely 11:59 pm on Sunday...

Could someone please help me out with this...