To transfer the selected record from a list box.
Posted: Fri Feb 14, 2003 7:21 pm
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:
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>