new to php - please help

[Joanne_08]

Hi there,

I feel so stupid asking this as its prob very simple.

I am just trying to get some information from my database to display when you click a cerain option.

One the first page I have asubmit button:
<!--submit button -->
<td><form action="<?= $php_SELF ?>" method="POST">
</form><h5>navigation &amp; search</h5></label>
<?php function course_name () {} ?>
<?php function course_date () {} ?>
<input name="course_name" type="submit" onclick="MM_goToURL('parent','individual_course_info2.php');return document.MM_returnValue" value="submit" />

Then on the second page (when a user selects the submit button for the navigation&seach course) it should display the available options:

<!-- connect to the database -->
<?php

$con = mysql_connect("localhost","root","joanne");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("training", $con);

// perform the SQL query
function submit($query)
{}
function course_name($course_name)
{}
if(isset($course_name))
submit($query);

$course_name= "navigation & search";

$query = "select course_name, course_date from trainee_courses where course_name= '$course_name' ";

if(mysql_num_rows($query) > 0)
{
$course_name = mysql_result($query,$i, "course_name");
$course_date = mysql_result($query,$i, "course_date");

  echo $course_name."<---- Trainee Course";
 echo $course_date."<----  Course Date";

for($i=0; $i<mysql_num_rows($query); $i++)

else
echo "SORRY THERE AIN'T NO DATA BOY!!";
}

{
or die(mysql_error());
}
?>

PLEEEAASSSEEE help me

Thanks 🙂 😕 😕

[kbc1]

Seems to me that the first page is not doing anything apart from directing the user to the second page - is this correct? Or should it have a load of links from individual courses which when clicked, take you to the information about that selected item?

If so, you could use $_GET to pass the ID of the database value through to Page 2 and then you could have this code:

	$course_name	=	$_GET['course_name'];

$sqlquery = "select course_name, course_date from trainee_courses where course_name= '$course_name' ";
$dataresult = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($dataresult)) {
	$coursename = stripslashes($datarow['course_name']);
	$coursedate = $datarow['course_date'];

	echo "Course Name: $coursename<br />Course Date: $coursedate<br />";
}
mysql_free_result($dataresult);

You will need to format your date however you want and obviously the outputting of the data is down to you, but that should sort it.

[Joanne_08]

Yes - thats right 🙂 thats how I want it to work! Thank you.

so when im using the GET statement would I put this in the first page - where the links are?
and then put the other code (sql) in the second page?

cheers

[kbc1]

*EDITED: I have made a mistake, the GET should be as I have edited below***

And also change to this on Page 1:

$course_id    =    $_GET['course_id'];

$sqlquery = "select course_name, course_date from trainee_courses where course_id= '$course_id' ";

Correct - to some extent!

Your first page will have something like this:

// get all records from the database
$sqlquery = "select course_name, course_id from trainee_courses";
    $dataresult = mysql_query($sqlquery);
    while ($datarow = mysql_fetch_array($dataresult)) {
        $coursename = stripslashes($datarow['course_name']);
        $courseid = $datarow['course_id'];

    echo "<p><a href=\"page2.php?course_id=$courseid\" title=\"Click to read more on $coursename\">$coursename</a></p>";
}
mysql_free_result($dataresult); 

That should list all items in your database (with a bit of tweaking) and you can see that they should all be hyper links to 'page2.php'. When you click it, page2.php should load.

On Page 2 use the code I posted earlier and that should display the details. If you are only displaying one record on page2.php then you can change the query to not be in a loop (cos you'll only ever have one record) but thats by the by - the code will still work for what you need.

[Joanne_08]

Thanks for all your help :o

Just one last thing - The pages are working fine now, no errors 🙂
but the information which is in my db table does not display- do I have to specify which table I am using?

Cheers.

[halojoy]

<!--submit button -->
<td>
<form action="<?= $php_SELF ?>" method="POST">
</form>

<h5>navigation &amp; search</h5></label>

Let's take it from the start.
Because if start is not right,
then it does not matter what rest is like. Does it?

1. you have a <form></form> .... with no input at all
2. action="<?= $php_SELF ?>"

Can this be a problem.
I would say: YES.

Think you have to take step by step, line by line,
do some thinking and ask for more support, when it eventually should not work.
Good Luck! 🙂

I normally use this way, like:

<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="POST">

Label1: <input something>
Label2: <input something>
<input type="submit">

</form><!-- end of form -->

regars 🙂
halojoy

[kbc1]

The query itself states which table to select information from:

$sqlquery = "select course_name, course_id from trainee_courses";

As you can see you are selecting data from trainee_courses.

Have you got your database connection running OK?

Page one should look something like this:

$con = mysql_connect("localhost","root","joanne");
if (!$con){
die('Could not connect: ' . mysql_error());
}
mysql_select_db("training", $con);


// get all records from the database
$sqlquery = "select course_name, course_id from trainee_courses";
    $dataresult = mysql_query($sqlquery);
    while ($datarow = mysql_fetch_array($dataresult)) {
        $coursename = stripslashes($datarow['course_name']);
        $courseid = $datarow['course_id'];

    echo "<p><a href=\"page2.php?course_id=$courseid\" title=\"Click to read more on $coursename\">$coursename</a></p>";
}
mysql_free_result($dataresult); 

I guessed that you would have an ID record for your database records so make sure the field names in the query match your table structure.

When this page is processed via the browser, you should get a list of items from your database or some errors.

Page 2 should look like this:

$con = mysql_connect("localhost","root","joanne");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("training", $con);


$course_id    =    $_GET['course_id'];

$sqlquery = "select course_name, course_date from trainee_courses where course_id= '$course_id' ";
$dataresult = mysql_query($sqlquery);
while ($datarow = mysql_fetch_array($dataresult)) {
    $coursename = stripslashes($datarow['course_name']);
    $coursedate = $datarow['course_date'];

    echo "Course Name: $coursename<br />Course Date: $coursedate<br />";
}
mysql_free_result($dataresult);

This should return the information for the item you clicked on Page 1. Again you need to make sure that the query is changed to match your table structure.

That should be enough to get you up and running and you can go on to extend it as you wish.

Good luck