Databases
StackOverflow2013
Postsdbo
POinsert datestamp if condition is satisfied
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POinsert datestamp if condition is satisfied
    text
    copied!<p>I would like to insert datetime stamp into a variable once the if-condition is satisfied. But I get the following error:</p> <blockquote> <p>Notice: Undefined index: status in C:\wamp\www\business\edit_log_widget.php on line 55</p> </blockquote> <p>The following is the php code:</p> <pre><code>&lt;?php include 'scripts/init.php'; include 'html/header.php'; $page = 'servers'; $id =$_SESSION['logid']; $query = "SELECT *FROM log WHERE logid = $id"; $query_submit = mysql_query($query) or die(mysql_error); $row = mysql_fetch_assoc($query_submit); ?&gt; &lt;div class="article"&gt; &lt;h2&gt;&lt;span&gt;Edit Logs&lt;/span&gt;&lt;/h2&gt; &lt;div class="clr"&gt;&lt;/div&gt; &lt;form action="" method="POST" &gt; &lt;p&gt; &lt;table border="0"&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="Task Name"&gt;Task Name:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="task_name" size="45" value="&lt;?php echo $row['task_name'] ?&gt;"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="description"&gt;Problem Description:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;textarea name="description" cols="33" rows="10" &gt;&lt;?php echo $row['description'] ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="solution"&gt;Solution Description:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;textarea name="solution" cols="33" rows="10" &gt;&lt;?php echo $row['solution'] ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="status"&gt;Status:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt; &lt;select id="Select2" name="status"&gt; &lt;option&gt;-Select-&lt;/option&gt; &lt;option&gt;Resolved&lt;/option&gt; &lt;option&gt;Un-resolved&lt;/option&gt; &lt;option&gt;In-Progress&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/p&gt; &lt;p&gt; &lt;td&gt;&lt;input id="Submit" type="submit" value="Submit" /&gt;&lt;/td&gt; &lt;td&gt;&lt;input id ="Clear and Restart" type ="reset" value= "Clear and Restart" /&gt;&lt;/td&gt; &lt;/p&gt; &lt;?php if($_POST['status']== 'Resolved') { $today = DateTime::createFromFormat('!Y-m-d',date('Y-m-d')); // This is Line 55 } if(isset($_GET['success']) &amp;&amp; empty($_GET['sucess'])) { echo 'the log has been captured'; } else { if(empty($_POST) === false &amp;&amp; empty($errors)=== true) { //Update Log details $update_log = array( 'task_name'=&gt;$_POST['task_name'], 'description' =&gt; $_POST['description'], 'solution' =&gt;$_POST['solution'], 'status'=&gt;$_POST['status'], 'closed_date'=&gt;$today, 'userid' =&gt;$_SESSION['userid']); update_log($update_log); //redirect header('Location: edit_log_widget.php?success'); exit(); } else if(empty($errors) === false) { //output errors if the errors array is not empty echo output($errors); } } ?&gt; &lt;/form&gt; &lt;?php include 'html/side_menu.php'; include 'html/footer.php'; ?&gt; </code></pre> <p>Update: edit_log.php.</p> <pre><code>&lt;?php include 'scripts/init.php'; include 'html/header.php'; $page = 'servers'; $id = $_GET['logid']; $_SESSION['logid'] = $id; $query = "SELECT *FROM log WHERE logid = $id"; $query_submit = mysql_query($query) or die(mysql_error); $row = mysql_fetch_assoc($query_submit); ?&gt; &lt;div class="article"&gt; &lt;h2&gt;&lt;span&gt;Edit Logs&lt;/span&gt;&lt;/h2&gt; &lt;div class="clr"&gt;&lt;/div&gt; &lt;form action="edit_log_widget.php" method="POST" &gt; &lt;p&gt; &lt;table border="0"&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="Task Name"&gt;Task Name:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;input type="text" name="task_name" size="45" value="&lt;?php echo $row['task_name'] ?&gt;"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="description"&gt;Problem Description:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;textarea name="description" cols="33" rows="10" &gt;&lt;?php echo $row['description'] ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="solution"&gt;Solution Description:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt;&lt;textarea name="solution" cols="33" rows="10" &gt;&lt;?php echo $row['solution'] ?&gt;&lt;/textarea&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td&gt;&lt;label for="status"&gt;Status:*&lt;/label&gt;&lt;/td&gt; &lt;td&gt; &lt;select id="Select2" name="status"&gt; &lt;option&gt;-Select-&lt;/option&gt; &lt;option value="Resolved"&gt;Resolved&lt;/option&gt; &lt;option value="Un-resolved"&gt;Un-resolved&lt;/option&gt; &lt;option value="In-Progress"&gt;In-Progress&lt;/option&gt; &lt;/select&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/p&gt; &lt;p&gt; &lt;td&gt;&lt;input id="Submit" type="submit" value="Submit" /&gt;&lt;/td&gt; &lt;td&gt;&lt;input id ="Clear and Restart" type ="reset" value= "Clear and Restart" /&gt;&lt;/td&gt; &lt;/p&gt; &lt;/form&gt; &lt;?php include 'html/side_menu.php'; include 'html/footer.php'; ?&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload