cmb Posted July 30, 2011 Share Posted July 30, 2011 i have set up a search of my database and now i want wen i click a result it to take me to a page were i can have the user edit the information this is my search code: <?php require('check_login.php'); echo "<a href=\"index.php\">Logout</a>"; echo "<span> </span>"; echo "<a href=\"s_home.php\">Home</a>"; ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-… <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Search</title> </head> <body> <center> <h2>Search </h2> <form action='./search.php' method='get'> <input type='text' name='k' size='50' value='<?php echo $_GET['k']; ?>' /> <input type='submit' value='Search'> </form> <hr /> <?php $k = $_GET['k']; $terms = explode(" ", $k); $query = "SELECT * FROM patients WHERE "; foreach ($terms as $each){ $i++; if ($i == 1) $query .= "Keyword LIKE '%$each%' "; else $query .= "OR Keyword LIKE '%$each%' "; } // connect mysql_connect("localhost", "root", "password"); mysql_select_db("hospital_patients")… $query = mysql_query($query); $numrows = mysql_num_rows($query); if ($numrows > 0){ while ($row = mysql_fetch_assoc($query)){ $id = $row['id']; $name = $row['First_Name']; $lname = $row['Last_Name']; echo "<h2><a href='modify.php'>$name, $lname</a></h2> "; } } else echo "No results found for \"<b>$k</b>\""; // disconnect mysql_close(); ?> </center> </body> </html> MOD EDIT: code tags added. Quote Link to comment https://forums.phpfreaks.com/topic/243251-update-database-help/ Share on other sites More sharing options...
Pikachu2000 Posted July 30, 2011 Share Posted July 30, 2011 When posting code, enclose it within the forum's . . . BBCode tags. Quote Link to comment https://forums.phpfreaks.com/topic/243251-update-database-help/#findComment-1249315 Share on other sites More sharing options...
chintansshah Posted July 30, 2011 Share Posted July 30, 2011 I think there is problem in action page, can you check where search.php located? if it is in same folder then write action="search.php" only or in parent folder then action = "../seach.php" or in different folder in parent folder then action = "../FOLDER_NAME/search.php" or in current folder with in a folder then action = "FOLDER_NAME/search.php" Quote Link to comment https://forums.phpfreaks.com/topic/243251-update-database-help/#findComment-1249342 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.