...

View Full Version : Adding Data Into A MySQL Table



tomyknoker
03-31-2007, 04:48 AM
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';

?>

iLLin
03-31-2007, 04:51 AM
Insert into $table (field1,field2) VALUES ($value1, $value2) ...

you get the idea.

tomyknoker
03-31-2007, 04:57 AM
I got that far, but didn't know how to add it to my 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');

iLLin
03-31-2007, 03:09 PM
Post to the same page, when you submit, check for a hidden field and value and then error check and insertinto the db...

Then make your select * query after the insert so you get that latest result too.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum