Return results from database in editable html text form with php

Question

EMP    |T_IN    |T_OUT    |ITEM    |NOTES
-----------------------------------------
Name 1 | time   | time    | break  | job1
Name 2 | time   | time    | break  | job2
Name 1 | time   | time    | office | 
Name 3 | time   | time    | fab    | job6

The above I need each item in each row column intersection to be displayed in an editable html textbox form for submission to the next step. Ive tried several things... all of which I have abandoned.

<!DOCTYPE html>
<html>
<body>

<form action="test.php" method="post">
Pay Range 
  <input type="date" name="start">
<input type="date" name="stop">
  <input type="submit">
</form>

</body>
</html>


<?php
if($_POST){
mysql_connect('localhost', 'user', 'Pass');
mysql_select_db('database');
$rt = mysql_query("SELECT * FROM TIME WHERE STAMP BETWEEN '". $_POST['start']."' AND '".$_POST['stop']."'");



while($data = mysql_fetch_array($rt)){

    $results .= $data['EMP'].", ".$data['T_IN'].", ".$_POST['T_OUT'].", ".$_POST['ITEM'].", ".$_POST['NOTE'];
echo $results."<br/>";
}
}




?>

UPDATED CODE:

<!DOCTYPE html>
<html>
<body>

<form action="test.php" method="post">
Pay Range 
  <input type="date" name="start">
<input type="date" name="stop">
  <input type="submit">
</form>

</body>
</html>

<?php
$servername = "localhost";
$username = "user";
$password = "Pass";
$dbname = "DB";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
} 

$sql = "SELECT * FROM TIME WHERE STAMP BETWEEN '". $_POST['start']."' AND '".$_POST['stop']."'";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // output data of each row
    while($row = $result->fetch_assoc()){
        echo "<input type="text" value=\"" . $row['EMP']. "\"> <br>";
    }
} else {
    echo "0 results";
}
$conn->close();
?>

@TomasK Ive deleted it all. But I ran it through a loop and tried several combinations... none of which worked. — Elegance
– Elegance, Commented Aug 31, 2015 at 15:26
Have you tried modifying code of answers like stackoverflow.com/q/13549605/4229630 ? — Tomas K
– Tomas K, Commented Aug 31, 2015 at 15:30

Tomas K · Accepted Answer · 2015-08-31 17:30:09Z

1

This will output all data from your MySql query

    <?php
    $servername = "localhost";
    $username = "username";
    $password = "password";
    $dbname = "myDB";

    // Create connection
    $conn = new mysqli($servername, $username, $password, $dbname);
    // Check connection
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    } 

    $sql = "SELECT id, firstname, lastname FROM MyGuests";
    $result = $conn->query($sql);?>
      <form action="test.php" method="post">
   <?php if ($result->num_rows > 0) {
        // output data of each row
        while($row = $result->fetch_assoc()){
    echo '<input type="text" name="myinput" value="' . $row["id"]. '"> <br>'
        }
    } else {
        echo "0 results";
    }
    $conn->close();
    ?>
       </form>

Snippet & more information at w3schools

edited Aug 31, 2015 at 17:30

answered Aug 31, 2015 at 15:43

Tomas K

3714 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Elegance Over a year ago

How do I place that information into text boxes so it can be edited and the changes submitted?

Elegance Over a year ago

Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log.

Elegance Over a year ago

I found the problem

'text' (T_STRING), expecting ',' or ';' in your code on line 20 echo "<input type="text" value=\"" . $row['EMP']. "\"> <br>";

Elegance Over a year ago

I used \ to exit the "

Elegance Over a year ago

if you will fix it arround type=\"text\" Ill give you the points :)

Collectives™ on Stack Overflow

Return results from database in editable html text form with php

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related