There's something wrong with the $_GET since it won't echo (and it does on an earlier iteration) - I'll try and get that sorted and hopefully that will sort it out.
I have a search function on a site I'm building and would like to have it so that a user can click on a search result to see more columns from that row on the db, if you see what I mean. The best way seems to be to open a new page on which to display more detail on the chosen search result.
The problem is this - when I click through to the new page, all rows on the db are shown i.e. the search is made, result x is returned, click on x and in newpage.php x y and z (i.e. all rows) are displayed.
How do I structure things so that only x (and any other columns from row x that I choose) are displayed?
I'm thinking that I should be able to limit what it displayed with the SELECT but can't seem to find the right syntax to finish it off properly. Currently I have this on newpage.php
This is what I want my search/display files to do;
- user makes a search of a table on a database - one or more entries are returned - the results link to a file word2.php - if the user searches for the word 'example' s/he clicks on that result to be taken to word2.php. The table contains columns for the word ('word'), the type of word ('type') and a sentence showing its use ('sentence'). I would like word2.php to contain column entries for 'word' 'type' and 'sentence' that relate to the choice made by the user.
Hope that's clearer now.
From what you've said, I think SELECT in word2.php will need a WHERE clause.
In my site I have a search function but have hit on a problem that I can only partly solve.
A user makes a search - one or more results are returned. A user can click on an entry and view additional resources on a new page (word2.php) (that's the idea anyway!).
This is the search code;
// Set up our error check and result check array
$error = array();
$results = array();
// First check if a form was submitted.
// Since this is a search we will use $_GET
if (isset($_GET['search'])) {
$searchTerms = trim($_GET['search']);
$searchTerms = strip_tags($searchTerms); // remove any html/javascript.
if (strlen($searchTerms) < 1) {
$error[] = "Search terms must be longer than 1 character.";
}else {
$searchTermDB = mysql_real_escape_string($searchTerms); // prevent sql injection.
}
// If there are no errors, lets get the search going.
if (count($error) < 1) {
$searchSQL = "SELECT * FROM pro_words WHERE";
// grab the search types.
$types = array();
if (count($types) < 1)
$types[] = "`word` LIKE '%{$searchTermDB}%'";
$andOr = isset($_GET['matchall'])?'AND':'OR';
$searchSQL .= implode(" {$andOr} ", $types) . " ORDER BY `word`"; // order by word.
$searchResult = mysql_query($searchSQL) or trigger_error("There was an error.<br/>" . mysql_error() . "<br />SQL Was: {$searchSQL}");
if (mysql_num_rows($searchResult) < 1) {
$error[] = "Your search yielded no results. Sorry.";
}else {
$results = array(); // the result array
$i = 0;
while ($row = mysql_fetch_assoc($searchResult)) {
$results[] = "{$row['word']}<br />";
echo '<h2><tr><td align="left"><a href="word2.php?w=' . $row['word'] . '">' . $row['word'] …
<?php
session_start();
// check session variable
if (isset($_SESSION['first_name']))
{
include ('includes/header_loggedin.html');
//connect to mysql
$link = mysql_connect('localhost', 'zzz', 'xxx');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// access the required db
$db_selected = mysql_select_db('proguide', $link);
if (!$db_selected) {
die ('Can\'t use proguide : ' . mysql_error());
}
//specify type of search
$search=$_POST["search"];
//get the mysql and store them in $result
$result = mysql_query("SELECT word,sentence1 FROM pro_words WHERE word = '$word' LIKE '%$search%'");
//get the db content that is specified above
if (mysql_num_rows($result) < 1) {
echo "<br><br><h2>Oh dear. We didn't find anything. Sorry - we did look though.</h2>";
}else {
echo '<table align="center" cellspacing="8" cellpadding="8" width="85%"><tr><td align="left"><b>Word</b></td></tr>';
echo "<br><br><h3>This is what we found:</h3><br>";
while ($r=mysql_fetch_array($result, MYSQL_ASSOC))
echo '<tr><td align="left"><a href="word.php?w=' . $r['word'] . '">' . $r['word'] . '</a></td></tr>';
}
#$_GET["word"]=$r['word'];
#$_GET["sentence1"]=$r['sentence1'];
echo "Click on any word to use it.";
echo '</table>'; // Close the table.
}
else
{
echo '<h1><p>You are not logged in.</p></h1>';
echo '<h2><p>If you want to see this page, please register or log-in.</p></h2>';
echo '<a href="index.php">Take Me Back</a><br>';
echo '<a href="register.php">Register</a><br>';
}
echo '<br><a href="search.php">Search again?</a><br>';
?>
<?php
session_start();
if(isset($_SESSION['first_name']))
{
include ('includes/header_loggedin.html');
echo '<br><br><h3>You have chosen the word </h3><br>';
//insert word
echo $_GET['w'];
#print_r($_GET);
echo '<h3>Here are some examples of its modern use </h3>';
if (isset($_GET['w'])){ //show the next div only if there\'s GET parameter
echo '<div id="sentence1">This is the sentence : . $row['sentence1'] .</div>';
}
else
{
echo 'Content coming soon!';
}
echo '<h3>Use the player to listen and practice </h3>';
echo '<h3>Click on a sentence to listen to it. </h3>';
//insert player
echo '<h3>Listen to the instructions to get the most out of our player! </h3>';
//insert player with instructions
echo '<br><h2><a href="search.php">Back To Search</a><br></h2>';
// Check for an image name in the URL:
}else{
include ('includes/header.html');
echo '<h2><p>If you want to access this site, please register or log-in.</p></h2>';
}
?>
The only problem I have is that there are other entries from the database that I would like to include in word.php, up to 3 sentences and all of which link to audio material as well.
I was hoping there was an effective way to pull all those entries into word.php via searchdb.php. Can I put more than one array into the url constructed in searchdb.php?
<?php
session_start();
// check session variable
if (isset($_SESSION['first_name']))
{
include ('includes/header_loggedin.html');
//connect to mysql
$link = mysql_connect('xxxx', 'yyyyy', 'zzzzzz');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// access the required db
$db_selected = mysql_select_db('proguide', $link);
if (!$db_selected) {
die ('Can\'t use proguide : ' . mysql_error());
}
//specify type of search
$search=$_POST["search"];
//get the mysql and store them in $result
$result = mysql_query("SELECT word,sentence1 FROM pro_words WHERE word LIKE '%$search%'");
//get the db content that is specified above
if (mysql_num_rows($result) < 1) {
echo "<br><br><h2>Oh dear. We didn't find anything. Sorry - we did look though.</h2>";
}else {
echo '<table align="center" cellspacing="8" cellpadding="8" width="85%"><tr><td align="left"><b>Word</b></td></tr>';
echo "<br><br><h3>This is what we found:</h3><br>";
while ($r=mysql_fetch_array($result, MYSQLI_ASSOC))
echo '<tr><td align="left"><a href="word.php?w=' . $r['word'] . '">' . $r['word'] . '</a></td></tr>';
}
// session variable for word.php
$_SESSION["word"]=$r['word'];
echo "Click on any word to use it.";
echo '</table>'; // Close the table.
}
else
{
echo '<h1><p>You are not logged in.</p></h1>';
echo '<h2><p>If you want to see this page, please register or log-in.</p></h2>';
echo '<a href="index.php">Take Me Back</a><br>';
echo '<a href="register.php">Register</a><br>';
}
echo '<br><a href="search.php">Search again?</a><br>';
?>
So,
- the search is made - any results are returned - each result is displayed as a link to a new page that displays further information on the chosen search result. The bit in bold is what I can't get working
