The Web Design Group

... Making the Web accessible to all.

Welcome Guest ( Log In | Register )

> upload multiple textboxes?
xxkasperxx
post Jun 27 2012, 11:30 AM
Post #1


Serious Coder
*****

Group: Members
Posts: 261
Joined: 30-April 11
Member No.: 14,449



How can i upload more than 1 text box into my database? i want to have it to where they are seperrate fields..

EX: |--------------------------------------------|
| FIELD 1.. so text box 1 goes here |
|--------------------------------------------|
|--------------------------------------------|
| FIELD 2.. so text box 2 goes here |
|--------------------------------------------|

But the user is going to be able to add more text boxes. It is for an announcements page.

So the big question is how do i upload the text-boxes into the correct field?

CODE
<?php
session_start();
include("config.php");
$query = mysql_query("SELECT * FROM home");
$query_row=mysql_fetch_array($query) or die (mysql_error());
if (isset($_SESSION['loggedin'])&&isset($_SESSION['username']))
{
echo "Welcome, " . $_SESSION['username'] . "!" . "<a href='logout.php'> Log-out!</a>";

?>
<!-- EDIT FOR CMS -->

<!DOCTYPE html>
<html>
<head>
<link href="css/main.css" type="text/css" rel="stylesheet" >
    <title>ConroeGoAway</title>
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>

</head>

<body>
    <div id="wrapper">
        <div id="header">
            <ul>
                <li><a href="index.php" class="active">Home</a></li>
                <li><a href="articles.php">Articles</a></li>
                <li><a href="email.php">Email</a></li>
                <li><a href="suggestions.php">Suggestions</a></li>
                <li><a href="#">Blog</a></li>
        </div>
        
        <div id="picture">
            <img src="images/home.png"width="80%">
        </div>
        <div id="bgAnnouncments">
        <form action="" method="POST">
        <?php
        $counter =0;
        while($row = mysql_fetch_array($query)){
        $counter++;
            echo '<textarea id="text.$counter" name="text" rows="15" cols="80" style="width: 100%">';
                echo $row['content'];
            echo '</textarea>';
            
            
    
            }
        ?>
        <input type="submit" value="Submit" name="submit">
        </form>
        </div>
        <footer>
          <p>Copyright © 2012 ConroeGoAway</p>
        </footer>
        
    </div>
</body>

</html>
<?php
}else
{
?>

<!-- REGULAR -->
<!DOCTYPE html>
<html>
<head>
<link href="css/main.css" type="text/css" rel="stylesheet" >
    <title>ConroeGoAway</title>
</head>

<body>
    <div id="wrapper">
        <div id="header">
            <ul>
                <li><a href="index.php" class="active">Home</a></li>
                <li><a href="articles.php">Articles</a></li>
                <li><a href="email.php">Email</a></li>
                <li><a href="suggestions.php">Suggestions</a></li>
                <li><a href="#">Blog</a></li>
        </div>
        
        <div id="picture">
            <img src="images/home.png"width="80%">
        </div>
        <div id="bgAnnouncments">
        <?php
        while($row = mysql_fetch_array($query)){
            echo $row['content'];
            }
        ?>
        </div>
        <footer>
          <p>Copyright © 2012 ConroeGoAway</p>
        </footer>
        
    </div>
</body>

</html>
<?php
}

    if ($_POST)
    {
    /*
        foreach ($text as $text){
        $text = $_POST['text'];
        echo $text;
        echo "data is posted";
        if (isset($text))
        {
            echo 'text is set';
            $result = strip_tags(mysql_query("UPDATE home SET content = '$text'"));
            
            
        }
    }*/
    

        

    }
    
    
    
    


    

?>
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post
 
Reply to this topicStart new topic
Replies
xxkasperxx
post Jul 4 2012, 11:47 AM
Post #2


Serious Coder
*****

Group: Members
Posts: 261
Joined: 30-April 11
Member No.: 14,449



I got it to work!!!!!!!!!!!!!!!!!!!!!

This is my code:

CODE
<?php
session_start();
include("config.php");
$query = mysql_query("SELECT * FROM home");
$query_row=mysql_fetch_array($query) or die (mysql_error());
    
    if($_POST['save'])
    {

            $counter = 1;
            $passorfail = false;
            foreach ( $_POST['mytext'] as $c=> $k)
            {
                while($row = mysql_fetch_array($query)){
                    $tbNum = $row['id'];
                    echo 'ID: '.$tbNum.'<br>';
                    //echo 'input text:'.$k.'<br>';
                    //echo 'exiting while statement<br>';
                    //echo 'K: '.$k.'<br>';
                    $counter++;
                    echo 'Counter:'.$counter.'<br>';
                }
            
                
                
                //echo 'input text: '.implode($_POST['mytext']).'<br>';
                echo '<br>input text:'.$k.'<br>';    // Outputs all text like it should.
                
                //echo '<pre>'; print_r( $row ); echo '</pre>';
                 //echo "its on<br>";
                
                //execute the sql
                // set allow = true where id = $c
                $allow = "false";
                //echo "ID: ".$tbNum."<br>";
                $text = implode($_POST['mytext']);    // ARRAY of text
            
                //echo '<br>they are equal<br>';
                //$text = $row['id'];
                //echo "".$text."";
                //echo "$c";
                
                
                

        
                $result = strip_tags(mysql_query("UPDATE home SET content = '$k' WHERE id=$counter"));
                    
                
                $passorfail = true;
                
                if ($passorfail==true)
                {
                    //echo "passed";
                }
                
                if ($passorfail=false)
                {
                        echo "Error: Please contact levi at leviwurtz2622@yahoo.com. Thank you!";
                }
                
            
                $counter++;
                    echo 'Counter: '.$counter.'<br>';

                
            //}
            }
    }
    
?>


Tell me if there is anything I can fix to increase security, or make it work a little more efficient?
User is offlinePM
Go to the top of the page
Toggle Multi-post QuotingQuote Post

Posts in this topic
xxkasperxx   upload multiple textboxes?   Jun 27 2012, 11:30 AM
xxkasperxx   i have tryed to de-bug this... and it seems like i...   Jun 28 2012, 05:36 PM
Brian Chandler   That's a good start. (Though you should know...   Jun 29 2012, 12:07 AM
xxkasperxx   Because it is being processed on the same page.   Jun 29 2012, 01:50 PM
Christian J   why does the form have no action? If it submits ...   Jun 29 2012, 02:02 PM
xxkasperxx   The text areas are named "text" and have...   Jun 29 2012, 11:54 AM
Christian J   The text areas are named "text" and hav...   Jun 29 2012, 02:29 PM
Brian Chandler   Sorry, I forgot about the empty action thing. I...   Jun 30 2012, 01:44 AM
Christian J   Which way to go is the Really Big Decision of PHP...   Jun 30 2012, 01:43 PM
xxkasperxx   It keeps give me a error message of "Notice:...   Jun 29 2012, 02:51 PM
Christian J   "$text = $_POST["text'....   Jun 29 2012, 03:57 PM
xxkasperxx   So now I get to press submit with no errors, but i...   Jun 29 2012, 04:09 PM
Ephraim F. Moya   How does the user add more text boxes? The only w...   Jun 30 2012, 08:30 AM
Christian J   How does the user add more text boxes? The only ...   Jun 30 2012, 01:44 PM
Ephraim F. Moya   How does the user add more text boxes? The only...   Jun 30 2012, 03:29 PM
xxkasperxx   There is only one user, and there would be a textb...   Jun 30 2012, 12:30 PM
xxkasperxx   so i still havent figured out how to update what i...   Jun 30 2012, 02:47 PM
xxkasperxx   so i still havent figured out how to update what ...   Jun 30 2012, 05:48 PM
Christian J   still havent figured it out My SQL is a bit rust...   Jul 1 2012, 03:14 PM
xxkasperxx   so i tryed to see where stuff was going wrong but ...   Jul 2 2012, 09:03 AM
Christian J   You're mixing up single- and double quote syn...   Jul 2 2012, 12:35 PM
xxkasperxx   okay. But why does it still only take the last tex...   Jul 2 2012, 12:43 PM
Ephraim F. Moya   okay. But why does it still only take the last te...   Jul 2 2012, 01:53 PM
xxkasperxx   the counter is increased each time it goes through...   Jul 2 2012, 04:22 PM
Ephraim F. Moya   the counter is increased each time it goes throug...   Jul 3 2012, 09:58 AM
xxkasperxx   There's something you're not telling us...   Jul 3 2012, 11:14 AM
Ephraim F. Moya   I get this when i use what you have posted. Arra...   Jul 3 2012, 12:50 PM
xxkasperxx   id is starting at 2 because thats what it starts a...   Jul 3 2012, 07:04 PM
Ephraim F. Moya   id is starting at 2 because thats what it starts ...   Jul 3 2012, 07:24 PM
xxkasperxx   it said array because tats waht was put in the DB ...   Jul 3 2012, 08:09 PM
Ephraim F. Moya   it said array because tats waht was put in the DB...   Jul 3 2012, 09:14 PM
xxkasperxx   How do i stop it from over writing? i cant figure ...   Jul 3 2012, 09:23 PM
Ephraim F. Moya   How do i stop it from over writing? i cant figure...   Jul 3 2012, 11:13 PM
xxkasperxx   Because it shows the second text box as the same t...   Jul 4 2012, 01:55 AM
Ephraim F. Moya   Because it shows the second text box as the same ...   Jul 4 2012, 07:59 AM
xxkasperxx   It is not getting the second box's text. Becau...   Jul 4 2012, 10:10 AM
xxkasperxx   So this is what i have so far. Can you please help...   Jul 4 2012, 11:31 AM
xxkasperxx   I got it to work!!!!!!...   Jul 4 2012, 11:47 AM


Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 



- Lo-Fi Version Time is now: 28th March 2024 - 08:08 PM