Can this be done?

[ozzysworld]

Hi guys, a nice easy one for you now.

So at the moment I've got a FAQ section that requires me to manually create a new page for each question.

See it here http://www.bentinckfencing.co.uk/skiphire/useful_information.php

I've got my questions and answered stored like this

<?php
define('Q1','How big are your skips?');
define('Q1A','You can find a full list of our skip dimensions<ahref="hire_a_skip.php">HERE</a>');
?>

and at the moment i'm just outputting them onto their own individual page like this:

	<p class="heading"><?php echo Q1?> </p>
	<?php echo Q1A ?><br /> <br />

It's a pain in the ass creating a seperate page for each question so here's MY question:

How can I send Information to a php file via a clicked link, so that I can write a program to display the one they've click on?

At the moment I can do exactly what I want via this method:
but it requires a form.

	<?php 
	$choice = $_POST['choice'];

switch ($choice) {
	case "1": $answer ="<p class=\"heading\">Question: </p>" . Q1 . "<BR/><p class=\"heading\">Answer: </p>" . Q1A;
	break;
	case "2": $answer ="<p class=\"heading\">Question: </p>" . Q2 . "<BR/><p class=\"heading\">Answer: </p>" . Q2A;
	break;
	}
echo $answer;
?>

Can I create the same effect by catching what the user clicks? so that I don't have to have a page for every question?

Check this link to clarify what i'm talking about

http://www.bentinckfencing.co.uk/skiphire/useful_information.php

On the right hand side, I want to be able to create a page depending which question the user clicks..

Thanks in advance, I know it's a long one, but I'm sure there's an easy answer!

[ozzysworld]

Just an Update for anyone who might be having this same, very easy-to-solve easy.

I've figured it out by myself using this method:

I code my links like this:

	<a href="?choice=1"><?php echo Q1 ?> </a><hr>

And the PHP that receives it looks like this

	<?php //this function sets which question & Answer to display.

$choice = $_GET['choice'];	


	switch ($choice) {
			case "1": $answer = Q1A;
				$question = Q1;			
	break;
			case "2": $answer = Q2A;
				$question = Q2;			
	break;
			case "3": $answer = Q3A;
				$question = Q3;			
	break;
			case "4": $answer = Q1A;
				$question = Q4;			
	break;
			case "5": $answer = Q5A;
				$question = Q5;			
	break;
			case "6": $answer = Q6A;
				$question = Q6;			
	break;
			case "7": $answer = Q7A;
				$question = Q7;			
	break;
			case "8": $answer = Q8A;
				$question = Q8;			
	break;
			case "9": $answer = Q9A;
				$question = Q9;			
	break;
			case "10": $answer = Q10A;
				$question = Q10;			
	break;
			case "11": $answer = Q11A;
				$question = Q11;			
	break;
			case "12": $answer = Q12A;
				$question = Q12;			
	break;
			case "13": $answer = Q13A;
				$question = Q13;			
	break;

	}
	$answeroutput ="<p class=\"heading\">Question: </p>" . $question . 
	"<BR/><p class=\"heading\">Answer: </p>" . $answer . "<br /><br /><hr width=\"100%\"";

	echo $answeroutput;

And to make all this work I have all my FAQ Questions and answered stored as follows in a separate file:

<?php
// FAQ Questions and Answeres
define('Q1','How big are your skips?');
define('Q1A','You can find a full list of our skip dimensions <a href="hire_a_skip.php">HERE</a>');

Finally I link to the PHP code inside the page where I want my Question and Answers to display using this :

	<?php 

include_once('includes/function1.php');

?>

That's it. It makes it look very snazzy and dynamic as the new question & answers appear to loads instantly into the same page.

If any PHP guru out there could suggest any improvements on my ideas, or ways of further shortening the workload, I'd be most happy to hear them 🙂

[djjjozsi]

fill these questions and answers in database, and you can make text search on the inputed data...

i've got a little details page code 🙂

download JS: JS files

mysql dump:

CREATE TABLE `faq` (
`faqid` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`q` VARCHAR( 255 ) CHARACTER SET latin2 COLLATE latin2_hungarian_ci NOT NULL,
`a` VARCHAR( 255 ) CHARACTER SET latin2 COLLATE latin2_hungarian_ci NOT NULL
) ENGINE = MYISAM  CHARACTER SET latin2 COLLATE latin2_hungarian_ci;

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Select from 'faq' table</title>
<?php
/* http://phpcode.hu/teszt/details/ */

$hostname=''; //// specify host, i.e. 'localhost'
$user='***********'; //// specify username
$pass='***********'; //// specify password
$dbase=''; //// specify database name
$connection = mysql_connect("$hostname" , "$user" , "$pass")
or die ("Can't connect to MySQL");
$db = mysql_select_db($dbase , $connection) or die ("Can't select database.");
mysql_query( "SET NAMES utf8" ); // állatsd latin2 -re ha olyan karakterkódolást használsz
$sql='select * from faq';
$res=mysql_query($sql) OR DIE(mysql_error());
while($a=mysql_fetch_assoc($res))
$data[]=$a;

?>
<script type="text/javascript" src="jquery.min.js"></script>
<script type="text/javascript" src="animatedcollapse.js">

/***********************************************
* Animated Collapsible DIV v2.4- (c) Dynamic Drive DHTML code library (www.dynamicdrive.com)
* This notice MUST stay intact for legal use
* Visit Dynamic Drive at http://www.dynamicdrive.com/ for this script and 100s more
***********************************************/
</script>

<script type="text/javascript">
<?php
foreach($data AS $v)
{
echo "animatedcollapse.addDiv('data{$v["faqid"]}', '')\n";
}
?>
animatedcollapse.init()
</script>

</head>
<body>

<?php
foreach($data AS $k)
{
    echo "{$k["q"]}<br />";
    echo "<a href=\"javascript:animatedcollapse.toggle('data{$k["faqid"]}')\">see the answer</a> ";
    echo '<div id="data'.$k["faqid"].'" style="width: 300px; background: #FFFFCC; display:none">';
    echo "{$k["a"]}<br />";
    echo '</div><br />';
}
?>

</body>
</html> 

[ozzysworld]

Hey man, Thanks alot for the reply.

I understand your answer would provide the PERFECT solution. But there won't ever be more than 20 questions, so for now I'm happy to use my solution. Mainly because it doesn't require me to access any of my databases and is a nifty little way of 'looking' dynamic without the database.

Thanks again, I'm about to create a Testimonials section too but I'm thinking more along your route for that!

[djjjozsi]

its ok 🙂

Arrays?

<?php

$site[] = array( "1 question" , "Answer for Q1" );
$site[] = array( "2 question" , "Answer for Q2" );
$site[] = array( "3 question" , "Answer for Q3" );
// list them out:
if ( isset( $_GET["q"] ) ) {
    if ( !empty( $site[$_GET["q"]] ) ) {
        echo $site[$_GET["q"]][0] . ":<br />";
        echo $site[$_GET["q"]][1] . ":<br />";
    } else {
        echo "removed answer!";
    }
    echo "<a href=\"faq.php\"> back </a>";
} else
    foreach( $site AS $r => $k ) {
    echo "<a href=\"?q=$r\">$k[0]</a><br />";
}

?>

[ozzysworld]

I've tried your code, and it would've certainly saved me some time/effort had I done it like that originally. ( I am fairly new to PHP )

While we're on, my testimonials are going to be just shown in a small box, that displays random entries each page visit.

I've come up with this so far:

<?php //
$test = array (
	'Margery Doors: We Thought your service was fantastic!, Thank You',	
	'Shane Osbourne : Not bad',
	'Spike : bad service',
	'Allan : Good Service',
	'Fred : Fantastic' ,);

$rand_keys = array_rand($test, 2);
echo $test[$rand_keys[0]] . "\n";
?>

It seems to do the trick, but ideally I wanted to have Names, Dates, and Messages to be accessible by separate variables.

I managed it with arrays nested inside other arrays, but I couldn't randomise it.

Any Idea?

[djjjozsi]

Solve it with database 🙂

maybe this helps:

<?php
$contents = "Margery Doors|We Thought your service was fantastic!, Thank You|234234234
Margery Doors|We Thought your service was fantastic!, Thank You|23444234
Shane Osbourne|Not bad|347
Spike|bad service|239874
Allan|Good Service|23468
Fred|Fantastic'|4";

$c = explode( "\r" , $contents );
foreach( $c AS $rows )
$data[] = explode( "|", trim( $rows ) );

$rand_keys = array_rand( $data, 2 );

foreach( $rand_keys AS $keys ) {
    echo $data[$keys][0] . $data[$keys][1] . $data[$keys][2] . "<br />";
} 

?>