PHP - Moved: Stamp Time : Update?

Hello, i need a fast convertor that converts the date format 03-03-2008, 08:26 PM into a timestamp fast.
Like, you paste 03-03-2008, 08:26 PM into a post form, submit and it gives you the time stamp.

I made a convertor a whille ago, but you need to insert each numbers into a separate input box (day, months, year etc)
I cant remember how exactly it functions etc asi haventtouched PHP In a while.....

2011-02-05T18:07:57.00+0000

This is a string.

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

This topic has been moved to Application Design.

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

Ohhh, these thoughts just run through my head as I sleep.  But will it work?

Can I set a function so that my UPDATE form will NOT execute after a certain DATE (or even a time of day?)

I'm thinking something along the lines of:
$time=timestamp
if $time>19:00
  echo" You need to make changes before 7:PM";
else (UPDATE... yadda yadda yadda)

Yes, i know this is worse than a rough draft, but will it work?  Is it acceptable methodology?

Hi i need to count the number items in an album now on the album i have create a field called count which counts the number items in that album

but now i dnt knw how to update those as soon insert a item in the table item

so i thought woul be possible to create a script that when insert data into item tables also update album table row count by adding one like update count with A now A equal row count ++1  any help on start of it if possible???/

hi
my db table  has 2 field:

ID - Place
1     France
2     Germany

My form has 2 text field (printed with while cycle).

mysql_query("UPDATE mytable SET Place = '" . $_POST['place'] . "' WHERE ID=". $_POST['ID']." ");

This query doesn't work, because updates only the last record.

Where is wrong?

many thanks 

I have a form right now that Updates a table on my database.

I was wondering if I could possibly still have that working but also Insert the same information into another table on the database when the submit button is pressed?

I'm working on a chat using basic textarea input, post, but the problem that I'm facing is, if a person doesn't send something, then the output is not updated eg. other messages from other users updating in real time.   How is that achieved when you see new database entries pop up live, milliseconds after they are entered? Do I set a constant refresh rate of some sort?   How do you update a section of a webpage without "refreshing" the entire page like the POST method?

The table is:

next       next_id        id

0              2               1
1              3               2
0              4               3
0              1               4



The form:

<?php 
include 'dbc.php';
page_protect();

if(!checkAdmin()) {
header("Location: login.php");
exit();
}

  if($_POST['doSubmit'] == 'Create') {

list($next_id) = mysql_fetch_row(mysql_query("select next_id from users where id='$id'"));

mysql_query("update users set approved='1' where id='$id'");

mysql_query("update users set next='1' where id='$next_id'");

mysql_query("update users set next='0' where id='$id'");

list($to_email) = mysql_fetch_row(mysql_query("select user_email from users where id='$id'"));

$ret = $_SERVER['PHP_SELF'] . '?'.$_POST['query_str'];  
 header("Location: $ret");
 exit();

$message = 
"Hello \n

";

@mail($to_email, "Aaaaack", $message,
    "From: \"Lobo\" <auto-reply@$host>\r\n" .
     "X-Mailer: PHP/" . phpversion()); 

 
}
 

  ?>
Code: [Select]
<html>
  <body>
      <table width="80%" border="0" cellpadding="5" cellspacing="2" class="myaccount">
        <tr>
          <td>i<form name="form1" method="post" action="form.php">
             
                <input name="doSubmit" type="submit" id="doSubmit" value="Create">
              </p>
            </form>
            </td>
        </tr>
      </table>
     
     </body></html>


I am sorry if this is posted in the wrong place!  Here to learn.  Thank you for any clues!

Is there any way to have a field that will update any time its row is updated?   My situation is that I will have multiple devices writing to a database, and in one case the time that is being kept track of is important.  And the devices writing to the database are a bit difficult to keep accurate times on, so instead of writing the time from the devices themselves, I was hoping I could just have a field update itself. I know it can be done on INSERT, but I do not want to do an INSERT every time.   Thanks!

I'm not looking for code, mostly just some direction, but I'm sure I'll be back as I try to shape the code.  Also, I know very little about coding jQuery, Ajax, etc.  Here is what I'm looking for:

Basketball coach enters a Page that only he (or admin) can see.  (I have that part figured out.)
Once there, he has a form to fill out with a player's name and other information.

I'd rather there not be 12 rows of empty cells.  (Coaches will view that as work)
I'd rather not have the Page reload on each "Add", but that would be the lesser of two evils.

Is there a way to keep a persistent connection so when a coach hits Add, the player gets added to the database, a new empty form shows up, and the player's information shows up below on a roster?

This topic has been moved to MySQL Help.

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