Geek Answers Handbook

Php form does not update database

I am trying to use pdo to update the database, the code does not return any errors, but the code does not work. The logic is that the user enters the user ID and then sends a new location, and the location will 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 code:

 <?php error_reporting(E_ALL); ini_set('display_errors',1); $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]' ); } ?>
+5
source share
1 answer

There is some error in your code.

 <?php $host = "localhost"; $db = "mdb"; $user ="sbuser"; $pass =""; $Patid=$_POST['Patid']; $Location=$_POST['Location']; $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)); ?>
+2
source

More articles:


All Articles