Location: PHPKode > projects > TherapyDoc > therapydoc_1.3.1_3/view/physician/edit_physician.php
<?php
require_once "connect.inc";
include('globals.inc');

$sql="UPDATE `tbl_physician` SET fname=:fname,lname=:lname,add1=:add1,add2=:add2,city=:city,state=:state,zip=:zip,phone=:phone,fax=:fax,email=:email,specialty_id=:specialty_id WHERE physician_id=:physician_id";
$stmt = $dbh->prepare($sql);
$stmt->bindParam(':fname', $_POST['fname']);
$stmt->bindParam(':lname', $_POST['lname']);
$stmt->bindParam(':add1', $_POST['add1']);
$stmt->bindParam(':add2', $_POST['add2']);
$stmt->bindParam(':city', $_POST['city']);
$stmt->bindParam(':state', $_POST['state']);
$stmt->bindParam(':zip', $_POST['zip']);
$stmt->bindParam(':phone', $_POST['phone']);
$stmt->bindParam(':fax', $_POST['fax']);
$stmt->bindParam(':email', $_POST['email']);
$stmt->bindParam(':specialty_id', $_POST['specialty_id']);
$stmt->bindParam(':physician_id', $_POST['physician_id']);
$stmt->execute();
$dbh=NULL;

?>
<META
	HTTP-EQUIV="refresh"
	content="0;URL=edit_form.php?physician_id=<?php echo $_POST['physician_id']; ?>">
Return current item: TherapyDoc