Making new table on a same page, using values entered by user.

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Tekukatetetomo
    New Member
    • May 2011
    • 1

    Making new table on a same page, using values entered by user.

    Hi there.
    I'm a newb in php so, you'll have to forgive me for such a simple question i guess.
    I need to form out a table from the values, users enter in textareas.
    For example
    Code:
    <td><input type="textarea" name="room" id="room" style="width: 25px"></td>
    <td><select id="city" name="city" style="width: 50px; border: 1px solid black;">
            <option value="" selected>
            <?
            	$q = mysql_query('SELECT * FROM city ORDER BY name');
    			for ($i=0; $i<mysql_num_rows($q); $i++)
    				print '<option value="'.mysql_result($q,$i,'name').'">'.mysql_result($q,$i,'name');
    		?>
            </select>&nbsp;&nbsp;
    I need to get all data entered by user into a table using for example:
    Code:
    $sql_query = "INSERT INTO dogovora (roomb, city...) VALUES ( ";
    So the question is... how to create a table below with this values on a same page.
    Thanks!
  • ronverdonk
    Recognized Expert Specialist
    • Jul 2006
    • 4259

    #2
    Enclose the input fields in a form, add a submit button which submits the form to your MySql insertion part en process, like:
    Code:
    //  check submission
    if (isset($_GET['submitted'])) {
        .... check $_GET['city'] and $_GET['room'] for validity
        .... insert values into database
    }
    else {
        // Prompt for values
    ?>
       <form>
       .... your input fields ....
       <input type='submit' name='submitted' value='Submit data' />
       </form>
    <?php
    }

    Comment

    Working...