I've recently begun learning PHP. I'm using it in a file called add.php for displaying a log-in form with a few fields. When viewed and run in Dreamweaver, the PHP displays in design view and executes properly when run using the testing server. But when this page is included (and the form is placed inside a div and styled with CSS to appear in the header) of a Dreamweaver template file, the PHP appears as I expect it to in design view, but when I switch to Live View or when I run the page through the testing server nothing happens. The PHP does not appear to be recognized. Can someone tell me why the PHP in this page works when run independently, but not when included in my site? I assume I included it properly, else I wouldn't see it at all. I tried saving the template as a web page - both with an html and php suffix, but the result is the same. Here is the code as it appears in the external page that is included. (If you're wondering why I've disabled the pw encrypting, that's until I learn how to do that properly.)
<?php // Connects to your Databasemysql_connect("localhost", "my_username", "my_password") or die(mysql_error());mysql_select_db("my_database") or die(mysql_error()); //This code runs if the form has been submittedif (isset($_POST['submit'])) { //This makes sure they did not leave any fields blankif (!$_POST['username'] | !$_POST['pass'] | !$_POST['pass2'] ) { die('You did not complete all of the required fields'); }// checks if the username is in use if (!get_magic_quotes_gpc()) { $_POST['username'] = addslashes($_POST['username']); }$usercheck = $_POST['username'];$check = mysql_query("SELECT username FROM clients WHERE username = '$usercheck'")or die(mysql_error());$check2 = mysql_num_rows($check); //if the name exists it gives an errorif ($check2 != 0) { die('Sorry, the username '.$_POST['username'].' is already in use.'); }// this makes sure both passwords entered match if ($_POST['pass'] != $_POST['pass2']) { die('Your passwords did not match. '); } // here we encrypt the password and add slashes if needed // $_POST['pass'] = md5($_POST['pass']); if (!get_magic_quotes_gpc()) { $_POST['pass'] = addslashes($_POST['pass']); $_POST['username'] = addslashes($_POST['username']); } // now we insert it into the database $insert = "INSERT INTO clients (username, password) VALUES ('".$_POST['username']."', '".$_POST['pass']."')"; $add_member = mysql_query($insert); ?><p>Registered - you may now log in</a>.</p><?php}else{?><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"><table border="0"><tr><td>Username:</td><td><input type="text" name="username" maxlength="60"></td></tr><tr><td>Password:</td><td><input type="password" name="pass" maxlength="10"></td></tr><tr><td>Confirm:</td><td><input type="password" name="pass2" maxlength="10"></td></tr><tr><th colspan=2><input type="submit" name="submit"value="Register"></th></tr> </table></form><?php}?>