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. 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. 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" Link to comment https://forums.phpfreaks.com/topic/243251-update-database-help/#findComment-1249342 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.