PHP - Why Does The Date Stamp Work On Some Sites And Not Others?

I am getting syntax error, unexpected T_CONSTANT_ENCAPSED_STRING
on the date stamp line below but I can't see what is causing the problem.
when I comment it out the problem goes away so I know I it is there.
please help.
 
$email_message = "Form details below.\n\n";
 $email_message = date("m/d/Y")"\n";

(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

hello, im trying to figure out the difference between 2 numbers in minutes.  here is what i have:

Code: [Select]
$tsignin="09-05 10:30:00";
$tsignina="09-06 11:30:00";

$log_in_time_stringsa = strtotime($tsignin);
$log_out_time_stringsa = strtotime($tsignina);
$difference_in_secondssa = ($log_out_time_stringsa - $log_in_time_stringsa);
$tsigna = ($difference_in_secondssa / 60);
 
  $tsigna2 = number_format(round($tsigna));
the 09-05 is sept 5, and 09-06 is sept 6.

this works if the month and date are not included.  any ideas for me so i can figure out the total difference between date/times?

This topic has been moved to MySQL Help.

http://www.phpfreaks.com/forums/index.php?topic=315056.0

Code: [Select]
<?php
$myServer = "202.138.125.155";
$myUser = "micro_fms";
$myPass = "micro_fms*#$";
$myDB = "micro_fms"; 

//create an instance of the  ADO connection object
$conn = new COM("ADODB.Connection")or die("Cannot start ADO");

//define connection string, specify database driver
$connStr = "PROVIDER='SQLOLEDB'; SERVER=".$myServer.";UID=".$myUser.";PWD=".$myPass.";DATABASE=".$myDB; 

//Open the connection to the database
$conn->open($connStr);

//$table_name=$_GET['Device'];
$table_data=$_GET['Data'];
$data=(explode(",",$table_data));

$table_name=$data[0];
$speed=$data[1];
$time=$data[2];
$date=$data[3];
$lat=$data[4];
$long=$data[5];
//$newdate = substr($date,6,2) . "-" . substr($date,0,2) . "-" substr($date,3,2);
$datetime=$date.$time;


$new_lat = substr($lat,0,2).'.'.substr($lat,2);
$new_long = substr($long,0,2).'.'.substr($long,2);

echo $table_name."<br>";
echo $speed."<br>";
echo $new_lat."<br>";
echo $new_long."<br>";
echo $datetime."<br>";

$query="insert into $table_name (DeviceNumber,Speed,dtDateTime,Latitude,Longitude)values('$table_name','$speed','$datetime','$new_lat','$new_long')";


//execute the SQL statement and return records
$rs = $conn->execute($query);
if($rs)
{
echo 'Values Inserted';
}
else
{
echo "faile";
}
?>


Hi friends...
I have two variables ($date and $time). I concat these two strings and make a new variable called "$datetime". Now in above code I want to insert it into table but I got the following error. Code: [Select]
Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Microsoft OLE DB Provider for SQL Server<br/><b>Description:</b> Conversion failed when converting datetime from character string.' in C:\wamp\www\FMS\fms.php:44 Stack trace: #0 C:\wamp\www\FMS\fms.php(44): com->execute('insert into A00...') #1 {main} thrown in C:\wamp\www\FMS\fms.php on line 44
In my database, data type of column in which I want to insert is Date time stamp though I have string type ($datetime) variable.
I think I have to convert this $datetime variable string to "DateTime type first but don't have any idea about it.
Please help??/
Thanks in advance....

I am trying to enter a new time stamp into mysql database when a user logs in at my site.
I read on the update syntax but can't seem to get it to do it.. It reads the values just doesnt write the values into mysql.

$update_query = mysql_query UPDATE users SET (last_access, ip_address, browser, hostname) values ($date, $IP, $browser, $hostname) WHERE username = '$login'") or die("QUERY FAILED: " . mysql_error()); 
$update = ($update_query) or die ("QUERY FAILED: " . mysql_error()); 

I have this code to change the validity date of an account.
I do a check against timestamp and current validity which works  fine.
Then I have radio buttons you can check to choose to extend with one, three, six or 12 months through a form and a post variable - they work too.
When I write the variables out they look fine but when I want it in my database - nothing happens!
I mean the original data is never changed.
Can you see what is wrong?

I tried changing the data type from date to datetime to timestamp with the same result.
I suppose I will learn something new from phpfreaks today again.

Code is here for the 12 month radio button:
Code: [Select]
$newdate = strtotime ( '+12 months' , strtotime ($fromDate) ) ;
$newdate = date ('Y-m-d H:i:s', $newdate );
echo "$newdate";
$query = "UPDATE TABLE user_data SET paid_days='$newdate' WHERE user='$user'";
mysql_query($query);When I write the variable $newdate it shows up as 2013-01-10 21:55 (right now) which seems like a valid format to me.
Do I need to convert it somehow?

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=306905.0

I'm having a problem with getting the timestamp to attach to the filename.  Currently when it's uploaded in the database it says $timestamp in front of the filename instead of the time.

Scroll down towards the bottom of the code to see it.  Thanks for your help!


$username = $_GET['username'];
$item_id = $_GET['id'];

  define( 'DESIRED_IMAGE_WIDTH', 150 );
  define( 'DESIRED_IMAGE_HEIGHT', 150 );

  $source_path = $_FILES[ 'thumb' ][ 'tmp_name' ];
  $timestamp = time();

  //
  // Add file validation code here
  //

  list( $source_width, $source_height, $source_type ) = getimagesize( $source_path );

  switch ( $source_type )
  {
    case IMAGETYPE_GIF:
      $source_gdim = imagecreatefromgif( $source_path );
      break;

    case IMAGETYPE_JPEG:
      $source_gdim = imagecreatefromjpeg( $source_path );
      break;

    case IMAGETYPE_PNG:
      $source_gdim = imagecreatefrompng( $source_path );
      break;
  }

  $source_aspect_ratio = $source_width / $source_height;
  $desired_aspect_ratio = DESIRED_IMAGE_WIDTH / DESIRED_IMAGE_HEIGHT;

  if ( $source_aspect_ratio > $desired_aspect_ratio )
  {
    //
    // Triggered when source image is wider
    //
    $temp_height = DESIRED_IMAGE_HEIGHT;
    $temp_width = ( int ) ( DESIRED_IMAGE_HEIGHT * $source_aspect_ratio );
  }
  else
  {
    //
    // Triggered otherwise (i.e. source image is similar or taller)
    //
    $temp_width = DESIRED_IMAGE_WIDTH;
    $temp_height = ( int ) ( DESIRED_IMAGE_WIDTH / $source_aspect_ratio );
  }

  //
  // Resize the image into a temporary GD image
  //

  $temp_gdim = imagecreatetruecolor( $temp_width, $temp_height );
  imagecopyresampled(
    $temp_gdim,
    $source_gdim,
    0, 0,
    0, 0,
    $temp_width, $temp_height,
    $source_width, $source_height
  );

  //
  // Copy cropped region from temporary image into the desired GD image
  //

  $x0 = ( $temp_width - DESIRED_IMAGE_WIDTH ) / 2;
  $y0 = ( $temp_height - DESIRED_IMAGE_HEIGHT ) / 2;

  $desired_gdim = imagecreatetruecolor( DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT );
  imagecopy(
    $desired_gdim,
    $temp_gdim,
    0, 0,
    $x0, $y0,
    DESIRED_IMAGE_WIDTH, DESIRED_IMAGE_HEIGHT
  );

  //
  // Render the image
  // Alternatively, you can save the image in file-system or database
  //

  header( 'Content-type: image/jpeg' );
  imagejpeg( $desired_gdim, "image_files/".'$timestamp'.$_FILES["thumb"]["name"] );
  
  
  
mysql_connect("localhost", "root", "", "") or die(mysql_error());
mysql_select_db("") or die(mysql_error());

$timestamp = time();
$item_image = '"$timestamp"'.$_FILES['thumb']['name'];
  
$sql="UPDATE product SET thumb='$item_image' WHERE id = '$item_id'";

 if (!mysql_query($sql))

  {

  die('Error: ' . mysql_error());

Code: [Select]
for ($z=1;$z<=30*365; $z++)
{
$bal[date('Y-m-d', strtotime("+ ". $z ." days"))] = $balance;//the balance of loan here.;
}

As you can see Im working on loading the daily balance of a 30 year loan in an array.

The code goes to hell in the year 2038.  I have scoured the internet for help.  I have gone to the wikipedia link and have looked at other posts but there isn't quite something that can help me.  How can I load dates beyond 01-18-2038 into my array?

I have heard of ways to do it with MySQL and the DATETIME() function, but that doesn't seem to make sense for what I am trying to accomplish.

Please point me in the right direction.

Thanks.

Hi everyone...

I would like to implement a questionnaire/survey system that has only two Answers (Yes /No).

Basically, this questionnaire system will be widely used on Mobile Phones.

It will be looking something like this below: http://awardwinningfjords.com/2009/06/16/iphone-style-checkboxes.html

Lets say a user selects a response as No (Using the above slider button for a question). That response should be recorded in the database with User Details + Time Stamp.

Also, I would like to generate a report for each question (Responses of Multiple Users) and a report at a User Level for the entire questionnaire/survey (s).

Can some one guide me the fastest & easiest way to achieve this? I'm a new learner of PHP.

Regards
Sandeep

Hi guys

I was just wondering if there is some date combination for which this type of comparisons will not work.

var_dump("2010-15-1">"2010-4-01");

Provided the date is always in the YYYY-mm-dd format with optional preceding 0 .

Thanks

Hey,

I'm using a script which allows you to click on a calendar to select the date to submit to the database.

The date is submitted like this: 2014-02-08

Is there a really simple way to prevent rows showing if the date is in the past?

Something like this:
if($currentdate < 2014-02-08 || $currentdate == 2014-02-08) {

}

Thanks very much,
Jack

Hi

I am trying to create a site that determines the device's screen size. Most mobile phone browsers does not have javascript, so to determine the width and height of the screen I cannot use Javascript. Does anyone know how i can test whether a mobile phone is used to visit the site and what that phone's screen resolution is, so that I can redirect it to the right folder.

Thanks in advance

Hi, i webmaster multi sites and at the moment run php code to block unwanted ip addresses because of bad submittings.   I am running this code at the moment <?php