I am trying to use pdo to update a database, the code is not returning any errors but the code does not work.
Logic is the user would enter in user id and then a new location hit submit and the location would be updated.

Here is the form code

 <html> <head> <title>Web Dev 1</title> </head> <body> <form method="post" action="update.php">

    Patient location by ID: <input type="text" id="Patid" name="Patid" /><br />
    Location: <input type="text" id="Location" name="Location" /><br /> <input type="submit" name = 'action' value="update" /> </html>

This is the update

 $host = "localhost";
 $user ="sbuser";
 $db = "mdb";
 $pass ="lamepassword";

 $conn = new PDO($dsn, $user, $password);

  $sqlInsert = 'UPDATE lobby set Location=:Location where Patid=:Patid';
 $preparedStatement = $conn->prepare($sqlInsert);
  $preparedStatement->execute(array(':Patid' => '$_POST[Patid]', ':Location' = $_POST[Location]' );


Recommended Answers

All 2 Replies

some syntex error in your code...

add this code check it again

 $host = "localhost";
 $db = "mdb";
 $user ="sbuser";
 $pass ="";
 $conn = new PDO("mysql:host=$host;name=$name",$user,$pass);
    $sqlInsert = "UPDATE lobby SET Location=? WHERE Patid=?";
    $preparedStatement = $conn->prepare($sqlInsert);
    $preparedStatement->execute(array($Location, $Patid));


Thanks, that helped!!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.