Adding Data Into A MySQL Table

Hi All,

I can easily pull data about my members using this page, not sure if you can see from the code but I also have textfields, in each column. I want to just be able to type in these and then click Submit/Update and the user get’s added… Anyone have any idea?

[code=php]<?php

/* connect to the mysql database and use different queries for the count of members */

include ‘library/config.php’;
include ‘library/opendb.php’;

//navigation
include(“nav.php”);

$info = mysql_query(“SELECT * FROM tbladministrators”);

echo ‘<table border=”1″ cellpadding=”3″ cellspacing=”1″>
<tr valign=”top”>
<td>First Name</td>
<td>Last Name</td>
<td>Username</td>
<td>Password</td>
<td>Super User</td>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr><tr valign=”top”>
<td><input type=”text” name=”firstname” /></td>
<td><input type=”text” name=”lastname” /></td>
<td><input type=”text” name=”username” /></td>
<td><input type=”text” name=”password” /></td>
<td><select name=”select”>
<option value=”0″>Yes</option>
<option value=”1″>No</option>
</select></td>
<td>&nbsp;</td>
<td>Insert</td>
</tr>’;

if (mysql_num_rows($info) < 1) {
echo ‘<tr valign=”top”>
<td colspan=”4″>There are no members that match the query. Please go back and try again</td>
</tr>’;
}

else {
while ($qry = mysql_fetch_array($info)) {

//create the layout
?>
<link href=”cs_style.css” rel=”stylesheet” type=”text/css” />

<tr valign=”top”>
<td><?php echo $qry[‘firstname’]; ?></td>
<td><?php echo $qry[‘lastname’]; ?></td>
<td><?php echo $qry[‘username’]; ?></td>
<td><?php echo $qry[‘password’]; ?></td>
<td><?php echo $qry[‘superuser’]; ?></td>
<td><a href=”showAdminEdit.php?record_id=<?php echo $qry[‘id’]; ?>”>Edit</a></td>
<td>Delete</td>
</tr>
<?php
}
}

echo ‘</table>’;

include ‘library/closedb.php’;

?>[/code]

Also in #PHP _↴