mysql_query($sql, $conn); $sql = SELECT listname FROM (Medical web site) ml_lists
mysql_query($sql, $conn); $sql = SELECT listname FROM ml_lists . WHERE ml_id= . $_POST[ ml_id ]; $result = mysql_query($sql, $conn); $row = mysql_fetch_array($result); $listname = $row[ listname ]; $url = http:// . $_SERVER[ HTTP_HOST ] . dirname($_SERVER[ PHP_SELF ]) . /user_transact.php?u= . $user_id . &ml= . $_POST[ ml_id ] . &action=confirm ; $subject = Mailing list confirmation ; $body = Hello . $_POST[ firstname ] . n . Our records indicate that you have subscribed to . the . $listname . mailing list.nn . If you did not subscribe, please accept our . apologies. You will not be subscribed if you do . not visit the confirmation URL.nn . If you subscribed, please confirm this by visiting . the following URL:n . $url; $mailmsg = new SimpleMail(); $mailmsg->send($_POST[ email ],$subject,$body,$headers); $redirect = thanks.php?u= . $user_id . &ml= . $_POST[ ml_id ] . &t=s ; break; case confirm : if (isset($_GET[ u ], $_GET[ ml ])) { $sql = UPDATE ml_subscriptions SET pending=0 . WHERE user_id= . $_GET[ u ] . AND ml_id= . $_GET[ ml ]; mysql_query($sql, $conn); $sql = SELECT listname FROM ml_lists . WHERE ml_id= . $_GET[ ml ]; $result = mysql_query($sql, $conn); $row = mysql_fetch_array($result); $listname = $row[ listname ]; $sql = SELECT * FROM ml_users . WHERE user_id= . $_GET[ u ] . ; $result = mysql_query($sql, $conn); $row = mysql_fetch_array($result); $firstname = $row[ firstname ]; $email = $row[ email ]; $url = http:// . $_SERVER[ HTTP_HOST ] . dirname($_SERVER[ PHP_SELF ]) . 500 Chapter 14
From our experience, we can recommend PHP Web Hosting services, if you need affordable webhost to host and run your web application.