How do I change the value of textarea by option selected?

Question

I am trying to change the contents of depending on the current option selected.

The getData(page) comes back correctly (onChange) but it just doesn't go over to the variable I get "Fatal error: Call to undefined function getData() in C:\xampp\htdocs\pdimi\admin\editpages.php on line 42"

EDIT: This is how I finished it!

Javascript:

Select form:

Textarea:

    <?php
if (isset($_GET['page'])) {
$sql1 = @mysql_query("SELECT * FROM pages WHERE pageid='".$_GET['page']."'") or die(mysql_error());
$sql2 = @mysql_fetch_array($sql1) or die(mysql_error());

if ($sql1) {
echo $sql2['content'];
}
}

?>

And that is that!

LSerni · Accepted Answer

You cannot execute a Javascript function (client side) from PHP (which runs server side).

Also, you need to connect to a database server with user and password, and select a database. Do not use @, it will only prevent you from seeing errors -- but the errors will be there.

In the PHP file you need to check whether you receive a $_POST['page'], and if so, use that as the ID for the SELECT. You have set up a combo named 'page', so on submit the PHP script will receive the selected value into a variable called $_POST['page'].

Usual warnings apply:

mysql_* functions are discouraged, use mysqli or PDO
if you still use mysql_*, sanitize the input (e.g. $id = (int)$_POST['page'] if it is numeric, or mysql_real_escape_string if it is not, as in your case)

If you want to change the content of textarea when the user changes the combo box, that is a work for AJAX (e.g. jQuery):

bind a function to the change event of the combo box
issue a call to a PHP script server side passing the new ID
the PHP script will output only the content, no other HTML
receive the content in the change-function of the combo and verify success
set $('#textarea')'s value to the content

This way you won't have to reload the page at each combo change. Which reminds me of another thing, when you reload the page now, you have to properly set the combo value: and you can exploit this to dynamically generate the combo, also.

Working example

This file expects to be called 'editpages.php'. PHP elaboration is done (almost) separately from data presentation.







PDIMI - The Personal Development and Internet Marketing Institution








{$row['pagename']}";
        }
        mysql_free_result($exec);

        if (isset($_POST['page_data']))
        {
           $page_data = mysql_real_escape_string($_POST['page_data']);
$query = "INSERT INTO pages ( pageid, content ) VALUES ( '{$page}', '{$page_data}' ) ON DUPLICATE KEY UPDATE content=VALUES(content);";
           if (!mysql_query($query))
                trigger_error("An error occurred: " . mysql_error(), E_USER_ERROR);
        }
        // Anyway, recover its contents (maybe updated)
        $query = "SELECT content FROM pages WHERE pageid='{$page}';";
        $exec  = mysql_query($query);
        // who says we found anything? Maybe this id does not even exist.
        if (mysql_num_rows($exec) > 0)
        {
           // if it does, we're inside a textarea and we directly output the text
           $row = mysql_fetch_array($exec);
           $textarea = $row['content'];
        }
        else
           $textarea = '';
        mysql_free_result($exec);
?>


        
            
                    Edit Your Pages Here
                    
                    
                            
                                    
                                    Please Select The Page You Wish To Edit:
                                    
                                            
                                    
                                    
                                    
                                            <?php print $textarea; ?>

How do I change the value of textarea by option selected?

Answers (2)

Working example

Related Questions