adzie Posted October 15, 2007 Share Posted October 15, 2007 is it possible to convert this form to php? <h2>Search</h2> <form name="search" method="post" action="<?=$PHP_SELF?>"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="name">Name</option> <Option VALUE="pilot_num">Group</option> <Option VALUE="email">Email</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> <? //This is only displayed if they have submitted the form if ($searching =="yes") { echo "<h2>Results</h2><p>"; //If they did not enter a search term we give them an error if ($find == "") { echo "<p>You forgot to enter a search term"; exit; } // Otherwise we connect to our Database include("connectdb.php"); // We preform a bit of filtering $find = strtoupper($find); $find = strip_tags($find); $find = trim ($find); //Now we search for our search term, in the field the user specified $data = mysql_query("SELECT * FROM members WHERE upper($field) LIKE'%$find%'"); //And we display the results while($result = mysql_fetch_array( $data )) { echo $result['name']; echo " "; echo $result['Group']; echo "<br>"; echo $result['email']; echo "<br>"; echo "<br>"; } //This counts the number or results - and if there wasn't any it gives them a little message explaining that $anymatches=mysql_num_rows($data); if ($anymatches == 0) { echo "Sorry, but we can not find an entry to match your query<br><br>"; } //And we remind them what they searched for echo "<b>Searched For:</b> " .$find; } ?> Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2007 Share Posted October 15, 2007 It is php. Quote Link to comment Share on other sites More sharing options...
adzie Posted October 15, 2007 Author Share Posted October 15, 2007 what I mean is, the form to be in the php section of the script so it displays right in an existing script I'm using, anything not inside the <?Php ?> does not show correctly an example of a form which is in an existing script <td>".$Body."<strong>Name</strong></font></u></b></td><td><input type=\"text\" name=\"name\" value=\"".$row['2']."\"></td> Quote Link to comment Share on other sites More sharing options...
trq Posted October 15, 2007 Share Posted October 15, 2007 Well, the answer to your question is yes. Quote Link to comment Share on other sites More sharing options...
Barand Posted October 15, 2007 Share Posted October 15, 2007 do you mean like this? (using heredoc syntax) <?php echo <<<HTML <h2>Search</h2> <form name="search" method="post" action="{$_SERVER['PHP_SELF']}"> Seach for: <input type="text" name="find" /> in <Select NAME="field"> <Option VALUE="name">Name</option> <Option VALUE="pilot_num">Group</option> <Option VALUE="email">Email</option> </Select> <input type="hidden" name="searching" value="yes" /> <input type="submit" name="search" value="Search" /> </form> HTML; ?> Quote Link to comment Share on other sites More sharing options...
adzie Posted October 20, 2007 Author Share Posted October 20, 2007 thanks thorpe, can you give me a few lines as this is different to any php scripts i've done before. thanks Quote Link to comment Share on other sites More sharing options...
simcoweb Posted October 20, 2007 Share Posted October 20, 2007 That example you showed: <td>".$Body."<strong>Name</strong></font></td><td><input type=\"text\" name=\"name\" value=\"".$row['2']."\"></td> is for dynamically populating a form's fields. Not just displaying a form. Barand showed you how to display the form within your <?php ?> tags but not how to dynamically populate the fields. Is that what you're looking for? Quote Link to comment Share on other sites More sharing options...
adzie Posted October 20, 2007 Author Share Posted October 20, 2007 sorry as I may be confusing this more than is nessecary I have downloaded a management console, which works superb, what I wanted was to be able to search for record, unfortunatly the very first script appears above the management console page when displayed on web, the second code example, anything written like that appears fine Quote Link to comment Share on other sites More sharing options...
0x00 Posted October 20, 2007 Share Posted October 20, 2007 I'd use '$sret .= ' instead of 'echo', then you can print it wherever you want! Quote Link to comment Share on other sites More sharing options...
simcoweb Posted October 20, 2007 Share Posted October 20, 2007 Hmmm...ok, if i'm understanding correctly this 'management console' has somewhat of a broken page where the form displays where it shouldn't? And you want to move it to where it should display? Quote Link to comment Share on other sites More sharing options...
adzie Posted October 20, 2007 Author Share Posted October 20, 2007 yes sorry its taken this long, the other pages which i have been able to edit are written in the style of that small excert, the search scrip works but doesnt display right, i thought it was due to the coding. Quote Link to comment Share on other sites More sharing options...
adzie Posted October 22, 2007 Author Share Posted October 22, 2007 anyone have any suggestions? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.