I can’t view the database content on a php page [closed]

by

I have made an example how it could look with PDO (as i see you are just starting and i suggest to learn PDO as its not that hard)
This way you also are safe from SQL injections.

$host="127.0.0.1";
$db   = 'test';
$user="root";
$pass="";
$charset="utf8mb4";

$usid = 0;
$docname="";

$dsn = "mysql:host=$host;dbname=$db;charset=$charset";
$options = [
    PDO::ATTR_ERRMODE            => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    PDO::ATTR_EMULATE_PREPARES   => false,
];
try {
     $pdo = new PDO($dsn, $user, $pass, $options);
} catch (\PDOException $e) {
     throw new \PDOException($e->getMessage(), (int)$e->getCode());
}

$stmt = $pdo->query("SELECT * FROM users WHERE id=?");
$stmt->execute([$usid]); 

$row = $stmt->fetch();
$docname = $row['docname'];

echo '
<div class="form-group">
  <input type="text" class="form-input" name="docname" id="name" placeholder="Your Name" value="'.$docname.'" />
</div>';

P.S. I have not tested it so fill your details and give it a try!

Here is really good website to learn all about PDO: https://phpdelusions.net/pdo

More Related Contents:

  1. Use PHP to render multiple images to the browser [closed]
  2. How to prevent duplicate usernames when people register?
  3. MySQL connection not working: 2002 No such file or directory
  4. Sum values of multidimensional array by key without loop
  5. Get sum of MySQL column in PHP
  6. mysqli: can it prepare multiple queries in one statement?
  7. Laravel 5 PDOException Could Not Find Driver
  8. Escaping MySQL wild cards
  9. Import CSV file directly into MySQL
  10. Storing and displaying unicode string (हिन्दी) using PHP and MySQL
  11. Using MySQLi from another class in PHP
  12. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  13. Increment value in MySQL update query
  14. Php – Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  15. What is the advantage of using try {} catch {} versus if {} else {}
  16. Javascript function post and call php script
  17. while ($row = mysql_fetch_array($result)) – how many loops are being performed?
  18. Trying to access array offset on value of type bool
  19. onbeforeprint() and onafterprint() equivalent for non IE browsers
  20. How to get a query error from prepare() in PDO PHP?
  21. Fatal error: Call to a member function query() on null
  22. MySQL GROUP BY and Fill Empty Rows
  23. mysql injection damages?
  24. PHP PDO how to run a multiple query request?
  25. How can I do a migration in laravel 5.5?
  26. Best way to store IP in database?
  27. Which is fastest in PHP- MySQL or MySQLi?
  28. How to get last inserted id from table MySQL [duplicate]
  29. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  30. find in set in laravel ? example

Leave a Comment