Learn VBA & Macros in 1 Week!

PHP - Updating The Timestamp Error

Full Excel VBA Course - Beginner to Expert

Updating The Timestamp Error	View Content

Hi,

I have a php form that submits updated 'comments' onto specific records.

I have now added a timestamp feature to record the time of submission automatically.

I have only added the lines and sections containing 'sent' (which is the column that for the timestamp) but there is an error when I do this and the php file shows an error as a result.

$hospitalnumber = $_POST['hospitalnumber'];
   $PIN = $_POST['PIN'];
   $comments = $_POST['comments'];
   $sent = date("Y-m-d H:i:s");

   // mysql query to Update data
   $query = "UPDATE `greencard` SET `comments`= '$comments', 'sent' = '$sent' WHERE `hospitalnumber`= '$hospitalnumber' and `PIN`= '$PIN'";

I have tested the timestamp coding and it has worked on other php files I made so I am confused as to what is wrong.

Also, the overall code works when I remove 'sent' = '$sent' and $sent = date("Y-m-d H:i:s"); (but obviously without updating the timestamp).

Any help appreciated as always.

Full Excel VBA Course - Beginner to Expert

Updating Error

Similar Tutorials

View Content

well here my page i tryed and tryed to get it working but it shows the data but it dont update it

Code: [Select]
[php]<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><?php include "../config.php";

$id = $_GET['id'];
$con = database_connect();
$sql = "SELECT * FROM anime1 WHERE animeid ='$id'";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {

$title = $row['title'];
$type = $row['type'];
$episode = $row['episode'];
$year = $row['year'];
$genre = $row['genre'];
$status = $row['status'];
$summary = $row['summary'];
$pictures = $row['pictures'];

}mysql_query($sql) or exit(mysql_error());
mysql_close($con);
?>

<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$(".flip").click(function(){
$(".panel").slideToggle("slow");
});
});

</script>

<style type="text/css">

</style>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Transdmin Light</title>


<link href="style/css/transdmin.css" rel="stylesheet" type="text/css" media="screen" />




<script type="text/javascript" src="style/js/jquery.js"></script>
<script type="text/javascript" src="style/js/jNice.js"></script>
</head>

<body>
<div id="wrapper">

<h1><a href="#"><span>Transdmin Light</span></a></h1>


<ul id="mainNav">
<li><a href="#">DASHBOARD</a></li>

<li><a href="./anime.php" class="active">Anime</a></li>
<li><a href="#">DESIGN</a></li>
<li><a href="#">OPTION</a></li>
<li class="logout"><a href="#">LOGOUT</a></li>
</ul>


<div id="containerHolder">
<div id="container">
<div id="sidebar">
<ul class="sideNav">
<li><?php echo $lbox1 ?></li>
<li><?php echo $lbox2 ?></li>
<li><?php echo $lbox3 ?></li>
<li><?php echo $lbox4 ?></li>
<li> <?php echo $lbox5 ?></li>
<li><?php echo $lbox6 ?></li>
</ul>

</div>


<h2><a href="#">Anime</a> » edit » <?php echo "$title"; ?></h2>
<div id="main">
<form action="<?php echo $_SERVER['PHP_SELF']."?id=$id" ; ?>" method="post" class="jNice">
<h3>Editing <?php echo "$title"; ?>, when finished click submit</h3>
<fieldset>
<p>
<label>Series Title -- (Put the Title of the Series you are adding into here)</label>
<input name="title" type="text" class="text-long" id="title" value="<?php echo $title ?>" />
</p>
<p>
<label>Type -- (Put what type of anime is it?)</label>
<select name="type" id="type">
<option selected="selected">Select one</option>
<option>TV Series</option>
<option>OVA</option>
<option>TV Special</option>
<option>Movie</option>
<option>Web</option>
<option>DVD Special</option>
<option>Other</option>
</select>
</p>
<p>
<label>Episodes -- (How many Episode are there?)</label>
<input name="episode" type="text" class="text-long" id="episode" value="<?php echo $episode ?>" />
</p>
<p>
<label>Year -- (What year was the anime release in?)</label>
<input name="year" type="text" class="text-long" id="year" value="<?php echo $year ?>" />
</p>
<p>
<label>genre <a href="./genre">(click this for the list and FAQ for adding in genre)</a></label>
<input name="genre" type="text" class="text-long" id="genre" value="<?php echo $genre ?>" />
</p>
<p>
<label>status -- (What Is the status of the anime, Completed, Ongoing or Stalled)</label>
<select name="status" id="status">
<option selected="selected">Select one</option>
<option>Complete</option>
<option>Ongoing</option>
<option>Stalled</option>
</select>
</p>
<p>
<label>Summary -- (Put in the Summary for the anime)</label>
<textarea name="summary" cols="1" rows="1" id="summary"><?php echo $summary
?></textarea>
</p>
<p>
<label>Pictures -- (link to the Anime Pictures you upladed)</label>
<input name="pictures" type="text" class="text-long" id="pictures" value="<?php echo $pictures ?>" />
</p>
<?php
  $con = database_connect();
  $sql="UPDATE anime1
SET title='$title', type='$type', episode='$episode', year='$year', genre='$genre', status='$status', summary='$summary', pictures='$pictures' WHERE animeid = '$id'";

$con = database_connect();
$title = $_POST['title'];
$type = $_POST['type'];
$episode = $_POST['episode'];
$year = $_POST['year'];
$genre = $_POST['genre'];
$status = $_POST['status'];
$summary = $_POST['summary'];
$pictures = $_POST['pictures'];
$title = mysql_real_escape_string($title);
$type = mysql_real_escape_string($type);
$episode = mysql_real_escape_string($episode);
$year = mysql_real_escape_string($year);
$genre = mysql_real_escape_string($genre);
$status = mysql_real_escape_string($status);
$summary = mysql_real_escape_string($summary);
$pictures = mysql_real_escape_string($pictures);
error_reporting(-1);

if (!mysql_query($sql,$con))
  {
  die('Error adding anime database: ' . mysql_error());
  }

?>
<h3> </h3>

<?php

$con = database_connect();
$sql1 = "SELECT * FROM episodea WHERE animeid = '$id'
UNION ALL
SELECT * FROM episodeb WHERE animeid = '$id'";
$result1 = mysql_query($sql1);
while ($row = mysql_fetch_assoc($result1)) {
$ep = $row['ep'];
$epname = $row['epname'];
$animeid = $row['animeid'];
$video = $row['video'];
$video2 = $row['video2'];
$video3 = $row['video3'];

mysql_query($sql) or exit(mysql_error());

              echo "    <div class=\"panel\">\n";
echo "<p>\n";
echo "                         <label>Episodes -- (When this box says Anime episode finished, you have added in all the episodes)</label>\n";
echo "                         <input name=\"ep\" type=\"text\" class=\"text-long\" id=\"ep\" value=\" $ep\" readonly=\"readonly\" />\n";
echo "                       </p>\n";
echo "                       <p>\n";
echo "                         <label>Episodes Name-- (What is the name of the episode you are adding? --- If the episodes has no name enter episode number)</label>\n";
echo "                         <input name=\"epname\" type=\"text\" class=\"text-long\" id=\"epname\" value=\" $epname\" />\n";
echo "                       </p>\n";
echo "                       <p>\n";
echo "                         <label>Viewable -- (Is the episode your are adding in SUBBED or DUBBED or RAW?)</label>\n";
echo "                            <select name=\"viewable\" id=\"viewable\">\n";
echo "                            <option selected=\"selected\">Select one</option>\n";
echo "                             <option>SUBBED</option>\n";
echo "                             <option>DUBBED</option>\n";
echo "                             <option>RAW</option>\n";
echo "                            </select>\n";
echo "                           </p>\n";
echo "                       <p>\n";
echo "                            <label>Video 1 -- (enter the embed code for the episode you are adding in)</label>\n";
echo "                          <textarea name=\"video\" cols=\"1\" rows=\"1\" id=\"video\"> $video</textarea></p>\n";
echo "                          <p>\n";
echo "                            <label>Video 2 -- ( If you have a 2ed embed code </label>\n";
echo "                            <textarea name=\"video1\" cols=\"1\" rows=\"1\" id=\"video1\"> $video2</textarea>\n";
echo "                          </p>\n";
echo "                          <p>\n";
echo "                            <label>Video 3 --( If you have a 3ed embed code </label>\n";
echo "                            <textarea name=\"video4\" cols=\"1\" rows=\"1\" id=\"video4\"> $video3</textarea>\n";
echo "<h3>\n";
echo "<a href=\"#submit\">IF you finished editing ep, click me to go to submit button</a></h3>\n";
echo "                          </p>\n";
echo "</div>\n";
echo " \n";
echo " <br />";
echo "<br />";
echo "<p class=\"flip\">Click here to edit all Episodes For $title </p>\n";

echo " <br />";
echo "<br />";

   }
  ?>
<h3>

remember to click submit before changing the page</h3>
<h3> </h3>
<h3>
<a name="submit" id="submit"></a>
<input type="submit" value="Submit Query" />
</h3>
</fieldset>
</form>
</div>

<div class="clear"></div>
</div>

</div>


<p id="footer">Feel free to use and customize it. <a href="http://www.perspectived.com">Credit is appreciated.</a></p>
</div>

</body>
</html>
[/php]

Error Updating Record:

Similar Tutorials

View Content

I am getting this error when updating a record (through a form)

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/wormste1/public_html/tilburywebdesign/shop/FTPServers/barryottley/updates.php on line 62

This is updates.php

<?php

mysql_connect("localhost", "wormste1_barry", "barry") or die(mysql_error());
mysql_select_db("wormste1_barry") or die(mysql_error());

$carname = mysql_real_escape_string(trim($_POST['CarName']));
$cartitle = mysql_real_escape_string(trim($_POST['CarTitle']));
$carprice = mysql_real_escape_string(trim($_POST['CarPrice']));
$carmiles = mysql_real_escape_string(trim($_POST['CarMiles']));
$cardesc = mysql_real_escape_string(trim($_POST['CarDescription']));

mysql_query("UPDATE cars WHERE id='.intval ($_GET['id']).' LIMIT 1
(CarName, CarTitle, CarPrice, CarMiles, CarDescription, photo) VALUES('$carname', '$cartitle', '$carprice', '$carmiles', '$cardesc' ) ")
or die(mysql_error());

echo "The vehicle data has been updated!";

?>

the updates.php actually processes the update.

the form page is edit.php:

<CENTER><B>Update a Vehicle</B></CENTER>
<BR>

<?php
$what_id=$_GET['id'];
$query="SELECT * FROM cars WHERE id = '$what_id'";
$result=mysql_query($query);
while($row=mysql_fetch_array($result)) {

$carname = $row['CarName'];

$cartitle = $row['CarTitle'];

$carprice = $row['CarPrice'];

$carmiles = $row['CarMiles'];

$cardesc = $row['CarDescription'];
}
?>
<form action="updates.php" method="post">
<CENTER>Vehicle Name:</CENTER> <br><CENTER><input type="text" name="CarName" value="<?php echo $carname; ?>"></CENTER><br>
<CENTER>Vehicle Type:</CENTER><br><CENTER><input type="text" name="CarTitle" value="<?php echo $cartitle; ?>"></CENTER><br>
<CENTER>Vehicle Price:</CENTER><br><CENTER><input type="text" name="CarPrice" value="<?php echo $carprice; ?>"></CENTER><br>
<CENTER>Vehicle Mileage:</CENTER><br><CENTER><input type="text" name="CarMiles" value="<?php echo $carmiles; ?>"></CENTER><br>
<CENTER>Vehicle Description:</CENTER><br><CENTER><input type="text" name="CarDescription" value="<?php echo $cardesc; ?>"></CENTER><br>
<CENTER>Vehicle Description:</CENTER><br>
<CENTER><textarea name="CarDescription" rows="10" cols="30" value="<?php echo nl2br($cardesc); ?>"></textarea></CENTER><br>
<CENTER><input type="Submit"></CENTER>
</form>

Any idea for the error. I think it could be because the UPDATE tag syntax is wrong.

Help would be great!!!

Error Occurs While Updating Data In Mysql Using Csv File

Similar Tutorials

View Content

I need help here. I am creating a system where the user will be able to update the product stock by uploading the stock of the products according to the id that has been assigned to the product.
this is how my products table in looks like in mysql database

I tried the code below but all i could not update my data into my database. And there's not error shown on my code. I do not know what is wrong with my codes. Please help me.
below the code that i use for uploading the CSV file to the data of my product_stock.

<?php 
include 'conn.php';
if(isset($_POST["add_stock"]))
{
 if($_FILES['product_file']['tmp_name'])
 {
  $filename = explode(".", $_FILES['product_file']['tmp_name']);
  if(end($filename) == "csv")
  {
   $handle = fopen($_FILES['product_file']['tmp_name'], "r");
   while($data = fgetcsv($handle))
   {
    $product_id = mysqli_real_escape_string($conn, $data[0]);
    $product_stock = mysqli_real_escape_string($conn, $data[1]);  
    $product_status = 1 ;
    $query = "UPDATE products SET `product_stock` = '$product_stock', `product_status` = '$product_status' WHERE id = '$product_id'";
    mysqli_query($conn, $query);
   }
   fclose($handle);
   header("location: upload-product.php?updation=1");
  }
  else
  {
   echo '<script>alert("An error occur while uploading product. Please try again.")
   window.location.href = "upload-product.php"</script>';
  }
 }
 else
 {
  echo '<script>alert("No file selected! ")
  window.location.href = "upload-product.php"</script>';
 }
}
if(isset($_GET["updation"]))
{
  echo '<script>alert("Product Stock Updated successfully!")</script>';
}
?>

 <div class="col-12">
            <div class="card card-user">
              <div class="card-header">
                <h5 class="card-title">Update Product Stock</h5>
                <div class="card-body">
                <div class="form-group">
				<label for="file">Update Products stock File (.csv file)</label>
                <a href="assets/templates/product-template.xlsx" title="Download Sample File (Fill In Information and Export As CSV File)" class="mx-2">
				<span class="iconify" data-icon="fa-solid:download" data-inline="false">
				</a>
                </div>
                <form class = "form" action="" method="post" name="uploadCsv" enctype="multipart/form-data">
                <div>
                <input type="file" name="product_file" accept=".csv">
                <div class="row">
                <div class="update ml-auto mr-auto">
                <button type="submit" class="btn btn-primary btn-round" name="add_stock"> Import .cvs file</button>
                </div>
                </div>
                </div>
                </div>
                </form>
                </div>
              </div>

Hi am trying to add date and timestamp of when a comment gets posted.Am not gr8t at php but still learning.
If any one can help me on this would be reil gr8t.
Sry for the long post.
As for now i have this Code: [Select]
$date = date("M j, y, g:i a"); and echo's out the date, time [/code]$date[/code] as in the current date and time which i dont want.

Code: [Select]
<?php
$query = yasDB_select("SELECT * FROM newsblog");
if($query->num_rows == 0) {
echo '<div id="newsblog_text">This news blog has no comments, become a member and be the first to add one!</div>';
} else {
$query = yasDB_select("SELECT * FROM newsblog WHERE userid = '$id'");
while($row = $query->fetch_array(MYSQLI_ASSOC)) {
$date = date("M j, y, g:i a");
$text = $row['comment'];
$text = str_replace(':D','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/biggrin.gif" title="biggrin" alt="biggrin" />',$text);
$text = str_replace(':?','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/confused.gif" title="confused" alt="confused" />',$text);
$text = str_replace('8)','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/cool.gif" title="cool" alt="cool" />',$text);
$text = str_replace(':cry:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/cry.gif" title="cry" alt="cry" />',$text);
$text = str_replace(':shock:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/eek.gif" title="eek" alt="eek" />',$text);
$text = str_replace(':evil:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/evil.gif" title="evil" alt="evil" />',$text);
$text = str_replace(':lol:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/lol.gif" title="lol" alt="lol" />',$text);
$text = str_replace(':x','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/mad.gif" title="mad" alt="mad" />',$text);
$text = str_replace(':P','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/razz.gif" title="razz" alt="razz" />',$text);
$text = str_replace(':oops:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/redface.gif" title="redface" alt="redface" />',$text);
$text = str_replace(':roll:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/rolleyes.gif" title="rolleyes" alt="rolleyes" />',$text);
$text = str_replace(':(','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/sad.gif" title="sad" alt="sad" />',$text);
$text = str_replace(':)','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/smile.gif" title="smile" alt="smile" />',$text);
$text = str_replace(':o','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/surprised.gif" title="surprised" alt="surprised" />',$text);
$text = str_replace(':twisted:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/twisted.gif" title="twisted" alt="twisted" />',$text);
$text = str_replace(':wink:','<img src="' . $siteurl . 'templates/' . $theme . '/styles/images/smileys/wink.gif" title="wink" alt="wink" />',$text);
echo '<div class="newsblog_box1"><div class="newsblog_name">' . $row['name'] . ' '.$date.'</div></div>
<div class="newsblog_box2">' . $text . '</div>';
}
}?>