PHP Mysql Pasing as parameter TextArea more than 1 line

Question

Insert Page

Modify Page

Show Page

I am having an issue to pass a textarea to another page when contains more than one line.

I have 3 pages:

1.-_testInsertText.php = INSERT a new text in Database

2.-_testShowText.php = SELECT the texts from Database and redirect to Modify Page

3.-_testTextModify.php = UPDATE the text passed by _testShowText.php

My structure from my table from Database:

CREATE TABLE `tblTest`
(
   `clmSerie`    int     (11) NOT NULL
  ,`clmTextArea` text         NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

If I insert a text with two lines through _testInsertText.php I am able to display correctly through _testShowText.php

My problem is in redirecting (through href) those records with more than one line to _testTextModify.php page (For 1 line is working fine). It is not redirecting.

Could you please help me?

My code can be found below:

1.-_testInsertText.php

<?php
    $txtEvolucion = '';
    if(isset($_POST['Insert']) && isset($_POST["txtEvolucion"]))
    {
        $txtEvolucion = $_POST["txtEvolucion"];
        require_once('mysqli_connect.php');
        echo "<br>". "txtEvolucion={"     . $txtEvolucion    ."}";
        $query = "INSERT INTO tblTest (clmTextArea) VALUES (?)";
        $stmt = mysqli_prepare($dbc, $query);
        mysqli_stmt_bind_param($stmt, "s", $txtEvolucion);
        mysqli_stmt_execute($stmt);
        $affected_rows = mysqli_stmt_affected_rows($stmt);
        echo $affected_rows;
        if($affected_rows == 1)
        {
            $txtEvolucion = '';
            echo "Inserted";
            mysqli_stmt_close($stmt);
        }
        else
        {
            ini_set('display_errors', 'On');
            mysqli_stmt_close($stmt);
        }
    }
?>
<html>
    <head>
        <title>Insert TextArea</title>
    </head>
    <body>
        <h1>Insert TextArea</h1>
        <div id="divAgenda"> 
        <form id="contact" action="" method="post">
            <fieldset>
                <textarea id="txtEvolucion"  name="txtEvolucion" tabindex="4" cols="90" rows="7" 
                          value="<?= $txtEvolucion ?> "
                ><?= $txtEvolucion ?></textarea><br><br>

                <button name="Insert" type="submit" id="contact-submit" data-submit="...Sending">Insert</button><br>
            </fieldset>
        </form>
    </body>
</html>

2.-_testShowText.php

<?php

    $output = '';
    require_once('mysqli_connect.php');
    $query = mysqli_query($dbc,"SELECT    clmSerie
                                         ,clmTextArea
                                 FROM     tblTest
                                  "
          ) or die('Error to select!: {' . mysqli_error($dbc) . '}');

    $count = mysqli_num_rows($query);

    $output .= '<table border="1" align="left" cellspacing="5" cellpadding="8">
                   <tr><td align="left"><b>MODIFY     </b></td>
                       <td align="left"><b>Id         </b></td>
                       <td align="left"><b>Text Area  </b></td>
                   </tr>';
    while($row = mysqli_fetch_array($query))
    {
        $serie       = $row['clmSerie'];
        $descripcion = utf8_encode($row['clmTextArea']);
        $descripcion = nl2br($descripcion);

        $output .= '<tr><td align="left"><a href="_testTextModify.php?descripcion=' . $descripcion .
                                                                          '&serie=' . $serie       .
                                         '">Modify
                                         </a></td>
                        <td align="left">' .$serie         . '</td>
                        <td align="left">' .$descripcion   . '</td>
                        ';
        $output .= '</tr>';
    }
?>
<html>
    <head>
        <title>Show TextArea</title>
    </head>
    <body>
        <h1>Show TextArea</h1>
        <?php echo $output;?>
    </body>
</html>

3.-_testTextModify.php

<?php
    $txtEvolucion = '';
    $txtEvolucionOld = $_GET['descripcion'];
    $idSerie         = $_GET['serie'];
    echo "<br>". "txtEvolucionOld={"     . $txtEvolucionOld    ."}";
    if(isset($_POST['Modify']) && isset($_POST["txtEvolucion"]))
    {
        $txtEvolucion = $_POST["txtEvolucion"];
        require_once('mysqli_connect.php');
        echo "<br>". "txtEvolucion={"     . $txtEvolucion    ."}";
        $query = "UPDATE  tblTest 
                  SET     clmTextArea  = ?
                  WHERE   clmTextArea  = ?
                    AND   clmSerie     = ?
                    ";
        $stmt = mysqli_prepare($dbc, $query);
        mysqli_stmt_bind_param($stmt, "sss", $txtEvolucion, $txtEvolucionOld, $idSerie);
        mysqli_stmt_execute($stmt);
        $affected_rows = mysqli_stmt_affected_rows($stmt);
        echo $affected_rows;
        if($affected_rows == 1)
        {
            $txtEvolucion = '';
            echo "Modified";
            mysqli_stmt_close($stmt);
        }
        else
        {
            ini_set('display_errors', 'On');
            mysqli_stmt_close($stmt);
        }
    }
?>
<html>
    <head>
        <title>Modify TextArea</title>
    </head>
    <body>
        <h1>Modify TextArea</h1>
        <div id="divAgenda"> 
        <form id="contact" action="" method="post">
            <fieldset>
                <textarea id="txtEvolucion"  name="txtEvolucion" tabindex="4" cols="90" rows="7" 
                          value="<?= $txtEvolucion ?> "
                ><?= $txtEvolucionOld ?></textarea><br><br>

                <button name="Modify" type="submit" id="contact-submit" data-submit="...Sending">Modify</button><br>
            </fieldset>
        </form>
    </body>
</html>

By _redirect_ do you mean the link??? If so, you need `urlencode()` on the vars in the href. — AbraCadaver, Apr 10 '18 at 20:01
Looks like you would need to add a button/link on the show page to go to the modify page. t would be in a form tag, with a hidden input tag with the row key for the item displayed. — Sloan Thrasher, Apr 10 '18 at 20:15
Thank you AbraCadaver, yes I mean with the href link, I put the urlencode() as: But the problem is the MODIFY page will not receive correctly: first line = Text with 3 lines:
Second Line.
Third Line. Also will not take to updated. — felipe, Apr 10 '18 at 20:27
Thank you Sloan Thrasher for your comments, I will try puting a hidden input and see, Also how should I trigger the button (also hidden) ? — felipe, Apr 10 '18 at 20:36

score 0 · Accepted Answer · answered Apr 11 '18 at 18:46

Thanks to comment by Sloan Thrasher, I modified _testTextModify.php and _testShowText.php And now I am passing content to a hidden TextArea instead of a href to the modify page and it is working fine now when it comes with more than one line.

Thank you everyone :)

The new code below:

_testTextModify.php

<?php
    if(isset($_POST['fromTestShowText']))
    {
        $txtEvolucionOld = $_POST['descripcion'];
        $idSerie         = $_POST['serie'];
    }
    if(isset($_POST['Modify']) && isset($_POST["txtEvolucionOld"]))
    {
        $txtEvolucionOld = $_POST["txtEvolucionOld"];
        require_once('mysqli_connect.php');
        $query = "UPDATE  tblTest 
                  SET     clmTextArea  = ?
                  WHERE   clmSerie     = ?
                    ";
        $stmt = mysqli_prepare($dbc, $query);

        mysqli_stmt_bind_param($stmt, "ss", $_POST['txtEvolucionOld'], $_POST['idSerie']);
        mysqli_stmt_execute($stmt);
        $affected_rows = mysqli_stmt_affected_rows($stmt);
        echo "<br>". "affected_rows={"     . $affected_rows    ."}";
        if($affected_rows == 1)
        {
            $txtEvolucionOld = $recibeSerieEvolucion = '';
            echo "Modified";
            mysqli_stmt_close($stmt);
        }
        else
        {
            ini_set('display_errors', 'On');
            mysqli_stmt_close($stmt);
        }
    }
?>
<html>
    <head>
        <title>Modify TextArea</title>
    </head>
    <body>
         <br><a href="_testShowText.php">Show</a>
         <br><a href="_testInsertText.php">Insert</a>
        <h1>Modify TextArea</h1>
        <div id="divAgenda"> 
        <form id="contact" action="" method="post">
            <fieldset>
                <input type="hidden" readonly id="idSerie" name="idSerie" size="2" type="text" maxlength="100" tabindex="3"
                       value="<?= $idSerie ?>"
                ><br>
                <textarea id="txtEvolucionOld"  name="txtEvolucionOld" tabindex="4" cols="90" rows="7" 
                          value="<?= $txtEvolucionOld ?> "
                ><?= $txtEvolucionOld ?></textarea><br><br>

                <button name="Modify" type="submit" id="contact-submit" data-submit="...Sending">Modify</button><br>
            </fieldset>
        </form>
    </body>
</html>

_testShowText.php

<?php

    $output = '';
    require_once('mysqli_connect.php');
    $query = mysqli_query($dbc,"SELECT    clmSerie
                                         ,clmTextArea
                                 FROM     tblTest
                                  "
          ) or die('Error to select!: {' . mysqli_error($dbc) . '}');

    $count = mysqli_num_rows($query);

    $output .= '<table border="1" align="left" cellspacing="5" cellpadding="8">
                   <tr><td align="left"><b>MODIFY     </b></td>
                       <td align="left"><b>Id         </b></td>
                       <td align="left"><b>Text Area  </b></td>
                   </tr>';
    while($row = mysqli_fetch_array($query))
    {
        $serie       = $row['clmSerie'];
        $descripcion = utf8_encode($row['clmTextArea']);
        //$descripcion = nl2br($descripcion);

        $output .= '<tr><td align="left"><form action="_testTextModify.php" method="post">
                                             <button name = "fromTestShowText" type="image" 
                                                     value="Submit">Modify
                                             </button>        
                        </td>
                        <td align="left">' .$serie         . '</td>
                        <td align="left"><input hidden readonly id="serie" name="serie" type="text"
                                                value="'. $serie . '" 
                                         >
                                         <textarea id="descripcion" name="descripcion" cols="50" rows="6"
                                                   value = "'.$descripcion.'" 
                                                   readonly>'. $descripcion .'</textarea>
                        </td>
                                         </form>';
        $output .= '</tr>';
    }
?>
<html>
    <head>
        <title>Show TextArea</title>
    </head>
    <body>
         <br><a href="_testShowText.php">Show</a>
         <br><a href="_testInsertText.php">Insert</a>
        <h1>Show TextArea</h1>
        <?php echo $output;?>
    </body>
</html>

PHP Mysql Pasing as parameter TextArea more than 1 line

1 Answers1