html - PHP call is not returning all of the values -


i trying use php access database created , load text boxes. currently, code below loads list of text boxes , populates 'name' field, loads empty text boxes other sections.

i have made sure $row['query'] parameters correct.
here seeing:

screenshot of html

    $sql = "select * salesmen";     $stmt = $conn->query($sql);      echo '<table border="0">';     echo '<tr>         <td align="center">name</td>         <td align="center">user id</td>         <td align="center">password</td>         <td align="center">commission</td>         <td align="center">address</td>     </tr>';      while($row = $stmt->fetch(pdo::fetch_assoc))     {         echo '<tr>';         echo '<td><input type="text" name="name" value="' .$row['name']. '"></td>';         echo '<td><input type="text" name="id" value"' .$row['id']. '"></td>';         echo '<td><input type="text" name="password" value"' .$row['password']. '"></td>';         echo '<td><input type="text" naem="commission" value"' .$row['commission']. '"></td>';         echo '<td><input type="text" name="address" value"' .$row['address']. '"></td>';         echo '</tr>';     }     echo '</table>' 

you missing = sign on of other 4 columns, , name misspelled on commission column(thanks fred)!

echo '<td><input type="text" name="id" value="' .$row['id']. '"></td>'; echo '<td><input type="text" name="password" value="' .$row['password']. '"></td>'; echo '<td><input type="text" name="commission" value="' .$row['commission']. '"></td>'; echo '<td><input type="text" name="address" value="' .$row['address']. '"></td>'; 

you missed semi-colon echo '</table>'


Comments

Popular posts from this blog

python - pip install -U PySide error -

arrays - C++ error: a brace-enclosed initializer is not allowed here before ‘{’ token -

cytoscape.js - How to add nodes to Dagre layout with Cytoscape -