vivification

Thank you so much aysiu!! that's perfect. Thank you also hitman.

Thanks hitman, but can you show me how I enter it on my code? I dont understand how I need to enter/display it in my code. Are they both on the same line? i.e. while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td><a href='edit--report.php?id=" . $row['ID'] . "' >" . $row['ID'] . "</a></td>"; echo "<td>" . $date = new DateTime($row['etd']); print $date->format('d-m-Y') "</td>"; echo "</tr>"; } echo "</table>";

Hi there, I am still new to PHP and having trouble trying to format a date. When the form data is saved; it is saved as YYYY-MM-DD. Then, when you view a page to display all the records, it shows as YYYY-MM-DD. I want to convert it to show DD-MM-YYYY. The field name is "ETD" and "ETA". Can I just use: echo date("Y/m/d") ? If so, how do I use it in the below scenario. Would it be: echo "<td>" . $row['etd']date("Y/m/d") . "</td>"; while($row = mysql_fetch_array($result)) { echo "<tr>"; echo "<td><a href='edit--report.php?id=" . $row['ID'] . "' >" . $row['ID'] . "</a></td>"; echo "<td>" . $row['etd'] . "</td>"; echo "<td>" . $row['eta'] . "</td>"; echo "</tr>"; } echo "</table>"; //mysqli_close($con); ?> Would appreciate any help! Thanks,

Hi requinix, Thanks, I get what you are saying, but I still dont follow how I 'dont' store the username. How does the username from the "staff" table (that is used for login.php), get captured and then saved on the "dispatch" table (dispatch.php) when the form is created & posted/submitted? If you could give me an example - as I am only new to PHP so trying to understand the way that it needs to be created/written.

Hi Davidannis, Thanks for those details, below is the code I am using for my login.php I have just constructed this via some online demos & templates etc. So at the top of this, I am changing it to: <?php session_start(); Then... // Connects to your Database etc, etc. <?php // Connects to your Database mysql_connect("localhost", "root", "password") or die(mysql_error()); mysql_select_db("dispatch") or die(mysql_error()); //Checks if there is a login cookie if(isset($_COOKIE['ID_my_site'])) //if there is, it logs you in and directes you to the members page { $username = $_COOKIE['ID_my_site']; $pass = $_COOKIE['Key_my_site']; $check = mysql_query("SELECT * FROM users WHERE username = '$username'")or die(mysql_error()); while($info = mysql_fetch_array( $check )) { if ($pass != $info['password']) { } else { header("Location: functions.php"); } } } //if the login form is submitted if (isset($_POST['submit'])) { // if form has been submitted // makes sure they filled it in if(!$_POST['username'] | !$_POST['pass']) { die('You did not fill in a required field.'); } // checks it against the database if (!get_magic_quotes_gpc()) { $_POST['email'] = addslashes($_POST['email']); } $check = mysql_query("SELECT * FROM users WHERE username = '".$_POST['username']."'")or die(mysql_error()); //Gives error if user dosen't exist $check2 = mysql_num_rows($check); if ($check2 == 0) { die('That user does not exist in our database. <a href=add.php>Click Here to Register</a>'); } while($info = mysql_fetch_array( $check )) { $_POST['pass'] = stripslashes($_POST['pass']); $info['password'] = stripslashes($info['password']); $_POST['pass'] = md5($_POST['pass']); //gives error if the password is wrong if ($_POST['pass'] != $info['password']) { die('Incorrect password, please try again.'); } else { // if login is ok then we add a cookie $_POST['username'] = stripslashes($_POST['username']); $hour = time() + 3600; setcookie(ID_my_site, $_POST['username'], $hour); setcookie(Key_my_site, $_POST['pass'], $hour); //then redirect them to the members area header("Location: functions.php"); } } } else { // if they are not logged in ?> For the second part, that you mentioned, $_SESSION['username']=$variable_you_stored_username_in ; 1) Is this going on the same page as login.php 2) Can you just explain the ['username']=$variable_you_stored_username_in ; part? 3) When you say "after the user is verified" I assume you mean put this on the page that is entering the form data? Because once the user logs in via login.php they go to a "Menu" page which gives them the options to choose from (e.g. Dispatch, Reports etc)

Can you give me an example of how I can do that? I think I understand what you mean, but are you saying add a field on my form for the user to enter their username? Not sure I follow. Does the "staff" table still exist and used to verify the login?

Hi there, I am new to PHP, and can create basic login forms, and INSERT into mysql forms etc all OK. However I am trying to understand how to create a form that shows the username of the person that entered the data. For example, I have a table called staff and a table called dispatch User: "Mary" logs in via the form login OK. (this is verified from the staff table) She then logs into the next section of the form, and enters some data in (which will be added to the dispatch table). When she adds the data in, I want to be able to show the Username of the person logged in that added this data. Would appreciate any help! Thanks