PHP - Updating Time Stamp - No Update

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());

This topic has been moved to JavaScript Help.

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

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 executes with no errors but it is not updating the db. I have previously verified that the record exists.


<?php // update  database
 
// Connect to database =====================================================

include("connect_db.php");

// retrieve form data from form2.html  ==========================================

$id = $_POST['id']; // do not change
$id = $_POST['ama']; // do not change
$id = $_POST['model_name'];
$id = $_POST['model_mfg'];
$id = $_POST['wingspan'];
$id = $_POST['engine'];
$id = $_POST['decibels'];

// Send query ===========================================================

$query = "UPDATE airplanes SET model_name = '$model_name' WHERE id = '$id'";

//if (!mysql_query($query)){
//die('Error :' .mysql_error());
//}
   
echo '<p>Return to <a
href="members_menu.html">Members Menu</a></p>';

?>


Thanks

Hi there.  I'm totally new (about a week!) with php and mysql and am encountering a problem that perhaps someone can help me with? I've looked through to see if a similar problem has appeared or been solved, but without success, so apologies if I am repeating something.    In php I am trying to update 7 fields from a form from which a user has edited/modified any of the fields in a chosen record (except id).   Here is the code:   $id=$_GET['id'];

I have the following PHP script to update two time/date fields in the database.

When i run this the fields are not updated.

Can anyone see where i m going wrong.

<?php
$con = mysql_connect("localhost","dbname","dbpassword");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

echo 'Connected successfully';

mysql_select_db("my_db", $con);

mysql_query("UPDATE msm_content SET created = '2011-01-02 00:00:00', modified = '2011-01-01 00:00:00'");

echo 'Query Updated successfully';

mysql_close($con);
?>

Your guidance is much appreciated.

The following code works. The user checks off what foods they want to be added. Then the foods and their nutrient values get added into the database. However, if the user refreshes, it updates the database with the values they selected before - thus doubling the amount of foods stored in the database. How do I stop this from happening?

Right now i'm taking values from the POST array and running an INSERT SQL query to put them into the database. (look for the following comment below: //Look here PHPFREAKS.COM)

Code: [Select]
<?php include 'top.php'; ?>
<?php

if (!loggedin())
{//1 if start
header('Location: need-to-log-in-mmp.php');
}//1 if end
?>
    <title>My Meal Planner - Vitamin K Tracker</title>
</head>

<div id="container">

<?php include 'header.php'; ?>

<?php include 'nav.php'; ?>



<div id="content-container">

<div id="content_for_site">
<h2>My Meal Planner</h2> <br />
                     
     


     
       
                        My Meal Que:
<br />
<ul>
<form action="my-meal-planner.php" method="POST">
<?php
//do sql query to return the foods and nutrients that a person added to their que

$query = "SELECT DISTINCT
foods.id, `name`, `source`,`vit_k`, `cal`,`protein`, `fiber`, `carbs`, `sugar`, `sodium`, `chol`, `total_servings`
 FROM `foods`
 LEFT JOIN users_foods
 ON foods.id=users_foods.food_id

WHERE users_foods.user_id =". $_SESSION['user_id']."
 ORDER BY users_foods.id";



$query_run = mysql_query($query, $link);
//echo mysql_errno($link) . ": " . mysql_error($link). "\n";
while ($row = mysql_fetch_array($query_run)){
?> <input type="checkbox" name="<?php
echo $row["id"];
?>"<?php
    echo ' value="'.$row["id"].'" />';
echo ' Food Name: '. $row["name"]." | Vitamin K: ".
    $row["vit_k"]." | Fiber: ".
    $row["fiber"]." | Calories: ".
    $row["cal"]." | Protein: ".
    $row["protein"]." | Carbs:".
    $row["carbs"]." | Sugar: ".
    $row["sugar"]." | Sodium: ".
    $row["sodium"]." | Cholesterol: ".
    $row["chol"]." | Source: ".
    $row["source"]." | Total Servings: ".
    $row["total_servings"]. "<br />How many servings will you have? "?><input type="text" name="<?php
echo $row["id"]."serving";
?>"<?php
    echo ' />';
   echo '<br /><br />';
}
     

?>
</ul>
Select a date: <input id="date" type="text" name="add_to_calendar"><br />
<input type="submit" value="add to calendar" ><br />





<input type="button" value="delete" name="delete">

</form>

<?php
//updates the date of the food 
if (isset($_POST['add_to_calendar']) && !empty($_POST['add_to_calendar'])){

$add_to_calendar = $_POST['add_to_calendar'];
$date_array = explode("/", $add_to_calendar);
                   

//Look here PHPFREAKS.COM
for ($i=1; $i<1000; $i++){
if (!empty($_POST[$i])){
$id = $_POST[$i];
$serv = $id. "serving";
$serving = $_POST[$serv];
$month = $date_array[0];
$day = $date_array[1];
$year = $date_array[2];
//echo 'month: '. $month . ' day: ' . $day . ' year: ' . $year . "<br />"; 

if (substr($month,0,1) == '0'){
//takes out a zero in front of month if it exists
$month = substr($month,1,1);}

if (substr($day,0,1) == '0'){
//takes out a zero in front of day if it exists
$day = substr($day,1,1);}

//echo 'POST ARRAY READS AS: <br />';
//print_r($_POST);
//echo '<br />';
$query = "INSERT INTO `users_calendar` VALUES ('','".$_SESSION['user_id']."','".$id."','".$month."','".$day."','".$year."','".$serving."')";
//echo '<br /> The query reads as: ' . $query;
$query_run = mysql_query($query) or die(mysql_error());
//columns in users_calendar:
//DONEid    DONEuser__id   DONEfood_id    DONEcalendar_month   DONElendar_day    DONEcalendar_year    servings
  }
}




}
?>

<br />


</div>



<script type="text/javascript" src="js/datepicker.js"></script>
<div id="clear"></div>
<?php //include 'footer.php'; ?>


</div>
</div>
</body>
</html>

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?

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?

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'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!