Create input fields dynamically with values and column names from database

Question

I create inputs using the information in the columns for example if a field is called about_content it outputs a label of About Content with an input field. This works fine for inserting however I want to use this code similarly to UPDATE and I want to display to users the current value of a field as entered in the database. For example if about_content = Hello World! I want the input value to reflect that. Is there a way of doing this dynamically?

<?php

require('dbc.php');

mysql_select_db($db);
$resultInput = mysql_query("SHOW COLUMNS FROM about WHERE Field NOT IN 
('id', 'created', 'date_modified', 'last_modified', 'update', 'type', 'bodytext') 
AND Field NOT REGEXP '_image'"); // selects only the columns I want

$result = mysql_query("SELECT * FROM about WHERE id=".$_GET['id']); // values I want to put into the values for <input>

while ($row = mysql_fetch_assoc ($result) && $column = mysql_num_rows ($resultInput)) {

    foreach($row as $column => $value){
        echo '<label>'.$column.'<input name="'.$column.'" type="input" value="'.$value.'"></label><br>';
    }
}
?>

Yes currently every part works perfectly separately but the problem is idk how to combine the input w the values — Alex
– Alex, Commented Jul 1, 2012 at 15:25
so write a query to get the values from the database and like you are able to print labels you can print the values in the input box. — Kishore
– Kishore, Commented Jul 1, 2012 at 15:38

alexis · Accepted Answer · 2012-07-01 16:09:02Z

1

See the spot you've marked with an arrow? Instead of the string (1), set value to the appropriate database value you read in $result (not in $resultInput).

Here's how: use mysql_fetch_assoc for your SELECT query, not mysql_fetch_row. There will be only one row, so fetch it before you start generating the form. You'll then have a named array with the row values, and you can grab each field by name and put it in the form.

If you don't understand how to do that, check the php documentation for mysql_fetch_assoc.

And escape your $_GET['id'] like you were told in your last question. You're begging to be pwned!

edited Jul 1, 2012 at 16:09

answered Jul 1, 2012 at 15:28

alexis

50.4k18 gold badges107 silver badges172 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Alex Over a year ago

Thanks I'll worry about security after I get the main function to work... and the (1) was just so ppl could understand maybe what i wanted to do.. I'm still confused how to set the db value to $result, only when i have a while function with $resultInput to get the column names

Somnath Muluk · Accepted Answer · 2012-07-02 05:16:16Z

1

See mysql_fetch_field.

if (mysql_num_rows($result) > 0) {
//loop creates inputs
//make $resultInput object to array.
$i=0;
while ($row = mysql_fetch_assoc($result)) {
    $meta = mysql_fetch_field($result, $i);
    if(in_array($meta->name, $resultInput )){
    echo '<div class="wrapper"><label>' . ucfirst(str_replace('_', ' ',$meta->name)) . 
    '<br><input name="' . $meta->name . 
    '" type="text" class="input" value="$row[$meta->name]"><br></label></div>';
    }
    $i++;
 }
}

edited Jul 2, 2012 at 5:16

answered Jul 1, 2012 at 16:03

Somnath Muluk

58.3k39 gold badges225 silver badges230 bronze badges

6 Comments

Alex Over a year ago

Warning: in_array() expects parameter 2 to be array, resource given in C:\xampp\htdocs\test.php on line 17

Somnath Muluk Over a year ago

I have said to make $resultInput object to array i.e. $resultInput=$resultInput->result()

Alex Over a year ago

Its parsing nothing... It has something to do with the $i when I change the value to for example 2 I get my second field. Also heres my array $resultInput = array("page_header", "sub_header", "content_short", "content");

Somnath Muluk Over a year ago

@Alex: I havn't tested it. You might have understood logic now. I have updated answer. Check it.

Alex Over a year ago

still isnt outputting anything. The logic makes sense, but i cant find the error.

|

user7819803 · Accepted Answer · 2017-04-05 10:14:37Z

<?php
include('db.php');
if (isset($_POST['btn'])) {

    $dcolumn = $_POST['dyncolumns'];
    $dvalue = $_POST['dynfields'];

    $name = $_POST['name'];
    $mobile = $_POST['mobile'];
    $address = $_POST['address'];
    $query = "INSERT into addtable(name,mobile,address)VALUES('" . $name . "','" . $mobile . "','" . $address . "')";
    $result = mysql_query($query)or die(mysql_error());
    $id = mysql_insert_id();


    if ($dcolumn) {
        foreach ($dcolumn as $key => $value) {
            $result1 = "show COLUMNS from addtable like '.$value.'";
            $exists = mysql_query($result1)or die(mysql_error());
            $data = mysql_fetch_assoc($exists);

            if ($data==TRUE) {
                $query = "update addtable set $value = '" . $dvalue[$key] . "' where id=$id";
            } else {
                $query1 = "ALTER TABLE addtable ADD $value varchar(45)";
                $result2 = mysql_query($query1)or die(mysql_error());
                $query = "update addtable set $value = '" . $dvalue[$key] . "' where id=$id";
                $result = mysql_query($query)or die(mysql_error());
            }
        }
    }


}
?>
<script>
    function myFunction() {
        var table = document.getElementById("insert");
        var row = table.insertRow(3);
        var cell1 = row.insertCell(0);
        var cell2 = row.insertCell(1);
        cell1.innerHTML = "<input type='text' name='dyncolumns[]'>";
        cell2.innerHTML = "<input type='text' name='dynfields[]' >";
    }
</script>
<html>
    <body>
        <form name="insert" method="post">

            <table border="2" align="center" id="insert">
                <tr>
                    <td>Name</td><td><input type="text" name="name" /></td>
                </tr>
                <tr>
                    <td>Mobile</td><td><input type="text" name="mobile" maxlength="10"/></td>
                </tr>
                <tr>
                    <td>Address</td><td><input type="text" name="address" /></td>
                </tr>

                <tr>
                    <td colspan="2" align="center"><input type="submit" name="btn" value="submit"></td>
                </tr>

            </table>
            <input type="button" onclick="myFunction()" name="add" value="Add">
            <a href="logout.php">Logout</a>
        </form>
    </body>
</html>

Collectives™ on Stack Overflow

Create input fields dynamically with values and column names from database

3 Answers 3

1 Comment

6 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

6 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related