Adding Data Into A MySQL Table

[tomyknoker]

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?

<?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';

?>

[tomyknoker]

I was able to build the query, just not sure where to add it to the page?

$query = "INSERT INTO tbladministrators (firstname, lastname, username, password, superuser) VALUES ($value1, $value2, $value3, $value4, $value5)";
mysql_query($query) or die('Error, insert query failed');

$query = "FLUSH PRIVILEGES";
mysql_query($query) or die('Error, insert query failed'); 

[Twey]

$sqldata = array_map('mysql_real_escape_string', $_GET);
mysql_query("insert into tbladministrators (firstname, lastname, username, password, superuser) values ('{$sqldata['firstname']}', '{$sqldata['lastname']}', '{$sqldata['username']}', '{$sqldata['password']}', '{$sqldata['select']}')" or die('Insert query failed.');

Anywhere after including opendb.php.