Storing radio button values and display "read by" text on page

[bulldog317]

I have a page entitled view.php that will display information depending on $id. I am going to place a list of names with a radio button beside each name with an OK button for the user viewing the page to acknowledge they have read the information at the bottom of this page.

My first question is what is the best way to post this to my database? Can one field be set up to collect the multiple names or do I have to create a separate table containing the names and if so, what is the best way to tie the information together? There will be approximately 10 users who will view the information.

And my second question is after the user presses OK and that name placed in the database, I want the same page (view.php) to be updated to display something along the lines of "$user read this information on $date at $time" for each user who clicks the radio button beside their name and presses OK.

[kevinsequeira]

can u post any code that you might have written for view.php ??

reg
kevin

[bulldog317]

Sure. Here is the view.php page (I have not added the radio buttons yet and have not finalized the layout of the information but everything else is good to go) :

<?php
include ("include/header.inc.php");

include ("include/dbconnect.php");

if ($id) {

   $result = mysql_query("SELECT * FROM $table WHERE id=$id",$db);

   $links = mysql_fetch_array($result);

   $id = $links["id"];
   $staff = $links["staff"];
   $cnum = $links["cnum"];
   $atty = $links["atty"];
   $opend = $links["opend"];
   $cname = $links["cname"];
   $client = $links["client"];

   if(strlen($links["contact"]))
        $contact.=$links["contact"];

   if(strlen($links["ref"]))
        $ref.=$links["ref"];

   if(strlen($links["other"]))
        $other.=$links["other"];

   if(strlen($links["court"]))
        $court.=$links["court"];

   if(strlen($links["docket"]))
        $docket.=$links["docket"];

   if(strlen($links["jury"]))
        $jury.=$links["jury"];

   if(strlen($links["compfile"]))
        $compfile.=$links["compfile"];

   if(strlen($links["compserv"]))
        $compserv.=$links["compserv"];

   if(strlen($links["ansdue"]))
        $ansdue.=$links["ansdue"];

   if(strlen($links["eoa"]))
        $eoa.=$links["eoa"];

   if(strlen($links["part"]))
        $part.=$links["part"];

   if(strlen($links["assoc"]))
        $assoc.=$links["assoc"];

   if(strlen($links["comments"]))
        $comments.=$links["comments"];


echo "<table width='800'>";
    echo "<tr><td width='150'><b>Prepared by</b>:</td><td width='650'>$staff</td></tr>";
echo "<tr><td width='150'><b>Case No.</b>:</td><td width='650'>$cnum</td></tr>";
echo "<tr><td width='150'><b>Attorney</b>:</td><td width='650'>$atty</td></tr>";
echo "<tr><td width='150'><b>Date Opened</b>:</td><td width='650'>$opend</td></tr>";
echo "<tr><td width='150'>Case Style:</td><td width='650'><i><u>$cname</u></i></td></tr>";
echo "<tr><td width='150'>Client:</td><td width='650'>$client</td></tr>";
echo "<tr><td width='150'>Contact:</td><td width='650'>$contact</td></tr>";
echo "<tr><td width='150'>Clief Ref. No.:</td><td width='650'>$ref</td></tr></table>";
echo "<table width='800'>";
echo "<tr><td width='800'><b>Other Parties / Counsel</b>:</td></tr>";
echo "<tr><td width='800'>$other</td></tr></table>";
echo "<table width='800'>";
echo "<tr><td width='150'>Court:</td><td width='650'>$court</td></tr>";
echo "<tr><td width='150'>Docket No.:</td><td width='650'>$docket</td></tr>";
echo "<tr><td width='150'>Jury Demand:</td><td width='650'>$jury</td></tr>";
echo "<tr><td width='150'>Date Complaint Filed:</td><td width='650'>$compfile</td></tr>";
echo "<tr><td width='150'>Date Complaint Served:</td><td width='650'>$compserv</td></tr>";
echo "<tr><td width='150'>Date Answer Due:</td><td width='650'>$ansdue</td></tr>";
echo "<tr><td width='150'>Entry of Appearance:</td><td width='650'>$eoa</td></tr>";
echo "<tr><td width='150'>Partner Rate:</td><td width='650'>$part</td></tr>";
echo "<tr><td width='150'>Associate Rate:</td><td width='650'>$assoc</td></tr></table>";
echo "<table width='800'>";
echo "<tr><td width='150'><b>Comments</b>:</td></tr>";
echo "<tr><td width='800'>$comments</td></tr>";


} else {

echo "You need to select an ID number of a data entry";

}

include ("include/footer.inc.php");

?>

<html>
<head><title></title></head>
<body><br><br>
HERE IS WHERE I WILL ADD THE RADIO BUTTONS


</body></html>

[kevinsequeira]

correct me if im wrong ..

1. on the html page where the radio button are going to be generated, the users are taken from another table right, so the $id in the view.php is the case id not the id of the user who is going to view the page.
2. if that is so, how are you getting the case id on the html form page where the radio buttos are placed??
3. can each user goto to view.php more than once so that the time he saw view.php can get updated more than once ???

reg
kevin

[bulldog317]

kevin-

To clarify, the view.php page will be the page that contains the radio buttons at the bottom in the HTML section of the page (if this can be done). I apologize as I am unsure what can be done exactly and I guess that is why I am asking these questions.

1) the $id in view.php is the id automatically assigned when the user filled out a form and the information posted to a table in my database. I think this is what you are referring to when you say case id. I do not currently have a table containing users because I want to make sure I do it correctly and am unsure how to store this information. Do I need a separate table containing the users? And if so, how do I tie that table in with my already existing table which stores the case data when the user fills out a form.

2) you actually helped me on this yesterday with the automatic e-mailing of a link after the user filled out a form, it was posted to the database and then a link sent. The user will be pulling up view.php?id=XX from clicking on a link they receive in an e-mail. I am assuming that by placing radio buttons at the bottom of the main view.php page, the values of the users clicking their radio buttons would be posted to whatever case is displayed according to the XX. I am be incorrect which is what I am trying to find out.

3) this is how I was hoping it would work: the user receives the link to the case (view.php?id=XX) in an e-mail. The user clicks the link and the page is displayed. They read the information, click the radio button corresponding to their name and hit OK. The page still displays the same information except I want to add a section that will list "$user read this information on $date at $time" that would display corresponding to the XX in view.php?id=XX.

Thanks for your assistance by the way.

[kevinsequeira]

1. once the user reads the page, dont give them the option to click on the radio button corresponding to their name, cause they may not click their name or might click the wrong name etc
2. this might complicate things but its better if the users log onto the system and in that way you can automatically store their user id in the form and once they read it you can update the database.
3. so here is one way of doing things
   a. the user logs onto the system using a username and pwd
   table : users
   user_id|first_name|last_name|user_name|password|...
   b. creates a conflict -
   table : conflict
   conflict_id|........
   c. have a table that links user_id to case_id
   table : user_case
   id|conflict_id|user_id|has_viewed|date_viewed|....

im not sure if this is what you where looking for, but im assuming you have some way of users logging onto to your system ...

reg
Kevin

[bulldog317]

Actually, I was trying to avoid the whole log in proces which is why I wanted the e-mail sent automatically because I am dealing with approximately 10 individuals who do not want to have to remember another user name and password. I wanted to make it as simple as possible on their end. Click a link in an e-mail, review the information and click the box by their name and they're done. I currently have pretty much the same setup except the user enters information in a Word document, e-mails a link to that document, the person pulls it up, reviews the information and clicks a check box and saves it. I'm running into problems with this because I have people running terminal services who access a certain drive and others who do not access through terminal services who access another drive.

This by the way is all done on our intranet versus the internet so I'm not really worried about someone clicking the wrong name because it will be the same individuals every time and as far as not clicking by their name, they are required by our clients to acknowledge reviewing this information so that definitely will not be a problem.

Would a drop down box work better? Select their name in the drop down box and then click OK.

Also, the user(s) who fill out the initial form are separate from those who receive the e-mails. It is the 10 individuals who would be clicking radio buttons or selecting their name in a drop down box.

So this pretty much cannot be done then?

[kevinsequeira]

no this can be easily done ...

just have a user table with

table : user
user_id|name|conflict_id|date_seen

no need to login etc

on view.php have drop down or radio button at the bottom of page like

<form name="conflict_seen" action="view.php">
<select NAME="user_seen">
<option VALUE="1">user A</option>
<option VALUE="2">user B</option>
<option VALUE="3">user C</option>
.
.
.

</select>
<input type=hidden name="seen_conflict" value="yes">
<input type=hidden name="id" value="<?php print($id);?>">

</form>

on top of view.php or where every you want to display date seen hae this

<?php
 if(isSet($seen_conflict) && isSet($user_seen)){
  //insert into table user the values
  // then display the message to the user 
 }
 ?>

this should you an idea of how to proceed ...

[bulldog317]

A few questions:

user_id|name|conflict_id|date_seen

Would user_id be the same as the value number in the form?
Also, what would be the value of conflict_id?

<input type=hidden name="id" value="<?php print($id);?>">

Is this $id the $id pulled from my table containing the information already posted?

Also, I have include files to connect to my database, etc.

Here is my dbconnect.php file:

<?

include("include/config.php");

$db = mysql_connect("$dbserver", "$dbuser", "$dbpass");
mysql_select_db("$dbname",$db);
  ?>

Here is my config.php file:

<?
  $dbname     = "name"; 
  $dbserver   = "server"; 
  $dbuser     = "user"; 
  $dbpass     = "pass"; 
  $table      = "memos"
  ?>

To add reference to the "user" table, can I just add $table2 = "user" to the config.php file and then reference it in the view.php file?