To transfer the selected record from a list box.

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
minds_gifts
Forum Commoner
Posts: 63
Joined: Mon Feb 10, 2003 4:23 am

To transfer the selected record from a list box.

Post by minds_gifts »

Hello everybody,

Breifly, I've 3 list boxes.Select a record from the first one, click a button, the second list box is filled and select a record now and then click a button, the third list box is filled.Now, select the record, the selected record has to be shown in the text box.But, I also want to show one more field related to this one in another text box.How can i do??

well, the first list box shows the topic names, 2nd one the sub-topic names and the third one the article names.

Now, when i select the article name, the article name and the article content has to be shown in the text boxes.

If its just article name, i know how to do it by java-script but i also need article content to be shown.

Could somebody please help me how should i modify my code and where should i insert the text boxes??

Also, one more question, If i make any changes to the data in the text boxes, i would like to update.How can i do that??

Many thanks.

Here is my code:

Code: Select all

<?php
//DB connection details

?>

<html>
<head>
<title>Update the article information</title>
</head>
<body>    
<?
if (isset($HTTP_POST_VARS ["TOPIC_ID"])) {
    $TOPIC_ID=(int)$HTTP_POST_VARS ["TOPIC_ID"];
    $q=mysql_query("select * from topic where TOPIC_ID=$TOPIC_ID");
    if (!mysql_num_rows($q))
        $TOPIC_ID=0;
} else {
    $TOPIC_ID=0;
}
 

if ($TOPIC_ID && isset($HTTP_POST_VARS ["SUBTOPIC_ID"]) && $HTTP_POST_VARS ["submitname"]!="Change") {
    $SUBTOPIC_ID=(int)$HTTP_POST_VARS ["SUBTOPIC_ID"];
    $q=mysql_query("select * from subtopic where TOPIC_ID=$TOPIC_ID and SUBTOPIC_ID=$SUBTOPIC_ID");
    if (!mysql_num_rows($q))
        $SUBTOPIC_ID=0;
} else {
    $SUBTOPIC_ID=0;
}

if ($SUBTOPIC_ID && isset($HTTP_POST_VARS ["ARTICLE_ID"]) && $HTTP_POST_VARS ["submit"]!="Change") {
    $ARTICLE_ID=(int)$HTTP_POST_VARS ["ARTICLE_ID"];
    $q=mysql_query("select * from articles where ARTICLE_ID=$ARTICLE_ID and SUBTOPIC_ID=$SUBTOPIC_ID");
    if (!mysql_num_rows($q))
        $ARTICLE_ID=0;
} else {
    $ARTICLE_ID=0;
}

// If we got here, we need to display the form...

echo "<html><form method=post action="$PHP_SELF">";
echo "<select name=TOPIC_ID>";
$q=mysql_query("SELECT * FROM topic ORDER BY TOPIC_NAME");
while ($l=mysql_fetch_array($q)) {
     $selected="";
     if ($l["TOPIC_ID"]==$TOPIC_ID)
         $selected="selected=1";
     echo "<option value="".$l["TOPIC_ID"]."" $selected>".$l["TOPIC_NAME"];
}
echo "</select>";
echo " <input type=submit name=submitname value="Change"> ";
echo "<br><br>";
 
echo "<select name=SUBTOPIC_ID>";
if ($TOPIC_ID) {
    $q=mysql_query("SELECT * FROM subtopic WHERE TOPIC_ID=$TOPIC_ID");
    while ($l=mysql_fetch_array($q)) {
        $selected="";
        if ($l["SUBTOPIC_ID"]==$SUBTOPIC_ID)
            $selected="selected=1";
        echo "<option value="".$l["SUBTOPIC_ID"]."" $selected>".$l["SUBTOPIC_NAME"];
    }
} else {
     echo "<option value=0>Please select topic first";
}
echo "</select>";
echo " <input type=submit name=submit value="Change"> ";
echo "<br><br>";

echo "<select name=ARTICLE_ID>";
if ($SUBTOPIC_ID) {
    $q=mysql_query("SELECT * FROM articles WHERE SUBTOPIC_ID=$SUBTOPIC_ID");
    while ($l=mysql_fetch_array($q)) {
        $selected="";
        if ($l["SUBTOPIC_ID"]==$SUBTOPIC_ID)
            $selected="selected=1";
        echo "<option value="".$l["ARTICLE_ID"]."" $selected>".$l["ARTICLE_NAME"];
    }
} else {
     echo "<option value=0>Please select subtopic first";
}
echo "</select>";
echo "<br><br>";

// To get the article name and the article content
//I guess i need to inser the code here which shows me the textboxes and transfer the article name and article content, am m i right?I've tried with this piece of code, but it does'nt seems to be working.

if($ARTICLE_ID) {
    $q=mysql_query("SELECT * FROM articles WHERE ARTICLE_ID=$ARTICLE_ID");
    $row=mysql_fetch_array($q);
    
    echo "<input type="text" name="article_name" value="".$row['article_name'].""><br><br>";
    echo "<input type="text" name="article_content" value="".$row['article_content'].""><br><br>";
      
}
echo "</form>";

</body>
</html>
User avatar
patrikG
DevNet Master
Posts: 4235
Joined: Thu Aug 15, 2002 5:53 am
Location: Sussex, UK

Post by patrikG »

Use the onChange-event for <textarea>:

Code: Select all

<?php
//DB connection details

?>

<html>
<head>
<title>Update the article information</title>
//////////////////////// added code here - start
<script language=javascript>
function yourFunction()
{
yourForm.yourFormField.value=whatever //insert your update-function here
}
</script>
//////////////////////// added code here - end
</head>
<body>   
<?
if (isset($HTTP_POST_VARS ["TOPIC_ID"])) {
    $TOPIC_ID=(int)$HTTP_POST_VARS ["TOPIC_ID"];
    $q=mysql_query("select * from topic where TOPIC_ID=$TOPIC_ID");
    if (!mysql_num_rows($q))
        $TOPIC_ID=0;
} else {
    $TOPIC_ID=0;
}


if ($TOPIC_ID && isset($HTTP_POST_VARS ["SUBTOPIC_ID"]) && $HTTP_POST_VARS ["submitname"]!="Change") {
    $SUBTOPIC_ID=(int)$HTTP_POST_VARS ["SUBTOPIC_ID"];
    $q=mysql_query("select * from subtopic where TOPIC_ID=$TOPIC_ID and SUBTOPIC_ID=$SUBTOPIC_ID");
    if (!mysql_num_rows($q))
        $SUBTOPIC_ID=0;
} else {
    $SUBTOPIC_ID=0;
}

if ($SUBTOPIC_ID && isset($HTTP_POST_VARS ["ARTICLE_ID"]) && $HTTP_POST_VARS ["submit"]!="Change") {
    $ARTICLE_ID=(int)$HTTP_POST_VARS ["ARTICLE_ID"];
    $q=mysql_query("select * from articles where ARTICLE_ID=$ARTICLE_ID and SUBTOPIC_ID=$SUBTOPIC_ID");
    if (!mysql_num_rows($q))
        $ARTICLE_ID=0;
} else {
    $ARTICLE_ID=0;
}

// If we got here, we need to display the form...

echo "<html><form method=post action="$PHP_SELF">";
echo "<select name=TOPIC_ID>";
$q=mysql_query("SELECT * FROM topic ORDER BY TOPIC_NAME");
while ($l=mysql_fetch_array($q)) {
     $selected="";
     if ($l["TOPIC_ID"]==$TOPIC_ID)
         $selected="selected=1";
     echo "<option value="".$l["TOPIC_ID"]."" $selected>".$l["TOPIC_NAME"];
}
echo "</select>";
echo " <input type=submit name=submitname value="Change"> ";
echo "<br><br>";

echo "<select name=SUBTOPIC_ID>";
if ($TOPIC_ID) {
    $q=mysql_query("SELECT * FROM subtopic WHERE TOPIC_ID=$TOPIC_ID");
    while ($l=mysql_fetch_array($q)) {
        $selected="";
        if ($l["SUBTOPIC_ID"]==$SUBTOPIC_ID)
            $selected="selected=1";
        echo "<option value="".$l["SUBTOPIC_ID"]."" $selected>".$l["SUBTOPIC_NAME"];
    }
} else {
     echo "<option value=0>Please select topic first";
}
echo "</select>";
echo " <input type=submit name=submit value="Change"> ";
echo "<br><br>";

echo "<select name=ARTICLE_ID>";
if ($SUBTOPIC_ID) {
    $q=mysql_query("SELECT * FROM articles WHERE SUBTOPIC_ID=$SUBTOPIC_ID");
    while ($l=mysql_fetch_array($q)) {
        $selected="";
        if ($l["SUBTOPIC_ID"]==$SUBTOPIC_ID)
            $selected="selected=1";
        echo "<option value="".$l["ARTICLE_ID"]."" $selected>".$l["ARTICLE_NAME"];
    }
} else {
     echo "<option value=0>Please select subtopic first";
}
echo "</select>";
echo "<br><br>";

//////////////////////// added code here - start

<textarea name=yourTestarea col=50 row=10 onChange="yourFunction()"></textarea> //will call javascript: yourFunction() when content of textarea is changed.

//////////////////////// added code here - end

if($ARTICLE_ID) {
    $q=mysql_query("SELECT * FROM articles WHERE ARTICLE_ID=$ARTICLE_ID");
    $row=mysql_fetch_array($q);
   
    echo "<input type="text" name="article_name" value="".$row['article_name'].""><br><br>";
    echo "<input type="text" name="article_content" value="".$row['article_content'].""><br><br>";
     
}
echo "</form>";

</body>
</html>
Post Reply